Also fixes MySQL upgrade file and SQLite regular file.

[roundcube.git] / debian / sql / mysql / 0.7-1

diff --git a/debian/sql/mysql/0.7-1 b/debian/sql/mysql/0.7-1
index bf994983f08912401385cbe62b96894dfb7399db..093ced4c9acdd3a80fff945883ec1ca1f93fc732 100644 (file)
--- a/debian/sql/mysql/0.7-1
+++ b/debian/sql/mysql/0.7-1
@@ -1,5 +1,7 @@
 -- Updates from version 0.6
 
+/*!40014 SET FOREIGN_KEY_CHECKS=0 */;
+
 ALTER TABLE `users` CHANGE `alias` `alias` varchar(128) BINARY NOT NULL;
 ALTER TABLE `users` CHANGE `username` `username` varchar(128) BINARY NOT NULL;
 
@@ -62,6 +64,8 @@ CREATE TABLE `cache_messages` (
  PRIMARY KEY (`user_id`, `mailbox`, `uid`)
 ) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;
 
+/*!40014 SET FOREIGN_KEY_CHECKS=1 */;
+
 -- Updates from version 0.7-beta
 
 ALTER TABLE `session` CHANGE `sess_id` `sess_id` varchar(128) NOT NULL;