pgsql/update_tables_0.5.x_for_dovecot-1.2.x.pgsql
author Pascal Volk <neverseen@users.sourceforge.net>
Tue, 20 Apr 2010 02:59:08 +0000
changeset 258 9bf8d97ced88
parent 160 639cf4003965
permissions -rw-r--r--
VMM/VMM: corrected name of password scheme PLAIN-MD4.
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
123
626c008a4a04 Added update SQL scripts for Dovecot v1.2.x
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
     1
-- ---
626c008a4a04 Added update SQL scripts for Dovecot v1.2.x
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
     2
-- with Dovecot v1.2.x the service managesieve was renamed to sieve
626c008a4a04 Added update SQL scripts for Dovecot v1.2.x
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
     3
-- ---
626c008a4a04 Added update SQL scripts for Dovecot v1.2.x
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
     4
ALTER TABLE users RENAME managesieve TO sieve;
626c008a4a04 Added update SQL scripts for Dovecot v1.2.x
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
     5
626c008a4a04 Added update SQL scripts for Dovecot v1.2.x
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
     6
DROP VIEW dovecot_password;
626c008a4a04 Added update SQL scripts for Dovecot v1.2.x
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
     7
CREATE OR REPLACE VIEW dovecot_password AS
626c008a4a04 Added update SQL scripts for Dovecot v1.2.x
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
     8
    SELECT local_part || '@' || domain_name.domainname AS "user",
626c008a4a04 Added update SQL scripts for Dovecot v1.2.x
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
     9
           passwd AS "password", smtp, pop3, imap, sieve
626c008a4a04 Added update SQL scripts for Dovecot v1.2.x
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
    10
      FROM users
125
988b9a719929 Removed the currently not needed WHERE clause from the VIEW.
Pascal Volk <neverseen@users.sourceforge.net>
parents: 123
diff changeset
    11
           LEFT JOIN domain_name USING (gid);
123
626c008a4a04 Added update SQL scripts for Dovecot v1.2.x
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
    12