X-Git-Url: http://git.heureux-cyclage.org/?a=blobdiff_plain;f=maintenance%2Farchives%2Fpatch-ipb_expiry.sql;h=f3b6a82b08690a04f3dec1ef4efe9610c1caf0f7;hb=fb5eed4ebb0a0e8b4b357b2c23913fd5176eee4e;hp=d41c8771da1f2ad769ab1a6b51494e32d9792ed8;hpb=e2f98922df92eedf50aa5f93f2f4327d436a1c71;p=lhc%2Fweb%2Fwiklou.git diff --git a/maintenance/archives/patch-ipb_expiry.sql b/maintenance/archives/patch-ipb_expiry.sql index d41c8771da..f3b6a82b08 100644 --- a/maintenance/archives/patch-ipb_expiry.sql +++ b/maintenance/archives/patch-ipb_expiry.sql @@ -1,8 +1,8 @@ -- Adds the ipb_expiry field to ipblocks -ALTER TABLE ipblocks ADD ipb_expiry char(14) binary NOT NULL default ''; +ALTER TABLE /*$wgDBprefix*/ipblocks ADD ipb_expiry varbinary(14) NOT NULL default ''; -- All IP blocks have one day expiry -UPDATE ipblocks SET ipb_expiry = date_format(date_add(ipb_timestamp,INTERVAL 1 DAY),"%Y%m%d%H%i%s") WHERE ipb_user = 0; +UPDATE /*$wgDBprefix*/ipblocks SET ipb_expiry = date_format(date_add(ipb_timestamp,INTERVAL 1 DAY),"%Y%m%d%H%i%s") WHERE ipb_user = 0; -- Null string is fine for user blocks, since this indicates infinity