INSERT INTO `acl_rules` (`module`, `controller`, `action`) VALUES ('call', 'marketing', 'show-promocode-customers');
INSERT INTO acl_settings (acl_roles_id, acl_rules_id, access_type) VALUES (23, LAST_INSERT_ID(), 'ALLOW');

DROP TABLE IF EXISTS `holidays`;
CREATE TABLE IF NOT EXISTS `holidays` (
  `holidays_id` INT(11) NOT NULL AUTO_INCREMENT,
  `date` DATE NOT NULL COMMENT 'Дата',
  `type` ENUM('holiday','working_day') NOT NULL DEFAULT 'holiday' COMMENT 'Тип записи: выходной или рабочий день',
  `date_added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`holidays_id`),
  KEY `type`(`type`),
  KEY `date_added`(`date_added`),
  UNIQUE INDEX `date` (`date`)
)
COMMENT 'Перенесенный holidays.ini. Добавляются только выходные дни, которые по умолчанию рабочие либо рабочие, которые по умолчанию выходные'
ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT IGNORE INTO `holidays` (`date`, `type`) VALUES

#2012

('2012-01-01', 'holiday'),
('2012-01-02', 'holiday'),
('2012-01-03', 'holiday'),
('2012-01-04', 'holiday'),
('2012-01-05', 'holiday'),
('2012-01-06', 'holiday'),
('2012-01-07', 'holiday'),
('2012-01-09', 'holiday'),
('2012-02-23', 'holiday'),
('2012-03-08', 'holiday'),
('2012-03-09', 'holiday'),
('2012-04-30', 'holiday'),
('2012-05-01', 'holiday'),
('2012-05-07', 'holiday'),
('2012-05-08', 'holiday'),
('2012-06-11', 'holiday'),
('2012-06-12', 'holiday'),
('2012-11-04', 'holiday'),
('2012-11-05', 'holiday'),
('2012-12-31', 'holiday'),

('2012-03-11', 'working_day'),
('2012-04-28', 'working_day'),
('2012-05-05', 'working_day'),
('2012-05-12', 'working_day'),
('2012-06-09', 'working_day'),
('2012-12-29', 'working_day'),

#2013

('2013-01-01', 'holiday'),
('2013-01-02', 'holiday'),
('2013-01-03', 'holiday'),
('2013-01-04', 'holiday'),
('2013-01-05', 'holiday'),
('2013-01-06', 'holiday'),
('2013-01-07', 'holiday'),
('2013-01-08', 'holiday'),
('2013-02-23', 'holiday'),
('2013-03-08', 'holiday'),
('2013-05-01', 'holiday'),
('2013-05-02', 'holiday'),
('2013-05-03', 'holiday'),
('2013-05-09', 'holiday'),
('2013-05-10', 'holiday'),
('2013-06-12', 'holiday'),
('2013-11-04', 'holiday'),

#2014

('2014-01-01', 'holiday'),
('2014-01-02', 'holiday'),
('2014-01-03', 'holiday'),
('2014-01-04', 'holiday'),
('2014-01-05', 'holiday'),
('2014-01-06', 'holiday'),
('2014-01-07', 'holiday'),
('2014-01-08', 'holiday'),
('2014-03-10', 'holiday'),
('2014-05-01', 'holiday'),
('2014-05-02', 'holiday'),
('2014-05-09', 'holiday'),
('2014-06-12', 'holiday'),
('2014-06-13', 'holiday'),
('2014-11-03', 'holiday'),
('2014-11-04', 'holiday'),

#2015

('2015-01-01', 'holiday'),
('2015-01-02', 'holiday'),
('2015-01-05', 'holiday'),
('2015-01-06', 'holiday'),
('2015-01-07', 'holiday'),
('2015-01-08', 'holiday'),
('2015-01-09', 'holiday'),
('2015-02-23', 'holiday'),
('2015-03-09', 'holiday'),
('2015-05-01', 'holiday'),
('2015-05-04', 'holiday'),
('2015-05-11', 'holiday'),
('2015-06-12', 'holiday'),
('2015-11-04', 'holiday'),

#2016

('2016-01-01', 'holiday'),
('2016-01-04', 'holiday'),
('2016-01-05', 'holiday'),
('2016-01-06', 'holiday'),
('2016-01-07', 'holiday'),
('2016-01-08', 'holiday'),
('2016-02-22', 'holiday'),
('2016-02-23', 'holiday'),
('2016-03-07', 'holiday'),
('2016-03-08', 'holiday'),
('2016-05-02', 'holiday'),
('2016-05-03', 'holiday'),
('2016-05-09', 'holiday'),
('2016-06-13', 'holiday'),
('2016-11-04', 'holiday'),
('2016-02-20', 'working_day');

#1
UPDATE status_maps_accepts_structures_buttons SET can_hide_comment = 'N'
WHERE status_maps_accepts_structures_buttons_id IN(2, 7);

INSERT INTO acl_rules (module, controller, action, acl_rules_fake) VALUES
    ('call', 'event', 'change-hide-comment', 'N')
;

#2
UPDATE status_maps_accepts_structures_buttons SET can_hide_comment = 'N'
WHERE status_maps_accepts_structures_buttons_id = 18;

#3
UPDATE entities_statuses SET
    entities_statuses_class = 'blue'
    WHERE `entities_id` = '17'
;
UPDATE entities_statuses SET
    entities_statuses_class = 'red'
    WHERE `entities_id` = '17' AND statuses_id IN(5, 18)
;

#9
ALTER TABLE files_groups
    ADD COLUMN files_types_id INT NOT NULL DEFAULT 0 AFTER files_groups_id
;

UPDATE files_groups fg
    JOIN files f ON f.object_id = fg.files_groups_id AND f.component = fg.component
    SET fg.files_types_id = f.files_types_id
    WHERE f.files_types_id IS NOT NULL
;

INSERT INTO acl_rules (module, controller, `action`) VALUES('partner', 'supplier-cabinet', 'change-documents-group');
SELECT @acl_rules_id := LAST_INSERT_ID() INTO @acl_rules;
INSERT INTO acl_settings (acl_roles_id, acl_rules_id, access_type, assert) VALUES
    (35, @acl_rules_id, 'ALLOW', '')
;

#10
INSERT INTO acl_settings (acl_roles_id, acl_rules_id, access_type, assert) VALUES
    (92, 1025, 'ALLOW', ''),
    (92, 1026, 'ALLOW', ''),
    (92, 1028, 'ALLOW', '')
;

#12
INSERT INTO acl_settings (acl_roles_id, acl_rules_id, access_type, assert) VALUES
    (14, 937, 'ALLOW', ''),
    (23, 937, 'ALLOW', ''),
    (54, 937, 'ALLOW', ''),
    (77, 937, 'ALLOW', '')
;

#13
UPDATE sub_status SET comment = 'Отказ ООО «МАМСИ». Предоставление известного брендового товара с большим количеством подлога на рынке'
WHERE sub_status_id = 149;

INSERT INTO
    acl_rules(module, controller, action, acl_rules_fake)
VALUES
    ('call', 'reviews', 'review-delete', 'N');

INSERT INTO
    acl_settings(acl_roles_id, acl_rules_id, access_type)
VALUES (
    (SELECT acl_roles_id FROM acl_roles WHERE acl_roles_title_en = 'callMarketing'),
    (SELECT acl_rules_id FROM acl_rules WHERE module = 'call' AND controller = 'reviews' AND action = 'review-delete'),
    'DENY'
);


/* 5 */
INSERT INTO classifier_binds_to_categories(object_id, classifier_subcategories_id, classifier_age_groups_id,
    classifier_categories_id, classifier_orientations_id, classifier_accessories_id, customers_id, date_added)
SELECT c.categories_id,
    cbtp.classifier_subcategories_id,
    cbtp.classifier_age_groups_id,
    cbtp.classifier_categories_id,
    NULL,
    NULL,
    1,
    now()

FROM categories AS c
    JOIN products_to_categories AS ptc ON ptc.categories_id = c.categories_id
        JOIN classifier_binds_to_products AS cbtp ON cbtp.object_id = ptc.products_id
    LEFT JOIN classifier_binds_to_categories AS cbtc ON cbtc.object_id = c.categories_id
WHERE cbtc.classifier_binds_to_categories_id IS NULL

GROUP BY c.categories_id,
    cbtp.classifier_categories_id,
    cbtp.classifier_subcategories_id,
    cbtp.classifier_age_groups_id;

DELETE FROM mail_templates WHERE code = 'check_pre_moderation';

DROP TABLE change_cnt_requests;

CREATE TABLE `customers_cards` (
    `customers_cards_id` BIGINT(20) UNSIGNED NOT NULL,
    `customers_id` INT(10) UNSIGNED NOT NULL,
    `customers_cards_mask` VARCHAR(16) NOT NULL,
    `date_added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`customers_cards_id`),
    INDEX `customers_id` (`customers_id`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;


CREATE TABLE `payments_requests` (
    `payments_requests_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `payments_requests_status_id` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
    `customers_id` INT(10) UNSIGNED NOT NULL,
    `amount` DECIMAL(15,2) UNSIGNED NOT NULL,
    `payment_system_id` INT(10) UNSIGNED NOT NULL,
    `type` ENUM('customers','orders') NOT NULL,
    `type_id` INT(10) UNSIGNED NOT NULL,
    `date_added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`payments_requests_id`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;

ALTER TABLE `log_yandex_mws`
    CHANGE COLUMN `service` `service` ENUM('createInvoice','confirmInvoice','returnPayment','repeatCardPayment') NOT NULL AFTER `log_yandex_mws_id`;

/* 3 */
INSERT INTO `products_options_ranges` (`id`, `min`, `max`, `option_id`, `object_id`, `component`, `style`) VALUES (NULL, '70DD', NULL, 1, 883, 'classifier_subcategories', 'button');
INSERT INTO `products_options_ranges` (`id`, `min`, `max`, `option_id`, `object_id`, `component`, `style`) VALUES (NULL, '75DD', NULL, 1, 883, 'classifier_subcategories', 'button');
INSERT INTO `products_options_ranges` (`id`, `min`, `max`, `option_id`, `object_id`, `component`, `style`) VALUES (NULL, '80DD', NULL, 1, 883, 'classifier_subcategories', 'button');
INSERT INTO `products_options_ranges` (`id`, `min`, `max`, `option_id`, `object_id`, `component`, `style`) VALUES (NULL, '85DD', NULL, 1, 883, 'classifier_subcategories', 'button');
INSERT INTO `products_options_ranges` (`id`, `min`, `max`, `option_id`, `object_id`, `component`, `style`) VALUES (NULL, '90DD', NULL, 1, 883, 'classifier_subcategories', 'button');