TRUNCATE `messages`;
-ALTER TABLE `messages`
- ADD INDEX `index_index` (`user_id`, `cache_key`, `idx`);
+-- ALTER TABLE `messages`
+-- ADD INDEX `index_index` (`user_id`, `cache_key`, `idx`);
-ALTER TABLE `session`
- CHANGE `vars` `vars` MEDIUMTEXT NOT NULL;
+-- ALTER TABLE `session`
+-- CHANGE `vars` `vars` MEDIUMTEXT NOT NULL;
-ALTER TABLE `contacts`
- ADD INDEX `user_contacts_index` (`user_id`,`email`);
+-- ALTER TABLE `contacts`
+-- ADD INDEX `user_contacts_index` (`user_id`,`email`);
-- Updates from version 0.3.1
-- WARNING: Make sure that all tables are using InnoDB engine!!!
ALTER TABLE `contacts` ALTER `firstname` SET DEFAULT '';
ALTER TABLE `contacts` ALTER `surname` SET DEFAULT '';
-ALTER TABLE `identities` ADD INDEX `user_identities_index` (`user_id`, `del`);
-ALTER TABLE `identities` ADD `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00' AFTER `user_id`;
+-- ALTER TABLE `identities` ADD INDEX `user_identities_index` (`user_id`, `del`);
+-- ALTER TABLE `identities` ADD `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00' AFTER `user_id`;
CREATE TABLE `contactgroups` (
`contactgroup_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,