/*
 Navicat Premium Data Transfer

 Source Server         : 绿电线上
 Source Server Type    : MySQL
 Source Server Version : 80027 (8.0.27)
 Source Host           : 47.120.5.122:3306
 Source Schema         : nacos

 Target Server Type    : MySQL
 Target Server Version : 80027 (8.0.27)
 File Encoding         : 65001

 Date: 30/06/2025 19:16:30
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for config_info
-- ----------------------------
DROP TABLE IF EXISTS `config_info`;
CREATE TABLE `config_info`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id',
  `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'content',
  `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'md5',
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  `src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT 'source user',
  `src_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'source ip',
  `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT '租户字段',
  `c_desc` varchar(256) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `c_use` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `effect` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `type` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `c_schema` text CHARACTER SET utf8 COLLATE utf8_bin NULL,
  `encrypted_data_key` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT '秘钥',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uk_configinfo_datagrouptenant`(`data_id` ASC, `group_id` ASC, `tenant_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'config_info' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of config_info
-- ----------------------------
INSERT INTO `config_info` VALUES (1, 'sentinel-ruoyi-gateway', 'DEFAULT_GROUP', '[\r\n    {\r\n        \"resource\": \"ruoyi-auth\",\r\n        \"count\": 500,\r\n        \"grade\": 1,\r\n        \"limitApp\": \"default\",\r\n        \"strategy\": 0,\r\n        \"controlBehavior\": 0\r\n    },\r\n	{\r\n        \"resource\": \"ruoyi-system\",\r\n        \"count\": 1000,\r\n        \"grade\": 1,\r\n        \"limitApp\": \"default\",\r\n        \"strategy\": 0,\r\n        \"controlBehavior\": 0\r\n    },\r\n	{\r\n        \"resource\": \"ruoyi-gen\",\r\n        \"count\": 200,\r\n        \"grade\": 1,\r\n        \"limitApp\": \"default\",\r\n        \"strategy\": 0,\r\n        \"controlBehavior\": 0\r\n    },\r\n	{\r\n        \"resource\": \"ruoyi-job\",\r\n        \"count\": 300,\r\n        \"grade\": 1,\r\n        \"limitApp\": \"default\",\r\n        \"strategy\": 0,\r\n        \"controlBehavior\": 0\r\n    }\r\n]', '9f3a3069261598f74220bc47958ec252', '2025-06-30 05:43:00', '2025-06-30 05:43:00', NULL, '221.182.45.100', '', '508d0707-50dd-48b0-ad27-349e7bb3c9eb', NULL, NULL, NULL, 'text', NULL, NULL);
INSERT INTO `config_info` VALUES (2, 'ruoyi-account.yml', 'DEFAULT_GROUP', 'server:\n  port: 9200\nspring:\n  redis:\n    host: 47.120.5.122\n    port: 6379\n    password: [REDACTED]  datasource:\n    type: com.alibaba.druid.pool.DruidDataSource\n    driver-class-name: com.mysql.cj.jdbc.Driver\n    url: jdbc:mysql://47.120.5.122:3306/gy_jifenshangcheng_account?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n    username: root\n    password: [REDACTED]    druid:\n      # 连接池初始化时创建的连接数。\n      # 应根据实际应用场景设置，确保应用程序启动时即可获取数据库连接。\n      initial-size: 10\n      # 连接池中最小的空闲连接数，保证即使在低负载时也有足够的连接可用。\n      min-idle: 10\n      # 连接池中最大活动连接数，限制并发请求时的数据库连接数，避免过多的连接消耗系统资源。\n      max-active: 1000\n      # 获取连接时的最大等待时间，超过该时间则抛出异常。单位通常为毫秒。\n      max-wait: 60000\n      # 两个连接检查之间的时间间隔，用于检测和清理空闲过久的连接。单位为毫秒。\n      time-between-eviction-runs-millis: 60000\n      # 连接在被清理前的最小空闲时间。单位为毫秒。\n      min-evictable-idle-time-millis: 300000\n      # 用于验证连接有效性的 SQL 查询语句。\n      validation-query: SELECT 1 \n      # 如果为真，则连接空闲时会被定期测试有效性。\n      test-while-idle: true\n      # 如果为真，在获取连接前进行有效性测试。\n      test-on-borrow: false\n      # 如果为真，在归还连接时进行有效性测试。\n      test-on-return: false\n      # 是否开启 PreparedStatement 缓存。\n      pool-prepared-statements: true\n      # 单个连接上缓存的 PreparedStatement 最大数量。\n      max-pool-prepared-statement-per-connection-size: 20\n      # 指定要启用的过滤器，如 stat, log4j, wall 等，用于监控和日志记录。\n      filters: stat,wall,log4j\n      # 连接属性，例如配置日志级别或慢 SQL 阈值。\n      connection-properties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000\n      # 是否自动回收超时连接\n      remove-abandoned: true\n      # 超时时间，单位秒\n      remove-abandoned-timeout: 1800\n      # 是否记录被遗弃的连接\n      log-abandoned: true\n      # StatViewServlet配置，访问监控页面\n      stat-view-servlet:\n        enabled: true\n        url-pattern: /druid/*\n        login-username: admin\n        login-password: [REDACTED]        reset-enable: false\n      # 防火墙配置\n      wall:\n        config:\n          multi-statement-allow: false\nwx: \n  appletsAppid: wx049faf9c5234f31c\n  appletsAppSecret: [REDACTED]\n\n\nali:\n  conf: \n    appId: 2021004173610331\n    privateKey: [REDACTED]==\n    alipayPublicKey: [REDACTED]\n', 'c30ea350cb0602842ac83f6e4f896002', '2025-06-30 05:43:00', '2025-06-30 05:46:29', 'nacos', '221.182.45.100', '', '508d0707-50dd-48b0-ad27-349e7bb3c9eb', '', '', '', 'yaml', '', NULL);
INSERT INTO `config_info` VALUES (3, 'ruoyi-order.yml', 'DEFAULT_GROUP', 'server:\n  port: 9400\nspring:\n  redis:\n    host: 47.120.5.122\n    port: 6379\n    password: [REDACTED]  datasource:\n    type: com.alibaba.druid.pool.DruidDataSource\n    driver-class-name: com.mysql.cj.jdbc.Driver\n    url: jdbc:mysql://47.120.5.122:3306/gy_jifenshangcheng_order?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n    username: root\n    password: [REDACTED]    druid:\n      # 连接池初始化时创建的连接数。\n      # 应根据实际应用场景设置，确保应用程序启动时即可获取数据库连接。\n      initial-size: 10\n      # 连接池中最小的空闲连接数，保证即使在低负载时也有足够的连接可用。\n      min-idle: 10\n      # 连接池中最大活动连接数，限制并发请求时的数据库连接数，避免过多的连接消耗系统资源。\n      max-active: 1000\n      # 获取连接时的最大等待时间，超过该时间则抛出异常。单位通常为毫秒。\n      max-wait: 60000\n      # 两个连接检查之间的时间间隔，用于检测和清理空闲过久的连接。单位为毫秒。\n      time-between-eviction-runs-millis: 60000\n      # 连接在被清理前的最小空闲时间。单位为毫秒。\n      min-evictable-idle-time-millis: 300000\n      # 用于验证连接有效性的 SQL 查询语句。\n      validation-query: SELECT 1 \n      # 如果为真，则连接空闲时会被定期测试有效性。\n      test-while-idle: true\n      # 如果为真，在获取连接前进行有效性测试。\n      test-on-borrow: false\n      # 如果为真，在归还连接时进行有效性测试。\n      test-on-return: false\n      # 是否开启 PreparedStatement 缓存。\n      pool-prepared-statements: true\n      # 单个连接上缓存的 PreparedStatement 最大数量。\n      max-pool-prepared-statement-per-connection-size: 20\n      # 指定要启用的过滤器，如 stat, log4j, wall 等，用于监控和日志记录。\n      filters: stat,wall,log4j\n      # 连接属性，例如配置日志级别或慢 SQL 阈值。\n      connection-properties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000\n      # 是否自动回收超时连接\n      remove-abandoned: true\n      # 超时时间，单位秒\n      remove-abandoned-timeout: 1800\n      # 是否记录被遗弃的连接\n      log-abandoned: true\n      # StatViewServlet配置，访问监控页面\n      stat-view-servlet:\n        enabled: true\n        url-pattern: /druid/*\n        login-username: admin\n        login-password: [REDACTED]        reset-enable: false\n      # 防火墙配置\n      wall:\n        config:\n          multi-statement-allow: false\nwx:\n  grantType: authorization_code \n  appid: wx049faf9c5234f31c \n  appSecret: [REDACTED]\n  appletsAppid: #小程序APPid\n  appletsAppSecret: #\n  mchId: 1717539630 \n  key: [REDACTED] \n  callbackPath: http://47.120.5.122:8080\n  certPath: classpath:cert/apiclient_cert.p12\n  RASPath: E:cert/wechat_rsa_public_key.pem\nalipay:\n  appid: \n  appPrivateKey:\n  alipayPublicKey:\n  alipay_public_key:\n', '2213e64fd4ace1af3e2aef5ef7810c4e', '2025-06-30 05:43:00', '2025-06-30 06:09:46', 'nacos', '221.182.45.100', '', '508d0707-50dd-48b0-ad27-349e7bb3c9eb', '', '', '', 'yaml', '', NULL);
INSERT INTO `config_info` VALUES (4, 'ruoyi-other.yml', 'DEFAULT_GROUP', 'server:\n  port: 9600\nspring:\n  redis:\n    host: 47.120.5.122\n    port: 6379\n    password: [REDACTED]  datasource:\n    type: com.alibaba.druid.pool.DruidDataSource\n    driver-class-name: com.mysql.cj.jdbc.Driver\n    url: jdbc:mysql://47.120.5.122:3306/gy_jifenshangcheng_other?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n    username: root\n    password: [REDACTED]    druid:\n      # 连接池初始化时创建的连接数。\n      # 应根据实际应用场景设置，确保应用程序启动时即可获取数据库连接。\n      initial-size: 10\n      # 连接池中最小的空闲连接数，保证即使在低负载时也有足够的连接可用。\n      min-idle: 10\n      # 连接池中最大活动连接数，限制并发请求时的数据库连接数，避免过多的连接消耗系统资源。\n      max-active: 1000\n      # 获取连接时的最大等待时间，超过该时间则抛出异常。单位通常为毫秒。\n      max-wait: 60000\n      # 两个连接检查之间的时间间隔，用于检测和清理空闲过久的连接。单位为毫秒。\n      time-between-eviction-runs-millis: 60000\n      # 连接在被清理前的最小空闲时间。单位为毫秒。\n      min-evictable-idle-time-millis: 300000\n      # 用于验证连接有效性的 SQL 查询语句。\n      validation-query: SELECT 1 \n      # 如果为真，则连接空闲时会被定期测试有效性。\n      test-while-idle: true\n      # 如果为真，在获取连接前进行有效性测试。\n      test-on-borrow: false\n      # 如果为真，在归还连接时进行有效性测试。\n      test-on-return: false\n      # 是否开启 PreparedStatement 缓存。\n      pool-prepared-statements: true\n      # 单个连接上缓存的 PreparedStatement 最大数量。\n      max-pool-prepared-statement-per-connection-size: 20\n      # 指定要启用的过滤器，如 stat, log4j, wall 等，用于监控和日志记录。\n      filters: stat,wall,log4j\n      # 连接属性，例如配置日志级别或慢 SQL 阈值。\n      connection-properties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000\n      # 是否自动回收超时连接\n      remove-abandoned: true\n      # 超时时间，单位秒\n      remove-abandoned-timeout: 1800\n      # 是否记录被遗弃的连接\n      log-abandoned: true\n      # StatViewServlet配置，访问监控页面\n      stat-view-servlet:\n        enabled: true\n        url-pattern: /druid/*\n        login-username: admin\n        login-password: [REDACTED]        reset-enable: false\n      # 防火墙配置\n      wall:\n        config:\n          multi-statement-allow: false\n\nmybatis-plus:\n  # 此处在多数据源中生效\n  config-location: classpath:/mybatis-config.xml\n  global-config:\n    banner: false\n    db-config:\n      logic-not-delete-value: 0\n      logic-delete-value: 1\n  type-aliases-package: com.ruoyi.other\n  # 指定Mapper文件位置\n  mapper-locations: classpath*:/mapper/**/*.xml\nwx:\n  grantType: authorization_code \n  appid: wx049faf9c5234f31c \n  appSecret: [REDACTED]\n  appletsAppid: #小程序APPid\n  appletsAppSecret: #\n  mchId: 1717539630 \n  key: [REDACTED] \n  callbackPath: http://47.120.5.122:8080\n  certPath: classpath:cert/apiclient_cert.p12\n', '0b1679380e4a0b008855ba68574dc218', '2025-06-30 05:43:00', '2025-06-30 06:10:14', 'nacos', '221.182.45.100', '', '508d0707-50dd-48b0-ad27-349e7bb3c9eb', '', '', '', 'yaml', '', NULL);
INSERT INTO `config_info` VALUES (5, '.metadata', 'DEFAULT_GROUP', 'metadata:\r\n- appName: \'\'\r\n  dataId: application-dev.yml\r\n  desc: \'\'\r\n  group: DEFAULT_GROUP\r\n  type: yaml\r\n- appName: \'\'\r\n  dataId: ruoyi-gateway-dev.yml\r\n  desc: \'\'\r\n  group: DEFAULT_GROUP\r\n  type: yaml\r\n- appName: \'\'\r\n  dataId: ruoyi-auth-dev.yml\r\n  desc: \'\'\r\n  group: DEFAULT_GROUP\r\n  type: yaml\r\n- appName: \'\'\r\n  dataId: ruoyi-system-dev.yml\r\n  desc: \'\'\r\n  group: DEFAULT_GROUP\r\n  type: yaml\r\n- appName: \'\'\r\n  dataId: ruoyi-gen-dev.yml\r\n  desc: \'\'\r\n  group: DEFAULT_GROUP\r\n  type: yaml\r\n- appName: \'\'\r\n  dataId: ruoyi-job-dev.yml\r\n  group: DEFAULT_GROUP\r\n  type: yaml\r\n- appName: \'\'\r\n  dataId: ruoyi-file-dev.yml\r\n  group: DEFAULT_GROUP\r\n  type: yaml\r\n- appName: \'\'\r\n  dataId: sentinel-ruoyi-gateway\r\n  group: DEFAULT_GROUP\r\n  type: text\r\n- appName: \'\'\r\n  dataId: ruoyi-account.yml\r\n  desc: 账户服务\r\n  group: DEFAULT_GROUP\r\n  type: yaml\r\n- appName: \'\'\r\n  dataId: ruoyi-order.yml\r\n  desc: 订单服务\r\n  group: DEFAULT_GROUP\r\n  type: yaml\r\n- appName: \'\'\r\n  dataId: ruoyi-other.yml\r\n  desc: 系统基础服务\r\n  group: DEFAULT_GROUP\r\n  type: yaml\r\n- appName: \'\'\r\n  dataId: seata-server.properties\r\n  desc: \'\'\r\n  group: DEFAULT_GROUP\r\n  type: properties\r\n', '325cafb4cf54976cf8aecfa9f2805ac4', '2025-06-30 05:43:00', '2025-06-30 05:43:00', NULL, '221.182.45.100', '', '508d0707-50dd-48b0-ad27-349e7bb3c9eb', NULL, NULL, NULL, 'text', NULL, NULL);
INSERT INTO `config_info` VALUES (6, 'application-prod.yml', 'DEFAULT_GROUP', 'spring:\r\n#maxFileSize 单个数据大小\r\n  servlet:\r\n    multipart: \r\n      max-file-size: 50MB\r\n#maxRequestSize 是总数据大小\r\n      max-request-size: 100MB\r\n  autoconfigure:\r\n    exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure\r\n  mvc:\r\n    pathmatch:\r\n      matching-strategy: ant_path_matcher\r\n\r\n# feign 配置\r\nfeign:\r\n  sentinel:\r\n    enabled: true\r\n  okhttp:\r\n    enabled: true\r\n  httpclient:\r\n    enabled: false\r\n  client:\r\n    config:\r\n      default:\r\n        connectTimeout: 10000\r\n        readTimeout: 10000\r\n  compression:\r\n    request:\r\n      enabled: false\r\n    response:\r\n      enabled: false\r\n\r\n# 暴露监控端点\r\nmanagement:\r\n  endpoints:\r\n    web:\r\n      exposure:\r\n        include: \'*\'\r\n\r\n\r\nsecurity:\r\n  # 不校验白名单\r\n  ignore:\r\n    whites:\r\n      - /logout\r\n      - /login\r\n      - /register\r\n      - /*/v2/api-docs\r\n      - /csrf\r\n      - /account/app-user/appletLogin\r\n      - /account/app-user/mobileLogin\r\n      - /account/app-user/getSMSCode\r\n      - /account/app-user/registerAccount\r\n      - /account/app-user/getReferrer\r\n      - /account/app-user/getNearbyReferrer\r\n\r\n# 文件上传地址\r\nfile: \r\n  upload: \r\n    accessPath: http://47.120.5.122:8080/\r\n    location: D:/Program Files/nginx-1.20.2/html/\r\n    allowExt: png,jpeg,jpg,pdf,doc,docx', 'da086b5082b6e2cdec6198ec09955398', '2025-06-30 05:43:00', '2025-06-30 05:43:00', NULL, '221.182.45.100', '', '508d0707-50dd-48b0-ad27-349e7bb3c9eb', NULL, NULL, NULL, 'yaml', NULL, NULL);
INSERT INTO `config_info` VALUES (7, 'ruoyi-gateway-prod.yml', 'DEFAULT_GROUP', 'server:\n  port: 8080\n  tomcat:\n    max-swallow-size: 10MB\nspring:\n#maxFileSize 单个数据大小\n  servlet:\n    multipart: \n      max-file-size: 50MB\n#maxRequestSize 是总数据大小\n      max-request-size: 100MB\n  redis:\n    host: 47.120.5.122\n    port: 6379\n    password: [REDACTED]  cloud:\n    gateway:\n      discovery:\n        locator:\n          lowerCaseServiceId: true\n          enabled: true\n      routes:\n        # 认证中心\n        - id: ruoyi-auth\n          uri: lb://ruoyi-auth\n          predicates:\n            - Path=/auth/**\n          filters:\n            # 验证码处理\n            - CacheRequestFilter\n            - ValidateCodeFilter\n            - StripPrefix=1\n        # 系统模块\n        - id: ruoyi-system\n          uri: lb://ruoyi-system\n          predicates:\n            - Path=/system/**\n          filters:\n            - StripPrefix=1\n        # 文件服务\n        - id: ruoyi-file\n          uri: lb://ruoyi-file\n          predicates:\n            - Path=/file/**\n          filters:\n            - StripPrefix=1\n        # 账户服务\n        - id: ruoyi-account\n          uri: lb://ruoyi-account\n          predicates:\n            - Path=/account/**\n          filters:\n            - StripPrefix=1\n        # 订单服务\n        - id: ruoyi-order\n          uri: lb://ruoyi-order\n          predicates:\n            - Path=/order/**\n          filters:\n            - StripPrefix=1\n        # 系统配置服务\n        - id: ruoyi-other\n          uri: lb://ruoyi-other\n          predicates:\n            - Path=/other/**\n          filters:\n            - StripPrefix=1\n\n# 安全配置\nsecurity:\n  # 验证码\n  captcha:\n    enabled: false\n    type: math\n  # 防止XSS攻击\n  xss:\n    enabled: true\n    excludeUrls:\n      - /other/goods/manageGoodsUpdate\n      - /other/goods/addGoods\n      - /other/vip-setting/manage/set\n      - /other/agreement/saveAgreement\n      - /other/system-config/index/add\n      - /other/share/manage/add\n      - /other/share/manage/edit\n      - /other/shop/addGoods\n      - /other/shop/editGoods\n      - /other/goods/manageGoodsUpdate\n      - /order/order/orderPaymentCallback\n      - /order/order/refundPayMoneyCallback\n      - /order/order/getRsaPublicKey\n\n  # 不校验白名单\n  ignore:\n    whites:\n      - /auth/logout\n      - /auth/login\n      - /auth/loginShop\n      - /auth/register\n      - /*/v2/api-docs\n      - /csrf\n      - /account/app-user/appletLogin\n      - /account/app-user/mobileLogin\n      - /account/app-user/getSMSCode\n      - /account/app-user/registerAccount\n      - /account/app-user/getReferrer\n      - /account/app-user/getNearbyReferrer\n      - /account/wallet/rechargeCallback\n      - /other/system-config/index/start\n      - /other/system-config/index/detail\n      - /other/goods-category/index/list\n      - /other/goods/goodsList\n      - /other/goods/goodsDetail/*\n      - /other/goods/getGoodsListByShopId\n      - /other/banner/list\n      - /other/shop/shopDetail\n      - /other/shop/nearbyShopList\n      - /other/share/detail/*\n      - /other/seckill-activity-info/vipId/*\n      - /account/app-user/upload\n      - /other/agreement/getAgreement/*\n      - /system/user/profile/updatePwd\n      - /other/goods-evaluate/goodsList\n      - /order/order/refundPayMoneyCallback\n      - /order/order/refundExpressPayMoneyCallback\n      - /order/shopping-cart/shoppingCartPaymentCallback\n      - /order/shopping-cart/shoppingCartMaterialFlowPaymentCallback\n      - /account/withdrawal-requests/withdrawalCallback\n      - /other/shop-withdraw/withdrawalCallback\n      - /order/order/importExpress\n      - /order/order/orderPaymentCallback\n      - /order/order/refundPayMoneyCallback\n      - /order/order/getRsaPublicKey\n      - /account/app-user/download/**\n      - /order/charge/importExpress\n              \n  # 参数签名校验\n  sign: \n    enable: false\n  # 防抖校验\n  anti-shake: \n    enable: true\n    interval: 500', '0817566193c521e230bda8271a9b338a', '2025-06-30 05:43:00', '2025-06-30 05:43:00', NULL, '221.182.45.100', '', '508d0707-50dd-48b0-ad27-349e7bb3c9eb', NULL, NULL, NULL, 'yaml', NULL, NULL);
INSERT INTO `config_info` VALUES (8, 'ruoyi-auth-prod.yml', 'DEFAULT_GROUP', 'server:\n  port: 9100\nspring:\n  redis:\n    host: 47.120.5.122\n    port: 6379\n    password: [REDACTED]  datasource:\n    type: com.alibaba.druid.pool.DruidDataSource\n    driver-class-name: com.mysql.cj.jdbc.Driver\n    url: jdbc:mysql://47.120.5.122:3306/gy_jifenshangcheng_system?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n    username: root\n    password: [REDACTED]    druid:\n      # 连接池初始化时创建的连接数。\n      # 应根据实际应用场景设置，确保应用程序启动时即可获取数据库连接。\n      initial-size: 10\n      # 连接池中最小的空闲连接数，保证即使在低负载时也有足够的连接可用。\n      min-idle: 10\n      # 连接池中最大活动连接数，限制并发请求时的数据库连接数，避免过多的连接消耗系统资源。\n      max-active: 1000\n      # 获取连接时的最大等待时间，超过该时间则抛出异常。单位通常为毫秒。\n      max-wait: 60000\n      # 两个连接检查之间的时间间隔，用于检测和清理空闲过久的连接。单位为毫秒。\n      time-between-eviction-runs-millis: 60000\n      # 连接在被清理前的最小空闲时间。单位为毫秒。\n      min-evictable-idle-time-millis: 300000\n      # 用于验证连接有效性的 SQL 查询语句。\n      validation-query: SELECT 1 \n      # 如果为真，则连接空闲时会被定期测试有效性。\n      test-while-idle: true\n      # 如果为真，在获取连接前进行有效性测试。\n      test-on-borrow: false\n      # 如果为真，在归还连接时进行有效性测试。\n      test-on-return: false\n      # 是否开启 PreparedStatement 缓存。\n      pool-prepared-statements: true\n      # 单个连接上缓存的 PreparedStatement 最大数量。\n      max-pool-prepared-statement-per-connection-size: 20\n      # 指定要启用的过滤器，如 stat, log4j, wall 等，用于监控和日志记录。\n      filters: stat,wall,log4j\n      # 连接属性，例如配置日志级别或慢 SQL 阈值。\n      connection-properties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000\n      # 是否自动回收超时连接\n      remove-abandoned: true\n      # 超时时间，单位秒\n      remove-abandoned-timeout: 1800\n      # 是否记录被遗弃的连接\n      log-abandoned: true\n      # StatViewServlet配置，访问监控页面\n      stat-view-servlet:\n        enabled: true\n        url-pattern: /druid/*\n        login-username: admin\n        login-password: [REDACTED]        reset-enable: false\n      # 防火墙配置\n      wall:\n        config:\n          multi-statement-allow: false\n', 'ef793d390ad13310c970bbed567aff1e', '2025-06-30 05:43:00', '2025-06-30 05:48:32', 'nacos', '221.182.45.100', '', '508d0707-50dd-48b0-ad27-349e7bb3c9eb', '', '', '', 'yaml', '', NULL);
INSERT INTO `config_info` VALUES (9, 'ruoyi-system-prod.yml', 'DEFAULT_GROUP', 'server:\n  port: 9800\n# spring配置\nspring:\n  redis:\n    host: 47.120.5.122\n    port: 6379\n    password: [REDACTED]  datasource: \n    type: com.alibaba.druid.pool.DruidDataSource\n    driver-class-name: com.mysql.cj.jdbc.Driver\n    url: jdbc:mysql://47.120.5.122:3306/gy_jifenshangcheng_system?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n    username: root\n    password: [REDACTED]    druid:\n      # 连接池初始化时创建的连接数。\n      # 应根据实际应用场景设置，确保应用程序启动时即可获取数据库连接。\n      initial-size: 10\n      # 连接池中最小的空闲连接数，保证即使在低负载时也有足够的连接可用。\n      min-idle: 10\n      # 连接池中最大活动连接数，限制并发请求时的数据库连接数，避免过多的连接消耗系统资源。\n      max-active: 1000\n      # 获取连接时的最大等待时间，超过该时间则抛出异常。单位通常为毫秒。\n      max-wait: 60000\n      # 两个连接检查之间的时间间隔，用于检测和清理空闲过久的连接。单位为毫秒。\n      time-between-eviction-runs-millis: 60000\n      # 连接在被清理前的最小空闲时间。单位为毫秒。\n      min-evictable-idle-time-millis: 300000\n      # 用于验证连接有效性的 SQL 查询语句。\n      validation-query: SELECT 1 \n      # 如果为真，则连接空闲时会被定期测试有效性。\n      test-while-idle: true\n      # 如果为真，在获取连接前进行有效性测试。\n      test-on-borrow: false\n      # 如果为真，在归还连接时进行有效性测试。\n      test-on-return: false\n      # 是否开启 PreparedStatement 缓存。\n      pool-prepared-statements: true\n      # 单个连接上缓存的 PreparedStatement 最大数量。\n      max-pool-prepared-statement-per-connection-size: 20\n      # 指定要启用的过滤器，如 stat, log4j, wall 等，用于监控和日志记录。\n      filters: stat,wall,log4j\n      # 连接属性，例如配置日志级别或慢 SQL 阈值。\n      connection-properties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000\n      # 是否自动回收超时连接\n      remove-abandoned: true\n      # 超时时间，单位秒\n      remove-abandoned-timeout: 1800\n      # 是否记录被遗弃的连接\n      log-abandoned: true\n      # StatViewServlet配置，访问监控页面\n      stat-view-servlet:\n        enabled: true\n        url-pattern: /druid/*\n        login-username: admin\n        login-password: [REDACTED]        reset-enable: false\n      # 防火墙配置\n      wall:\n        config:\n          multi-statement-allow: false\n    \n\n# mybatis配置\n# mybatis:\n#     # 搜索指定包别名\n#   typeAliasesPackage: com.ruoyi.system,com.ruoyi.system.api\n#     # 配置mapper的扫描，找到所有的mapper.xml映射文件\n#   mapperLocations: classpath:mapper/**/*.xml\nmybatis-plus:\n  # 此处在多数据源中生效\n  config-location: classpath:/mybatis-config.xml\n  global-config:\n    banner: false\n    db-config:\n      logic-not-delete-value: 0\n      logic-delete-value: 1\n  type-aliases-package: com.ruoyi.system\n  # 指定Mapper文件位置\n  mapper-locations: classpath*:/mapping/**/*.xml\n\n# swagger配置\nswagger:\n  title: 系统模块接口文档\n  enabled: true\n  license: Powered By ruoyi\n  licenseUrl: http://47.120.5.122:9800/doc.html', 'd480ddca71915102966cdd1639c1cedb', '2025-06-30 05:43:00', '2025-06-30 06:06:06', 'nacos', '221.182.45.100', '', '508d0707-50dd-48b0-ad27-349e7bb3c9eb', '', '', '', 'yaml', '', NULL);

