/****
|
hive2.0改版sql变更
|
*/
|
|
|
ALTER TABLE `shopping_goods`
|
ADD COLUMN `GOODS_NO` varchar(100) NULL COMMENT '存货编号(条形码)' AFTER `code`,
|
ADD COLUMN `unit` varchar(20) NULL COMMENT '单位' AFTER `GOODS_NO`,
|
ADD COLUMN `goods_sort_id` bigint(10) NULL COMMENT '存货分类' AFTER `unit`,
|
ADD COLUMN `supplier_id` bigint(10) NULL COMMENT '往来单位id' AFTER `goods_sort_id`,
|
ADD COLUMN `measure` varchar(5) NULL COMMENT '计量单位' AFTER `supplier_id`,
|
ADD COLUMN `alarm_num` double(20, 0) NULL COMMENT '预警数量' AFTER `measure`,
|
ADD COLUMN `volume` double(20, 0) NULL COMMENT '容积' AFTER `alarm_num`,
|
ADD COLUMN `price` double(20, 2) NULL COMMENT '成本价' AFTER `volume`,
|
ADD COLUMN `wholesale` double(20, 0) NULL COMMENT '批发价' AFTER `price`,
|
ADD COLUMN `time_length` int(10) NULL COMMENT '服务时长' AFTER `wholesale`,
|
ADD COLUMN `proReward` double(20, 0) NULL COMMENT '服务提成' AFTER `time_length`;
|
|
|
ALTER TABLE `shopping_goods_assemble`
|
ADD COLUMN `assemble_good_id` bigint(0) NULL COMMENT '组合产品ID' AFTER `assembleGoodId`;
|
|
|
ALTER TABLE `shopping_goods`
|
ADD COLUMN `use_shop` varchar(1000) NULL COMMENT '品种可用门店' AFTER `proReward`;
|
|
|
ALTER TABLE `shopping_goods`
|
ADD COLUMN `headquarters` int(2) NULL COMMENT '是否为总部产品，1是2不是' AFTER `use_shop`;
|
|
ALTER TABLE `sys_shop_info`
|
ADD COLUMN `shop_type` int(2) NULL COMMENT '门店类型1.总部，2.门店，3.加盟店' AFTER `shop_short_name`;
|
|
|
|
|
|
-- 数据迁移
|
update shopping_goods set headquarters=2
|
where ISNULL(headquarters);
|
|
|
update sys_data_dictionary set type='入库类型' where type='产品用途';
|
|
|
ALTER TABLE `money_card_use`
|
ADD COLUMN `card_name` varchar(255) NULL COMMENT '充值卡名称' AFTER `remark`;
|
/**
|
充值卡改造后需要为已经导入的用户生成一个默认的储值卡
|
*/
|
|
/**
|
供应商菜单管理，改为往来单位管理
|
|
*/
|
|
|
ALTER TABLE `sys_proj_use`
|
ADD COLUMN `proj_name` varchar(500) NULL COMMENT '项目名称' AFTER `remark`,
|
ADD COLUMN `deductionNum` int(255) NULL COMMENT '单次扣减次数' AFTER `proj_name`;
|
ALTER TABLE sys_proj_use
|
ADD COLUMN `tcName` varchar(255) NULL COMMENT '套餐名称' AFTER `deductionNum`;
|
|
ALTER TABLE `sys_proj_use`
|
ADD COLUMN `is_course` varchar(2) NULL COMMENT '套餐类型 N=固定套餐，Y=任选套餐' AFTER `tcName`;
|
