lanzu_api_2021-12-26/MySQL_change.sql

# 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`;