Mercurial > hg > rc2

comparison SQL/mysql/2011121400.sql @ 0:4681f974d28b

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
vanilla 1.3.3 distro, I hope
author Charlie Root
date Thu, 04 Jan 2018 15:52:31 -0500
parents
children
comparison
equal deleted inserted replaced
-1:000000000000 0:4681f974d28b
1 -- Updates from version 0.7
2
3 /*!40014 SET FOREIGN_KEY_CHECKS=0 */;
4
5 ALTER TABLE `contacts` DROP FOREIGN KEY `user_id_fk_contacts`;
6 ALTER TABLE `contacts` DROP INDEX `user_contacts_index`;
7 ALTER TABLE `contacts` MODIFY `email` text NOT NULL;
8 ALTER TABLE `contacts` ADD INDEX `user_contacts_index` (`user_id`,`del`);
9 ALTER TABLE `contacts` ADD CONSTRAINT `user_id_fk_contacts` FOREIGN KEY (`user_id`)
10 REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;
11
12 ALTER TABLE `cache` ALTER `user_id` DROP DEFAULT;
13 ALTER TABLE `cache_index` ALTER `user_id` DROP DEFAULT;
14 ALTER TABLE `cache_thread` ALTER `user_id` DROP DEFAULT;
15 ALTER TABLE `cache_messages` ALTER `user_id` DROP DEFAULT;
16 ALTER TABLE `contacts` ALTER `user_id` DROP DEFAULT;
17 ALTER TABLE `contactgroups` ALTER `user_id` DROP DEFAULT;
18 ALTER TABLE `contactgroupmembers` ALTER `contact_id` DROP DEFAULT;
19 ALTER TABLE `identities` ALTER `user_id` DROP DEFAULT;
20 ALTER TABLE `searches` ALTER `user_id` DROP DEFAULT;
21
22 /*!40014 SET FOREIGN_KEY_CHECKS=1 */;