JY0rg0KX

1INSERT INTO orders_status (orders_status_id, orders_status_name) VALUES (17, 'Подтвержден');
2INSERT INTO orders_status (orders_status_id, orders_status_name) VALUES (18, 'Не подтвержден');
3INSERT INTO orders_status (orders_status_id, orders_status_name) VALUES (19, 'Отменен по вине поставщика');
4INSERT INTO orders_status (orders_status_id, orders_status_name) VALUES (20, 'Отменен (1)');
5INSERT INTO orders_status (orders_status_id, orders_status_name) VALUES (21, 'Отменен (2)');
6INSERT INTO orders_status (orders_status_id, orders_status_name) VALUES (22, 'Частичный возврат');
7INSERT INTO orders_status (orders_status_id, orders_status_name) VALUES (23, 'Назначена доставка');
8INSERT INTO orders_status (orders_status_id, orders_status_name) VALUES (24, 'Отменен (3)');
9INSERT INTO orders_status (orders_status_id, orders_status_name) VALUES (25, 'Отменен (4)');
10
11UPDATE `orders_status` SET `orders_status_name`='Расформирован по недозвону' WHERE  `orders_status_id`=15 AND `language_id`=1 LIMIT 1;
12
13ALTER TABLE `categories`
14	ADD COLUMN `invoice_file` VARCHAR(255) NULL DEFAULT NULL AFTER `invoice_date`;
15	
16ALTER TABLE `suppliers_products`
17	ADD COLUMN `is_deleted` INT(11) UNSIGNED NOT NULL DEFAULT '0' AFTER `products_in_stock`;
18
19CREATE TABLE IF NOT EXISTS `suppliers_products_deleted` (
20  `categories_id` int(10) unsigned NOT NULL,
21  `products_id` int(10) unsigned NOT NULL,
22  `products_attributes_id` int(10) unsigned NOT NULL,
23  `products_in_stock` int(10) unsigned NOT NULL,
24  `date_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
25  UNIQUE KEY `categories_id_products_id_products_attributes_id` (`categories_id`,`products_id`,`products_attributes_id`),
26  KEY `categories_id` (`categories_id`),
27  KEY `products_id` (`products_id`),
28  KEY `products_attributes_id` (`products_attributes_id`)
29) ENGINE=MyISAM DEFAULT CHARSET=utf8;
30
31ALTER TABLE `customers`
32	ADD COLUMN `customers_tried` TINYINT(1) NULL DEFAULT NULL AFTER `is_distribution_bonus`;
33
34ALTER TABLE `orders_acts`
35	ADD COLUMN `acts_name` VARCHAR(100) NULL AFTER `acts_id`;
36
37ALTER TABLE `orders`
38ADD `orders_delivered_email_send` tinyint(1) unsigned NULL,
39  COMMENT='';