INSERT INTO orders_status (orders_status_id, orders_status_name) VALUES (17, 'Подтвержден');
INSERT INTO orders_status (orders_status_id, orders_status_name) VALUES (18, 'Не подтвержден');
INSERT INTO orders_status (orders_status_id, orders_status_name) VALUES (19, 'Отменен по вине поставщика');
INSERT INTO orders_status (orders_status_id, orders_status_name) VALUES (20, 'Отменен (1)');
INSERT INTO orders_status (orders_status_id, orders_status_name) VALUES (21, 'Отменен (2)');
INSERT INTO orders_status (orders_status_id, orders_status_name) VALUES (22, 'Частичный возврат');
INSERT INTO orders_status (orders_status_id, orders_status_name) VALUES (23, 'Назначена доставка');
INSERT INTO orders_status (orders_status_id, orders_status_name) VALUES (24, 'Отменен (3)');
INSERT INTO orders_status (orders_status_id, orders_status_name) VALUES (25, 'Отменен (4)');

UPDATE `orders_status` SET `orders_status_name`='Расформирован по недозвону' WHERE  `orders_status_id`=15 AND `language_id`=1 LIMIT 1;

ALTER TABLE `categories`
    ADD COLUMN `invoice_file` VARCHAR(255) NULL DEFAULT NULL AFTER `invoice_date`;

ALTER TABLE `suppliers_products`
    ADD COLUMN `is_deleted` INT(11) UNSIGNED NOT NULL DEFAULT '0' AFTER `products_in_stock`;

CREATE TABLE IF NOT EXISTS `suppliers_products_deleted` (
  `categories_id` INT(10) UNSIGNED NOT NULL,
  `products_id` INT(10) UNSIGNED NOT NULL,
  `products_attributes_id` INT(10) UNSIGNED NOT NULL,
  `products_in_stock` INT(10) UNSIGNED NOT NULL,
  `date_added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  UNIQUE KEY `categories_id_products_id_products_attributes_id` (`categories_id`,`products_id`,`products_attributes_id`),
  KEY `categories_id` (`categories_id`),
  KEY `products_id` (`products_id`),
  KEY `products_attributes_id` (`products_attributes_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

ALTER TABLE `customers`
    ADD COLUMN `customers_tried` TINYINT(1) NULL DEFAULT NULL AFTER `is_distribution_bonus`;

ALTER TABLE `orders_acts`
    ADD COLUMN `acts_name` VARCHAR(100) NULL AFTER `acts_id`;

ALTER TABLE `orders`
ADD `orders_delivered_email_send` tinyint(1) UNSIGNED NULL,
  COMMENT='';