yystopf
/
microservices
forked from Gitlink/microservices
0
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
microservices/docker-gitlink/nacos/sql/default_gitlink-nacos-confi...

425 lines
52 KiB
SQL
Executable File
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for config_info
-- ----------------------------
DROP TABLE IF EXISTS `config_info`;
CREATE TABLE `config_info`
(
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
`data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id',
`group_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
`content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'content',
`md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'md5',
`gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
`src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT 'source user',
`src_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'source ip',
`app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
`tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT '租户字段',
`c_desc` varchar(256) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
`c_use` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
`effect` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
`type` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
`c_schema` text CHARACTER SET utf8 COLLATE utf8_bin NULL,
`encrypted_data_key` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT '秘钥',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `uk_configinfo_datagrouptenant` (`data_id`, `group_id`, `tenant_id`) USING BTREE
) ENGINE = InnoDB
AUTO_INCREMENT = 55
CHARACTER SET = utf8
COLLATE = utf8_bin COMMENT = 'config_info'
ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of config_info
-- ----------------------------
INSERT INTO `config_info`
VALUES (1, 'application-prod.yml', 'DEFAULT_GROUP',
'spring:\n autoconfigure:\n exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure\n mvc:\n pathmatch:\n matching-strategy: ant_path_matcher\n servlet:\n multipart:\n max-file-size: 100MB\n max-request-size: 100MB\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 response:\n enabled: true\n\n# 暴露监控端点\nmanagement:\n endpoints:\n web:\n exposure:\n include: \'*\'\n\nhttp:\n #最大连接数\n maxTotal: 100\n #并发数\n defaultMaxPerRoute: 20\n #创建连接的最长时间\n connectTimeout: 1000\n #从连接池中获取到连接的最长时间\n connectionRequestTimeout: 500\n #数据传输的最长时间\n socketTimeout: 10000\n #提交请求前测试连接是否可用\n staleConnectionCheckEnabled: true\n #gitlink请求地址\n gitLinkUrl: #cms_gitLinkUrl\n #网关请求地址\n gatewayUrl: #gatewayUrl\n\nswagger:\n host: #gatewayUrl/api\n\ngitlink:\n admin_user:\n username: #gitlinkAdminUsername\n password: #gitlinkAdminPassword\n client_id: #gitlinkClientId\n client_secret: #gitlinkClientSecret\n',
'5f9b789aa22c2418a629ca812a0b6176', '2020-05-20 12:00:00', '2023-12-08 09:24:50', 'nacos', '172.18.0.1', '', '',
'通用配置', 'null', 'null', 'yaml', '', '');
INSERT INTO `config_info`
VALUES (2, 'ruoyi-gateway-prod.yml', 'DEFAULT_GROUP',
'spring:\n redis:\n host: #redis_ip\n port: #redis_port\n password:\n cloud:\n gateway:\n globalcors: #跨域问题\n cors-configurations:\n \'[/**]\':\n allowedOriginPatterns:\n - \"*\"\n allowedHeaders:\n - \"*\"\n allowCredentials: true\n maxAge: 360000\n allowedMethods:\n - GET\n - POST\n - DELETE\n - PUT\n - OPTIONS\n - HEAD\n discovery:\n locator:\n lowerCaseServiceId: true\n enabled: true\n routes:\n # 认证中心\n - id: ruoyi-auth\n uri: lb://ruoyi-auth\n predicates:\n - Path=/auth/**\n filters:\n # 验证码处理\n - CacheRequestFilter\n - ValidateCodeFilter\n - StripPrefix=1\n # 代码生成\n - id: ruoyi-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 # 内容管理服务\n - id: ruoyi-cms\n uri: lb://ruoyi-cms\n predicates:\n - Path=/cms/**\n filters:\n - StripPrefix=1\n \n # 特色专区服务\n - id: ruoyi-zone\n uri: lb://ruoyi-zone\n predicates:\n - Path=/zone/**\n filters:\n - StripPrefix=1\n\n # 项目管理服务\n - id: ruoyi-pms\n uri: lb://ruoyi-pms\n predicates:\n - Path=/pms/**\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 ignore:\n whites:\n - /auth/logout\n - /auth/login\n - /auth/register\n - /*/v2/api-docs\n - /csrf\n - /profile/**\n - /cms/blog/cms/**\n - /cms/message/cms/**\n - /cms/comment/cms/**\n - /file/statics/**\n - /cms/doc/open/**\n - /zone/open/**\n - /file/open/**\n',
'22aff6c040e82ae8ad57a83170ffc15d', '2020-05-14 14:17:55', '2023-12-07 15:06:06', 'nacos', '172.18.0.1', '', '',
'网关模块', 'null', 'null', 'yaml', '', '');
INSERT INTO `config_info`
VALUES (3, 'ruoyi-auth-prod.yml', 'DEFAULT_GROUP',
'spring:\n redis:\n host: #redis_ip\n port: #redis_port\n password:\n',
'fa91c345f1bf98f36d1f4d6fe24cb925', '2020-11-20 00:00:00', '2023-04-26 16:27:42', 'nacos', '172.18.0.1', '', '',
'认证中心', 'null', 'null', 'yaml', '', '');
INSERT INTO `config_info`
VALUES (5, 'ruoyi-system-prod.yml', 'DEFAULT_GROUP',
'# spring配置\nspring:\n redis:\n host: #redis_ip\n port: #redis_port\n password:\n datasource:\n druid:\n stat-view-servlet:\n enabled: true\n loginUsername: admin\n loginPassword: 123456\n dynamic:\n druid:\n initial-size: 5\n min-idle: 5\n maxActive: 20\n maxWait: 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://#db_url/#db_name?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: #db_username\n password: #db_password\n # 从库数据源\n slave:\n username: #gitlink_db_username\n password: #gitlink_db_password\n url: jdbc:mysql://#gitlink_db_url/#gitlink_db_name?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n driver-class-name: com.mysql.cj.jdbc.Driver\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.system\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n configuration:\n log-impl: org.apache.ibatis.logging.stdout.StdOutImpl\n\n# swagger配置\nswagger:\n title: 系统模块接口文档\n license: Powered By ruoyi\n licenseUrl: https://ruoyi.vip',
'0530f34dae0dd2f3d905b66334e438a2', '2020-11-20 00:00:00', '2023-04-26 16:28:09', 'nacos', '172.18.0.1', '', '',
'系统模块', 'null', 'null', 'yaml', '', '');
INSERT INTO `config_info`
VALUES (7, 'ruoyi-job-prod.yml', 'DEFAULT_GROUP',
'# spring配置\nspring:\n redis:\n host: #redis_ip\n port: #redis_port\n password: \n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://#db_url/#db_name?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: #db_username\n password: #db_password\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.job.domain\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n\n# swagger配置\nswagger:\n title: 定时任务接口文档\n license: Powered By ruoyi\n licenseUrl: https://ruoyi.vip\n',
'70213ed62c6a9fc42cd652c11556483e', '2020-11-20 00:00:00', '2023-04-26 16:28:25', 'nacos', '172.18.0.1', '', '',
'定时任务', 'null', 'null', 'yaml', '', '');
INSERT INTO `config_info`
VALUES (8, 'ruoyi-file-prod.yml', 'DEFAULT_GROUP',
'# 本地文件上传 \nfile:\n domain: #file_url\n path: #file_path\n prefix: /statics\n # 允许的文件后缀(该格式允许通过静态资源直接访问)\n allowedExtension: gif,jfif,svg,webp,bmp,gif,jpg,jpeg,png\n # cms允许的文件后缀\n cmsAllowedExtension: gif,jfif,svg,webp,bmp,gif,jpg,jpeg,png,mp4,avi,rmvb,mov,wmv,flv,webm,mkv\n # 允许的最大文件大小（单位MB）\n maxSize: 200\n # 文件名最大长度\n maxNameSize: 100\n\n# FastDFS配置\nfdfs:\n domain: http://8.129.231.12\n soTimeout: 3000\n connectTimeout: 2000\n trackerList: 8.129.231.12:22122\n\n# Minio配置\nminio:\n url: http://8.129.231.12:9000\n accessKey: minioadmin\n secretKey: minioadmin\n bucketName: test\n# spring配置\nspring:\n redis:\n host: #redis_ip\n port: #redis_port\n password:\n datasource:\n druid:\n stat-view-servlet:\n enabled: true\n loginUsername: admin\n loginPassword: 123456\n dynamic:\n druid:\n initial-size: 5\n min-idle: 5\n maxActive: 20\n maxWait: 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://#db_url/#db_name?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: #db_username\n password: #db_password\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.file\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n configuration:\n log-impl: org.apache.ibatis.logging.stdout.StdOutImpl',
'a63f9934c3961d24333cb58592457d6a', '2020-11-20 00:00:00', '2023-12-07 15:08:54', 'nacos', '172.18.0.1', '', '',
'文件服务', 'null', 'null', 'yaml', '', '');
INSERT INTO `config_info`
VALUES (9, 'sentinel-ruoyi-gateway', 'DEFAULT_GROUP',
'[\r\n {\r\n \"resource\": \"ruoyi-auth\",\r\n \"count\": 500,\r\n \"grade\": 1,\r\n \"limitApp\": \"default\",\r\n \"strategy\": 0,\r\n \"controlBehavior\": 0\r\n },\r\n {\r\n \"resource\": \"ruoyi-system\",\r\n \"count\": 1000,\r\n \"grade\": 1,\r\n \"limitApp\": \"default\",\r\n \"strategy\": 0,\r\n \"controlBehavior\": 0\r\n },\r\n {\r\n \"resource\": \"ruoyi-gen\",\r\n \"count\": 200,\r\n \"grade\": 1,\r\n \"limitApp\": \"default\",\r\n \"strategy\": 0,\r\n \"controlBehavior\": 0\r\n },\r\n {\r\n \"resource\": \"ruoyi-job\",\r\n \"count\": 300,\r\n \"grade\": 1,\r\n \"limitApp\": \"default\",\r\n \"strategy\": 0,\r\n \"controlBehavior\": 0\r\n }\r\n]',
'9f3a3069261598f74220bc47958ec252', '2020-11-20 00:00:00', '2020-11-20 00:00:00', NULL, '0:0:0:0:0:0:0:1', '',
'', '限流策略', 'null', 'null', 'json', NULL, '');
INSERT INTO `config_info`
VALUES (14, 'ruoyi-cms-prod.yml', 'DEFAULT_GROUP',
'# spring配置\nspring:\n redis:\n host: #redis_ip\n port: #redis_port\n password:\n datasource:\n druid:\n stat-view-servlet:\n enabled: true\n loginUsername: admin\n loginPassword: 123456\n dynamic:\n druid:\n initial-size: 5\n min-idle: 5\n maxActive: 20\n maxWait: 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://#db_url/#db_name?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: #db_username\n password: #db_password\n # 从库数据源\n # slave:\n # username: root\n # password: Trust_#%01\n # url: jdbc:mysql://173.15.15.83:3306/testjunkenewweb?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n # driver-class-name: com.mysql.cj.jdbc.Driver\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.cms\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n configuration:\n log-impl: org.apache.ibatis.logging.stdout.StdOutImpl\n\n# swagger配置\nswagger:\n title: 内容管理模块接口文档\n license: Powered By ruoyi\n licenseUrl: https://ruoyi.vip\n\ncms:\n summaryMaxLength: #cms_summaryMaxLength\n gitLinkOrganization: #cms_gitLinkOrganization\n #专区资讯详情路由\n detailPath: #cmsDetailPath\n',
'7107b9b8e369432a754cfd7ac8d0fdcd', '2023-03-21 14:26:45', '2023-12-07 15:09:25', 'nacos', '172.18.0.1', '', '',
'', '', '', 'yaml', '', '');
INSERT INTO `config_info`
VALUES (45, 'ruoyi-zone-prod.yml', 'DEFAULT_GROUP',
'# spring配置\nspring:\n redis:\n host: #redis_ip\n port: #redis_port\n password:\n datasource:\n druid:\n stat-view-servlet:\n enabled: true\n loginUsername: admin\n loginPassword: 123456\n dynamic:\n druid:\n initial-size: 5\n min-idle: 5\n maxActive: 20\n maxWait: 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://#db_url/#db_name?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: #db_username\n password: #db_password\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.zone\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n configuration:\n log-impl: org.apache.ibatis.logging.stdout.StdOutImpl\n\n# swagger配置\nswagger:\n title: 内容管理模块接口文档\n license: Powered By ruoyi\n licenseUrl: https://ruoyi.vip\n\nzone:\n #邀请链接有效时长（单位：天）\n invitationLinkExpirationTime: #invitationLinkExpirationTime\n #邀请确认页面\n invitationPagePath: #invitationPagePath\n #消息模板\n messageTemplate: #messageTemplate\n #会员加入失败消息模板\n memberMessageTemplate: #memberMessageTemplate\n #专区管理地址\n zoneAdminUrl: #zoneAdminUrl\n #专区首页前缀\n zoneHomepagePath: #zoneHomepagePath\n #专区会员后缀\n zoneMemberPath: #zoneMemberPath\n #后台管理地址\n adminUrl: #adminUrl\n #专区配置地址\n zoneConfigurationUrl: #zoneConfigurationUrl\n #专区资讯管理地址\n docManageUrl: #docManageUrl\n #专区资源管理地址\n resourceManageUrl: #resourceManageUrl\n #专区初始化数据\n initData:\n #项目聚合中，GitLink项目Id\n gitlinkProjectId: #gitlinkProjectId\n #会员聚合中，gitlink用户名\n gitLinkUserName1: #gitLinkUserName1\n gitLinkUserName2: #gitLinkUserName2\n gitLinkUserName3: #gitLinkUserName3\n gitLinkUserName4: #gitLinkUserName4',
'd54d4255749d67f314e3985176e26624', '2023-05-16 09:05:57', '2023-12-07 15:12:49', 'nacos', '172.18.0.1', '', '',
'', '', '', 'yaml', '', '');
INSERT INTO `config_info`
VALUES (52, 'ruoyi-pms-prod.yml', 'DEFAULT_GROUP',
'# spring配置\r\nspring:\r\n redis:\r\n host: #redis_ip\r\n port: #redis_port\r\n password:\r\n datasource:\r\n druid:\r\n stat-view-servlet:\r\n enabled: true\r\n loginUsername: admin\r\n loginPassword: 123456\r\n dynamic:\r\n druid:\r\n initial-size: 5\r\n min-idle: 5\r\n maxActive: 20\r\n maxWait: 60000\r\n timeBetweenEvictionRunsMillis: 60000\r\n minEvictableIdleTimeMillis: 300000\r\n validationQuery: SELECT 1 FROM DUAL\r\n testWhileIdle: true\r\n testOnBorrow: false\r\n testOnReturn: false\r\n poolPreparedStatements: true\r\n maxPoolPreparedStatementPerConnectionSize: 20\r\n filters: stat,slf4j\r\n connectionProperties: druid.stat.mergeSql\\=true;druid.stat.slowSqlMillis\\=5000\r\n datasource:\r\n # 主库数据源\r\n master:\r\n driver-class-name: com.mysql.cj.jdbc.Driver\r\n url: jdbc:mysql://#db_url/#db_name?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\r\n username: #db_username\r\n password: #db_password\r\n\r\n# mybatis配置\r\nmybatis:\r\n # 搜索指定包别名\r\n typeAliasesPackage: com.ruoyi.pms\r\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\r\n mapperLocations: classpath:mapper/**/*.xml\r\n configuration:\r\n log-impl: org.apache.ibatis.logging.stdout.StdOutImpl\r\n\r\n# swagger配置\r\nswagger:\r\n title: 项目管理模块接口文档\r\n license: Powered By ruoyi\r\n licenseUrl: https://ruoyi.vip',
'375d4b57eaf365c384f8baedc0c15092', '2023-12-07 15:16:03', '2023-12-07 15:16:03', NULL, '172.18.0.1', '', '',
NULL, NULL, NULL, 'yaml', NULL, '');
-- ----------------------------
-- Table structure for config_info_aggr
-- ----------------------------
DROP TABLE IF EXISTS `config_info_aggr`;
CREATE TABLE `config_info_aggr`
(
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
`data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id',
`group_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'group_id',
`datum_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'datum_id',
`content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '内容',
`gmt_modified` datetime NOT NULL COMMENT '修改时间',
`app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
`tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT '租户字段',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `uk_configinfoaggr_datagrouptenantdatum` (`data_id`, `group_id`, `tenant_id`, `datum_id`) USING BTREE
) ENGINE = InnoDB
AUTO_INCREMENT = 1
CHARACTER SET = utf8
COLLATE = utf8_bin COMMENT = '增加租户字段'
ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of config_info_aggr
-- ----------------------------
-- ----------------------------
-- Table structure for config_info_beta
-- ----------------------------
DROP TABLE IF EXISTS `config_info_beta`;
CREATE TABLE `config_info_beta`
(
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
`data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id',
`group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'group_id',
`app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'app_name',
`content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'content',
`beta_ips` varchar(1024) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'betaIps',
`md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'md5',
`gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
`src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT 'source user',
`src_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'source ip',
`tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT '租户字段',
`encrypted_data_key` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT '秘钥',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `uk_configinfobeta_datagrouptenant` (`data_id`, `group_id`, `tenant_id`) USING BTREE
) ENGINE = InnoDB
AUTO_INCREMENT = 1
CHARACTER SET = utf8
COLLATE = utf8_bin COMMENT = 'config_info_beta'
ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of config_info_beta
-- ----------------------------
-- ----------------------------
-- Table structure for config_info_tag
-- ----------------------------
DROP TABLE IF EXISTS `config_info_tag`;
CREATE TABLE `config_info_tag`
(
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
`data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id',
`group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'group_id',
`tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT 'tenant_id',
`tag_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'tag_id',
`app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'app_name',
`content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'content',
`md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'md5',
`gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
`src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT 'source user',
`src_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'source ip',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `uk_configinfotag_datagrouptenanttag` (`data_id`, `group_id`, `tenant_id`, `tag_id`) USING BTREE
) ENGINE = InnoDB
AUTO_INCREMENT = 1
CHARACTER SET = utf8
COLLATE = utf8_bin COMMENT = 'config_info_tag'
ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of config_info_tag
-- ----------------------------
-- ----------------------------
-- Table structure for config_tags_relation
-- ----------------------------
DROP TABLE IF EXISTS `config_tags_relation`;
CREATE TABLE `config_tags_relation`
(
`id` bigint(20) NOT NULL COMMENT 'id',
`tag_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'tag_name',
`tag_type` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'tag_type',
`data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id',
`group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'group_id',
`tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT 'tenant_id',
`nid` bigint(20) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`nid`) USING BTREE,
UNIQUE INDEX `uk_configtagrelation_configidtag` (`id`, `tag_name`, `tag_type`) USING BTREE,
INDEX `idx_tenant_id` (`tenant_id`) USING BTREE
) ENGINE = InnoDB
AUTO_INCREMENT = 1
CHARACTER SET = utf8
COLLATE = utf8_bin COMMENT = 'config_tag_relation'
ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of config_tags_relation
-- ----------------------------
-- ----------------------------
-- Table structure for group_capacity
-- ----------------------------
DROP TABLE IF EXISTS `group_capacity`;
CREATE TABLE `group_capacity`
(
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'Group ID，空字符表示整个集群',
`quota` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '配额，0表示使用默认值',
`usage` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '使用量',
`max_size` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '单个配置大小上限，单位为字节，0表示使用默认值',
`max_aggr_count` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '聚合子配置最大个数，，0表示使用默认值',
`max_aggr_size` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '单个聚合数据的子配置大小上限，单位为字节，0表示使用默认值',
`max_history_count` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最大变更历史数量',
`gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `uk_group_id` (`group_id`) USING BTREE
) ENGINE = InnoDB
AUTO_INCREMENT = 1
CHARACTER SET = utf8
COLLATE = utf8_bin COMMENT = '集群、各Group容量信息表'
ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of group_capacity
-- ----------------------------
-- ----------------------------
-- Table structure for his_config_info
-- ----------------------------
DROP TABLE IF EXISTS `his_config_info`;
CREATE TABLE `his_config_info`
(
`id` bigint(64) UNSIGNED NOT NULL,
`nid` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'app_name',
`content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
`gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL,
`src_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
`op_type` char(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
`tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT '租户字段',
`encrypted_data_key` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT '秘钥',
PRIMARY KEY (`nid`) USING BTREE,
INDEX `idx_gmt_create` (`gmt_create`) USING BTREE,
INDEX `idx_gmt_modified` (`gmt_modified`) USING BTREE,
INDEX `idx_did` (`data_id`) USING BTREE
) ENGINE = InnoDB
AUTO_INCREMENT = 10
CHARACTER SET = utf8
COLLATE = utf8_bin COMMENT = '多租户改造'
ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of his_config_info
-- ----------------------------
INSERT INTO `his_config_info`
VALUES (1, 1, 'application-prod.yml', 'DEFAULT_GROUP', '',
'spring:\n autoconfigure:\n exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure\n mvc:\n pathmatch:\n matching-strategy: ant_path_matcher\n servlet:\n multipart:\n max-file-size: 100MB\n max-request-size: 100MB\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 response:\n enabled: true\n\n# 暴露监控端点\nmanagement:\n endpoints:\n web:\n exposure:\n include: \'*\'\n\n\nhttp:\n #最大连接数\n maxTotal: 100\n #并发数\n defaultMaxPerRoute: 20\n #创建连接的最长时间\n connectTimeout: 1000\n #从连接池中获取到连接的最长时间\n connectionRequestTimeout: 500\n #数据传输的最长时间\n socketTimeout: 10000\n #提交请求前测试连接是否可用\n staleConnectionCheckEnabled: true\n #gitlink请求地址\n gitLinkUrl: #cms_gitLinkUrl\n',
'0466a4b215975b0659266be39de36b15', '2023-12-07 15:02:44', '2023-12-07 15:02:45', 'nacos', '172.18.0.1', 'U',
'', '');
INSERT INTO `his_config_info`
VALUES (2, 2, 'ruoyi-gateway-prod.yml', 'DEFAULT_GROUP', '',
'spring:\n redis:\n host: #redis_ip\n port: #redis_port\n password:\n cloud:\n gateway:\n globalcors: #跨域问题\n cors-configurations:\n \'[/**]\':\n allowedOriginPatterns:\n - \"*\"\n allowedHeaders:\n - \"*\"\n allowCredentials: true\n maxAge: 360000\n allowedMethods:\n - GET\n - POST\n - DELETE\n - PUT\n - OPTIONS\n - HEAD\n discovery:\n locator:\n lowerCaseServiceId: true\n enabled: true\n routes:\n # 认证中心\n - id: ruoyi-auth\n uri: lb://ruoyi-auth\n predicates:\n - Path=/auth/**\n filters:\n # 验证码处理\n - CacheRequestFilter\n - ValidateCodeFilter\n - StripPrefix=1\n # 代码生成\n - id: ruoyi-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 # 内容管理服务\n - id: ruoyi-cms\n uri: lb://ruoyi-cms\n predicates:\n - Path=/cms/**\n filters:\n - StripPrefix=1\n # 特色专区服务\n - id: ruoyi-zone\n uri: lb://ruoyi-zone\n predicates:\n - Path=/zone/**\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 ignore:\n whites:\n - /auth/logout\n - /auth/login\n - /auth/register\n - /*/v2/api-docs\n - /csrf\n - /profile/**\n - /cms/blog/cms/**\n - /cms/message/cms/**\n - /cms/comment/cms/**\n - /file/statics/**\n - /cms/doc/open/**\n - /zone/open/**\n',
'dedf84995bd0ece580befa5ca05e79d0', '2023-12-07 15:06:05', '2023-12-07 15:06:06', 'nacos', '172.18.0.1', 'U',
'', '');
INSERT INTO `his_config_info`
VALUES (1, 3, 'application-prod.yml', 'DEFAULT_GROUP', '',
'spring:\n autoconfigure:\n exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure\n mvc:\n pathmatch:\n matching-strategy: ant_path_matcher\n servlet:\n multipart:\n max-file-size: 100MB\n max-request-size: 100MB\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 response:\n enabled: true\n\n# 暴露监控端点\nmanagement:\n endpoints:\n web:\n exposure:\n include: \'*\'\n\n\nhttp:\n #最大连接数\n maxTotal: 100\n #并发数\n defaultMaxPerRoute: 20\n #创建连接的最长时间\n connectTimeout: 1000\n #从连接池中获取到连接的最长时间\n connectionRequestTimeout: 500\n #数据传输的最长时间\n socketTimeout: 10000\n #提交请求前测试连接是否可用\n staleConnectionCheckEnabled: true\n #gitlink请求地址\n gitLinkUrl: #cms_gitLinkUrl\n #网关请求地址\n gatewayUrl: #gatewayUrl\n\ngitlink:\n admin_user:\n username: #gitlinkAdminUsername\n password: #gitlinkAdminPassword\n client_id: #gitlinkClientId\n client_secret: #gitlinkClientSecret\n',
'ac2b302f7b4f774a8458905b84dac26a', '2023-12-07 15:06:33', '2023-12-07 15:06:34', 'nacos', '172.18.0.1', 'U',
'', '');
INSERT INTO `his_config_info`
VALUES (8, 4, 'ruoyi-file-prod.yml', 'DEFAULT_GROUP', '',
'# 本地文件上传 \nfile:\n domain: #file_url\n path: #file_path\n prefix: /statics\n\n# FastDFS配置\nfdfs:\n domain: http://8.129.231.12\n soTimeout: 3000\n connectTimeout: 2000\n trackerList: 8.129.231.12:22122\n\n# Minio配置\nminio:\n url: http://8.129.231.12:9000\n accessKey: minioadmin\n secretKey: minioadmin\n bucketName: test',
'1ca67f615144b6dae3d1fcc437c1e681', '2023-12-07 15:08:53', '2023-12-07 15:08:54', 'nacos', '172.18.0.1', 'U',
'', '');
INSERT INTO `his_config_info`
VALUES (14, 5, 'ruoyi-cms-prod.yml', 'DEFAULT_GROUP', '',
'# spring配置\nspring:\n redis:\n host: #redis_ip\n port: #redis_port\n password:\n datasource:\n druid:\n stat-view-servlet:\n enabled: true\n loginUsername: admin\n loginPassword: 123456\n dynamic:\n druid:\n initial-size: 5\n min-idle: 5\n maxActive: 20\n maxWait: 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://#db_url/#db_name?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: #db_username\n password: #db_password\n # 从库数据源\n # slave:\n # username: root\n # password: Trust_#%01\n # url: jdbc:mysql://173.15.15.83:3306/testjunkenewweb?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n # driver-class-name: com.mysql.cj.jdbc.Driver\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.cms\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n configuration:\n log-impl: org.apache.ibatis.logging.stdout.StdOutImpl\n\n# swagger配置\nswagger:\n title: 内容管理模块接口文档\n license: Powered By ruoyi\n licenseUrl: https://ruoyi.vip\n\ncms:\n summaryMaxLength: #cms_summaryMaxLength\n gitLinkOrganization: #cms_gitLinkOrganization\n',
'9966bd2f7023b0c8fdb01d2f57e484e3', '2023-12-07 15:09:24', '2023-12-07 15:09:25', 'nacos', '172.18.0.1', 'U',
'', '');
INSERT INTO `his_config_info`
VALUES (45, 6, 'ruoyi-zone-prod.yml', 'DEFAULT_GROUP', '',
'# spring配置\nspring:\n redis:\n host: #redis_ip\n port: #redis_port\n password:\n datasource:\n druid:\n stat-view-servlet:\n enabled: true\n loginUsername: admin\n loginPassword: 123456\n dynamic:\n druid:\n initial-size: 5\n min-idle: 5\n maxActive: 20\n maxWait: 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://#db_url/#db_name?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: #db_username\n password: #db_password\n # 从库数据源\n # slave:\n # username: root\n # password: Trust_#%01\n # url: jdbc:mysql://173.15.15.83:3306/testjunkenewweb?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n # driver-class-name: com.mysql.cj.jdbc.Driver\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.zone\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\n mapperLocations: classpath:mapper/**/*.xml\n configuration:\n log-impl: org.apache.ibatis.logging.stdout.StdOutImpl\n\n# swagger配置\nswagger:\n title: 内容管理模块接口文档\n license: Powered By ruoyi\n licenseUrl: https://ruoyi.vip\n\nzone:\n #邀请链接有效时长（单位：天）\n invitationLinkExpirationTime: #invitationLinkExpirationTime\n #邀请确认页面\n invitationPagePath: #invitationPagePath\n #消息模板\n messageTemplate: #messageTemplate\n #专区管理地址\n zoneAdminUrl: #zoneAdminUrl\n #专区初始化数据\n initData:\n #项目聚合中，GitLink项目Id\n gitlinkProjectId: #gitlinkProjectId\n #会员聚合中，gitlink用户名\n gitLinkUserName1: #gitLinkUserName1\n gitLinkUserName2: #gitLinkUserName2\n gitLinkUserName3: #gitLinkUserName3\n gitLinkUserName4: #gitLinkUserName4',
'd4b72950712cff61d20a4739ec617c16', '2023-12-07 15:12:49', '2023-12-07 15:12:49', 'nacos', '172.18.0.1', 'U',
'', '');
INSERT INTO `his_config_info`
VALUES (0, 7, 'ruoyi-pms-prod.yml', 'DEFAULT_GROUP', '',
'# spring配置\r\nspring:\r\n redis:\r\n host: #redis_ip\r\n port: #redis_port\r\n password:\r\n datasource:\r\n druid:\r\n stat-view-servlet:\r\n enabled: true\r\n loginUsername: admin\r\n loginPassword: 123456\r\n dynamic:\r\n druid:\r\n initial-size: 5\r\n min-idle: 5\r\n maxActive: 20\r\n maxWait: 60000\r\n timeBetweenEvictionRunsMillis: 60000\r\n minEvictableIdleTimeMillis: 300000\r\n validationQuery: SELECT 1 FROM DUAL\r\n testWhileIdle: true\r\n testOnBorrow: false\r\n testOnReturn: false\r\n poolPreparedStatements: true\r\n maxPoolPreparedStatementPerConnectionSize: 20\r\n filters: stat,slf4j\r\n connectionProperties: druid.stat.mergeSql\\=true;druid.stat.slowSqlMillis\\=5000\r\n datasource:\r\n # 主库数据源\r\n master:\r\n driver-class-name: com.mysql.cj.jdbc.Driver\r\n url: jdbc:mysql://#db_url/#db_name?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\r\n username: #db_username\r\n password: #db_password\r\n\r\n# mybatis配置\r\nmybatis:\r\n # 搜索指定包别名\r\n typeAliasesPackage: com.ruoyi.pms\r\n # 配置mapper的扫描，找到所有的mapper.xml映射文件\r\n mapperLocations: classpath:mapper/**/*.xml\r\n configuration:\r\n log-impl: org.apache.ibatis.logging.stdout.StdOutImpl\r\n\r\n# swagger配置\r\nswagger:\r\n title: 项目管理模块接口文档\r\n license: Powered By ruoyi\r\n licenseUrl: https://ruoyi.vip',
'375d4b57eaf365c384f8baedc0c15092', '2023-12-07 15:16:03', '2023-12-07 15:16:03', NULL, '172.18.0.1', 'I', '',
'');
INSERT INTO `his_config_info`
VALUES (1, 8, 'application-prod.yml', 'DEFAULT_GROUP', '',
'spring:\n autoconfigure:\n exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure\n mvc:\n pathmatch:\n matching-strategy: ant_path_matcher\n servlet:\n multipart:\n max-file-size: 100MB\n max-request-size: 100MB\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 response:\n enabled: true\n\n# 暴露监控端点\nmanagement:\n endpoints:\n web:\n exposure:\n include: \'*\'\n\nhttp:\n #最大连接数\n maxTotal: 100\n #并发数\n defaultMaxPerRoute: 20\n #创建连接的最长时间\n connectTimeout: 1000\n #从连接池中获取到连接的最长时间\n connectionRequestTimeout: 500\n #数据传输的最长时间\n socketTimeout: 10000\n #提交请求前测试连接是否可用\n staleConnectionCheckEnabled: true\n #gitlink请求地址\n gitLinkUrl: #cms_gitLinkUrl\n #网关请求地址\n gatewayUrl: #gatewayUrl\n\ngitlink:\n admin_user:\n username: #gitlinkAdminUsername\n password: #gitlinkAdminPassword\n client_id: #gitlinkClientId\n client_secret: #gitlinkClientSecret\n',
'37eac228d7bf07256764e6c374a6abea', '2023-12-08 09:24:43', '2023-12-08 09:24:43', 'nacos', '172.18.0.1', 'U',
'', '');
INSERT INTO `his_config_info`
VALUES (1, 9, 'application-prod.yml', 'DEFAULT_GROUP', '',
'spring:\n autoconfigure:\n exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure\n mvc:\n pathmatch:\n matching-strategy: ant_path_matcher\n servlet:\n multipart:\n max-file-size: 100MB\n max-request-size: 100MB\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 response:\n enabled: true\n\n# 暴露监控端点\nmanagement:\n endpoints:\n web:\n exposure:\n include: \'*\'\n\nhttp:\n #最大连接数\n maxTotal: 100\n #并发数\n defaultMaxPerRoute: 20\n #创建连接的最长时间\n connectTimeout: 1000\n #从连接池中获取到连接的最长时间\n connectionRequestTimeout: 500\n #数据传输的最长时间\n socketTimeout: 10000\n #提交请求前测试连接是否可用\n staleConnectionCheckEnabled: true\n #gitlink请求地址\n gitLinkUrl: #cms_gitLinkUrl\n #网关请求地址\n gatewayUrl: #gatewayUrl\n\nswagger:\n host: #gatewayUrl/api\n\ngitlink:\n admin_user:\n username: #gitlinkAdminUsername\n password: #gitlinkAdminPassword\n client_id: #gitlinkClientId\n client_secret: #gitlinkClientSecret\n',
'5f9b789aa22c2418a629ca812a0b6176', '2023-12-08 09:24:50', '2023-12-08 09:24:50', 'nacos', '172.18.0.1', 'U',
'', '');
-- ----------------------------
-- Table structure for permissions
-- ----------------------------
DROP TABLE IF EXISTS `permissions`;
CREATE TABLE `permissions`
(
`role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`resource` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`action` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
UNIQUE INDEX `uk_role_permission` (`role`, `resource`, `action`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8mb4
COLLATE = utf8mb4_general_ci
ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of permissions
-- ----------------------------
-- ----------------------------
-- Table structure for roles
-- ----------------------------
DROP TABLE IF EXISTS `roles`;
CREATE TABLE `roles`
(
`username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
UNIQUE INDEX `idx_user_role` (`username`, `role`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8mb4
COLLATE = utf8mb4_general_ci
ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of roles
-- ----------------------------
INSERT INTO `roles`
VALUES ('nacos', 'ROLE_ADMIN');
-- ----------------------------
-- Table structure for tenant_capacity
-- ----------------------------
DROP TABLE IF EXISTS `tenant_capacity`;
CREATE TABLE `tenant_capacity`
(
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'Tenant ID',
`quota` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '配额，0表示使用默认值',
`usage` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '使用量',
`max_size` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '单个配置大小上限，单位为字节，0表示使用默认值',
`max_aggr_count` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '聚合子配置最大个数',
`max_aggr_size` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '单个聚合数据的子配置大小上限，单位为字节，0表示使用默认值',
`max_history_count` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最大变更历史数量',
`gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `uk_tenant_id` (`tenant_id`) USING BTREE
) ENGINE = InnoDB
AUTO_INCREMENT = 1
CHARACTER SET = utf8
COLLATE = utf8_bin COMMENT = '租户容量信息表'
ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of tenant_capacity
-- ----------------------------
-- ----------------------------
-- Table structure for tenant_info
-- ----------------------------
DROP TABLE IF EXISTS `tenant_info`;
CREATE TABLE `tenant_info`
(
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
`kp` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'kp',
`tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT 'tenant_id',
`tenant_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT 'tenant_name',
`tenant_desc` varchar(256) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'tenant_desc',
`create_source` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'create_source',
`gmt_create` bigint(20) NOT NULL COMMENT '创建时间',
`gmt_modified` bigint(20) NOT NULL COMMENT '修改时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `uk_tenant_info_kptenantid` (`kp`, `tenant_id`) USING BTREE,
INDEX `idx_tenant_id` (`tenant_id`) USING BTREE
) ENGINE = InnoDB
AUTO_INCREMENT = 1
CHARACTER SET = utf8
COLLATE = utf8_bin COMMENT = 'tenant_info'
ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of tenant_info
-- ----------------------------
-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`
(
`username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`password` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`enabled` tinyint(1) NOT NULL,
PRIMARY KEY (`username`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8mb4
COLLATE = utf8mb4_general_ci
ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users`
VALUES ('nacos', '$2a$10$EuWPZHzz32dJN7jexM34MOeYirDdFAZm2kuWj7VEOJhhZkDrxfvUu', 1);
SET FOREIGN_KEY_CHECKS = 1;
Reference in New Issue View Git Blame Copy Permalink