+roundcube (0.5.1+dfsg-2) unstable; urgency=low
+
+ * Remove all "ADD INDEX" from MySQL 0.5-1 upgrade file and put them in
+ postinst script. Also add a note in NEWS.Debian file about this
+ problem. Closes: #613586.
+
+ -- Vincent Bernat <bernat@debian.org> Wed, 16 Feb 2011 08:40:34 +0100
+
roundcube (0.5.1+dfsg-1) unstable; urgency=low
* Add plugins. Closes: #550454.
+roundcube (0.5.1+dfsg-2) unstable; urgency=low
+
+ Upgrades to 0.5.X using a MySQL database and with the help of
+ dbconfig-common may have been incomplete. If you got error from
+ dbconfig-common about a problem during migration from 0.3.1-6 to
+ 0.5-1 or if some features are missing, most notably identities and
+ address book management, please reexecute all commands in this
+ file (with "-f" flag of mysql command):
+ /usr/share/dbconfig-common/data/roundcube/upgrade/mysql/0.5-1
+
+ More information can be found here:
+ http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=613586
+
+ -- Vincent Bernat <bernat@debian.org> Wed, 16 Feb 2011 08:40:34 +0100
+
roundcube (0.3.1-2) unstable; urgency=low
Starting from Roundcube 0.3, an incompatibility with Suhosin session
ALTER TABLE \`messages\` ADD INDEX \`index_index\` (\`user_id\`, \`cache_key\`, \`idx\`);
ALTER TABLE \`session\` CHANGE \`vars\` \`vars\` MEDIUMTEXT NOT NULL;
ALTER TABLE \`contacts\`ADD INDEX \`user_contacts_index\` (\`user_id\`,\`email\`);
+ALTER TABLE \`identities\` ADD INDEX \`user_identities_index\` (\`user_id\`, \`del\`);
EOF
fi
fi
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 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` (