20200422.sql 481 B

12345678
  1. -- 推送通知 方式重置
  2. update `config` SET `name` = 'is_notification', `value` = '0' where `config`.`id` = 39;
  3. -- 修改支付方式命名
  4. alter table `order` CHANGE `pay_way` `pay_way` VARCHAR(20) NOT NULL DEFAULT '1' COMMENT '支付方式:balance、f2fpay、codepay、payjs、bitpayx等';
  5. UPDATE `order` SET `pay_way`= 'balance' WHERE pay_way = '1';
  6. UPDATE `order` SET `pay_way`= 'youzan' WHERE pay_way = '2';
  7. UPDATE `order` SET `pay_way`= 'f2fpay' WHERE pay_way = '5';