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 Pascal Volk <neverseen@users.sourceforge.net>
Fri, 26 Feb 2010 02:35:25 +0000
branchv0.6.x
changeset 216 0c8c053b451c
parent 160 639cf4003965
permissions -rw-r--r--
Moved VirtualMailManager/Exceptions to VirtualMailManager/errors. Renamed VMM*Exception classes to *Error. No longer add the attribute 'message' to VMMError if it doesn't exist, like in Python 2.4. It has been deprecated as of Python 2.6. Also removed the methods code() and msg(), the values are now accessible via the attributes 'code' and 'msg'.
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