SQL For Test

INSERT INTO `order_info` (`order_info_id`, `store_id`, `account_id`, `store_customer_id`, `order_number`, `store_order_number`, `order_date`, `consignor_type`, `delivery_destination_type`, `subtotal`, `subtotal_tax`, `subtotal_discount`, `postage`, `postage_tax`, `wrapping_fee`, `wrapping_fee_tax`, `cash_on_delivery_fee`, `cash_on_delivery_fee_tax`, `payment_fee`, `payment_fee_tax`, `use_point`, `point_discount`, `total_amount`, `total_tax`, `total`, `adjustment_amount`, `detail_plus_point_total`, `detail_discount_total`, `tax_rate`, `tax_calculation_method`, `repeat_count`, `refund_method`, `answer_expiration_date`, `orderer_note`, `payment_type_id`, `order_company_name`, `order_company_name_kana`, `order_last_name`, `order_first_name`, `order_last_name_kana`, `order_first_name_kana`, `order_zip`, `order_pref_id`, `order_pref`, `order_city`, `order_town`, `order_town2`, `order_address`, `order_tel`, `order_mail_address`, `order_sex_id`, `order_birth`, `order_job`, `order_user_agent`, `site_code`, `delete_flag`, `delete_account_id`, `delete_date`, `create_account_id`, `create_date`, `last_update_account_id`, `last_update_date`) VALUES (1, 1, 2, 1, '11111', '22', '2017-04-11 17:41:40', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'aa', 1, 'aaaa', 'a', 'ccc', 'ssss', 'ccc', 'ssss', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 0, '2017-07-11 15:01:17', 0, '2017-07-11 15:01:22');
INSERT INTO `order_info` (`order_info_id`, `store_id`, `account_id`, `store_customer_id`, `order_number`, `store_order_number`, `order_date`, `consignor_type`, `delivery_destination_type`, `subtotal`, `subtotal_tax`, `subtotal_discount`, `postage`, `postage_tax`, `wrapping_fee`, `wrapping_fee_tax`, `cash_on_delivery_fee`, `cash_on_delivery_fee_tax`, `payment_fee`, `payment_fee_tax`, `use_point`, `point_discount`, `total_amount`, `total_tax`, `total`, `adjustment_amount`, `detail_plus_point_total`, `detail_discount_total`, `tax_rate`, `tax_calculation_method`, `repeat_count`, `refund_method`, `answer_expiration_date`, `orderer_note`, `payment_type_id`, `order_company_name`, `order_company_name_kana`, `order_last_name`, `order_first_name`, `order_last_name_kana`, `order_first_name_kana`, `order_zip`, `order_pref_id`, `order_pref`, `order_city`, `order_town`, `order_town2`, `order_address`, `order_tel`, `order_mail_address`, `order_sex_id`, `order_birth`, `order_job`, `order_user_agent`, `site_code`, `delete_flag`, `delete_account_id`, `delete_date`, `create_account_id`, `create_date`, `last_update_account_id`, `last_update_date`) VALUES (2, 2, 3, 1, '11111', '22', '2017-07-11 17:41:42', 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 0, '2017-07-11 15:01:17', 0, '2017-07-11 15:01:22');
INSERT INTO `order_info` (`order_info_id`, `store_id`, `account_id`, `store_customer_id`, `order_number`, `store_order_number`, `order_date`, `consignor_type`, `delivery_destination_type`, `subtotal`, `subtotal_tax`, `subtotal_discount`, `postage`, `postage_tax`, `wrapping_fee`, `wrapping_fee_tax`, `cash_on_delivery_fee`, `cash_on_delivery_fee_tax`, `payment_fee`, `payment_fee_tax`, `use_point`, `point_discount`, `total_amount`, `total_tax`, `total`, `adjustment_amount`, `detail_plus_point_total`, `detail_discount_total`, `tax_rate`, `tax_calculation_method`, `repeat_count`, `refund_method`, `answer_expiration_date`, `orderer_note`, `payment_type_id`, `order_company_name`, `order_company_name_kana`, `order_last_name`, `order_first_name`, `order_last_name_kana`, `order_first_name_kana`, `order_zip`, `order_pref_id`, `order_pref`, `order_city`, `order_town`, `order_town2`, `order_address`, `order_tel`, `order_mail_address`, `order_sex_id`, `order_birth`, `order_job`, `order_user_agent`, `site_code`, `delete_flag`, `delete_account_id`, `delete_date`, `create_account_id`, `create_date`, `last_update_account_id`, `last_update_date`) VALUES (3, 1, 1, 1, '11111', '22', '2017-04-11 17:41:40', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'aa', 1, '1', 'a', 'ccc', 'ssss', 'ccc', 'ssss', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 0, '2017-07-11 15:01:17', 0, '2017-07-11 15:01:22');
INSERT INTO `order_info` (`order_info_id`, `store_id`, `account_id`, `store_customer_id`, `order_number`, `store_order_number`, `order_date`, `consignor_type`, `delivery_destination_type`, `subtotal`, `subtotal_tax`, `subtotal_discount`, `postage`, `postage_tax`, `wrapping_fee`, `wrapping_fee_tax`, `cash_on_delivery_fee`, `cash_on_delivery_fee_tax`, `payment_fee`, `payment_fee_tax`, `use_point`, `point_discount`, `total_amount`, `total_tax`, `total`, `adjustment_amount`, `detail_plus_point_total`, `detail_discount_total`, `tax_rate`, `tax_calculation_method`, `repeat_count`, `refund_method`, `answer_expiration_date`, `orderer_note`, `payment_type_id`, `order_company_name`, `order_company_name_kana`, `order_last_name`, `order_first_name`, `order_last_name_kana`, `order_first_name_kana`, `order_zip`, `order_pref_id`, `order_pref`, `order_city`, `order_town`, `order_town2`, `order_address`, `order_tel`, `order_mail_address`, `order_sex_id`, `order_birth`, `order_job`, `order_user_agent`, `site_code`, `delete_flag`, `delete_account_id`, `delete_date`, `create_account_id`, `create_date`, `last_update_account_id`, `last_update_date`) VALUES (4, 1, 1, 1, '11111', '22', '2017-04-11 17:41:40', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'aa', 1, '1', 'a', 'ccc', 'ssss', 'ccc', 'ssss', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 0, '2017-07-11 15:01:17', 0, '2017-07-11 15:01:22');
INSERT INTO `order_info` (`order_info_id`, `store_id`, `account_id`, `store_customer_id`, `order_number`, `store_order_number`, `order_date`, `consignor_type`, `delivery_destination_type`, `subtotal`, `subtotal_tax`, `subtotal_discount`, `postage`, `postage_tax`, `wrapping_fee`, `wrapping_fee_tax`, `cash_on_delivery_fee`, `cash_on_delivery_fee_tax`, `payment_fee`, `payment_fee_tax`, `use_point`, `point_discount`, `total_amount`, `total_tax`, `total`, `adjustment_amount`, `detail_plus_point_total`, `detail_discount_total`, `tax_rate`, `tax_calculation_method`, `repeat_count`, `refund_method`, `answer_expiration_date`, `orderer_note`, `payment_type_id`, `order_company_name`, `order_company_name_kana`, `order_last_name`, `order_first_name`, `order_last_name_kana`, `order_first_name_kana`, `order_zip`, `order_pref_id`, `order_pref`, `order_city`, `order_town`, `order_town2`, `order_address`, `order_tel`, `order_mail_address`, `order_sex_id`, `order_birth`, `order_job`, `order_user_agent`, `site_code`, `delete_flag`, `delete_account_id`, `delete_date`, `create_account_id`, `create_date`, `last_update_account_id`, `last_update_date`) VALUES (5, 1, 1, 1, '11111', '22', '2017-04-11 17:41:40', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'aa', 1, '1', 'a', 'ccc', 'ssss', 'ccc', 'ssss', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 0, '2017-07-11 15:01:17', 0, '2017-07-11 15:01:22');


