EtMC3AWP

1DROP TABLE IF EXISTS `orders_products_to_discounts`;
2CREATE TABLE `orders_products_to_discounts` (
3    `orders_products_to_discounts_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
4    `orders_products_id` INT UNSIGNED NOT NULL,
5    `discount_value` TINYINT UNSIGNED NOT NULL COMMENT 'Значение скидки в %',
6    `orders_id` INT UNSIGNED NOT NULL,
7    PRIMARY KEY (`orders_products_to_discounts_id`),
8    UNIQUE INDEX `orders_products_id` (`orders_products_id`),
9    INDEX `orders_id` (`orders_id`)
10)
11    COMMENT ='На какие товары в заказе применена скидка (кроме промокода)'
12    COLLATE = 'utf8_general_ci'
13    ENGINE = InnoDB
14;
15
16DROP TABLE IF EXISTS categories_discounts;
17CREATE TABLE `categories_discounts` (
18`categories_discounts_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
19`categories_discounts_amount` INT(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Пороговая сумма стоимости товаров',
20`categories_discounts_value` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Значение скидки в %',
21`categories_id` INT(10) UNSIGNED NOT NULL DEFAULT 0,
22`customers_id` INT(10) UNSIGNED NOT NULL DEFAULT 0,
23`is_deleted` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0,
24`date_added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
25`date_deleted` DATETIME NULL DEFAULT NULL COMMENT 'Дата удаления настройки',
26PRIMARY KEY (`categories_discounts_id`),
27INDEX `categories_id` (`categories_id`),
28INDEX `is_deleted` (`is_deleted`),
29INDEX `date_deleted` (`date_deleted`),
30INDEX `date_added` (`date_added`)
31)
32    COMMENT='Настройки скидок для акций'
33    COLLATE='utf8_general_ci'
34    ENGINE=InnoDB
35;
36
37-- права
38INSERT INTO `acl_rules` (`module`, `controller`, `action`) VALUES ('call', 'sale', 'discount-b2b');
39set @ruleId = last_insert_id();
40INSERT INTO `acl_settings` (`acl_roles_id`, `acl_rules_id`, `access_type`, `assert`) VALUES
41(101, @ruleId, 'ALLOW', ''),
42(95, @ruleId, 'ALLOW', ''),
43(50, @ruleId, 'ALLOW', '');
44
45INSERT INTO `acl_rules` (`module`, `controller`, `action`) VALUES ('call', 'sale', 'categories-add-discount-b2b');
46set @ruleId = last_insert_id();
47INSERT INTO `acl_settings` (`acl_roles_id`, `acl_rules_id`, `access_type`, `assert`) VALUES
48(101, @ruleId, 'ALLOW', ''),
49(95, @ruleId, 'ALLOW', ''),
50(50, @ruleId, 'ALLOW', '');
51
52INSERT INTO `acl_rules` (`module`, `controller`, `action`) VALUES ('call', 'sale', 'categories-remove-discount-b2b');
53set @ruleId = last_insert_id();
54INSERT INTO `acl_settings` (`acl_roles_id`, `acl_rules_id`, `access_type`, `assert`) VALUES
55(101, @ruleId, 'ALLOW', ''),
56(95, @ruleId, 'ALLOW', ''),
57(50, @ruleId, 'ALLOW', '');
58
59-- новый столбец для скидки по предоплате
60ALTER TABLE `products_prices`
61    ADD COLUMN `products_prepaid_discount` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Скидка на товар при предоплате заказа' AFTER `products_trade_price_currencies_id`;