Changeset 2108 in subversion for trunk/roundcubemail/SQL/postgres.update.sql

Timestamp:

Dec 3, 2008 3:02:32 AM (5 years ago)

Author:

alec

Message:

• change few "boolean" columns type from integer to smallint

File:

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

trunk/roundcubemail/SQL/postgres.update.sql

@@ -32 +32 @@
 ALTER TABLE users ALTER "language" DROP NOT NULL;
 ALTER TABLE users ALTER "language" DROP DEFAULT;
+
+ALTER TABLE identities ALTER del TYPE smallint;
+ALTER TABLE identities ALTER standard TYPE smallint;
+ALTER TABLE contacts ALTER del TYPE smallint;
+ALTER TABLE messages ALTER del TYPE smallint;