20170918-achievement-order-change.sql 675 B

1234567891011
  1. ALTER TABLE `achievement_order`
  2. DROP COLUMN `service_money`,
  3. DROP COLUMN `commission`,
  4. DROP COLUMN `contract_money`,
  5. DROP COLUMN `intention_money`,
  6. CHANGE COLUMN `status` `status` INT(2) NULL DEFAULT NULL COMMENT '(0, \"未支付\"),(1, \"已支付\"),(2, \"支付中\"),(3, \"完成\"),(9, \"取消\"),(10, \"无效\")' ,
  7. ADD COLUMN `payment_value` DOUBLE(10,2) NULL COMMENT '实际支付金额' AFTER `status`,
  8. ADD COLUMN `payment_type` VARCHAR(16) NULL COMMENT '支付方式' AFTER `payment_value`,
  9. ADD COLUMN `payment_id` VARCHAR(45) NULL COMMENT '支付流水号' AFTER `payment_type`,
  10. ADD COLUMN `payment_time` DATETIME NULL COMMENT '支付时间' AFTER `payment_id`;