1 -- Adds the ipb_expiry field to ipblocks
3 ALTER TABLE ipblocks
ADD ipb_expiry
char(14) binary NOT NULL default '';
5 -- All IP blocks have one day expiry
6 UPDATE ipblocks
SET ipb_expiry
= date_format(date_add(ipb_timestamp
,INTERVAL 1 DAY),"%Y%m%d%H%i%s") WHERE ipb_user
= 0;
8 -- Null string is fine for user blocks, since this indicates infinity