Changeset 8381ec1 in github

Timestamp:

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

Author:

alecpl <alec@…>

Branches:

master, HEAD, courier-fix, dev-browser-capabilities, pdo, release-0.6, release-0.7, release-0.8

Children:

4591de7

Parents:

32c8ba6

Message:

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

Files:

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

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

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

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