-- ---

-- 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);