In alLANBilling added database cleanup

In the alLANBilling version 20080928 added textbox where you can type date.

All records BEFORE entered date will be deleted from database.

After delete database will optimize and check.

Don’t forget to grant delete privilege to the user!

grant delete on DATABSE.TABLE to USER;

UPD: After mistake in the code…i’ve lost all records in my database…. After that I added protection:

You will be unable to delete records with date > -2 mont (this means, that you can delete only recods thats old more than 2 month)

This entry was posted in alLANBilling. Bookmark the permalink. Both comments and trackbacks are currently closed.