Changeset 6223e95 in github

Timestamp:

Nov 25, 2007 10:52:36 AM (5 years ago)

Author:

thomascube <thomas@…>

Branches:

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

Children:

a898459

Parents:

82cd5cd

Message:

Fix Postgresql upgrade script (#1484668)

File:

• SQL/postgres.update.sql (modified) (1 diff)

SQL/postgres.update.sql

@@ -6 +6 @@
 ALTER TABLE "messages" ADD UNIQUE (user_id, cache_key, uid);
 
-ALTER TABLE "identities" ADD html_signature integer DEFAULT 0 NOT NULL;
+ALTER TABLE "identities" ADD html_signature INTEGER;
+ALTER TABLE "identities" ALTER html_signature SET DEFAULT 0;
+UPDATE identities SET html_signature = 0;
+ALTER TABLE "identities" ALTER html_signature SET NOT NULL;