Use user_id for unique key in messages table (closes #1484074)
| | |
| | | KEY `user_id` (`user_id`), |
| | | KEY `idx` (`idx`), |
| | | KEY `uid` (`uid`), |
| | | UNIQUE `uniqueness` (`cache_key`, `uid`) |
| | | UNIQUE `uniqueness` (`user_id`, `cache_key`, `uid`) |
| | | ); |
| | | |
| | | |
| | |
| | | DROP `body`, |
| | | DROP INDEX `cache_key`, |
| | | ADD `structure` TEXT, |
| | | ADD UNIQUE `uniqueness` (`cache_key`, `uid`); |
| | | ADD UNIQUE `uniqueness` (`user_id`, `cache_key`, `uid`); |
| | | |
| | | ALTER TABLE `identities` |
| | | ADD `html_signature` tinyint(1) default 0 NOT NULL; |
| | |
| | | PRIMARY KEY(`message_id`), |
| | | 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`) |
| | | ON DELETE CASCADE |
| | |
| | | structure text |
| | | ); |
| | | |
| | | ALTER TABLE "messages" ADD UNIQUE (cache_key, uid); |
| | | ALTER TABLE "messages" ADD UNIQUE (user_id, cache_key, uid); |
| | |
| | | |
| | | 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; |
| | | |