diff options
Diffstat (limited to 'database')
| -rw-r--r-- | database/updates.inc | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/database/updates.inc b/database/updates.inc index 534fa611d..d5b9ed5c1 100644 --- a/database/updates.inc +++ b/database/updates.inc @@ -1961,7 +1961,7 @@ function update_110() { #$ret[] = update_sql('ALTER TABLE {blocks} DROP path'); $ret[] = update_sql('ALTER TABLE {blocks} ADD visibility smallint'); - $ret[] = update_sql("ALTER TABLE {blocks} ALTER COLUMN type set default ''"); + $ret[] = update_sql("ALTER TABLE {blocks} ALTER COLUMN visibility set default 0"); $ret[] = update_sql('UPDATE {blocks} SET visibility = 0'); $ret[] = update_sql('ALTER TABLE {blocks} ALTER COLUMN visibility SET NOT NULL'); $ret[] = update_sql('ALTER TABLE {blocks} ADD pages text'); @@ -2291,7 +2291,7 @@ function update_125() { if ($GLOBALS['db_type'] == 'pgsql') { - $ret[] = update_sql[] = ("CREATE FUNCTION "if"(boolean, anyelement, anyelement) RETURNS anyelement AS ' + $ret[] = update_sql("CREATE OR REPLACE FUNCTION if(boolean, anyelement, anyelement) RETURNS anyelement AS ' SELECT CASE WHEN $1 THEN $2 ELSE $3 END; ' LANGUAGE 'sql'"); |