Changeset 429 for trunk/app/config/sql/karamelo_postgres.sql

Timestamp:

04/24/08 21:33:43 (9 months ago)

Author:

aarkerio

Message:

Tests and answers

Files:

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

trunk/app/config/sql/karamelo_postgres.sql

@@ -589 +589 @@
    results smallint NOT NULL,
    test_id int NOT NULL REFERENCES tests(id) ON DELETE CASCADE,
-   PRIMARY KEY (user_id, test_id)
+   vclassroom_id int NOT NULL REFERENCES vclassrooms(id) ON DELETE CASCADE,
+   PRIMARY KEY (user_id, test_id, vclassroom_id)
 );
 -- Test model tables ends
 
-
--- Share it!
+-- Share stuff (docs an5Dd multimedia) with your students
 CREATE TABLE shares (
 id serial PRIMARY KEY,