From 40ce6724a9b1c619261319d23468d7eb312353eb Mon Sep 17 00:00:00 2001 From: zotlabs Date: Mon, 17 Oct 2016 15:13:58 -0700 Subject: "alter table alter" has completely different rules between postgres and mysql --- install/update.php | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) (limited to 'install') 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) -- cgit v1.2.3