
TRUNCATE TABLE `acc_export`.`accounts` ;
TRUNCATE TABLE `acc_export`.`accounts_audit` ;
TRUNCATE TABLE `acc_export`.`accounts_contacts` ;
TRUNCATE TABLE `acc_export`.`acl_roles` ;
TRUNCATE TABLE `acc_export`.`acl_actions` ;
TRUNCATE TABLE `acc_export`.`acl_roles_actions` ;
TRUNCATE TABLE `acc_export`.`acl_roles_users` ;
TRUNCATE TABLE `acc_export`.`bank_info` ;
TRUNCATE TABLE `acc_export`.`batch_items` ;
TRUNCATE TABLE `acc_export`.`batch_manager` ;
TRUNCATE TABLE `acc_export`.`combiniactions_history` ;
TRUNCATE TABLE `acc_export`.`combini_history` ;
TRUNCATE TABLE `acc_export`.`config_export_fields` ;
TRUNCATE TABLE `acc_export`.`config_lock` ;
TRUNCATE TABLE `acc_export`.`contacts` ;
TRUNCATE TABLE `acc_export`.`contacts_audit` ;
TRUNCATE TABLE `acc_export`.`contacts_sms_memo` ;
TRUNCATE TABLE `acc_export`.`contacts_sub1` ;
TRUNCATE TABLE `acc_export`.`courselist` ;
TRUNCATE TABLE `acc_export`.`courselist_courses` ;
TRUNCATE TABLE `acc_export`.`emailman` ;
TRUNCATE TABLE `acc_export`.`emails` ;
TRUNCATE TABLE `acc_export`.`emails_contacts` ;
TRUNCATE TABLE `acc_export`.`emails_sub1` ;
TRUNCATE TABLE `acc_export`.`email_templates` ;
TRUNCATE TABLE `acc_export`.`email_templates_category` ;
TRUNCATE TABLE `acc_export`.`event_contacts` ;
TRUNCATE TABLE `acc_export`.`event_contacts_sub1` ;
TRUNCATE TABLE `acc_export`.`event_resource` ;
TRUNCATE TABLE `acc_export`.`master_kanri` ;
TRUNCATE TABLE `acc_export`.`menu_priviledge` ;
TRUNCATE TABLE `acc_export`.`postcard` ;
TRUNCATE TABLE `acc_export`.`product` ;
TRUNCATE TABLE `acc_export`.`productcategory` ;
TRUNCATE TABLE `acc_export`.`prospect_lists` ;
TRUNCATE TABLE `acc_export`.`prospect_lists_prospects` ;
TRUNCATE TABLE `acc_export`.`resource` ;
TRUNCATE TABLE `acc_export`.`resource_sub1` ;
TRUNCATE TABLE `acc_export`.`smsevent` ;
TRUNCATE TABLE `acc_export`.`smsevent_instances` ;
TRUNCATE TABLE `acc_export`.`smsevent_sub1` ;
TRUNCATE TABLE `acc_export`.`smsevent_sub2` ;
TRUNCATE TABLE `acc_export`.`smsevent_sub3` ;
TRUNCATE TABLE `acc_export`.`sms_event_instance` ;
TRUNCATE TABLE `acc_export`.`sms_fee` ;
TRUNCATE TABLE `acc_export`.`sms_fee_sub1` ;
TRUNCATE TABLE `acc_export`.`sms_memo` ;
TRUNCATE TABLE `acc_export`.`sms_memo_templates` ;
TRUNCATE TABLE `acc_export`.`sms_recurrence` ;
TRUNCATE TABLE `acc_export`.`sms_recurrence_templates` ;
TRUNCATE TABLE `acc_export`.`sms_salesgroup` ;
TRUNCATE TABLE `acc_export`.`sms_transaction` ;
TRUNCATE TABLE `acc_export`.`tracker` ;
TRUNCATE TABLE `acc_export`.`trans_combini_hist` ;
TRUNCATE TABLE `acc_export`.`users` ;
TRUNCATE TABLE `acc_export`.`yoyaku_basic` ;
TRUNCATE TABLE `acc_export`.`yoyaku_contacts` ;
TRUNCATE TABLE `acc_export`.`yoyaku_event_contacts` ;
TRUNCATE TABLE `acc_export`.`yoyaku_event_contacts_sub1` ;
TRUNCATE TABLE `acc_export`.`yoyaku_fees` ;
TRUNCATE TABLE `acc_export`.`yoyaku_fees_sub1` ;
TRUNCATE TABLE `acc_export`.`yoyaku_transactions` ;

