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

Timestamp:

04/05/08 13:20:54 (9 months ago)

Author:

aarkerio

Message:

Vclassrooms improved

Files:

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

trunk/app/config/sql/karamelo_postgres.sql

@@ -346 +346 @@
 );
 
-CREATE TABLE vclassrooms_users (
-  "vclassroom_id" int REFERENCES vclassrooms(id) NOT NULL DEFAULT 0,
-  "user_id" int REFERENCES users(id) NOT NULL DEFAULT 0
-);
-
-CREATE UNIQUE INDEX vclasroom_id_user_id_key on vclassrooms_users(vclassroom_id, user_id);
+CREATE TABLE users_vclassrooms (
+  "user_id" int REFERENCES users(id) NOT NULL,
+  "vclassroom_id" int REFERENCES vclassrooms(id) NOT NULL,
+   PRIMARY KEY  ("user_id", "vclassroom_id")
+);
 
 -- Categories users blogs