From b639ce7621bd07b43ad0b67c1bf7142486acea18 Mon Sep 17 00:00:00 2001 From: Greg Sabino Mullane Date: Thu, 12 Mar 2009 12:43:57 +0000 Subject: [PATCH] Specify DEFAULT 0 on upgrade to ipb_deleted, in case they had old version of '0'::char --- maintenance/updaters.inc | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/maintenance/updaters.inc b/maintenance/updaters.inc index 34d83f8e44..6d0003d540 100644 --- a/maintenance/updaters.inc +++ b/maintenance/updaters.inc @@ -1570,7 +1570,7 @@ function do_postgres_updates() { array("ipblocks", "ipb_enable_autoblock", "smallint", "CASE WHEN ipb_enable_autoblock=' ' THEN 0 ELSE ipb_enable_autoblock::smallint END DEFAULT 1"), array("ipblocks", "ipb_block_email", "smallint", "CASE WHEN ipb_block_email=' ' THEN 0 ELSE ipb_block_email::smallint END DEFAULT 0"), array("ipblocks", "ipb_address", "text", "ipb_address::text"), - array("ipblocks", "ipb_deleted", "smallint", "ipb_deleted::smallint"), + array("ipblocks", "ipb_deleted", "smallint", "ipb_deleted::smallint DEFAULT 0"), array("math", "math_inputhash", "bytea", "decode(math_inputhash,'escape')"), array("math", "math_outputhash", "bytea", "decode(math_outputhash,'escape')"), array("mwuser", "user_token", "text", ""), -- 2.20.1