fixed error at ndp request

[opengatem/opengatem.git] / sqlscript / updatescript3

/*
Remove the mac address record 
for device passing 1 year after limit date.
Use as
 mysql < updatescript3
*/
use opengatem;
delete from macaddrs where limitDate<adddate(now(), interval -1 year);