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