You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
18 lines
1002 B
18 lines
1002 B
# 2022-04-09 14:57
|
|
ALTER TABLE `lanzu_order_main`
|
|
CHANGE COLUMN `shipping_type` `shipping_type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '配送方式:1服务站配送，2达达配送，3自提，4顺丰配送' AFTER `global_order_id`,
|
|
CHANGE COLUMN `delivery_time_note` `delivery_time_note` VARCHAR(100) NULL DEFAULT '' COMMENT '客户期望送达时间' COLLATE 'utf8mb4_general_ci' AFTER `shipping_name`;
|
|
|
|
# 2022-04-11 23:50
|
|
ALTER TABLE `lanzu_goods`
|
|
ADD COLUMN `weight` INT(11) NOT NULL DEFAULT '0' COMMENT '产品毛重，用于计算顺丰运费' AFTER `goods_unit`;
|
|
ALTER TABLE `lanzu_goods_activity`
|
|
ADD COLUMN `weight` INT(11) NOT NULL DEFAULT '0' COMMENT '产品毛重，用于计算顺丰运费' AFTER `goods_unit`;
|
|
|
|
# 2022-04-17 23:41
|
|
ALTER TABLE `lanzu_order_goods`
|
|
ADD COLUMN `weight` INT NULL DEFAULT 0 COMMENT '一件商品的重量（多个需要*number），单位：克' AFTER `note`;
|
|
|
|
|
|
# 顺丰订单记录
|
|
create table `lanzu_sf_express_orders`;
|