-- ----------------------------
-- Table structure for config_info_aggr
-- ----------------------------
DROP TABLE IF EXISTS `config_info_aggr`;
CREATE TABLE `config_info_aggr`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id',
  `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'group_id',
  `datum_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'datum_id',
  `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '内容',
  `gmt_modified` datetime NOT NULL COMMENT '修改时间',
  `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT '租户字段',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uk_configinfoaggr_datagrouptenantdatum`(`data_id` ASC, `group_id` ASC, `tenant_id` ASC, `datum_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '增加租户字段' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of config_info_aggr
-- ----------------------------

-- ----------------------------
-- Table structure for config_info_beta
-- ----------------------------
DROP TABLE IF EXISTS `config_info_beta`;
CREATE TABLE `config_info_beta`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id',
  `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'group_id',
  `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'app_name',
  `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'content',
  `beta_ips` varchar(1024) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'betaIps',
  `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'md5',
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  `src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT 'source user',
  `src_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'source ip',
  `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT '租户字段',
  `encrypted_data_key` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '秘钥',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uk_configinfobeta_datagrouptenant`(`data_id` ASC, `group_id` ASC, `tenant_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'config_info_beta' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of config_info_beta
-- ----------------------------

-- ----------------------------
-- Table structure for config_info_tag
-- ----------------------------
DROP TABLE IF EXISTS `config_info_tag`;
CREATE TABLE `config_info_tag`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id',
  `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'group_id',
  `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT 'tenant_id',
  `tag_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'tag_id',
  `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'app_name',
  `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'content',
  `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'md5',
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  `src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT 'source user',
  `src_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'source ip',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uk_configinfotag_datagrouptenanttag`(`data_id` ASC, `group_id` ASC, `tenant_id` ASC, `tag_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'config_info_tag' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of config_info_tag
-- ----------------------------

-- ----------------------------
-- Table structure for config_tags_relation
-- ----------------------------
DROP TABLE IF EXISTS `config_tags_relation`;
CREATE TABLE `config_tags_relation`  (
  `id` bigint NOT NULL COMMENT 'id',
  `tag_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'tag_name',
  `tag_type` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'tag_type',
  `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id',
  `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'group_id',
  `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT 'tenant_id',
  `nid` bigint NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`nid`) USING BTREE,
  UNIQUE INDEX `uk_configtagrelation_configidtag`(`id` ASC, `tag_name` ASC, `tag_type` ASC) USING BTREE,
  INDEX `idx_tenant_id`(`tenant_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'config_tag_relation' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of config_tags_relation
-- ----------------------------

-- ----------------------------
-- Table structure for group_capacity
-- ----------------------------
DROP TABLE IF EXISTS `group_capacity`;
CREATE TABLE `group_capacity`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'Group ID，空字符表示整个集群',
  `quota` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '配额，0表示使用默认值',
  `usage` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '使用量',
  `max_size` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '单个配置大小上限，单位为字节，0表示使用默认值',
  `max_aggr_count` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '聚合子配置最大个数，，0表示使用默认值',
  `max_aggr_size` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '单个聚合数据的子配置大小上限，单位为字节，0表示使用默认值',
  `max_history_count` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '最大变更历史数量',
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uk_group_id`(`group_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '集群、各Group容量信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of group_capacity
-- ----------------------------

-- ----------------------------
-- Table structure for his_config_info
-- ----------------------------
DROP TABLE IF EXISTS `his_config_info`;
CREATE TABLE `his_config_info`  (
  `id` bigint UNSIGNED NOT NULL,
  `nid` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'app_name',
  `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL,
  `src_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `op_type` char(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT '租户字段',
  `encrypted_data_key` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT '秘钥',
  PRIMARY KEY (`nid`) USING BTREE,
  INDEX `idx_gmt_create`(`gmt_create` ASC) USING BTREE,
  INDEX `idx_gmt_modified`(`gmt_modified` ASC) USING BTREE,
  INDEX `idx_did`(`data_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '多租户改造' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of his_config_info
-- ----------------------------
INSERT INTO `his_config_info` VALUES (0, 1, 'sentinel-ruoyi-gateway', 'DEFAULT_GROUP', '', '[\r\n    {\r\n        \"resource\": \"ruoyi-auth\",\r\n        \"count\": 500,\r\n        \"grade\": 1,\r\n        \"limitApp\": \"default\",\r\n        \"strategy\": 0,\r\n        \"controlBehavior\": 0\r\n    },\r\n	{\r\n        \"resource\": \"ruoyi-system\",\r\n        \"count\": 1000,\r\n        \"grade\": 1,\r\n        \"limitApp\": \"default\",\r\n        \"strategy\": 0,\r\n        \"controlBehavior\": 0\r\n    },\r\n	{\r\n        \"resource\": \"ruoyi-gen\",\r\n        \"count\": 200,\r\n        \"grade\": 1,\r\n        \"limitApp\": \"default\",\r\n        \"strategy\": 0,\r\n        \"controlBehavior\": 0\r\n    },\r\n	{\r\n        \"resource\": \"ruoyi-job\",\r\n        \"count\": 300,\r\n        \"grade\": 1,\r\n        \"limitApp\": \"default\",\r\n        \"strategy\": 0,\r\n        \"controlBehavior\": 0\r\n    }\r\n]', '9f3a3069261598f74220bc47958ec252', '2025-06-30 18:42:59', '2025-06-30 05:43:00', NULL, '221.182.45.100', 'I', '508d0707-50dd-48b0-ad27-349e7bb3c9eb', NULL);
INSERT INTO `his_config_info` VALUES (0, 2, 'ruoyi-account.yml', 'DEFAULT_GROUP', '', 'server:\n  port: 9200\nspring:\n  redis:\n    host: 47.120.5.122\n    port: 6379\n    password: [REDACTED]  datasource:\n    type: com.alibaba.druid.pool.DruidDataSource\n    driver-class-name: com.mysql.cj.jdbc.Driver\n    url: jdbc:mysql://47.120.5.122:3306/gy_jifenshangcheng_account?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n    username: root\n    password: [REDACTED]    druid:\n      # 连接池初始化时创建的连接数。\n      # 应根据实际应用场景设置，确保应用程序启动时即可获取数据库连接。\n      initial-size: 10\n      # 连接池中最小的空闲连接数，保证即使在低负载时也有足够的连接可用。\n      min-idle: 10\n      # 连接池中最大活动连接数，限制并发请求时的数据库连接数，避免过多的连接消耗系统资源。\n      max-active: 1000\n      # 获取连接时的最大等待时间，超过该时间则抛出异常。单位通常为毫秒。\n      max-wait: 60000\n      # 两个连接检查之间的时间间隔，用于检测和清理空闲过久的连接。单位为毫秒。\n      time-between-eviction-runs-millis: 60000\n      # 连接在被清理前的最小空闲时间。单位为毫秒。\n      min-evictable-idle-time-millis: 300000\n      # 用于验证连接有效性的 SQL 查询语句。\n      validation-query: SELECT 1 \n      # 如果为真，则连接空闲时会被定期测试有效性。\n      test-while-idle: true\n      # 如果为真，在获取连接前进行有效性测试。\n      test-on-borrow: false\n      # 如果为真，在归还连接时进行有效性测试。\n      test-on-return: false\n      # 是否开启 PreparedStatement 缓存。\n      pool-prepared-statements: true\n      # 单个连接上缓存的 PreparedStatement 最大数量。\n      max-pool-prepared-statement-per-connection-size: 20\n      # 指定要启用的过滤器，如 stat, log4j, wall 等，用于监控和日志记录。\n      filters: stat,wall,log4j\n      # 连接属性，例如配置日志级别或慢 SQL 阈值。\n      connection-properties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000\n      # 是否自动回收超时连接\n      remove-abandoned: true\n      # 超时时间，单位秒\n      remove-abandoned-timeout: 1800\n      # 是否记录被遗弃的连接\n      log-abandoned: true\n      # StatViewServlet配置，访问监控页面\n      stat-view-servlet:\n        enabled: true\n        url-pattern: /druid/*\n        login-username: admin\n        login-password: [REDACTED]        reset-enable: false\n      # 防火墙配置\n      wall:\n        config:\n          multi-statement-allow: false\nwx: \n  appletsAppid: wx049faf9c5234f31c\n  appletsAppSecret: [REDACTED]\n\n\nali:\n  conf: \n    appId: 2021004173610331\n    privateKey: [REDACTED]==\n    alipayPublicKey: [REDACTED]\n', '1b48dc4d37bf29bf401f9d05d9ca551a', '2025-06-30 18:42:59', '2025-06-30 05:43:00', NULL, '221.182.45.100', 'I', '508d0707-50dd-48b0-ad27-349e7bb3c9eb', NULL);
INSERT INTO `his_config_info` VALUES (0, 3, 'ruoyi-order.yml', 'DEFAULT_GROUP', '', 'server:\n  port: 9400\nspring:\n  redis:\n    host: 47.120.5.122\n    port: 6379\n    password: [REDACTED]  datasource:\n    type: com.alibaba.druid.pool.DruidDataSource\n    driver-class-name: com.mysql.cj.jdbc.Driver\n    url: jdbc:mysql://47.120.5.122:3306/gy_jifenshangcheng_order?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n    username: root\n    password: [REDACTED]    druid:\n      # 连接池初始化时创建的连接数。\n      # 应根据实际应用场景设置，确保应用程序启动时即可获取数据库连接。\n      initial-size: 10\n      # 连接池中最小的空闲连接数，保证即使在低负载时也有足够的连接可用。\n      min-idle: 10\n      # 连接池中最大活动连接数，限制并发请求时的数据库连接数，避免过多的连接消耗系统资源。\n      max-active: 1000\n      # 获取连接时的最大等待时间，超过该时间则抛出异常。单位通常为毫秒。\n      max-wait: 60000\n      # 两个连接检查之间的时间间隔，用于检测和清理空闲过久的连接。单位为毫秒。\n      time-between-eviction-runs-millis: 60000\n      # 连接在被清理前的最小空闲时间。单位为毫秒。\n      min-evictable-idle-time-millis: 300000\n      # 用于验证连接有效性的 SQL 查询语句。\n      validation-query: SELECT 1 \n      # 如果为真，则连接空闲时会被定期测试有效性。\n      test-while-idle: true\n      # 如果为真，在获取连接前进行有效性测试。\n      test-on-borrow: false\n      # 如果为真，在归还连接时进行有效性测试。\n      test-on-return: false\n      # 是否开启 PreparedStatement 缓存。\n      pool-prepared-statements: true\n      # 单个连接上缓存的 PreparedStatement 最大数量。\n      max-pool-prepared-statement-per-connection-size: 20\n      # 指定要启用的过滤器，如 stat, log4j, wall 等，用于监控和日志记录。\n      filters: stat,wall,log4j\n      # 连接属性，例如配置日志级别或慢 SQL 阈值。\n      connection-properties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000\n      # 是否自动回收超时连接\n      remove-abandoned: true\n      # 超时时间，单位秒\n      remove-abandoned-timeout: 1800\n      # 是否记录被遗弃的连接\n      log-abandoned: true\n      # StatViewServlet配置，访问监控页面\n      stat-view-servlet:\n        enabled: true\n        url-pattern: /druid/*\n        login-username: admin\n        login-password: [REDACTED]        reset-enable: false\n      # 防火墙配置\n      wall:\n        config:\n          multi-statement-allow: false\nwx:\n  grantType: authorization_code \n  appid: wx049faf9c5234f31c \n  appSecret: [REDACTED]\n  appletsAppid: #小程序APPid\n  appletsAppSecret: #\n  mchId: 1717539630 \n  key: [REDACTED] \n  callbackPath: http://47.120.5.122:8080\n  certPath: classpath:cert/apiclient_cert.p12\n  RASPath: E:cert/wechat_rsa_public_key.pem\nalipay:\n  appid: \n  appPrivateKey:\n  alipayPublicKey:\n  alipay_public_key:\n', 'ab8f23aa57cf2620efefdb7017018597', '2025-06-30 18:42:59', '2025-06-30 05:43:00', NULL, '221.182.45.100', 'I', '508d0707-50dd-48b0-ad27-349e7bb3c9eb', NULL);
INSERT INTO `his_config_info` VALUES (0, 4, 'ruoyi-other.yml', 'DEFAULT_GROUP', '', 'server:\n  port: 9600\nspring:\n  redis:\n    host: 47.120.5.122\n    port: 6379\n    password: [REDACTED]  datasource:\n    type: com.alibaba.druid.pool.DruidDataSource\n    driver-class-name: com.mysql.cj.jdbc.Driver\n    url: jdbc:mysql://47.120.5.122:3306/gy_jifenshangcheng_other?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n    username: root\n    password: [REDACTED]    druid:\n      # 连接池初始化时创建的连接数。\n      # 应根据实际应用场景设置，确保应用程序启动时即可获取数据库连接。\n      initial-size: 10\n      # 连接池中最小的空闲连接数，保证即使在低负载时也有足够的连接可用。\n      min-idle: 10\n      # 连接池中最大活动连接数，限制并发请求时的数据库连接数，避免过多的连接消耗系统资源。\n      max-active: 1000\n      # 获取连接时的最大等待时间，超过该时间则抛出异常。单位通常为毫秒。\n      max-wait: 60000\n      # 两个连接检查之间的时间间隔，用于检测和清理空闲过久的连接。单位为毫秒。\n      time-between-eviction-runs-millis: 60000\n      # 连接在被清理前的最小空闲时间。单位为毫秒。\n      min-evictable-idle-time-millis: 300000\n      # 用于验证连接有效性的 SQL 查询语句。\n      validation-query: SELECT 1 \n      # 如果为真，则连接空闲时会被定期测试有效性。\n      test-while-idle: true\n      # 如果为真，在获取连接前进行有效性测试。\n      test-on-borrow: false\n      # 如果为真，在归还连接时进行有效性测试。\n      test-on-return: false\n      # 是否开启 PreparedStatement 缓存。\n      pool-prepared-statements: true\n      # 单个连接上缓存的 PreparedStatement 最大数量。\n      max-pool-prepared-statement-per-connection-size: 20\n      # 指定要启用的过滤器，如 stat, log4j, wall 等，用于监控和日志记录。\n      filters: stat,wall,log4j\n      # 连接属性，例如配置日志级别或慢 SQL 阈值。\n      connection-properties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000\n      # 是否自动回收超时连接\n      remove-abandoned: true\n      # 超时时间，单位秒\n      remove-abandoned-timeout: 1800\n      # 是否记录被遗弃的连接\n      log-abandoned: true\n      # StatViewServlet配置，访问监控页面\n      stat-view-servlet:\n        enabled: true\n        url-pattern: /druid/*\n        login-username: admin\n        login-password: [REDACTED]        reset-enable: false\n      # 防火墙配置\n      wall:\n        config:\n          multi-statement-allow: false\n\nmybatis-plus:\n  # 此处在多数据源中生效\n  config-location: classpath:/mybatis-config.xml\n  global-config:\n    banner: false\n    db-config:\n      logic-not-delete-value: 0\n      logic-delete-value: 1\n  type-aliases-package: com.ruoyi.other\n  # 指定Mapper文件位置\n  mapper-locations: classpath*:/mapper/**/*.xml\nwx:\n  grantType: authorization_code \n  appid: wx049faf9c5234f31c \n  appSecret: [REDACTED]\n  appletsAppid: #小程序APPid\n  appletsAppSecret: #\n  mchId: 1717539630 \n  key: [REDACTED] \n  callbackPath: http://47.120.5.122:8080\n  certPath: classpath:cert/apiclient_cert.p12\n', '58f02a7f12a1f7254066e5204cca2ea2', '2025-06-30 18:42:59', '2025-06-30 05:43:00', NULL, '221.182.45.100', 'I', '508d0707-50dd-48b0-ad27-349e7bb3c9eb', NULL);
INSERT INTO `his_config_info` VALUES (0, 5, '.metadata', 'DEFAULT_GROUP', '', 'metadata:\r\n- appName: \'\'\r\n  dataId: application-dev.yml\r\n  desc: \'\'\r\n  group: DEFAULT_GROUP\r\n  type: yaml\r\n- appName: \'\'\r\n  dataId: ruoyi-gateway-dev.yml\r\n  desc: \'\'\r\n  group: DEFAULT_GROUP\r\n  type: yaml\r\n- appName: \'\'\r\n  dataId: ruoyi-auth-dev.yml\r\n  desc: \'\'\r\n  group: DEFAULT_GROUP\r\n  type: yaml\r\n- appName: \'\'\r\n  dataId: ruoyi-system-dev.yml\r\n  desc: \'\'\r\n  group: DEFAULT_GROUP\r\n  type: yaml\r\n- appName: \'\'\r\n  dataId: ruoyi-gen-dev.yml\r\n  desc: \'\'\r\n  group: DEFAULT_GROUP\r\n  type: yaml\r\n- appName: \'\'\r\n  dataId: ruoyi-job-dev.yml\r\n  group: DEFAULT_GROUP\r\n  type: yaml\r\n- appName: \'\'\r\n  dataId: ruoyi-file-dev.yml\r\n  group: DEFAULT_GROUP\r\n  type: yaml\r\n- appName: \'\'\r\n  dataId: sentinel-ruoyi-gateway\r\n  group: DEFAULT_GROUP\r\n  type: text\r\n- appName: \'\'\r\n  dataId: ruoyi-account.yml\r\n  desc: 账户服务\r\n  group: DEFAULT_GROUP\r\n  type: yaml\r\n- appName: \'\'\r\n  dataId: ruoyi-order.yml\r\n  desc: 订单服务\r\n  group: DEFAULT_GROUP\r\n  type: yaml\r\n- appName: \'\'\r\n  dataId: ruoyi-other.yml\r\n  desc: 系统基础服务\r\n  group: DEFAULT_GROUP\r\n  type: yaml\r\n- appName: \'\'\r\n  dataId: seata-server.properties\r\n  desc: \'\'\r\n  group: DEFAULT_GROUP\r\n  type: properties\r\n', '325cafb4cf54976cf8aecfa9f2805ac4', '2025-06-30 18:42:59', '2025-06-30 05:43:00', NULL, '221.182.45.100', 'I', '508d0707-50dd-48b0-ad27-349e7bb3c9eb', NULL);
INSERT INTO `his_config_info` VALUES (0, 6, 'application-prod.yml', 'DEFAULT_GROUP', '', 'spring:\r\n#maxFileSize 单个数据大小\r\n  servlet:\r\n    multipart: \r\n      max-file-size: 50MB\r\n#maxRequestSize 是总数据大小\r\n      max-request-size: 100MB\r\n  autoconfigure:\r\n    exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure\r\n  mvc:\r\n    pathmatch:\r\n      matching-strategy: ant_path_matcher\r\n\r\n# feign 配置\r\nfeign:\r\n  sentinel:\r\n    enabled: true\r\n  okhttp:\r\n    enabled: true\r\n  httpclient:\r\n    enabled: false\r\n  client:\r\n    config:\r\n      default:\r\n        connectTimeout: 10000\r\n        readTimeout: 10000\r\n  compression:\r\n    request:\r\n      enabled: false\r\n    response:\r\n      enabled: false\r\n\r\n# 暴露监控端点\r\nmanagement:\r\n  endpoints:\r\n    web:\r\n      exposure:\r\n        include: \'*\'\r\n\r\n\r\nsecurity:\r\n  # 不校验白名单\r\n  ignore:\r\n    whites:\r\n      - /logout\r\n      - /login\r\n      - /register\r\n      - /*/v2/api-docs\r\n      - /csrf\r\n      - /account/app-user/appletLogin\r\n      - /account/app-user/mobileLogin\r\n      - /account/app-user/getSMSCode\r\n      - /account/app-user/registerAccount\r\n      - /account/app-user/getReferrer\r\n      - /account/app-user/getNearbyReferrer\r\n\r\n# 文件上传地址\r\nfile: \r\n  upload: \r\n    accessPath: http://47.120.5.122:8080/\r\n    location: D:/Program Files/nginx-1.20.2/html/\r\n    allowExt: png,jpeg,jpg,pdf,doc,docx', 'da086b5082b6e2cdec6198ec09955398', '2025-06-30 18:42:59', '2025-06-30 05:43:00', NULL, '221.182.45.100', 'I', '508d0707-50dd-48b0-ad27-349e7bb3c9eb', NULL);
INSERT INTO `his_config_info` VALUES (0, 7, 'ruoyi-gateway-prod.yml', 'DEFAULT_GROUP', '', 'server:\n  port: 8080\n  tomcat:\n    max-swallow-size: 10MB\nspring:\n#maxFileSize 单个数据大小\n  servlet:\n    multipart: \n      max-file-size: 50MB\n#maxRequestSize 是总数据大小\n      max-request-size: 100MB\n  redis:\n    host: 47.120.5.122\n    port: 6379\n    password: [REDACTED]  cloud:\n    gateway:\n      discovery:\n        locator:\n          lowerCaseServiceId: true\n          enabled: true\n      routes:\n        # 认证中心\n        - id: ruoyi-auth\n          uri: lb://ruoyi-auth\n          predicates:\n            - Path=/auth/**\n          filters:\n            # 验证码处理\n            - CacheRequestFilter\n            - ValidateCodeFilter\n            - StripPrefix=1\n        # 系统模块\n        - id: ruoyi-system\n          uri: lb://ruoyi-system\n          predicates:\n            - Path=/system/**\n          filters:\n            - StripPrefix=1\n        # 文件服务\n        - id: ruoyi-file\n          uri: lb://ruoyi-file\n          predicates:\n            - Path=/file/**\n          filters:\n            - StripPrefix=1\n        # 账户服务\n        - id: ruoyi-account\n          uri: lb://ruoyi-account\n          predicates:\n            - Path=/account/**\n          filters:\n            - StripPrefix=1\n        # 订单服务\n        - id: ruoyi-order\n          uri: lb://ruoyi-order\n          predicates:\n            - Path=/order/**\n          filters:\n            - StripPrefix=1\n        # 系统配置服务\n        - id: ruoyi-other\n          uri: lb://ruoyi-other\n          predicates:\n            - Path=/other/**\n          filters:\n            - StripPrefix=1\n\n# 安全配置\nsecurity:\n  # 验证码\n  captcha:\n    enabled: false\n    type: math\n  # 防止XSS攻击\n  xss:\n    enabled: true\n    excludeUrls:\n      - /other/goods/manageGoodsUpdate\n      - /other/goods/addGoods\n      - /other/vip-setting/manage/set\n      - /other/agreement/saveAgreement\n      - /other/system-config/index/add\n      - /other/share/manage/add\n      - /other/share/manage/edit\n      - /other/shop/addGoods\n      - /other/shop/editGoods\n      - /other/goods/manageGoodsUpdate\n      - /order/order/orderPaymentCallback\n      - /order/order/refundPayMoneyCallback\n      - /order/order/getRsaPublicKey\n\n  # 不校验白名单\n  ignore:\n    whites:\n      - /auth/logout\n      - /auth/login\n      - /auth/loginShop\n      - /auth/register\n      - /*/v2/api-docs\n      - /csrf\n      - /account/app-user/appletLogin\n      - /account/app-user/mobileLogin\n      - /account/app-user/getSMSCode\n      - /account/app-user/registerAccount\n      - /account/app-user/getReferrer\n      - /account/app-user/getNearbyReferrer\n      - /account/wallet/rechargeCallback\n      - /other/system-config/index/start\n      - /other/system-config/index/detail\n      - /other/goods-category/index/list\n      - /other/goods/goodsList\n      - /other/goods/goodsDetail/*\n      - /other/goods/getGoodsListByShopId\n      - /other/banner/list\n      - /other/shop/shopDetail\n      - /other/shop/nearbyShopList\n      - /other/share/detail/*\n      - /other/seckill-activity-info/vipId/*\n      - /account/app-user/upload\n      - /other/agreement/getAgreement/*\n      - /system/user/profile/updatePwd\n      - /other/goods-evaluate/goodsList\n      - /order/order/refundPayMoneyCallback\n      - /order/order/refundExpressPayMoneyCallback\n      - /order/shopping-cart/shoppingCartPaymentCallback\n      - /order/shopping-cart/shoppingCartMaterialFlowPaymentCallback\n      - /account/withdrawal-requests/withdrawalCallback\n      - /other/shop-withdraw/withdrawalCallback\n      - /order/order/importExpress\n      - /order/order/orderPaymentCallback\n      - /order/order/refundPayMoneyCallback\n      - /order/order/getRsaPublicKey\n      - /account/app-user/download/**\n      - /order/charge/importExpress\n              \n  # 参数签名校验\n  sign: \n    enable: false\n  # 防抖校验\n  anti-shake: \n    enable: true\n    interval: 500', '0817566193c521e230bda8271a9b338a', '2025-06-30 18:42:59', '2025-06-30 05:43:00', NULL, '221.182.45.100', 'I', '508d0707-50dd-48b0-ad27-349e7bb3c9eb', NULL);
INSERT INTO `his_config_info` VALUES (0, 8, 'ruoyi-auth-prod.yml', 'DEFAULT_GROUP', '', 'server:\r\n  port: 9100\r\nspring:\r\n  redis:\r\n    host: 47.120.5.122\r\n    port: 6379\r\n    password: [REDACTED]  datasource:\r\n    type: com.alibaba.druid.pool.DruidDataSource\r\n    driver-class-name: com.mysql.cj.jdbc.Driver\r\n    url: jdbc:mysql://47.120.5.122:3306/gy_jifenshangcheng_system?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\r\n    username: root\r\n    password: [REDACTED]    druid:\r\n      # 连接池初始化时创建的连接数。\r\n      # 应根据实际应用场景设置，确保应用程序启动时即可获取数据库连接。\r\n      initial-size: 10\r\n      # 连接池中最小的空闲连接数，保证即使在低负载时也有足够的连接可用。\r\n      min-idle: 10\r\n      # 连接池中最大活动连接数，限制并发请求时的数据库连接数，避免过多的连接消耗系统资源。\r\n      max-active: 1000\r\n      # 获取连接时的最大等待时间，超过该时间则抛出异常。单位通常为毫秒。\r\n      max-wait: 60000\r\n      # 两个连接检查之间的时间间隔，用于检测和清理空闲过久的连接。单位为毫秒。\r\n      time-between-eviction-runs-millis: 60000\r\n      # 连接在被清理前的最小空闲时间。单位为毫秒。\r\n      min-evictable-idle-time-millis: 300000\r\n      # 用于验证连接有效性的 SQL 查询语句。\r\n      validation-query: SELECT 1 \r\n      # 如果为真，则连接空闲时会被定期测试有效性。\r\n      test-while-idle: true\r\n      # 如果为真，在获取连接前进行有效性测试。\r\n      test-on-borrow: false\r\n      # 如果为真，在归还连接时进行有效性测试。\r\n      test-on-return: false\r\n      # 是否开启 PreparedStatement 缓存。\r\n      pool-prepared-statements: true\r\n      # 单个连接上缓存的 PreparedStatement 最大数量。\r\n      max-pool-prepared-statement-per-connection-size: 20\r\n      # 指定要启用的过滤器，如 stat, log4j, wall 等，用于监控和日志记录。\r\n      filters: stat,wall,log4j\r\n      # 连接属性，例如配置日志级别或慢 SQL 阈值。\r\n      connection-properties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000\r\n      # 是否自动回收超时连接\r\n      remove-abandoned: true\r\n      # 超时时间，单位秒\r\n      remove-abandoned-timeout: 1800\r\n      # 是否记录被遗弃的连接\r\n      log-abandoned: true\r\n      # StatViewServlet配置，访问监控页面\r\n      stat-view-servlet:\r\n        enabled: true\r\n        url-pattern: /druid/*\r\n        login-username: admin\r\n        login-password: [REDACTED]        reset-enable: false\r\n      # 防火墙配置\r\n      wall:\r\n        config:\r\n          multi-statement-allow: false\r\n', 'd75502a5b174c97ad2d3098dc7f78a98', '2025-06-30 18:42:59', '2025-06-30 05:43:00', NULL, '221.182.45.100', 'I', '508d0707-50dd-48b0-ad27-349e7bb3c9eb', NULL);
INSERT INTO `his_config_info` VALUES (0, 9, 'ruoyi-system-prod.yml', 'DEFAULT_GROUP', '', 'server:\r\n  port: 9800\r\n# spring配置\r\nspring:\r\n  redis:\r\n    host: 47.120.5.122\r\n    port: 6379\r\n    password: [REDACTED]  datasource: \r\n    type: com.alibaba.druid.pool.DruidDataSource\r\n    driver-class-name: com.mysql.cj.jdbc.Driver\r\n    url: jdbc:mysql://47.120.5.122:3306/gy_jifenshangcheng_system?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\r\n    username: root\r\n    password: [REDACTED]    druid:\r\n      # 连接池初始化时创建的连接数。\r\n      # 应根据实际应用场景设置，确保应用程序启动时即可获取数据库连接。\r\n      initial-size: 10\r\n      # 连接池中最小的空闲连接数，保证即使在低负载时也有足够的连接可用。\r\n      min-idle: 10\r\n      # 连接池中最大活动连接数，限制并发请求时的数据库连接数，避免过多的连接消耗系统资源。\r\n      max-active: 1000\r\n      # 获取连接时的最大等待时间，超过该时间则抛出异常。单位通常为毫秒。\r\n      max-wait: 60000\r\n      # 两个连接检查之间的时间间隔，用于检测和清理空闲过久的连接。单位为毫秒。\r\n      time-between-eviction-runs-millis: 60000\r\n      # 连接在被清理前的最小空闲时间。单位为毫秒。\r\n      min-evictable-idle-time-millis: 300000\r\n      # 用于验证连接有效性的 SQL 查询语句。\r\n      validation-query: SELECT 1 \r\n      # 如果为真，则连接空闲时会被定期测试有效性。\r\n      test-while-idle: true\r\n      # 如果为真，在获取连接前进行有效性测试。\r\n      test-on-borrow: false\r\n      # 如果为真，在归还连接时进行有效性测试。\r\n      test-on-return: false\r\n      # 是否开启 PreparedStatement 缓存。\r\n      pool-prepared-statements: true\r\n      # 单个连接上缓存的 PreparedStatement 最大数量。\r\n      max-pool-prepared-statement-per-connection-size: 20\r\n      # 指定要启用的过滤器，如 stat, log4j, wall 等，用于监控和日志记录。\r\n      filters: stat,wall,log4j\r\n      # 连接属性，例如配置日志级别或慢 SQL 阈值。\r\n      connection-properties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000\r\n      # 是否自动回收超时连接\r\n      remove-abandoned: true\r\n      # 超时时间，单位秒\r\n      remove-abandoned-timeout: 1800\r\n      # 是否记录被遗弃的连接\r\n      log-abandoned: true\r\n      # StatViewServlet配置，访问监控页面\r\n      stat-view-servlet:\r\n        enabled: true\r\n        url-pattern: /druid/*\r\n        login-username: admin\r\n        login-password: [REDACTED]        reset-enable: false\r\n      # 防火墙配置\r\n      wall:\r\n        config:\r\n          multi-statement-allow: false\r\n    \r\n\r\n# mybatis配置\r\n# mybatis:\r\n#     # 搜索指定包别名\r\n#   typeAliasesPackage: com.ruoyi.system,com.ruoyi.system.api\r\n#     # 配置mapper的扫描，找到所有的mapper.xml映射文件\r\n#   mapperLocations: classpath:mapper/**/*.xml\r\nmybatis-plus:\r\n  # 此处在多数据源中生效\r\n  config-location: classpath:/mybatis-config.xml\r\n  global-config:\r\n    banner: false\r\n    db-config:\r\n      logic-not-delete-value: 0\r\n      logic-delete-value: 1\r\n  type-aliases-package: com.ruoyi.system\r\n  # 指定Mapper文件位置\r\n  mapper-locations: classpath*:/mapping/**/*.xml\r\n\r\n# swagger配置\r\nswagger:\r\n  title: 系统模块接口文档\r\n  enabled: true\r\n  license: Powered By ruoyi\r\n  licenseUrl: http://47.120.5.122:9800/doc.html', '5c55ed0dced8adf3e8e59fabb6fc409e', '2025-06-30 18:42:59', '2025-06-30 05:43:00', NULL, '221.182.45.100', 'I', '508d0707-50dd-48b0-ad27-349e7bb3c9eb', NULL);
INSERT INTO `his_config_info` VALUES (2, 10, 'ruoyi-account.yml', 'DEFAULT_GROUP', '', 'server:\n  port: 9200\nspring:\n  redis:\n    host: 47.120.5.122\n    port: 6379\n    password: [REDACTED]  datasource:\n    type: com.alibaba.druid.pool.DruidDataSource\n    driver-class-name: com.mysql.cj.jdbc.Driver\n    url: jdbc:mysql://47.120.5.122:3306/gy_jifenshangcheng_account?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n    username: root\n    password: [REDACTED]    druid:\n      # 连接池初始化时创建的连接数。\n      # 应根据实际应用场景设置，确保应用程序启动时即可获取数据库连接。\n      initial-size: 10\n      # 连接池中最小的空闲连接数，保证即使在低负载时也有足够的连接可用。\n      min-idle: 10\n      # 连接池中最大活动连接数，限制并发请求时的数据库连接数，避免过多的连接消耗系统资源。\n      max-active: 1000\n      # 获取连接时的最大等待时间，超过该时间则抛出异常。单位通常为毫秒。\n      max-wait: 60000\n      # 两个连接检查之间的时间间隔，用于检测和清理空闲过久的连接。单位为毫秒。\n      time-between-eviction-runs-millis: 60000\n      # 连接在被清理前的最小空闲时间。单位为毫秒。\n      min-evictable-idle-time-millis: 300000\n      # 用于验证连接有效性的 SQL 查询语句。\n      validation-query: SELECT 1 \n      # 如果为真，则连接空闲时会被定期测试有效性。\n      test-while-idle: true\n      # 如果为真，在获取连接前进行有效性测试。\n      test-on-borrow: false\n      # 如果为真，在归还连接时进行有效性测试。\n      test-on-return: false\n      # 是否开启 PreparedStatement 缓存。\n      pool-prepared-statements: true\n      # 单个连接上缓存的 PreparedStatement 最大数量。\n      max-pool-prepared-statement-per-connection-size: 20\n      # 指定要启用的过滤器，如 stat, log4j, wall 等，用于监控和日志记录。\n      filters: stat,wall,log4j\n      # 连接属性，例如配置日志级别或慢 SQL 阈值。\n      connection-properties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000\n      # 是否自动回收超时连接\n      remove-abandoned: true\n      # 超时时间，单位秒\n      remove-abandoned-timeout: 1800\n      # 是否记录被遗弃的连接\n      log-abandoned: true\n      # StatViewServlet配置，访问监控页面\n      stat-view-servlet:\n        enabled: true\n        url-pattern: /druid/*\n        login-username: admin\n        login-password: [REDACTED]        reset-enable: false\n      # 防火墙配置\n      wall:\n        config:\n          multi-statement-allow: false\nwx: \n  appletsAppid: wx049faf9c5234f31c\n  appletsAppSecret: [REDACTED]\n\n\nali:\n  conf: \n    appId: 2021004173610331\n    privateKey: [REDACTED]==\n    alipayPublicKey: [REDACTED]\n', '1b48dc4d37bf29bf401f9d05d9ca551a', '2025-06-30 18:46:28', '2025-06-30 05:46:29', 'nacos', '221.182.45.100', 'U', '508d0707-50dd-48b0-ad27-349e7bb3c9eb', NULL);
INSERT INTO `his_config_info` VALUES (8, 11, 'ruoyi-auth-prod.yml', 'DEFAULT_GROUP', '', 'server:\r\n  port: 9100\r\nspring:\r\n  redis:\r\n    host: 47.120.5.122\r\n    port: 6379\r\n    password: [REDACTED]  datasource:\r\n    type: com.alibaba.druid.pool.DruidDataSource\r\n    driver-class-name: com.mysql.cj.jdbc.Driver\r\n    url: jdbc:mysql://47.120.5.122:3306/gy_jifenshangcheng_system?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\r\n    username: root\r\n    password: [REDACTED]    druid:\r\n      # 连接池初始化时创建的连接数。\r\n      # 应根据实际应用场景设置，确保应用程序启动时即可获取数据库连接。\r\n      initial-size: 10\r\n      # 连接池中最小的空闲连接数，保证即使在低负载时也有足够的连接可用。\r\n      min-idle: 10\r\n      # 连接池中最大活动连接数，限制并发请求时的数据库连接数，避免过多的连接消耗系统资源。\r\n      max-active: 1000\r\n      # 获取连接时的最大等待时间，超过该时间则抛出异常。单位通常为毫秒。\r\n      max-wait: 60000\r\n      # 两个连接检查之间的时间间隔，用于检测和清理空闲过久的连接。单位为毫秒。\r\n      time-between-eviction-runs-millis: 60000\r\n      # 连接在被清理前的最小空闲时间。单位为毫秒。\r\n      min-evictable-idle-time-millis: 300000\r\n      # 用于验证连接有效性的 SQL 查询语句。\r\n      validation-query: SELECT 1 \r\n      # 如果为真，则连接空闲时会被定期测试有效性。\r\n      test-while-idle: true\r\n      # 如果为真，在获取连接前进行有效性测试。\r\n      test-on-borrow: false\r\n      # 如果为真，在归还连接时进行有效性测试。\r\n      test-on-return: false\r\n      # 是否开启 PreparedStatement 缓存。\r\n      pool-prepared-statements: true\r\n      # 单个连接上缓存的 PreparedStatement 最大数量。\r\n      max-pool-prepared-statement-per-connection-size: 20\r\n      # 指定要启用的过滤器，如 stat, log4j, wall 等，用于监控和日志记录。\r\n      filters: stat,wall,log4j\r\n      # 连接属性，例如配置日志级别或慢 SQL 阈值。\r\n      connection-properties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000\r\n      # 是否自动回收超时连接\r\n      remove-abandoned: true\r\n      # 超时时间，单位秒\r\n      remove-abandoned-timeout: 1800\r\n      # 是否记录被遗弃的连接\r\n      log-abandoned: true\r\n      # StatViewServlet配置，访问监控页面\r\n      stat-view-servlet:\r\n        enabled: true\r\n        url-pattern: /druid/*\r\n        login-username: admin\r\n        login-password: [REDACTED]        reset-enable: false\r\n      # 防火墙配置\r\n      wall:\r\n        config:\r\n          multi-statement-allow: false\r\n', 'd75502a5b174c97ad2d3098dc7f78a98', '2025-06-30 18:48:31', '2025-06-30 05:48:32', 'nacos', '221.182.45.100', 'U', '508d0707-50dd-48b0-ad27-349e7bb3c9eb', NULL);
INSERT INTO `his_config_info` VALUES (9, 12, 'ruoyi-system-prod.yml', 'DEFAULT_GROUP', '', 'server:\r\n  port: 9800\r\n# spring配置\r\nspring:\r\n  redis:\r\n    host: 47.120.5.122\r\n    port: 6379\r\n    password: [REDACTED]  datasource: \r\n    type: com.alibaba.druid.pool.DruidDataSource\r\n    driver-class-name: com.mysql.cj.jdbc.Driver\r\n    url: jdbc:mysql://47.120.5.122:3306/gy_jifenshangcheng_system?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\r\n    username: root\r\n    password: [REDACTED]    druid:\r\n      # 连接池初始化时创建的连接数。\r\n      # 应根据实际应用场景设置，确保应用程序启动时即可获取数据库连接。\r\n      initial-size: 10\r\n      # 连接池中最小的空闲连接数，保证即使在低负载时也有足够的连接可用。\r\n      min-idle: 10\r\n      # 连接池中最大活动连接数，限制并发请求时的数据库连接数，避免过多的连接消耗系统资源。\r\n      max-active: 1000\r\n      # 获取连接时的最大等待时间，超过该时间则抛出异常。单位通常为毫秒。\r\n      max-wait: 60000\r\n      # 两个连接检查之间的时间间隔，用于检测和清理空闲过久的连接。单位为毫秒。\r\n      time-between-eviction-runs-millis: 60000\r\n      # 连接在被清理前的最小空闲时间。单位为毫秒。\r\n      min-evictable-idle-time-millis: 300000\r\n      # 用于验证连接有效性的 SQL 查询语句。\r\n      validation-query: SELECT 1 \r\n      # 如果为真，则连接空闲时会被定期测试有效性。\r\n      test-while-idle: true\r\n      # 如果为真，在获取连接前进行有效性测试。\r\n      test-on-borrow: false\r\n      # 如果为真，在归还连接时进行有效性测试。\r\n      test-on-return: false\r\n      # 是否开启 PreparedStatement 缓存。\r\n      pool-prepared-statements: true\r\n      # 单个连接上缓存的 PreparedStatement 最大数量。\r\n      max-pool-prepared-statement-per-connection-size: 20\r\n      # 指定要启用的过滤器，如 stat, log4j, wall 等，用于监控和日志记录。\r\n      filters: stat,wall,log4j\r\n      # 连接属性，例如配置日志级别或慢 SQL 阈值。\r\n      connection-properties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000\r\n      # 是否自动回收超时连接\r\n      remove-abandoned: true\r\n      # 超时时间，单位秒\r\n      remove-abandoned-timeout: 1800\r\n      # 是否记录被遗弃的连接\r\n      log-abandoned: true\r\n      # StatViewServlet配置，访问监控页面\r\n      stat-view-servlet:\r\n        enabled: true\r\n        url-pattern: /druid/*\r\n        login-username: admin\r\n        login-password: [REDACTED]        reset-enable: false\r\n      # 防火墙配置\r\n      wall:\r\n        config:\r\n          multi-statement-allow: false\r\n    \r\n\r\n# mybatis配置\r\n# mybatis:\r\n#     # 搜索指定包别名\r\n#   typeAliasesPackage: com.ruoyi.system,com.ruoyi.system.api\r\n#     # 配置mapper的扫描，找到所有的mapper.xml映射文件\r\n#   mapperLocations: classpath:mapper/**/*.xml\r\nmybatis-plus:\r\n  # 此处在多数据源中生效\r\n  config-location: classpath:/mybatis-config.xml\r\n  global-config:\r\n    banner: false\r\n    db-config:\r\n      logic-not-delete-value: 0\r\n      logic-delete-value: 1\r\n  type-aliases-package: com.ruoyi.system\r\n  # 指定Mapper文件位置\r\n  mapper-locations: classpath*:/mapping/**/*.xml\r\n\r\n# swagger配置\r\nswagger:\r\n  title: 系统模块接口文档\r\n  enabled: true\r\n  license: Powered By ruoyi\r\n  licenseUrl: http://47.120.5.122:9800/doc.html', '5c55ed0dced8adf3e8e59fabb6fc409e', '2025-06-30 19:06:06', '2025-06-30 06:06:06', 'nacos', '221.182.45.100', 'U', '508d0707-50dd-48b0-ad27-349e7bb3c9eb', NULL);
INSERT INTO `his_config_info` VALUES (3, 13, 'ruoyi-order.yml', 'DEFAULT_GROUP', '', 'server:\n  port: 9400\nspring:\n  redis:\n    host: 47.120.5.122\n    port: 6379\n    password: [REDACTED]  datasource:\n    type: com.alibaba.druid.pool.DruidDataSource\n    driver-class-name: com.mysql.cj.jdbc.Driver\n    url: jdbc:mysql://47.120.5.122:3306/gy_jifenshangcheng_order?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n    username: root\n    password: [REDACTED]    druid:\n      # 连接池初始化时创建的连接数。\n      # 应根据实际应用场景设置，确保应用程序启动时即可获取数据库连接。\n      initial-size: 10\n      # 连接池中最小的空闲连接数，保证即使在低负载时也有足够的连接可用。\n      min-idle: 10\n      # 连接池中最大活动连接数，限制并发请求时的数据库连接数，避免过多的连接消耗系统资源。\n      max-active: 1000\n      # 获取连接时的最大等待时间，超过该时间则抛出异常。单位通常为毫秒。\n      max-wait: 60000\n      # 两个连接检查之间的时间间隔，用于检测和清理空闲过久的连接。单位为毫秒。\n      time-between-eviction-runs-millis: 60000\n      # 连接在被清理前的最小空闲时间。单位为毫秒。\n      min-evictable-idle-time-millis: 300000\n      # 用于验证连接有效性的 SQL 查询语句。\n      validation-query: SELECT 1 \n      # 如果为真，则连接空闲时会被定期测试有效性。\n      test-while-idle: true\n      # 如果为真，在获取连接前进行有效性测试。\n      test-on-borrow: false\n      # 如果为真，在归还连接时进行有效性测试。\n      test-on-return: false\n      # 是否开启 PreparedStatement 缓存。\n      pool-prepared-statements: true\n      # 单个连接上缓存的 PreparedStatement 最大数量。\n      max-pool-prepared-statement-per-connection-size: 20\n      # 指定要启用的过滤器，如 stat, log4j, wall 等，用于监控和日志记录。\n      filters: stat,wall,log4j\n      # 连接属性，例如配置日志级别或慢 SQL 阈值。\n      connection-properties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000\n      # 是否自动回收超时连接\n      remove-abandoned: true\n      # 超时时间，单位秒\n      remove-abandoned-timeout: 1800\n      # 是否记录被遗弃的连接\n      log-abandoned: true\n      # StatViewServlet配置，访问监控页面\n      stat-view-servlet:\n        enabled: true\n        url-pattern: /druid/*\n        login-username: admin\n        login-password: [REDACTED]        reset-enable: false\n      # 防火墙配置\n      wall:\n        config:\n          multi-statement-allow: false\nwx:\n  grantType: authorization_code \n  appid: wx049faf9c5234f31c \n  appSecret: [REDACTED]\n  appletsAppid: #小程序APPid\n  appletsAppSecret: #\n  mchId: 1717539630 \n  key: [REDACTED] \n  callbackPath: http://47.120.5.122:8080\n  certPath: classpath:cert/apiclient_cert.p12\n  RASPath: E:cert/wechat_rsa_public_key.pem\nalipay:\n  appid: \n  appPrivateKey:\n  alipayPublicKey:\n  alipay_public_key:\n', 'ab8f23aa57cf2620efefdb7017018597', '2025-06-30 19:09:46', '2025-06-30 06:09:46', 'nacos', '221.182.45.100', 'U', '508d0707-50dd-48b0-ad27-349e7bb3c9eb', NULL);
INSERT INTO `his_config_info` VALUES (4, 14, 'ruoyi-other.yml', 'DEFAULT_GROUP', '', 'server:\n  port: 9600\nspring:\n  redis:\n    host: 47.120.5.122\n    port: 6379\n    password: [REDACTED]  datasource:\n    type: com.alibaba.druid.pool.DruidDataSource\n    driver-class-name: com.mysql.cj.jdbc.Driver\n    url: jdbc:mysql://47.120.5.122:3306/gy_jifenshangcheng_other?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n    username: root\n    password: [REDACTED]    druid:\n      # 连接池初始化时创建的连接数。\n      # 应根据实际应用场景设置，确保应用程序启动时即可获取数据库连接。\n      initial-size: 10\n      # 连接池中最小的空闲连接数，保证即使在低负载时也有足够的连接可用。\n      min-idle: 10\n      # 连接池中最大活动连接数，限制并发请求时的数据库连接数，避免过多的连接消耗系统资源。\n      max-active: 1000\n      # 获取连接时的最大等待时间，超过该时间则抛出异常。单位通常为毫秒。\n      max-wait: 60000\n      # 两个连接检查之间的时间间隔，用于检测和清理空闲过久的连接。单位为毫秒。\n      time-between-eviction-runs-millis: 60000\n      # 连接在被清理前的最小空闲时间。单位为毫秒。\n      min-evictable-idle-time-millis: 300000\n      # 用于验证连接有效性的 SQL 查询语句。\n      validation-query: SELECT 1 \n      # 如果为真，则连接空闲时会被定期测试有效性。\n      test-while-idle: true\n      # 如果为真，在获取连接前进行有效性测试。\n      test-on-borrow: false\n      # 如果为真，在归还连接时进行有效性测试。\n      test-on-return: false\n      # 是否开启 PreparedStatement 缓存。\n      pool-prepared-statements: true\n      # 单个连接上缓存的 PreparedStatement 最大数量。\n      max-pool-prepared-statement-per-connection-size: 20\n      # 指定要启用的过滤器，如 stat, log4j, wall 等，用于监控和日志记录。\n      filters: stat,wall,log4j\n      # 连接属性，例如配置日志级别或慢 SQL 阈值。\n      connection-properties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000\n      # 是否自动回收超时连接\n      remove-abandoned: true\n      # 超时时间，单位秒\n      remove-abandoned-timeout: 1800\n      # 是否记录被遗弃的连接\n      log-abandoned: true\n      # StatViewServlet配置，访问监控页面\n      stat-view-servlet:\n        enabled: true\n        url-pattern: /druid/*\n        login-username: admin\n        login-password: [REDACTED]        reset-enable: false\n      # 防火墙配置\n      wall:\n        config:\n          multi-statement-allow: false\n\nmybatis-plus:\n  # 此处在多数据源中生效\n  config-location: classpath:/mybatis-config.xml\n  global-config:\n    banner: false\n    db-config:\n      logic-not-delete-value: 0\n      logic-delete-value: 1\n  type-aliases-package: com.ruoyi.other\n  # 指定Mapper文件位置\n  mapper-locations: classpath*:/mapper/**/*.xml\nwx:\n  grantType: authorization_code \n  appid: wx049faf9c5234f31c \n  appSecret: [REDACTED]\n  appletsAppid: #小程序APPid\n  appletsAppSecret: #\n  mchId: 1717539630 \n  key: [REDACTED] \n  callbackPath: http://47.120.5.122:8080\n  certPath: classpath:cert/apiclient_cert.p12\n', '58f02a7f12a1f7254066e5204cca2ea2', '2025-06-30 19:10:14', '2025-06-30 06:10:14', 'nacos', '221.182.45.100', 'U', '508d0707-50dd-48b0-ad27-349e7bb3c9eb', NULL);

-- ----------------------------
-- Table structure for permissions
-- ----------------------------
DROP TABLE IF EXISTS `permissions`;
CREATE TABLE `permissions`  (
  `role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `resource` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `action` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  UNIQUE INDEX `uk_role_permission`(`role` ASC, `resource` ASC, `action` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of permissions
-- ----------------------------

-- ----------------------------
-- Table structure for roles
-- ----------------------------
DROP TABLE IF EXISTS `roles`;
CREATE TABLE `roles`  (
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  UNIQUE INDEX `idx_user_role`(`username` ASC, `role` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of roles
-- ----------------------------
INSERT INTO `roles` VALUES ('nacos', 'ROLE_ADMIN');

-- ----------------------------
-- Table structure for tenant_capacity
-- ----------------------------
DROP TABLE IF EXISTS `tenant_capacity`;
CREATE TABLE `tenant_capacity`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'Tenant ID',
  `quota` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '配额，0表示使用默认值',
  `usage` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '使用量',
  `max_size` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '单个配置大小上限，单位为字节，0表示使用默认值',
  `max_aggr_count` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '聚合子配置最大个数',
  `max_aggr_size` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '单个聚合数据的子配置大小上限，单位为字节，0表示使用默认值',
  `max_history_count` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '最大变更历史数量',
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uk_tenant_id`(`tenant_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '租户容量信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tenant_capacity
-- ----------------------------

-- ----------------------------
-- Table structure for tenant_info
-- ----------------------------
DROP TABLE IF EXISTS `tenant_info`;
CREATE TABLE `tenant_info`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `kp` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'kp',
  `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT 'tenant_id',
  `tenant_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT 'tenant_name',
  `tenant_desc` varchar(256) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'tenant_desc',
  `create_source` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'create_source',
  `gmt_create` bigint NOT NULL COMMENT '创建时间',
  `gmt_modified` bigint NOT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uk_tenant_info_kptenantid`(`kp` ASC, `tenant_id` ASC) USING BTREE,
  INDEX `idx_tenant_id`(`tenant_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'tenant_info' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tenant_info
-- ----------------------------
INSERT INTO `tenant_info` VALUES (1, '1', '508d0707-50dd-48b0-ad27-349e7bb3c9eb', '绿电线上', '线上', 'nacos', 1751280157927, 1751280157927);

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`  (
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `password` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  PRIMARY KEY (`username`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES ('nacos', '$2a$10$EuWPZHzz32dJN7jexM34MOeYirDdFAZm2kuWj7VEOJhhZkDrxfvUu', 1);

SET FOREIGN_KEY_CHECKS = 1;
