-- 配送地域を登録
INSERT INTO `wp_woocommerce_shipping_zones` (`zone_id`, `zone_name`, `zone_order`) VALUES
(1, '北海道', 0),
(2, '東北', 0),
(3, '関東', 0),
(4, '甲信越', 0),
(5, '北陸', 0),
(6, '東海', 0),
(7, '関西', 0),
(8, '中国', 0),
(9, '四国', 0),
(10, '九州', 0),
(11, '沖縄', 0);
-- 各配送地域に地域(都道府県)を登録
INSERT INTO `wp_woocommerce_shipping_zone_locations` (`location_id`, `zone_id`, `location_code`, `location_type`) VALUES
(1, 1, 'JP:JP01', 'state'),
(2, 2, 'JP:JP02', 'state'),
(3, 2, 'JP:JP03', 'state'),
(4, 2, 'JP:JP04', 'state'),
(5, 2, 'JP:JP05', 'state'),
(6, 2, 'JP:JP06', 'state'),
(7, 2, 'JP:JP07', 'state'),
(8, 3, 'JP:JP08', 'state'),
(9, 3, 'JP:JP09', 'state'),
(10, 3, 'JP:JP10', 'state'),
(11, 3, 'JP:JP11', 'state'),
(12, 3, 'JP:JP12', 'state'),
(13, 3, 'JP:JP13', 'state'),
(14, 3, 'JP:JP14', 'state'),
(15, 4, 'JP:JP15', 'state'),
(16, 4, 'JP:JP19', 'state'),
(17, 4, 'JP:JP20', 'state'),
(18, 5, 'JP:JP16', 'state'),
(19, 5, 'JP:JP17', 'state'),
(20, 5, 'JP:JP18', 'state'),
(21, 6, 'JP:JP21', 'state'),
(22, 6, 'JP:JP22', 'state'),
(23, 6, 'JP:JP23', 'state'),
(24, 6, 'JP:JP24', 'state'),
(25, 7, 'JP:JP25', 'state'),
(26, 7, 'JP:JP26', 'state'),
(27, 7, 'JP:JP27', 'state'),
(28, 7, 'JP:JP28', 'state'),
(29, 7, 'JP:JP29', 'state'),
(30, 7, 'JP:JP30', 'state'),
(31, 8, 'JP:JP31', 'state'),
(32, 8, 'JP:JP32', 'state'),
(33, 8, 'JP:JP33', 'state'),
(34, 8, 'JP:JP34', 'state'),
(35, 8, 'JP:JP35', 'state'),
(36, 9, 'JP:JP36', 'state'),
(37, 9, 'JP:JP37', 'state'),
(38, 9, 'JP:JP38', 'state'),
(39, 9, 'JP:JP39', 'state'),
(40, 10, 'JP:JP40', 'state'),
(41, 10, 'JP:JP41', 'state'),
(42, 10, 'JP:JP42', 'state'),
(43, 10, 'JP:JP43', 'state'),
(44, 10, 'JP:JP44', 'state'),
(45, 10, 'JP:JP45', 'state'),
(46, 10, 'JP:JP46', 'state'),
(47, 11, 'JP:JP47', 'state');
-- 各配送地域に配送方法(定額送料)を登録
INSERT INTO `wp_woocommerce_shipping_zone_methods` (`zone_id`, `instance_id`, `method_id`, `method_order`, `is_enabled`) VALUES
(1, 1, 'flat_rate', 1, 1),
(2, 2, 'flat_rate', 1, 1),
(3, 3, 'flat_rate', 1, 1),
(4, 4, 'flat_rate', 1, 1),
(5, 5, 'flat_rate', 1, 1),
(6, 6, 'flat_rate', 1, 1),
(7, 7, 'flat_rate', 1, 1),
(8, 8, 'flat_rate', 1, 1),
(9, 9, 'flat_rate', 1, 1),
(10, 10, 'flat_rate', 1, 1),
(11, 11, 'flat_rate', 1, 1);