Changeset 461 for trunk/app/config/sql/postgresql/visitors.sql

Timestamp:

05/08/08 11:43:23 (8 months ago)

Author:

aarkerio

Message:

Forums and topics improveds

Files:

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

trunk/app/config/sql/postgresql/visitors.sql

@@ -2 +2 @@
   id serial PRIMARY KEY,
   user_id   int NOT NULL REFERENCES users(id) ON DELETE CASCADE,
-  topic_id int NOT NULL REFERENCES topics(id) ON DELETE CASCADE,
-  UNIQUE (user_id, topic_id)  -- constraint
+  topic_id int NOT NULL REFERENCES topics(id) ON DELETE CASCADE
 ); 
-
-