insert_alert.sql 2.4 KB

1234567891011121314151617181920212223242526
  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';
  16. UPDATE sys_menu SET parent_id = '0',order_num = '12',path = 'Bill/costManage' WHERE menu_id = '2576';
  17. # 时间:20211013 是否已发版: 测试- 是 生产-否
  18. delete from sys_company where scy_id = '000000';
  19. insert into `sys_company` (`scy_id`, `scy_license_file`, `scy_name`, `scy_social_code`, `scy_registered_capital`, `scy_start_time`, `scy_end_time`, `scy_address`, `scy_phone`, `scy_legal_file`, `scy_legal_back_file`, `scy_legal`, `scy_legal_id`, `scy_authorization_file`, `scy_commitment_file`, `scy_appendix_file`, `scy_type`, `scy_industry`, `scy_scale`, `scy_organization`, `scy_manager`, `scy_cfca_user_id`, `scy_cfca_auth_number`, `scy_cfca_bank_time`, `scy_remarks`, `scy_auth_status`, `scy_status`, `create_by`, `create_time`, `update_by`, `update_time`, `scy_contract_id`) values('000000',NULL,'招采云链(山东)信息服务有限公司','','无','','无','中国(山东)自由贸易试验区济南片区汉峪金谷A3-1-1401','18810133746',NULL,NULL,'丛美红','',NULL,NULL,NULL,'00',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,'01','00',NULL,NULL,NULL,NULL,NULL);
  20. UPDATE sys_user SET email = 'congmeihong@zcylian.com' WHERE user_id = '1'