When we delete a site, we don't delete it's data from other tables like cron, auth, whitelist, site_meta etc...
Also it should trigger cleanup actions which would regenerate files (auth files, cron files etc...)
It should also purge cache of that site if any.
Things to do on cleanup: