hRerQ1Y8

1DELETE FROM `admin_menu` WHERE  `_id`=52;
2
3INSERT IGNORE INTO acl_settings (acl_roles_id, acl_rules_id, access_type, assert)
4  SELECT aro.acl_roles_id, aru.acl_rules_id, 'ALLOW', ''
5  FROM acl_roles aro, acl_rules aru
6  WHERE aro.acl_roles_id IN (44) AND aru.module = 'call' AND aru.controller = 'stock' AND aru.action IN ('order-detail-by-item');
7
8DROP TABLE IF EXISTS remote_log_emarsys_request;
9CREATE TABLE `remote_log_emarsys_request`
10  ENGINE=FEDERATED
11  CONNECTION='mysql://logdb:5iVbj27p6JZmhwP2@logdb.ml:3306/logdb/log_emarsys_request'
12;
13
14ALTER TABLE `special_days`
15  ADD COLUMN `special_days_type` ENUM('default','new') NOT NULL DEFAULT 'default' AFTER `special_days_date_to`;
16
17UPDATE brands_we_love b
18JOIN (
19  SELECT count(bl.brandswelove_id) as cnt, bwl.brandswelove_id as brandswelove_id
20    FROM brands_we_love bwl
21      JOIN brands_love bl ON bl.brandswelove_id = bwl.brandswelove_id
22    GROUP BY bwl.brandswelove_id
23) t ON t.brandswelove_id = b.brandswelove_id
24SET b.brandswelove_loves_count = t.cnt;
25
26ALTER TABLE `suppliers_other`
27  CHANGE COLUMN `suppliers_other_quality_certificates_comment` `suppliers_other_quality_certificates_comment` TEXT NOT NULL
28COMMENT 'Дополнительная информация по ДПК';