INSERT INTO `acc_export`.`accounts` SELECT * FROM `acc`.`accounts` ;
INSERT INTO `acc_export`.`accounts_audit` SELECT * FROM `acc`.`accounts_audit` ;
INSERT INTO `acc_export`.`accounts_contacts` SELECT * FROM `acc`.`accounts_contacts` ;
INSERT INTO `acc_export`.`acl_roles` SELECT * FROM `acc`.`acl_roles` ;
INSERT INTO `acc_export`.`acl_actions` SELECT * FROM `acc`.`acl_actions` ;
INSERT INTO `acc_export`.`acl_roles_actions` SELECT * FROM `acc`.`acl_roles_actions` ;
INSERT INTO `acc_export`.`acl_roles_users` SELECT * FROM `acc`.`acl_roles_users` ;
INSERT INTO `acc_export`.`bank_info` SELECT * FROM `acc`.`bank_info` ;
INSERT INTO `acc_export`.`batch_items` SELECT * FROM `acc`.`batch_items` ;
INSERT INTO `acc_export`.`batch_manager` SELECT * FROM `acc`.`batch_manager` ;
INSERT INTO `acc_export`.`combiniactions_history` SELECT * FROM `acc`.`combiniactions_history` ;
INSERT INTO `acc_export`.`combini_history` SELECT * FROM `acc`.`combini_history` ;
INSERT INTO `acc_export`.`config_export_fields` SELECT * FROM `acc`.`config_export_fields` ;
INSERT INTO `acc_export`.`config_lock` SELECT * FROM `acc`.`config_lock` ;
INSERT INTO `acc_export`.`contacts` SELECT * FROM `acc`.`contacts` ;
INSERT INTO `acc_export`.`contacts_audit` SELECT * FROM `acc`.`contacts_audit` ;
INSERT INTO `acc_export`.`contacts_sms_memo` SELECT * FROM `acc`.`contacts_sms_memo` ;
INSERT INTO `acc_export`.`contacts_sub1` SELECT * FROM `acc`.`contacts_sub1` ;
INSERT INTO `acc_export`.`courselist` SELECT * FROM `acc`.`courselist` ;
INSERT INTO `acc_export`.`courselist_courses` SELECT * FROM `acc`.`courselist_courses` ;
INSERT INTO `acc_export`.`emailman` SELECT * FROM `acc`.`emailman` ;
INSERT INTO `acc_export`.`emails` SELECT * FROM `acc`.`emails` ;
INSERT INTO `acc_export`.`emails_contacts` SELECT * FROM `acc`.`emails_contacts` ;
INSERT INTO `acc_export`.`emails_sub1` SELECT * FROM `acc`.`emails_sub1` ;
INSERT INTO `acc_export`.`email_templates` SELECT * FROM `acc`.`email_templates` ;
INSERT INTO `acc_export`.`email_templates_category` SELECT * FROM `acc`.`email_templates_category` ;
INSERT INTO `acc_export`.`event_contacts` SELECT * FROM `acc`.`event_contacts` ;
INSERT INTO `acc_export`.`event_contacts_sub1` SELECT * FROM `acc`.`event_contacts_sub1` ;
INSERT INTO `acc_export`.`event_resource` SELECT * FROM `acc`.`event_resource` ;
INSERT INTO `acc_export`.`master_kanri` SELECT * FROM `acc`.`master_kanri` ;
INSERT INTO `acc_export`.`menu_priviledge` SELECT * FROM `acc`.`menu_priviledge` ;
INSERT INTO `acc_export`.`postcard` SELECT * FROM `acc`.`postcard` ;
INSERT INTO `acc_export`.`product` SELECT * FROM `acc`.`product` ;
INSERT INTO `acc_export`.`productcategory` SELECT * FROM `acc`.`productcategory` ;
INSERT INTO `acc_export`.`prospect_lists` SELECT * FROM `acc`.`prospect_lists` ;
INSERT INTO `acc_export`.`prospect_lists_prospects` SELECT * FROM `acc`.`prospect_lists_prospects` ;
INSERT INTO `acc_export`.`resource` SELECT * FROM `acc`.`resource` ;
INSERT INTO `acc_export`.`resource_sub1` SELECT * FROM `acc`.`resource_sub1` ;
INSERT INTO `acc_export`.`smsevent` SELECT * FROM `acc`.`smsevent` ;
INSERT INTO `acc_export`.`smsevent_instances` SELECT * FROM `acc`.`smsevent_instances` ;
INSERT INTO `acc_export`.`smsevent_sub1` SELECT * FROM `acc`.`smsevent_sub1` ;
INSERT INTO `acc_export`.`smsevent_sub2` SELECT * FROM `acc`.`smsevent_sub2` ;
INSERT INTO `acc_export`.`smsevent_sub3` SELECT * FROM `acc`.`smsevent_sub3` ;
INSERT INTO `acc_export`.`sms_event_instance` SELECT * FROM `acc`.`sms_event_instance` ;
INSERT INTO `acc_export`.`sms_fee` SELECT * FROM `acc`.`sms_fee` ;
INSERT INTO `acc_export`.`sms_fee_sub1` SELECT * FROM `acc`.`sms_fee_sub1` ;
INSERT INTO `acc_export`.`sms_memo` SELECT * FROM `acc`.`sms_memo` ;
INSERT INTO `acc_export`.`sms_memo_templates` SELECT * FROM `acc`.`sms_memo_templates` ;
INSERT INTO `acc_export`.`sms_recurrence` SELECT * FROM `acc`.`sms_recurrence` ;
INSERT INTO `acc_export`.`sms_recurrence_templates` SELECT * FROM `acc`.`sms_recurrence_templates` ;
INSERT INTO `acc_export`.`sms_salesgroup` SELECT * FROM `acc`.`sms_salesgroup` ;
INSERT INTO `acc_export`.`sms_transaction` SELECT * FROM `acc`.`sms_transaction` ;
INSERT INTO `acc_export`.`tracker` SELECT * FROM `acc`.`tracker` ;
INSERT INTO `acc_export`.`trans_combini_hist` SELECT * FROM `acc`.`trans_combini_hist` ;
INSERT INTO `acc_export`.`users` SELECT * FROM `acc`.`users` ;
INSERT INTO `acc_export`.`yoyaku_basic` SELECT * FROM `acc`.`yoyaku_basic` ;
INSERT INTO `acc_export`.`yoyaku_contacts` SELECT * FROM `acc`.`yoyaku_contacts` ;
INSERT INTO `acc_export`.`yoyaku_event_contacts` SELECT * FROM `acc`.`yoyaku_event_contacts` ;
INSERT INTO `acc_export`.`yoyaku_event_contacts_sub1` SELECT * FROM `acc`.`yoyaku_event_contacts_sub1` ;
INSERT INTO `acc_export`.`yoyaku_fees` SELECT * FROM `acc`.`yoyaku_fees` ;
INSERT INTO `acc_export`.`yoyaku_fees_sub1` SELECT * FROM `acc`.`yoyaku_fees_sub1` ;
INSERT INTO `acc_export`.`yoyaku_transactions` SELECT * FROM `acc`.`yoyaku_transactions` ;

