diff options
author | alecpl <alec@alec.pl> | 2011-12-15 11:13:44 +0400 |
---|---|---|
committer | alecpl <alec@alec.pl> | 2011-12-15 11:13:44 +0400 |
commit | d2d94ac6df0b8c07f0b36da71b1e4b14d6d1e8ab (patch) | |
tree | 48cdc25089c2439227a2db5c75a8287fa374167e /SQL | |
parent | b540ed15a30cd9379df7feb62b0ae81a8a111e9c (diff) |
- Disable FOREIGN_KEY_CHECKS in update from 0.6 (#1488209)
Diffstat (limited to 'SQL')
-rw-r--r-- | SQL/mysql.update.sql | 4 |
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; |