INSERT INTO `inquiry` (`inquiry_id`, `inquiry_from_member_id`, `inquiry_to_member_id`, `inquiry_thread_id`, `inquiry_kind`, `inquiry_status`, `inquiry_update_date`, `inquiry_member_account_id`, `inquiry_detail`, `answer_date`, `answer_member_account_id`, `answer_detail`, `data_id`, `delete_flag`, `delete_account_id`, `delete_date`, `create_account_id`, `create_date`, `last_update_account_id`, `last_update_date`) VALUES (1, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, NULL, 0, '2017-07-11 20:36:13', 0, '2017-07-11 20:36:15');


INSERT INTO `order_shipping` (`order_shipping_id`, `order_info_id`, `shipping_status_type_id`, `order_shipping_possible_date`, `order_shipping_possible_note`, `order_shipping_transaction_start_date`, `order_shipping_transaction_start_note`, `order_shipping_date`, `order_shipping_note`, `arrival_date`, `arrival_note`, `shipping_number`, `target_delivery_warehouse_id`, `delivery_company_id`, `estimated_delivery_date`, `desired_delivery_date_flag`, `desired_delivery_date`, `desired_delivery_time_id`, `desired_delivery_time_name`, `postage`, `delivery_method_id`, `invoice_software_id`, `gift_wrapping_flag`, `gift_wrapping_type`, `gift_message`, `gift_wrapping_noshi_flag`, `gift_wrapping_noshi_type`, `gift_wrapping_noshi_name`, `shipping_last_name`, `shipping_first_name`, `shipping_last_name_kana`, `shipping_first_name_kana`, `shipping_company_name`, `shipping_company_name_kana`, `shipping_zip`, `shipping_pref_id`, `shipping_pref`, `shipping_city`, `shipping_town`, `shipping_town2`, `shipping_address`, `shipping_tel`, `shipping_mail_address`, `delete_flag`, `delete_account_id`, `delete_date`, `create_account_id`, `create_date`, `last_update_account_id`, `last_update_date`) VALUES (1, 1, 1, NULL, '1', NULL, NULL, '2017-07-08 07:20:19', NULL, '2017-07-12 10:21:03', NULL, NULL, NULL, NULL, '2017-07-12 10:21:11', NULL, '2017-07-12 11:51:42', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 0, '2017-07-11 15:17:15', 0, '2017-07-11 15:17:20');
INSERT INTO `order_shipping` (`order_shipping_id`, `order_info_id`, `shipping_status_type_id`, `order_shipping_possible_date`, `order_shipping_possible_note`, `order_shipping_transaction_start_date`, `order_shipping_transaction_start_note`, `order_shipping_date`, `order_shipping_note`, `arrival_date`, `arrival_note`, `shipping_number`, `target_delivery_warehouse_id`, `delivery_company_id`, `estimated_delivery_date`, `desired_delivery_date_flag`, `desired_delivery_date`, `desired_delivery_time_id`, `desired_delivery_time_name`, `postage`, `delivery_method_id`, `invoice_software_id`, `gift_wrapping_flag`, `gift_wrapping_type`, `gift_message`, `gift_wrapping_noshi_flag`, `gift_wrapping_noshi_type`, `gift_wrapping_noshi_name`, `shipping_last_name`, `shipping_first_name`, `shipping_last_name_kana`, `shipping_first_name_kana`, `shipping_company_name`, `shipping_company_name_kana`, `shipping_zip`, `shipping_pref_id`, `shipping_pref`, `shipping_city`, `shipping_town`, `shipping_town2`, `shipping_address`, `shipping_tel`, `shipping_mail_address`, `delete_flag`, `delete_account_id`, `delete_date`, `create_account_id`, `create_date`, `last_update_account_id`, `last_update_date`) VALUES (2, 1, 1, NULL, '2', NULL, NULL, '2017-07-08 10:20:27', NULL, '2017-07-12 10:21:04', NULL, NULL, NULL, NULL, '2017-07-12 10:21:12', NULL, '2017-07-12 11:51:43', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 0, '2017-07-11 15:17:15', 0, '2017-07-11 15:17:20');


