pgsql/update_tables_0.5.x_for_dovecot-1.2.x.pgsql
author Pascal Volk <neverseen@users.sourceforge.net>
Sat, 02 Jan 2010 19:56:58 +0000
branchv0.6.x
changeset 164 67dc18294de6
parent 160 639cf4003965
permissions -rw-r--r--
*.sh: Added --force option to python setup.py install call. upgrade.sh: Removed old cleanup code.
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