2021-10-08_002(张跃文).sql 636 B

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