diff options
| author | alecpl <alec@alec.pl> | 2008-12-03 08:02:32 +0000 |
|---|---|---|
| committer | alecpl <alec@alec.pl> | 2008-12-03 08:02:32 +0000 |
| commit | a493ea8e48ddaa28090c2b74251654376462ebb6 (patch) | |
| tree | 7fc6473ab2d5619ece40f362d8e316c03d2787fd /SQL/postgres.update.sql | |
| parent | f1f17fa5a4284011bd4dbc00b33b61785fd5c645 (diff) | |
- change few "boolean" columns type from integer to smallint
Diffstat (limited to 'SQL/postgres.update.sql')
| -rw-r--r-- | 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 5dae5a28a..a29558e66 100644 --- a/SQL/postgres.update.sql +++ b/SQL/postgres.update.sql @@ -31,3 +31,8 @@ CREATE INDEX cache_created_idx ON "cache" (created); 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; |