diff options
| author | zotlabs <mike@macgirvin.com> | 2016-10-17 15:13:58 -0700 |
|---|---|---|
| committer | zotlabs <mike@macgirvin.com> | 2016-10-17 15:13:58 -0700 |
| commit | 40ce6724a9b1c619261319d23468d7eb312353eb (patch) | |
| tree | 88b4ec71d5f76a5106712d2a9461a767acace283 | |
| parent | e46e3027fa90309d5d0051aa82fc0a8e16512935 (diff) | |
| download | volse-hubzilla-40ce6724a9b1c619261319d23468d7eb312353eb.tar.gz volse-hubzilla-40ce6724a9b1c619261319d23468d7eb312353eb.tar.bz2 volse-hubzilla-40ce6724a9b1c619261319d23468d7eb312353eb.zip | |
"alter table alter" has completely different rules between postgres and mysql
| -rw-r--r-- | install/update.php | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/install/update.php b/install/update.php index 00973a53f..f13243a93 100644 --- a/install/update.php +++ b/install/update.php @@ -2447,7 +2447,13 @@ function update_r1182() { function update_r1183() { - $r1 = q("alter table hook ALTER priority priority smallint NOT NULL DEFAULT '0' "); + + if(ACTIVE_DBTYPE == DBTYPE_POSTGRES) { + $r1 = q("alter table hook ALTER priority priority smallint NOT NULL DEFAULT '0' "); + } + else { + $r1 = q("alter table hook CHANGE priority priority smallint NOT NULL DEFAULT '0' "); + } $r2 = q("create index priority_idx on hook (priority)"); if($r1 && $r2) |