--- 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),

--- 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);