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