| | |
|---|
| | | PRIMARY KEY(id) |
|---|
| | | )ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='分销订单'; |
|---|
| | | |
|---|
| | | biz_user原来的userId改成了自增长的bigint |
|---|
| | | |
|---|
| | | |
|---|
| | | ALTER TABLE `shop_sku` |
|---|
| | | ADD COLUMN `score_price` decimal(10, 2) NULL COMMENT '积分兑换价格' AFTER `invitation_price`; |
|---|
| | | |
|---|
| | | ALTER TABLE `shop_product` |
|---|
| | | ADD COLUMN `score_category_id` bigint(20) NULL COMMENT '积分商城分类ID' AFTER `company_id`, |
|---|
| | | ADD COLUMN `able_sales` int(2) NULL COMMENT '是否为分销产品' AFTER `score_category_id`, |
|---|
| | | ADD COLUMN `mall_type` int(2) NULL COMMENT '上架卖场' AFTER `able_sales`; |
|---|
| | | |
|---|
| | | update shop_product set mall_type=1; |
|---|
| | | update shop_product set able_sales=2; |
|---|
| | | |
|---|
| | | ALTER TABLE `shop_shopping_cart` |
|---|
| | | ADD COLUMN `cart_type` int(2) NOT NULL COMMENT '购物车类型 1微商城 2积分商城' AFTER `company_id`; |
|---|
| | | |
|---|
| | | |
|---|
| | | update shop_shopping_cart set cart_type=1; |
|---|
| | | |
|---|
