/*
Change the mac address to deleted mode 
for device passing 6 month after limit date.
Use as
 mysql < updatescript2
*/
use opengatem;
update macaddrs set status='D' where limitDate<adddate(now(), interval -6 month) and status!='D';