01-ry-config.sql 103 KB

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