Changeset 468 for trunk/app/config

Show
Ignore:
Timestamp:
05/09/08 00:41:41 (7 months ago)
Author:
aarkerio
Message:

Forums and topics improveds

Files:
1 modified

Legend:

Unmodified
Added
Removed

  • trunk/app/config/sql/postgresql/result_webquests.sql

    r444 r468  
    11CREATE TABLE result_webquests (  -- webquests student results 
    22   id serial NOT NULL UNIQUE, 
     3   answer text NOT NULL, 
    34   user_id int NOT NULL REFERENCES users(id) ON DELETE CASCADE, 
    45   points smallint NOT NULL, 
    5    webquest_id int NOT NULL REFERENCES tests(id) ON DELETE CASCADE, 
     6   webquest_id int NOT NULL REFERENCES webquests(id) ON DELETE CASCADE, 
    67   vclassroom_id int NOT NULL REFERENCES vclassrooms(id) ON DELETE CASCADE, 
    78   PRIMARY KEY (user_id, webquest_id, vclassroom_id)