Changeset 43a42dc in github

Timestamp:

Mar 18, 2007 1:11:43 PM (6 years ago)

Author:

thomascube <thomas@…>

Branches:

master, HEAD, courier-fix, dev-browser-capabilities, pdo, release-0.6, release-0.7, release-0.8

Children:

86958f7

Parents:

87b280e

Message:

Use user_id for unique key in messages table (closes #1484074)

Location:

SQL

Files:

• mysql.initial.sql (modified) (1 diff)
• mysql.update.sql (modified) (1 diff)
• mysql5.initial.sql (modified) (1 diff)
• postgres.initial.sql (modified) (1 diff)
• postgres.update.sql (modified) (1 diff)

SQL/mysql.initial.sql

@@ -123 +123 @@
   KEY `idx` (`idx`),
   KEY `uid` (`uid`),
-  UNIQUE `uniqueness` (`cache_key`, `uid`)
+  UNIQUE `uniqueness` (`user_id`, `cache_key`, `uid`)
 );
 

SQL/mysql.update.sql

@@ -6 +6 @@
   DROP INDEX `cache_key`,
   ADD `structure` TEXT,
-  ADD UNIQUE `uniqueness` (`cache_key`, `uid`);
+  ADD UNIQUE `uniqueness` (`user_id`, `cache_key`, `uid`);
 
 ALTER TABLE `identities`

SQL/mysql5.initial.sql

@@ -56 +56 @@
  INDEX `idx`(`idx`),
  INDEX `uid`(`uid`),
- UNIQUE `uniqueness` (`cache_key`, `uid`),
+ UNIQUE `uniqueness` (`user_id`, `cache_key`, `uid`),
  CONSTRAINT `User_ID_FK_messages` FOREIGN KEY (`user_id`)
    REFERENCES `users`(`user_id`)

SQL/postgres.initial.sql

@@ -168 +168 @@
 );
 
-ALTER TABLE "messages" ADD UNIQUE (cache_key, uid);
+ALTER TABLE "messages" ADD UNIQUE (user_id, cache_key, uid);

SQL/postgres.update.sql

@@ -4 +4 @@
 ALTER TABLE "messages" DROP body;
 ALTER TABLE "messages" ADD structure TEXT;
-ALTER TABLE "messages" ADD UNIQUE (cache_key, uid);
+ALTER TABLE "messages" ADD UNIQUE (user_id, cache_key, uid);
 
 ALTER TABLE "identities" ADD html_signature integer DEFAULT 0 NOT NULL;