库分期.sql 668 B

12345
  1. INSERT INTO `caimei`.`paytype` (`payTypeID`, `name`, `validFlag`, `image`) VALUES ('1009', '在线支付_库分期支付', '1', NULL);
  2. alter table bp_order add column cooFreeFlag char(1) DEFAULT '1' COMMENT '库分期免息状态 0、免息 1、不免息' AFTER discount;
  3. alter table bp_order add column cooFreeRate int(3) DEFAULT 0 COMMENT '库分期免息费率 实际计算除以100' AFTER cooFreeFlag;
  4. alter table bp_order add column cooFreeAmount DECIMAL(20,2) DEFAULT 0.00 COMMENT '库分期免息金额' AFTER cooFreeRate;
  5. alter table cm_finance_receipts add column cooFreeAmount DECIMAL(20,2) DEFAULT 0.00 COMMENT '库分期免息金额' AFTER deductionAmount;