[Summary view] [Print] [Text view]

   1  -- Adds the ipb_expiry field to ipblocks
   2  
   3  ALTER TABLE /*$wgDBprefix*/ipblocks ADD ipb_expiry varbinary(14) NOT NULL default '';
   4  
   5  -- All IP blocks have one day expiry
   6  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;
   7  
   8  -- Null string is fine for user blocks, since this indicates infinity