/*
|
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: 123456\n 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: Lv12321@\n 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: admin\n reset-enable: false\n # 防火墙配置\n wall:\n config:\n multi-statement-allow: false\nwx: \n appletsAppid: wx049faf9c5234f31c\n appletsAppSecret: d24f34a70e3aa7086d6d6050d253ef7b\n\n\nali:\n conf: \n appId: 2021004173610331\n privateKey: MIIEvwIBADANBgkqhkiG9w0BAQEFAASCBKkwggSlAgEAAoIBAQCdf1zyOndfbhI67zoFtjuVMYMJkr1UHBOpX1kWe4z8uqo5F7ESpJzsUNRcV/Mgz4QPOYGMV6C5KsT6QH2in5XDumIlY3FVFLOeXrVczJSTJdeY+00Ky9MMB5/Hsg/0GqdBvbDMxY/A6EQ1jH7BnV5wpq8gsNDTJLRKfTpnh0jyjH4nNormnLNgah9SBdxTOccWqP3VblpuqLNMYCIvoF5ukD3Z/GCIQ4FUTMwzdXW69uVEzCTucwxsylHmj3lE8Th4Lf4Nr4+oq2LfkNoHv1ygDluKA2oy5AaUg/pfEEeQYSzAJXc23AAdEgj5oS2eIkbthuC70Ns8clTgVfiWj5mvAgMBAAECggEBAJHvj/pLPo1Ies/tF0BvqSoHJLpcI96p3XYViYERnoQXmt8oGsWBjn5SL1QZkokWf/FzgZy/HYg2HysbUs67PJSOQZ8PU9ZYRk86xqZkUk8+w1VXlf2o+7er4NuzHKE9iTmbQRWdAiTnkzxjIJja7sVHTgLmk7jxy7Ux8Eo5ytgi7M7eFjr/jOErHikEImdiM77T1SDD7rbEtXhocr6vyAMgI02/ZEAO4w9Cui+fqrDWUouMeHzgRZxJ1Mp1GGlsZ5X3P3Fd6oGyznvsuqS6h803O+zdg+0GdtmudjVHuHi/clOpMI3YB9JfBZPli5lCMSO2yrr+zRnvXBQM94MfaQECgYEA2rqA1G1sKbWakH1N3ZKH4Jferat/sKc5KDa9ws1vyIwGA1emwG7zuettaAlQBbzXUmOC8O0m/a5vyu029p9BuWpi2upeo8SX66Cm8RenjOJ/giaPmIYtbFC5PwSeIFk3rLQK6gsMQAsiYvul/5ZySus1+7YOFPq/y5J4pGNqwO8CgYEAuFXOfN/gIPsiy3FuKiAcC72QLe4dtk4WE96UADKZ6jpcIfuf2szNFJbbn/MZS4iWJ4QmPQMw4aRhDGxzVcpZkYrNFDZBarMTfYYlD8ZYOXhf7JG+IRqSWTVK/3Zpspdwi90CKKPlcglboOMl4vRHiR2tB7ff1A47EIcvRlJLM0ECgYEArSbhn8jzzF0IfAPGJXa/fCudy2wtjIIE/HHBbTpGmMNIa1LzHfl3liHqnWZp4/DnoEBIw0NqD38M3t9FGJ1gYVD36weIXirefVjTb55jNGOFv1mZaYwm301UKLAWIdOfAGgTD84pJ3XpBeTjN185IVfsh1RK9469UIGmYbSWKR8CgYEAozWGD9aAsXLqCcsyySWI73Q1thUARau5rHoD/HDRCiwF6yjJDocKhVJUvrgVC2Wx3OcKnDa5Du/l5YQYUjtJNq34ig7HuNs5RIiDRAZPkwLbm7Am8VR/g3DGKI4FY9TmF0/lW2pR+rgCYt77aojy1Zpq20yYZz76WNX4q4CtiIECgYBxaN8iMXuKkGigDq+DWiw3RSt9XalqJEWdLKXLJZto1ESN+KC6ZQaCM+j9L+2A4n2N10UjjABdvcztK7EFw5LFI5nDEFEQu7VUfi2eKIS2hUKm2QGQPxeCbNd5mUL4kXsmetKHcZnxZlG1CBinWXCUbJAIRbl9Cc4ax85evX+ChA==\n alipayPublicKey: MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAkoPidM7vHL/74FhOWARjkMDZN0GktpVEQaYz6qpIjTuKLcQsR74CUv9LoiGD9uquYAI52TdmxzMWbuMEvrdVIT6pWyJuCvScX2U5Zwn9Bk8bE5RmTobUrU3LFudMYIGFU3qUHqnTJFQxLsSUibTtxbov1bpCQNwk3/2RdYOpJHKDjkXzNcjJrkuNcGcuzNW/3+L5CMaVm0dxqxx0dhJ4H0xvpMw2uvdxdLXN/KoYszfps4j61x0KFwkulvD1WHzR1f/ot9NU8FZe+dkNm5cXb9HbwQIbfARyB5bd0EYHSr4fJIUJx1GnjpfT6/traxEoyOcI6diJa4b2hZpR3WvxTQIDAQAB\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: 123456\n 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: Lv12321@\n 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: admin\n reset-enable: false\n # 防火墙配置\n wall:\n config:\n multi-statement-allow: false\nwx:\n grantType: authorization_code \n appid: wx049faf9c5234f31c \n appSecret: d24f34a70e3aa7086d6d6050d253ef7b\n appletsAppid: #小程序APPid\n appletsAppSecret: #\n mchId: 1717539630 \n key: fD0JzscfMf295SYtRK3MnPRjSCA4Gahr \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: 123456\n 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: Lv12321@\n 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: admin\n 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: d24f34a70e3aa7086d6d6050d253ef7b\n appletsAppid: #小程序APPid\n appletsAppSecret: #\n mchId: 1717539630 \n key: fD0JzscfMf295SYtRK3MnPRjSCA4Gahr \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: 123456\n 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: 123456\n 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: Lv12321@\n 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: admin\n 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: 123456\n 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: Lv12321@\n 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: admin\n 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: 123456\n 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: 123456\n 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: admin\n reset-enable: false\n # 防火墙配置\n wall:\n config:\n multi-statement-allow: false\nwx: \n appletsAppid: wx049faf9c5234f31c\n appletsAppSecret: d24f34a70e3aa7086d6d6050d253ef7b\n\n\nali:\n conf: \n appId: 2021004173610331\n privateKey: MIIEvwIBADANBgkqhkiG9w0BAQEFAASCBKkwggSlAgEAAoIBAQCdf1zyOndfbhI67zoFtjuVMYMJkr1UHBOpX1kWe4z8uqo5F7ESpJzsUNRcV/Mgz4QPOYGMV6C5KsT6QH2in5XDumIlY3FVFLOeXrVczJSTJdeY+00Ky9MMB5/Hsg/0GqdBvbDMxY/A6EQ1jH7BnV5wpq8gsNDTJLRKfTpnh0jyjH4nNormnLNgah9SBdxTOccWqP3VblpuqLNMYCIvoF5ukD3Z/GCIQ4FUTMwzdXW69uVEzCTucwxsylHmj3lE8Th4Lf4Nr4+oq2LfkNoHv1ygDluKA2oy5AaUg/pfEEeQYSzAJXc23AAdEgj5oS2eIkbthuC70Ns8clTgVfiWj5mvAgMBAAECggEBAJHvj/pLPo1Ies/tF0BvqSoHJLpcI96p3XYViYERnoQXmt8oGsWBjn5SL1QZkokWf/FzgZy/HYg2HysbUs67PJSOQZ8PU9ZYRk86xqZkUk8+w1VXlf2o+7er4NuzHKE9iTmbQRWdAiTnkzxjIJja7sVHTgLmk7jxy7Ux8Eo5ytgi7M7eFjr/jOErHikEImdiM77T1SDD7rbEtXhocr6vyAMgI02/ZEAO4w9Cui+fqrDWUouMeHzgRZxJ1Mp1GGlsZ5X3P3Fd6oGyznvsuqS6h803O+zdg+0GdtmudjVHuHi/clOpMI3YB9JfBZPli5lCMSO2yrr+zRnvXBQM94MfaQECgYEA2rqA1G1sKbWakH1N3ZKH4Jferat/sKc5KDa9ws1vyIwGA1emwG7zuettaAlQBbzXUmOC8O0m/a5vyu029p9BuWpi2upeo8SX66Cm8RenjOJ/giaPmIYtbFC5PwSeIFk3rLQK6gsMQAsiYvul/5ZySus1+7YOFPq/y5J4pGNqwO8CgYEAuFXOfN/gIPsiy3FuKiAcC72QLe4dtk4WE96UADKZ6jpcIfuf2szNFJbbn/MZS4iWJ4QmPQMw4aRhDGxzVcpZkYrNFDZBarMTfYYlD8ZYOXhf7JG+IRqSWTVK/3Zpspdwi90CKKPlcglboOMl4vRHiR2tB7ff1A47EIcvRlJLM0ECgYEArSbhn8jzzF0IfAPGJXa/fCudy2wtjIIE/HHBbTpGmMNIa1LzHfl3liHqnWZp4/DnoEBIw0NqD38M3t9FGJ1gYVD36weIXirefVjTb55jNGOFv1mZaYwm301UKLAWIdOfAGgTD84pJ3XpBeTjN185IVfsh1RK9469UIGmYbSWKR8CgYEAozWGD9aAsXLqCcsyySWI73Q1thUARau5rHoD/HDRCiwF6yjJDocKhVJUvrgVC2Wx3OcKnDa5Du/l5YQYUjtJNq34ig7HuNs5RIiDRAZPkwLbm7Am8VR/g3DGKI4FY9TmF0/lW2pR+rgCYt77aojy1Zpq20yYZz76WNX4q4CtiIECgYBxaN8iMXuKkGigDq+DWiw3RSt9XalqJEWdLKXLJZto1ESN+KC6ZQaCM+j9L+2A4n2N10UjjABdvcztK7EFw5LFI5nDEFEQu7VUfi2eKIS2hUKm2QGQPxeCbNd5mUL4kXsmetKHcZnxZlG1CBinWXCUbJAIRbl9Cc4ax85evX+ChA==\n alipayPublicKey: MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAkoPidM7vHL/74FhOWARjkMDZN0GktpVEQaYz6qpIjTuKLcQsR74CUv9LoiGD9uquYAI52TdmxzMWbuMEvrdVIT6pWyJuCvScX2U5Zwn9Bk8bE5RmTobUrU3LFudMYIGFU3qUHqnTJFQxLsSUibTtxbov1bpCQNwk3/2RdYOpJHKDjkXzNcjJrkuNcGcuzNW/3+L5CMaVm0dxqxx0dhJ4H0xvpMw2uvdxdLXN/KoYszfps4j61x0KFwkulvD1WHzR1f/ot9NU8FZe+dkNm5cXb9HbwQIbfARyB5bd0EYHSr4fJIUJx1GnjpfT6/traxEoyOcI6diJa4b2hZpR3WvxTQIDAQAB\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: 123456\n 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: 123456\n 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: admin\n reset-enable: false\n # 防火墙配置\n wall:\n config:\n multi-statement-allow: false\nwx:\n grantType: authorization_code \n appid: wx049faf9c5234f31c \n appSecret: d24f34a70e3aa7086d6d6050d253ef7b\n appletsAppid: #小程序APPid\n appletsAppSecret: #\n mchId: 1717539630 \n key: fD0JzscfMf295SYtRK3MnPRjSCA4Gahr \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: 123456\n 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: 123456\n 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: admin\n 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: d24f34a70e3aa7086d6d6050d253ef7b\n appletsAppid: #小程序APPid\n appletsAppSecret: #\n mchId: 1717539630 \n key: fD0JzscfMf295SYtRK3MnPRjSCA4Gahr \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: 123456\n 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: 123456\r\n 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: 123456\r\n 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: admin\r\n 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: 123456\r\n 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: 123456\r\n 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: admin\r\n 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: 123456\n 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: 123456\n 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: admin\n reset-enable: false\n # 防火墙配置\n wall:\n config:\n multi-statement-allow: false\nwx: \n appletsAppid: wx049faf9c5234f31c\n appletsAppSecret: d24f34a70e3aa7086d6d6050d253ef7b\n\n\nali:\n conf: \n appId: 2021004173610331\n privateKey: MIIEvwIBADANBgkqhkiG9w0BAQEFAASCBKkwggSlAgEAAoIBAQCdf1zyOndfbhI67zoFtjuVMYMJkr1UHBOpX1kWe4z8uqo5F7ESpJzsUNRcV/Mgz4QPOYGMV6C5KsT6QH2in5XDumIlY3FVFLOeXrVczJSTJdeY+00Ky9MMB5/Hsg/0GqdBvbDMxY/A6EQ1jH7BnV5wpq8gsNDTJLRKfTpnh0jyjH4nNormnLNgah9SBdxTOccWqP3VblpuqLNMYCIvoF5ukD3Z/GCIQ4FUTMwzdXW69uVEzCTucwxsylHmj3lE8Th4Lf4Nr4+oq2LfkNoHv1ygDluKA2oy5AaUg/pfEEeQYSzAJXc23AAdEgj5oS2eIkbthuC70Ns8clTgVfiWj5mvAgMBAAECggEBAJHvj/pLPo1Ies/tF0BvqSoHJLpcI96p3XYViYERnoQXmt8oGsWBjn5SL1QZkokWf/FzgZy/HYg2HysbUs67PJSOQZ8PU9ZYRk86xqZkUk8+w1VXlf2o+7er4NuzHKE9iTmbQRWdAiTnkzxjIJja7sVHTgLmk7jxy7Ux8Eo5ytgi7M7eFjr/jOErHikEImdiM77T1SDD7rbEtXhocr6vyAMgI02/ZEAO4w9Cui+fqrDWUouMeHzgRZxJ1Mp1GGlsZ5X3P3Fd6oGyznvsuqS6h803O+zdg+0GdtmudjVHuHi/clOpMI3YB9JfBZPli5lCMSO2yrr+zRnvXBQM94MfaQECgYEA2rqA1G1sKbWakH1N3ZKH4Jferat/sKc5KDa9ws1vyIwGA1emwG7zuettaAlQBbzXUmOC8O0m/a5vyu029p9BuWpi2upeo8SX66Cm8RenjOJ/giaPmIYtbFC5PwSeIFk3rLQK6gsMQAsiYvul/5ZySus1+7YOFPq/y5J4pGNqwO8CgYEAuFXOfN/gIPsiy3FuKiAcC72QLe4dtk4WE96UADKZ6jpcIfuf2szNFJbbn/MZS4iWJ4QmPQMw4aRhDGxzVcpZkYrNFDZBarMTfYYlD8ZYOXhf7JG+IRqSWTVK/3Zpspdwi90CKKPlcglboOMl4vRHiR2tB7ff1A47EIcvRlJLM0ECgYEArSbhn8jzzF0IfAPGJXa/fCudy2wtjIIE/HHBbTpGmMNIa1LzHfl3liHqnWZp4/DnoEBIw0NqD38M3t9FGJ1gYVD36weIXirefVjTb55jNGOFv1mZaYwm301UKLAWIdOfAGgTD84pJ3XpBeTjN185IVfsh1RK9469UIGmYbSWKR8CgYEAozWGD9aAsXLqCcsyySWI73Q1thUARau5rHoD/HDRCiwF6yjJDocKhVJUvrgVC2Wx3OcKnDa5Du/l5YQYUjtJNq34ig7HuNs5RIiDRAZPkwLbm7Am8VR/g3DGKI4FY9TmF0/lW2pR+rgCYt77aojy1Zpq20yYZz76WNX4q4CtiIECgYBxaN8iMXuKkGigDq+DWiw3RSt9XalqJEWdLKXLJZto1ESN+KC6ZQaCM+j9L+2A4n2N10UjjABdvcztK7EFw5LFI5nDEFEQu7VUfi2eKIS2hUKm2QGQPxeCbNd5mUL4kXsmetKHcZnxZlG1CBinWXCUbJAIRbl9Cc4ax85evX+ChA==\n alipayPublicKey: MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAkoPidM7vHL/74FhOWARjkMDZN0GktpVEQaYz6qpIjTuKLcQsR74CUv9LoiGD9uquYAI52TdmxzMWbuMEvrdVIT6pWyJuCvScX2U5Zwn9Bk8bE5RmTobUrU3LFudMYIGFU3qUHqnTJFQxLsSUibTtxbov1bpCQNwk3/2RdYOpJHKDjkXzNcjJrkuNcGcuzNW/3+L5CMaVm0dxqxx0dhJ4H0xvpMw2uvdxdLXN/KoYszfps4j61x0KFwkulvD1WHzR1f/ot9NU8FZe+dkNm5cXb9HbwQIbfARyB5bd0EYHSr4fJIUJx1GnjpfT6/traxEoyOcI6diJa4b2hZpR3WvxTQIDAQAB\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: 123456\r\n 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: 123456\r\n 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: admin\r\n 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: 123456\r\n 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: 123456\r\n 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: admin\r\n 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: 123456\n 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: 123456\n 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: admin\n reset-enable: false\n # 防火墙配置\n wall:\n config:\n multi-statement-allow: false\nwx:\n grantType: authorization_code \n appid: wx049faf9c5234f31c \n appSecret: d24f34a70e3aa7086d6d6050d253ef7b\n appletsAppid: #小程序APPid\n appletsAppSecret: #\n mchId: 1717539630 \n key: fD0JzscfMf295SYtRK3MnPRjSCA4Gahr \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: 123456\n 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: 123456\n 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: admin\n 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: d24f34a70e3aa7086d6d6050d253ef7b\n appletsAppid: #小程序APPid\n appletsAppSecret: #\n mchId: 1717539630 \n key: fD0JzscfMf295SYtRK3MnPRjSCA4Gahr \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;
|
