aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--install/update.php7
1 files changed, 6 insertions, 1 deletions
diff --git a/install/update.php b/install/update.php
index 06084a422..f9f1d0a3c 100644
--- a/install/update.php
+++ b/install/update.php
@@ -2524,8 +2524,13 @@ function update_r1188() {
function update_r1189() {
$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(ACTIVE_DBTYPE == DBTYPE_POSTGRES) {
+ $r2 = q("alter table mail add mail_raw smallint not null default 0 ");
+ }
+ else {
+ $r2 = q("alter table mail add mail_raw tinyint(4) not null default 0 ");
+ }
if($r1 && $r2)
return UPDATE_SUCCESS;
return UPDATE_FAILED;