7B3KmYQh

1ALTER TABLE `refunds_acts_to_objects` ADD `is_deleted` TINYINT(4)  NOT NULL  DEFAULT '0'  AFTER `refunds_acts_to_object_products_count_total`;
2
3ALTER TABLE `reviews`
4  COLLATE='utf8mb4_general_ci',
5  CHANGE COLUMN `comment` `comment` TEXT NOT NULL COLLATE 'utf8mb4_general_ci' AFTER `customers_id`;
6
7ALTER TABLE customers_surveys ADD COLUMN `call_back_to` TIMESTAMP NULL DEFAULT NULL AFTER call_back;
8
9INSERT IGNORE INTO acl_rules (module, controller, action) VALUES ('call', 'stock', 'move_between_warehouses');
10
11insert into categories_status (status_id, status_name) values (37, 'Предпоставка');
12
13update `classifier_binds_to_products` set `classifier_subcategories_id`=1684, `classifier_categories_id` = 3 WHERE `classifier_subcategories_id`=124;
14
15DELETE FROM admin_menu WHERE url = '/call/accept/';
16
17ALTER TABLE `shipping_acts`
18  CHANGE COLUMN `component` `component` ENUM('orders','pallets', 'objects') NOT NULL DEFAULT 'orders' AFTER `act_type`;
19
20
21CREATE TABLE `shipping_acts_objects` (
22  `shipping_acts_id` INT(11) UNSIGNED NOT NULL,
23  `orders_id` INT(11) UNSIGNED NOT NULL,
24  `objects_id` INT(11) UNSIGNED NOT NULL,
25  `entities_id` INT(11) UNSIGNED NOT NULL,
26  `fulfilments_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
27  PRIMARY KEY (`shipping_acts_id`, `orders_id`, `objects_id`, `entities_id`)
28)
29COLLATE='utf8_general_ci'
30ENGINE=InnoDB
31;
32
33ALTER TABLE `fulfilments`
34    ADD COLUMN `delivery_type_id` INT UNSIGNED NULL DEFAULT NULL AFTER `fulfilments_color`;
35UPDATE `fulfilments` SET `delivery_type_id`='46' WHERE  `fulfilments_id` = 1;
36
37CREATE TABLE `fulfilments_income_packages_info` (
38  `fulfilments_income_packages_id` INT(10) UNSIGNED NOT NULL,
39  `fulfilments_income_packages_weight` DECIMAL(10,2) UNSIGNED NOT NULL COMMENT 'Вес (в кг)',
40  PRIMARY KEY (`fulfilments_income_packages_id`)
41)
42COLLATE='utf8_general_ci'
43ENGINE=InnoDB
44;
45
46insert ignore into fulfilments_income_packages_info (fulfilments_income_packages_id, fulfilments_income_packages_weight)
47    select fip.fulfilments_income_packages_id, pa.products_weight
48    from fulfilments_income_packages as fip
49    join products_attributes as pa on pa.products_attributes_id = fip.products_attributes_id
50;
51
52
53set @mainStorekeeperRole = 9;
54set @mainReturnerRole = 63;
55
56INSERT IGNORE INTO `acl_rules` (`module`, `controller`, `action`) VALUES ('call', 'stock', 'shipping-refund-fulfilment');
57set @url_1 = last_insert_id();
58INSERT IGNORE INTO `acl_rules` (`module`, `controller`, `action`) VALUES ('call', 'stock', 'shipping-refund-fulfilment-scan');
59set @url_2 = last_insert_id();
60INSERT IGNORE INTO `acl_rules` (`module`, `controller`, `action`) VALUES ('call', 'stock', 'shipping-refund-fulfilment-remove');
61set @url_3 = last_insert_id();
62INSERT IGNORE INTO `acl_rules` (`module`, `controller`, `action`) VALUES ('call', 'stock', 'shipping-refund-fulfilment-create-act');
63set @url_4 = last_insert_id();
64INSERT IGNORE INTO `acl_rules` (`module`, `controller`, `action`) VALUES ('call', 'stock', 'shipping-refund-fulfilment-create-inventory');
65set @url_5 = last_insert_id();
66
67
68INSERT IGNORE INTO `acl_settings` (`acl_roles_id`, `acl_rules_id`, `access_type`, `assert`)
69    VALUES  (@mainStorekeeperRole, @url_1, 'ALLOW', ''),
70            (@mainStorekeeperRole, @url_2, 'ALLOW', ''),
71            (@mainStorekeeperRole, @url_3, 'ALLOW', ''),
72            (@mainStorekeeperRole, @url_4, 'ALLOW', ''),
73            (@mainStorekeeperRole, @url_5, 'ALLOW', ''),
74            (@mainReturnerRole, @url_1, 'ALLOW', ''),
75            (@mainReturnerRole, @url_2, 'ALLOW', ''),
76            (@mainReturnerRole, @url_3, 'ALLOW', ''),
77            (@mainReturnerRole, @url_4, 'ALLOW', ''),
78            (@mainReturnerRole, @url_5, 'ALLOW', '')
79;
80
81INSERT IGNORE INTO `admin_menu` (`pid`, `name`, `url`) VALUES ('5', 'Отгрузка возвратов GA в FF', '/call/stock/shipping-refund-fulfilment');
82
83UPDATE bestsellers b
84SET b.bestsellers_type = 3
85WHERE b.bestsellers_type = 0;
86
87UPDATE bestsellers b
88SET b.bestsellers_type = 2
89WHERE b.bestsellers_type = 1;
90
91ALTER TABLE `bestsellers`
92  ADD COLUMN `bestsellers_banner_file_width` INT NOT NULL AFTER `bestsellers_banner_file`,
93  ADD COLUMN `bestsellers_banner_file_height` INT NOT NULL AFTER `bestsellers_banner_file_width`;
94
95drop table if exists bestsellers_areas;
96CREATE TABLE `bestsellers_areas` (
97  `bestsellers_areas_id` INT(11) NOT NULL AUTO_INCREMENT,
98  `bestsellers_id` INT(11) NOT NULL DEFAULT '0',
99  `bestsellers_areas_type` ENUM('filter','bestseller','category','product') NOT NULL,
100  `object_id` INT(11) NOT NULL DEFAULT '0',
101  `bestsellers_areas_data` TEXT NOT NULL,
102  PRIMARY KEY (`bestsellers_areas_id`),
103  INDEX `bestsellers_id` (`bestsellers_id`)
104)
105COLLATE='utf8_general_ci'
106ENGINE=InnoDB
107;
108
109ALTER TABLE `fulfilments_income_packages`
110ADD COLUMN `first_products_attributes_id` INT(10) UNSIGNED NULL DEFAULT NULL
111AFTER `products_attributes_id`;
112
113UPDATE fulfilments_income_packages fip
114SET fip.first_products_attributes_id = fip.products_attributes_id;
115
116DROP TABLE IF EXISTS `cards_banks`;
117CREATE TABLE IF NOT EXISTS `cards_banks` (
118  `number` int(10) unsigned NOT NULL,
119  `bank` varchar(128) NOT NULL,
120  PRIMARY KEY (`number`)
121) ENGINE=InnoDB DEFAULT CHARSET=utf8;
122
123INSERT INTO `cards_banks` (`number`, `bank`) VALUES (400287, 'soyuz'),(400648, 'center-invest'),(400881, 'soyuz'),(402326, 'mib'),(402327, 'mib'),(402328, 'mib'),(402457, 'novikombank'),(402538, 'binbank'),(402549, 'mib'),(402578, 'inteza'),(402877, 'transcapital'),(402909, 'novikombank'),(402910, 'novikombank'),(402911, 'novikombank'),(403828, 'fnp-bank'),(403829, 'fnp-bank'),(403830, 'fnp-bank'),(403896, 'avangard'),(403897, 'avangard'),(403898, 'avangard'),(404114, 'avangard'),(404160, 'expobank'),(404204, 'mts-bank'),(404224, 'mts-bank'),(404266, 'mts-bank'),(404267, 'mts-bank'),(404268, 'mts-bank'),(404269, 'mts-bank'),(404270, 'gasprom'),(404862, 'rosbank'),(404890, 'rosbank'),(404892, 'rosbank'),(405844, 'probusiness'),(405845, 'probusiness'),(405846, 'probusiness'),(405847, 'probusiness'),(405992, 'leto-bank'),(406140, 'vbrr'),(406141, 'vbrr'),(406180, 'intercommerz'),(406181, 'intercommerz'),(406182, 'intercommerz'),(406356, 'mts-bank'),(406726, 'globex'),(406767, 'rosbank'),(406777, 'jugra'),(406778, 'jugra'),(406780, 'jugra'),(406781, 'jugra'),(406790, 'otkritie'),(406791, 'otkritie'),(406792, 'otkritie'),(407564, 'rosbank'),(408373, 'crediteuropebank'),(409755, 'otkritie'),(409756, 'otkritie'),(410243, 'alfabank'),(410244, 'alfabank'),(410245, 'alfabank'),(410246, 'alfabank'),(410247, 'alfabank'),(410584, 'alfabank'),(411647, 'crediteuropebank'),(411648, 'crediteuropebank'),(411649, 'crediteuropebank'),(411717, 'center-invest'),(411718, 'center-invest'),(412519, 'rosbank'),(413064, 'bank-moskvi'),(413203, 'vbrr'),(413204, 'vbrr'),(413205, 'vbrr'),(413229, 'probusiness'),(413877, 'skb-bank'),(413878, 'skb-bank'),(413879, 'skb-bank'),(414656, 'zenit'),(414657, 'zenit'),(414658, 'zenit'),(414659, 'zenit'),(415400, 'alfabank'),(415428, 'alfabank'),(415429, 'alfabank'),(415481, 'alfabank'),(415482, 'alfabank'),(416956, 'rosbank'),(416982, 'rgs'),(416983, 'rgs'),(416984, 'rgs'),(417225, 'tatfondbank'),(417226, 'tatfondbank'),(417227, 'tatfondbank'),(417250, 'russtandart'),(417251, 'russtandart'),(417252, 'russtandart'),(417253, 'russtandart'),(417254, 'russtandart'),(417291, 'russtandart'),(417627, 'visa-qiwi'),(417628, 'visa-qiwi'),(417629, 'visa-qiwi'),(417676, 'otkritie'),(419149, 'az-to-bank'),(419150, 'az-to-bank'),(419151, 'az-to-bank'),(419152, 'az-to-bank'),(419153, 'az-to-bank'),(419163, 'avangard'),(419540, 'alfabank'),(419905, 'rossiya'),(420102, 'alfabank'),(420103, 'alfabank'),(420104, 'alfabank'),(420105, 'alfabank'),(420106, 'alfabank'),(420108, 'alfabank'),(421118, 'alfabank'),(421169, 'inteza'),(421170, 'inteza'),(421171, 'inteza'),(422081, 'expobank'),(422605, 'alfabank'),(422608, 'rsb'),(423169, 'rosbank'),(423217, 'tatfondbank'),(423649, 'vneshprombank'),(423719, 'alfabank'),(424352, 'soyuz'),(424436, 'akbars'),(424437, 'akbars'),(424438, 'akbars'),(424439, 'akbars'),(424440, 'akbars'),(424547, 'globex'),(424548, 'globex'),(424646, 'bank-moskvi'),(425153, 'rosbank'),(425175, 'binbank'),(425534, 'express-bank'),(425535, 'express-bank'),(425656, 'otkritie'),(426343, 'sberbank'),(426740, 'visa-qiwi'),(426809, 'rossiya'),(426810, 'rossiya'),(426811, 'rossiya'),(426812, 'rossiya'),(426813, 'rossiya'),(426814, 'rossiya'),(426815, 'rossiya'),(427218, 'alfabank'),(427229, 'vtb24'),(427275, 'bank-moskvi'),(427400, 'sberbank'),(427401, 'sberbank'),(427402, 'sberbank'),(427403, 'sberbank'),(427404, 'sberbank'),(427405, 'sberbank'),(427406, 'sberbank'),(427407, 'sberbank'),(427408, 'sberbank'),(427409, 'sberbank'),(427410, 'sberbank'),(427411, 'sberbank'),(427412, 'sberbank'),(427413, 'sberbank'),(427414, 'sberbank'),(427416, 'sberbank'),(427417, 'sberbank'),(427418, 'sberbank'),(427419, 'sberbank'),(427420, 'sberbank'),(427421, 'sberbank'),(427422, 'sberbank'),(427423, 'sberbank'),(427424, 'sberbank'),(427425, 'sberbank'),(427426, 'sberbank'),(427427, 'sberbank'),(427428, 'sberbank'),(427429, 'sberbank'),(427430, 'sberbank'),(427431, 'sberbank'),(427433, 'sberbank'),(427434, 'sberbank'),(427435, 'sberbank'),(427437, 'sberbank'),(427438, 'sberbank'),(427439, 'sberbank'),(427440, 'sberbank'),(427441, 'sberbank'),(427442, 'sberbank'),(427443, 'sberbank'),(427444, 'sberbank'),(427445, 'sberbank'),(427446, 'sberbank'),(427447, 'sberbank'),(427448, 'sberbank'),(427449, 'sberbank'),(427450, 'sberbank'),(427451, 'sberbank'),(427453, 'sberbank'),(427454, 'sberbank'),(427455, 'sberbank'),(427456, 'sberbank'),(427457, 'sberbank'),(427458, 'sberbank'),(427459, 'sberbank'),(427460, 'sberbank'),(427461, 'sberbank'),(427462, 'sberbank'),(427463, 'sberbank'),(427465, 'sberbank'),(427466, 'sberbank'),(427467, 'sberbank'),(427468, 'sberbank'),(427469, 'sberbank'),(427470, 'sberbank'),(427471, 'sberbank'),(427472, 'sberbank'),(427473, 'sberbank'),(427474, 'sberbank'),(427475, 'sberbank'),(427476, 'sberbank'),(427477, 'sberbank'),(427491, 'sberbank'),(427499, 'sberbank'),(427600, 'sberbank'),(427601, 'sberbank'),(427602, 'sberbank'),(427603, 'sberbank'),(427604, 'sberbank'),(427605, 'sberbank'),(427606, 'sberbank'),(427607, 'sberbank'),(427608, 'sberbank'),(427609, 'sberbank'),(427610, 'sberbank'),(427611, 'sberbank'),(427612, 'sberbank'),(427613, 'sberbank'),(427614, 'sberbank'),(427615, 'sberbank'),(427616, 'sberbank'),(427617, 'sberbank'),(427618, 'sberbank'),(427619, 'sberbank'),(427620, 'sberbank'),(427621, 'sberbank'),(427622, 'sberbank'),(427624, 'sberbank'),(427625, 'sberbank'),(427626, 'sberbank'),(427627, 'sberbank'),(427628, 'sberbank'),(427629, 'sberbank'),(427630, 'sberbank'),(427631, 'sberbank'),(427632, 'sberbank'),(427633, 'sberbank'),(427634, 'sberbank'),(427635, 'sberbank'),(427636, 'sberbank'),(427637, 'sberbank'),(427638, 'sberbank'),(427639, 'sberbank'),(427640, 'sberbank'),(427641, 'sberbank'),(427642, 'sberbank'),(427643, 'sberbank'),(427644, 'sberbank'),(427645, 'sberbank'),(427646, 'sberbank'),(427647, 'sberbank'),(427648, 'sberbank'),(427649, 'sberbank'),(427650, 'sberbank'),(427651, 'sberbank'),(427652, 'sberbank'),(427653, 'sberbank'),(427654, 'sberbank'),(427655, 'sberbank'),(427656, 'sberbank'),(427657, 'sberbank'),(427658, 'sberbank'),(427659, 'sberbank'),(427660, 'sberbank'),(427661, 'sberbank'),(427662, 'sberbank'),(427663, 'sberbank'),(427664, 'sberbank'),(427665, 'sberbank'),(427666, 'sberbank'),(427667, 'sberbank'),(427668, 'sberbank'),(427669, 'sberbank'),(427670, 'sberbank'),(427671, 'sberbank'),(427672, 'sberbank'),(427673, 'sberbank'),(427674, 'sberbank'),(427675, 'sberbank'),(427676, 'sberbank'),(427677, 'sberbank'),(427678, 'sberbank'),(427679, 'sberbank'),(427680, 'sberbank'),(427681, 'sberbank'),(427684, 'sberbank'),(427685, 'sberbank'),(427686, 'sberbank'),(427687, 'sberbank'),(427688, 'sberbank'),(427689, 'sberbank'),(427690, 'sberbank'),(427692, 'sberbank'),(427693, 'sberbank'),(427694, 'sberbank'),(427695, 'sberbank'),(427696, 'sberbank'),(427697, 'sberbank'),(427714, 'alfabank'),(427715, 'rosbank'),(427726, 'bank-moskvi'),(427754, 'expobank'),(427871, 'tatfondbank'),(427900, 'sberbank'),(427902, 'sberbank'),(427903, 'sberbank'),(427904, 'sberbank'),(427905, 'sberbank'),(427906, 'sberbank'),(427907, 'sberbank'),(427908, 'sberbank'),(427910, 'sberbank'),(427911, 'sberbank'),(427912, 'sberbank'),(427913, 'sberbank'),(427914, 'sberbank'),(427915, 'sberbank'),(427916, 'sberbank'),(427917, 'sberbank'),(427918, 'sberbank'),(427919, 'sberbank'),(427920, 'sberbank'),(427921, 'sberbank'),(427922, 'sberbank'),(427923, 'sberbank'),(427924, 'sberbank'),(427925, 'sberbank'),(427927, 'sberbank'),(427928, 'sberbank'),(427929, 'sberbank'),(427930, 'sberbank'),(427931, 'sberbank'),(427932, 'sberbank'),(427933, 'sberbank'),(427934, 'sberbank'),(427935, 'sberbank'),(427936, 'sberbank'),(427937, 'sberbank'),(427938, 'sberbank'),(427939, 'sberbank'),(427940, 'sberbank'),(427941, 'sberbank'),(427942, 'sberbank'),(427943, 'sberbank'),(427944, 'sberbank'),(427945, 'sberbank'),(427946, 'sberbank'),(427947, 'sberbank'),(427948, 'sberbank'),(427949, 'sberbank'),(427950, 'sberbank'),(427951, 'sberbank'),(427952, 'sberbank'),(427953, 'sberbank'),(427954, 'sberbank'),(427955, 'sberbank'),(427956, 'sberbank'),(427957, 'sberbank'),(427958, 'sberbank'),(427960, 'sberbank'),(427961, 'sberbank'),(427962, 'sberbank'),(427963, 'sberbank'),(427964, 'sberbank'),(427965, 'sberbank'),(427966, 'sberbank'),(427967, 'sberbank'),(427968, 'sberbank'),(427969, 'sberbank'),(427970, 'sberbank'),(427971, 'sberbank'),(427972, 'sberbank'),(427973, 'sberbank'),(427974, 'sberbank'),(427975, 'sberbank'),(427976, 'sberbank'),(427977, 'sberbank'),(427978, 'sberbank'),(427979, 'sberbank'),(427980, 'sberbank'),(427982, 'sberbank'),(427983, 'sberbank'),(427984, 'sberbank'),(427986, 'sberbank'),(427988, 'sberbank'),(427989, 'sberbank'),(427990, 'sberbank'),(427991, 'sberbank'),(427992, 'sberbank'),(427993, 'sberbank'),(427994, 'sberbank'),(427995, 'sberbank'),(427996, 'sberbank'),(427997, 'sberbank'),(427998, 'sberbank'),(427999, 'sberbank'),(428122, 'visa-qiwi'),(428247, 'baltinvestbank'),(428248, 'baltinvestbank'),(428249, 'baltinvestbank'),(428266, 'zenit'),(428804, 'alfabank'),(428905, 'alfabank'),(428906, 'alfabank'),(429158, 'bank-moskvi'),(429907, 'finservice'),(429908, 'finservice'),(430112, 'mfk'),(430113, 'mfk'),(430114, 'mfk'),(430312, 'center-invest'),(430314, 'center-invest'),(430708, 'rossiya'),(430709, 'rossiya'),(431336, 'bank-moskvi'),(431359, 'rgs'),(431416, 'alfabank'),(431417, 'alfabank'),(431727, 'alfabank'),(432158, 'crediteuropebank'),(432638, 'rosbank'),(432974, 'soyuz'),(433710, 'soyuz'),(433711, 'soyuz'),(433920, 'binbank'),(434135, 'alfabank'),(434381, 'soyuz'),(434382, 'soyuz'),(434383, 'soyuz'),(434384, 'soyuz'),(437351, 'otkritie'),(437435, 'sberbank'),(437773, 'tinkoff'),(437985, 'sberbank'),(438138, 'alfabank'),(438139, 'alfabank'),(438140, 'alfabank'),(438933, 'rosbank'),(438970, 'rosbank'),(438971, 'rosbank'),(439000, 'alfabank'),(439077, 'alfabank'),(439245, 'globex'),(440237, 'alfabank'),(440503, 'rosbank'),(440505, 'rosbank'),(440540, 'rosbank'),(440541, 'rosbank'),(443886, 'express-bank'),(443887, 'express-bank'),(443888, 'express-bank'),(444094, 'express-bank'),(445034, 'tatfondbank'),(445433, 'homecredit'),(445434, 'homecredit'),(445435, 'homecredit'),(445636, 'mfk'),(445637, 'mfk'),(446065, 'otkritie'),(458280, 'alfabank'),(458410, 'alfabank'),(458411, 'alfabank'),(458449, 'mfk'),(458450, 'alfabank'),(458488, 'az-to-bank'),(458489, 'az-to-bank'),(458490, 'az-to-bank'),(458521, 'alfabank'),(458527, 'center-invest'),(458559, 'novikombank'),(458722, 'rossiya'),(458723, 'rossiya'),(459937, 'rosbank'),(460052, 'intercommerz'),(462729, 'raiffeisen'),(465206, 'bank-moskvi'),(465207, 'bank-moskvi'),(465208, 'bank-moskvi'),(465218, 'bank-moskvi'),(469395, 'visa-qiwi'),(470434, 'zenit'),(471436, 'novikombank'),(472445, 'homecredit'),(472480, 'mib'),(472489, 'rgs'),(474159, 'otkritie'),(474218, 'rosbank'),(477908, 'rosbank'),(477932, 'alfabank'),(477964, 'alfabank'),(477986, 'rosbank'),(478471, 'vneshprombank'),(478472, 'vneshprombank'),(478474, 'transcapital'),(478475, 'transcapital'),(478476, 'transcapital'),(478488, 'fnp-bank'),(478752, 'alfabank'),(479004, 'alfabank'),(479087, 'alfabank'),(480232, 'zenit'),(480938, 'mib'),(481776, 'sberbank'),(484891, 'inteza'),(485078, 'rocketbank'),(487415, 'gasprom'),(487432, 'expobank'),(487433, 'expobank'),(487434, 'expobank'),(487435, 'expobank'),(488951, 'skb-bank'),(488967, 'soyuz'),(488968, 'soyuz'),(488993, 'vneshprombank'),(489008, 'soyuz'),(489049, 'visa-qiwi'),(489095, 'soyuz'),(499932, 'rosbank'),(499966, 'rosbank'),(508406, 'raiffeisen'),(510047, 'russtandart'),(510069, 'raiffeisen'),(510070, 'raiffeisen'),(510074, 'unicredit'),(510092, 'russtandart'),(510126, 'alfabank'),(510144, 'vtb24'),(510170, 'intercommerz'),(510621, 'ym'),(512273, 'crediteuropebank'),(512449, 'zenit'),(512762, 'citibank'),(513691, 'russtandart'),(514082, 'gasprom'),(515587, 'mib'),(515605, 'rosbank'),(515760, 'zenit'),(515770, 'moscredbank'),(515783, 'tatfondbank'),(515785, 'mdm'),(515842, 'sberbank'),(515848, 'promsvyazbank'),(515854, 'citibank'),(515876, 'raiffeisen'),(516333, 'zenit'),(516358, 'zenit'),(516473, 'promsvyazbank'),(517667, 'zenit'),(517955, 'mts-bank'),(518079, 'rosbank'),(518228, 'gasprom'),(518373, 'gasprom'),(518486, 'promsvyazbank'),(518586, 'mdm'),(518591, 'vtb24'),(518640, 'vtb24'),(518642, 'rosbank'),(518647, 'zenit'),(518704, 'gasprom'),(518788, 'mdm'),(518816, 'gasprom'),(518876, 'mdm'),(518882, 'rosbank'),(518901, 'tinkoff'),(518902, 'gasprom'),(518946, 'promsvyazbank'),(518951, 'promsvyazbank'),(518961, 'binbank'),(518970, 'promsvyazbank'),(518977, 'promsvyazbank'),(518981, 'promsvyazbank'),(518996, 'unicredit'),(518997, 'unicredit'),(519304, 'vtb24'),(519998, 'vtb24'),(520085, 'promsvyazbank'),(520088, 'promsvyazbank'),(520306, 'citibank'),(520328, 'mdm'),(520373, 'promsvyazbank'),(520920, 'smp-bank'),(520957, 'crediteuropebank'),(520993, 'crediteuropebank'),(521124, 'promsvyazbank'),(521144, 'crediteuropebank'),(521155, 'gasprom'),(521172, 'rgs'),(521178, 'alfabank'),(521194, 'zenit'),(521324, 'tinkoff'),(521326, 'smp-bank'),(521801, 'moscredbank'),(521830, 'crediteuropebank'),(522193, 'gasprom'),(522199, 'homecredit'),(522223, 'avangard'),(522224, 'avangard'),(522456, 'zenit'),(522458, 'unicredit'),(522477, 'gasprom'),(522826, 'gasprom'),(522851, 'zenit'),(522858, 'spb-bank'),(522988, 'gasprom'),(522989, 'gasprom'),(524860, 'mdm'),(524862, 'mdm'),(525446, 'rsb'),(525494, 'promsvyazbank'),(525689, 'citibank'),(525740, 'gasprom'),(525742, 'mdm'),(525744, 'mdm'),(525784, 'gasprom'),(525833, 'gasprom'),(525933, 'homecredit'),(525991, 'crediteuropebank'),(526280, 'promsvyazbank'),(526462, 'rosbank'),(526483, 'gasprom'),(526818, 'rgs'),(526891, 'zenit'),(527448, 'mdm'),(527450, 'mdm'),(527594, 'citibank'),(527883, 'vtb24'),(528053, 'raiffeisen'),(528701, 'promsvyazbank'),(528808, 'raiffeisen'),(528809, 'raiffeisen'),(528933, 'rosbank'),(529025, 'vtb24'),(529160, 'promsvyazbank'),(529278, 'gasprom'),(529938, 'vtb24'),(530114, 'gasprom'),(530145, 'transcapital'),(530172, 'unicredit'),(530183, 'otkritie'),(530403, 'otkritie'),(530441, 'promsvyazbank'),(530827, 'alfabank'),(530867, 'raiffeisen'),(530900, 'spb-bank'),(530993, 'gasprom'),(531034, 'crediteuropebank'),(531222, 'rosbank'),(531236, 'unicredit'),(531305, 'gasprom'),(531310, 'sberbank'),(531344, 'unicredit'),(531425, 'mdm'),(531534, 'promsvyazbank'),(531674, 'otkritie'),(531809, 'citibank'),(532130, 'openrocket'),(532184, 'moscredbank'),(532186, 'spb-bank'),(532301, 'otkritie'),(532315, 'crediteuropebank'),(532421, 'promsvyazbank'),(532461, 'zenit'),(532463, 'zenit'),(532684, 'gasprom'),(532835, 'mdm'),(532947, 'az-to-bank'),(532974, 'citibank'),(533201, 'citibank'),(533469, 'russtandart'),(533594, 'raiffeisen'),(533614, 'mdm'),(533616, 'raiffeisen'),(533669, 'sberbank'),(533681, 'citibank'),(533736, 'mts-bank'),(534130, 'gasprom'),(534162, 'rsb'),(534196, 'gasprom'),(534251, 'rosbank'),(536392, 'raiffeisen'),(536401, 'russtandart'),(536409, 'rsb'),(536511, 'homecredit'),(536995, 'gasprom'),(539036, 'mdm'),(539600, 'mdm'),(539607, 'zenit'),(539613, 'zenit'),(539621, 'promsvyazbank'),(539704, 'promsvyazbank'),(539714, 'otkritie'),(539726, 'citibank'),(539839, 'gasprom'),(539850, 'zenit'),(539861, 'promsvyazbank'),(539898, 'zenit'),(540035, 'rosbank'),(540154, 'vtb24'),(540194, 'mdm'),(540455, 'mdm'),(540616, 'mts-bank'),(540642, 'mdm'),(540664, 'gasprom'),(540670, 'soyuz'),(540788, 'citibank'),(541152, 'mdm'),(541269, 'promsvyazbank'),(541294, 'mdm'),(541435, 'mts-bank'),(541450, 'crediteuropebank'),(541587, 'mdm'),(541600, 'spb-bank'),(541715, 'bank-moskvi'),(541778, 'zenit'),(541903, 'rosbank'),(542033, 'moscredbank'),(542048, 'russtandart'),(542255, 'gasprom'),(542340, 'promsvyazbank'),(542504, 'mdm'),(542772, 'raiffeisen'),(543038, 'mdm'),(543101, 'spb-bank'),(543211, 'moscredbank'),(543236, 'zenit'),(543259, 'alfabank'),(543301, 'zenit'),(543366, 'mdm'),(543672, 'gasprom'),(543724, 'gasprom'),(543762, 'gasprom'),(543874, 'promsvyazbank'),(544025, 'zenit'),(544026, 'gasprom'),(544117, 'mdm'),(544218, 'otkritie'),(544237, 'raiffeisen'),(544561, 'gasprom'),(544800, 'promsvyazbank'),(544852, 'zenit'),(544962, 'otkritie'),(545037, 'sberbank'),(545101, 'gasprom'),(545115, 'raiffeisen'),(545160, 'russtandart'),(545182, 'citibank'),(545224, 'vtb24'),(545350, 'promsvyazbank'),(545762, 'homecredit'),(545896, 'zenit'),(545929, 'zenit'),(546766, 'promsvyazbank'),(546855, 'expobank'),(546902, 'sberbank'),(546903, 'sberbank'),(546904, 'sberbank'),(546905, 'sberbank'),(546906, 'sberbank'),(546907, 'sberbank'),(546908, 'sberbank'),(546909, 'sberbank'),(546910, 'sberbank'),(546911, 'sberbank'),(546912, 'sberbank'),(546913, 'sberbank'),(546916, 'sberbank'),(546917, 'sberbank'),(546918, 'sberbank'),(546920, 'sberbank'),(546922, 'sberbank'),(546925, 'sberbank'),(546926, 'sberbank'),(546927, 'sberbank'),(546928, 'sberbank'),(546930, 'sberbank'),(546931, 'sberbank'),(546935, 'sberbank'),(546936, 'sberbank'),(546937, 'sberbank'),(546938, 'sberbank'),(546939, 'sberbank'),(546940, 'sberbank'),(546941, 'sberbank'),(546942, 'sberbank'),(546943, 'sberbank'),(546944, 'sberbank'),(546945, 'sberbank'),(546947, 'sberbank'),(546948, 'sberbank'),(546949, 'sberbank'),(546951, 'sberbank'),(546952, 'sberbank'),(546953, 'sberbank'),(546954, 'sberbank'),(546955, 'sberbank'),(546956, 'sberbank'),(546959, 'sberbank'),(546960, 'sberbank'),(546961, 'sberbank'),(546962, 'sberbank'),(546963, 'sberbank'),(546964, 'sberbank'),(546966, 'sberbank'),(546967, 'sberbank'),(546968, 'sberbank'),(546969, 'sberbank'),(546970, 'sberbank'),(546972, 'sberbank'),(546974, 'sberbank'),(546975, 'sberbank'),(546977, 'sberbank'),(546999, 'sberbank'),(547243, 'mdm'),(547329, 'promsvyazbank'),(547348, 'gasprom'),(547377, 'mdm'),(547550, 'crediteuropebank'),(547601, 'rsb'),(547613, 'raiffeisen'),(547728, 'unicredit'),(547801, 'mdm'),(547927, 'sberbank'),(547931, 'sberbank'),(547932, 'sberbank'),(547947, 'sberbank'),(547952, 'sberbank'),(547955, 'sberbank'),(547961, 'sberbank'),(548027, 'gasprom'),(548092, 'mdm'),(548172, 'promsvyazbank'),(548265, 'mdm'),(548270, 'mdm'),(548387, 'ym'),(548401, 'sberbank'),(548402, 'sberbank'),(548407, 'sberbank'),(548410, 'sberbank'),(548412, 'sberbank'),(548413, 'sberbank'),(548416, 'sberbank'),(548420, 'sberbank'),(548425, 'sberbank'),(548426, 'sberbank'),(548427, 'sberbank'),(548428, 'sberbank'),(548429, 'promsvyazbank'),(548430, 'sberbank'),(548435, 'sberbank'),(548440, 'sberbank'),(548442, 'sberbank'),(548443, 'sberbank'),(548444, 'sberbank'),(548445, 'sberbank'),(548447, 'sberbank'),(548448, 'sberbank'),(548449, 'sberbank'),(548450, 'sberbank'),(548452, 'sberbank'),(548454, 'sberbank'),(548455, 'sberbank'),(548459, 'sberbank'),(548460, 'sberbank'),(548461, 'sberbank'),(548462, 'sberbank'),(548463, 'sberbank'),(548464, 'sberbank'),(548466, 'sberbank'),(548469, 'sberbank'),(548470, 'sberbank'),(548472, 'sberbank'),(548477, 'sberbank'),(548498, 'sberbank'),(548499, 'sberbank'),(548601, 'alfabank'),(548655, 'alfabank'),(548673, 'alfabank'),(548674, 'alfabank'),(548745, 'homecredit'),(548767, 'zenit'),(548999, 'gasprom'),(549000, 'gasprom'),(549024, 'otkritie'),(549025, 'otkritie'),(549098, 'gasprom'),(549223, 'vtb24'),(549270, 'vtb24'),(549302, 'unicredit'),(549349, 'mdm'),(549411, 'zenit'),(549413, 'zenit'),(549425, 'promsvyazbank'),(549439, 'promsvyazbank'),(549475, 'rosbank'),(549500, 'vtb24'),(549512, 'mdm'),(549523, 'mdm'),(549524, 'promsvyazbank'),(549600, 'gasprom'),(549715, 'rsb'),(549866, 'vtb24'),(549882, 'zenit'),(549888, 'zenit'),(549966, 'jugra'),(550025, 'mdm'),(550583, 'mts-bank'),(552175, 'alfabank'),(552573, 'citibank'),(552669, 'spb-bank'),(552680, 'moscredbank'),(552702, 'gasprom'),(552866, 'mdm'),(553496, 'raiffeisen'),(554279, 'promsvyazbank'),(554372, 'mdm'),(554373, 'mdm'),(554386, 'vtb24'),(554393, 'vtb24'),(554759, 'promsvyazbank'),(554761, 'rosbank'),(554780, 'zenit'),(554781, 'promsvyazbank'),(554782, 'rosbank'),(554834, 'expobank'),(555057, 'citibank'),(555058, 'citibank'),(555079, 'rosbank'),(555947, 'alfabank'),(555949, 'alfabank'),(555957, 'alfabank'),(556046, 'promsvyazbank'),(556052, 'gasprom'),(557029, 'zenit'),(557030, 'zenit'),(557056, 'crediteuropebank'),(557057, 'crediteuropebank'),(557071, 'mib'),(557072, 'mib'),(557734, 'homecredit'),(557944, 'zenit'),(557960, 'zenit'),(557976, 'mdm'),(557981, 'promsvyazbank'),(558254, 'promsvyazbank'),(558268, 'promsvyazbank'),(558273, 'raiffeisen'),(558355, 'gasprom'),(558385, 'jugra'),(558516, 'promsvyazbank'),(558518, 'vtb24'),(558536, 'raiffeisen'),(558620, 'otkritie'),(558625, 'mdm'),(558636, 'mdm'),(558672, 'promsvyazbank'),(558673, 'rosbank'),(558696, 'zenit'),(559900, 'ym'),(605461, 'sberbank'),(639002, 'sberbank'),(670508, 'promsvyazbank'),(670518, 'otkritie'),(670583, 'promsvyazbank'),(670611, 'promsvyazbank'),(670654, 'promsvyazbank'),(670661, 'promsvyazbank'),(676195, 'sberbank'),(676196, 'sberbank'),(676231, 'otkritie'),(676421, 'vtb24'),(676428, 'mdm'),(676444, 'promsvyazbank'),(676454, 'gasprom'),(676565, 'russtandart'),(676586, 'crediteuropebank'),(676625, 'raiffeisen'),(676672, 'unicredit'),(676934, 'mdm'),(676947, 'mdm'),(676948, 'spb-bank'),(676967, 'moscredbank'),(676974, 'vtb24'),(676990, 'gasprom'),(676998, 'mdm'),(677058, 'mdm'),(677088, 'akbars'),(677189, 'rgs'),(677225, 'tatfondbank'),(677263, 'promsvyazbank'),(677275, 'mdm'),(677276, 'mdm'),(677356, 'promsvyazbank'),(677358, 'mdm'),(677370, 'promsvyazbank'),(677371, 'promsvyazbank'),(677372, 'promsvyazbank'),(677406, 'mdm'),(677461, 'promsvyazbank'),(677462, 'promsvyazbank'),(677470, 'vtb24'),(677471, 'vtb24'),(677484, 'gasprom'),(677505, 'mdm'),(677506, 'promsvyazbank'),(677517, 'vtb24'),(677585, 'gasprom');
124
125ALTER TABLE `customers_cards`
126  ADD COLUMN `customers_cards_bank` VARCHAR(128) NOT NULL DEFAULT '' AFTER `customers_cards_mask`;
127
128UPDATE customers_cards as cc
129INNER JOIN cards_banks as cb ON cb.number = SUBSTRING_INDEX(cc.customers_cards_mask, '|', 1)
130SET cc.customers_cards_bank = cb.bank;
131
132
133INSERT INTO `currencies` (`currencies_title`) VALUES ('фунт стерлингов');
134ALTER TABLE `exchange_rates`
135ADD COLUMN `exchange_rates_gbp` DECIMAL(10,5) NOT NULL AFTER `exchange_rates_usd`;
136
137
138
139INSERT IGNORE INTO acl_settings (acl_roles_id, acl_rules_id, access_type, assert)
140  SELECT aro.acl_roles_id, aru.acl_rules_id, 'ALLOW', ''
141  FROM acl_roles aro, acl_rules aru
142  WHERE aro.acl_roles_id IN (60) AND aru.module = 'call' AND aru.controller = 'stock' AND aru.action IN ('move_between_warehouses');
143
144INSERT IGNORE INTO acl_rules (module, controller, action) VALUES ('call', 'customer', 'change-phone');
145
146INSERT IGNORE INTO acl_settings (acl_roles_id, acl_rules_id, access_type, assert)
147  SELECT aro.acl_roles_id, aru.acl_rules_id, 'ALLOW', ''
148  FROM acl_roles aro, acl_rules aru
149  WHERE aro.acl_roles_id IN (91) AND aru.module = 'call' AND aru.controller = 'customer' AND aru.action IN ('change-phone');