Changeset 457 for trunk/app/config

Timestamp:

05/05/08 20:56:59 (7 months ago)

Author:

aarkerio

Message:

Users improved

Files:

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

trunk/app/config/sql/postgresql/users_vclassrooms.sql

@@ -1 +1 @@
 CREATE TABLE users_vclassrooms (
+  "id" serial PRIMARY KEY,
   "user_id" int REFERENCES users(id) NOT NULL,
   "vclassroom_id" int REFERENCES vclassrooms(id) NOT NULL,
-   PRIMARY KEY  ("user_id", "vclassroom_id")
+   UNIQUE ("user_id", "vclassroom_id")
 );
-
-