1 Various SQL fixes for 0.7.
2 --- roundcubemail/SQL/mysql.update.sql (revision 5468)
3 +++ roundcubemail/SQL/mysql.update.sql (revision 5618)
6 -- Updates from version 0.6
8 +/*!40014 SET FOREIGN_KEY_CHECKS=0 */;
10 ALTER TABLE `users` CHANGE `alias` `alias` varchar(128) BINARY NOT NULL;
12 ) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;
14 +/*!40014 SET FOREIGN_KEY_CHECKS=1 */;
16 -- Updates from version 0.7-beta
18 --- roundcubemail/SQL/sqlite.update.sql (revision 5468)
19 +++ roundcubemail/SQL/sqlite.update.sql (revision 5615)
23 -CREATE UNIQUE INDEX ix_searches_user_type_name (user_id, type, name);
24 +CREATE UNIQUE INDEX ix_searches_user_type_name ON searches (user_id, type, name);
27 --- roundcubemail/SQL/sqlite.initial.sql (revision 5460)
28 +++ roundcubemail/SQL/sqlite.initial.sql (revision 5615)
32 -CREATE UNIQUE INDEX ix_searches_user_type_name (user_id, type, name);
33 +CREATE UNIQUE INDEX ix_searches_user_type_name ON searches (user_id, type, name);
35 -- --------------------------------------------------------
36 --- roundcubemail/SQL/postgres.update.sql (revision 5468)
37 +++ roundcubemail/SQL/postgres.update.sql (revision 5627)
41 -DROP SEQUENCE messages_ids;
42 +DROP SEQUENCE message_ids;