| author | Pascal Volk <neverseen@users.sourceforge.net> |
| Sat, 05 Sep 2009 18:46:33 +0000 | |
| changeset 144 | 4c6aa6c29dd7 |
| parent 126 | 3643a0777e77 |
| permissions | -rw-r--r-- |
|
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 |