Changeset 429 for trunk/app/config

Show
Ignore:
Timestamp:
04/24/08 21:33:43 (7 months ago)
Author:
aarkerio
Message:

Tests and answers

Files:
1 modified

Legend:

Unmodified
Added
Removed

  • trunk/app/config/sql/karamelo_postgres.sql

    r418 r429  
    589589   results smallint NOT NULL, 
    590590   test_id int NOT NULL REFERENCES tests(id) ON DELETE CASCADE, 
    591    PRIMARY KEY (user_id, test_id) 
     591   vclassroom_id int NOT NULL REFERENCES vclassrooms(id) ON DELETE CASCADE, 
     592   PRIMARY KEY (user_id, test_id, vclassroom_id) 
    592593); 
    593594-- Test model tables ends 
    594595 
    595  
    596 -- Share it! 
     596-- Share stuff (docs an5Dd multimedia) with your students 
    597597CREATE TABLE shares ( 
    598598id serial PRIMARY KEY,