summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoralecpl <alec@alec.pl>2011-12-15 07:13:44 +0000
committeralecpl <alec@alec.pl>2011-12-15 07:13:44 +0000
commitd2d94ac6df0b8c07f0b36da71b1e4b14d6d1e8ab (patch)
tree48cdc25089c2439227a2db5c75a8287fa374167e
parentb540ed15a30cd9379df7feb62b0ae81a8a111e9c (diff)
- Disable FOREIGN_KEY_CHECKS in update from 0.6 (#1488209)
-rw-r--r--SQL/mysql.update.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/SQL/mysql.update.sql b/SQL/mysql.update.sql
index 07617316b..f4a61bc30 100644
--- a/SQL/mysql.update.sql
+++ b/SQL/mysql.update.sql
@@ -147,6 +147,8 @@ TRUNCATE TABLE `cache`;
-- 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;
@@ -209,6 +211,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;