20_20240805.sql 533 B

123456789101112
  1. ALTER TABLE product_sku
  2. ADD COLUMN `settlement_price` int DEFAULT '0' COMMENT '结算价,单位: 分',
  3. ADD COLUMN `high_precision_settlement_price` decimal(11,6) DEFAULT '0' COMMENT '高精度结算价';
  4. ALTER TABLE trade_order_item
  5. ADD COLUMN `settlement_price` int DEFAULT '0' COMMENT '结算价,单位: 分',
  6. ADD COLUMN `high_precision_settlement_price` decimal(11,6) DEFAULT '0' COMMENT '高精度结算价';
  7. ALTER TABLE distri_pt_profit
  8. ADD COLUMN `profit` bigint NOT NULL DEFAULT '0' COMMENT '利润';