summaryrefslogtreecommitdiff
path: root/includes/database/pgsql/schema.inc
diff options
context:
space:
mode:
Diffstat (limited to 'includes/database/pgsql/schema.inc')
-rw-r--r--includes/database/pgsql/schema.inc7
1 files changed, 3 insertions, 4 deletions
diff --git a/includes/database/pgsql/schema.inc b/includes/database/pgsql/schema.inc
index d2e837d1e..578c074bb 100644
--- a/includes/database/pgsql/schema.inc
+++ b/includes/database/pgsql/schema.inc
@@ -147,6 +147,9 @@ 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'] . ')';
@@ -155,10 +158,6 @@ 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';
}