-- excelmito_test DB

DELETE FROM sms_salesgroup WHERE contact_id="774da38a-1be2-14be-2e87-4e163c4e5358";
DELETE FROM sms_fee WHERE contact_id="774da38a-1be2-14be-2e87-4e163c4e5358";
DELETE FROM sms_transaction WHERE contact_id="774da38a-1be2-14be-2e87-4e163c4e5358";

INSERT INTO `sms_salesgroup` (`id`, `name`, `event_id`, `contact_id`, `account_id`, `type_id`, `occurences`, `occurences_hour`, `deleted`, `date_entered`, `date_modified`, `sell_date`, `modified_user_id`, `created_by`, `basic_fee`, `unit_type`, `unit_no`, `period`, `period_no`, `due_to`, `description`, `applied_contact`, `discount_percentage`, `discount_price`, `salesno`, `bank_account`, `hakkoubi`, `receipt_hakkoubi`, `seikyusaki`, `tantosha`, `item`, `school_code`) VALUES
('2b834371-54b5-ab90-50ab-4e2da31b1e07', '', NULL, '774da38a-1be2-14be-2e87-4e163c4e5358', NULL, NULL, 1, 1, 0, '2011-07-25 17:08:55', '2011-07-25 17:08:55', '0000-00-00 00:00:00', '1', '1', 0, '0', 0, 1, 1, '31', NULL, 0, 0, NULL, '0100000006', NULL, '0000-00-00', NULL, NULL, NULL, NULL, NULL),
('4ea7de14-46cb-5302-2372-4e304da1acde', '', 'ad9459f5-e8c4-ab40-b1b1-4e304bd7d622', '774da38a-1be2-14be-2e87-4e163c4e5358', NULL, NULL, 1, 1, 0, '2011-07-27 17:40:27', '2011-07-27 17:40:27', '0000-00-00 00:00:00', '1', '1', 0, '0', 0, 1, 1, '31', NULL, 0, 0, NULL, '0100000007', NULL, '0000-00-00', NULL, NULL, NULL, NULL, NULL),
('9058b324-d364-23e5-6c2a-4e304d9ae2ec', '', '9e666ed1-a5da-d02c-2aa8-4e304cbd8e77', '774da38a-1be2-14be-2e87-4e163c4e5358', NULL, NULL, 1, 1, 0, '2011-07-27 17:41:00', '2011-07-27 17:41:00', '0000-00-00 00:00:00', '1', '1', 0, '0', 0, 1, 1, '31', NULL, 0, 0, NULL, '0100000008', NULL, '0000-00-00', NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sms_fee` (`id`, `school_id`, `name`, `event_id`, `contact_id`, `account_id`, `type_id`, `deleted`, `date_entered`, `date_modified`, `sell_date`, `modified_user_id`, `created_by`, `basic_fee`, `unit_type`, `unit_no`, `period`, `period_no`, `due_to`, `description`, `applied_contact`, `discount_percentage`, `discount_price`, `salesno`, `start_date`, `end_date`, `product_id`, `product_count`, `ticket_count`, `ticket_valid`, `jikyu_rate`, `event_credit`, `fee_subcategory`, `source_gessha_id`, `next_gessha_applied`) VALUES
('f98209f8-aa8a-d9bf-3029-4e16409830d7', 'sssssss-1111', '受講料', '564106b1-f9e0-9ff6-b3f7-4df6f77b0988', '774da38a-1be2-14be-2e87-4e163c4e5358', NULL, '29', 0, '2011-07-07 23:24:14', '2011-07-07 23:24:14', '2011-07-08 01:00:00', '1', '1', 12000, '0', 1, 1, 0, '3', NULL, 1, 0, NULL, '0100000006', '2011-07-08', '2011-09-06', NULL, 0, 0, 0, '1', NULL, '受講料', NULL, '0'),
('11913035-af38-f231-c812-4e1640112428', 'sssssss-1111', '教材費(講師分)', '564106b1-f9e0-9ff6-b3f7-4df6f77b0988', '774da38a-1be2-14be-2e87-4e163c4e5358', NULL, '29', 0, '2011-07-07 23:24:14', '2011-07-07 23:24:14', '2011-07-08 01:00:00', '1', '1', 3000, '0', 1, 1, 0, '3', NULL, 1, 0, NULL, '0100000006', '2011-07-08', '2011-09-06', NULL, 0, 0, 0, '1', NULL, '教材費(講師)', NULL, '0'),
('138754a0-26ef-93fa-dc2d-4e164011e6a7', 'sssssss-1111', '教材費（カルチャー・スクール）', '564106b1-f9e0-9ff6-b3f7-4df6f77b0988', '774da38a-1be2-14be-2e87-4e163c4e5358', NULL, '29', 0, '2011-07-07 23:24:14', '2011-07-07 23:24:14', '2011-07-08 01:00:00', '1', '1', 6000, '0', 1, 1, 0, '3', NULL, 1, 0, NULL, '0100000006', '2011-07-08', '2011-09-06', NULL, 0, 0, 0, '1', NULL, '教材費(スクール)', NULL, '0'),
('157c9a73-9310-db96-583b-4e16403cc262', 'sssssss-1111', '施設使用料', '564106b1-f9e0-9ff6-b3f7-4df6f77b0988', '774da38a-1be2-14be-2e87-4e163c4e5358', NULL, '29', 0, '2011-07-07 23:24:14', '2011-07-07 23:24:14', '2011-07-08 01:00:00', '1', '1', 100, '0', 1, 1, 0, '3', NULL, 1, 0, NULL, '0100000006', '2011-07-08', '2011-09-06', NULL, 0, 0, 0, '1', NULL, '施設使用料', NULL, '0'),
('178667eb-c637-fad9-ce63-4e1640c0afd9', 'sssssss-1111', '保険料', '564106b1-f9e0-9ff6-b3f7-4df6f77b0988', '774da38a-1be2-14be-2e87-4e163c4e5358', NULL, '29', 0, '2011-07-07 23:24:14', '2011-07-07 23:24:14', '2011-07-08 01:00:00', '1', '1', 10, '0', 1, 1, 0, '3', NULL, 1, 0, NULL, '0100000006', '2011-07-08', '2011-09-06', NULL, 0, 0, 0, '1', NULL, '保険料', NULL, '0'),
('7fb8b3de-c983-99ec-dbe8-4e304d47e3ca', 'sssssss-1111', '受講料', 'ad9459f5-e8c4-ab40-b1b1-4e304bd7d622', '774da38a-1be2-14be-2e87-4e163c4e5358', NULL, '29', 0, '2011-07-27 17:39:48', '2011-07-27 17:39:48', '2011-07-28 01:00:00', '1', '1', 20000, '0', 1, 1, 0, '3', NULL, 1, 0, NULL, '0100000007', '2011-07-28', '2011-09-06', NULL, 0, 0, 0, '1', NULL, '受講料', NULL, '0'),
('81b6e71a-cbcf-17ff-ed48-4e304d125392', 'sssssss-1111', '教材費(講師分)', 'ad9459f5-e8c4-ab40-b1b1-4e304bd7d622', '774da38a-1be2-14be-2e87-4e163c4e5358', NULL, '29', 0, '2011-07-27 17:39:48', '2011-07-27 17:39:48', '2011-07-28 01:00:00', '1', '1', 5000, '0', 1, 1, 0, '3', NULL, 1, 0, NULL, '0100000007', '2011-07-28', '2011-09-06', NULL, 0, 0, 0, '1', NULL, '教材費(講師)', NULL, '0'),
('83b27c67-20f7-a49a-e184-4e304d3d5a31', 'sssssss-1111', '教材費（カルチャー・スクール）', 'ad9459f5-e8c4-ab40-b1b1-4e304bd7d622', '774da38a-1be2-14be-2e87-4e163c4e5358', NULL, '29', 0, '2011-07-27 17:39:48', '2011-07-27 17:39:48', '2011-07-28 01:00:00', '1', '1', 10000, '0', 1, 1, 0, '3', NULL, 1, 0, NULL, '0100000007', '2011-07-28', '2011-09-06', NULL, 0, 0, 0, '1', NULL, '教材費(スクール)', NULL, '0'),
('85a495c3-c0d6-55ed-a314-4e304d4f6ce4', 'sssssss-1111', '施設使用料', 'ad9459f5-e8c4-ab40-b1b1-4e304bd7d622', '774da38a-1be2-14be-2e87-4e163c4e5358', NULL, '29', 0, '2011-07-27 17:39:48', '2011-07-27 17:39:48', '2011-07-28 01:00:00', '1', '1', 140, '0', 1, 1, 0, '3', NULL, 1, 0, NULL, '0100000007', '2011-07-28', '2011-09-06', NULL, 0, 0, 0, '1', NULL, '施設使用料', NULL, '0'),
('87994431-b1d8-2cd9-b7a3-4e304d51a9de', 'sssssss-1111', '保険料', 'ad9459f5-e8c4-ab40-b1b1-4e304bd7d622', '774da38a-1be2-14be-2e87-4e163c4e5358', NULL, '29', 0, '2011-07-27 17:39:48', '2011-07-27 17:39:48', '2011-07-28 01:00:00', '1', '1', 30, '0', 1, 1, 0, '3', NULL, 1, 0, NULL, '0100000007', '2011-07-28', '2011-09-06', NULL, 0, 0, 0, '1', NULL, '保険料', NULL, '0'),
('3d6a2650-f839-decc-c328-4e304dfe585e', 'sssssss-1111', '受講料', '9e666ed1-a5da-d02c-2aa8-4e304cbd8e77', '774da38a-1be2-14be-2e87-4e163c4e5358', NULL, '29', 0, '2011-07-27 17:40:47', '2011-07-27 17:40:47', '2011-07-28 01:00:00', '1', '1', 20000, '0', 1, 1, 0, '3', NULL, 1, 0, NULL, '0100000008', '2011-07-28', '2011-09-06', NULL, 0, 0, 0, '1', NULL, '受講料', NULL, '0'),
('3f9349ca-2b78-3d6a-967c-4e304db38c73', 'sssssss-1111', '教材費(講師分)', '9e666ed1-a5da-d02c-2aa8-4e304cbd8e77', '774da38a-1be2-14be-2e87-4e163c4e5358', NULL, '29', 0, '2011-07-27 17:40:47', '2011-07-27 17:40:47', '2011-07-28 01:00:00', '1', '1', 5000, '0', 1, 1, 0, '3', NULL, 1, 0, NULL, '0100000008', '2011-07-28', '2011-09-06', NULL, 0, 0, 0, '1', NULL, '教材費(講師)', NULL, '0'),
('41ab432b-b120-6ab1-ca75-4e304d8fad9f', 'sssssss-1111', '教材費（カルチャー・スクール）', '9e666ed1-a5da-d02c-2aa8-4e304cbd8e77', '774da38a-1be2-14be-2e87-4e163c4e5358', NULL, '29', 0, '2011-07-27 17:40:47', '2011-07-27 17:40:47', '2011-07-28 01:00:00', '1', '1', 10000, '0', 1, 1, 0, '3', NULL, 1, 0, NULL, '0100000008', '2011-07-28', '2011-09-06', NULL, 0, 0, 0, '1', NULL, '教材費(スクール)', NULL, '0'),
('43bd84d0-20ad-4dd8-1689-4e304d14a14a', 'sssssss-1111', '施設使用料', '9e666ed1-a5da-d02c-2aa8-4e304cbd8e77', '774da38a-1be2-14be-2e87-4e163c4e5358', NULL, '29', 0, '2011-07-27 17:40:47', '2011-07-27 17:40:47', '2011-07-28 01:00:00', '1', '1', 140, '0', 1, 1, 0, '3', NULL, 1, 0, NULL, '0100000008', '2011-07-28', '2011-09-06', NULL, 0, 0, 0, '1', NULL, '施設使用料', NULL, '0'),
('45dcdfac-333d-9c9b-577b-4e304ddc5e10', 'sssssss-1111', '保険料', '9e666ed1-a5da-d02c-2aa8-4e304cbd8e77', '774da38a-1be2-14be-2e87-4e163c4e5358', NULL, '29', 0, '2011-07-27 17:40:47', '2011-07-27 17:40:47', '2011-07-28 01:00:00', '1', '1', 30, '0', 1, 1, 0, '3', NULL, 1, 0, NULL, '0100000008', '2011-07-28', '2011-09-06', NULL, 0, 0, 0, '1', NULL, '保険料', NULL, '0');

INSERT INTO `sms_transaction` (`id`, `fee_id`, `type_id`, `document_id`, `deleted`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, `sell_date`, `due_date`, `t_date`, `in_amount`, `out_amount`, `actual_in_amount`, `actual_out_amount`, `commission`, `actual`, `contact_id`, `account_id`, `event_id`, `payment_type`, `bank_account_id`, `description`, `salesno`) VALUES
('3950c23d-c2dd-f164-b868-4e2da33937be', 'f98209f8-aa8a-d9bf-3029-4e16409830d7', '29', NULL, 0, '2011-07-25 17:08:00', '2011-07-27 19:49:54', '1', '1', '2011-07-08 01:00:00', '2011-07-11 01:00:00', '2011-07-05 01:00:00', 10000, 0, 10000, 0, 0, 0, '774da38a-1be2-14be-2e87-4e163c4e5358', NULL, '564106b1-f9e0-9ff6-b3f7-4df6f77b0988', 'transfer', NULL, '受講料', '0100000006'),
('43312b41-9d31-ebb0-ca0f-4e2da391a8f2', '11913035-af38-f231-c812-4e1640112428', '29', NULL, 0, '2011-07-25 17:08:00', '2011-07-27 19:49:54', '1', '1', '2011-07-08 01:00:00', '2011-07-11 01:00:00', '0000-00-00 00:00:00', 3000, 0, 0, 0, 0, 0, '774da38a-1be2-14be-2e87-4e163c4e5358', NULL, '564106b1-f9e0-9ff6-b3f7-4df6f77b0988', 'transfer', NULL, '教材費(講師分)', '0100000006'),
('4d7c641c-7ce7-9421-7e7d-4e2da313e12f', '138754a0-26ef-93fa-dc2d-4e164011e6a7', '29', NULL, 0, '2011-07-25 17:08:00', '2011-07-27 19:49:54', '1', '1', '2011-07-08 01:00:00', '2011-07-11 01:00:00', '0000-00-00 00:00:00', 6000, 0, 0, 0, 0, 0, '774da38a-1be2-14be-2e87-4e163c4e5358', NULL, '564106b1-f9e0-9ff6-b3f7-4df6f77b0988', 'transfer', NULL, '教材費（カルチャー・スクール）', '0100000006'),
('57c652cb-52eb-5948-9df9-4e2da39aceeb', '157c9a73-9310-db96-583b-4e16403cc262', '29', NULL, 0, '2011-07-25 17:08:00', '2011-07-27 19:49:54', '1', '1', '2011-07-08 01:00:00', '2011-07-11 01:00:00', '0000-00-00 00:00:00', 100, 0, 0, 0, 0, 0, '774da38a-1be2-14be-2e87-4e163c4e5358', NULL, '564106b1-f9e0-9ff6-b3f7-4df6f77b0988', 'transfer', NULL, '施設使用料', '0100000006'),
('61c03f16-38f3-5bed-7a9b-4e2da3dfc14e', '178667eb-c637-fad9-ce63-4e1640c0afd9', '29', NULL, 0, '2011-07-25 17:08:00', '2011-07-27 19:49:54', '1', '1', '2011-07-08 01:00:00', '2011-07-11 01:00:00', '0000-00-00 00:00:00', 10, 0, 0, 0, 0, 0, '774da38a-1be2-14be-2e87-4e163c4e5358', NULL, '564106b1-f9e0-9ff6-b3f7-4df6f77b0988', 'transfer', NULL, '保険料', '0100000006'),
('5310d0f3-66d8-5795-2a65-4e304d122194', '7fb8b3de-c983-99ec-dbe8-4e304d47e3ca', '29', NULL, 0, '2011-07-27 17:40:00', '2011-07-27 17:40:00', '1', '1', '2011-07-28 01:00:00', '2011-07-31 01:00:00', '0000-00-00 00:00:00', 20000, 0, 0, 0, 0, 0, '774da38a-1be2-14be-2e87-4e163c4e5358', NULL, 'ad9459f5-e8c4-ab40-b1b1-4e304bd7d622', NULL, NULL, '受講料', '0100000007'),
('5854dd53-1b49-fd17-a9fb-4e304db9560d', '81b6e71a-cbcf-17ff-ed48-4e304d125392', '29', NULL, 0, '2011-07-27 17:40:00', '2011-07-27 17:40:00', '1', '1', '2011-07-28 01:00:00', '2011-07-31 01:00:00', '0000-00-00 00:00:00', 5000, 0, 0, 0, 0, 0, '774da38a-1be2-14be-2e87-4e163c4e5358', NULL, 'ad9459f5-e8c4-ab40-b1b1-4e304bd7d622', NULL, NULL, '教材費(講師分)', '0100000007'),
('5d81367b-12c2-1a6f-5051-4e304db16dad', '83b27c67-20f7-a49a-e184-4e304d3d5a31', '29', NULL, 0, '2011-07-27 17:40:00', '2011-07-27 17:40:00', '1', '1', '2011-07-28 01:00:00', '2011-07-31 01:00:00', '0000-00-00 00:00:00', 10000, 0, 0, 0, 0, 0, '774da38a-1be2-14be-2e87-4e163c4e5358', NULL, 'ad9459f5-e8c4-ab40-b1b1-4e304bd7d622', NULL, NULL, '教材費（カルチャー・スクール）', '0100000007'),
('62a703a2-670e-2f9a-a21e-4e304df428ec', '85a495c3-c0d6-55ed-a314-4e304d4f6ce4', '29', NULL, 0, '2011-07-27 17:40:00', '2011-07-27 17:40:00', '1', '1', '2011-07-28 01:00:00', '2011-07-31 01:00:00', '0000-00-00 00:00:00', 140, 0, 0, 0, 0, 0, '774da38a-1be2-14be-2e87-4e163c4e5358', NULL, 'ad9459f5-e8c4-ab40-b1b1-4e304bd7d622', NULL, NULL, '施設使用料', '0100000007'),
('68129117-4fba-a260-82e3-4e304d743820', '87994431-b1d8-2cd9-b7a3-4e304d51a9de', '29', NULL, 0, '2011-07-27 17:40:00', '2011-07-27 17:40:00', '1', '1', '2011-07-28 01:00:00', '2011-07-31 01:00:00', '0000-00-00 00:00:00', 30, 0, 0, 0, 0, 0, '774da38a-1be2-14be-2e87-4e163c4e5358', NULL, 'ad9459f5-e8c4-ab40-b1b1-4e304bd7d622', NULL, NULL, '保険料', '0100000007'),
('95a7db9e-00ae-0064-dce5-4e304d4dcfa8', '3d6a2650-f839-decc-c328-4e304dfe585e', '29', NULL, 0, '2011-07-27 17:41:00', '2011-07-27 18:11:22', '1', '1', '2011-07-28 01:00:00', '2011-07-31 01:00:00', '2011-07-01 01:00:00', 20000, 0, 20000, 0, 0, 0, '774da38a-1be2-14be-2e87-4e163c4e5358', NULL, '9e666ed1-a5da-d02c-2aa8-4e304cbd8e77', 'cash', NULL, '受講料', '0100000008'),
('9b99d3ee-c688-01bc-21df-4e304db689a9', '3f9349ca-2b78-3d6a-967c-4e304db38c73', '29', NULL, 0, '2011-07-27 17:41:00', '2011-07-27 18:11:22', '1', '1', '2011-07-28 01:00:00', '2011-07-31 01:00:00', '2011-07-01 01:00:00', 5000, 0, 5000, 0, 0, 0, '774da38a-1be2-14be-2e87-4e163c4e5358', NULL, '9e666ed1-a5da-d02c-2aa8-4e304cbd8e77', 'cash', NULL, '教材費(講師分)', '0100000008'),
('a19bd579-a2ab-c202-11e9-4e304ddf8cec', '41ab432b-b120-6ab1-ca75-4e304d8fad9f', '29', NULL, 0, '2011-07-27 17:41:00', '2011-07-27 18:11:22', '1', '1', '2011-07-28 01:00:00', '2011-07-31 01:00:00', '2011-07-01 01:00:00', 5000, 0, 5000, 0, 0, 0, '774da38a-1be2-14be-2e87-4e163c4e5358', NULL, '9e666ed1-a5da-d02c-2aa8-4e304cbd8e77', 'cash', NULL, '教材費（カルチャー・スクール）', '0100000008'),
('a7e2936b-f25c-bd4b-6755-4e304d19a5da', '43bd84d0-20ad-4dd8-1689-4e304d14a14a', '29', NULL, 0, '2011-07-27 17:41:00', '2011-07-27 18:11:22', '1', '1', '2011-07-28 01:00:00', '2011-07-31 01:00:00', '2011-07-28 01:00:00', 140, 0, 140, 0, 0, 0, '774da38a-1be2-14be-2e87-4e163c4e5358', NULL, '9e666ed1-a5da-d02c-2aa8-4e304cbd8e77', 'transfer', NULL, '施設使用料', '0100000008'),
('addffd8c-0e3d-445d-1821-4e304d33227f', '45dcdfac-333d-9c9b-577b-4e304ddc5e10', '29', NULL, 0, '2011-07-27 17:41:00', '2011-07-27 18:11:22', '1', '1', '2011-07-28 01:00:00', '2011-07-31 01:00:00', '2011-07-28 01:00:00', 30, 0, 30, 0, 0, 0, '774da38a-1be2-14be-2e87-4e163c4e5358', NULL, '9e666ed1-a5da-d02c-2aa8-4e304cbd8e77', 'transfer', NULL, '保険料', '0100000008'),
('c594f8de-2c83-6200-f6a6-4e3054c98bea', '41ab432b-b120-6ab1-ca75-4e304d8fad9f', '29', NULL, 0, '2011-07-28 02:41:00', '2011-07-27 18:11:23', '1', '1', '2011-07-28 01:00:00', '2011-07-31 01:00:00', '2011-07-28 01:00:00', 5000, 0, 5000, 0, 0, 0, '774da38a-1be2-14be-2e87-4e163c4e5358', NULL, '9e666ed1-a5da-d02c-2aa8-4e304cbd8e77', 'transfer', NULL, '教材費（カルチャー・スクール）', '0100000008'),
('c1efbd3a-dd97-327d-3d98-4e306b85b7af', 'f98209f8-aa8a-d9bf-3029-4e16409830d7', '29', NULL, 0, '2011-07-26 02:08:00', '2011-07-27 19:49:54', '1', '1', '2011-07-08 01:00:00', '2011-07-11 01:00:00', '0000-00-00 00:00:00', 2000, 0, 0, 0, 0, 0, '774da38a-1be2-14be-2e87-4e163c4e5358', NULL, '564106b1-f9e0-9ff6-b3f7-4df6f77b0988', 'transfer', NULL, '受講料', '0100000006');