004_super_admin_discount_fields.sql 359 B

12345678
  1. -- 为 user_consumption_detail 表添加超管折扣和超管实际金额字段
  2. -- 解决爬取数据时超管折扣丢失的问题
  3. ALTER TABLE domain_monitor.user_consumption_detail
  4. ADD COLUMN super_admin_discount NUMERIC(10, 4) DEFAULT 1.0000;
  5. ALTER TABLE domain_monitor.user_consumption_detail
  6. ADD COLUMN super_admin_actual_price NUMERIC(20, 4);