<?php
declare(strict_types=1);
namespace DoctrineMigrations;
use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;
/**
* Auto-generated Migration: Please modify to your needs!
*/
final class Version20240506064848 extends AbstractMigration
{
public function getDescription(): string
{
return '';
}
public function up(Schema $schema): void
{
// EC-CUBEの初期データを削除
$this->addSql('SET FOREIGN_KEY_CHECKS=0');
$this->addSql('DELETE FROM dtb_delivery_fee WHERE 1');
$this->addSql('DELETE FROM dtb_payment_option WHERE 1');
$this->addSql('DELETE FROM dtb_delivery WHERE 1');
$this->addSql('SET FOREIGN_KEY_CHECKS=1');
// 配送方法
$this->addSql("INSERT INTO dtb_delivery (id, creator_id, sale_type_id, name, service_name, description, confirm_url, sort_no, visible, create_date, update_date, discriminator_type) VALUES
(1, NULL, 1, 'レターパック(ポスト投函)', 'L1', NULL, NULL, 1, 1, NOW(), NOW(), 'delivery'),
(2, NULL, 1, 'まるた急行(西濃運輸)', 'M1', NULL, NULL, 2, 1, NOW(), NOW(), 'delivery'),
(3, NULL, 1, 'まるた急行(西濃運輸)', 'M2', NULL, NULL, 3, 1, NOW(), NOW(), 'delivery'),
(4, NULL, 1, 'まるた急行(西濃運輸)', 'M4', NULL, NULL, 4, 1, NOW(), NOW(), 'delivery'),
(5, NULL, 1, 'まるた急行(西濃運輸)', 'M5', NULL, NULL, 5, 1, NOW(), NOW(), 'delivery'),
(6, NULL, 1, 'まるた急行(西濃運輸)', 'M6', NULL, NULL, 6, 1, NOW(), NOW(), 'delivery'),
(7, NULL, 1, 'まるた急行(西濃運輸)', 'M7', NULL, NULL, 7, 1, NOW(), NOW(), 'delivery'),
(8, NULL, 1, 'まるた急行(西濃運輸)', 'M8', NULL, NULL, 8, 1, NOW(), NOW(), 'delivery'),
(9, NULL, 1, '新潟運輸', 'N1', NULL, NULL, 9, 1, NOW(), NOW(), 'delivery'),
(10, NULL, 1, '新潟運輸', 'N2', NULL, NULL, 10, 1, NOW(), NOW(), 'delivery'),
(11, NULL, 1, '新潟運輸', 'N5', NULL, NULL, 11, 1, NOW(), NOW(), 'delivery'),
(12, NULL, 1, '新潟運輸', 'N6', NULL, NULL, 12, 1, NOW(), NOW(), 'delivery'),
(13, NULL, 1, '新潟運輸', 'N8', NULL, NULL, 13, 1, NOW(), NOW(), 'delivery'),
(14, NULL, 1, '佐川急便', 'S1', NULL, NULL, 14, 1, NOW(), NOW(), 'delivery'),
(15, NULL, 1, '佐川急便', 'S2', NULL, NULL, 15, 1, NOW(), NOW(), 'delivery'),
(16, NULL, 1, '佐川急便', 'S3', NULL, NULL, 16, 1, NOW(), NOW(), 'delivery'),
(17, NULL, 1, '三八五流通(チャーター)', 'T1', NULL, NULL, 17, 1, NOW(), NOW(), 'delivery'),
(18, NULL, 1, '三八五流通(チャーター)', 'T2', NULL, NULL, 18, 1, NOW(), NOW(), 'delivery');
");
// 配送方法ごとの取り扱う支払方法
$this->addSql("INSERT INTO dtb_payment_option (delivery_id, payment_id, discriminator_type) VALUES
(1, 1, 'paymentoption'),
(1, 2, 'paymentoption'),
(1, 3, 'paymentoption'),
(1, 4, 'paymentoption'),
(2, 1, 'paymentoption'),
(2, 2, 'paymentoption'),
(2, 3, 'paymentoption'),
(2, 4, 'paymentoption'),
(3, 1, 'paymentoption'),
(3, 2, 'paymentoption'),
(3, 3, 'paymentoption'),
(3, 4, 'paymentoption'),
(4, 1, 'paymentoption'),
(4, 2, 'paymentoption'),
(4, 3, 'paymentoption'),
(4, 4, 'paymentoption'),
(5, 1, 'paymentoption'),
(5, 2, 'paymentoption'),
(5, 3, 'paymentoption'),
(5, 4, 'paymentoption'),
(6, 1, 'paymentoption'),
(6, 2, 'paymentoption'),
(6, 3, 'paymentoption'),
(6, 4, 'paymentoption'),
(7, 1, 'paymentoption'),
(7, 2, 'paymentoption'),
(7, 3, 'paymentoption'),
(7, 4, 'paymentoption'),
(8, 1, 'paymentoption'),
(8, 2, 'paymentoption'),
(8, 3, 'paymentoption'),
(8, 4, 'paymentoption'),
(9, 1, 'paymentoption'),
(9, 2, 'paymentoption'),
(9, 3, 'paymentoption'),
(9, 4, 'paymentoption'),
(10, 1, 'paymentoption'),
(10, 2, 'paymentoption'),
(10, 3, 'paymentoption'),
(10, 4, 'paymentoption'),
(11, 1, 'paymentoption'),
(11, 2, 'paymentoption'),
(11, 3, 'paymentoption'),
(11, 4, 'paymentoption'),
(12, 1, 'paymentoption'),
(12, 2, 'paymentoption'),
(12, 3, 'paymentoption'),
(12, 4, 'paymentoption'),
(13, 1, 'paymentoption'),
(13, 2, 'paymentoption'),
(13, 3, 'paymentoption'),
(13, 4, 'paymentoption'),
(14, 1, 'paymentoption'),
(14, 2, 'paymentoption'),
(14, 3, 'paymentoption'),
(14, 4, 'paymentoption'),
(15, 1, 'paymentoption'),
(15, 2, 'paymentoption'),
(15, 3, 'paymentoption'),
(15, 4, 'paymentoption'),
(16, 1, 'paymentoption'),
(16, 2, 'paymentoption'),
(16, 3, 'paymentoption'),
(16, 4, 'paymentoption'),
(17, 1, 'paymentoption'),
(17, 2, 'paymentoption'),
(17, 3, 'paymentoption'),
(17, 4, 'paymentoption'),
(18, 1, 'paymentoption'),
(18, 2, 'paymentoption'),
(18, 3, 'paymentoption'),
(18, 4, 'paymentoption')
");
// 配送方法ごとの都道府県別送料設定
$this->addSql("INSERT INTO dtb_delivery_fee (id, delivery_id, pref_id, fee, discriminator_type) VALUES
(1, 1, 1, 370, 'deliveryfee'),
(2, 1, 2, 370, 'deliveryfee'),
(3, 1, 3, 370, 'deliveryfee'),
(4, 1, 4, 370, 'deliveryfee'),
(5, 1, 5, 370, 'deliveryfee'),
(6, 1, 6, 370, 'deliveryfee'),
(7, 1, 7, 370, 'deliveryfee'),
(8, 1, 8, 370, 'deliveryfee'),
(9, 1, 9, 370, 'deliveryfee'),
(10, 1, 10, 370, 'deliveryfee'),
(11, 1, 11, 370, 'deliveryfee'),
(12, 1, 12, 370, 'deliveryfee'),
(13, 1, 13, 370, 'deliveryfee'),
(14, 1, 14, 370, 'deliveryfee'),
(15, 1, 15, 370, 'deliveryfee'),
(16, 1, 16, 370, 'deliveryfee'),
(17, 1, 17, 370, 'deliveryfee'),
(18, 1, 18, 370, 'deliveryfee'),
(19, 1, 19, 370, 'deliveryfee'),
(20, 1, 20, 370, 'deliveryfee'),
(21, 1, 21, 370, 'deliveryfee'),
(22, 1, 22, 370, 'deliveryfee'),
(23, 1, 23, 370, 'deliveryfee'),
(24, 1, 24, 370, 'deliveryfee'),
(25, 1, 25, 370, 'deliveryfee'),
(26, 1, 26, 370, 'deliveryfee'),
(27, 1, 27, 370, 'deliveryfee'),
(28, 1, 28, 370, 'deliveryfee'),
(29, 1, 29, 370, 'deliveryfee'),
(30, 1, 30, 370, 'deliveryfee'),
(31, 1, 31, 370, 'deliveryfee'),
(32, 1, 32, 370, 'deliveryfee'),
(33, 1, 33, 370, 'deliveryfee'),
(34, 1, 34, 370, 'deliveryfee'),
(35, 1, 35, 370, 'deliveryfee'),
(36, 1, 36, 370, 'deliveryfee'),
(37, 1, 37, 370, 'deliveryfee'),
(38, 1, 38, 370, 'deliveryfee'),
(39, 1, 39, 370, 'deliveryfee'),
(40, 1, 40, 370, 'deliveryfee'),
(41, 1, 41, 370, 'deliveryfee'),
(42, 1, 42, 370, 'deliveryfee'),
(43, 1, 43, 370, 'deliveryfee'),
(44, 1, 44, 370, 'deliveryfee'),
(45, 1, 45, 370, 'deliveryfee'),
(46, 1, 46, 370, 'deliveryfee'),
(47, 1, 47, 0, 'deliveryfee')
;");
$this->addSql("INSERT INTO dtb_delivery_fee (id, delivery_id, pref_id, fee, discriminator_type) VALUES
(48, 2, 1, 3000, 'deliveryfee'),
(49, 2, 2, 3000, 'deliveryfee'),
(50, 2, 3, 3000, 'deliveryfee'),
(51, 2, 4, 3000, 'deliveryfee'),
(52, 2, 5, 3000, 'deliveryfee'),
(53, 2, 6, 3000, 'deliveryfee'),
(54, 2, 7, 3000, 'deliveryfee'),
(55, 2, 8, 3000, 'deliveryfee'),
(56, 2, 9, 3000, 'deliveryfee'),
(57, 2, 10, 3000, 'deliveryfee'),
(58, 2, 11, 3000, 'deliveryfee'),
(59, 2, 12, 3000, 'deliveryfee'),
(60, 2, 13, 3000, 'deliveryfee'),
(61, 2, 14, 3000, 'deliveryfee'),
(62, 2, 15, 3000, 'deliveryfee'),
(63, 2, 16, 3000, 'deliveryfee'),
(64, 2, 17, 3000, 'deliveryfee'),
(65, 2, 18, 3000, 'deliveryfee'),
(66, 2, 19, 3000, 'deliveryfee'),
(67, 2, 20, 3000, 'deliveryfee'),
(68, 2, 21, 3000, 'deliveryfee'),
(69, 2, 22, 3000, 'deliveryfee'),
(70, 2, 23, 3000, 'deliveryfee'),
(71, 2, 24, 3000, 'deliveryfee'),
(72, 2, 25, 3000, 'deliveryfee'),
(73, 2, 26, 3000, 'deliveryfee'),
(74, 2, 27, 3000, 'deliveryfee'),
(75, 2, 28, 3000, 'deliveryfee'),
(76, 2, 29, 3000, 'deliveryfee'),
(77, 2, 30, 3000, 'deliveryfee'),
(78, 2, 31, 3000, 'deliveryfee'),
(79, 2, 32, 3000, 'deliveryfee'),
(80, 2, 33, 3000, 'deliveryfee'),
(81, 2, 34, 3000, 'deliveryfee'),
(82, 2, 35, 3000, 'deliveryfee'),
(83, 2, 36, 3000, 'deliveryfee'),
(84, 2, 37, 3000, 'deliveryfee'),
(85, 2, 38, 3000, 'deliveryfee'),
(86, 2, 39, 3000, 'deliveryfee'),
(87, 2, 40, 3000, 'deliveryfee'),
(88, 2, 41, 3000, 'deliveryfee'),
(89, 2, 42, 3000, 'deliveryfee'),
(90, 2, 43, 3000, 'deliveryfee'),
(91, 2, 44, 3000, 'deliveryfee'),
(92, 2, 45, 3000, 'deliveryfee'),
(93, 2, 46, 3000, 'deliveryfee'),
(94, 2, 47, 0, 'deliveryfee')
;");
$this->addSql("INSERT INTO dtb_delivery_fee (id, delivery_id, pref_id, fee, discriminator_type) VALUES
(95, 3, 1, 5000, 'deliveryfee'),
(96, 3, 2, 5000, 'deliveryfee'),
(97, 3, 3, 5000, 'deliveryfee'),
(98, 3, 4, 5000, 'deliveryfee'),
(99, 3, 5, 5000, 'deliveryfee'),
(100, 3, 6, 5000, 'deliveryfee'),
(101, 3, 7, 5000, 'deliveryfee'),
(102, 3, 8, 5000, 'deliveryfee'),
(103, 3, 9, 5000, 'deliveryfee'),
(104, 3, 10, 5000, 'deliveryfee'),
(105, 3, 11, 5000, 'deliveryfee'),
(106, 3, 12, 5000, 'deliveryfee'),
(107, 3, 13, 5000, 'deliveryfee'),
(108, 3, 14, 5000, 'deliveryfee'),
(109, 3, 15, 5000, 'deliveryfee'),
(110, 3, 16, 5000, 'deliveryfee'),
(111, 3, 17, 5000, 'deliveryfee'),
(112, 3, 18, 5000, 'deliveryfee'),
(113, 3, 19, 5000, 'deliveryfee'),
(114, 3, 20, 5000, 'deliveryfee'),
(115, 3, 21, 5000, 'deliveryfee'),
(116, 3, 22, 5000, 'deliveryfee'),
(117, 3, 23, 5000, 'deliveryfee'),
(118, 3, 24, 5000, 'deliveryfee'),
(119, 3, 25, 5000, 'deliveryfee'),
(120, 3, 26, 5000, 'deliveryfee'),
(121, 3, 27, 5000, 'deliveryfee'),
(122, 3, 28, 5000, 'deliveryfee'),
(123, 3, 29, 5000, 'deliveryfee'),
(124, 3, 30, 5000, 'deliveryfee'),
(125, 3, 31, 5000, 'deliveryfee'),
(126, 3, 32, 5000, 'deliveryfee'),
(127, 3, 33, 5000, 'deliveryfee'),
(128, 3, 34, 5000, 'deliveryfee'),
(129, 3, 35, 5000, 'deliveryfee'),
(130, 3, 36, 5000, 'deliveryfee'),
(131, 3, 37, 5000, 'deliveryfee'),
(132, 3, 38, 5000, 'deliveryfee'),
(133, 3, 39, 5000, 'deliveryfee'),
(134, 3, 40, 5000, 'deliveryfee'),
(135, 3, 41, 5000, 'deliveryfee'),
(136, 3, 42, 5000, 'deliveryfee'),
(137, 3, 43, 5000, 'deliveryfee'),
(138, 3, 44, 5000, 'deliveryfee'),
(139, 3, 45, 5000, 'deliveryfee'),
(140, 3, 46, 5000, 'deliveryfee'),
(141, 3, 47, 0, 'deliveryfee')
;");
$this->addSql("INSERT INTO dtb_delivery_fee (id, delivery_id, pref_id, fee, discriminator_type) VALUES
(142, 4, 1, 3300, 'deliveryfee'),
(143, 4, 2, 2890, 'deliveryfee'),
(144, 4, 3, 2890, 'deliveryfee'),
(145, 4, 4, 2990, 'deliveryfee'),
(146, 4, 5, 2890, 'deliveryfee'),
(147, 4, 6, 2990, 'deliveryfee'),
(148, 4, 7, 2990, 'deliveryfee'),
(149, 4, 8, 3100, 'deliveryfee'),
(150, 4, 9, 3100, 'deliveryfee'),
(151, 4, 10, 3100, 'deliveryfee'),
(152, 4, 11, 3100, 'deliveryfee'),
(153, 4, 12, 3100, 'deliveryfee'),
(154, 4, 13, 3100, 'deliveryfee'),
(155, 4, 14, 3100, 'deliveryfee'),
(156, 4, 15, 3100, 'deliveryfee'),
(157, 4, 16, 3200, 'deliveryfee'),
(158, 4, 17, 3200, 'deliveryfee'),
(159, 4, 18, 3200, 'deliveryfee'),
(160, 4, 19, 3200, 'deliveryfee'),
(161, 4, 20, 3100, 'deliveryfee'),
(162, 4, 21, 3200, 'deliveryfee'),
(163, 4, 22, 3200, 'deliveryfee'),
(164, 4, 23, 3200, 'deliveryfee'),
(165, 4, 24, 3310, 'deliveryfee'),
(166, 4, 25, 3310, 'deliveryfee'),
(167, 4, 26, 3310, 'deliveryfee'),
(168, 4, 27, 3310, 'deliveryfee'),
(169, 4, 28, 3310, 'deliveryfee'),
(170, 4, 29, 3310, 'deliveryfee'),
(171, 4, 30, 3310, 'deliveryfee'),
(172, 4, 31, 3530, 'deliveryfee'),
(173, 4, 32, 3530, 'deliveryfee'),
(174, 4, 33, 3530, 'deliveryfee'),
(175, 4, 34, 3530, 'deliveryfee'),
(176, 4, 35, 3530, 'deliveryfee'),
(177, 4, 36, 3620, 'deliveryfee'),
(178, 4, 37, 3620, 'deliveryfee'),
(179, 4, 38, 3620, 'deliveryfee'),
(180, 4, 39, 3620, 'deliveryfee'),
(181, 4, 40, 3640, 'deliveryfee'),
(182, 4, 41, 3640, 'deliveryfee'),
(183, 4, 42, 3850, 'deliveryfee'),
(184, 4, 43, 3850, 'deliveryfee'),
(185, 4, 44, 3640, 'deliveryfee'),
(186, 4, 45, 3850, 'deliveryfee'),
(187, 4, 46, 3850, 'deliveryfee'),
(188, 4, 47, 0, 'deliveryfee')
;");
$this->addSql("INSERT INTO dtb_delivery_fee (id, delivery_id, pref_id, fee, discriminator_type) VALUES
(189, 5, 1, 3570, 'deliveryfee'),
(190, 5, 2, 2990, 'deliveryfee'),
(191, 5, 3, 2990, 'deliveryfee'),
(192, 5, 4, 3100, 'deliveryfee'),
(193, 5, 5, 2990, 'deliveryfee'),
(194, 5, 6, 3100, 'deliveryfee'),
(195, 5, 7, 3100, 'deliveryfee'),
(196, 5, 8, 3310, 'deliveryfee'),
(197, 5, 9, 3310, 'deliveryfee'),
(198, 5, 10, 3310, 'deliveryfee'),
(199, 5, 11, 3310, 'deliveryfee'),
(200, 5, 12, 3310, 'deliveryfee'),
(201, 5, 13, 3310, 'deliveryfee'),
(202, 5, 14, 3310, 'deliveryfee'),
(203, 5, 15, 3310, 'deliveryfee'),
(204, 5, 16, 3410, 'deliveryfee'),
(205, 5, 17, 3410, 'deliveryfee'),
(206, 5, 18, 3410, 'deliveryfee'),
(207, 5, 19, 3410, 'deliveryfee'),
(208, 5, 20, 3310, 'deliveryfee'),
(209, 5, 21, 3410, 'deliveryfee'),
(210, 5, 22, 3410, 'deliveryfee'),
(211, 5, 23, 3410, 'deliveryfee'),
(212, 5, 24, 3620, 'deliveryfee'),
(213, 5, 25, 3620, 'deliveryfee'),
(214, 5, 26, 3620, 'deliveryfee'),
(215, 5, 27, 3620, 'deliveryfee'),
(216, 5, 28, 3620, 'deliveryfee'),
(217, 5, 29, 3620, 'deliveryfee'),
(218, 5, 30, 3620, 'deliveryfee'),
(219, 5, 31, 3840, 'deliveryfee'),
(220, 5, 32, 3840, 'deliveryfee'),
(221, 5, 33, 3840, 'deliveryfee'),
(222, 5, 34, 3840, 'deliveryfee'),
(223, 5, 35, 3840, 'deliveryfee'),
(224, 5, 36, 3970, 'deliveryfee'),
(225, 5, 37, 3970, 'deliveryfee'),
(226, 5, 38, 3970, 'deliveryfee'),
(227, 5, 39, 3970, 'deliveryfee'),
(228, 5, 40, 2950, 'deliveryfee'),
(229, 5, 41, 2950, 'deliveryfee'),
(230, 5, 42, 3060, 'deliveryfee'),
(231, 5, 43, 3060, 'deliveryfee'),
(232, 5, 44, 2950, 'deliveryfee'),
(233, 5, 45, 3060, 'deliveryfee'),
(234, 5, 46, 3060, 'deliveryfee'),
(235, 5, 47, 0, 'deliveryfee')
;");
$this->addSql("INSERT INTO dtb_delivery_fee (id, delivery_id, pref_id, fee, discriminator_type) VALUES
(236, 6, 1, 6670, 'deliveryfee'),
(237, 6, 2, 5580, 'deliveryfee'),
(238, 6, 3, 5580, 'deliveryfee'),
(239, 6, 4, 5890, 'deliveryfee'),
(240, 6, 5, 5580, 'deliveryfee'),
(241, 6, 6, 5890, 'deliveryfee'),
(242, 6, 7, 5890, 'deliveryfee'),
(243, 6, 8, 6200, 'deliveryfee'),
(244, 6, 9, 6200, 'deliveryfee'),
(245, 6, 10, 6200, 'deliveryfee'),
(246, 6, 11, 6310, 'deliveryfee'),
(247, 6, 12, 6310, 'deliveryfee'),
(248, 6, 13, 6310, 'deliveryfee'),
(249, 6, 14, 6310, 'deliveryfee'),
(250, 6, 15, 6210, 'deliveryfee'),
(251, 6, 16, 6420, 'deliveryfee'),
(252, 6, 17, 6420, 'deliveryfee'),
(253, 6, 18, 6420, 'deliveryfee'),
(254, 6, 19, 6520, 'deliveryfee'),
(255, 6, 20, 6210, 'deliveryfee'),
(256, 6, 21, 6520, 'deliveryfee'),
(257, 6, 22, 6520, 'deliveryfee'),
(258, 6, 23, 6520, 'deliveryfee'),
(259, 6, 24, 6840, 'deliveryfee'),
(260, 6, 25, 6840, 'deliveryfee'),
(261, 6, 26, 6840, 'deliveryfee'),
(262, 6, 27, 6840, 'deliveryfee'),
(263, 6, 28, 6840, 'deliveryfee'),
(264, 6, 29, 6840, 'deliveryfee'),
(265, 6, 30, 6840, 'deliveryfee'),
(266, 6, 31, 7380, 'deliveryfee'),
(267, 6, 32, 7380, 'deliveryfee'),
(268, 6, 33, 7380, 'deliveryfee'),
(269, 6, 34, 7380, 'deliveryfee'),
(270, 6, 35, 7380, 'deliveryfee'),
(271, 6, 36, 7590, 'deliveryfee'),
(272, 6, 37, 7590, 'deliveryfee'),
(273, 6, 38, 7590, 'deliveryfee'),
(274, 6, 39, 7590, 'deliveryfee'),
(275, 6, 40, 7700, 'deliveryfee'),
(276, 6, 41, 7700, 'deliveryfee'),
(277, 6, 42, 7920, 'deliveryfee'),
(278, 6, 43, 7920, 'deliveryfee'),
(279, 6, 44, 7700, 'deliveryfee'),
(280, 6, 45, 7920, 'deliveryfee'),
(281, 6, 46, 7920, 'deliveryfee'),
(282, 6, 47, 0, 'deliveryfee')
;");
$this->addSql("INSERT INTO dtb_delivery_fee (id, delivery_id, pref_id, fee, discriminator_type) VALUES
(283, 7, 1, 9610, 'deliveryfee'),
(284, 7, 2, 7020, 'deliveryfee'),
(285, 7, 3, 7020, 'deliveryfee'),
(286, 7, 4, 7750, 'deliveryfee'),
(287, 7, 5, 7020, 'deliveryfee'),
(288, 7, 6, 7750, 'deliveryfee'),
(289, 7, 7, 7750, 'deliveryfee'),
(290, 7, 8, 8380, 'deliveryfee'),
(291, 7, 9, 8380, 'deliveryfee'),
(292, 7, 10, 8380, 'deliveryfee'),
(293, 7, 11, 8690, 'deliveryfee'),
(294, 7, 12, 8690, 'deliveryfee'),
(295, 7, 13, 8690, 'deliveryfee'),
(296, 7, 14, 8690, 'deliveryfee'),
(297, 7, 15, 8480, 'deliveryfee'),
(298, 7, 16, 9000, 'deliveryfee'),
(299, 7, 17, 9000, 'deliveryfee'),
(300, 7, 18, 9000, 'deliveryfee'),
(301, 7, 19, 9110, 'deliveryfee'),
(302, 7, 20, 8480, 'deliveryfee'),
(303, 7, 21, 9110, 'deliveryfee'),
(304, 7, 22, 9110, 'deliveryfee'),
(305, 7, 23, 9110, 'deliveryfee'),
(306, 7, 24, 9740, 'deliveryfee'),
(307, 7, 25, 9740, 'deliveryfee'),
(308, 7, 26, 9740, 'deliveryfee'),
(309, 7, 27, 9740, 'deliveryfee'),
(310, 7, 28, 9740, 'deliveryfee'),
(311, 7, 29, 9740, 'deliveryfee'),
(312, 7, 30, 9740, 'deliveryfee'),
(313, 7, 31, 11000, 'deliveryfee'),
(314, 7, 32, 11000, 'deliveryfee'),
(315, 7, 33, 11000, 'deliveryfee'),
(316, 7, 34, 11000, 'deliveryfee'),
(317, 7, 35, 11000, 'deliveryfee'),
(318, 7, 36, 11510, 'deliveryfee'),
(319, 7, 37, 11510, 'deliveryfee'),
(320, 7, 38, 11510, 'deliveryfee'),
(321, 7, 39, 11510, 'deliveryfee'),
(322, 7, 40, 11630, 'deliveryfee'),
(323, 7, 41, 11630, 'deliveryfee'),
(324, 7, 42, 12260, 'deliveryfee'),
(325, 7, 43, 12260, 'deliveryfee'),
(326, 7, 44, 11630, 'deliveryfee'),
(327, 7, 45, 12260, 'deliveryfee'),
(328, 7, 46, 12260, 'deliveryfee'),
(329, 7, 47, 0, 'deliveryfee')
;");
$this->addSql("INSERT INTO dtb_delivery_fee (id, delivery_id, pref_id, fee, discriminator_type) VALUES
(330, 8, 1, 8000, 'deliveryfee'),
(331, 8, 2, 8000, 'deliveryfee'),
(332, 8, 3, 8000, 'deliveryfee'),
(333, 8, 4, 8000, 'deliveryfee'),
(334, 8, 5, 8000, 'deliveryfee'),
(335, 8, 6, 8000, 'deliveryfee'),
(336, 8, 7, 8000, 'deliveryfee'),
(337, 8, 8, 8000, 'deliveryfee'),
(338, 8, 9, 8000, 'deliveryfee'),
(339, 8, 10, 8000, 'deliveryfee'),
(340, 8, 11, 8000, 'deliveryfee'),
(341, 8, 12, 8000, 'deliveryfee'),
(342, 8, 13, 8000, 'deliveryfee'),
(343, 8, 14, 8000, 'deliveryfee'),
(344, 8, 15, 8000, 'deliveryfee'),
(345, 8, 16, 8000, 'deliveryfee'),
(346, 8, 17, 8000, 'deliveryfee'),
(347, 8, 18, 8000, 'deliveryfee'),
(348, 8, 19, 8000, 'deliveryfee'),
(349, 8, 20, 8000, 'deliveryfee'),
(350, 8, 21, 8000, 'deliveryfee'),
(351, 8, 22, 8000, 'deliveryfee'),
(352, 8, 23, 8000, 'deliveryfee'),
(353, 8, 24, 8000, 'deliveryfee'),
(354, 8, 25, 8000, 'deliveryfee'),
(355, 8, 26, 8000, 'deliveryfee'),
(356, 8, 27, 8000, 'deliveryfee'),
(357, 8, 28, 8000, 'deliveryfee'),
(358, 8, 29, 8000, 'deliveryfee'),
(359, 8, 30, 8000, 'deliveryfee'),
(360, 8, 31, 8000, 'deliveryfee'),
(361, 8, 32, 8000, 'deliveryfee'),
(362, 8, 33, 8000, 'deliveryfee'),
(363, 8, 34, 8000, 'deliveryfee'),
(364, 8, 35, 8000, 'deliveryfee'),
(365, 8, 36, 8000, 'deliveryfee'),
(366, 8, 37, 8000, 'deliveryfee'),
(367, 8, 38, 8000, 'deliveryfee'),
(368, 8, 39, 8000, 'deliveryfee'),
(369, 8, 40, 8000, 'deliveryfee'),
(370, 8, 41, 8000, 'deliveryfee'),
(371, 8, 42, 8000, 'deliveryfee'),
(372, 8, 43, 8000, 'deliveryfee'),
(373, 8, 44, 8000, 'deliveryfee'),
(374, 8, 45, 8000, 'deliveryfee'),
(375, 8, 46, 8000, 'deliveryfee'),
(376, 8, 47, 0, 'deliveryfee')
;");
$this->addSql("INSERT INTO dtb_delivery_fee (id, delivery_id, pref_id, fee, discriminator_type) VALUES
(377, 9, 1, 6000, 'deliveryfee'),
(378, 9, 2, 6000, 'deliveryfee'),
(379, 9, 3, 6000, 'deliveryfee'),
(380, 9, 4, 6000, 'deliveryfee'),
(381, 9, 5, 6000, 'deliveryfee'),
(382, 9, 6, 6000, 'deliveryfee'),
(383, 9, 7, 6000, 'deliveryfee'),
(384, 9, 8, 6000, 'deliveryfee'),
(385, 9, 9, 6000, 'deliveryfee'),
(386, 9, 10, 6000, 'deliveryfee'),
(387, 9, 11, 6000, 'deliveryfee'),
(388, 9, 12, 6000, 'deliveryfee'),
(389, 9, 13, 6000, 'deliveryfee'),
(390, 9, 14, 6000, 'deliveryfee'),
(391, 9, 15, 6000, 'deliveryfee'),
(392, 9, 16, 6000, 'deliveryfee'),
(393, 9, 17, 6000, 'deliveryfee'),
(394, 9, 18, 6000, 'deliveryfee'),
(395, 9, 19, 6000, 'deliveryfee'),
(396, 9, 20, 6000, 'deliveryfee'),
(397, 9, 21, 6000, 'deliveryfee'),
(398, 9, 22, 6000, 'deliveryfee'),
(399, 9, 23, 6000, 'deliveryfee'),
(400, 9, 24, 6000, 'deliveryfee'),
(401, 9, 25, 6000, 'deliveryfee'),
(402, 9, 26, 6000, 'deliveryfee'),
(403, 9, 27, 6000, 'deliveryfee'),
(404, 9, 28, 6000, 'deliveryfee'),
(405, 9, 29, 6000, 'deliveryfee'),
(406, 9, 30, 6000, 'deliveryfee'),
(407, 9, 31, 6000, 'deliveryfee'),
(408, 9, 32, 6000, 'deliveryfee'),
(409, 9, 33, 6000, 'deliveryfee'),
(410, 9, 34, 6000, 'deliveryfee'),
(411, 9, 35, 6000, 'deliveryfee'),
(412, 9, 36, 6000, 'deliveryfee'),
(413, 9, 37, 6000, 'deliveryfee'),
(414, 9, 38, 6000, 'deliveryfee'),
(415, 9, 39, 6000, 'deliveryfee'),
(416, 9, 40, 6000, 'deliveryfee'),
(417, 9, 41, 6000, 'deliveryfee'),
(418, 9, 42, 6000, 'deliveryfee'),
(419, 9, 43, 6000, 'deliveryfee'),
(420, 9, 44, 6000, 'deliveryfee'),
(421, 9, 45, 6000, 'deliveryfee'),
(422, 9, 46, 6000, 'deliveryfee'),
(423, 9, 47, 0, 'deliveryfee')
;");
$this->addSql("INSERT INTO dtb_delivery_fee (id, delivery_id, pref_id, fee, discriminator_type) VALUES
(424, 10, 1, 5000, 'deliveryfee'),
(425, 10, 2, 5000, 'deliveryfee'),
(426, 10, 3, 5000, 'deliveryfee'),
(427, 10, 4, 5000, 'deliveryfee'),
(428, 10, 5, 5000, 'deliveryfee'),
(429, 10, 6, 5000, 'deliveryfee'),
(430, 10, 7, 5000, 'deliveryfee'),
(431, 10, 8, 5000, 'deliveryfee'),
(432, 10, 9, 5000, 'deliveryfee'),
(433, 10, 10, 5000, 'deliveryfee'),
(434, 10, 11, 5000, 'deliveryfee'),
(435, 10, 12, 5000, 'deliveryfee'),
(436, 10, 13, 5000, 'deliveryfee'),
(437, 10, 14, 5000, 'deliveryfee'),
(438, 10, 15, 5000, 'deliveryfee'),
(439, 10, 16, 5000, 'deliveryfee'),
(440, 10, 17, 5000, 'deliveryfee'),
(441, 10, 18, 5000, 'deliveryfee'),
(442, 10, 19, 5000, 'deliveryfee'),
(443, 10, 20, 5000, 'deliveryfee'),
(444, 10, 21, 5000, 'deliveryfee'),
(445, 10, 22, 5000, 'deliveryfee'),
(446, 10, 23, 5000, 'deliveryfee'),
(447, 10, 24, 5000, 'deliveryfee'),
(448, 10, 25, 5000, 'deliveryfee'),
(449, 10, 26, 5000, 'deliveryfee'),
(450, 10, 27, 5000, 'deliveryfee'),
(451, 10, 28, 5000, 'deliveryfee'),
(452, 10, 29, 5000, 'deliveryfee'),
(453, 10, 30, 5000, 'deliveryfee'),
(454, 10, 31, 5000, 'deliveryfee'),
(455, 10, 32, 5000, 'deliveryfee'),
(456, 10, 33, 5000, 'deliveryfee'),
(457, 10, 34, 5000, 'deliveryfee'),
(458, 10, 35, 5000, 'deliveryfee'),
(459, 10, 36, 5000, 'deliveryfee'),
(460, 10, 37, 5000, 'deliveryfee'),
(461, 10, 38, 5000, 'deliveryfee'),
(462, 10, 39, 5000, 'deliveryfee'),
(463, 10, 40, 5000, 'deliveryfee'),
(464, 10, 41, 5000, 'deliveryfee'),
(465, 10, 42, 5000, 'deliveryfee'),
(466, 10, 43, 5000, 'deliveryfee'),
(467, 10, 44, 5000, 'deliveryfee'),
(468, 10, 45, 5000, 'deliveryfee'),
(469, 10, 46, 5000, 'deliveryfee'),
(470, 10, 47, 0, 'deliveryfee')
;");
$this->addSql("INSERT INTO dtb_delivery_fee (id, delivery_id, pref_id, fee, discriminator_type) VALUES
(471, 11, 1, 0, 'deliveryfee'),
(472, 11, 2, 13750, 'deliveryfee'),
(473, 11, 3, 13750, 'deliveryfee'),
(474, 11, 4, 16280, 'deliveryfee'),
(475, 11, 5, 13750, 'deliveryfee'),
(476, 11, 6, 16280, 'deliveryfee'),
(477, 11, 7, 16280, 'deliveryfee'),
(478, 11, 8, 18040, 'deliveryfee'),
(479, 11, 9, 18040, 'deliveryfee'),
(480, 11, 10, 18040, 'deliveryfee'),
(481, 11, 11, 19690, 'deliveryfee'),
(482, 11, 12, 19690, 'deliveryfee'),
(483, 11, 13, 19690, 'deliveryfee'),
(484, 11, 14, 19690, 'deliveryfee'),
(485, 11, 15, 23100, 'deliveryfee'),
(486, 11, 16, 25740, 'deliveryfee'),
(487, 11, 17, 25740, 'deliveryfee'),
(488, 11, 18, 25740, 'deliveryfee'),
(489, 11, 19, 25740, 'deliveryfee'),
(490, 11, 20, 23100, 'deliveryfee'),
(491, 11, 21, 25740, 'deliveryfee'),
(492, 11, 22, 25740, 'deliveryfee'),
(493, 11, 23, 25740, 'deliveryfee'),
(494, 11, 24, 29150, 'deliveryfee'),
(495, 11, 25, 29150, 'deliveryfee'),
(496, 11, 26, 29150, 'deliveryfee'),
(497, 11, 27, 29150, 'deliveryfee'),
(498, 11, 28, 29150, 'deliveryfee'),
(499, 11, 29, 29150, 'deliveryfee'),
(500, 11, 30, 29150, 'deliveryfee'),
(501, 11, 31, 35970, 'deliveryfee'),
(502, 11, 32, 35970, 'deliveryfee'),
(503, 11, 33, 35970, 'deliveryfee'),
(504, 11, 34, 35970, 'deliveryfee'),
(505, 11, 35, 35970, 'deliveryfee'),
(506, 11, 36, 37620, 'deliveryfee'),
(507, 11, 37, 37620, 'deliveryfee'),
(508, 11, 38, 37620, 'deliveryfee'),
(509, 11, 39, 37620, 'deliveryfee'),
(510, 11, 40, 39380, 'deliveryfee'),
(511, 11, 41, 39380, 'deliveryfee'),
(512, 11, 42, 41030, 'deliveryfee'),
(513, 11, 43, 41030, 'deliveryfee'),
(514, 11, 44, 39380, 'deliveryfee'),
(515, 11, 45, 41030, 'deliveryfee'),
(516, 11, 46, 41030, 'deliveryfee'),
(517, 11, 47, 0, 'deliveryfee')
;");
$this->addSql("INSERT INTO dtb_delivery_fee (id, delivery_id, pref_id, fee, discriminator_type) VALUES
(518, 12, 1, 0, 'deliveryfee'),
(519, 12, 2, 24640, 'deliveryfee'),
(520, 12, 3, 24640, 'deliveryfee'),
(521, 12, 4, 29480, 'deliveryfee'),
(522, 12, 5, 24640, 'deliveryfee'),
(523, 12, 6, 29480, 'deliveryfee'),
(524, 12, 7, 29480, 'deliveryfee'),
(525, 12, 8, 32670, 'deliveryfee'),
(526, 12, 9, 32670, 'deliveryfee'),
(527, 12, 10, 32670, 'deliveryfee'),
(528, 12, 11, 37510, 'deliveryfee'),
(529, 12, 12, 37510, 'deliveryfee'),
(530, 12, 13, 37510, 'deliveryfee'),
(531, 12, 14, 37510, 'deliveryfee'),
(532, 12, 15, 42350, 'deliveryfee'),
(533, 12, 16, 47080, 'deliveryfee'),
(534, 12, 17, 47080, 'deliveryfee'),
(535, 12, 18, 47080, 'deliveryfee'),
(536, 12, 19, 47080, 'deliveryfee'),
(537, 12, 20, 42350, 'deliveryfee'),
(538, 12, 21, 47080, 'deliveryfee'),
(539, 12, 22, 47080, 'deliveryfee'),
(540, 12, 23, 47080, 'deliveryfee'),
(541, 12, 24, 53460, 'deliveryfee'),
(542, 12, 25, 53460, 'deliveryfee'),
(543, 12, 26, 53460, 'deliveryfee'),
(544, 12, 27, 53460, 'deliveryfee'),
(545, 12, 28, 53460, 'deliveryfee'),
(546, 12, 29, 53460, 'deliveryfee'),
(547, 12, 30, 53460, 'deliveryfee'),
(548, 12, 31, 66330, 'deliveryfee'),
(549, 12, 32, 66330, 'deliveryfee'),
(550, 12, 33, 66330, 'deliveryfee'),
(551, 12, 34, 66330, 'deliveryfee'),
(552, 12, 35, 66330, 'deliveryfee'),
(553, 12, 36, 69520, 'deliveryfee'),
(554, 12, 37, 69520, 'deliveryfee'),
(555, 12, 38, 69520, 'deliveryfee'),
(556, 12, 39, 69520, 'deliveryfee'),
(557, 12, 40, 72710, 'deliveryfee'),
(558, 12, 41, 72710, 'deliveryfee'),
(559, 12, 42, 75900, 'deliveryfee'),
(560, 12, 43, 75900, 'deliveryfee'),
(561, 12, 44, 72710, 'deliveryfee'),
(562, 12, 45, 75900, 'deliveryfee'),
(563, 12, 46, 75900, 'deliveryfee'),
(564, 12, 47, 0, 'deliveryfee')
;");
$this->addSql("INSERT INTO dtb_delivery_fee (id, delivery_id, pref_id, fee, discriminator_type) VALUES
(565, 13, 1, 24000, 'deliveryfee'),
(566, 13, 2, 24000, 'deliveryfee'),
(567, 13, 3, 24000, 'deliveryfee'),
(568, 13, 4, 24000, 'deliveryfee'),
(569, 13, 5, 24000, 'deliveryfee'),
(570, 13, 6, 24000, 'deliveryfee'),
(571, 13, 7, 24000, 'deliveryfee'),
(572, 13, 8, 24000, 'deliveryfee'),
(573, 13, 9, 24000, 'deliveryfee'),
(574, 13, 10, 24000, 'deliveryfee'),
(575, 13, 11, 24000, 'deliveryfee'),
(576, 13, 12, 24000, 'deliveryfee'),
(577, 13, 13, 24000, 'deliveryfee'),
(578, 13, 14, 24000, 'deliveryfee'),
(579, 13, 15, 24000, 'deliveryfee'),
(580, 13, 16, 24000, 'deliveryfee'),
(581, 13, 17, 24000, 'deliveryfee'),
(582, 13, 18, 24000, 'deliveryfee'),
(583, 13, 19, 24000, 'deliveryfee'),
(584, 13, 20, 24000, 'deliveryfee'),
(585, 13, 21, 24000, 'deliveryfee'),
(586, 13, 22, 24000, 'deliveryfee'),
(587, 13, 23, 24000, 'deliveryfee'),
(588, 13, 24, 24000, 'deliveryfee'),
(589, 13, 25, 24000, 'deliveryfee'),
(590, 13, 26, 24000, 'deliveryfee'),
(591, 13, 27, 24000, 'deliveryfee'),
(592, 13, 28, 24000, 'deliveryfee'),
(593, 13, 29, 24000, 'deliveryfee'),
(594, 13, 30, 24000, 'deliveryfee'),
(595, 13, 31, 24000, 'deliveryfee'),
(596, 13, 32, 24000, 'deliveryfee'),
(597, 13, 33, 24000, 'deliveryfee'),
(598, 13, 34, 24000, 'deliveryfee'),
(599, 13, 35, 24000, 'deliveryfee'),
(600, 13, 36, 24000, 'deliveryfee'),
(601, 13, 37, 24000, 'deliveryfee'),
(602, 13, 38, 24000, 'deliveryfee'),
(603, 13, 39, 24000, 'deliveryfee'),
(604, 13, 40, 24000, 'deliveryfee'),
(605, 13, 41, 24000, 'deliveryfee'),
(606, 13, 42, 24000, 'deliveryfee'),
(607, 13, 43, 24000, 'deliveryfee'),
(608, 13, 44, 24000, 'deliveryfee'),
(609, 13, 45, 24000, 'deliveryfee'),
(610, 13, 46, 24000, 'deliveryfee'),
(611, 13, 47, 0, 'deliveryfee')
;");
$this->addSql("INSERT INTO dtb_delivery_fee (id, delivery_id, pref_id, fee, discriminator_type) VALUES
(612, 14, 1, 1100, 'deliveryfee'),
(613, 14, 2, 850, 'deliveryfee'),
(614, 14, 3, 850, 'deliveryfee'),
(615, 14, 4, 850, 'deliveryfee'),
(616, 14, 5, 850, 'deliveryfee'),
(617, 14, 6, 850, 'deliveryfee'),
(618, 14, 7, 850, 'deliveryfee'),
(619, 14, 8, 970, 'deliveryfee'),
(620, 14, 9, 970, 'deliveryfee'),
(621, 14, 10, 970, 'deliveryfee'),
(622, 14, 11, 970, 'deliveryfee'),
(623, 14, 12, 970, 'deliveryfee'),
(624, 14, 13, 970, 'deliveryfee'),
(625, 14, 14, 970, 'deliveryfee'),
(626, 14, 15, 970, 'deliveryfee'),
(627, 14, 16, 1100, 'deliveryfee'),
(628, 14, 17, 1100, 'deliveryfee'),
(629, 14, 18, 1100, 'deliveryfee'),
(630, 14, 19, 1100, 'deliveryfee'),
(631, 14, 20, 970, 'deliveryfee'),
(632, 14, 21, 1100, 'deliveryfee'),
(633, 14, 22, 1100, 'deliveryfee'),
(634, 14, 23, 1100, 'deliveryfee'),
(635, 14, 24, 1220, 'deliveryfee'),
(636, 14, 25, 1220, 'deliveryfee'),
(637, 14, 26, 1220, 'deliveryfee'),
(638, 14, 27, 1220, 'deliveryfee'),
(639, 14, 28, 1220, 'deliveryfee'),
(640, 14, 29, 1220, 'deliveryfee'),
(641, 14, 30, 1220, 'deliveryfee'),
(642, 14, 31, 1340, 'deliveryfee'),
(643, 14, 32, 1340, 'deliveryfee'),
(644, 14, 33, 1340, 'deliveryfee'),
(645, 14, 34, 1340, 'deliveryfee'),
(646, 14, 35, 1340, 'deliveryfee'),
(647, 14, 36, 1460, 'deliveryfee'),
(648, 14, 37, 1460, 'deliveryfee'),
(649, 14, 38, 1460, 'deliveryfee'),
(650, 14, 39, 1460, 'deliveryfee'),
(651, 14, 40, 1580, 'deliveryfee'),
(652, 14, 41, 1580, 'deliveryfee'),
(653, 14, 42, 1580, 'deliveryfee'),
(654, 14, 43, 1580, 'deliveryfee'),
(655, 14, 44, 1580, 'deliveryfee'),
(656, 14, 45, 1580, 'deliveryfee'),
(657, 14, 46, 1580, 'deliveryfee'),
(658, 14, 47, 0, 'deliveryfee')
;");
$this->addSql("INSERT INTO dtb_delivery_fee (id, delivery_id, pref_id, fee, discriminator_type) VALUES
(659, 15, 1, 1400, 'deliveryfee'),
(660, 15, 2, 1160, 'deliveryfee'),
(661, 15, 3, 1160, 'deliveryfee'),
(662, 15, 4, 1160, 'deliveryfee'),
(663, 15, 5, 1160, 'deliveryfee'),
(664, 15, 6, 1160, 'deliveryfee'),
(665, 15, 7, 1160, 'deliveryfee'),
(666, 15, 8, 1280, 'deliveryfee'),
(667, 15, 9, 1280, 'deliveryfee'),
(668, 15, 10, 1280, 'deliveryfee'),
(669, 15, 11, 1280, 'deliveryfee'),
(670, 15, 12, 1280, 'deliveryfee'),
(671, 15, 13, 1280, 'deliveryfee'),
(672, 15, 14, 1280, 'deliveryfee'),
(673, 15, 15, 1280, 'deliveryfee'),
(674, 15, 16, 1400, 'deliveryfee'),
(675, 15, 17, 1400, 'deliveryfee'),
(676, 15, 18, 1400, 'deliveryfee'),
(677, 15, 19, 1400, 'deliveryfee'),
(678, 15, 20, 1280, 'deliveryfee'),
(679, 15, 21, 1400, 'deliveryfee'),
(680, 15, 22, 1400, 'deliveryfee'),
(681, 15, 23, 1400, 'deliveryfee'),
(682, 15, 24, 1520, 'deliveryfee'),
(683, 15, 25, 1520, 'deliveryfee'),
(684, 15, 26, 1520, 'deliveryfee'),
(685, 15, 27, 1520, 'deliveryfee'),
(686, 15, 28, 1520, 'deliveryfee'),
(687, 15, 29, 1520, 'deliveryfee'),
(688, 15, 30, 1520, 'deliveryfee'),
(689, 15, 31, 1650, 'deliveryfee'),
(690, 15, 32, 1650, 'deliveryfee'),
(691, 15, 33, 1650, 'deliveryfee'),
(692, 15, 34, 1650, 'deliveryfee'),
(693, 15, 35, 1650, 'deliveryfee'),
(694, 15, 36, 1760, 'deliveryfee'),
(695, 15, 37, 1760, 'deliveryfee'),
(696, 15, 38, 1760, 'deliveryfee'),
(697, 15, 39, 1760, 'deliveryfee'),
(698, 15, 40, 1880, 'deliveryfee'),
(699, 15, 41, 1880, 'deliveryfee'),
(700, 15, 42, 1880, 'deliveryfee'),
(701, 15, 43, 1880, 'deliveryfee'),
(702, 15, 44, 1880, 'deliveryfee'),
(703, 15, 45, 1880, 'deliveryfee'),
(704, 15, 46, 1880, 'deliveryfee'),
(705, 15, 47, 0, 'deliveryfee')
;");
$this->addSql("INSERT INTO dtb_delivery_fee (id, delivery_id, pref_id, fee, discriminator_type) VALUES
(706, 16, 1, 1490, 'deliveryfee'),
(707, 16, 2, 1490, 'deliveryfee'),
(708, 16, 3, 1490, 'deliveryfee'),
(709, 16, 4, 1490, 'deliveryfee'),
(710, 16, 5, 1490, 'deliveryfee'),
(711, 16, 6, 1490, 'deliveryfee'),
(712, 16, 7, 1490, 'deliveryfee'),
(713, 16, 8, 1610, 'deliveryfee'),
(714, 16, 9, 1610, 'deliveryfee'),
(715, 16, 10, 1610, 'deliveryfee'),
(716, 16, 11, 1610, 'deliveryfee'),
(717, 16, 12, 1610, 'deliveryfee'),
(718, 16, 13, 1610, 'deliveryfee'),
(719, 16, 14, 1610, 'deliveryfee'),
(720, 16, 15, 1610, 'deliveryfee'),
(721, 16, 16, 1720, 'deliveryfee'),
(722, 16, 17, 1720, 'deliveryfee'),
(723, 16, 18, 1720, 'deliveryfee'),
(724, 16, 19, 1720, 'deliveryfee'),
(725, 16, 20, 1610, 'deliveryfee'),
(726, 16, 21, 1720, 'deliveryfee'),
(727, 16, 22, 1720, 'deliveryfee'),
(728, 16, 23, 1720, 'deliveryfee'),
(729, 16, 24, 1840, 'deliveryfee'),
(730, 16, 25, 1840, 'deliveryfee'),
(731, 16, 26, 1840, 'deliveryfee'),
(732, 16, 27, 1840, 'deliveryfee'),
(733, 16, 28, 1840, 'deliveryfee'),
(734, 16, 29, 1840, 'deliveryfee'),
(735, 16, 30, 1840, 'deliveryfee'),
(736, 16, 31, 1960, 'deliveryfee'),
(737, 16, 32, 1960, 'deliveryfee'),
(738, 16, 33, 1960, 'deliveryfee'),
(739, 16, 34, 1960, 'deliveryfee'),
(740, 16, 35, 1960, 'deliveryfee'),
(741, 16, 36, 2090, 'deliveryfee'),
(742, 16, 37, 2090, 'deliveryfee'),
(743, 16, 38, 2090, 'deliveryfee'),
(744, 16, 39, 2090, 'deliveryfee'),
(745, 16, 40, 2200, 'deliveryfee'),
(746, 16, 41, 2200, 'deliveryfee'),
(747, 16, 42, 2200, 'deliveryfee'),
(748, 16, 43, 2200, 'deliveryfee'),
(749, 16, 44, 2200, 'deliveryfee'),
(750, 16, 45, 2200, 'deliveryfee'),
(751, 16, 46, 2200, 'deliveryfee'),
(752, 16, 47, 0, 'deliveryfee')
;");
$this->addSql("INSERT INTO dtb_delivery_fee (id, delivery_id, pref_id, fee, discriminator_type) VALUES
(753, 17, 1, 177000, 'deliveryfee'),
(754, 17, 2, 57000, 'deliveryfee'),
(755, 17, 3, 57000, 'deliveryfee'),
(756, 17, 4, 68000, 'deliveryfee'),
(757, 17, 5, 57000, 'deliveryfee'),
(758, 17, 6, 68000, 'deliveryfee'),
(759, 17, 7, 68000, 'deliveryfee'),
(760, 17, 8, 90000, 'deliveryfee'),
(761, 17, 9, 90000, 'deliveryfee'),
(762, 17, 10, 90000, 'deliveryfee'),
(763, 17, 11, 103000, 'deliveryfee'),
(764, 17, 12, 103000, 'deliveryfee'),
(765, 17, 13, 103000, 'deliveryfee'),
(766, 17, 14, 103000, 'deliveryfee'),
(767, 17, 15, 108000, 'deliveryfee'),
(768, 17, 16, 143000, 'deliveryfee'),
(769, 17, 17, 143000, 'deliveryfee'),
(770, 17, 18, 143000, 'deliveryfee'),
(771, 17, 19, 149000, 'deliveryfee'),
(772, 17, 20, 108000, 'deliveryfee'),
(773, 17, 21, 149000, 'deliveryfee'),
(774, 17, 22, 149000, 'deliveryfee'),
(775, 17, 23, 149000, 'deliveryfee'),
(776, 17, 24, 179000, 'deliveryfee'),
(777, 17, 25, 179000, 'deliveryfee'),
(778, 17, 26, 179000, 'deliveryfee'),
(779, 17, 27, 179000, 'deliveryfee'),
(780, 17, 28, 179000, 'deliveryfee'),
(781, 17, 29, 179000, 'deliveryfee'),
(782, 17, 30, 179000, 'deliveryfee'),
(783, 17, 31, 215000, 'deliveryfee'),
(784, 17, 32, 215000, 'deliveryfee'),
(785, 17, 33, 215000, 'deliveryfee'),
(786, 17, 34, 215000, 'deliveryfee'),
(787, 17, 35, 215000, 'deliveryfee'),
(788, 17, 36, 204000, 'deliveryfee'),
(789, 17, 37, 204000, 'deliveryfee'),
(790, 17, 38, 204000, 'deliveryfee'),
(791, 17, 39, 204000, 'deliveryfee'),
(792, 17, 40, 245000, 'deliveryfee'),
(793, 17, 41, 245000, 'deliveryfee'),
(794, 17, 42, 269000, 'deliveryfee'),
(795, 17, 43, 269000, 'deliveryfee'),
(796, 17, 44, 245000, 'deliveryfee'),
(797, 17, 45, 269000, 'deliveryfee'),
(798, 17, 46, 269000, 'deliveryfee'),
(799, 17, 47, 0, 'deliveryfee')
;");
$this->addSql("INSERT INTO dtb_delivery_fee (id, delivery_id, pref_id, fee, discriminator_type) VALUES
(800, 18, 1, 33000, 'deliveryfee'),
(801, 18, 2, 27000, 'deliveryfee'),
(802, 18, 3, 27000, 'deliveryfee'),
(803, 18, 4, 27000, 'deliveryfee'),
(804, 18, 5, 27000, 'deliveryfee'),
(805, 18, 6, 27000, 'deliveryfee'),
(806, 18, 7, 27000, 'deliveryfee'),
(807, 18, 8, 27000, 'deliveryfee'),
(808, 18, 9, 27000, 'deliveryfee'),
(809, 18, 10, 27000, 'deliveryfee'),
(810, 18, 11, 27000, 'deliveryfee'),
(811, 18, 12, 27000, 'deliveryfee'),
(812, 18, 13, 27000, 'deliveryfee'),
(813, 18, 14, 27000, 'deliveryfee'),
(814, 18, 15, 35000, 'deliveryfee'),
(815, 18, 16, 35000, 'deliveryfee'),
(816, 18, 17, 35000, 'deliveryfee'),
(817, 18, 18, 35000, 'deliveryfee'),
(818, 18, 19, 35000, 'deliveryfee'),
(819, 18, 20, 35000, 'deliveryfee'),
(820, 18, 21, 35000, 'deliveryfee'),
(821, 18, 22, 35000, 'deliveryfee'),
(822, 18, 23, 35000, 'deliveryfee'),
(823, 18, 24, 35000, 'deliveryfee'),
(824, 18, 25, 35000, 'deliveryfee'),
(825, 18, 26, 35000, 'deliveryfee'),
(826, 18, 27, 35000, 'deliveryfee'),
(827, 18, 28, 35000, 'deliveryfee'),
(828, 18, 29, 35000, 'deliveryfee'),
(829, 18, 30, 35000, 'deliveryfee'),
(830, 18, 31, 35000, 'deliveryfee'),
(831, 18, 32, 35000, 'deliveryfee'),
(832, 18, 33, 35000, 'deliveryfee'),
(833, 18, 34, 35000, 'deliveryfee'),
(834, 18, 35, 35000, 'deliveryfee'),
(835, 18, 36, 35000, 'deliveryfee'),
(836, 18, 37, 35000, 'deliveryfee'),
(837, 18, 38, 35000, 'deliveryfee'),
(838, 18, 39, 35000, 'deliveryfee'),
(839, 18, 40, 35000, 'deliveryfee'),
(840, 18, 41, 35000, 'deliveryfee'),
(841, 18, 42, 35000, 'deliveryfee'),
(842, 18, 43, 35000, 'deliveryfee'),
(843, 18, 44, 35000, 'deliveryfee'),
(844, 18, 45, 35000, 'deliveryfee'),
(845, 18, 46, 35000, 'deliveryfee'),
(846, 18, 47, 0, 'deliveryfee')
;");
}
public function down(Schema $schema): void
{
$this->addSql("DELETE FROM dtb_delivery_fee WHERE id BETWEEN 1 AND 846;");
$this->addSql("DELETE FROM dtb_payment_option WHERE delivery_id BETWEEN 1 AND 18;");
$this->addSql("DELETE FROM dtb_delivery WHERE id BETWEEN 1 AND 18;");
}
}