A List of tables which can be truncated which does not harm the instances settings. the first section is for SugarCRM and the rest is to be added if you are using SuiteCRM. this is just the core modules and the cstm tables will be added later.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 |
truncate contacts; truncate contacts_cases; truncate contacts_cstm; truncate contacts_users; truncate accounts_contacts; truncate contacts_audit; truncate document_revisions; truncate emailman; truncate emails; truncate emails_email_addr_rel; truncate emails_text; truncate email_addresses; truncate email_cache; truncate email_marketing; truncate email_marketing_prospect_lists; truncate inbound_email; truncate email_addresses; truncate email_addr_bean_rel; truncate documents ; truncate documents_contacts; truncate documents_cases; truncate documents_accounts; truncate tasks; truncate user_preferences; truncate sugarfeed; truncate accounts; truncate accounts_contacts; truncate accounts_cases; truncate accounts_audit; truncate accounts_opportunities; truncate users; truncate users_cstm; truncate users_feeds; truncate contacts_users; truncate meetings; truncate meetings_leads; truncate meetings_users; truncate meetings_contacts; truncate calls; truncate calls_contacts; truncate calls_leads; truncate calls_users; truncate leads; truncate leads_audit; truncate notes; truncate cases; truncate cases_audit; truncate opportunities; truncate opportunities_contacts; truncate opportunities_audit; truncate project; truncate prospects; truncate prospects_cstm; truncate emails_beans; TRUNCATE prospect_lists; TRUNCATE prospect_lists_cstm; TRUNCATE prospect_lists_prospects; TRUNCATE prospect_list_campaigns; TRUNCATE prospect_lists_prospects; truncate documents_contacts; truncate documents; truncate documents_accounts; truncate documents_opportunities; truncate linked_documents; truncate campaigns; truncate campaign_log; truncate campaign_trkrs; /* SUITECRM TABLES */ truncate calls_reschedule; truncate aop_case_events; truncate aop_case_events_audit; truncate aop_case_updates; truncate aop_case_updates_audit; truncate aos_contracts; truncate aos_contracts_audit; truncate aos_invoices; truncate aos_line_item_groups; truncate aos_quotes; truncate aos_quotes_audit; |