ALTER TABLE erp_product.storage ADD `upm_code` VARCHAR(100) DEFAULT '' COMMENT 'upm条码';                   -- 平台化二期优化
ALTER TABLE erp_supplier.base_single ADD `upm_code` VARCHAR(100) DEFAULT '' COMMENT 'upm条码';      
create index product_factory_code on erp_product.product(factory_code);

-- 退换货
alter table erp_product.product_sort add COLUMN is_refund_exchange tinyint(1) unsigned NOT NULL DEFAULT '1';
alter table yh_shops.product_sort add COLUMN is_refund_exchange tinyint(1) unsigned NOT NULL DEFAULT '1';


-- 定时变价
ALTER TABLE erp_product.product_price ADD effective_time INT COMMENT '生效时间';
ALTER TABLE erp_product.product_price ADD cgprice_start_time INT(10) COMMENT '变价开始时间';
ALTER TABLE erp_product.product_price ADD cgprice_end_time INT(10) COMMENT '变价结束时间';
ALTER TABLE erp_product.product_price ADD tmp_cgprice_status SMALLINT(6) COMMENT '临时变价是否结束';

-- 定时变价
ALTER TABLE erp_product.product_price ADD change_price_type SMALLINT (6);

CREATE TABLE `erp_product`.`product_price_plan` (
	`id` INT (11),
	`product_skn` INT (11),
	`retail_price` DECIMAL (13),
	`sales_price` DECIMAL (13),
	`vip_price` DECIMAL (13),
	`vip1_price` DECIMAL (13),
	`vip2_price` DECIMAL (13),
	`vip3_price` DECIMAL (13),
	`vip_discount_type` TINYINT (3),
	`purchase_price` DECIMAL (13),
	`purchase_discount` DECIMAL (5),
	`cost_price` DECIMAL (13),
	`return_coin` INT (11),
	`founder` INT (11),
	`enable_vip` TINYINT (3),
	`create_time` INT (10),
	`update_time` INT (10),
	`sys_status` SMALLINT (6),
	`coin_status` TINYINT (3),
	`auditor_id` INT (11),
	`cgprice_start_time` INT (10),
	`cgprice_end_time` INT (10),
	`tmp_cgprice_status` SMALLINT (6),
	`effective_time` INT (11),
	`change_price_type` SMALLINT (6)
);