X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=debian%2Fsql%2Fmysql%2F0.5-1;h=193896f1df3f7798a083488843eafdb5e2cfeb52;hb=5d44896a1af845d9b9fc0ab9e5b3708e94233496;hp=9d7f7586c59bb985f1607b8fe2685f47368ed951;hpb=c3d1c4ab326e66c51b4ceca5d0f903528dac71cc;p=roundcube.git

diff --git a/debian/sql/mysql/0.5-1 b/debian/sql/mysql/0.5-1
index 9d7f758..193896f 100644
--- a/debian/sql/mysql/0.5-1
+++ b/debian/sql/mysql/0.5-1
@@ -11,14 +11,14 @@ ALTER TABLE `identities` ENGINE=InnoDB;
 
 TRUNCATE `messages`;
 
-ALTER TABLE `messages`
-    ADD INDEX `index_index` (`user_id`, `cache_key`, `idx`);
+-- ALTER TABLE `messages`
+--    ADD INDEX `index_index` (`user_id`, `cache_key`, `idx`);
 
-ALTER TABLE `session` 
-    CHANGE `vars` `vars` MEDIUMTEXT NOT NULL;
+-- ALTER TABLE `session` 
+--    CHANGE `vars` `vars` MEDIUMTEXT NOT NULL;
 
-ALTER TABLE `contacts`
-    ADD INDEX `user_contacts_index` (`user_id`,`email`);
+-- ALTER TABLE `contacts`
+--    ADD INDEX `user_contacts_index` (`user_id`,`email`);
 
 -- Updates from version 0.3.1
 -- WARNING: Make sure that all tables are using InnoDB engine!!!
@@ -45,8 +45,8 @@ ALTER TABLE `contacts` ALTER `name` SET DEFAULT '';
 ALTER TABLE `contacts` ALTER `firstname` SET DEFAULT '';
 ALTER TABLE `contacts` ALTER `surname` SET DEFAULT '';
 
-ALTER TABLE `identities` ADD INDEX `user_identities_index` (`user_id`, `del`);
-ALTER TABLE `identities` ADD `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00' AFTER `user_id`;
+-- ALTER TABLE `identities` ADD INDEX `user_identities_index` (`user_id`, `del`);
+-- ALTER TABLE `identities` ADD `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00' AFTER `user_id`;
 
 CREATE TABLE `contactgroups` (
   `contactgroup_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,