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