aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorzotlabs <mike@macgirvin.com>2016-10-17 15:13:58 -0700
committerzotlabs <mike@macgirvin.com>2016-10-17 15:13:58 -0700
commit40ce6724a9b1c619261319d23468d7eb312353eb (patch)
tree88b4ec71d5f76a5106712d2a9461a767acace283
parente46e3027fa90309d5d0051aa82fc0a8e16512935 (diff)
downloadvolse-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.php8
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)