Changeset 416 for trunk/app/config

Show
Ignore:
Timestamp:
04/21/08 13:05:04 (7 months ago)
Author:
aarkerio
Message:

Discussions fixed

Files:
1 modified

Legend:

Unmodified
Added
Removed

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

    r409 r416  
    522522--HABTM 
    523523CREATE TABLE "vclassrooms_webquests" ( 
    524   "vclassroom_id" int NOT NULL REFERENCES vclassrooms(id), 
    525   "webquest_id"   int NOT NULL REFERENCES webquests(id), 
    526   PRIMARY KEY  ("vclassroom_id", "webquest_id") 
    527 ); 
     524 "id" serial PRIMARY KEY, 
     525 "vclassroom_id" int NOT NULL REFERENCES vclassrooms(id) ON DELETE CASCADE, 
     526 "webquest_id" int NOT NULL REFERENCES webquests(id) ON DELETE CASCADE, 
     527  UNIQUE ("vclassroom_id", "webquest_id") 
     528); 
     529 
     530 
    528531-- Treasure hunts         http://www.gma.org/surfing/imaging/treasure.html 
    529532CREATE TABLE "treasures" (