date_sys_config.sql 11 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344
  1. insert into `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('1','用户管理-账号初始密码.','sys.user.initPassword','q1111111','Y','',NULL,'admin','2021-09-08 20:32:17','初始化密码 q1111111');
  2. insert into `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('22','阿里短信服务-accessKeyId','aliyun.message.accessKeyId','LTAI5tR6mofMgJH88GyVTp6o','Y','admin','2021-08-25 19:49:49','admin','2021-08-26 14:41:12',NULL);
  3. insert into `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('23','阿里短信服务-accessKeySecret','aliyun.message.accessKeySecret','w1pAMt3iUC6fce06PKWyK4VYCstaia','Y','admin','2021-08-25 19:50:33','admin','2021-08-26 14:41:27',NULL);
  4. insert into `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('24','阿里短信服务-signName','aliyun.message.signName','招采云链','Y','admin','2021-08-25 19:52:21','',NULL,NULL);
  5. insert into `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('25','还款明细存放路径','zc_repayment_export','/home/model/','Y','admin','2021-08-26 19:07:23','admin','2021-09-07 14:40:16',NULL);
  6. insert into `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('26','链属邀请url','zc_spare','https://www.baidu.com','Y','admin','2021-08-26 19:34:02','admin','2021-08-26 19:34:40',NULL);
  7. insert into `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('27','还款明细导出模板路径','zc_repayment_export_docx','/home/model/RepaymentList.docx','Y','admin','2021-08-27 14:31:08','admin','2021-09-07 14:38:38',NULL);
  8. insert into `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('28','核心企业产品ID','system.company.core','1','Y','admin','2021-08-28 10:23:10','',NULL,NULL);
  9. insert into `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('29','融资企业产品ID','system.company.supplier','94bd241048f6411e8f7945b2146b16d2','Y','admin','2021-08-28 10:25:42','',NULL,NULL);
  10. insert into `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('30','资方产品ID','system.company.management','cf02c903d33d4017b0be4f1614d19a9d','Y','admin','2021-08-28 10:27:29','',NULL,NULL);
  11. insert into `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('31','融资管理附件下载地址','zc_record_file','/home/model/record/','Y','admin','2021-08-30 10:53:10','admin','2021-09-15 09:57:00',NULL);
  12. insert into `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('32','融信文件下载路径','credit_file_path','/home/model/','Y','admin','2021-09-02 11:39:09','admin','2021-09-07 14:41:07',NULL);
  13. insert into `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('33','CFCA盖章后文件下载地址','cfca_file_path','/home/model/','Y','admin','2021-09-02 11:44:32','admin','2021-09-07 14:41:29',NULL);
  14. insert into `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('34','人脸识别前后台通知','face_back_front_url','https://www.baidu.com','Y','admin','2021-09-02 11:48:01','',NULL,NULL);
  15. insert into `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('35','人脸识别对公域名','face_public_name','http://face.zcylian.com/#/','Y','admin','2021-09-02 11:50:39','admin','2021-09-24 16:51:50',NULL);
  16. insert into `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('36','cfca机构编号','cfca_institution_id','100804','Y','admin','2021-09-02 11:53:39','',NULL,NULL);
  17. insert into `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('37','盖章jks路径','jks_path','/home/cfca/anxinsign.jks','Y','admin','2021-09-07 13:54:33','admin','2021-09-08 20:06:49',NULL);
  18. insert into `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('38','盖章密码','cfca_key_store_password','123456','Y','admin','2021-09-07 19:29:16','',NULL,NULL);
  19. insert into `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('39','cfca渠道','cfca_channel','Test','Y','admin','2021-09-07 19:31:05','',NULL,NULL);
  20. insert into `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('40','cfca的platId','cfca_platId','CA4572A39DCB55ABE05311016B0A04B3','Y','admin','2021-09-07 19:34:27','',NULL,NULL);
  21. insert into `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('41','核心企业普通用户','system.company.coreOrdinary','62a52a855a5f449c8e9a31d419078887','Y','admin','2021-09-07 14:34:36','',NULL,NULL);
  22. insert into `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('42','融资企业普通用户','system.company.supplierOrdinary','26ba680b8cdb4ed49597d889cc856671','Y','admin','2021-09-07 14:36:32','',NULL,NULL);
  23. insert into `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('43','flowable调用域名','flowable_post_url','http://47.94.193.84:8081','Y','admin','2021-09-07 13:54:33','admin','2021-09-13 14:11:09',NULL);
  24. insert into `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('44','flowable服务部署地址','flowable_url','http://47.94.174.212:7001/api/','Y','admin','2021-09-07 13:54:33','',NULL,NULL);
  25. insert into `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('45','是否为生产环境(短信,人脸,盖章)','is_product','false','Y','admin','2021-09-09 14:12:53','',NULL,NULL);
  26. insert into `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('46','资方普通用户','system.company.managementUser','77da14b330a94b8ba8283e3391088fb8','Y','admin','2021-09-13 15:32:38','',NULL,NULL);
  27. insert into `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('48','微信APPID','WX_WEB_APP_ID','wx1f2c18fe42595125','Y','admin','2021-09-13 15:32:38','',NULL,NULL);
  28. insert into `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('49','微信SCOPE','WX_WEB_SCOPE','snsapi_login','Y','admin','2021-09-13 15:32:38','',NULL,NULL);
  29. insert into `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('50','微信回调地址','WEB_REDIRECT_URL','http://manage.zcylian.com/wxLogin','Y','admin','2021-09-13 15:32:38','',NULL,NULL);
  30. insert into `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('51','cfca授权编号','ZCYL-CFCA','100001','Y','admin','2021-09-22 15:55:35','',NULL,NULL);
  31. insert into `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('52','是否单点登录','singleLogin','0','Y','admin','2021-09-22 15:55:35','',NULL,NULL);
  32. insert into `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('53','微信SECRET','WEB_APP_SECRET','a4b384abaf013110e44df5ec9418fc68','Y','admin','2021-09-13 15:32:38','',NULL,NULL);
  33. insert into `sys_config` ( `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('中信银行登录名','zx_login_user','zhaocaiyinqiyun','Y','admin','2021-09-13 15:32:38','',NULL,NULL);
  34. insert into `sys_config` ( `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('中信银行主体账号','zx_main_accno','8115701013000133903','Y','admin','2021-09-13 15:32:38','',NULL,NULL);
  35. insert into `sys_config` ( `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('中信银行会员确认中心','zx_mng_node','236201','Y','admin','2021-09-13 15:32:38','',NULL,NULL);
  36. insert into `sys_config` ( `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('中信银行机构编号','zx_branch','56','Y','admin','2021-09-13 15:32:38','',NULL,NULL);
  37. insert into `sys_config` ( `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('中信银行客户端请求地址','zx_url','http://192.168.0.101:6789/','Y','admin','2021-09-13 15:32:38','',NULL,NULL);