From 6c7972470be056b650ac9bc66c4ccd307729dd11 Mon Sep 17 00:00:00 2001 From: zotlabs Date: Mon, 17 Oct 2016 16:10:32 -0700 Subject: if we have to go through this contortion every time we change a DB column from unsigned to signed... --- install/update.php | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) (limited to 'install') diff --git a/install/update.php b/install/update.php index f13243a93..fc6641c55 100644 --- a/install/update.php +++ b/install/update.php @@ -2449,7 +2449,10 @@ function update_r1182() { function update_r1183() { if(ACTIVE_DBTYPE == DBTYPE_POSTGRES) { - $r1 = q("alter table hook ALTER priority priority smallint NOT NULL DEFAULT '0' "); + $r1 = q("alter table hook ALTER COLUMN priority TYPE smallint"); + $r2 = q("alter table hook ALTER COLUMN priority SET NOT NULL"); + $r3 = q("alter table hook ALTER COLUMN priority SET DEFAULT '0'"); + $r1 = $r1 && $r2 && $r3; } else { $r1 = q("alter table hook CHANGE priority priority smallint NOT NULL DEFAULT '0' "); -- cgit v1.2.3