VMM/{Account,common,maillocation}: Dovecot version (check) fixes.
- Account: fixed versions dependencies.
- maillocation: use the version string, may be uses in a error message.
- common: version_hex() raises a ValueError, instead of returning 0,
if the version string is invalid.
-- ---
-- with Dovecot v1.2.x the service managesieve was renamed to sieve
-- ---
ALTER TABLE users RENAME managesieve TO sieve;
DROP VIEW dovecot_password;
CREATE OR REPLACE VIEW dovecot_password AS
SELECT local_part || '@' || domain_name.domainname AS "user",
passwd AS "password", smtp, pop3, imap, sieve
FROM users
LEFT JOIN domain_name USING (gid);