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

Timestamp:

04/05/08 12:52:08 (9 months ago)

Author:

aarkerio

Message:

vClassrooms ans tests fixed

Files:

• trunk/app/config/sql/karamelo_postgres.sql (modified) (2 diffs)

trunk/app/config/sql/karamelo_postgres.sql

@@ -573 +573 @@
 );
 --HABTM
-CREATE TABLE "vclassrooms_treasures" (
+CREATE TABLE "treasures_vclassrooms" (
+  "treasure_id"   int NOT NULL REFERENCES treasures(id),
   "vclassroom_id" int NOT NULL REFERENCES vclassrooms(id),
-  "treasure_id"   int NOT NULL REFERENCES treasures(id),
   PRIMARY KEY  ("vclassroom_id", "treasure_id")
 );
@@ -590 +590 @@
 
 --HABTM
-CREATE TABLE "vclassrooms_tests" (
-  "vclassroom_id" int NOT NULL REFERENCES vclassrooms(id),
-  "test_id"   int NOT NULL REFERENCES tests(id),
-  PRIMARY KEY  ("vclassroom_id", "test_id")
+CREATE TABLE "tests_vclassrooms" (
+ "test_id" int NOT NULL REFERENCES tests(id),
+ "vclassroom_id" int NOT NULL REFERENCES vclassrooms(id),
+  PRIMARY KEY  ("test_id", "vclassroom_id")
 );