pub_syspar_data.sql 5.7 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546
  1. /*
  2. SQLyog v10.2
  3. MySQL - 5.6.37
  4. *********************************************************************
  5. */
  6. /*!40101 SET NAMES utf8 */;
  7. insert into pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE, SPR_TYPE, SPR_SCOPE, SPR_MFLAG) values('FILE_PATH_00','图片文件保存路径','baotuan/img/','0','0','1');
  8. insert into pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE, SPR_TYPE, SPR_SCOPE, SPR_MFLAG) values('FILE_PATH_01','文档文件保存路径','/doc/','0','0','1');
  9. insert into pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE, SPR_TYPE, SPR_SCOPE, SPR_MFLAG) values('FILE_PATH_02','视频文件保存路径','/video/','0','0','1');
  10. insert into pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE, SPR_TYPE, SPR_SCOPE, SPR_MFLAG) values('FILE_SERVER_BASE_PATH','文件服务器存放根路径','/home/ftp_file/','0','0','1');
  11. insert into pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE, SPR_TYPE, SPR_SCOPE, SPR_MFLAG) values('FILE_SERVER_URL','文件服务器访问路径','https://baotuan.keao.tech/','0','0','1');
  12. insert into pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE, SPR_TYPE, SPR_SCOPE, SPR_MFLAG) values('FILE_URL_PREFIX_IMAGE','图片访问路径前缀','http://www.minpay.cc/mon/img/','0','0','0');
  13. insert into pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE, SPR_TYPE, SPR_SCOPE, SPR_MFLAG) values('FTP_IP','服务端地址','123.138.111.22','0','0','0');
  14. insert into pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE, SPR_TYPE, SPR_SCOPE, SPR_MFLAG) values('FTP_PASSWORD','服务端地址','1qaz!QAZ','0','0','0');
  15. insert into pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE, SPR_TYPE, SPR_SCOPE, SPR_MFLAG) values('FTP_PORT','服务端地址','21','0','0','0');
  16. insert into pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE, SPR_TYPE, SPR_SCOPE, SPR_MFLAG) values('FTP_USERNAME','服务端地址','ftp_user','0','0','0');
  17. insert into pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE, SPR_TYPE, SPR_SCOPE, SPR_MFLAG) values('IM_LOGONFAIL_TODAY_COUNT','每天密码最大输入错误次数','5','0','0','0');
  18. insert into pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE, SPR_TYPE, SPR_SCOPE, SPR_MFLAG) values('IM_PSW_MODIFY_DATE','查询系统配置的修改密码间隔时间(天)','90','0','0','0');
  19. insert into pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE, SPR_TYPE, SPR_SCOPE, SPR_MFLAG) values('LOCAL_SAVEPATH_IMAGE','图片存放服务器绝对路径','/root/nginx/html/mon/img/','0','0','0');
  20. insert into pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE, SPR_TYPE, SPR_SCOPE, SPR_MFLAG) values('PER_LOGONFAIL_COUNT','个人系统登录密码错误当日最大次数','5','0','0','0');
  21. insert into pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE, SPR_TYPE, SPR_SCOPE, SPR_MFLAG) values('PER_LOGONFAIL_MAXCOUNT','个人系统登录密码错误最大次数,达到后永久冻结','9','0','0','0');
  22. insert into pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE, SPR_TYPE, SPR_SCOPE, SPR_MFLAG) values('PER_LOGONFAIL_NEED_CODE','错误几次后校验验证码','1','0','0','0');
  23. insert into pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE, SPR_TYPE, SPR_SCOPE, SPR_MFLAG) values('PRESSURE_TEST_MODE','压测模式','false','0','0','0');
  24. insert into pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE, SPR_TYPE, SPR_SCOPE, SPR_MFLAG) values('RSA_CONFIG','证书地址','/home/rrtx/','0','0','1');
  25. insert into pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE, SPR_TYPE, SPR_SCOPE, SPR_MFLAG) values('SHORT_MSG_01','注册验证码','您的注册验证码为:','0','0','1');
  26. insert into pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE, SPR_TYPE, SPR_SCOPE, SPR_MFLAG) values('SHORT_MSG_02','密码重置验证码','您的申请密码重置验证码为:','0','0','1');
  27. insert into pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE, SPR_TYPE, SPR_SCOPE, SPR_MFLAG) values('SMS_CONTENT','短信内容','@,5分钟内有效。请不要把此验证码泄露给任何人。【云朵宝贝】','0','0','0');
  28. insert into pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE, SPR_TYPE, SPR_SCOPE, SPR_MFLAG) values('AUTH_URL','企业实名认证路径','http://60.191.250.12:8107/credit-facade/facade/qyMain.html','0','0','0');
  29. insert into pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE, SPR_TYPE, SPR_SCOPE, SPR_MFLAG) values('AUTH_ENABLE','企业实名认证挡板','true','0','0','0');
  30. insert into pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE, SPR_TYPE, SPR_SCOPE, SPR_MFLAG) values('JJ_URL','久捷联调地址','http://www.hzagil.com:2980/home/GetOrderFromShop','0','0','0');
  31. insert into pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE, SPR_TYPE, SPR_SCOPE, SPR_MFLAG) values('SMS_URL','短信接口地址','http://60.191.246.11/emas','0','0','0');
  32. insert into pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE, SPR_TYPE, SPR_SCOPE, SPR_MFLAG) values('APPID','短信公钥','EMAS-8638-008D-E6B1','0','0','0');
  33. insert into pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE, SPR_TYPE, SPR_SCOPE, SPR_MFLAG) values('SECERTKEY','短信私钥','8DE6B17FF330479F','0','0','0');
  34. insert into pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE, SPR_TYPE, SPR_SCOPE, SPR_MFLAG) values('SMS_ENABLE','短信挡板','true','0','0','0');
  35. insert into pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE, SPR_TYPE, SPR_SCOPE, SPR_MFLAG) values('RMBQUOT','聚合货币汇率key','cba54dabc99242b30b4b9b77821e0ab5','0','0','0');
  36. insert into pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE, SPR_TYPE, SPR_SCOPE, SPR_MFLAG)
  37. values('V01_ADM_URl','后台地址','http://127.0.0.1:8888/adm','0','0','0');
  38. insert into pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE, SPR_TYPE, SPR_SCOPE, SPR_MFLAG)
  39. values('REDIRECT_URl','重定向地址','http://127.0.0.1:8888/adm/ApiAction/redirect?','0','0','0');
  40. insert into pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE, SPR_TYPE, SPR_SCOPE, SPR_MFLAG)
  41. values('PAY_CHANNEL','支付渠道-合利宝','09','0','0','0');
  42. insert into pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE, SPR_TYPE, SPR_SCOPE, SPR_MFLAG)
  43. values('V01_SHOUHUO_TURNTABLE_PAGE','支付成功后返回前端页面','http://shjservices.personalpay.cn/services/ApiAction/redirect?','0','0','0');