[Pkg-roundcube-maintainers] Bug#711904: [roundcube] can't modify identities since wheezy

[Matija Nalis]

Package: roundcube
Version: 0.7.2-9+deb7u1
Followup-For: Bug #711904

same problem here...

It seems that 
/usr/share/dbconfig-common/data/roundcube/upgrade/mysql/0.5-1
did get applied correctly, but that this file is broken as packaged.

it contains (among valid SQL) two problematic lines:
-- 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`;

note that "--" indicates SQL comment, so those two lines DO NOT get
executed, although they should!

If one executes them manually, (by removing "--" at the begging of the lines)
the roundcube works normally again (when editing identities).

So, something commented those two lines out with '--' for some reason, but never
enabled them again, althought clearly they must be executed for roundcube to
work correctly (none of the other mysql upgrade commands creates that
"changed" field in "indentities" table, and code uses it -- causing
roundcube as packaged in wheezy to break when attempting to manipulate
identities)