From df3eb562f09dc8c9248d9f76c7cf48480027075e Mon Sep 17 00:00:00 2001 From: zotlabs Date: Mon, 15 May 2017 22:58:13 -0700 Subject: danger - do not use 'char(n)' with postgres it creates a thing called a bpchar which is different than a normal text field in subtle ways. --- install/update.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'install/update.php') diff --git a/install/update.php b/install/update.php index 65506a2f7..affdb6ffb 100644 --- a/install/update.php +++ b/install/update.php @@ -2475,7 +2475,7 @@ function update_r1184() { function update_r1185() { - $r1 = q("alter table app add app_plugin char(255) not null default '' "); + $r1 = q("alter table app add app_plugin text not null default '' "); if($r1) return UPDATE_SUCCESS; @@ -2523,7 +2523,7 @@ function update_r1188() { function update_r1189() { - $r1 = q("alter table mail add mail_mimetype char(64) not null default 'text/bbcode' "); + $r1 = q("alter table mail add mail_mimetype varchar(64) not null default 'text/bbcode' "); $r2 = q("alter table mail add mail_raw int(4) not null default '0' "); if($r1 && $r2) -- cgit v1.2.3