From a493ea8e48ddaa28090c2b74251654376462ebb6 Mon Sep 17 00:00:00 2001 From: alecpl <alec@alec.pl> Date: Wed, 03 Dec 2008 03:02:32 -0500 Subject: [PATCH] - change few "boolean" columns type from integer to smallint --- SQL/postgres.update.sql | 5 +++++ 1 files changed, 5 insertions(+), 0 deletions(-) diff --git a/SQL/postgres.update.sql b/SQL/postgres.update.sql index 5dae5a2..a29558e 100644 --- a/SQL/postgres.update.sql +++ b/SQL/postgres.update.sql @@ -31,3 +31,8 @@ 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; -- Gitblit v1.9.1