ry-config.sql 103 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367
  1. /*
  2. Navicat Premium Data Transfer
  3. Source Server : 本地
  4. Source Server Type : MySQL
  5. Source Server Version : 50744
  6. Source Host : 127.0.0.1:3306
  7. Source Schema : ry-config
  8. Target Server Type : MySQL
  9. Target Server Version : 50744
  10. File Encoding : 65001
  11. Date: 31/05/2026 21:53:45
  12. */
  13. SET NAMES utf8mb4;
  14. SET FOREIGN_KEY_CHECKS = 0;
  15. -- ----------------------------
  16. -- Table structure for config_info
  17. -- ----------------------------
  18. DROP TABLE IF EXISTS `config_info`;
  19. CREATE TABLE `config_info` (
  20. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  21. `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id',
  22. `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'group_id',
  23. `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'content',
  24. `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'md5',
  25. `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  26. `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  27. `src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT 'source user',
  28. `src_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'source ip',
  29. `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'app_name',
  30. `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT '租户字段',
  31. `c_desc` varchar(256) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'configuration description',
  32. `c_use` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'configuration usage',
  33. `effect` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '配置生效的描述',
  34. `type` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '配置的类型',
  35. `c_schema` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT '配置的模式',
  36. `encrypted_data_key` varchar(1024) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '密钥',
  37. PRIMARY KEY (`id`) USING BTREE,
  38. UNIQUE INDEX `uk_configinfo_datagrouptenant`(`data_id`, `group_id`, `tenant_id`) USING BTREE
  39. ) ENGINE = InnoDB AUTO_INCREMENT = 43 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'config_info' ROW_FORMAT = DYNAMIC;
  40. -- ----------------------------
  41. -- Records of config_info
  42. -- ----------------------------
  43. 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, '');
  44. 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, '');
  45. 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, '');
  46. 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', '', '');
  47. 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, '');
  48. 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, '');
  49. 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, '');
  50. 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, '');
  51. 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, '');
  52. 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, '');
  53. 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, '');
  54. 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, '');
  55. 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, '');
  56. 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, '');
  57. 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, '');
  58. 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, '');
  59. 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, '');
  60. 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, '');
  61. 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, '');
  62. 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, '');
  63. 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, '');
  64. 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, '');
  65. 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, '');
  66. 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, '');
  67. 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, '');
  68. 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, '');
  69. 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, '');
  70. 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, '');
  71. 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, '');
  72. 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, '');
  73. 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, '');
  74. 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, '');
  75. 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, '');
  76. 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, '');
  77. -- ----------------------------
  78. -- Table structure for config_info_aggr
  79. -- ----------------------------
  80. DROP TABLE IF EXISTS `config_info_aggr`;
  81. CREATE TABLE `config_info_aggr` (
  82. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  83. `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id',
  84. `group_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'group_id',
  85. `datum_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'datum_id',
  86. `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '内容',
  87. `gmt_modified` datetime NOT NULL COMMENT '修改时间',
  88. `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  89. `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT '租户字段',
  90. PRIMARY KEY (`id`) USING BTREE,
  91. UNIQUE INDEX `uk_configinfoaggr_datagrouptenantdatum`(`data_id`, `group_id`, `tenant_id`, `datum_id`) USING BTREE
  92. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '增加租户字段' ROW_FORMAT = DYNAMIC;
  93. -- ----------------------------
  94. -- Records of config_info_aggr
  95. -- ----------------------------
  96. -- ----------------------------
  97. -- Table structure for config_info_beta
  98. -- ----------------------------
  99. DROP TABLE IF EXISTS `config_info_beta`;
  100. CREATE TABLE `config_info_beta` (
  101. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  102. `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id',
  103. `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'group_id',
  104. `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'app_name',
  105. `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'content',
  106. `beta_ips` varchar(1024) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'betaIps',
  107. `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'md5',
  108. `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  109. `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  110. `src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT 'source user',
  111. `src_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'source ip',
  112. `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT '租户字段',
  113. `encrypted_data_key` varchar(1024) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '密钥',
  114. PRIMARY KEY (`id`) USING BTREE,
  115. UNIQUE INDEX `uk_configinfobeta_datagrouptenant`(`data_id`, `group_id`, `tenant_id`) USING BTREE
  116. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'config_info_beta' ROW_FORMAT = DYNAMIC;
  117. -- ----------------------------
  118. -- Records of config_info_beta
  119. -- ----------------------------
  120. -- ----------------------------
  121. -- Table structure for config_info_gray
  122. -- ----------------------------
  123. DROP TABLE IF EXISTS `config_info_gray`;
  124. CREATE TABLE `config_info_gray` (
  125. `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id',
  126. `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'data_id',
  127. `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'group_id',
  128. `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'content',
  129. `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'md5',
  130. `src_user` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT 'src_user',
  131. `src_ip` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'src_ip',
  132. `gmt_create` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT 'gmt_create',
  133. `gmt_modified` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT 'gmt_modified',
  134. `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'app_name',
  135. `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT 'tenant_id',
  136. `gray_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'gray_name',
  137. `gray_rule` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'gray_rule',
  138. `encrypted_data_key` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'encrypted_data_key',
  139. PRIMARY KEY (`id`) USING BTREE,
  140. UNIQUE INDEX `uk_configinfogray_datagrouptenantgray`(`data_id`, `group_id`, `tenant_id`, `gray_name`) USING BTREE,
  141. INDEX `idx_dataid_gmt_modified`(`data_id`, `gmt_modified`) USING BTREE,
  142. INDEX `idx_gmt_modified`(`gmt_modified`) USING BTREE
  143. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'config_info_gray' ROW_FORMAT = DYNAMIC;
  144. -- ----------------------------
  145. -- Records of config_info_gray
  146. -- ----------------------------
  147. -- ----------------------------
  148. -- Table structure for config_info_tag
  149. -- ----------------------------
  150. DROP TABLE IF EXISTS `config_info_tag`;
  151. CREATE TABLE `config_info_tag` (
  152. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  153. `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id',
  154. `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'group_id',
  155. `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT 'tenant_id',
  156. `tag_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'tag_id',
  157. `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'app_name',
  158. `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'content',
  159. `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'md5',
  160. `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  161. `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  162. `src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT 'source user',
  163. `src_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'source ip',
  164. PRIMARY KEY (`id`) USING BTREE,
  165. UNIQUE INDEX `uk_configinfotag_datagrouptenanttag`(`data_id`, `group_id`, `tenant_id`, `tag_id`) USING BTREE
  166. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'config_info_tag' ROW_FORMAT = DYNAMIC;
  167. -- ----------------------------
  168. -- Records of config_info_tag
  169. -- ----------------------------
  170. -- ----------------------------
  171. -- Table structure for config_tags_relation
  172. -- ----------------------------
  173. DROP TABLE IF EXISTS `config_tags_relation`;
  174. CREATE TABLE `config_tags_relation` (
  175. `id` bigint(20) NOT NULL COMMENT 'id',
  176. `tag_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'tag_name',
  177. `tag_type` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'tag_type',
  178. `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id',
  179. `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'group_id',
  180. `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT 'tenant_id',
  181. `nid` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'nid, 自增长标识',
  182. PRIMARY KEY (`nid`) USING BTREE,
  183. UNIQUE INDEX `uk_configtagrelation_configidtag`(`id`, `tag_name`, `tag_type`) USING BTREE,
  184. INDEX `idx_tenant_id`(`tenant_id`) USING BTREE
  185. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'config_tag_relation' ROW_FORMAT = DYNAMIC;
  186. -- ----------------------------
  187. -- Records of config_tags_relation
  188. -- ----------------------------
  189. -- ----------------------------
  190. -- Table structure for group_capacity
  191. -- ----------------------------
  192. DROP TABLE IF EXISTS `group_capacity`;
  193. CREATE TABLE `group_capacity` (
  194. `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  195. `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'Group ID,空字符表示整个集群',
  196. `quota` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '配额,0表示使用默认值',
  197. `usage` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '使用量',
  198. `max_size` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '单个配置大小上限,单位为字节,0表示使用默认值',
  199. `max_aggr_count` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '聚合子配置最大个数,,0表示使用默认值',
  200. `max_aggr_size` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '单个聚合数据的子配置大小上限,单位为字节,0表示使用默认值',
  201. `max_history_count` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最大变更历史数量',
  202. `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  203. `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  204. PRIMARY KEY (`id`) USING BTREE,
  205. UNIQUE INDEX `uk_group_id`(`group_id`) USING BTREE
  206. ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '集群、各Group容量信息表' ROW_FORMAT = DYNAMIC;
  207. -- ----------------------------
  208. -- Records of group_capacity
  209. -- ----------------------------
  210. INSERT INTO `group_capacity` VALUES (1, '', 0, 34, 0, 0, 0, 0, '2026-03-27 06:18:58', '2026-05-30 16:33:21');
  211. -- ----------------------------
  212. -- Table structure for his_config_info
  213. -- ----------------------------
  214. DROP TABLE IF EXISTS `his_config_info`;
  215. CREATE TABLE `his_config_info` (
  216. `id` bigint(20) UNSIGNED NOT NULL COMMENT 'id',
  217. `nid` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'nid, 自增标识',
  218. `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id',
  219. `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'group_id',
  220. `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'app_name',
  221. `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'content',
  222. `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'md5',
  223. `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  224. `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  225. `src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT 'source user',
  226. `src_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'source ip',
  227. `op_type` char(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'operation type',
  228. `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT '租户字段',
  229. `encrypted_data_key` varchar(1024) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '密钥',
  230. `publish_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT 'formal' COMMENT 'publish type gray or formal',
  231. `gray_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'gray name',
  232. `ext_info` longtext CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT 'ext info',
  233. PRIMARY KEY (`nid`) USING BTREE,
  234. INDEX `idx_gmt_create`(`gmt_create`) USING BTREE,
  235. INDEX `idx_gmt_modified`(`gmt_modified`) USING BTREE,
  236. INDEX `idx_did`(`data_id`) USING BTREE
  237. ) ENGINE = InnoDB AUTO_INCREMENT = 86 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '多租户改造' ROW_FORMAT = DYNAMIC;
  238. -- ----------------------------
  239. -- Records of his_config_info
  240. -- ----------------------------
  241. 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\"}');
  242. 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\"}');
  243. 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\"}');
  244. 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\"}');
  245. 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\"}');
  246. 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\"}');
  247. 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\"}');
  248. 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\"}');
  249. 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\"}');
  250. 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\":\"通用配置\"}');
  251. 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\"}');
  252. 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\"}');
  253. 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配置\"}');
  254. -- ----------------------------
  255. -- Table structure for permissions
  256. -- ----------------------------
  257. DROP TABLE IF EXISTS `permissions`;
  258. CREATE TABLE `permissions` (
  259. `role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'role',
  260. `resource` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'resource',
  261. `action` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'action',
  262. UNIQUE INDEX `uk_role_permission`(`role`, `resource`, `action`) USING BTREE
  263. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
  264. -- ----------------------------
  265. -- Records of permissions
  266. -- ----------------------------
  267. -- ----------------------------
  268. -- Table structure for roles
  269. -- ----------------------------
  270. DROP TABLE IF EXISTS `roles`;
  271. CREATE TABLE `roles` (
  272. `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'username',
  273. `role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'role',
  274. UNIQUE INDEX `idx_user_role`(`username`, `role`) USING BTREE
  275. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
  276. -- ----------------------------
  277. -- Records of roles
  278. -- ----------------------------
  279. INSERT INTO `roles` VALUES ('nacos', 'ROLE_ADMIN');
  280. -- ----------------------------
  281. -- Table structure for tenant_capacity
  282. -- ----------------------------
  283. DROP TABLE IF EXISTS `tenant_capacity`;
  284. CREATE TABLE `tenant_capacity` (
  285. `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  286. `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'Tenant ID',
  287. `quota` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '配额,0表示使用默认值',
  288. `usage` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '使用量',
  289. `max_size` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '单个配置大小上限,单位为字节,0表示使用默认值',
  290. `max_aggr_count` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '聚合子配置最大个数',
  291. `max_aggr_size` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '单个聚合数据的子配置大小上限,单位为字节,0表示使用默认值',
  292. `max_history_count` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最大变更历史数量',
  293. `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  294. `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  295. PRIMARY KEY (`id`) USING BTREE,
  296. UNIQUE INDEX `uk_tenant_id`(`tenant_id`) USING BTREE
  297. ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '租户容量信息表' ROW_FORMAT = DYNAMIC;
  298. -- ----------------------------
  299. -- Records of tenant_capacity
  300. -- ----------------------------
  301. 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');
  302. -- ----------------------------
  303. -- Table structure for tenant_info
  304. -- ----------------------------
  305. DROP TABLE IF EXISTS `tenant_info`;
  306. CREATE TABLE `tenant_info` (
  307. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  308. `kp` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'kp',
  309. `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT 'tenant_id',
  310. `tenant_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT 'tenant_name',
  311. `tenant_desc` varchar(256) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'tenant_desc',
  312. `create_source` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'create_source',
  313. `gmt_create` bigint(20) NOT NULL COMMENT '创建时间',
  314. `gmt_modified` bigint(20) NOT NULL COMMENT '修改时间',
  315. PRIMARY KEY (`id`) USING BTREE,
  316. UNIQUE INDEX `uk_tenant_info_kptenantid`(`kp`, `tenant_id`) USING BTREE,
  317. INDEX `idx_tenant_id`(`tenant_id`) USING BTREE
  318. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'tenant_info' ROW_FORMAT = DYNAMIC;
  319. -- ----------------------------
  320. -- Records of tenant_info
  321. -- ----------------------------
  322. -- ----------------------------
  323. -- Table structure for users
  324. -- ----------------------------
  325. DROP TABLE IF EXISTS `users`;
  326. CREATE TABLE `users` (
  327. `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'username',
  328. `password` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'password',
  329. `enabled` tinyint(1) NOT NULL COMMENT 'enabled',
  330. PRIMARY KEY (`username`) USING BTREE
  331. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
  332. -- ----------------------------
  333. -- Records of users
  334. -- ----------------------------
  335. INSERT INTO `users` VALUES ('nacos', '$2a$10$EuWPZHzz32dJN7jexM34MOeYirDdFAZm2kuWj7VEOJhhZkDrxfvUu', 1);
  336. SET FOREIGN_KEY_CHECKS = 1;