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