Changeset 468 for trunk/app/config/sql/postgresql/result_webquests.sql

Timestamp:

05/09/08 00:41:41 (8 months ago)

Author:

aarkerio

Message:

Forums and topics improveds

Files:

• trunk/app/config/sql/postgresql/result_webquests.sql (modified) (1 diff)

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

@@ -1 +1 @@
 CREATE TABLE result_webquests (  -- webquests student results
    id serial NOT NULL UNIQUE,
+   answer text NOT NULL,
    user_id int NOT NULL REFERENCES users(id) ON DELETE CASCADE,
    points smallint NOT NULL,
-   webquest_id int NOT NULL REFERENCES tests(id) ON DELETE CASCADE,
+   webquest_id int NOT NULL REFERENCES webquests(id) ON DELETE CASCADE,
    vclassroom_id int NOT NULL REFERENCES vclassrooms(id) ON DELETE CASCADE,
    PRIMARY KEY (user_id, webquest_id, vclassroom_id)