diff options
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; |