sckw-service-platform/sql/2026/04/2026_04_02_tangyishan_alter.sql

ALTER TABLE `sckw_ng_order`.`kwo_trade_order`
    ADD COLUMN `settlement` tinyint NOT NULL DEFAULT 1 COMMENT '结算方式 (1普通结算，2预付制结算)' AFTER `consignment_way`


ALTER TABLE `sckw_ng_contract`.`kwc_contract_logistics`
    ADD COLUMN `settlement` tinyint NOT NULL DEFAULT 1 COMMENT '结算方式 (1普通结算，2记账模式)' AFTER `dispatch_way`


ALTER TABLE `sckw_ng_transport`.`kwt_logistics_order`
    ADD COLUMN `settlement` tinyint NOT NULL COMMENT '结算方式 (1普通结算，2记账模式)' AFTER `dispatch_way`;