diff options
Diffstat (limited to 'includes/database/pgsql/schema.inc')
| -rw-r--r-- | includes/database/pgsql/schema.inc | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/includes/database/pgsql/schema.inc b/includes/database/pgsql/schema.inc index 578c074bb..d2e837d1e 100644 --- a/includes/database/pgsql/schema.inc +++ b/includes/database/pgsql/schema.inc @@ -147,9 +147,6 @@ class DatabaseSchema_pgsql extends DatabaseSchema { if ($spec['type'] == 'serial') { unset($spec['not null']); } - if (!empty($spec['unsigned'])) { - $sql .= " CHECK ($name >= 0)"; - } if (in_array($spec['type'], array('varchar', 'char', 'text')) && isset($spec['length'])) { $sql .= '(' . $spec['length'] . ')'; @@ -158,6 +155,10 @@ class DatabaseSchema_pgsql extends DatabaseSchema { $sql .= '(' . $spec['precision'] . ', ' . $spec['scale'] . ')'; } + if (!empty($spec['unsigned'])) { + $sql .= " CHECK ($name >= 0)"; + } + if (isset($spec['not null']) && $spec['not null']) { $sql .= ' NOT NULL'; } |