Changeset 445 for trunk/app/config/sql/postgresql/participations.sql

Timestamp:

05/02/08 13:22:37 (8 months ago)

Author:

aarkerio

Message:

New hobbit edublog style

Files:

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

trunk/app/config/sql/postgresql/participations.sql

@@ -1 +1 @@
 CREATE TABLE participations (  -- tests student results
-   id serial NOT NULL UNIQUE,
+   id serial NOT NULL PRIMARY KEY,
    user_id int NOT NULL REFERENCES users(id) ON DELETE CASCADE,
-   points smallint NOT NULL DEFAULT 1,
+   points smallint NOT NULL DEFAULT 0,
+   participation text NOT NULL,
    forum_id int NOT NULL REFERENCES forums(id) ON DELETE CASCADE,
-   vclassroom_id int NOT NULL REFERENCES vclassrooms(id) ON DELETE CASCADE,
-   PRIMARY KEY (user_id, forum_id, vclassroom_id)
+   vclassroom_id int NOT NULL REFERENCES vclassrooms(id) ON DELETE CASCADE
 );
 -- Test model tables ends