summaryrefslogtreecommitdiff
path: root/plugins/libkolab/SQL/mysql/2015021000.sql
blob: 97b9c1e82cd39d81ab8b3f8b22f8300a942bffb3 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
-- 2014032700.sql equivalent from git master
ALTER TABLE `kolab_cache_configuration` ADD INDEX `configuration_uid2msguid` (`folder_id`, `uid`, `msguid`);
ALTER TABLE `kolab_cache_contact` ADD INDEX `contact_uid2msguid` (`folder_id`, `uid`, `msguid`);
ALTER TABLE `kolab_cache_event` ADD INDEX `event_uid2msguid` (`folder_id`, `uid`, `msguid`);
ALTER TABLE `kolab_cache_task` ADD INDEX `task_uid2msguid` (`folder_id`, `uid`, `msguid`);
ALTER TABLE `kolab_cache_journal` ADD INDEX `journal_uid2msguid` (`folder_id`, `uid`, `msguid`);
ALTER TABLE `kolab_cache_note` ADD INDEX `note_uid2msguid` (`folder_id`, `uid`, `msguid`);
ALTER TABLE `kolab_cache_file` ADD INDEX `file_uid2msguid` (`folder_id`, `uid`, `msguid`);
ALTER TABLE `kolab_cache_freebusy` ADD INDEX `freebusy_uid2msguid` (`folder_id`, `uid`, `msguid`);

-- 2015011600.sql equivalent from git master
ALTER TABLE `kolab_cache_contact` MODIFY `tags` text NOT NULL;
ALTER TABLE `kolab_cache_event` MODIFY `tags` text NOT NULL;
ALTER TABLE `kolab_cache_task` MODIFY `tags` text NOT NULL;
ALTER TABLE `kolab_cache_journal` MODIFY `tags` text NOT NULL;
ALTER TABLE `kolab_cache_note` MODIFY `tags` text NOT NULL;
ALTER TABLE `kolab_cache_file` MODIFY `tags` text NOT NULL;
ALTER TABLE `kolab_cache_configuration` MODIFY `tags` text NOT NULL;
ALTER TABLE `kolab_cache_freebusy` MODIFY `tags` text NOT NULL;