DB-SQL/2021-10-08_002(张跃文).sql

ALTER TABLE `warehouse_in_out_info` 
ADD COLUMN `type` varchar(100) NULL COMMENT '潮粮/干粮' AFTER `address_url`,
ADD COLUMN `buckle_weight_ratio` float(11, 4) NULL COMMENT '扣重比' AFTER `type`,
ADD COLUMN `tidal_grain_water` varchar(50) NULL COMMENT '潮粮水分' AFTER `buckle_weight_ratio`,
ADD COLUMN `solid_grain_water` varchar(50) NULL COMMENT '干粮水分' AFTER `tidal_grain_water`,
ADD COLUMN `pure_weight` float(11, 4) NULL COMMENT '纯重(吨)' AFTER `solid_grain_water`,
ADD COLUMN `cost` float(11, 4) NULL COMMENT '成本' AFTER `pure_weight`,
ADD COLUMN `freight` float(11, 4) NULL COMMENT '运费' AFTER `cost`;