INSERT INTO `order_status` (`order_order_status_id`, `order_info_id`, `order_status_type_id`, `reservation_date`, `reservation_reason`, `cancel_date`, `cancel_reason_id`, `cancel_note`, `delete_flag`, `delete_account_id`, `delete_date`, `create_account_id`, `create_date`, `last_update_account_id`, `last_update_date`) VALUES (1, 1, 1, NULL, NULL, NULL, 1, NULL, 0, NULL, NULL, 0, '2017-07-11 15:18:21', 0, '2017-07-11 15:18:25');
INSERT INTO `order_status` (`order_order_status_id`, `order_info_id`, `order_status_type_id`, `reservation_date`, `reservation_reason`, `cancel_date`, `cancel_reason_id`, `cancel_note`, `delete_flag`, `delete_account_id`, `delete_date`, `create_account_id`, `create_date`, `last_update_account_id`, `last_update_date`) VALUES (3, 2, NULL, NULL, NULL, NULL, 1, NULL, 0, NULL, NULL, 0, '2017-07-11 15:40:22', 0, '2017-07-11 15:40:23');


INSERT INTO `order_shipping_status` (`order_shipping_status_id`, `order_info_id`, `shipping_status_type_id`, `delete_flag`, `delete_account_id`, `delete_date`, `create_account_id`, `create_date`, `last_update_account_id`, `last_update_date`) VALUES (1, 1, 1, 0, NULL, NULL, 0, '2017-07-11 15:17:50', 0, '2017-07-11 15:17:52');
INSERT INTO `order_shipping_status` (`order_shipping_status_id`, `order_info_id`, `shipping_status_type_id`, `delete_flag`, `delete_account_id`, `delete_date`, `create_account_id`, `create_date`, `last_update_account_id`, `last_update_date`) VALUES (3, 2, 1, 0, NULL, NULL, 0, '2017-07-11 15:17:50', 0, '2017-07-11 15:17:52');


INSERT INTO `order_payment_status` (`order_payment_status_id`, `order_info_id`, `payment_status_type_id`, `payment_number`, `delete_flag`, `delete_account_id`, `delete_date`, `create_account_id`, `create_date`, `last_update_account_id`, `last_update_date`) VALUES (1, 1, 1, NULL, 0, NULL, NULL, 0, '2017-07-11 15:02:18', 0, '2017-07-11 15:02:21');
INSERT INTO `order_payment_status` (`order_payment_status_id`, `order_info_id`, `payment_status_type_id`, `payment_number`, `delete_flag`, `delete_account_id`, `delete_date`, `create_account_id`, `create_date`, `last_update_account_id`, `last_update_date`) VALUES (3, 2, 1, NULL, 0, NULL, NULL, 0, '2017-07-11 15:02:18', 0, '2017-07-11 15:02:21');