Changeset 445 for trunk/app/config

Show
Ignore:
Timestamp:
05/02/08 13:22:37 (7 months ago)
Author:
aarkerio
Message:

New hobbit edublog style

Files:
1 modified

Legend:

Unmodified
Added
Removed

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

    r444 r445  
    11CREATE TABLE participations (  -- tests student results 
    2    id serial NOT NULL UNIQUE, 
     2   id serial NOT NULL PRIMARY KEY, 
    33   user_id int NOT NULL REFERENCES users(id) ON DELETE CASCADE, 
    4    points smallint NOT NULL DEFAULT 1, 
     4   points smallint NOT NULL DEFAULT 0, 
     5   participation text NOT NULL, 
    56   forum_id int NOT NULL REFERENCES forums(id) ON DELETE CASCADE, 
    6    vclassroom_id int NOT NULL REFERENCES vclassrooms(id) ON DELETE CASCADE, 
    7    PRIMARY KEY (user_id, forum_id, vclassroom_id) 
     7   vclassroom_id int NOT NULL REFERENCES vclassrooms(id) ON DELETE CASCADE 
    88); 
    99-- Test model tables ends