diff options
| author | alec <alec@208e9e7b-5314-0410-a742-e7e81cd9613c> | 2008-12-03 08:02:32 +0000 |
|---|---|---|
| committer | alec <alec@208e9e7b-5314-0410-a742-e7e81cd9613c> | 2008-12-03 08:02:32 +0000 |
| commit | 9bafa7e81ba587659fc335bc2bc587cfde7739c9 (patch) | |
| tree | 880d25b77272331a90173f1cdf6205ef6db787f0 /roundcubemail/SQL/postgres.update.sql | |
| parent | b239c28757e181cf1a00d9b04b5f2eee0b24c218 (diff) | |
- change few "boolean" columns type from integer to smallint
git-svn-id: https://svn.roundcube.net/trunk@2108 208e9e7b-5314-0410-a742-e7e81cd9613c
Diffstat (limited to 'roundcubemail/SQL/postgres.update.sql')
| -rw-r--r-- | roundcubemail/SQL/postgres.update.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/roundcubemail/SQL/postgres.update.sql b/roundcubemail/SQL/postgres.update.sql index 5dae5a28a..a29558e66 100644 --- a/roundcubemail/SQL/postgres.update.sql +++ b/roundcubemail/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; |