| commit | author | age | ||
| b7e7c8 | 1 | -- Updates from version 0.7 |
| AM | 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 */; | |
