/* Navicat Premium Data Transfer Source Server : 本地 Source Server Type : MySQL Source Server Version : 50744 Source Host : 127.0.0.1:3306 Source Schema : ry-config Target Server Type : MySQL Target Server Version : 50744 File Encoding : 65001 Date: 31/05/2026 21:53:45 */ 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(20) 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 COMMENT 'group_id', `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 COMMENT 'app_name', `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 COMMENT 'configuration description', `c_use` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'configuration usage', `effect` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '配置生效的描述', `type` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '配置的类型', `c_schema` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT '配置的模式', `encrypted_data_key` varchar(1024) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '密钥', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_configinfo_datagrouptenant`(`data_id`, `group_id`, `tenant_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 43 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'config_info' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of config_info -- ---------------------------- INSERT INTO `config_info` VALUES (1, 'application-dev.yml', 'DEFAULT_GROUP', 'spring:\n autoconfigure:\n exclude: com.alibaba.druid.spring.boot3.autoconfigure.DruidDataSourceAutoConfigure\n\n# feign 配置\nfeign:\n sentinel:\n enabled: true\n okhttp:\n enabled: true\n httpclient:\n enabled: false\n client:\n config:\n default:\n connectTimeout: 10000\n readTimeout: 10000\n compression:\n request:\n enabled: true\n min-request-size: 8192\n response:\n enabled: true\n\n# 本地文件上传 \nfile:\n domain: http://127.0.0.1:9300\n path: D:/ruoyi/uploadPath\n prefix: /statics\n\n#zlm 默认服务器配置\nmedia:\n id: hxkj_zlm\n # [必须修改] zlm服务器的内网IP\n ip: 192.168.31.12\n # [必须修改] zlm服务器的http.port\n http-port: 8092\n http-ssl-port: 443\n # [可选] zlm服务器的hook所使用的IP, 默认使用sip.ip\n hook-ip: 192.168.31.12\n # [必选选] zlm服务器的hook.admin_params=secret\n secret: hxkj_zlm\n # # [可选] 录像文件存储路径\n # record-path: F:/zml/record\n # [可选] 录像保存时间,单位是天\n record-day: 3\n # 启用多端口模式, 多端口模式使用端口区分每路流，兼容性更好。 单端口使用流的ssrc区分， 点播超时建议使用多端口测试\n rtp:\n # [可选] 在此范围内选择端口用于媒体流传输, 必须提前在zlm上配置该属性，不然自动配置此属性可能不成功\n port-range: 30500,40500 # 端口范围\n # [可选] 国标级联在此范围内选择端口发送媒体流,\n send-port-range: 30000,30500 # 端口范围\n\n# 暴露监控端点\nmanagement:\n endpoints:\n web:\n exposure:\n include: \'*\'\n', 'afbb638ea85dfb8cca710d5f44aaf565', '2020-05-20 12:00:00', '2026-05-29 12:41:14', 'nacos_namespace_migrate', '172.18.0.1', '', '', '通用配置', NULL, NULL, 'yaml', NULL, ''); INSERT INTO `config_info` VALUES (2, 'ruoyi-gateway-dev.yml', 'DEFAULT_GROUP', 'spring:\n data:\n redis:\n host: localhost\n port: 6379\n password: 123456\n cloud:\n gateway:\n server:\n webflux:\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 - CacheRequestBody\n - ValidateCodeFilter\n - StripPrefix=1\n # 代码生成\n - id: ruoyi-gen\n uri: lb://ruoyi-gen\n predicates:\n - Path=/code/**\n filters:\n - StripPrefix=1\n # 定时任务\n - id: ruoyi-job\n uri: lb://ruoyi-job\n predicates:\n - Path=/schedule/**\n filters:\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 # 海康sdk服务\n - id: ruoyi-haikang\n uri: lb://ruoyi-haikang\n predicates:\n - Path=/haikang/**\n filters:\n - StripPrefix=1\n # 泉视服务\n - id: ruoyi-qs\n uri: lb://ruoyi-qs\n predicates:\n - Path=/qs/**\n filters:\n - StripPrefix=1\n # 海康isup服务\n - id: ruoyi-haikang-isup\n uri: lb://ruoyi-haikang-isup\n predicates:\n - Path=/haikangIsup/**\n filters:\n - StripPrefix=1\n # 大华sdk服务\n - id: ruoyi-dahua\n uri: lb://ruoyi-dahua\n predicates:\n - Path=/dahua/**\n filters:\n - StripPrefix=1\n # zlm服务\n - id: ruoyi-zlm\n uri: lb://ruoyi-zlm\n predicates:\n - Path=/zlm/**\n filters:\n - StripPrefix=1\n # onvif服务\n - id: ruoyi-onvif\n uri: lb://ruoyi-onvif\n predicates:\n - Path=/onvif/**\n filters:\n - StripPrefix=1\n # gb28181 服务\n - id: ruoyi-gb28181\n uri: lb://ruoyi-gb28181\n predicates:\n - Path=/gb28181/**\n filters:\n - StripPrefix=1\n # jt1078 服务\n - id: ruoyi-jt1078\n uri: lb://ruoyi-jt1078\n predicates:\n - Path=/jt1078/**\n filters:\n - StripPrefix=1\n\n# 安全配置\nsecurity:\n # 验证码\n captcha:\n enabled: true\n type: math\n # 防止XSS攻击\n xss:\n enabled: true\n excludeUrls:\n - /system/notice\n\n # 不校验白名单\n ignore:\n whites:\n - /auth/logout\n - /auth/login\n - /auth/register\n - /*/v2/api-docs\n - /*/v3/api-docs\n - /csrf\n - /zlm/index/hook/**\n - /zlm/cloudRecord/download/zip\n\n# springdoc配置\nspringdoc:\n webjars:\n # 访问前缀\n prefix:\n', 'a64564490aa28efdb8c5b6bf67bddf85', '2020-05-14 14:17:55', '2026-04-26 20:31:52', 'nacos_namespace_migrate', '172.18.0.1', '', '', '网关模块', NULL, NULL, 'yaml', NULL, ''); INSERT INTO `config_info` VALUES (3, 'ruoyi-auth-dev.yml', 'DEFAULT_GROUP', 'spring:\n data:\n redis:\n host: localhost\n port: 6379\n password: 123456\n', '9501cdbab3b30d2812e8075e8f17e66a', '2020-11-20 00:00:00', '2026-03-27 13:50:54', 'nacos_namespace_migrate', '172.19.0.1', '', '', '认证中心', NULL, NULL, 'yaml', NULL, ''); INSERT INTO `config_info` VALUES (4, 'ruoyi-monitor-dev.yml', 'DEFAULT_GROUP', '# spring\nspring:\n security:\n user:\n name: ruoyi\n password: 123456\n boot:\n admin:\n ui:\n title: 若依服务状态监控\n', '6f122fd2bfb8d45f858e7d6529a9cd44', '2020-11-20 00:00:00', '2024-08-29 12:15:11', 'nacos', '0:0:0:0:0:0:0:1', '', '', '监控中心', 'null', 'null', 'yaml', '', ''); INSERT INTO `config_info` VALUES (5, 'ruoyi-system-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n data:\n redis:\n host: localhost\n port: 6379\n password: 123456\n datasource:\n druid:\n stat-view-servlet:\n enabled: true\n loginUsername: ruoyi\n loginPassword: 123456\n dynamic:\n druid:\n initial-size: 5\n min-idle: 5\n maxActive: 20\n maxWait: 60000\n connectTimeout: 30000\n socketTimeout: 60000\n timeBetweenEvictionRunsMillis: 60000\n minEvictableIdleTimeMillis: 300000\n validationQuery: SELECT 1 FROM DUAL\n testWhileIdle: true\n testOnBorrow: false\n testOnReturn: false\n poolPreparedStatements: true\n maxPoolPreparedStatementPerConnectionSize: 20\n filters: stat,slf4j\n connectionProperties: druid.stat.mergeSql\\=true;druid.stat.slowSqlMillis\\=5000\n datasource:\n # 主库数据源\n master:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: haoxin\n # 从库数据源\n # slave:\n # username: \n # password: \n # url: \n # driver-class-name: \n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.system\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n\n# springdoc配置\nspringdoc:\n gatewayUrl: http://localhost:8080/${spring.application.name}\n api-docs:\n # 是否开启接口文档\n enabled: true\n info:\n # 标题\n title: \'系统模块接口文档\'\n # 描述\n description: \'系统模块接口描述\'\n # 作者信息\n contact:\n name: RuoYi\n url: https://ruoyi.vip\n', '1a57cfb93b124a2fd1a54e1b3030e3ad', '2020-11-20 00:00:00', '2026-03-27 13:51:26', 'nacos_namespace_migrate', '172.19.0.1', '', '', '系统模块', NULL, NULL, 'yaml', NULL, ''); INSERT INTO `config_info` VALUES (6, 'ruoyi-gen-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n data:\n redis:\n host: localhost\n port: 6379\n password: 123456\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: haoxin\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.gen.domain\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n\n# springdoc配置\nspringdoc:\n gatewayUrl: http://localhost:8080/${spring.application.name}\n api-docs:\n # 是否开启接口文档\n enabled: true\n info:\n # 标题\n title: \'代码生成接口文档\'\n # 描述\n description: \'代码生成接口描述\'\n # 作者信息\n contact:\n name: RuoYi\n url: https://ruoyi.vip\n\n# 代码生成\ngen:\n # 作者\n author: ruoyi\n # 默认生成包路径 system 需改成自己的模块名称 如 system monitor tool\n packageName: com.ruoyi.system\n # 自动去除表前缀，默认是false\n autoRemovePre: false\n # 表前缀（生成类名不会包含表前缀，多个用逗号分隔）\n tablePrefix: sys_\n # 是否允许生成文件覆盖到本地（自定义路径），默认不允许\n allowOverwrite: false', '0ca5fab33644844031753b7da340a23b', '2020-11-20 00:00:00', '2026-03-27 13:51:43', 'nacos_namespace_migrate', '172.19.0.1', '', '', '代码生成', NULL, NULL, 'yaml', NULL, ''); INSERT INTO `config_info` VALUES (7, 'ruoyi-job-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n data:\n redis:\n host: localhost\n port: 6379\n password: 123456\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: haoxin\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.job.domain\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n\n# springdoc配置\nspringdoc:\n gatewayUrl: http://localhost:8080/${spring.application.name}\n api-docs:\n # 是否开启接口文档\n enabled: true\n info:\n # 标题\n title: \'定时任务接口文档\'\n # 描述\n description: \'定时任务接口描述\'\n # 作者信息\n contact:\n name: RuoYi\n url: https://ruoyi.vip\n', '393a1f5b82f4bac14c22587d9cdd8c39', '2020-11-20 00:00:00', '2026-03-27 13:51:57', 'nacos_namespace_migrate', '172.19.0.1', '', '', '定时任务', NULL, NULL, 'yaml', NULL, ''); INSERT INTO `config_info` VALUES (8, 'ruoyi-file-dev.yml', 'DEFAULT_GROUP', '# FastDFS配置\nfdfs:\n domain: http://127.0.0.1\n soTimeout: 3000\n connectTimeout: 2000\n trackerList: 127.0.0.1:22122\n\n# Minio配置\nminio:\n url: http://127.0.0.1:9000\n accessKey: minioadmin\n secretKey: minioadmin\n bucketName: test\n\n # 防盗链配置\nreferer:\n # 防盗链开关\n enabled: false\n # 允许的域名列表\n allowed-domains: localhost,127.0.0.1,ruoyi.vip,www.ruoyi.vip\n\nspring:\n servlet:\n multipart:\n # 单个文件的最大大小，例如 1024MB\n max-file-size: 1204MB\n # 整个请求（可包含多个文件）的最大总大小，例如 100MB\n max-request-size: 5120MB\n', '7470eb26adef9cd849e658d868d7fd7b', '2020-11-20 00:00:00', '2026-04-07 12:06:52', 'nacos_namespace_migrate', '172.19.0.1', '', '', '文件服务', NULL, NULL, 'yaml', NULL, ''); INSERT INTO `config_info` VALUES (9, 'sentinel-ruoyi-gateway', 'DEFAULT_GROUP', '[\n {\n \"resource\": \"ruoyi-auth\",\n \"count\": 500,\n \"grade\": 1,\n \"limitApp\": \"default\",\n \"strategy\": 0,\n \"controlBehavior\": 0\n },\n {\n \"resource\": \"ruoyi-system\",\n \"count\": 1000,\n \"grade\": 1,\n \"limitApp\": \"default\",\n \"strategy\": 0,\n \"controlBehavior\": 0\n },\n {\n \"resource\": \"ruoyi-gen\",\n \"count\": 200,\n \"grade\": 1,\n \"limitApp\": \"default\",\n \"strategy\": 0,\n \"controlBehavior\": 0\n },\n {\n \"resource\": \"ruoyi-job\",\n \"count\": 300,\n \"grade\": 1,\n \"limitApp\": \"default\",\n \"strategy\": 0,\n \"controlBehavior\": 0\n },\n {\n \"resource\": \"ruoyi-haikang\",\n \"count\": 300,\n \"grade\": 1,\n \"limitApp\": \"default\",\n \"strategy\": 0,\n \"controlBehavior\": 0\n },\n {\n \"resource\": \"ruoyi-qs\",\n \"count\": 300,\n \"grade\": 1,\n \"limitApp\": \"default\",\n \"strategy\": 0,\n \"controlBehavior\": 0\n },\n {\n \"resource\": \"ruoyi-haikang-isup\",\n \"count\": 300,\n \"grade\": 1,\n \"limitApp\": \"default\",\n \"strategy\": 0,\n \"controlBehavior\": 0\n },\n {\n \"resource\": \"ruoyi-dahua\",\n \"count\": 300,\n \"grade\": 1,\n \"limitApp\": \"default\",\n \"strategy\": 0,\n \"controlBehavior\": 0\n },\n {\n \"resource\": \"ruoyi-zlm\",\n \"count\": 300,\n \"grade\": 1,\n \"limitApp\": \"default\",\n \"strategy\": 0,\n \"controlBehavior\": 0\n },\n {\n \"resource\": \"ruoyi-onvif\",\n \"count\": 300,\n \"grade\": 1,\n \"limitApp\": \"default\",\n \"strategy\": 0,\n \"controlBehavior\": 0\n },\n {\n \"resource\": \"ruoyi-gb28181\",\n \"count\": 300,\n \"grade\": 1,\n \"limitApp\": \"default\",\n \"strategy\": 0,\n \"controlBehavior\": 0\n },\n {\n \"resource\": \"ruoyi-jt1078\",\n \"count\": 300,\n \"grade\": 1,\n \"limitApp\": \"default\",\n \"strategy\": 0,\n \"controlBehavior\": 0\n }\n]', 'fb44bf56f06a3b198cee785a33964e58', '2020-11-20 00:00:00', '2026-04-26 20:32:16', 'nacos_namespace_migrate', '172.18.0.1', '', '', '限流策略', NULL, NULL, 'json', NULL, ''); INSERT INTO `config_info` VALUES (10, 'application-dev.yml', 'DEFAULT_GROUP', 'spring:\n autoconfigure:\n exclude: com.alibaba.druid.spring.boot3.autoconfigure.DruidDataSourceAutoConfigure\n\n# feign 配置\nfeign:\n sentinel:\n enabled: true\n okhttp:\n enabled: true\n httpclient:\n enabled: false\n client:\n config:\n default:\n connectTimeout: 10000\n readTimeout: 10000\n compression:\n request:\n enabled: true\n min-request-size: 8192\n response:\n enabled: true\n\n# 本地文件上传 \nfile:\n domain: http://127.0.0.1:9300\n path: D:/ruoyi/uploadPath\n prefix: /statics\n\n#zlm 默认服务器配置\nmedia:\n id: hxkj_zlm\n # [必须修改] zlm服务器的内网IP\n ip: 192.168.31.12\n # [必须修改] zlm服务器的http.port\n http-port: 8092\n http-ssl-port: 443\n # [可选] zlm服务器的hook所使用的IP, 默认使用sip.ip\n hook-ip: 192.168.31.12\n # [必选选] zlm服务器的hook.admin_params=secret\n secret: hxkj_zlm\n # # [可选] 录像文件存储路径\n # record-path: F:/zml/record\n # [可选] 录像保存时间,单位是天\n record-day: 3\n # 启用多端口模式, 多端口模式使用端口区分每路流，兼容性更好。 单端口使用流的ssrc区分， 点播超时建议使用多端口测试\n rtp:\n # [可选] 在此范围内选择端口用于媒体流传输, 必须提前在zlm上配置该属性，不然自动配置此属性可能不成功\n port-range: 30500,40500 # 端口范围\n # [可选] 国标级联在此范围内选择端口发送媒体流,\n send-port-range: 30000,30500 # 端口范围\n\n# 暴露监控端点\nmanagement:\n endpoints:\n web:\n exposure:\n include: \'*\'\n', 'afbb638ea85dfb8cca710d5f44aaf565', '2026-03-27 13:35:57', '2026-05-29 12:41:14', 'nacos', '172.18.0.1', '', 'public', '通用配置', NULL, NULL, 'yaml', NULL, ''); INSERT INTO `config_info` VALUES (11, 'ruoyi-gateway-dev.yml', 'DEFAULT_GROUP', 'spring:\n data:\n redis:\n host: localhost\n port: 6379\n password: 123456\n cloud:\n gateway:\n server:\n webflux:\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 - CacheRequestBody\n - ValidateCodeFilter\n - StripPrefix=1\n # 代码生成\n - id: ruoyi-gen\n uri: lb://ruoyi-gen\n predicates:\n - Path=/code/**\n filters:\n - StripPrefix=1\n # 定时任务\n - id: ruoyi-job\n uri: lb://ruoyi-job\n predicates:\n - Path=/schedule/**\n filters:\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 # 海康sdk服务\n - id: ruoyi-haikang\n uri: lb://ruoyi-haikang\n predicates:\n - Path=/haikang/**\n filters:\n - StripPrefix=1\n # 泉视服务\n - id: ruoyi-qs\n uri: lb://ruoyi-qs\n predicates:\n - Path=/qs/**\n filters:\n - StripPrefix=1\n # 海康isup服务\n - id: ruoyi-haikang-isup\n uri: lb://ruoyi-haikang-isup\n predicates:\n - Path=/haikangIsup/**\n filters:\n - StripPrefix=1\n # 大华sdk服务\n - id: ruoyi-dahua\n uri: lb://ruoyi-dahua\n predicates:\n - Path=/dahua/**\n filters:\n - StripPrefix=1\n # zlm服务\n - id: ruoyi-zlm\n uri: lb://ruoyi-zlm\n predicates:\n - Path=/zlm/**\n filters:\n - StripPrefix=1\n # onvif服务\n - id: ruoyi-onvif\n uri: lb://ruoyi-onvif\n predicates:\n - Path=/onvif/**\n filters:\n - StripPrefix=1\n # gb28181 服务\n - id: ruoyi-gb28181\n uri: lb://ruoyi-gb28181\n predicates:\n - Path=/gb28181/**\n filters:\n - StripPrefix=1\n # jt1078 服务\n - id: ruoyi-jt1078\n uri: lb://ruoyi-jt1078\n predicates:\n - Path=/jt1078/**\n filters:\n - StripPrefix=1\n\n# 安全配置\nsecurity:\n # 验证码\n captcha:\n enabled: true\n type: math\n # 防止XSS攻击\n xss:\n enabled: true\n excludeUrls:\n - /system/notice\n\n # 不校验白名单\n ignore:\n whites:\n - /auth/logout\n - /auth/login\n - /auth/register\n - /*/v2/api-docs\n - /*/v3/api-docs\n - /csrf\n - /zlm/index/hook/**\n - /zlm/cloudRecord/download/zip\n\n# springdoc配置\nspringdoc:\n webjars:\n # 访问前缀\n prefix:\n', 'a64564490aa28efdb8c5b6bf67bddf85', '2026-03-27 13:35:57', '2026-04-26 20:31:52', 'nacos', '172.18.0.1', '', 'public', '网关模块', NULL, NULL, 'yaml', NULL, ''); INSERT INTO `config_info` VALUES (12, 'ruoyi-auth-dev.yml', 'DEFAULT_GROUP', 'spring:\n data:\n redis:\n host: localhost\n port: 6379\n password: 123456\n', '9501cdbab3b30d2812e8075e8f17e66a', '2026-03-27 13:35:57', '2026-03-27 13:50:54', 'nacos', '172.19.0.1', '', 'public', '认证中心', NULL, NULL, 'yaml', NULL, ''); INSERT INTO `config_info` VALUES (13, 'ruoyi-monitor-dev.yml', 'DEFAULT_GROUP', '# spring\nspring:\n security:\n user:\n name: ruoyi\n password: 123456\n boot:\n admin:\n ui:\n title: 若依服务状态监控\n', '6f122fd2bfb8d45f858e7d6529a9cd44', '2026-03-27 13:35:57', '2026-03-27 13:35:57', 'nacos_namespace_migrate', '0:0:0:0:0:0:0:1', '', 'public', '监控中心', NULL, NULL, 'yaml', NULL, ''); INSERT INTO `config_info` VALUES (14, 'ruoyi-system-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n data:\n redis:\n host: localhost\n port: 6379\n password: 123456\n datasource:\n druid:\n stat-view-servlet:\n enabled: true\n loginUsername: ruoyi\n loginPassword: 123456\n dynamic:\n druid:\n initial-size: 5\n min-idle: 5\n maxActive: 20\n maxWait: 60000\n connectTimeout: 30000\n socketTimeout: 60000\n timeBetweenEvictionRunsMillis: 60000\n minEvictableIdleTimeMillis: 300000\n validationQuery: SELECT 1 FROM DUAL\n testWhileIdle: true\n testOnBorrow: false\n testOnReturn: false\n poolPreparedStatements: true\n maxPoolPreparedStatementPerConnectionSize: 20\n filters: stat,slf4j\n connectionProperties: druid.stat.mergeSql\\=true;druid.stat.slowSqlMillis\\=5000\n datasource:\n # 主库数据源\n master:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: haoxin\n # 从库数据源\n # slave:\n # username: \n # password: \n # url: \n # driver-class-name: \n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.system\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n\n# springdoc配置\nspringdoc:\n gatewayUrl: http://localhost:8080/${spring.application.name}\n api-docs:\n # 是否开启接口文档\n enabled: true\n info:\n # 标题\n title: \'系统模块接口文档\'\n # 描述\n description: \'系统模块接口描述\'\n # 作者信息\n contact:\n name: RuoYi\n url: https://ruoyi.vip\n', '1a57cfb93b124a2fd1a54e1b3030e3ad', '2026-03-27 13:35:57', '2026-03-27 13:51:26', 'nacos', '172.19.0.1', '', 'public', '系统模块', NULL, NULL, 'yaml', NULL, ''); INSERT INTO `config_info` VALUES (15, 'ruoyi-gen-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n data:\n redis:\n host: localhost\n port: 6379\n password: 123456\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: haoxin\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.gen.domain\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n\n# springdoc配置\nspringdoc:\n gatewayUrl: http://localhost:8080/${spring.application.name}\n api-docs:\n # 是否开启接口文档\n enabled: true\n info:\n # 标题\n title: \'代码生成接口文档\'\n # 描述\n description: \'代码生成接口描述\'\n # 作者信息\n contact:\n name: RuoYi\n url: https://ruoyi.vip\n\n# 代码生成\ngen:\n # 作者\n author: ruoyi\n # 默认生成包路径 system 需改成自己的模块名称 如 system monitor tool\n packageName: com.ruoyi.system\n # 自动去除表前缀，默认是false\n autoRemovePre: false\n # 表前缀（生成类名不会包含表前缀，多个用逗号分隔）\n tablePrefix: sys_\n # 是否允许生成文件覆盖到本地（自定义路径），默认不允许\n allowOverwrite: false', '0ca5fab33644844031753b7da340a23b', '2026-03-27 13:35:57', '2026-03-27 13:51:43', 'nacos', '172.19.0.1', '', 'public', '代码生成', NULL, NULL, 'yaml', NULL, ''); INSERT INTO `config_info` VALUES (16, 'ruoyi-job-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n data:\n redis:\n host: localhost\n port: 6379\n password: 123456\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: haoxin\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.job.domain\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n\n# springdoc配置\nspringdoc:\n gatewayUrl: http://localhost:8080/${spring.application.name}\n api-docs:\n # 是否开启接口文档\n enabled: true\n info:\n # 标题\n title: \'定时任务接口文档\'\n # 描述\n description: \'定时任务接口描述\'\n # 作者信息\n contact:\n name: RuoYi\n url: https://ruoyi.vip\n', '393a1f5b82f4bac14c22587d9cdd8c39', '2026-03-27 13:35:57', '2026-03-27 13:51:57', 'nacos', '172.19.0.1', '', 'public', '定时任务', NULL, NULL, 'yaml', NULL, ''); INSERT INTO `config_info` VALUES (17, 'ruoyi-file-dev.yml', 'DEFAULT_GROUP', '# FastDFS配置\nfdfs:\n domain: http://127.0.0.1\n soTimeout: 3000\n connectTimeout: 2000\n trackerList: 127.0.0.1:22122\n\n# Minio配置\nminio:\n url: http://127.0.0.1:9000\n accessKey: minioadmin\n secretKey: minioadmin\n bucketName: test\n\n # 防盗链配置\nreferer:\n # 防盗链开关\n enabled: false\n # 允许的域名列表\n allowed-domains: localhost,127.0.0.1,ruoyi.vip,www.ruoyi.vip\n\nspring:\n servlet:\n multipart:\n # 单个文件的最大大小，例如 1024MB\n max-file-size: 1204MB\n # 整个请求（可包含多个文件）的最大总大小，例如 100MB\n max-request-size: 5120MB\n', '7470eb26adef9cd849e658d868d7fd7b', '2026-03-27 13:35:57', '2026-04-07 12:06:52', 'nacos', '172.19.0.1', '', 'public', '文件服务', NULL, NULL, 'yaml', NULL, ''); INSERT INTO `config_info` VALUES (18, 'sentinel-ruoyi-gateway', 'DEFAULT_GROUP', '[\n {\n \"resource\": \"ruoyi-auth\",\n \"count\": 500,\n \"grade\": 1,\n \"limitApp\": \"default\",\n \"strategy\": 0,\n \"controlBehavior\": 0\n },\n {\n \"resource\": \"ruoyi-system\",\n \"count\": 1000,\n \"grade\": 1,\n \"limitApp\": \"default\",\n \"strategy\": 0,\n \"controlBehavior\": 0\n },\n {\n \"resource\": \"ruoyi-gen\",\n \"count\": 200,\n \"grade\": 1,\n \"limitApp\": \"default\",\n \"strategy\": 0,\n \"controlBehavior\": 0\n },\n {\n \"resource\": \"ruoyi-job\",\n \"count\": 300,\n \"grade\": 1,\n \"limitApp\": \"default\",\n \"strategy\": 0,\n \"controlBehavior\": 0\n },\n {\n \"resource\": \"ruoyi-haikang\",\n \"count\": 300,\n \"grade\": 1,\n \"limitApp\": \"default\",\n \"strategy\": 0,\n \"controlBehavior\": 0\n },\n {\n \"resource\": \"ruoyi-qs\",\n \"count\": 300,\n \"grade\": 1,\n \"limitApp\": \"default\",\n \"strategy\": 0,\n \"controlBehavior\": 0\n },\n {\n \"resource\": \"ruoyi-haikang-isup\",\n \"count\": 300,\n \"grade\": 1,\n \"limitApp\": \"default\",\n \"strategy\": 0,\n \"controlBehavior\": 0\n },\n {\n \"resource\": \"ruoyi-dahua\",\n \"count\": 300,\n \"grade\": 1,\n \"limitApp\": \"default\",\n \"strategy\": 0,\n \"controlBehavior\": 0\n },\n {\n \"resource\": \"ruoyi-zlm\",\n \"count\": 300,\n \"grade\": 1,\n \"limitApp\": \"default\",\n \"strategy\": 0,\n \"controlBehavior\": 0\n },\n {\n \"resource\": \"ruoyi-onvif\",\n \"count\": 300,\n \"grade\": 1,\n \"limitApp\": \"default\",\n \"strategy\": 0,\n \"controlBehavior\": 0\n },\n {\n \"resource\": \"ruoyi-gb28181\",\n \"count\": 300,\n \"grade\": 1,\n \"limitApp\": \"default\",\n \"strategy\": 0,\n \"controlBehavior\": 0\n },\n {\n \"resource\": \"ruoyi-jt1078\",\n \"count\": 300,\n \"grade\": 1,\n \"limitApp\": \"default\",\n \"strategy\": 0,\n \"controlBehavior\": 0\n }\n]', 'fb44bf56f06a3b198cee785a33964e58', '2026-03-27 13:35:57', '2026-04-26 20:32:16', 'nacos', '172.18.0.1', '', 'public', '限流策略', NULL, NULL, 'json', NULL, ''); INSERT INTO `config_info` VALUES (27, 'ruoyi-haikang-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n data:\n redis:\n host: localhost\n port: 6379\n password: 123456\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: haoxin\n\nhaikang:\n # 是否监听报警\n enable-alarm-listen: false\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.haikang.domain\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n\n# springdoc配置\nspringdoc:\n gatewayUrl: http://localhost:8080/${spring.application.name}\n api-docs:\n # 是否开启接口文档\n enabled: true\n info:\n # 标题\n title: \'海康sdk生成接口文档\'\n # 描述\n description: \'海康sdk生成接口描述\'\n # 作者信息\n contact:\n name: RuoYi\n url: https://ruoyi.vip', 'd8eb924e9495c6440a8611ac3e14e0d8', '2026-03-27 14:19:23', '2026-05-20 22:39:12', 'nacos_namespace_migrate', '172.18.0.1', '', '', '', NULL, NULL, 'yaml', NULL, ''); INSERT INTO `config_info` VALUES (28, 'ruoyi-haikang-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n data:\n redis:\n host: localhost\n port: 6379\n password: 123456\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: haoxin\n\nhaikang:\n # 是否监听报警\n enable-alarm-listen: false\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.haikang.domain\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n\n# springdoc配置\nspringdoc:\n gatewayUrl: http://localhost:8080/${spring.application.name}\n api-docs:\n # 是否开启接口文档\n enabled: true\n info:\n # 标题\n title: \'海康sdk生成接口文档\'\n # 描述\n description: \'海康sdk生成接口描述\'\n # 作者信息\n contact:\n name: RuoYi\n url: https://ruoyi.vip', 'd8eb924e9495c6440a8611ac3e14e0d8', '2026-03-27 14:19:23', '2026-05-20 22:39:12', 'nacos', '172.18.0.1', '', 'public', '', NULL, NULL, 'yaml', NULL, ''); INSERT INTO `config_info` VALUES (29, 'ruoyi-qs-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n data:\n redis:\n host: localhost\n port: 6379\n password: 123456\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8&&allowMultiQueries=true\n username: root\n password: haoxin\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.qs.**.domain\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n\n# springdoc配置\nspringdoc:\n gatewayUrl: http://localhost:8080/${spring.application.name}\n api-docs:\n # 是否开启接口文档\n enabled: true\n info:\n # 标题\n title: \'泉视生成接口文档\'\n # 描述\n description: \'泉视生成接口描述\'\n # 作者信息\n contact:\n name: RuoYi\n url: https://ruoyi.vip', 'b98ec21b9ee07746583d5bff3edf9356', '2026-03-27 15:56:20', '2026-04-08 12:38:27', 'nacos_namespace_migrate', '172.19.0.1', '', '', '', NULL, NULL, 'yaml', NULL, ''); INSERT INTO `config_info` VALUES (30, 'ruoyi-qs-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n data:\n redis:\n host: localhost\n port: 6379\n password: 123456\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8&&allowMultiQueries=true\n username: root\n password: haoxin\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.qs.**.domain\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n\n# springdoc配置\nspringdoc:\n gatewayUrl: http://localhost:8080/${spring.application.name}\n api-docs:\n # 是否开启接口文档\n enabled: true\n info:\n # 标题\n title: \'泉视生成接口文档\'\n # 描述\n description: \'泉视生成接口描述\'\n # 作者信息\n contact:\n name: RuoYi\n url: https://ruoyi.vip', 'b98ec21b9ee07746583d5bff3edf9356', '2026-03-27 15:56:20', '2026-04-08 12:38:27', 'nacos', '172.19.0.1', '', 'public', '', NULL, NULL, 'yaml', NULL, ''); INSERT INTO `config_info` VALUES (31, 'ruoyi-haikang-isup-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n data:\n redis:\n host: localhost\n port: 6379\n password: 123456\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: haoxin\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.haikang.isup.**.domain\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n\nhaikang-isup:\n cmsServer:\n # 注册服务器监听地址(服务器本地地址)\n ip: 192.168.31.12\n port: 7660\n\n dasServer:\n # DAS地址（此处的IP和端口与设备网页端设置的平台IP地址和端口一致）\n ip: 192.168.31.12\n port: 7660\n\n smsServer:\n # 取流服务器地址端口（公网对接填入公网地址和端口）\n ip: 192.168.31.12\n port: 7665\n # 取流服务器监听地址端口(服务器本地地址)\n listenIp: 192.168.31.12\n listenPort: 7665\n\n smsBackServer:\n # 回放流媒体服务器地址端口（公网对接填入公网地址和端口）\n ip: 192.168.31.12\n port: 8000\n # 取流服务器监听地址端口(服务器本地地址)\n listenIp: 192.168.31.12\n listenPort: 8000\n\n voiceSmsServer:\n # 语音流媒体服务器地址端口（公网对接填入公网地址和端口）\n ip: 192.168.31.12\n port: 7500\n # 语音流媒体服务器监听地址端口(服务器本地地址)\n listenIp: 192.168.31.12\n listenPort: 7500\n\n alarmServer:\n # 报警服务器地址（公网对接填入公网地址和端口）\n ip: 192.168.31.12\n tcpPort: 8003\n udpPort: 8002\n #\n alarmStorage: false\n # 报警服务器类型：\n # 0-只支持UDP协议上报\n # 1-支持UDP、TCP两种协议上报（ISUP4.0）\n # 2-MQTT(ISUP5.0) (MQTT复用TCP的端口)\n type: 2\n # 报警服务器监听地址端口\n listenIp: 192.168.31.12\n listenTcpPort: 7663\n listenUdpPort: 7662\n\n picServer:\n # 图片存储服务器地址：IUSP5.0版本接入端口建议固定为6011\n ip: 192.168.31.12\n port: 6011\n # 图片存储服务器类型：\n # 0-Tomcat\n # 1-VRB\n # 2-云存储\n # 3-KMS\n # 4-ISUP5.0\n type: 2\n # 图片存储服务器监听地址端口\n listenIp: 192.168.31.12\n listenPort: 6011\n\n # ISUP5.0登录秘钥\n isupKey: 12345678\n\n # 报警服务器打印事件模式\n # file=事件保存到文件中\n # console=事件打印在控制台上\n eventInfoPrintType: console\n\n# springdoc配置\nspringdoc:\n gatewayUrl: http://localhost:8080/${spring.application.name}\n api-docs:\n # 是否开启接口文档\n enabled: true\n info:\n # 标题\n title: \'海康isup生成接口文档\'\n # 描述\n description: \'海康isup生成接口描述\'\n # 作者信息\n contact:\n name: RuoYi\n url: https://ruoyi.vip', '58a65a91c02ce20cb41f57be77652cdb', '2026-03-28 16:00:45', '2026-05-29 12:42:46', 'nacos_namespace_migrate', '172.18.0.1', '', '', '', NULL, NULL, 'yaml', NULL, ''); INSERT INTO `config_info` VALUES (32, 'ruoyi-haikang-isup-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n data:\n redis:\n host: localhost\n port: 6379\n password: 123456\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: haoxin\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.haikang.isup.**.domain\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n\nhaikang-isup:\n cmsServer:\n # 注册服务器监听地址(服务器本地地址)\n ip: 192.168.31.12\n port: 7660\n\n dasServer:\n # DAS地址（此处的IP和端口与设备网页端设置的平台IP地址和端口一致）\n ip: 192.168.31.12\n port: 7660\n\n smsServer:\n # 取流服务器地址端口（公网对接填入公网地址和端口）\n ip: 192.168.31.12\n port: 7665\n # 取流服务器监听地址端口(服务器本地地址)\n listenIp: 192.168.31.12\n listenPort: 7665\n\n smsBackServer:\n # 回放流媒体服务器地址端口（公网对接填入公网地址和端口）\n ip: 192.168.31.12\n port: 8000\n # 取流服务器监听地址端口(服务器本地地址)\n listenIp: 192.168.31.12\n listenPort: 8000\n\n voiceSmsServer:\n # 语音流媒体服务器地址端口（公网对接填入公网地址和端口）\n ip: 192.168.31.12\n port: 7500\n # 语音流媒体服务器监听地址端口(服务器本地地址)\n listenIp: 192.168.31.12\n listenPort: 7500\n\n alarmServer:\n # 报警服务器地址（公网对接填入公网地址和端口）\n ip: 192.168.31.12\n tcpPort: 8003\n udpPort: 8002\n #\n alarmStorage: false\n # 报警服务器类型：\n # 0-只支持UDP协议上报\n # 1-支持UDP、TCP两种协议上报（ISUP4.0）\n # 2-MQTT(ISUP5.0) (MQTT复用TCP的端口)\n type: 2\n # 报警服务器监听地址端口\n listenIp: 192.168.31.12\n listenTcpPort: 7663\n listenUdpPort: 7662\n\n picServer:\n # 图片存储服务器地址：IUSP5.0版本接入端口建议固定为6011\n ip: 192.168.31.12\n port: 6011\n # 图片存储服务器类型：\n # 0-Tomcat\n # 1-VRB\n # 2-云存储\n # 3-KMS\n # 4-ISUP5.0\n type: 2\n # 图片存储服务器监听地址端口\n listenIp: 192.168.31.12\n listenPort: 6011\n\n # ISUP5.0登录秘钥\n isupKey: 12345678\n\n # 报警服务器打印事件模式\n # file=事件保存到文件中\n # console=事件打印在控制台上\n eventInfoPrintType: console\n\n# springdoc配置\nspringdoc:\n gatewayUrl: http://localhost:8080/${spring.application.name}\n api-docs:\n # 是否开启接口文档\n enabled: true\n info:\n # 标题\n title: \'海康isup生成接口文档\'\n # 描述\n description: \'海康isup生成接口描述\'\n # 作者信息\n contact:\n name: RuoYi\n url: https://ruoyi.vip', '58a65a91c02ce20cb41f57be77652cdb', '2026-03-28 16:00:45', '2026-05-29 12:42:46', 'nacos', '172.18.0.1', '', 'public', '', NULL, NULL, 'yaml', NULL, ''); INSERT INTO `config_info` VALUES (33, 'ruoyi-dahua-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n data:\n redis:\n host: localhost\n port: 6379\n password: 123456\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: haoxin\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.dahua.domain\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n\n# dahua配置\ndahua:\n # [必须修改] dahua服务器的可以是内网IP也可以是公网IP\n ip: 192.168.31.12\n # [必须修改] dahua服务器的端口\n port: 9500\n # 是否公网\n isPublicNetwork: false\n # 是否监听报警\n enable-alarm-listen: false\n\n# springdoc配置\nspringdoc:\n gatewayUrl: http://localhost:8080/${spring.application.name}\n api-docs:\n # 是否开启接口文档\n enabled: true\n info:\n # 标题\n title: \'大华sdk生成接口文档\'\n # 描述\n description: \'大华sdk生成接口描述\'\n # 作者信息\n contact:\n name: RuoYi\n url: https://ruoyi.vip', '09bfe05213f6140e08e02639a4ac9f82', '2026-03-30 15:21:56', '2026-05-29 12:42:57', 'nacos_namespace_migrate', '172.18.0.1', '', '', '', NULL, NULL, 'yaml', NULL, ''); INSERT INTO `config_info` VALUES (34, 'ruoyi-dahua-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n data:\n redis:\n host: localhost\n port: 6379\n password: 123456\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: haoxin\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.dahua.domain\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n\n# dahua配置\ndahua:\n # [必须修改] dahua服务器的可以是内网IP也可以是公网IP\n ip: 192.168.31.12\n # [必须修改] dahua服务器的端口\n port: 9500\n # 是否公网\n isPublicNetwork: false\n # 是否监听报警\n enable-alarm-listen: false\n\n# springdoc配置\nspringdoc:\n gatewayUrl: http://localhost:8080/${spring.application.name}\n api-docs:\n # 是否开启接口文档\n enabled: true\n info:\n # 标题\n title: \'大华sdk生成接口文档\'\n # 描述\n description: \'大华sdk生成接口描述\'\n # 作者信息\n contact:\n name: RuoYi\n url: https://ruoyi.vip', '09bfe05213f6140e08e02639a4ac9f82', '2026-03-30 15:21:56', '2026-05-29 12:42:57', 'nacos', '172.18.0.1', '', 'public', '', NULL, NULL, 'yaml', NULL, ''); INSERT INTO `config_info` VALUES (35, 'ruoyi-zlm-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n gateway:\n prrt: 8080\n data:\n redis:\n host: localhost\n port: 6379\n password: 123456\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: haoxin\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.zlm.**.domain\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n\n# [根据业务需求配置]\nuser-settings:\n # 点播/录像回放 等待超时时间,单位：毫秒\n play-timeout: 180000\n # [可选] 自动点播， 使用固定流地址进行播放时，如果未点播则自动进行点播, 需要rtp.enable=true\n auto-apply-play: true\n # 推流直播是否录制\n record-push-live: true\n # 国标是否录制\n record-sip: true\n # 国标点播 按需拉流, true：有人观看拉流，无人观看释放， false：拉起后不自动释放\n stream-on-demand: false\n # 是否返回Date属性，true：不返回，避免摄像头通过该参数自动校时，false：返回，摄像头可能会根据该时间校时\n disable-date-header: false\n # 是否开启sql日志\n sql-log: false\n\n# springdoc配置\nspringdoc:\n gatewayUrl: http://localhost:8080/${spring.application.name}\n api-docs:\n # 是否开启接口文档\n enabled: true\n info:\n # 标题\n title: \'zlm生成接口文档\'\n # 描述\n description: \'zlm生成接口描述\'\n # 作者信息\n contact:\n name: RuoYi\n url: https://ruoyi.vip', '918ed0955f6ba92a2452aec6d0d718d0', '2026-03-31 16:04:27', '2026-04-02 17:01:59', 'nacos_namespace_migrate', '172.19.0.1', '', '', '', NULL, NULL, 'yaml', NULL, ''); INSERT INTO `config_info` VALUES (36, 'ruoyi-zlm-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n gateway:\n prrt: 8080\n data:\n redis:\n host: localhost\n port: 6379\n password: 123456\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: haoxin\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.zlm.**.domain\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n\n# [根据业务需求配置]\nuser-settings:\n # 点播/录像回放 等待超时时间,单位：毫秒\n play-timeout: 180000\n # [可选] 自动点播， 使用固定流地址进行播放时，如果未点播则自动进行点播, 需要rtp.enable=true\n auto-apply-play: true\n # 推流直播是否录制\n record-push-live: true\n # 国标是否录制\n record-sip: true\n # 国标点播 按需拉流, true：有人观看拉流，无人观看释放， false：拉起后不自动释放\n stream-on-demand: false\n # 是否返回Date属性，true：不返回，避免摄像头通过该参数自动校时，false：返回，摄像头可能会根据该时间校时\n disable-date-header: false\n # 是否开启sql日志\n sql-log: false\n\n# springdoc配置\nspringdoc:\n gatewayUrl: http://localhost:8080/${spring.application.name}\n api-docs:\n # 是否开启接口文档\n enabled: true\n info:\n # 标题\n title: \'zlm生成接口文档\'\n # 描述\n description: \'zlm生成接口描述\'\n # 作者信息\n contact:\n name: RuoYi\n url: https://ruoyi.vip', '918ed0955f6ba92a2452aec6d0d718d0', '2026-03-31 16:04:27', '2026-04-02 17:01:59', 'nacos', '172.19.0.1', '', 'public', '', NULL, NULL, 'yaml', NULL, ''); INSERT INTO `config_info` VALUES (37, 'ruoyi-onvif-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n data:\n redis:\n host: localhost\n port: 6379\n password: 123456\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: haoxin\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.onvif.domain\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n\n# springdoc配置\nspringdoc:\n gatewayUrl: http://localhost:8080/${spring.application.name}\n api-docs:\n # 是否开启接口文档\n enabled: true\n info:\n # 标题\n title: \'onvif接口文档\'\n # 描述\n description: \'onvif接口描述\'\n # 作者信息\n contact:\n name: RuoYi\n url: https://ruoyi.vip', '690d82dd727151336f34c3fa62592aac', '2026-04-09 15:01:38', '2026-04-09 15:02:30', 'nacos_namespace_migrate', '172.19.0.1', '', '', '', NULL, NULL, 'yaml', NULL, ''); INSERT INTO `config_info` VALUES (38, 'ruoyi-onvif-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n data:\n redis:\n host: localhost\n port: 6379\n password: 123456\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: haoxin\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.onvif.domain\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n\n# springdoc配置\nspringdoc:\n gatewayUrl: http://localhost:8080/${spring.application.name}\n api-docs:\n # 是否开启接口文档\n enabled: true\n info:\n # 标题\n title: \'onvif接口文档\'\n # 描述\n description: \'onvif接口描述\'\n # 作者信息\n contact:\n name: RuoYi\n url: https://ruoyi.vip', '690d82dd727151336f34c3fa62592aac', '2026-04-09 15:01:38', '2026-04-09 15:02:30', 'nacos', '172.19.0.1', '', 'public', '', NULL, NULL, 'yaml', NULL, ''); INSERT INTO `config_info` VALUES (39, 'ruoyi-gb28181-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n data:\n redis:\n host: localhost\n port: 6379\n password: 123456\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: haoxin\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.gb28181.**.domain\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n\n# 作为28181服务器的配置\nsip:\n ip: 0.0.0.0,192.168.31.12\n # [可选] 28181服务监听的端口\n port: 8116\n # 根据国标6.1.2中规定，domain宜采用ID统一编码的前十位编码。国标附录D中定义前8位为中心编码（由省级、市级、区级、基层编号组成，参照GB/T 2260-2007）\n # 后两位为行业编码，定义参照附录D.3\n # 3701020049标识山东济南历下区 信息行业接入\n # [可选]\n domain: 4101050000\n # [可选]\n id: 41010500002000000001\n # [可选] 默认设备认证密码，后续扩展使用设备单独密码, 移除密码将不进行校验\n password: 12345678\n\n# springdoc配置\nspringdoc:\n gatewayUrl: http://localhost:8080/${spring.application.name}\n api-docs:\n # 是否开启接口文档\n enabled: true\n info:\n # 标题\n title: \'国标28181生成接口文档\'\n # 描述\n description: \'国标28181生成接口描述\'\n # 作者信息\n contact:\n name: RuoYi\n url: https://ruoyi.vip', '55e5d4206f858f06f0355be0026cfbdd', '2026-04-23 12:44:01', '2026-05-29 12:43:22', 'nacos_namespace_migrate', '172.18.0.1', '', '', '国标28181配置', NULL, NULL, 'yaml', NULL, ''); INSERT INTO `config_info` VALUES (40, 'ruoyi-gb28181-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n data:\n redis:\n host: localhost\n port: 6379\n password: 123456\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: haoxin\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.gb28181.**.domain\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n\n# 作为28181服务器的配置\nsip:\n ip: 0.0.0.0,192.168.31.12\n # [可选] 28181服务监听的端口\n port: 8116\n # 根据国标6.1.2中规定，domain宜采用ID统一编码的前十位编码。国标附录D中定义前8位为中心编码（由省级、市级、区级、基层编号组成，参照GB/T 2260-2007）\n # 后两位为行业编码，定义参照附录D.3\n # 3701020049标识山东济南历下区 信息行业接入\n # [可选]\n domain: 4101050000\n # [可选]\n id: 41010500002000000001\n # [可选] 默认设备认证密码，后续扩展使用设备单独密码, 移除密码将不进行校验\n password: 12345678\n\n# springdoc配置\nspringdoc:\n gatewayUrl: http://localhost:8080/${spring.application.name}\n api-docs:\n # 是否开启接口文档\n enabled: true\n info:\n # 标题\n title: \'国标28181生成接口文档\'\n # 描述\n description: \'国标28181生成接口描述\'\n # 作者信息\n contact:\n name: RuoYi\n url: https://ruoyi.vip', '55e5d4206f858f06f0355be0026cfbdd', '2026-04-23 12:44:01', '2026-05-29 12:43:22', 'nacos', '172.18.0.1', '', 'public', '国标28181配置', NULL, NULL, 'yaml', NULL, ''); INSERT INTO `config_info` VALUES (41, 'ruoyi-jt1078-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n data:\n redis:\n host: localhost\n port: 6379\n password: 123456\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: haoxin\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.jt1078.**.domain\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n\njt-server:\n jt808:\n tcp-port: 7100\n udp-port: 7100\n idle-timeout: 180\n message-package: com.ruoyi.jt1078.protocol\n t0801:\n path: D:/jt_data/media_file\n t9208:\n host: 127.0.0.1\n port: 7200\n enabled: true\n path: D:/jt_data/alarm_file\n t9206:\n host: 127.0.0.1\n port: 21\n username: test\n password: test\n\n# springdoc配置\nspringdoc:\n gatewayUrl: http://localhost:8080/${spring.application.name}\n api-docs:\n # 是否开启接口文档\n enabled: true\n info:\n # 标题\n title: \'部标1078生成接口文档\'\n # 描述\n description: \'部标1078生成接口描述\'\n # 作者信息\n contact:\n name: RuoYi\n url: https://ruoyi.vip', 'da4ef4bd514497033abb44e4aa4ca662', '2026-04-25 16:54:12', '2026-04-28 19:04:35', 'nacos_namespace_migrate', '172.18.0.1', '', '', 'jt1078协议', NULL, NULL, 'yaml', NULL, ''); INSERT INTO `config_info` VALUES (42, 'ruoyi-jt1078-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n data:\n redis:\n host: localhost\n port: 6379\n password: 123456\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: haoxin\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.jt1078.**.domain\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n\njt-server:\n jt808:\n tcp-port: 7100\n udp-port: 7100\n idle-timeout: 180\n message-package: com.ruoyi.jt1078.protocol\n t0801:\n path: D:/jt_data/media_file\n t9208:\n host: 127.0.0.1\n port: 7200\n enabled: true\n path: D:/jt_data/alarm_file\n t9206:\n host: 127.0.0.1\n port: 21\n username: test\n password: test\n\n# springdoc配置\nspringdoc:\n gatewayUrl: http://localhost:8080/${spring.application.name}\n api-docs:\n # 是否开启接口文档\n enabled: true\n info:\n # 标题\n title: \'部标1078生成接口文档\'\n # 描述\n description: \'部标1078生成接口描述\'\n # 作者信息\n contact:\n name: RuoYi\n url: https://ruoyi.vip', 'da4ef4bd514497033abb44e4aa4ca662', '2026-04-25 16:54:12', '2026-04-28 19:04:35', 'nacos', '172.18.0.1', '', 'public', 'jt1078协议', NULL, NULL, 'yaml', NULL, ''); -- ---------------------------- -- Table structure for config_info_aggr -- ---------------------------- DROP TABLE IF EXISTS `config_info_aggr`; CREATE TABLE `config_info_aggr` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id', `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id', `group_id` varchar(255) 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`, `group_id`, `tenant_id`, `datum_id`) 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(20) 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` varchar(1024) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '密钥', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_configinfobeta_datagrouptenant`(`data_id`, `group_id`, `tenant_id`) 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_gray -- ---------------------------- DROP TABLE IF EXISTS `config_info_gray`; CREATE TABLE `config_info_gray` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id', `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'data_id', `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'group_id', `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'content', `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'md5', `src_user` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT 'src_user', `src_ip` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'src_ip', `gmt_create` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT 'gmt_create', `gmt_modified` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT 'gmt_modified', `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'app_name', `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT 'tenant_id', `gray_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'gray_name', `gray_rule` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'gray_rule', `encrypted_data_key` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'encrypted_data_key', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_configinfogray_datagrouptenantgray`(`data_id`, `group_id`, `tenant_id`, `gray_name`) USING BTREE, INDEX `idx_dataid_gmt_modified`(`data_id`, `gmt_modified`) USING BTREE, INDEX `idx_gmt_modified`(`gmt_modified`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'config_info_gray' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of config_info_gray -- ---------------------------- -- ---------------------------- -- Table structure for config_info_tag -- ---------------------------- DROP TABLE IF EXISTS `config_info_tag`; CREATE TABLE `config_info_tag` ( `id` bigint(20) 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`, `group_id`, `tenant_id`, `tag_id`) 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(20) 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(20) NOT NULL AUTO_INCREMENT COMMENT 'nid, 自增长标识', PRIMARY KEY (`nid`) USING BTREE, UNIQUE INDEX `uk_configtagrelation_configidtag`(`id`, `tag_name`, `tag_type`) USING BTREE, INDEX `idx_tenant_id`(`tenant_id`) 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(20) 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(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '配额，0表示使用默认值', `usage` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '使用量', `max_size` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '单个配置大小上限，单位为字节，0表示使用默认值', `max_aggr_count` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '聚合子配置最大个数，，0表示使用默认值', `max_aggr_size` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '单个聚合数据的子配置大小上限，单位为字节，0表示使用默认值', `max_history_count` int(10) 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`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '集群、各Group容量信息表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of group_capacity -- ---------------------------- INSERT INTO `group_capacity` VALUES (1, '', 0, 34, 0, 0, 0, 0, '2026-03-27 06:18:58', '2026-05-30 16:33:21'); -- ---------------------------- -- Table structure for his_config_info -- ---------------------------- DROP TABLE IF EXISTS `his_config_info`; CREATE TABLE `his_config_info` ( `id` bigint(20) UNSIGNED NOT NULL COMMENT 'id', `nid` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'nid, 自增标识', `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', `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', `op_type` char(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'operation type', `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT '租户字段', `encrypted_data_key` varchar(1024) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '密钥', `publish_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT 'formal' COMMENT 'publish type gray or formal', `gray_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'gray name', `ext_info` longtext CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT 'ext info', PRIMARY KEY (`nid`) USING BTREE, INDEX `idx_gmt_create`(`gmt_create`) USING BTREE, INDEX `idx_gmt_modified`(`gmt_modified`) USING BTREE, INDEX `idx_did`(`data_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 86 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '多租户改造' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of his_config_info -- ---------------------------- INSERT INTO `his_config_info` VALUES (34, 73, 'ruoyi-dahua-dev.yml', 'DEFAULT_GROUP', '', '# spring配置\nspring:\n data:\n redis:\n host: localhost\n port: 6379\n password: 123456\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: haoxin\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.dahua.domain\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n\n# dahua配置\ndahua:\n # [必须修改] dahua服务器的可以是内网IP也可以是公网IP\n ip: 192.168.1.200\n # [必须修改] dahua服务器的端口\n port: 9500\n # 是否公网\n isPublicNetwork: false\n\n# springdoc配置\nspringdoc:\n gatewayUrl: http://localhost:8080/${spring.application.name}\n api-docs:\n # 是否开启接口文档\n enabled: true\n info:\n # 标题\n title: \'大华sdk生成接口文档\'\n # 描述\n description: \'大华sdk生成接口描述\'\n # 作者信息\n contact:\n name: RuoYi\n url: https://ruoyi.vip', 'ab0d966e6c384e20606dab0e5f6a2639', '2026-05-18 00:53:05', '2026-05-17 16:53:05', 'nacos', '172.18.0.1', 'U', 'public', '', 'formal', '', '{\"type\":\"yaml\",\"src_user\":\"nacos\"}'); INSERT INTO `his_config_info` VALUES (34, 74, 'ruoyi-dahua-dev.yml', 'DEFAULT_GROUP', '', '# spring配置\nspring:\n data:\n redis:\n host: localhost\n port: 6379\n password: 123456\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: haoxin\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.dahua.domain\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n\n# dahua配置\ndahua:\n # [必须修改] dahua服务器的可以是内网IP也可以是公网IP\n ip: 192.168.1.200\n # [必须修改] dahua服务器的端口\n port: 9500\n # 是否公网\n isPublicNetwork: false\n # 是否监听报警\n enable-alarm-listen: true\n\n# springdoc配置\nspringdoc:\n gatewayUrl: http://localhost:8080/${spring.application.name}\n api-docs:\n # 是否开启接口文档\n enabled: true\n info:\n # 标题\n title: \'大华sdk生成接口文档\'\n # 描述\n description: \'大华sdk生成接口描述\'\n # 作者信息\n contact:\n name: RuoYi\n url: https://ruoyi.vip', '972432802f79c4f864ccbd2ba6a099d9', '2026-05-18 01:39:50', '2026-05-17 17:39:50', 'nacos', '172.18.0.1', 'U', 'public', '', 'formal', '', '{\"type\":\"yaml\",\"src_user\":\"nacos\"}'); INSERT INTO `his_config_info` VALUES (32, 75, 'ruoyi-haikang-isup-dev.yml', 'DEFAULT_GROUP', '', '# spring配置\nspring:\n data:\n redis:\n host: localhost\n port: 6379\n password: 123456\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: haoxin\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.haikang.isup.**.domain\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n\nhaikang-isup:\n cmsServer:\n # 注册服务器监听地址(服务器本地地址)\n ip: 192.168.1.200\n port: 7660\n\n dasServer:\n # DAS地址（此处的IP和端口与设备网页端设置的平台IP地址和端口一致）\n ip: 192.168.1.200\n port: 7660\n\n smsServer:\n # 取流服务器地址端口（公网对接填入公网地址和端口）\n ip: 192.168.1.200\n port: 7665\n # 取流服务器监听地址端口(服务器本地地址)\n listenIp: 192.168.1.200\n listenPort: 7665\n\n smsBackServer:\n # 回放流媒体服务器地址端口（公网对接填入公网地址和端口）\n ip: 192.168.1.200\n port: 8000\n # 取流服务器监听地址端口(服务器本地地址)\n listenIp: 192.168.1.200\n listenPort: 8000\n\n voiceSmsServer:\n # 语音流媒体服务器地址端口（公网对接填入公网地址和端口）\n ip: 192.168.1.200\n port: 7500\n # 语音流媒体服务器监听地址端口(服务器本地地址)\n listenIp: 192.168.1.200\n listenPort: 7500\n\n alarmServer:\n # 报警服务器地址（公网对接填入公网地址和端口）\n ip: 192.168.1.200\n tcpPort: 7663\n udpPort: 7662\n #\n alarmStorage: false\n # 报警服务器类型：\n # 0-只支持UDP协议上报\n # 1-支持UDP、TCP两种协议上报（ISUP4.0）\n # 2-MQTT(ISUP5.0) (MQTT复用TCP的端口)\n type: 2\n # 报警服务器监听地址端口\n listenIp: 192.168.1.200\n listenTcpPort: 7663\n listenUdpPort: 7662\n\n picServer:\n # 图片存储服务器地址：IUSP5.0版本接入端口建议固定为6011\n ip: 192.168.1.200\n port: 6011\n # 图片存储服务器类型：\n # 0-Tomcat\n # 1-VRB\n # 2-云存储\n # 3-KMS\n # 4-ISUP5.0\n type: 2\n # 图片存储服务器监听地址端口\n listenIp: 192.168.1.200\n listenPort: 6011\n\n # ISUP5.0登录秘钥\n isupKey: 12345678\n\n # 报警服务器打印事件模式\n # file=事件保存到文件中\n # console=事件打印在控制台上\n eventInfoPrintType: console\n\n# springdoc配置\nspringdoc:\n gatewayUrl: http://localhost:8080/${spring.application.name}\n api-docs:\n # 是否开启接口文档\n enabled: true\n info:\n # 标题\n title: \'海康isup生成接口文档\'\n # 描述\n description: \'海康isup生成接口描述\'\n # 作者信息\n contact:\n name: RuoYi\n url: https://ruoyi.vip', '95f21b60b198732b6528cadf7b504d0d', '2026-05-20 16:03:27', '2026-05-20 08:03:28', 'nacos', '172.18.0.1', 'U', 'public', '', 'formal', '', '{\"type\":\"yaml\",\"src_user\":\"nacos\"}'); INSERT INTO `his_config_info` VALUES (32, 76, 'ruoyi-haikang-isup-dev.yml', 'DEFAULT_GROUP', '', '# spring配置\nspring:\n data:\n redis:\n host: localhost\n port: 6379\n password: 123456\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: haoxin\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.haikang.isup.**.domain\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n\nhaikang-isup:\n cmsServer:\n # 注册服务器监听地址(服务器本地地址)\n ip: 192.168.1.200\n port: 7660\n\n dasServer:\n # DAS地址（此处的IP和端口与设备网页端设置的平台IP地址和端口一致）\n ip: 192.168.1.200\n port: 7660\n\n smsServer:\n # 取流服务器地址端口（公网对接填入公网地址和端口）\n ip: 192.168.1.200\n port: 7665\n # 取流服务器监听地址端口(服务器本地地址)\n listenIp: 192.168.1.200\n listenPort: 7665\n\n smsBackServer:\n # 回放流媒体服务器地址端口（公网对接填入公网地址和端口）\n ip: 192.168.1.200\n port: 8000\n # 取流服务器监听地址端口(服务器本地地址)\n listenIp: 192.168.1.200\n listenPort: 8000\n\n voiceSmsServer:\n # 语音流媒体服务器地址端口（公网对接填入公网地址和端口）\n ip: 192.168.1.200\n port: 7500\n # 语音流媒体服务器监听地址端口(服务器本地地址)\n listenIp: 192.168.1.200\n listenPort: 7500\n\n alarmServer:\n # 报警服务器地址（公网对接填入公网地址和端口）\n ip: 192.168.1.200\n tcpPort: 8003\n udpPort: 8002\n #\n alarmStorage: false\n # 报警服务器类型：\n # 0-只支持UDP协议上报\n # 1-支持UDP、TCP两种协议上报（ISUP4.0）\n # 2-MQTT(ISUP5.0) (MQTT复用TCP的端口)\n type: 2\n # 报警服务器监听地址端口\n listenIp: 192.168.1.200\n listenTcpPort: 7663\n listenUdpPort: 7662\n\n picServer:\n # 图片存储服务器地址：IUSP5.0版本接入端口建议固定为6011\n ip: 192.168.1.200\n port: 6011\n # 图片存储服务器类型：\n # 0-Tomcat\n # 1-VRB\n # 2-云存储\n # 3-KMS\n # 4-ISUP5.0\n type: 2\n # 图片存储服务器监听地址端口\n listenIp: 192.168.1.200\n listenPort: 6011\n\n # ISUP5.0登录秘钥\n isupKey: 12345678\n\n # 报警服务器打印事件模式\n # file=事件保存到文件中\n # console=事件打印在控制台上\n eventInfoPrintType: console\n\n# springdoc配置\nspringdoc:\n gatewayUrl: http://localhost:8080/${spring.application.name}\n api-docs:\n # 是否开启接口文档\n enabled: true\n info:\n # 标题\n title: \'海康isup生成接口文档\'\n # 描述\n description: \'海康isup生成接口描述\'\n # 作者信息\n contact:\n name: RuoYi\n url: https://ruoyi.vip', '64c46b95262ba54de5708f2f1d97d50a', '2026-05-20 16:29:16', '2026-05-20 08:29:17', 'nacos', '172.18.0.1', 'U', 'public', '', 'formal', '', '{\"type\":\"yaml\",\"src_user\":\"nacos\"}'); INSERT INTO `his_config_info` VALUES (34, 77, 'ruoyi-dahua-dev.yml', 'DEFAULT_GROUP', '', '# spring配置\nspring:\n data:\n redis:\n host: localhost\n port: 6379\n password: 123456\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: haoxin\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.dahua.domain\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n\n# dahua配置\ndahua:\n # [必须修改] dahua服务器的可以是内网IP也可以是公网IP\n ip: 192.168.1.200\n # [必须修改] dahua服务器的端口\n port: 9500\n # 是否公网\n isPublicNetwork: false\n # 是否监听报警\n enable-alarm-listen: false\n\n# springdoc配置\nspringdoc:\n gatewayUrl: http://localhost:8080/${spring.application.name}\n api-docs:\n # 是否开启接口文档\n enabled: true\n info:\n # 标题\n title: \'大华sdk生成接口文档\'\n # 描述\n description: \'大华sdk生成接口描述\'\n # 作者信息\n contact:\n name: RuoYi\n url: https://ruoyi.vip', '84401dec6033525000fb5f8936260ff7', '2026-05-20 19:27:25', '2026-05-20 11:27:25', 'nacos', '172.18.0.1', 'U', 'public', '', 'formal', '', '{\"type\":\"yaml\",\"src_user\":\"nacos\"}'); INSERT INTO `his_config_info` VALUES (28, 78, 'ruoyi-haikang-dev.yml', 'DEFAULT_GROUP', '', '# spring配置\nspring:\n data:\n redis:\n host: localhost\n port: 6379\n password: 123456\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: haoxin\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.haikang.domain\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n\n# springdoc配置\nspringdoc:\n gatewayUrl: http://localhost:8080/${spring.application.name}\n api-docs:\n # 是否开启接口文档\n enabled: true\n info:\n # 标题\n title: \'海康sdk生成接口文档\'\n # 描述\n description: \'海康sdk生成接口描述\'\n # 作者信息\n contact:\n name: RuoYi\n url: https://ruoyi.vip', '37dc1a92f463863bb7b518d91f9ecdb5', '2026-05-20 22:33:04', '2026-05-20 14:33:04', 'nacos', '172.18.0.1', 'U', 'public', '', 'formal', '', '{\"type\":\"yaml\",\"src_user\":\"nacos\"}'); INSERT INTO `his_config_info` VALUES (28, 79, 'ruoyi-haikang-dev.yml', 'DEFAULT_GROUP', '', '# spring配置\nspring:\n data:\n redis:\n host: localhost\n port: 6379\n password: 123456\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: haoxin\n\nhaikang:\n # 是否监听报警\n enable-alarm-listen: true\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.haikang.domain\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n\n# springdoc配置\nspringdoc:\n gatewayUrl: http://localhost:8080/${spring.application.name}\n api-docs:\n # 是否开启接口文档\n enabled: true\n info:\n # 标题\n title: \'海康sdk生成接口文档\'\n # 描述\n description: \'海康sdk生成接口描述\'\n # 作者信息\n contact:\n name: RuoYi\n url: https://ruoyi.vip', '800512884549e27737e99c7fcd865a32', '2026-05-20 22:39:12', '2026-05-20 14:39:12', 'nacos', '172.18.0.1', 'U', 'public', '', 'formal', '', '{\"type\":\"yaml\",\"src_user\":\"nacos\"}'); INSERT INTO `his_config_info` VALUES (32, 80, 'ruoyi-haikang-isup-dev.yml', 'DEFAULT_GROUP', '', '# spring配置\nspring:\n data:\n redis:\n host: localhost\n port: 6379\n password: 123456\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: haoxin\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.haikang.isup.**.domain\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n\nhaikang-isup:\n cmsServer:\n # 注册服务器监听地址(服务器本地地址)\n ip: 192.168.1.200\n port: 7660\n\n dasServer:\n # DAS地址（此处的IP和端口与设备网页端设置的平台IP地址和端口一致）\n ip: 192.168.1.200\n port: 7660\n\n smsServer:\n # 取流服务器地址端口（公网对接填入公网地址和端口）\n ip: 192.168.1.200\n port: 7665\n # 取流服务器监听地址端口(服务器本地地址)\n listenIp: 192.168.1.200\n listenPort: 7665\n\n smsBackServer:\n # 回放流媒体服务器地址端口（公网对接填入公网地址和端口）\n ip: 192.168.1.200\n port: 8000\n # 取流服务器监听地址端口(服务器本地地址)\n listenIp: 192.168.1.200\n listenPort: 8000\n\n voiceSmsServer:\n # 语音流媒体服务器地址端口（公网对接填入公网地址和端口）\n ip: 192.168.1.200\n port: 7500\n # 语音流媒体服务器监听地址端口(服务器本地地址)\n listenIp: 192.168.1.200\n listenPort: 7500\n\n alarmServer:\n # 报警服务器地址（公网对接填入公网地址和端口）\n ip: 192.168.1.200\n tcpPort: 8003\n udpPort: 8002\n #\n alarmStorage: true\n # 报警服务器类型：\n # 0-只支持UDP协议上报\n # 1-支持UDP、TCP两种协议上报（ISUP4.0）\n # 2-MQTT(ISUP5.0) (MQTT复用TCP的端口)\n type: 2\n # 报警服务器监听地址端口\n listenIp: 192.168.1.200\n listenTcpPort: 7663\n listenUdpPort: 7662\n\n picServer:\n # 图片存储服务器地址：IUSP5.0版本接入端口建议固定为6011\n ip: 192.168.1.200\n port: 6011\n # 图片存储服务器类型：\n # 0-Tomcat\n # 1-VRB\n # 2-云存储\n # 3-KMS\n # 4-ISUP5.0\n type: 2\n # 图片存储服务器监听地址端口\n listenIp: 192.168.1.200\n listenPort: 6011\n\n # ISUP5.0登录秘钥\n isupKey: 12345678\n\n # 报警服务器打印事件模式\n # file=事件保存到文件中\n # console=事件打印在控制台上\n eventInfoPrintType: console\n\n# springdoc配置\nspringdoc:\n gatewayUrl: http://localhost:8080/${spring.application.name}\n api-docs:\n # 是否开启接口文档\n enabled: true\n info:\n # 标题\n title: \'海康isup生成接口文档\'\n # 描述\n description: \'海康isup生成接口描述\'\n # 作者信息\n contact:\n name: RuoYi\n url: https://ruoyi.vip', 'ed1e1d292fd2a43d53fa76096916da53', '2026-05-20 22:39:26', '2026-05-20 14:39:26', 'nacos', '172.18.0.1', 'U', 'public', '', 'formal', '', '{\"type\":\"yaml\",\"src_user\":\"nacos\"}'); INSERT INTO `his_config_info` VALUES (34, 81, 'ruoyi-dahua-dev.yml', 'DEFAULT_GROUP', '', '# spring配置\nspring:\n data:\n redis:\n host: localhost\n port: 6379\n password: 123456\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: haoxin\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.dahua.domain\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n\n# dahua配置\ndahua:\n # [必须修改] dahua服务器的可以是内网IP也可以是公网IP\n ip: 192.168.1.200\n # [必须修改] dahua服务器的端口\n port: 9500\n # 是否公网\n isPublicNetwork: false\n # 是否监听报警\n enable-alarm-listen: true\n\n# springdoc配置\nspringdoc:\n gatewayUrl: http://localhost:8080/${spring.application.name}\n api-docs:\n # 是否开启接口文档\n enabled: true\n info:\n # 标题\n title: \'大华sdk生成接口文档\'\n # 描述\n description: \'大华sdk生成接口描述\'\n # 作者信息\n contact:\n name: RuoYi\n url: https://ruoyi.vip', '972432802f79c4f864ccbd2ba6a099d9', '2026-05-20 22:39:35', '2026-05-20 14:39:35', 'nacos', '172.18.0.1', 'U', 'public', '', 'formal', '', '{\"type\":\"yaml\",\"src_user\":\"nacos\"}'); INSERT INTO `his_config_info` VALUES (10, 82, 'application-dev.yml', 'DEFAULT_GROUP', '', 'spring:\n autoconfigure:\n exclude: com.alibaba.druid.spring.boot3.autoconfigure.DruidDataSourceAutoConfigure\n\n# feign 配置\nfeign:\n sentinel:\n enabled: true\n okhttp:\n enabled: true\n httpclient:\n enabled: false\n client:\n config:\n default:\n connectTimeout: 10000\n readTimeout: 10000\n compression:\n request:\n enabled: true\n min-request-size: 8192\n response:\n enabled: true\n\n# 本地文件上传 \nfile:\n domain: http://127.0.0.1:9300\n path: D:/ruoyi/uploadPath\n prefix: /statics\n\n#zlm 默认服务器配置\nmedia:\n id: hxkj_zlm\n # [必须修改] zlm服务器的内网IP\n ip: 192.168.1.200\n # [必须修改] zlm服务器的http.port\n http-port: 8092\n http-ssl-port: 443\n # [可选] zlm服务器的hook所使用的IP, 默认使用sip.ip\n hook-ip: 192.168.1.200\n # [必选选] zlm服务器的hook.admin_params=secret\n secret: hxkj_zlm\n # # [可选] 录像文件存储路径\n # record-path: F:/zml/record\n # [可选] 录像保存时间,单位是天\n record-day: 3\n # 启用多端口模式, 多端口模式使用端口区分每路流，兼容性更好。 单端口使用流的ssrc区分， 点播超时建议使用多端口测试\n rtp:\n # [可选] 在此范围内选择端口用于媒体流传输, 必须提前在zlm上配置该属性，不然自动配置此属性可能不成功\n port-range: 30500,40500 # 端口范围\n # [可选] 国标级联在此范围内选择端口发送媒体流,\n send-port-range: 30000,30500 # 端口范围\n\n# 暴露监控端点\nmanagement:\n endpoints:\n web:\n exposure:\n include: \'*\'\n', 'fdbd9c7d0c8d698f136895d6019c616a', '2026-05-29 12:41:14', '2026-05-29 04:41:14', 'nacos', '172.18.0.1', 'U', 'public', '', 'formal', '', '{\"type\":\"yaml\",\"src_user\":\"nacos\",\"c_desc\":\"通用配置\"}'); INSERT INTO `his_config_info` VALUES (32, 83, 'ruoyi-haikang-isup-dev.yml', 'DEFAULT_GROUP', '', '# spring配置\nspring:\n data:\n redis:\n host: localhost\n port: 6379\n password: 123456\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: haoxin\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.haikang.isup.**.domain\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n\nhaikang-isup:\n cmsServer:\n # 注册服务器监听地址(服务器本地地址)\n ip: 192.168.1.200\n port: 7660\n\n dasServer:\n # DAS地址（此处的IP和端口与设备网页端设置的平台IP地址和端口一致）\n ip: 192.168.1.200\n port: 7660\n\n smsServer:\n # 取流服务器地址端口（公网对接填入公网地址和端口）\n ip: 192.168.1.200\n port: 7665\n # 取流服务器监听地址端口(服务器本地地址)\n listenIp: 192.168.1.200\n listenPort: 7665\n\n smsBackServer:\n # 回放流媒体服务器地址端口（公网对接填入公网地址和端口）\n ip: 192.168.1.200\n port: 8000\n # 取流服务器监听地址端口(服务器本地地址)\n listenIp: 192.168.1.200\n listenPort: 8000\n\n voiceSmsServer:\n # 语音流媒体服务器地址端口（公网对接填入公网地址和端口）\n ip: 192.168.1.200\n port: 7500\n # 语音流媒体服务器监听地址端口(服务器本地地址)\n listenIp: 192.168.1.200\n listenPort: 7500\n\n alarmServer:\n # 报警服务器地址（公网对接填入公网地址和端口）\n ip: 192.168.1.200\n tcpPort: 8003\n udpPort: 8002\n #\n alarmStorage: false\n # 报警服务器类型：\n # 0-只支持UDP协议上报\n # 1-支持UDP、TCP两种协议上报（ISUP4.0）\n # 2-MQTT(ISUP5.0) (MQTT复用TCP的端口)\n type: 2\n # 报警服务器监听地址端口\n listenIp: 192.168.1.200\n listenTcpPort: 7663\n listenUdpPort: 7662\n\n picServer:\n # 图片存储服务器地址：IUSP5.0版本接入端口建议固定为6011\n ip: 192.168.1.200\n port: 6011\n # 图片存储服务器类型：\n # 0-Tomcat\n # 1-VRB\n # 2-云存储\n # 3-KMS\n # 4-ISUP5.0\n type: 2\n # 图片存储服务器监听地址端口\n listenIp: 192.168.1.200\n listenPort: 6011\n\n # ISUP5.0登录秘钥\n isupKey: 12345678\n\n # 报警服务器打印事件模式\n # file=事件保存到文件中\n # console=事件打印在控制台上\n eventInfoPrintType: console\n\n# springdoc配置\nspringdoc:\n gatewayUrl: http://localhost:8080/${spring.application.name}\n api-docs:\n # 是否开启接口文档\n enabled: true\n info:\n # 标题\n title: \'海康isup生成接口文档\'\n # 描述\n description: \'海康isup生成接口描述\'\n # 作者信息\n contact:\n name: RuoYi\n url: https://ruoyi.vip', '64c46b95262ba54de5708f2f1d97d50a', '2026-05-29 12:42:46', '2026-05-29 04:42:46', 'nacos', '172.18.0.1', 'U', 'public', '', 'formal', '', '{\"type\":\"yaml\",\"src_user\":\"nacos\"}'); INSERT INTO `his_config_info` VALUES (34, 84, 'ruoyi-dahua-dev.yml', 'DEFAULT_GROUP', '', '# spring配置\nspring:\n data:\n redis:\n host: localhost\n port: 6379\n password: 123456\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: haoxin\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.dahua.domain\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n\n# dahua配置\ndahua:\n # [必须修改] dahua服务器的可以是内网IP也可以是公网IP\n ip: 192.168.1.200\n # [必须修改] dahua服务器的端口\n port: 9500\n # 是否公网\n isPublicNetwork: false\n # 是否监听报警\n enable-alarm-listen: false\n\n# springdoc配置\nspringdoc:\n gatewayUrl: http://localhost:8080/${spring.application.name}\n api-docs:\n # 是否开启接口文档\n enabled: true\n info:\n # 标题\n title: \'大华sdk生成接口文档\'\n # 描述\n description: \'大华sdk生成接口描述\'\n # 作者信息\n contact:\n name: RuoYi\n url: https://ruoyi.vip', '84401dec6033525000fb5f8936260ff7', '2026-05-29 12:42:56', '2026-05-29 04:42:57', 'nacos', '172.18.0.1', 'U', 'public', '', 'formal', '', '{\"type\":\"yaml\",\"src_user\":\"nacos\"}'); INSERT INTO `his_config_info` VALUES (40, 85, 'ruoyi-gb28181-dev.yml', 'DEFAULT_GROUP', '', '# spring配置\nspring:\n data:\n redis:\n host: localhost\n port: 6379\n password: 123456\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: haoxin\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.gb28181.**.domain\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n\n# 作为28181服务器的配置\nsip:\n ip: 0.0.0.0,192.168.1.200\n # [可选] 28181服务监听的端口\n port: 8116\n # 根据国标6.1.2中规定，domain宜采用ID统一编码的前十位编码。国标附录D中定义前8位为中心编码（由省级、市级、区级、基层编号组成，参照GB/T 2260-2007）\n # 后两位为行业编码，定义参照附录D.3\n # 3701020049标识山东济南历下区 信息行业接入\n # [可选]\n domain: 4101050000\n # [可选]\n id: 41010500002000000001\n # [可选] 默认设备认证密码，后续扩展使用设备单独密码, 移除密码将不进行校验\n password: 12345678\n\n# springdoc配置\nspringdoc:\n gatewayUrl: http://localhost:8080/${spring.application.name}\n api-docs:\n # 是否开启接口文档\n enabled: true\n info:\n # 标题\n title: \'国标28181生成接口文档\'\n # 描述\n description: \'国标28181生成接口描述\'\n # 作者信息\n contact:\n name: RuoYi\n url: https://ruoyi.vip', '7cca6846ff88e0a475953bb63f9b5dfc', '2026-05-29 12:43:21', '2026-05-29 04:43:22', 'nacos', '172.18.0.1', 'U', 'public', '', 'formal', '', '{\"type\":\"yaml\",\"src_user\":\"nacos\",\"c_desc\":\"国标28181配置\"}'); -- ---------------------------- -- Table structure for permissions -- ---------------------------- DROP TABLE IF EXISTS `permissions`; CREATE TABLE `permissions` ( `role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'role', `resource` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'resource', `action` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'action', UNIQUE INDEX `uk_role_permission`(`role`, `resource`, `action`) 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 COMMENT 'username', `role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'role', UNIQUE INDEX `idx_user_role`(`username`, `role`) 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(20) 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(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '配额，0表示使用默认值', `usage` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '使用量', `max_size` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '单个配置大小上限，单位为字节，0表示使用默认值', `max_aggr_count` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '聚合子配置最大个数', `max_aggr_size` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '单个聚合数据的子配置大小上限，单位为字节，0表示使用默认值', `max_history_count` int(10) 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`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '租户容量信息表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of tenant_capacity -- ---------------------------- INSERT INTO `tenant_capacity` VALUES (1, 'public', 0, 17, 0, 0, 0, 0, '2026-03-27 06:18:58', '2026-05-30 16:33:22'); -- ---------------------------- -- Table structure for tenant_info -- ---------------------------- DROP TABLE IF EXISTS `tenant_info`; CREATE TABLE `tenant_info` ( `id` bigint(20) 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(20) NOT NULL COMMENT '创建时间', `gmt_modified` bigint(20) NOT NULL COMMENT '修改时间', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_tenant_info_kptenantid`(`kp`, `tenant_id`) USING BTREE, INDEX `idx_tenant_id`(`tenant_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'tenant_info' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of tenant_info -- ---------------------------- -- ---------------------------- -- Table structure for users -- ---------------------------- DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'username', `password` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'password', `enabled` tinyint(1) NOT NULL COMMENT 'enabled', 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;