Changeset 416 for trunk/app/config/sql/karamelo_postgres.sql

Timestamp:

04/21/08 13:05:04 (9 months ago)

Author:

aarkerio

Message:

Discussions fixed

Files:

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

trunk/app/config/sql/karamelo_postgres.sql

@@ -522 +522 @@
 --HABTM
 CREATE TABLE "vclassrooms_webquests" (
-  "vclassroom_id" int NOT NULL REFERENCES vclassrooms(id),
-  "webquest_id"   int NOT NULL REFERENCES webquests(id),
-  PRIMARY KEY  ("vclassroom_id", "webquest_id")
-);
+ "id" serial PRIMARY KEY,
+ "vclassroom_id" int NOT NULL REFERENCES vclassrooms(id) ON DELETE CASCADE,
+ "webquest_id" int NOT NULL REFERENCES webquests(id) ON DELETE CASCADE,
+  UNIQUE ("vclassroom_id", "webquest_id")
+);
+
+
 -- Treasure hunts         http://www.gma.org/surfing/imaging/treasure.html
 CREATE TABLE "treasures" (