# HG changeset patch
# User Pascal Volk <neverseen@users.sourceforge.net>
# Date 1220155958 0
# Node ID 4c94ba2976983e6faaa6974327ea2319acad4ca0
# Parent  a3663ad491bfd1735c7a544eb9a5d84f3eca3dfd
* 'create_tables.pgsql'
* 'update_tables_0.4.x-0.5.pgsql'
    - Corrected constraint name of table users PRIMARY KEY
      pkye_users -> pkey_users

diff -r a3663ad491bf -r 4c94ba297698 create_tables.pgsql
--- a/create_tables.pgsql	Fri Aug 29 03:28:25 2008 +0000
+++ b/create_tables.pgsql	Sun Aug 31 04:12:38 2008 +0000
@@ -71,7 +71,7 @@
     pop3        boolean NOT NULL DEFAULT TRUE,
     imap        boolean NOT NULL DEFAULT TRUE,
     managesieve boolean NOT NULL DEFAULT TRUE,
-    CONSTRAINT  pkye_users PRIMARY KEY (local_part, gid),
+    CONSTRAINT  pkey_users PRIMARY KEY (local_part, gid),
     CONSTRAINT  ukey_users_uid UNIQUE (uid),
     CONSTRAINT  fkey_users_gid_domain_data FOREIGN KEY (gid)
         REFERENCES domain_data (gid),
diff -r a3663ad491bf -r 4c94ba297698 update_tables_0.4.x-0.5.pgsql
--- a/update_tables_0.4.x-0.5.pgsql	Fri Aug 29 03:28:25 2008 +0000
+++ b/update_tables_0.4.x-0.5.pgsql	Sun Aug 31 04:12:38 2008 +0000
@@ -33,6 +33,8 @@
       FROM domains;
 
 
+ALTER TABLE users DROP CONSTRAINT pkye_users;
+ALTER TABLE users ADD CONSTRAINT  pkey_users PRIMARY KEY (local_part, gid);
 ALTER TABLE users DROP CONSTRAINT fkey_users_gid_domains;
 ALTER TABLE users ADD CONSTRAINT fkey_users_gid_domain_data FOREIGN KEY (gid)
     REFERENCES domain_data (gid);