diff options
| author | Dries Buytaert <dries@buytaert.net> | 2006-09-07 08:08:15 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2006-09-07 08:08:15 +0000 |
| commit | ce7adc62e09a5e07dd4cf568b399ecd57018119a (patch) | |
| tree | 4bf51811af09906d8384f13a29e3cf76ee85e4e7 /modules/system/system.install | |
| parent | 4ea672bfd19319efed1fd398724cc33387337a55 (diff) | |
| download | brdo-ce7adc62e09a5e07dd4cf568b399ecd57018119a.tar.gz brdo-ce7adc62e09a5e07dd4cf568b399ecd57018119a.tar.bz2 | |
- Patch #82822 by dww and sammys: PostgreSQL fixes.
Diffstat (limited to 'modules/system/system.install')
| -rw-r--r-- | modules/system/system.install | 11 |
1 files changed, 8 insertions, 3 deletions
diff --git a/modules/system/system.install b/modules/system/system.install index 26750135f..4ed676c5a 100644 --- a/modules/system/system.install +++ b/modules/system/system.install @@ -3155,17 +3155,22 @@ function system_update_1005() { break; case 'pgsql': + // add new unsigned types for pgsql + $ret[] = update_sql("CREATE DOMAIN int_unsigned integer CHECK (VALUE >= 0)"); + $ret[] = update_sql("CREATE DOMAIN smallint_unsigned smallint CHECK (VALUE >= 0)"); + $ret[] = update_sql("CREATE DOMAIN bigint_unsigned bigint CHECK (VALUE >= 0)"); + $ret[] = update_sql("CREATE TABLE {node_type} ( type varchar(32) NOT NULL, name varchar(255) NOT NULL, module varchar(255) NOT NULL, description text NOT NULL, help text NOT NULL, - has_title integer unsigned NOT NULL, + has_title smallint_unsigned NOT NULL, title_label varchar(255) NOT NULL default '', - has_body integer unsigned NOT NULL, + has_body smallint_unsigned NOT NULL, body_label varchar(255) NOT NULL default '', - min_word_count integer unsigned NOT NULL, + min_word_count smallint_unsigned NOT NULL, custom smallint NOT NULL DEFAULT '0', modified smallint NOT NULL DEFAULT '0', locked smallint NOT NULL DEFAULT '0', |