Changeset 923 in subversion

Timestamp:

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

Author:

thomasb

Message:

Fix Postgresql upgrade script (#1484668)

File:

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

trunk/roundcubemail/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;