source: lliurex-analytics-server/trunk/fuentes/lliurex-analytics-server/usr/lib/analytics-server/clean.sql @ 6926

Last change on this file since 6926 was 6926, checked in by mabarracus, 2 years ago

Fix bugs

File size: 202 bytes
Line 
1start transaction;
2
3delete from RecvPackages WHERE string not REGEXP '^[a-zA-Z][a-zA-Z0-9_.+\-]+$'
4
5delete from RecvPackages WHERE date < date_sub(date_format(NOW(),'%Y-%m-01'),interval 1 year)
6
7commit;
Note: See TracBrowser for help on using the repository browser.