| | |
| | | TRUNCATE TABLE `messages`; |
| | | TRUNCATE TABLE `cache`; |
| | | |
| | | -- Updates from version 0.6-stable |
| | | -- Updates from version 0.6 |
| | | |
| | | ALTER TABLE `users` CHANGE `alias` `alias` varchar(128) BINARY NOT NULL; |
| | | ALTER TABLE `users` CHANGE `username` `username` varchar(128) BINARY NOT NULL; |
| | |
| | | INDEX `changed_index` (`changed`), |
| | | PRIMARY KEY (`user_id`, `mailbox`, `uid`) |
| | | ) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */; |
| | | |
| | | -- Updates from version 0.7-beta |
| | | |
| | | ALTER TABLE `session` CHANGE `sess_id` `sess_id` varchar(128) NOT NULL; |