1 -- ---

     2 -- with Dovecot v1.2.x the service managesieve was renamed to sieve

     3 -- ---

     4 ALTER TABLE users RENAME managesieve TO sieve;

     5 

     6 DROP VIEW dovecot_password;

     7 CREATE OR REPLACE VIEW dovecot_password AS

     8     SELECT local_part || '@' || domain_name.domainname AS "user",

     9            passwd AS "password", smtp, pop3, imap, sieve

    10       FROM users

    11            LEFT JOIN domain_name USING (gid);

    12