Mercurial Mercurial > vmm / annotate
summary | shortlog | changelog | graph | tags | bookmarks | branches | files | changeset | file | latest | revisions | annotate | diff | comparison | raw | help
Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
pgsql/update_tables_0.5.x_for_dovecot-1.2.x.pgsql
author Tobias Berling <mail@tobiasberling.de>
Sun, 18 Apr 2010 19:02:23 +0000
branchv0.6.x
changeset 257 5b8fde01e4f0
parent 160 639cf4003965
permissions -rw-r--r--
VMM/Alias.py: Replaced some %r with '%s'. VMM/AliasDomain.py: save(), switch(), delete(): Update AliasDomain._gid after database change. Added dbc.close() to AliasDomain.delete(). create_tables{,-dovecot-1.2.x}.pgsql: Fixed a typo.
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
















vmm




Repositories index