config.sql 3.2 KB

12345678910111213141516171819202122232425262728293031323334353637
  1. delete from integrated_config where application = 'dmp-report';
  2. insert into integrated_config(application,pprofile,lable,pkey,pvalue,description,isupdate,belongto)
  3. values
  4. ('dmp-report','default','master','server.port', '8085', null, '1', 'DMP'),
  5. ('dmp-report','default','master','spring.application.name', 'dmp-report', null, '1', 'DMP'),
  6. ('dmp-report','default','master','spring.jackson.time-zone', 'Asia/Shanghai', null, '1', 'DMP'),
  7. ('dmp-report','default','master','spring.datasource.driver-class-name', 'com.mysql.cj.jdbc.Driver', null, '1', 'DMP'),
  8. ('dmp-report','default','master','spring.datasource.type', 'com.alibaba.druid.pool.DruidDataSource', null, '1', 'DMP'),
  9. ('dmp-report','default','master','spring.jpa.show-sql', 'true', null, '1', 'DMP'),
  10. ('dmp-report','default','master','spring.jpa.hibernate.ddl-auto', 'none', null, '1', 'DMP'),
  11. ('dmp-report','default','master','management.endpoints.web.exposure.include', '*', null, '1', 'DMP'),
  12. ('dmp-report','default','master','management.endpoint.health.show-details', 'ALWAYS', null, '1', 'DMP'),
  13. ('dmp-report','default','master','eureka.client.fetch-registry','true',null, '1', 'DMP'),
  14. ('dmp-report','default','master','eureka.client.register-with-eureka','true',null, '1', 'DMP'),
  15. ('dmp-report','default','master','eureka.instance.lease-renewal-interval-in-seconds','10',null, '1', 'DMP'),
  16. ('dmp-report','default','master','eureka.instance.lease-expiration-duration-in-seconds','30',null, '1', 'DMP'),
  17. ('dmp-report','default','master','eureka.instance.hostname','${spring.application.name}',null, '1', 'DMP'),
  18. ('dmp-report','default','master','eureka.instance.prefer-ip-address','true',null, '1', 'DMP'),
  19. ('dmp-report','default','master','eureka.instance.instance-id','${spring.cloud.client.ip-address}:${server.port}',null, '1', 'DMP'),
  20. ('dmp-report','dev','master','spring.datasource.url', 'jdbc:mysql://localhost:3301/dmp_dev?useUnicode=true&characterEncoding=utf-8&mysqlEncoding=utf8&useSSL=false', null, '1', 'DMP'),
  21. ('dmp-report','dev','master','spring.datasource.username', 'root', null, '1', 'DMP'),
  22. ('dmp-report','dev','master','spring.datasource.password', '123456', null, '1', 'DMP'),
  23. ('dmp-report','dev','master','spring.rabbitmq.host', 'host', null, '1', 'DMP'),
  24. ('dmp-report','dev','master','spring.rabbitmq.port', '5672', null, '1', 'DMP'),
  25. ('dmp-report','dev','master','spring.rabbitmq.username', 'admin', null, '1', 'DMP'),
  26. ('dmp-report','dev','master','spring.rabbitmq.password', '123456', null, '1', 'DMP'),
  27. ('dmp-report','dev','master','spring.rabbitmq.virtual-host', '/test', null, '1', 'DMP'),
  28. ('dmp-report','dev','master','eureka.client.service-url.defaultZone','http://frame:123456@localhost:9931/eureka/',null, '1', 'DMP'),
  29. ('dmp-report','dev','master','eureka.instance.ip-address','localhost',null, '1', 'DMP'),
  30. ('dmp-report','dev','master','dmp.report.exchange','exchange-dmp',null, '1', 'DMP'),
  31. ('dmp-report','dev','master','dmp.report.routingKey','routing-dmp-report',null, '1', 'DMP'),
  32. ('dmp-report','dev','master','dmp.report.queue','report-queue',null, '1', 'DMP'),
  33. ('dmp-report','dev','master','feign.client.config.default.connectTimeout','5000',null, '1', 'DMP'),
  34. ('dmp-report','dev','master','feign.client.config.default.readTimeout','10000',null, '1', 'DMP');