insert_alert.sql 1.3 KB

123456789101112131415161718
  1. # 时间:20211009 是否已发版: 测试- 是 生产-否
  2. ALTER TABLE `zc_finance_record` ADD `zfr_reason` varchar(300) DEFAULT NULL COMMENT '拒绝放款理由';
  3. ALTER TABLE `pay_acc_inf` ADD `pai_accno_name` varchar(300) DEFAULT NULL COMMENT '账户名称';
  4. ALTER TABLE `pay_acc_inf` ADD `pai_bank_name` varchar(300) DEFAULT NULL COMMENT '银行名称';
  5. ALTER TABLE `pay_acc_detail` ADD `PAD_STATE` varchar(2) DEFAULT NULL COMMENT '状态(00:交易中 01:成功 02:失败)';
  6. # 时间:20211012 是否已发版: 测试- 是 生产-否
  7. UPDATE sys_menu SET parent_id = '0',order_num = '3' WHERE menu_id = '2517';
  8. UPDATE sys_menu SET parent_id = '0',order_num = '4',path = 'Bill/creditLine' WHERE menu_id = '2530';
  9. UPDATE sys_menu SET parent_id = '0',order_num = '5' path = 'Bill/Bill' WHERE menu_id = '2518';
  10. UPDATE sys_menu SET parent_id = '0',order_num = '6' WHERE menu_id = '2528';
  11. UPDATE sys_menu SET parent_id = '0',order_num = '7' path = 'Bill/contract' WHERE menu_id = '2544';
  12. UPDATE sys_menu SET parent_id = '0',order_num = '8' WHERE menu_id = '2546';
  13. UPDATE sys_menu SET parent_id = '0',order_num = '9' WHERE menu_id = '2575';
  14. UPDATE sys_menu SET parent_id = '0',order_num = '10' path = 'Bill/rel' WHERE menu_id = '2536';
  15. UPDATE sys_menu SET parent_id = '0',order_num = '11' WHERE menu_id = '2591';