osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now
I am trying to track down the scheme of the database.
How is the ost_file & ost_attachment & ost_ticket tables all linked?
I have my antivirus reporting a trojan that I need to get rid of, I can delete the file however I do not want to delete the file without first getting rid of the database entries.
Second question, is there a database cleanup script of some sort which I can run for when things are deleted?