set @deliveryTypeHermesId = 51;
set @deliveryTypeHermesGsId = 52;

/* тарифы для зон по весу */
DROP TABLE IF EXISTS `delivery_config_hermes`;
CREATE TABLE `delivery_config_hermes` (
                                                                                `delivery_config_hermes_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id',
                                                                                `delivery_points_config_zones_id` INT(10) NOT NULL COMMENT 'Id зоны доставки Hermes',
                                                                                `weight` INT(10) NOT NULL COMMENT 'Вес',
                                                                                `price` DECIMAL(15,2) NOT NULL DEFAULT 0 COMMENT 'Стоимость доставки',
                                                                                PRIMARY KEY (`delivery_config_hermes_id`),
                                                                                UNIQUE INDEX `delivery_points_config_zones_id_weight` (`delivery_points_config_zones_id`, `weight`)
)
    COLLATE='utf8_general_ci'
    ENGINE=InnoDB
;

INSERT IGNORE INTO `delivery_config_hermes` (`delivery_points_config_zones_id`, `weight`, `price`) VALUES
(1, 1, 129.14),
(1, 2, 129.14),
(1, 3, 129.14),
(1, 4, 129.14),
(1, 5, 129.14),
(1, 6, 147.62),
(1, 7, 147.62),
(1, 8, 147.62),
(1, 9, 147.62),
(1, 10, 147.62),
(1, 11, 152.38),
(1, 12, 152.38),
(1, 13, 152.38),
(1, 14, 152.38),
(1, 15, 152.38),
(1, 16, 169.52),
(1, 17, 169.52),
(1, 18, 169.52),
(1, 19, 169.52),
(1, 20, 169.52),
(1, 21, 429.52),
(1, 22, 429.52),
(1, 23, 429.52),
(1, 24, 429.52),
(1, 25, 429.52),
(1, 26, 429.52),
(1, 27, 429.52),
(1, 28, 429.52),
(1, 29, 429.52),
(1, 30, 429.52),

(2, 1, 129.14),
(2, 2, 129.14),
(2, 3, 129.14),
(2, 4, 129.14),
(2, 5, 129.14),
(2, 6, 147.62),
(2, 7, 147.62),
(2, 8, 147.62),
(2, 9, 147.62),
(2, 10, 147.62),
(2, 11, 152.38),
(2, 12, 152.38),
(2, 13, 152.38),
(2, 14, 152.38),
(2, 15, 152.38),
(2, 16, 169.52),
(2, 17, 169.52),
(2, 18, 169.52),
(2, 19, 169.52),
(2, 20, 169.52),
(2, 21, 429.52),
(2, 22, 429.52),
(2, 23, 429.52),
(2, 24, 429.52),
(2, 25, 429.52),
(2, 26, 429.52),
(2, 27, 429.52),
(2, 28, 429.52),
(2, 29, 429.52),
(2, 30, 429.52),

(3, 1, 165.46),
(3, 2, 165.46),
(3, 3, 165.46),
(3, 4, 165.46),
(3, 5, 165.46),
(3, 6,167.62),
(3, 7,167.62),
(3, 8,167.62),
(3, 9,167.62),
(3, 10,167.62),
(3, 11, 200),
(3, 12, 200),
(3, 13, 200),
(3, 14, 200),
(3, 15, 200),
(3, 16, 232.38),
(3, 17, 232.38),
(3, 18, 232.38),
(3, 19, 232.38),
(3, 20, 232.38),
(3, 21, 469.52),
(3, 22, 469.52),
(3, 23, 469.52),
(3, 24, 469.52),
(3, 25, 469.52),
(3, 26, 469.52),
(3, 27, 469.52),
(3, 28, 469.52),
(3, 29, 469.52),
(3, 30, 469.52),

(4, 1, 177.56),
(4, 2, 177.56),
(4, 3, 177.56),
(4, 4, 177.56),
(4, 5, 177.56),
(4, 6, 200),
(4, 7, 200),
(4, 8, 200),
(4, 9, 200),
(4, 10, 200),
(4, 11, 251.43),
(4, 12, 251.43),
(4, 13, 251.43),
(4, 14, 251.43),
(4, 15, 251.43),
(4, 16, 271.43),
(4, 17, 271.43),
(4, 18, 271.43),
(4, 19, 271.43),
(4, 20, 271.43),
(4, 21, 573.33),
(4, 22, 573.33),
(4, 23, 573.33),
(4, 24, 573.33),
(4, 25, 573.33),
(4, 26, 573.33),
(4, 27, 573.33),
(4, 28, 573.33),
(4, 29, 573.33),
(4, 30, 573.33),

(5, 1, 213.88),
(5, 2, 213.88),
(5, 3, 213.88),
(5, 4, 213.88),
(5, 5, 213.88),
(5, 6, 229.52),
(5, 7, 229.52),
(5, 8, 229.52),
(5, 9, 229.52),
(5, 10, 229.52),
(5, 11, 309.52),
(5, 12, 309.52),
(5, 13, 309.52),
(5, 14, 309.52),
(5, 15, 309.52),
(5, 16, 323.81),
(5, 17, 323.81),
(5, 18, 323.81),
(5, 19, 323.81),
(5, 20, 323.81),
(5, 21, 780.95),
(5, 22, 780.95),
(5, 23, 780.95),
(5, 24, 780.95),
(5, 25, 780.95),
(5, 26, 780.95),
(5, 27, 780.95),
(5, 28, 780.95),
(5, 29, 780.95),
(5, 30, 780.95),

(6, 1, 242.13),
(6, 2, 242.13),
(6, 3, 242.13),
(6, 4, 242.13),
(6, 5, 242.13),
(6, 6, 314.29),
(6, 7, 314.29),
(6, 8, 314.29),
(6, 9, 314.29),
(6, 10, 314.29),
(6, 11, 357.14),
(6, 12, 357.14),
(6, 13, 357.14),
(6, 14, 357.14),
(6, 15, 357.14),
(6, 16, 454.29),
(6, 17, 454.29),
(6, 18, 454.29),
(6, 19, 454.29),
(6, 20, 454.29),
(6, 21, 1427.62),
(6, 22, 1427.62),
(6, 23, 1427.62),
(6, 24, 1427.62),
(6, 25, 1427.62),
(6, 26, 1427.62),
(6, 27, 1427.62),
(6, 28, 1427.62),
(6, 29, 1427.62),
(6, 30, 1427.62),

(7, 1, 129.14),
(7, 2, 129.14),
(7, 3, 129.14),
(7, 4, 129.14),
(7, 5, 129.14),
(7, 6, 147.62),
(7, 7, 147.62),
(7, 8, 147.62),
(7, 9, 147.62),
(7, 10, 147.62),
(7, 11, 152.38),
(7, 12, 152.38),
(7, 13, 152.38),
(7, 14, 152.38),
(7, 15, 152.38),
(7, 16, 169.52),
(7, 17, 169.52),
(7, 18, 169.52),
(7, 19, 169.52),
(7, 20, 169.52),
(7, 21, 429.52),
(7, 22, 429.52),
(7, 23, 429.52),
(7, 24, 429.52),
(7, 25, 429.52),
(7, 26, 429.52),
(7, 27, 429.52),
(7, 28, 429.52),
(7, 29, 429.52),
(7, 30, 429.52),

(8, 1, 129.14),
(8, 2, 129.14),
(8, 3, 129.14),
(8, 4, 129.14),
(8, 5, 129.14),
(8, 6, 147.62),
(8, 7, 147.62),
(8, 8, 147.62),
(8, 9, 147.62),
(8, 10, 147.62),
(8, 11, 152.38),
(8, 12, 152.38),
(8, 13, 152.38),
(8, 14, 152.38),
(8, 15, 152.38),
(8, 16, 169.52),
(8, 17, 169.52),
(8, 18, 169.52),
(8, 19, 169.52),
(8, 20, 169.52),
(8, 21, 429.52),
(8, 22, 429.52),
(8, 23, 429.52),
(8, 24, 429.52),
(8, 25, 429.52),
(8, 26, 429.52),
(8, 27, 429.52),
(8, 28, 429.52),
(8, 29, 429.52),
(8, 30, 429.52),

(9, 1, 165.46),
(9, 2, 165.46),
(9, 3, 165.46),
(9, 4, 165.46),
(9, 5, 165.46),
(9, 6,167.62),
(9, 7,167.62),
(9, 8,167.62),
(9, 9,167.62),
(9, 10,167.62),
(9, 11, 200),
(9, 12, 200),
(9, 13, 200),
(9, 14, 200),
(9, 15, 200),
(9, 16, 232.38),
(9, 17, 232.38),
(9, 18, 232.38),
(9, 19, 232.38),
(9, 20, 232.38),
(9, 21, 469.52),
(9, 22, 469.52),
(9, 23, 469.52),
(9, 24, 469.52),
(9, 25, 469.52),
(9, 26, 469.52),
(9, 27, 469.52),
(9, 28, 469.52),
(9, 29, 469.52),
(9, 30, 469.52),

(10, 1, 177.56),
(10, 2, 177.56),
(10, 3, 177.56),
(10, 4, 177.56),
(10, 5, 177.56),
(10, 6, 200),
(10, 7, 200),
(10, 8, 200),
(10, 9, 200),
(10, 10, 200),
(10, 11, 251.43),
(10, 12, 251.43),
(10, 13, 251.43),
(10, 14, 251.43),
(10, 15, 251.43),
(10, 16, 271.43),
(10, 17, 271.43),
(10, 18, 271.43),
(10, 19, 271.43),
(10, 20, 271.43),
(10, 21, 573.33),
(10, 22, 573.33),
(10, 23, 573.33),
(10, 24, 573.33),
(10, 25, 573.33),
(10, 26, 573.33),
(10, 27, 573.33),
(10, 28, 573.33),
(10, 29, 573.33),
(10, 30, 573.33),

(11, 1, 213.88),
(11, 2, 213.88),
(11, 3, 213.88),
(11, 4, 213.88),
(11, 5, 213.88),
(11, 6, 229.52),
(11, 7, 229.52),
(11, 8, 229.52),
(11, 9, 229.52),
(11, 10, 229.52),
(11, 11, 309.52),
(11, 12, 309.52),
(11, 13, 309.52),
(11, 14, 309.52),
(11, 15, 309.52),
(11, 16, 323.81),
(11, 17, 323.81),
(11, 18, 323.81),
(11, 19, 323.81),
(11, 20, 323.81),
(11, 21, 780.95),
(11, 22, 780.95),
(11, 23, 780.95),
(11, 24, 780.95),
(11, 25, 780.95),
(11, 26, 780.95),
(11, 27, 780.95),
(11, 28, 780.95),
(11, 29, 780.95),
(11, 30, 780.95),

(12, 1, 242.13),
(12, 2, 242.13),
(12, 3, 242.13),
(12, 4, 242.13),
(12, 5, 242.13),
(12, 6, 314.29),
(12, 7, 314.29),
(12, 8, 314.29),
(12, 9, 314.29),
(12, 10, 314.29),
(12, 11, 357.14),
(12, 12, 357.14),
(12, 13, 357.14),
(12, 14, 357.14),
(12, 15, 357.14),
(12, 16, 454.29),
(12, 17, 454.29),
(12, 18, 454.29),
(12, 19, 454.29),
(12, 20, 454.29),
(12, 21, 1427.62),
(12, 22, 1427.62),
(12, 23, 1427.62),
(12, 24, 1427.62),
(12, 25, 1427.62),
(12, 26, 1427.62),
(12, 27, 1427.62),
(12, 28, 1427.62),
(12, 29, 1427.62),
(12, 30, 1427.62)
;

/* новая правильная география */
INSERT IGNORE INTO delivery_points_config (`delivery_types_id`, `fias_id`, `tc_city_code`, `price`, `zone`, `is_active`) VALUES
(52, "378499", "1900000100000", 1000000, 11, 1),
(52, "745943", "2300300100000", 1000000, 10, 1),
(52, "672943", "2300000200000", 1000000, 10, 1),
(52, "926302", "2900000100000", 1000000, 10, 1),
(52, "900469", "3000000100000", 1000000, 10, 1),
(52, "811925", "6400000400000", 1000000, 10, 1),
(52, "202406", "5200400100000", 1000000, 9, 1),
(52, "1030433", "5000003600000", 1000000, 8, 1),
(52, "912369", "2200000100000", 1000000, 11, 1),
(52, "309046", "3100000100000", 1000000, 9, 1),
(52, "945867", "5400000200000", 1000000, 11, 1),
(52, "172289", "2200000400000", 1000000, 11, 1),
(52, "68882", "5200000500000", 1000000, 9, 1),
(52, "539541", "3200000100000", 1000000, 9, 1),
(52, "712657", "5300000100000", 1000000, 9, 1),
(52, "1054838", "5001400100000", 1000000, 8, 1),
(52, "888680", "2500000100000", 1000000, 12, 1),
(52, "579588", "1500000100000", 1000000, 11, 1),
(52, "911103", "3300000100000", 1000000, 9, 1),
(52, "530876", "3400000100000", 1000000, 10, 1),
(52, "42702", "3500000100000", 1000000, 9, 1),
(52, "694643", "5000300100000", 1000000, 8, 1),
(52, "902295", "6400000600000", 1000000, 10, 1),
(52, "468731", "3600000100000", 1000000, 9, 1),
(52, "578053", "5000400100000", 1000000, 8, 1),
(52, "666950", "4700500100000", 1000000, 9, 1),
(52, "10654", "4700600100000", 1000000, 10, 1),
(52, "307147", "4700700100000", 1000000, 9, 1),
(52, "404188", "2300000300000", 1000000, 10, 1),
(52, "17770", "5200000200000", 1000000, 9, 1),
(52, "410381", "5000002300000", 1000000, 9, 1),
(52, "625195", "7300000200000", 1000000, 10, 1),
(52, "371781", "5000500100000", 1000000, 8, 1),
(52, "773415", "5000002900000", 1000000, 8, 1),
(52, "586213", "5000000300000", 1000000, 8, 1),
(52,"167892", "3102200002400", 1000000, 9, 1),
(52, "434756", "5000700100000", 1000000, 8, 1),
(52, "517995", "2301100100000", 1000000, 10, 1),
(52, "318338", "6600000100000", 1000000, 10, 1),
(52, "543089", "5000000400000", 1000000, 8, 1),
(52, "215458", "5000000500000", 1000000, 8, 1),
(52, "424029", "7700000200000", 1000000, 8, 1),
(52, "837671", "3700000100000", 1000000, 9, 1),
(52, "336991", "1800000100000", 1000000, 10, 1),
(52, "370074", "3800000300000", 1000000, 11, 1),
(52, "135545", "1200000100000", 1000000, 10, 1),
(52, "605127", "1600000100000", 1000000, 10, 1),
(52, "63957", "4000000100000", 1000000, 9, 1),
(52, "865865", "6600002200000", 1000000, 10, 1),
(52, "81949", "3400000300000", 1000000, 10, 1),
(52, "751553", "4200000900000", 1000000, 11, 1),
(52, "294693", "4300000100000", 1000000, 10, 1),
(52,236419, "4301300100051", 1000000, 10, 1),
(52, "838047", "2600000400000", 1000000, 10, 1),
(52,315171, "5001100100000", 1000000, 8, 1),
(52, "756939", "3300000400000", 1000000, 9, 1),
(52, "52064", "5000002700000", 1000000, 8, 1),
(52, "657030", "3300900100000", 1000000, 9, 1),
(52, "294167", "2700000500000", 1000000, 12, 1),
(52, "163853", "5000000900000", 1000000, 8, 1),
(52, "770152", "4400000300000", 1000000, 9, 1),
(52, "30546", "5000003200000", 1000000, 8, 1),
(52, "54530", "5001300100000", 1000000, 8, 1),
(52, "650931", "2300000100000", 1000000, 10, 1),
(52, "36918", "7800000400000", 1000000, 9, 1),
(52, "591716", "2400000100000", 1000000, 11, 1),
(52, "571443", "5202700100000", 1000000, 9, 1),
(52, "214532", "4600000100000", 1000000, 9, 1),
(52, "112358", "4800000100000", 1000000, 9, 1),
(52, "745758", "5000001200000", 1000000, 8, 1),
(52, "866593", "5001700100000", 1000000, 8, 1),
(52, "277682", "7400000900000", 1000000, 10, 1),
(52, "271793", "0100000100000", 1000000, 11, 1),
(52, "991724", "4001500100000", 1000000, 9, 1),
(52, "229161", "0500000100000", 1000000, 11, 1),
(52, "209192", "2600001000000", 1000000, 10, 1),
(52, "225912", "6800000600000", 1000000, 9, 1),
(52, "171328", "5004000006000", 1000000, 8, 1),
(52, "452231", "7700000000000", 1000000, 8, 1),
(52, "20842", "7701100100000", 1000000, 8, 1),
(52, "374517", "5100000100000", 1000000, 10, 1),
(52, "293176", "3300000500000", 1000000, 9, 1),
(52, "815727", "5001900100000", 1000000, 8, 1),
(52, "2187", "1600000200000", 1000000, 10, 1),
(52, "621099", "0700000100000", 1000000, 11, 1),
(52, "889894", "2500000400000", 1000000, 12, 1),
(52, "414828", "8600001400000", 1000000, 10, 1),
(52, "355960", "8600001100000", 1000000, 10, 1),
(52, "703100", "1603100100000", 1000000, 10, 1),
(52, "734400", "5200000100000", 1000000, 9, 1),
(52, "44031", "4200001200000", 1000000, 11, 1),
(52, "147685", "7101700100000", 1000000, 9, 1),
(52, "825368", "2300000600000", 1000000, 10, 1),
(52, "978363", "5400000100000", 1000000, 11, 1),
(52, "676900", "2100002400000", 1000000, 10, 1),
(52,679313, "6100000900000", 1000000, 10, 1),
(52, "784235", "5002100100000", 1000000, 8, 1),
(52, "583590", "4000000200000", 1000000, 9, 1),
(52, "657840", "5002200100000", 1000000, 8, 1),
(52, "531666", "5500000100000", 1000000, 11, 1),
(52, "890385", "5700000100000", 1000000, 9, 1),
(52, "39489", "5600000100000", 1000000, 10, 1),
(52, "427741", "5000002600000", 1000000, 8, 1),
(52, "425427", "5600000400000", 1000000, 10, 1),
(52, "264450", "5800000100000", 1000000, 10, 1),
(52, "964424", "6600001600000", 1000000, 10, 1),
(52, "860613", "7600000200000", 1000000, 9, 1),
(52, "664002", "5900000100000", 1000000, 10, 1),
(52, "436308", "7800000800000", 1000000, 9, 1),
(52, "362254", "1000000100000", 1000000, 10, 1),
(52, "235762", "5000002400000", 1000000, 8, 1),
(52, "690606", "6000000100000", 1000000, 10, 1),
(52, "619837", "7800000900000", 1000000, 9, 1),
(52, "479388", "5002700100000", 1000000, 8, 1),
(52, "84034", "2600000700000", 1000000, 10, 1),
(52, "313226", "5002800100000", 1000000, 8, 1),
(52, "250611", "5000001600000", 1000000, 8, 1),
(52, "261052", "7601400100000", 1000000, 9, 1),
(52, "869170", "6100000100000", 1000000, 10, 1),
(52, "586571", "7601500100000", 1000000, 9, 1),
(52, "785125", "6200000100000", 1000000, 9, 1),
(52, "249370", "0200000500000", 1000000, 10, 1),
(52, "308251", "6300000100000", 1000000, 10, 1),
(52, "891320", "7800000000000", 1000000, 9, 1),
(52, "484515", "1300000100000", 1000000, 10, 1),
(52, "741005", "6400000100000", 1000000, 10, 1),
(52, "193435", "5200000300000", 1000000, 9, 1),
(52, "875318", "2900000400000", 1000000, 10, 1),
(52, "1072635", "5003000500000", 1000000, 8, 1),
(52, "797271", "5000002800000", 1000000, 8, 1),
(52, "1067750", "9100000700000", 1000000, 10, 1),
(52, "388827", "6700000300000", 1000000, 9, 1),
(52, "147634", "5003300100000", 1000000, 8, 1),
(52, "1072637", "4700000400000", 1000000, 9, 1),
(52, "279754", "2300000700000", 1000000, 10, 1),
(52, "980448", "2600000100000", 1000000, 10, 1),
(52, "185119", "3100000200000", 1000000, 9, 1),
(52, "205367", "0200001400000", 1000000, 10, 1),
(52, "336877", "5003400100000", 1000000, 8, 1),
(52, "362948", "8600001000000", 1000000, 10, 1),
(52, "748279", "6300000800000", 1000000, 10, 1),
(52, "386347", "1100000100000", 1000000, 10, 1),
(52, "985992", "6100001100000", 1000000, 10, 1),
(52, "110581", "6800000400000", 1000000, 9, 1),
(52, "726902", "6900000100000", 1000000, 9, 1),
(52, "220599", "6300000700000", 1000000, 10, 1),
(52, "314662", "7000000100000", 1000000, 11, 1),
(52, "698830", "7100000100000", 1000000, 9, 1),
(52, "649727", "7200000100000", 1000000, 10, 1),
(52, "674862", "0300000100000", 1000000, 11, 1),
(52,465798, "7102200100000", 1000000, 9, 1),
(52, "684600", "7300000100000", 1000000, 10, 1),
(52, "510493", "2500001100000", 1000000, 12, 1),
(52, "1009595", "0200000100000", 1000000, 10, 1),
(52, "175074", "1100000800000", 1000000, 10, 1),
(52, "535544", "5000001900000", 1000000, 8, 1),
(52, "7687", "2700000100000", 1000000, 12, 1),
(52,69794, "8600000100000", 1000000, 10, 1),
(52, "444369", "5000003000000", 1000000, 8, 1),
(52, "244445", "6300000600000", 1000000, 10, 1),
(52, "554977", "2100000100000", 1000000, 10, 1),
(52, "926982", "7400000100000", 1000000, 10, 1),
(52, "524228", "3500000200000", 1000000, 9, 1),
(52, "382872", "5003700100000", 1000000, 8, 1),
(52, "322940", "7500000100000", 1000000, 11, 1),
(52, "724297", "6100001200000", 1000000, 10, 1),
(52, "3518", "5004000100000", 1000000, 8, 1),
(52, "552926", "5000002100000", 1000000, 8, 1),
(52, "541829", "6400001300000", 1000000, 10, 1),
(52, "655320", "7600000100000", 1000000, 9, 1),

(52, "1008197", "0200000300000", 295+25, 10, 1),
(52, "221432", "0400000100000", 1000000, 11, 0),
(52, "1031914", "0700500100000", 495+25, 11, 1),
(52, "900507", "1602100100000", 295+25, 10, 1),
(52, "264196", "2200000900000", 1000000, 11, 0),
(52, "509302", "2500000300000", 545+25, 12, 1),
(52, "824857", "2800000100000", 1000000, 12, 0),
(52, "956329", "3701700100000", 345+25, 9, 1),
(52, "266580", "4100000100000", 1000000, 12, 0),
(52, "776983", "4700200100000", 295+25, 9, 1),
(52, "899598", "4700500008200", 295+25, 9, 1),
(52, "20415", "4701000300000", 295+25, 9, 1),
(52, "33593", "4701700100000", 295+25, 9, 1),
(52, "109472", "5000000101100", 355+25, 8, 1),
(52, "723861", "5200000400000", 245+25, 9, 1),
(52, "860684", "5200000700000", 245+25, 9, 1),
(52, "179636", "6500000100000", 1000000, 12, 0),
(52, "416292", "6600000300000", 295+25, 10, 1),
(52, "942515", "6800000200000", 345+25, 9, 1),
(52, "307849", "6900000600000", 295+25, 9, 1),
(52, "672193", "7600500100000", 295+25, 9, 1)
;

/* там где есть совпадение по пикпойнту - проставляем  цены для пользователя как у пикпойнта + 25 р. */
UPDATE delivery_points_config dpc JOIN fias f ON dpc.fias_id = f.id
    LEFT JOIN  delivery_points_config dpc_pickpoint ON dpc.fias_id = dpc_pickpoint.fias_id AND dpc_pickpoint.delivery_types_id = 21
SET dpc.price = dpc_pickpoint.price + 25
WHERE dpc.delivery_types_id = 52
    AND dpc_pickpoint.price IS NOT NULL;



/* пороги бесплатной доставки */
INSERT IGNORE INTO `delivery_config_free` (`fias_id`, `delivery_type`, `sum`, `is_active`) VALUES
(266580, @deliveryTypeHermesGsId, 5000, 1),
(315462, @deliveryTypeHermesGsId, 5000, 1),
(983798, @deliveryTypeHermesGsId, 7000, 1),
(984704, @deliveryTypeHermesGsId, 5000, 1)
;

INSERT INTO `package_costs` (`shipping_class`, `single_order`, `cost`, `date_start`, `date_end`) VALUES
('deliverypoint_hermes', 1, 9, '2019-01-01 00:00:00', '2033-01-01 00:00:00'),
('deliverypoint_hermes', 0, 9, '2019-01-01 00:00:00', '2033-01-01 00:00:00'),
('deliverypoint_hermesgs', 1, 9, '2019-01-01 00:00:00', '2033-01-01 00:00:00'),
('deliverypoint_hermesgs', 0, 9, '2019-01-01 00:00:00', '2033-01-01 00:00:00')
;

/* права на страницу обмена */
INSERT IGNORE INTO acl_rules (`module`, `controller`, `action`, `acl_rules_fake`) VALUES ('call', 'logistic', 'integration-with-hermes', 'N');
set @newRuleId = last_insert_id();
INSERT IGNORE INTO acl_settings (`acl_roles_id`, `acl_rules_id`, `access_type`, `assert`) VALUES (57, @newRuleId, 'ALLOW', '');
INSERT INTO `admin_menu` (`pid`, `name`, `url`) VALUES (351, 'Обмен с Hermes', '/call/logistic/integration-with-hermes');

INSERT IGNORE INTO acl_rules (`module`, `controller`, `action`, `acl_rules_fake`) VALUES ('call', 'logistic', 'unload-hermes-integration-data', 'N');
set @newRuleId = last_insert_id();
INSERT IGNORE INTO acl_settings (`acl_roles_id`, `acl_rules_id`, `access_type`, `assert`) VALUES (57, @newRuleId, 'ALLOW', '');

INSERT IGNORE INTO acl_rules (`module`, `controller`, `action`, `acl_rules_fake`) VALUES ('call', 'logistic', 'integration-with-hermes-archive', 'N');
set @newRuleId = last_insert_id();
INSERT IGNORE INTO acl_settings (`acl_roles_id`, `acl_rules_id`, `access_type`, `assert`) VALUES (57, @newRuleId, 'ALLOW', '');

ALTER TABLE log_api_requests_to_objects ADD COLUMN `status` VARCHAR(25) NOT NULL DEFAULT '' COMMENT 'Кастомный статус для каждого объекта в массовом запросе';