Changeset 4603 in subversion

Timestamp:

Mar 10, 2011 7:30:42 AM (2 years ago)

Author:

alec

Message:

• Force names of unique constraints in PostgreSQL DDL (postgres 9.x uses different naming convention than older versions)

Location:

trunk/roundcubemail

Files:

• CHANGELOG (modified) (1 diff)
• SQL/postgres.initial.sql (modified) (2 diffs)
• SQL/postgres.update.sql (modified) (1 diff)

trunk/roundcubemail/CHANGELOG

@@ -2 +2 @@
 ===========================
 
+- Force names of unique constraints in PostgreSQL DDL
 - Add code for prevention from IMAP connection hangs when server closes socket unexpectedly
 - Remove redundant DELETE query (for old session deletion) on login

trunk/roundcubemail/SQL/postgres.initial.sql

@@ -26 +26 @@
     "language" varchar(5),
     preferences text DEFAULT ''::text NOT NULL,
-    UNIQUE (username, mail_host)
+    CONSTRAINT users_username_key UNIQUE (username, mail_host)
 );
 
@@ -221 +221 @@
     headers text NOT NULL,
     structure text,
-    UNIQUE (user_id, cache_key, uid)
+    CONSTRAINT messages_user_id_key UNIQUE (user_id, cache_key, uid)
 );
 

trunk/roundcubemail/SQL/postgres.update.sql

@@ -86 +86 @@
 
 DROP INDEX users_username_id_idx;
-ALTER TABLE users ADD UNIQUE (username, mail_host);
+ALTER TABLE users ADD CONSTRAINT users_username_key UNIQUE (username, mail_host);
 ALTER TABLE contacts ALTER email TYPE varchar(255);