TRUNCATE `accounts_contacts`;
TRUNCATE `category_tree`;
TRUNCATE `courselist`;
TRUNCATE `courselist_courses`;
TRUNCATE `course_category`;
TRUNCATE `emailman`;
TRUNCATE `emails`;
TRUNCATE `emails_contacts`;
TRUNCATE `emails_sub1`;
TRUNCATE `event_contacts`;
TRUNCATE `event_contacts_sub1`;
TRUNCATE `event_resource`;
TRUNCATE `prospect_lists`;
TRUNCATE `prospect_lists_prospects`;
TRUNCATE `smsevent`;
TRUNCATE `smsevent_instances`;
TRUNCATE `smsevent_instances_backup`;
TRUNCATE `smsevent_sub1`;
TRUNCATE `smsevent_sub2`;
TRUNCATE `smsevent_sub3`;
TRUNCATE `sms_event_instance`;
TRUNCATE `sms_event_instance_backup`;
TRUNCATE `sms_event_instance_sub`;
TRUNCATE `sms_fee`;
TRUNCATE `sms_fee_sub1`;
TRUNCATE `sms_memo`;
TRUNCATE `sms_recurrence`;
TRUNCATE `sms_salesgroup`;
TRUNCATE `sms_transaction`;
TRUNCATE `yoyaku_basic`;
TRUNCATE `yoyaku_contacts`;
TRUNCATE `yoyaku_event_contacts`;
TRUNCATE `yoyaku_event_contacts_sub1`;
TRUNCATE `yoyaku_fees`;
TRUNCATE `yoyaku_fees_sub1`;
TRUNCATE `yoyaku_transactions`;