date_sys_config.sql 7.6 KB

12345678910111213141516171819202122232425262728293031
  1. #系统参数
  2. insert into `sys_config` (`config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('用户管理-账号初始密码','sys.user.initPassword','q1111111','Y','',NULL,'',NULL,'初始化密码 q1111111');
  3. insert into `sys_config` (`config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('阿里短信服务-accessKeyId','aliyun.message.accessKeyId','LTAI5tR6mofMgJH88GyVTp6o','Y','admin','2021-08-25 19:49:49','admin','2021-08-26 14:41:12',NULL);
  4. insert into `sys_config` (`config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('阿里短信服务-accessKeySecret','aliyun.message.accessKeySecret','w1pAMt3iUC6fce06PKWyK4VYCstaia','Y','admin','2021-08-25 19:50:33','admin','2021-08-26 14:41:27',NULL);
  5. insert into `sys_config` (`config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('阿里短信服务-signName','aliyun.message.signName','招采云链','Y','admin','2021-08-25 19:52:21','',NULL,NULL);
  6. insert into `sys_config` (`config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('还款明细存放路径','zc_repayment_export','D:/','Y','admin','2021-08-26 19:07:23','admin','2021-08-27 14:31:26',NULL);
  7. insert into `sys_config` (`config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('链属邀请url','zc_spare','https://www.baidu.com','Y','admin','2021-08-26 19:34:02','admin','2021-08-26 19:34:40',NULL);
  8. insert into `sys_config` (`config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('还款明细导出模板路径','zc_repayment_export_docx','D:\\RepaymentList.docx','Y','admin','2021-08-27 14:31:08','',NULL,NULL);
  9. insert into `sys_config` (`config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('核心企业产品ID','system.company.core','1','Y','admin','2021-08-28 10:23:10','',NULL,NULL);
  10. insert into `sys_config` (`config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('融资企业产品ID','system.company.supplier','94bd241048f6411e8f7945b2146b16d2','Y','admin','2021-08-28 10:25:42','',NULL,NULL);
  11. insert into `sys_config` (`config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('资方产品ID','system.company.management','cf02c903d33d4017b0be4f1614d19a9d','Y','admin','2021-08-28 10:27:29','',NULL,NULL);
  12. -- insert into `sys_config` (`config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('融资管理附件下载地址','zc_record_file','D:\\record','Y','admin','2021-08-30 10:53:10','admin','2021-09-02 20:08:25',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 (31, '融资管理附件下载地址', 'zc_record_file', '/home/model/record', 'Y', 'admin', '2021-08-30 10:53:10', 'admin', '2021-09-11 15:12:49', NULL);
  14. insert into `sys_config` (`config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('融信文件下载路径','credit_file_path','/home/aaa/','Y','admin','2021-09-02 11:39:09','',NULL,NULL);
  15. insert into `sys_config` (`config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('CFCA盖章后文件下载地址','cfca_file_path','D:/zhuomian/cfca/','Y','admin','2021-09-02 11:44:32','',NULL,NULL);
  16. insert into `sys_config` (`config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('人脸识别前后台通知','face_back_front_url','https://www.baidu.com','Y','admin','2021-09-02 11:48:01','',NULL,NULL);
  17. insert into `sys_config` (`config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('人脸识别对公域名','face_public_name','http://zcyl.keao.tech/#/','Y','admin','2021-09-02 11:50:39','',NULL,NULL);
  18. insert into `sys_config` (`config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('cfca机构编号','cfca_institution_id','100804','Y','admin','2021-09-02 11:53:39','',NULL,NULL);
  19. INSERT INTO `sys_config` (`config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES('盖章jks路径', 'jks_path', 'D:/anxinsign.jks', 'Y', 'admin', '2021-09-07 13:54:33', '', NULL, NULL);
  20. INSERT INTO `sys_config` (`config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ('盖章密码', 'cfca_key_store_password', '123456', 'Y', 'admin', '2021-09-07 19:29:16', '', NULL, NULL);
  21. INSERT INTO `sys_config` (`config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ('cfca渠道', 'cfca_channel', 'Test', 'Y', 'admin', '2021-09-07 19:31:05', '', NULL, NULL);
  22. INSERT INTO `sys_config` (`config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ('cfca的platId', 'cfca_platId', 'CA4572A39DCB55ABE05311016B0A04B3', 'Y', 'admin', '2021-09-07 19:34:27', '', NULL, NULL);
  23. insert into `sys_config` (`config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('核心企业普通用户','system.company.coreOrdinary','62a52a855a5f449c8e9a31d419078887','Y','admin','2021-09-07 14:34:36','',NULL,NULL);
  24. insert into `sys_config` (`config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('融资企业普通用户','system.company.supplierOrdinary','26ba680b8cdb4ed49597d889cc856671','Y','admin','2021-09-07 14:36:32','',NULL,NULL);
  25. INSERT INTO `sys_config` (`config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES('flowable调用域名', 'flowable_post_url', 'http://47.94.193.84/:8081', 'Y', 'admin', '2021-09-07 13:54:33', '', NULL, NULL);
  26. INSERT INTO `sys_config` (`config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES('flowable服务部署地址', 'flowable_url', 'http://47.94.174.212:7001/api/', 'Y', 'admin', '2021-09-07 13:54:33', '', NULL, NULL);
  27. insert into `sys_config` (`config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('是否为生产环境(短信,人脸,盖章)','is_product','false','Y','admin','2021-09-09 14:12:53','',NULL,NULL);
  28. insert into `sys_config` (`config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('资方普通用户','system.company.managementUser','77da14b330a94b8ba8283e3391088fb8','Y','admin','2021-09-13 15:32:38','',NULL,NULL);