exists for table "identities". Closes: #617312.
+roundcube (0.5.1+dfsg-6) unstable; urgency=low
+
+ * Handle incorrect upgrade from 0.3.1-6 when "changed" column already
+ exists for table "identities". Closes: #617312.
+
+ -- Vincent Bernat <bernat@debian.org> Tue, 08 Mar 2011 07:37:56 +0100
+
roundcube (0.5.1+dfsg-5) unstable; urgency=low
* Don't use awk. Use plain shell to modify main.inc.php.
configure)
# We try to fix an incomplete upgrade (see #610725 and #613586)
- if [ -n "$2" ] && dpkg --compare-versions "$2" le 0.5.1+dfsg-2; then
+ if [ -n "$2" ] && dpkg --compare-versions "$2" le 0.5.1+dfsg-5; then
db_get roundcube/dbconfig-upgrade || true
if [ x"$RET" = x"true" ]; then
if [ x"$dbc_dbtype" = x"mysql" ]; then
cat <<EOF | while read command; do dbc_mysql_exec_command "$command" || true ; done
ALTER TABLE \`messages\` ADD INDEX \`index_index\` (\`user_id\`, \`cache_key\`, \`idx\`);
ALTER TABLE \`contacts\`ADD INDEX \`user_contacts_index\` (\`user_id\`,\`email\`);
+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\`);
EOF
fi
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 `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,