kmall-haikong/sql/kmall_table_alter.sql

# 营销方式-满赠表
alter table mk_activities_full_gift add full_gift_type char(1) comment '满赠类型，0:按品牌 1:按商品分类';

alter table mk_activities_full_gift add category_id int(11) comment '分类id';

alter table mk_activities_full_gift add category_name varchar(32) comment '分类名称';

alter table mk_activities_full_gift add brand_id int(11) comment '品牌id';

alter table mk_activities_full_gift add shop_name varchar(64) comment '门店名称';

alter table mk_activities_full_gift add gift_number int(8) comment '赠品数量';

alter table mk_activities_full_gift add full_gift_type char(1) comment '满赠类型，0:按品牌 1:按商品分类';

# 营销方式-优惠券表
alter table mk_activities_coupon add full_gift_type char(1) comment '优惠券类型，0:按品牌 1:按商品分类 2：按商品';

alter table mk_activities_coupon add category_id int(11) comment '分类id';

alter table mk_activities_coupon add category_name varchar(255) comment '分类名称';

alter table mk_activities_coupon add brand_id int(11) comment '品牌id';

alter table mk_activities_coupon add brand_name varchar(255) comment '品牌id';


# 门店库存表
alter table mall_product_store_rela add exit_region_number int(11) comment '展销店出区数';


# 会员消费记录表
alter table mall2_member_consumption_records add deduction_score int(11) comment '订单抵扣积分';

alter table mall2_member_consumption_records add member_code varchar(64) comment '会员码';

alter table mall2_member_consumption_records add member_phone varchar(20) comment '会员手机号';

alter table mall2_member_consumption_records add order_total_price decimal(10,2) comment '订单总金额';

alter table mall2_member_consumption_records add score_deduction_price decimal(10,2) comment '积分抵扣金额';

alter table mall2_member_consumption_records add score_limit int(11) comment '积分抵扣规则，多少积分抵一元';

alter table mall2_member_consumption_records add before_score int(11) comment '下单之前积分数量';

alter table mall2_member_consumption_records add after_score int(11) comment '下单之后积分数量';