create_tables.pgsql
changeset 13 1d9bf63a86f7
parent 9 e3d3dbeb5b84
child 15 1607f7b2dba9
--- a/create_tables.pgsql	Mon Mar 03 23:48:07 2008 +0000
+++ b/create_tables.pgsql	Tue Mar 04 23:28:04 2008 +0000
@@ -90,9 +90,7 @@
 
 CREATE OR REPLACE VIEW dovecot_user AS
     SELECT local_part || '@' || domains.domainname AS userid,
-           domains.domaindir || '/' || uid AS home,
-           uid,
-           gid
+           domains.domaindir || '/' || uid AS home, uid, gid
       FROM users
            LEFT JOIN domains USING (gid);
 
@@ -101,8 +99,7 @@
       FROM domains;
 
 CREATE OR REPLACE VIEW postfix_uid AS
-    SELECT local_part || '@' || domains.domainname AS address,
-           uid
+    SELECT local_part || '@' || domains.domainname AS address, uid
       FROM users
            LEFT JOIN domains USING (gid);