It would be nice to have a near clean working database again with nothing we imported. Has anyone had this requirement and have a good solution to the problem?
I've used the sql below but is it enough?
# Removing leads import
TRUNCATE TABLE leads;
TRUNCATE TABLE leads_audit;
TRUNCATE TABLE leads_cstm;
TRUNCATE TABLE prospect_lists_prospects;
# Removing Contacts import
TRUNCATE TABLE contacts;
TRUNCATE TABLE contacts_audit;
TRUNCATE TABLE contacts_bugs;
TRUNCATE TABLE contacts_cases;
TRUNCATE TABLE contacts_cstm;
TRUNCATE TABLE contacts_users;
I would like to be able to remove as much junk as possible without breaking anything.