jtzfDpPD

1UPDATE `admin_menu` SET `pid`='5' WHERE  `_id`=258;
2
3ALTER TABLE `stock_zones`
4  ADD COLUMN `volume` float NULL DEFAULT NULL AFTER `color`;
5
6INSERT INTO `categories_status` (`status_name`) VALUES ('Поставка не получена');
7
8delete from stock_zones where is_active = 2;
9
10UPDATE `stock_zones` SET `name`='6 мск' WHERE  `stock_zones_id`=11;
11UPDATE `stock_zones` SET `name`='7 мск' WHERE  `stock_zones_id`=12;
12UPDATE `stock_zones` SET `name`='8 мск' WHERE  `stock_zones_id`=13;
13
14UPDATE `stock_zones` SET `name`='переносы питер' WHERE  `stock_zones_id`=40;
15
16ALTER TABLE `stock_zones`
17  ADD UNIQUE INDEX `name_type` (`name`, `type`);
18
19INSERT IGNORE INTO acl_settings (acl_roles_id, acl_rules_id, access_type, assert)
20  SELECT aro.acl_roles_id, aru.acl_rules_id, 'ALLOW', ''
21  FROM acl_roles aro, acl_rules aru
22  WHERE aro.acl_roles_id IN (11) AND aru.module = 'call' AND aru.controller = 'shop' AND aru.action IN ('products');
23
24INSERT IGNORE INTO acl_settings (acl_roles_id, acl_rules_id, access_type, assert)
25  SELECT aro.acl_roles_id, aru.acl_rules_id, 'ALLOW', ''
26  FROM acl_roles aro, acl_rules aru
27  WHERE aro.acl_roles_id IN (11) AND aru.module = 'call' AND aru.controller = 'shop' AND aru.action IN ('load-product-templates-tree');
28
29INSERT IGNORE INTO acl_settings (acl_roles_id, acl_rules_id, access_type, assert)
30  SELECT aro.acl_roles_id, aru.acl_rules_id, 'ALLOW', ''
31  FROM acl_roles aro, acl_rules aru
32  WHERE aro.acl_roles_id IN (50) AND aru.module = 'call' AND aru.controller = 'shop' AND aru.action IN ('products');
33
34INSERT IGNORE INTO acl_settings (acl_roles_id, acl_rules_id, access_type, assert)
35  SELECT aro.acl_roles_id, aru.acl_rules_id, 'ALLOW', ''
36  FROM acl_roles aro, acl_rules aru
37  WHERE aro.acl_roles_id IN (50) AND aru.module = 'call' AND aru.controller = 'shop' AND aru.action IN ('load-product-templates-tree');
38
39INSERT IGNORE INTO acl_settings (acl_roles_id, acl_rules_id, access_type, assert)
40  SELECT aro.acl_roles_id, aru.acl_rules_id, 'ALLOW', ''
41  FROM acl_roles aro, acl_rules aru
42  WHERE aro.acl_roles_id IN (40) AND aru.module = 'call' AND aru.controller = 'shop' AND aru.action IN ('inspection-scan');
43
44DROP TABLE IF EXISTS ab_testing_new_site;
45CREATE TABLE `ab_testing_new_site` (
46  `session_id` VARCHAR(64) NOT NULL,
47  `ab_test_id` TINYINT(1) NOT NULL,
48  `ab_test_part` TINYINT(1) NOT NULL,
49  `is_mobile` TINYINT(1) NOT NULL,
50  `user_agent` VARCHAR(255) NOT NULL,
51  `date_added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
52  `not_logined` TINYINT(1) NOT NULL,
53  PRIMARY KEY (`session_id`)
54)
55  COLLATE='utf8_general_ci'
56  ENGINE=InnoDB
57;
58
59DROP TABLE IF EXISTS customers_to_ab_testing_new_site;
60CREATE TABLE `customers_to_ab_testing_new_site` (
61  `customers_id` INT(11) NOT NULL,
62  `ab_testing_session_id` VARCHAR(255) NOT NULL, PRIMARY KEY (`customers_id`), INDEX `ab_testing_session_id` (`ab_testing_session_id`)
63) COLLATE='utf8_general_ci' ENGINE=InnoDB
64;