H2Sjdim7

1DROP TABLE IF EXISTS `products_change_log_temp` ;
2CREATE TABLE `products_change_log_temp` (
3	`products_change_log_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
4	`customers_id` INT(11) UNSIGNED NOT NULL,
5	`change_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
6	`products_id` INT(11) UNSIGNED NOT NULL,
7	`products_attributes_id` INT(11) UNSIGNED NOT NULL,
8	`products_model` VARCHAR(255) NULL DEFAULT NULL,
9	`products_price` DECIMAL(15,2) NULL DEFAULT NULL,
10	`products_purchase_price` DECIMAL(15,2) NULL DEFAULT NULL,
11	`products_old_price` DECIMAL(15,2) NULL DEFAULT NULL,
12	`products_trade_price` DECIMAL(15,2) NULL DEFAULT NULL,
13	`products_quantity` INT(4) NULL DEFAULT NULL,
14	`products_status` TINYINT(1) NULL DEFAULT NULL,
15	`parent_id` INT(11) UNSIGNED NULL DEFAULT NULL,
16	`products_country` VARCHAR(255) NULL DEFAULT NULL,
17	`products_country_manufactures` VARCHAR(255) NULL DEFAULT NULL,
18	`products_weight` DECIMAL(5,2) NULL DEFAULT NULL,
19	`products_dimensions` VARCHAR(255) NULL DEFAULT NULL,
20	`products_declaration` VARCHAR(255) NULL DEFAULT NULL,
21	`products_VAT` INT(11) NULL DEFAULT NULL,
22	`products_description` TEXT NULL,
23	`products_name` VARCHAR(255) NULL DEFAULT NULL,
24	`products_name_label` VARCHAR(255) NULL DEFAULT NULL,
25	`only_prepaid` VARCHAR(255) NULL DEFAULT NULL,
26	`on_moderation` TINYINT(1) UNSIGNED NULL DEFAULT NULL,
27	`products_class` VARCHAR(255) NULL DEFAULT NULL,
28	`one_delivery` VARCHAR(255) NULL DEFAULT NULL,
29	`article_supplier` VARCHAR(255) NULL DEFAULT NULL,
30	`notify_call_center` ENUM('Y','N') NULL DEFAULT 'N',
31	`products_comment` TEXT NULL,
32	`products_trade_price_currency` DECIMAL(15,2) NULL DEFAULT NULL,
33	`products_purchase_price_currency` DECIMAL(15,2) NULL DEFAULT NULL,
34	PRIMARY KEY (`products_change_log_id`),
35	INDEX `products_attributes_id` (`products_attributes_id`),
36	INDEX `products_id_products_attributes_id` (`products_id`, `products_attributes_id`),
37	INDEX `parent_id` (`parent_id`)
38)
39COMMENT='логгирование событий смены данных товара через call/content'
40COLLATE='utf8_general_ci'
41ENGINE=InnoDB
42;
43
44INSERT INTO products_change_log_temp 
45	SELECT *, null, null from products_change_log;
46	
47INSERT INTO products_change_log_temp 
48	SELECT pcl.*, null, null from products_change_log pcl	
49	where pcl.products_change_log_id > (select MAX(products_change_log_id)  from products_change_log_temp)
50;	
51
52INSERT INTO products_change_log_temp 
53	SELECT pcl.*, null, null from products_change_log pcl	
54	where pcl.products_change_log_id > (select MAX(products_change_log_id)  from products_change_log_temp)
55;	
56
57RENAME TABLE `products_change_log` TO `products_change_log_old`;
58RENAME TABLE `products_change_log_temp` TO `products_change_log`;