Changeset 438 for trunk/app/config/sql/postgresql/treasures_vclassrooms.sql

Timestamp:

04/28/08 17:15:07 (9 months ago)

Author:

aarkerio

Message:

Treasures changes

Files:

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

trunk/app/config/sql/postgresql/treasures_vclassrooms.sql

@@ -1 +1 @@
 --HABTM
 CREATE TABLE "treasures_vclassrooms" (
-  "treasure_id"   int NOT NULL REFERENCES treasures(id),
-  "vclassroom_id" int NOT NULL REFERENCES vclassrooms(id),
-  PRIMARY KEY  ("vclassroom_id", "treasure_id")
+ "id" serial PRIMARY KEY,
+ "treasure_id" int NOT NULL REFERENCES treasures(id) ON DELETE CASCADE,
+ "vclassroom_id" int NOT NULL REFERENCES vclassrooms(id) ON DELETE CASCADE,
+  UNIQUE  ("treasure_id", "vclassroom_id")
 );