pgsql/update_tables_0.5.x_for_dovecot-1.2.x.pgsql
author Pascal Volk <neverseen@users.sourceforge.net>
Mon, 01 Mar 2010 02:31:03 +0000
branchv0.6.x
changeset 223 5c7b7cbb01cd
parent 160 639cf4003965
permissions -rw-r--r--
replaced some "for x in list …"
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