Changeset 570 for trunk/app/config

Show
Ignore:
Timestamp:
05/27/08 19:33:12 (6 months ago)
Author:
aarkerio
Message:

Update record student

Location:
trunk/app/config/sql/postgresql
Files:
3 modified

Legend:

Unmodified
Added
Removed

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

    r502 r570  
    55   treasure_id int NOT NULL REFERENCES treasures (id) ON DELETE CASCADE, 
    66   vclassroom_id int NOT NULL REFERENCES vclassrooms(id) ON DELETE CASCADE, 
     7   created timestamp(0) with time zone DEFAULT now() NOT NULL, 
    78   PRIMARY KEY (user_id, treasure_id, vclassroom_id) 
    89); 

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

    r468 r570  
    66   webquest_id int NOT NULL REFERENCES webquests(id) ON DELETE CASCADE, 
    77   vclassroom_id int NOT NULL REFERENCES vclassrooms(id) ON DELETE CASCADE, 
     8   created timestamp(0) with time zone DEFAULT now() NOT NULL, 
    89   PRIMARY KEY (user_id, webquest_id, vclassroom_id) 
    910); 

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

    r436 r570  
    55   test_id int NOT NULL REFERENCES tests(id) ON DELETE CASCADE, 
    66   vclassroom_id int NOT NULL REFERENCES vclassrooms(id) ON DELETE CASCADE, 
     7   created timestamp(0) with time zone DEFAULT now() NOT NULL, 
    78   percentage decimal NOT NULL, 
    89   PRIMARY KEY (user_id, test_id, vclassroom_id)