/* Navicat Premium Data Transfer Source Server : 海恒-生产 Source Server Type : MySQL Source Server Version : 50740 Source Host : 47.109.78.184:10010 Source Schema : nacos Target Server Type : MySQL Target Server Version : 50740 File Encoding : 65001 Date: 23/09/2024 12:24:23 */ 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(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间', `gmt_modified` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) 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 = 221 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'config_info' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of config_info -- ---------------------------- INSERT INTO `config_info` VALUES (1, 'application-dev.yml', 'DEFAULT_GROUP', 'spring:\n autoconfigure:\n exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure\n mvc:\n pathmatch:\n matching-strategy: ant_path_matcher\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', 'aaa73b809cfd4d0058893aa13da57806', '2020-05-20 12:00:00', '2022-04-24 10:26:34', 'nacos', '0:0:0:0:0:0:0:1', '', '', '通用配置', 'null', 'null', 'yaml', NULL, ''); INSERT INTO `config_info` VALUES (2, 'ruoyi-gateway-dev.yml', 'DEFAULT_GROUP', 'spring:\n redis:\n host: 47.109.78.184\n port: 10020\n password: hrt123456\n cloud:\n gateway:\n globalcors:\n cors-configurations:\n \'[/**]\':\n allowedOrigins: \"*\" \n allowedMethods: \"*\" \n allowedHeaders: \"*\"\n maxAge: 360000 \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-member\n uri: lb://ruoyi-member\n predicates:\n - Path=/member/**\n filters:\n - StripPrefix=1\n # 商户服务\n - id: ruoyi-shop\n uri: lb://ruoyi-shop\n predicates:\n - Path=/shop/**\n filters:\n - StripPrefix=1\n # 订单服务\n - id: ruoyi-order\n uri: lb://ruoyi-order\n predicates:\n - Path=/order/**\n filters:\n - StripPrefix=1\n # 商品服务\n - id: ruoyi-goods\n uri: lb://ruoyi-goods\n predicates:\n - Path=/goods/**\n filters:\n - StripPrefix=1\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/h5/oauthUrl\n - /auth/h5/oauthStaffUrl\n - /auth/h5/oauthUser\n - /auth/h5/oauthStaff\n - /auth/login\n - /auth/miniLogin\n - /auth/miniRegister\n - /auth/register\n - /*/v2/api-docs\n - /file/uploadOSS\n - /file/batchUploadOSS\n - /system/app/config/getAppAgreement\n - /system/app/home/getAdvert\n - /system/app/home/getHomeBanner\n - /system/app/home/getQuickEntry\n - /system/app/home/getPop\n - /system/qywx/qywxNotify\n - /shop/app/home/getShopInfo\n - /goods/app/goods/getGoodsInfo\n - /shop/app/home/getNearbyShop\n - /goods/app/home/pageRecommendGoods\n - /goods/app/home/pageActivityGoods\n - /goods/app/home/pageShopGoods\n - /goods/app/activity/pageAppActivityGoods\n - /system/mgt/config/getCustomConfig\n\n ', '9f9f920c917ea1001fe2d0407f0ff5bf', '2020-05-14 14:17:55', '2023-08-17 12:25:31', 'nacos', '223.85.228.183', '', '', '网关模块', 'null', 'null', 'yaml', '', ''); INSERT INTO `config_info` VALUES (3, 'ruoyi-auth-dev.yml', 'DEFAULT_GROUP', 'spring:\n redis:\n host: 47.109.78.184\n port: 10020\n password: hrt123456\n\n# swagger配置\nswagger:\n title: 授权登录接口文档\n license: Powered By 鸿瑞堂\n basePackage: com.ruoyi.auth.controller\n licenseUrl: https://ruoyi.vip\n\nh5:\n redirectMerchantUriBase: http://wxapp.hhhrt.cn/merchant\n redirectEmployeeUriBase: http://wxapp.hhhrt.cn/employee\n', '85ae8d41f91f9f083fe23e73b264cb33', '2020-11-20 00:00:00', '2023-07-18 02:41:30', 'nacos', '221.182.45.100', '', '', '认证中心', 'null', 'null', 'yaml', '', ''); 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', '2022-09-29 02:48:54', 'nacos', '0:0:0:0:0:0:0:1', '', '', '监控中心', 'null', 'null', 'yaml', '', ''); INSERT INTO `config_info` VALUES (5, 'ruoyi-system-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n redis:\n host: 47.109.78.184\n port: 10020\n password: hrt123456\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://47.109.78.184:10010/hrt_sys?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: hrt123456\n # 从库数据源\n # slave:\n # username: \n # password: \n # url: \n # driver-class-name: \n\nmybatis:\n type-aliases-package: com.ruoyi.system\n mapper-locations: classpath:mapper/**/*.xml\n configuration:\n map-underscore-to-camel-case: true\n # org.apache.ibatis.logging.nologging.NoLoggingImpl\n #log-impl: org.apache.ibatis.logging.nologging.NoLoggingImpl\n log-impl: org.apache.ibatis.logging.stdout.StdOutImpl\n\nmybatis-plus:\n type-aliases-package: com.ruoyi.system\n mapper-locations: classpath:mapper/**/*.xml\n configuration:\n map-underscore-to-camel-case: true\n log-impl: org.apache.ibatis.logging.stdout.StdOutImpl\n\n# swagger配置\nswagger:\n title: 系统模块接口文档\n license: Powered By ruoyi\n basePackage: com.ruoyi.system.controller\n licenseUrl: https://ruoyi.vip', '8ca0e24b1787fd9ba91ad36085e572e3', '2020-11-20 00:00:00', '2023-05-10 14:33:12', 'nacos', '221.182.45.100', '', '', '系统模块', 'null', 'null', 'yaml', '', ''); INSERT INTO `config_info` VALUES (6, 'ruoyi-gen-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n redis:\n host: 47.109.78.184\n port: 10020\n password: hrt123456\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://47.109.78.184:10010/hongruitang?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: hrt123456\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.gen.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\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', 'a48004bc7c97ddad13fc38ad435cb9fe', '2020-11-20 00:00:00', '2023-04-25 01:59:22', 'nacos', '221.182.45.100', '', '', '代码生成', 'null', 'null', 'yaml', '', ''); INSERT INTO `config_info` VALUES (7, 'ruoyi-job-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n redis:\n host: 47.109.78.184\n port: 10020\n password: hrt123456\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: 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', 'ea123532862eef56ee43721622c9ef07', '2020-11-20 00:00:00', '2023-04-24 07:27:07', 'nacos', '221.182.45.100', '', '', '定时任务', 'null', 'null', 'yaml', '', ''); INSERT INTO `config_info` VALUES (8, 'ruoyi-file-dev.yml', 'DEFAULT_GROUP', '# 本地文件上传 \r\nfile:\r\n domain: http://127.0.0.1:9300\r\n path: D:/ruoyi/uploadPath\r\n prefix: /statics\r\n\r\n# FastDFS配置\r\nfdfs:\r\n domain: http://8.129.231.12\r\n soTimeout: 3000\r\n connectTimeout: 2000\r\n trackerList: 8.129.231.12:22122\r\n\r\n# Minio配置\r\nminio:\r\n url: http://8.129.231.12:9000\r\n accessKey: minioadmin\r\n secretKey: minioadmin\r\n bucketName: test', '5382b93f3d8059d6068c0501fdd41195', '2020-11-20 00:00:00', '2020-12-21 21:01:59', NULL, '0:0:0:0:0:0:0:1', '', '', '文件服务', 'null', 'null', 'yaml', NULL, ''); 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 (85, 'ruoyi-member-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n redis:\n host: 47.109.78.184\n port: 10020\n password: hrt123456\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://47.109.78.184:10010/hrt_member?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: hrt123456\n # 从库数据源\n # slave:\n # username: \n # password: \n # url: \n # driver-class-name: \n\nmybatis:\n type-aliases-package: com.ruoyi.member\n mapper-locations: classpath:mapper/**/*.xml\n\n\nmybatis-plus:\n type-aliases-package: com.ruoyi.member\n mapper-locations: classpath:mapper/**/*.xml\n\n\n# swagger配置\nswagger:\n title: 会员模块接口文档\n license: Powered By ruoyi\n basePackage: com.ruoyi.member.controller\n licenseUrl: https://ruoyi.vip', 'a9f5e41ab703c1deaece5136d6067776', '2023-04-30 03:47:35', '2023-05-12 02:56:04', 'nacos', '221.182.45.100', '', '', '会员模块', 'null', 'null', 'yaml', '', NULL); INSERT INTO `config_info` VALUES (86, 'ruoyi-shop-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n redis:\n host: 47.109.78.184\n port: 10020\n password: hrt123456\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://47.109.78.184:10010/hrt_shop?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: hrt123456\n # 从库数据源\n # slave:\n # username: \n # password: \n # url: \n # driver-class-name: \n\nmybatis:\n type-aliases-package: com.ruoyi.shop\n mapper-locations: classpath:mapper/**/*.xml\n\n\nmybatis-plus:\n type-aliases-package: com.ruoyi.shop\n mapper-locations: classpath:mapper/**/*.xml\n\n\n# swagger配置\nswagger:\n title: 商户模块接口文档\n license: Powered By ruoyi\n basePackage: com.ruoyi.shop.controller\n licenseUrl: https://ruoyi.vip', 'bec0e1a307b0c61346d64a4ea707d3ff', '2023-04-30 03:48:26', '2023-05-12 04:40:01', 'nacos', '221.182.45.100', '', '', '商户模块', 'null', 'null', 'yaml', '', NULL); INSERT INTO `config_info` VALUES (87, 'ruoyi-order-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n redis:\n host: 47.109.78.184\n port: 10020\n password: hrt123456\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://47.109.78.184:10010/hrt_order?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: hrt123456\n # 从库数据源\n # slave:\n # username: \n # password: \n # url: \n # driver-class-name: \n\nmybatis:\n type-aliases-package: com.ruoyi.order\n mapper-locations: classpath:mapper/**/*.xml\n\nmybatis-plus:\n type-aliases-package: com.ruoyi.order\n mapper-locations: classpath:mapper/**/*.xml\n\n\n# swagger配置\nswagger:\n title: 订单模块接口文档\n license: Powered By ruoyi\n basePackage: com.ruoyi.order.controller\n licenseUrl: https://ruoyi.vip', '15f68fd797204d8ff0ddcc5254efb360', '2023-04-30 03:48:39', '2023-05-12 04:59:09', 'nacos', '221.182.45.100', '', '', '订单模块', 'null', 'null', 'yaml', '', NULL); INSERT INTO `config_info` VALUES (113, 'ruoyi-goods-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n redis:\n host: 47.109.78.184\n port: 10020\n password: hrt123456\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://47.109.78.184:10010/hrt_goods?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: hrt123456\n # 从库数据源\n # slave:\n # username: \n # password: \n # url: \n # driver-class-name: \n\nmybatis:\n type-aliases-package: com.ruoyi.goods\n mapper-locations: classpath:mapper/**/*.xml\n\nmybatis-plus:\n type-aliases-package: com.ruoyi.goods\n mapper-locations: classpath:mapper/**/*.xml\n\n\n# swagger配置\nswagger:\n title: 订单模块接口文档\n license: Powered By ruoyi\n basePackage: com.ruoyi.goods.controller\n licenseUrl: https://ruoyi.vip', '78cea4c8254ceba4fbaa941d889347b8', '2023-05-23 03:02:36', '2023-06-12 03:37:52', 'nacos', '221.182.45.100', '', '', '商品模块', 'null', 'null', 'yaml', '', NULL); INSERT INTO `config_info` VALUES (115, 'application-dev.yml', 'DEV_GROUP', 'spring:\n autoconfigure:\n exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure\n mvc:\n pathmatch:\n matching-strategy: ant_path_matcher\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', 'aaa73b809cfd4d0058893aa13da57806', '2023-08-18 10:19:33', '2023-08-18 10:19:33', NULL, '221.182.45.100', '', 'd39a744d-116f-4280-8445-0502dd1a3116', NULL, NULL, NULL, 'yaml', NULL, NULL); INSERT INTO `config_info` VALUES (116, 'ruoyi-gateway-dev.yml', 'DEV_GROUP', 'spring:\n redis:\n host: 47.109.78.184\n port: 10020\n password: hrt123456\n database: 2\n cloud:\n gateway:\n globalcors:\n cors-configurations:\n \'[/**]\':\n allowedOrigins: \"*\" \n allowedMethods: \"*\" \n allowedHeaders: \"*\"\n maxAge: 360000 \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-member\n uri: lb://ruoyi-member\n predicates:\n - Path=/member/**\n filters:\n - StripPrefix=1\n # 商户服务\n - id: ruoyi-shop\n uri: lb://ruoyi-shop\n predicates:\n - Path=/shop/**\n filters:\n - StripPrefix=1\n # 订单服务\n - id: ruoyi-order\n uri: lb://ruoyi-order\n predicates:\n - Path=/order/**\n filters:\n - StripPrefix=1\n # 商品服务\n - id: ruoyi-goods\n uri: lb://ruoyi-goods\n predicates:\n - Path=/goods/**\n filters:\n - StripPrefix=1\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/h5/oauthUrl\n - /auth/h5/oauthStaffUrl\n - /auth/h5/oauthUser\n - /auth/h5/oauthStaff\n - /auth/login\n - /auth/miniLogin\n - /auth/miniRegister\n - /auth/register\n - /*/v2/api-docs\n - /file/uploadOSS\n - /file/batchUploadOSS\n - /system/app/config/getAppAgreement\n - /system/app/home/getAdvert\n - /system/app/home/getHomeBanner\n - /system/app/home/getQuickEntry\n - /system/app/home/getPop\n - /system/qywx/qywxNotify\n - /shop/app/home/getShopInfo\n - /goods/app/goods/getGoodsInfo\n - /shop/app/home/getNearbyShop\n - /goods/app/home/pageRecommendGoods\n - /goods/app/home/pageActivityGoods\n - /goods/app/home/pageShopGoods\n - /goods/app/activity/pageAppActivityGoods\n - /system/mgt/config/getCustomConfig\n\n ', 'fea1deb3acb69e10749173d18992071d', '2023-08-18 10:19:33', '2023-08-20 12:27:05', 'nacos', '223.85.228.183', '', 'd39a744d-116f-4280-8445-0502dd1a3116', '', '', '', 'yaml', '', NULL); INSERT INTO `config_info` VALUES (117, 'ruoyi-auth-dev.yml', 'DEV_GROUP', 'spring:\n redis:\n host: 47.109.78.184\n port: 10020\n password: hrt123456\n database: 2\n# swagger配置\nswagger:\n title: 授权登录接口文档\n license: Powered By 鸿瑞堂\n basePackage: com.ruoyi.auth.controller\n licenseUrl: https://wxapp.hhhrt.cn\n\nh5:\n redirectMerchantUriBase: http://wxapp.hhhrt.cn/merchant\n redirectEmployeeUriBase: http://wxapp.hhhrt.cn/employee\n', 'b729c0e1a355af464462e8adeaf39867', '2023-08-18 10:19:33', '2023-08-20 12:27:22', 'nacos', '223.85.228.183', '', 'd39a744d-116f-4280-8445-0502dd1a3116', '', '', '', 'yaml', '', NULL); INSERT INTO `config_info` VALUES (118, 'ruoyi-monitor-dev.yml', 'DEV_GROUP', '# spring\nspring:\n security:\n user:\n name: ruoyi\n password: 123456\n boot:\n admin:\n ui:\n title: 若依服务状态监控\n', '6f122fd2bfb8d45f858e7d6529a9cd44', '2023-08-18 10:19:33', '2023-08-18 10:19:33', NULL, '221.182.45.100', '', 'd39a744d-116f-4280-8445-0502dd1a3116', NULL, NULL, NULL, 'yaml', NULL, NULL); INSERT INTO `config_info` VALUES (119, 'ruoyi-system-dev.yml', 'DEV_GROUP', '# spring配置\nspring:\n redis:\n host: 47.109.78.184\n port: 10020\n password: hrt123456\n database: 2\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://8.137.105.173:10010/hrt_sys?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: hrt123456\n # 从库数据源\n # slave:\n # username: \n # password: \n # url: \n # driver-class-name: \n\nmybatis:\n type-aliases-package: com.ruoyi.system\n mapper-locations: classpath:mapper/**/*.xml\n configuration:\n map-underscore-to-camel-case: true\n # org.apache.ibatis.logging.nologging.NoLoggingImpl\n #log-impl: org.apache.ibatis.logging.nologging.NoLoggingImpl\n log-impl: org.apache.ibatis.logging.stdout.StdOutImpl\n\nmybatis-plus:\n type-aliases-package: com.ruoyi.system\n mapper-locations: classpath:mapper/**/*.xml\n configuration:\n map-underscore-to-camel-case: true\n log-impl: org.apache.ibatis.logging.stdout.StdOutImpl\n\n# swagger配置\nswagger:\n title: 系统模块接口文档\n license: Powered By ruoyi\n basePackage: com.ruoyi.system.controller\n licenseUrl: https://ruoyi.vip', 'dfa8f9a9557a2516e39991471f6535f9', '2023-08-18 10:19:33', '2023-09-20 08:23:01', 'nacos', '221.182.45.100', '', 'd39a744d-116f-4280-8445-0502dd1a3116', '', '', '', 'yaml', '', NULL); INSERT INTO `config_info` VALUES (120, 'ruoyi-gen-dev.yml', 'DEV_GROUP', '# spring配置\nspring:\n redis:\n host: 47.109.78.184\n port: 10020\n password: hrt123456\n database: 2\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://47.109.78.184:10010/hongruitang?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: hrt123456\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.gen.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\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', '0fd3b246da1c45ffa9c4ab3c401776a6', '2023-08-18 10:19:33', '2023-08-20 12:27:48', 'nacos', '223.85.228.183', '', 'd39a744d-116f-4280-8445-0502dd1a3116', '', '', '', 'yaml', '', NULL); INSERT INTO `config_info` VALUES (121, 'ruoyi-job-dev.yml', 'DEV_GROUP', '# spring配置\nspring:\n redis:\n host: 47.109.78.184\n port: 10020\n password: hrt123456\n database: 2\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: 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', '983a33447757aad125aff91b19613785', '2023-08-18 10:19:33', '2023-08-20 12:28:04', 'nacos', '223.85.228.183', '', 'd39a744d-116f-4280-8445-0502dd1a3116', '', '', '', 'yaml', '', NULL); INSERT INTO `config_info` VALUES (122, 'ruoyi-file-dev.yml', 'DEV_GROUP', '# 本地文件上传 \nfile:\n domain: http://127.0.0.1:9300\n path: D:/ruoyi/uploadPath\n prefix: /statics\n\n# spring配置\nspring:\n redis:\n host: 47.109.78.184\n port: 10020\n password: hrt123456\n database: 2', '837d5ef06631111e548d85cc4e8233fd', '2023-08-18 10:19:33', '2023-09-20 08:31:03', 'nacos', '221.182.45.100', '', 'd39a744d-116f-4280-8445-0502dd1a3116', '', '', '', 'yaml', '', NULL); INSERT INTO `config_info` VALUES (123, 'sentinel-ruoyi-gateway', 'DEV_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', '2023-08-18 10:19:33', '2023-08-18 10:19:33', NULL, '221.182.45.100', '', 'd39a744d-116f-4280-8445-0502dd1a3116', NULL, NULL, NULL, 'text', NULL, NULL); INSERT INTO `config_info` VALUES (124, 'ruoyi-member-dev.yml', 'DEV_GROUP', '# spring配置\nspring:\n redis:\n host: 47.109.78.184\n port: 10020\n password: hrt123456\n database: 2\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://8.137.105.173:10010/hrt_member?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: hrt123456\n # 从库数据源\n # slave:\n # username: \n # password: \n # url: \n # driver-class-name: \n\nmybatis:\n type-aliases-package: com.ruoyi.member\n mapper-locations: classpath:mapper/**/*.xml\n\n\nmybatis-plus:\n type-aliases-package: com.ruoyi.member\n mapper-locations: classpath:mapper/**/*.xml\n\n\n# swagger配置\nswagger:\n title: 会员模块接口文档\n license: Powered By ruoyi\n basePackage: com.ruoyi.member.controller\n licenseUrl: https://ruoyi.vip', 'e471442cac3c5c42a58b8e191163ab34', '2023-08-18 10:19:33', '2023-09-20 08:23:18', 'nacos', '221.182.45.100', '', 'd39a744d-116f-4280-8445-0502dd1a3116', '', '', '', 'yaml', '', NULL); INSERT INTO `config_info` VALUES (125, 'ruoyi-shop-dev.yml', 'DEV_GROUP', '# spring配置\nspring:\n redis:\n host: 47.109.78.184\n port: 10020\n password: hrt123456\n database: 2\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://8.137.105.173:10010/hrt_shop?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: hrt123456\n # 从库数据源\n # slave:\n # username: \n # password: \n # url: \n # driver-class-name: \n\nmybatis:\n type-aliases-package: com.ruoyi.shop\n mapper-locations: classpath:mapper/**/*.xml\n\n\nmybatis-plus:\n type-aliases-package: com.ruoyi.shop\n mapper-locations: classpath:mapper/**/*.xml\n\n\n# swagger配置\nswagger:\n title: 商户模块接口文档\n license: Powered By ruoyi\n basePackage: com.ruoyi.shop.controller\n licenseUrl: https://ruoyi.vip', '5de0e0e6cdc382ed9a5a330c79a4872d', '2023-08-18 10:19:33', '2023-09-20 08:23:35', 'nacos', '221.182.45.100', '', 'd39a744d-116f-4280-8445-0502dd1a3116', '', '', '', 'yaml', '', NULL); INSERT INTO `config_info` VALUES (126, 'ruoyi-order-dev.yml', 'DEV_GROUP', '# spring配置\nspring:\n redis:\n host: 47.109.78.184\n port: 10020\n password: hrt123456\n database: 2\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://8.137.105.173:10010/hrt_order?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: hrt123456\n # 从库数据源\n # slave:\n # username: \n # password: \n # url: \n # driver-class-name: \n\nmybatis:\n type-aliases-package: com.ruoyi.order\n mapper-locations: classpath:mapper/**/*.xml\n\nmybatis-plus:\n type-aliases-package: com.ruoyi.order\n mapper-locations: classpath:mapper/**/*.xml\n\n\n# swagger配置\nswagger:\n title: 订单模块接口文档\n license: Powered By ruoyi\n basePackage: com.ruoyi.order.controller\n licenseUrl: https://ruoyi.vip', '3ba7371228086cd5638aae79363fe691', '2023-08-18 10:19:33', '2023-09-20 08:23:45', 'nacos', '221.182.45.100', '', 'd39a744d-116f-4280-8445-0502dd1a3116', '', '', '', 'yaml', '', NULL); INSERT INTO `config_info` VALUES (127, 'ruoyi-goods-dev.yml', 'DEV_GROUP', '# spring配置\nspring:\n redis:\n host: 47.109.78.184\n port: 10020\n password: hrt123456\n database: 2\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://8.137.105.173:10010/hrt_goods?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: hrt123456\n # 从库数据源\n # slave:\n # username: \n # password: \n # url: \n # driver-class-name: \n\nmybatis:\n type-aliases-package: com.ruoyi.goods\n mapper-locations: classpath:mapper/**/*.xml\n\nmybatis-plus:\n type-aliases-package: com.ruoyi.goods\n mapper-locations: classpath:mapper/**/*.xml\n\n\n# swagger配置\nswagger:\n title: 订单模块接口文档\n license: Powered By ruoyi\n basePackage: com.ruoyi.goods.controller\n licenseUrl: https://ruoyi.vip', 'a619b1d32a0d6a05f4cdf57676c0a30b', '2023-08-18 10:19:33', '2023-09-20 08:23:56', 'nacos', '221.182.45.100', '', 'd39a744d-116f-4280-8445-0502dd1a3116', '', '', '', 'yaml', '', NULL); INSERT INTO `config_info` VALUES (128, 'application-dev.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\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', 'aaa73b809cfd4d0058893aa13da57806', '2023-08-18 10:29:52', '2023-08-18 10:29:52', NULL, '221.182.45.100', '', '9591ef9f-a49a-4900-be35-d77258bdd639', NULL, NULL, NULL, 'yaml', NULL, NULL); INSERT INTO `config_info` VALUES (129, 'ruoyi-gateway-dev.yml', 'DEFAULT_GROUP', 'spring:\n redis:\n host: 47.109.78.184\n port: 10020\n password: hrt123456\n database: 0\n cloud:\n gateway:\n globalcors:\n cors-configurations:\n \'[/**]\':\n allowedOrigins: \"*\" \n allowedMethods: \"*\" \n allowedHeaders: \"*\"\n maxAge: 360000 \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-member\n uri: lb://ruoyi-member\n predicates:\n - Path=/member/**\n filters:\n - StripPrefix=1\n # 商户服务\n - id: ruoyi-shop\n uri: lb://ruoyi-shop\n predicates:\n - Path=/shop/**\n filters:\n - StripPrefix=1\n # 订单服务\n - id: ruoyi-order\n uri: lb://ruoyi-order\n predicates:\n - Path=/order/**\n filters:\n - StripPrefix=1\n # 商品服务\n - id: ruoyi-goods\n uri: lb://ruoyi-goods\n predicates:\n - Path=/goods/**\n filters:\n - StripPrefix=1\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/h5/oauthUrl\n - /auth/h5/oauthStaffUrl\n - /auth/h5/oauthUser\n - /auth/h5/oauthStaff\n - /auth/login\n - /auth/miniLogin\n - /auth/miniRegister\n - /auth/register\n - /*/v2/api-docs\n - /file/uploadOSS\n - /file/batchUploadOSS\n - /system/app/config/getAppAgreement\n - /system/app/home/getAdvert\n - /system/app/home/getHomeBanner\n - /system/app/home/getQuickEntry\n - /system/app/home/getPop\n - /system/qywx/qywxNotify\n - /system/mgt/config/getCooperation\n - /shop/app/home/getShopInfo\n - /goods/app/goods/getGoodsInfo\n - /shop/app/home/getNearbyShop\n - /goods/app/home/pageRecommendGoods\n - /goods/app/home/pageActivityGoods\n - /goods/app/home/pageShopGoods\n - /goods/app/activity/pageAppActivityGoods\n - /system/mgt/config/getCustomConfig\n - /order/app/notify/payNotify\n - /shop/mgt/shop/merchantBasicdataNotify\n - /order/app/notify/wechatPaymentCallback\n - /order/app/notify/wechatPaymentRefundCallback\n\n ', 'd5010208d07415c1514487f417d26cf5', '2023-08-18 10:29:52', '2024-01-23 03:02:38', 'nacos', '221.182.45.100', '', '9591ef9f-a49a-4900-be35-d77258bdd639', '', '', '', 'yaml', '', NULL); INSERT INTO `config_info` VALUES (130, 'ruoyi-auth-dev.yml', 'DEFAULT_GROUP', 'spring:\n redis:\n host: 47.109.78.184\n port: 10020\n password: hrt123456\n database: 0\n# swagger配置\nswagger:\n title: 授权登录接口文档\n license: Powered By 鸿瑞堂\n basePackage: com.ruoyi.auth.controller\n licenseUrl: https://ruoyi.vip\n\nh5:\n redirectMerchantUriBase: http://wxapp.hhhrt.cn/merchant\n redirectEmployeeUriBase: http://wxapp.hhhrt.cn/employee\n', 'db1cf8d06d65b63dfe1e621ae2cd13d6', '2023-08-18 10:29:52', '2023-08-18 10:34:23', 'nacos', '221.182.45.100', '', '9591ef9f-a49a-4900-be35-d77258bdd639', '', '', '', 'yaml', '', NULL); INSERT INTO `config_info` VALUES (131, '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', '2023-08-18 10:29:52', '2023-08-18 10:29:52', NULL, '221.182.45.100', '', '9591ef9f-a49a-4900-be35-d77258bdd639', NULL, NULL, NULL, 'yaml', NULL, NULL); INSERT INTO `config_info` VALUES (132, 'ruoyi-system-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n redis:\n host: 47.109.78.184\n port: 10020\n password: hrt123456\n database: 0\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://47.109.78.184:10010/hrt_sys?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: hrt123456\n # 从库数据源\n # slave:\n # username: \n # password: \n # url: \n # driver-class-name: \n seata: true # 开启seata代理，开启后默认每个数据源都代理，如果某个不需要代理可单独关闭\n\n# seata配置\nseata:\n # 默认关闭，如需启用spring.datasource.dynami.seata需要同时开启\n enabled: true\n # Seata 应用编号，默认为 ${spring.application.name}\n application-id: ${spring.application.name}\n # Seata 事务组编号，用于 TC 集群名\n tx-service-group: ruoyi-system-group\n # 关闭自动代理\n enable-auto-data-source-proxy: false\n # 服务配置项\n service:\n # 虚拟组和分组的映射\n vgroup-mapping:\n ruoyi-system-group: default\n config:\n type: nacos\n nacos:\n serverAddr: 127.0.0.1:5000\n group: SEATA_GROUP\n namespace: 9591ef9f-a49a-4900-be35-d77258bdd639\n userName: nacos\n password: nacos\n registry:\n type: nacos\n nacos:\n application: seata-server\n server-addr: 127.0.0.1:5000\n group: SEATA_GROUP\n namespace: 9591ef9f-a49a-4900-be35-d77258bdd639\n userName: nacos\n password: nacos\n\n\nmybatis:\n type-aliases-package: com.ruoyi.system\n mapper-locations: classpath:mapper/**/*.xml\n configuration:\n map-underscore-to-camel-case: true\n # org.apache.ibatis.logging.nologging.NoLoggingImpl\n #log-impl: org.apache.ibatis.logging.nologging.NoLoggingImpl\n log-impl: org.apache.ibatis.logging.stdout.StdOutImpl\n\nmybatis-plus:\n type-aliases-package: com.ruoyi.system\n mapper-locations: classpath:mapper/**/*.xml\n configuration:\n map-underscore-to-camel-case: true\n log-impl: org.apache.ibatis.logging.stdout.StdOutImpl\n\n# swagger配置\nswagger:\n title: 系统模块接口文档\n license: Powered By ruoyi\n basePackage: com.ruoyi.system.controller\n licenseUrl: https://ruoyi.vip', '623395abdb27965470c3ee03231a50be', '2023-08-18 10:29:52', '2023-09-04 11:18:06', 'nacos', '221.182.45.100', '', '9591ef9f-a49a-4900-be35-d77258bdd639', '', '', '', 'yaml', '', NULL); INSERT INTO `config_info` VALUES (133, 'ruoyi-gen-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n redis:\n host: 47.109.78.184\n port: 10020\n password: hrt123456\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://47.109.78.184:10010/hongruitang?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: hrt123456\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.gen.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\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', 'a48004bc7c97ddad13fc38ad435cb9fe', '2023-08-18 10:29:52', '2023-08-18 10:29:52', NULL, '221.182.45.100', '', '9591ef9f-a49a-4900-be35-d77258bdd639', NULL, NULL, NULL, 'yaml', NULL, NULL); INSERT INTO `config_info` VALUES (134, 'ruoyi-job-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n redis:\n host: 47.109.78.184\n port: 10020\n password: hrt123456\n database: 0\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: 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', 'ee158fc55490dc6784519ac86594bda4', '2023-08-18 10:29:52', '2023-08-18 10:34:53', 'nacos', '221.182.45.100', '', '9591ef9f-a49a-4900-be35-d77258bdd639', '', '', '', 'yaml', '', NULL); INSERT INTO `config_info` VALUES (135, 'ruoyi-file-dev.yml', 'DEFAULT_GROUP', '# 本地文件上传 \nfile:\n domain: http://127.0.0.1:9300\n path: D:/ruoyi/uploadPath\n prefix: /statics\n\n# spring配置\nspring:\n redis:\n host: 47.109.78.184\n port: 10020\n password: hrt123456', 'c6b8601a2f6f340a679f03ecd4eab684', '2023-08-18 10:29:52', '2023-09-11 06:29:15', 'nacos', '221.182.45.100', '', '9591ef9f-a49a-4900-be35-d77258bdd639', '', '', '', 'yaml', '', NULL); INSERT INTO `config_info` VALUES (136, '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', '2023-08-18 10:29:52', '2023-08-18 10:29:52', NULL, '221.182.45.100', '', '9591ef9f-a49a-4900-be35-d77258bdd639', NULL, NULL, NULL, 'text', NULL, NULL); INSERT INTO `config_info` VALUES (137, 'ruoyi-member-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n redis:\n host: 47.109.78.184\n port: 10020\n password: hrt123456\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://47.109.78.184:10010/hrt_member?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: hrt123456\n # 从库数据源\n # slave:\n # username: \n # password: \n # url: \n # driver-class-name: \n\n seata: true # 开启seata代理，开启后默认每个数据源都代理，如果某个不需要代理可单独关闭\n\n# seata配置\nseata:\n # 默认关闭，如需启用spring.datasource.dynami.seata需要同时开启\n enabled: true\n # Seata 应用编号，默认为 ${spring.application.name}\n application-id: ${spring.application.name}\n # Seata 事务组编号，用于 TC 集群名\n tx-service-group: ruoyi-member-group\n # 关闭自动代理\n enable-auto-data-source-proxy: false\n # 服务配置项\n service:\n # 虚拟组和分组的映射\n vgroup-mapping:\n ruoyi-member-group: default\n config:\n type: nacos\n nacos:\n serverAddr: 47.109.78.184:5000\n group: SEATA_GROUP\n namespace: 9591ef9f-a49a-4900-be35-d77258bdd639\n userName: nacos\n password: nacos\n registry:\n type: nacos\n nacos:\n application: seata-server\n server-addr: 47.109.78.184:5000\n group: SEATA_GROUP\n namespace: 9591ef9f-a49a-4900-be35-d77258bdd639\n userName: nacos\n password: nacos\n\nmybatis:\n type-aliases-package: com.ruoyi.member\n mapper-locations: classpath:mapper/**/*.xml\n\n\nmybatis-plus:\n type-aliases-package: com.ruoyi.member\n mapper-locations: classpath:mapper/**/*.xml\n\n\n# swagger配置\nswagger:\n title: 会员模块接口文档\n license: Powered By ruoyi\n basePackage: com.ruoyi.member.controller\n licenseUrl: https://ruoyi.vip', '025c0eedaa1b8b420d0583e847fdf36a', '2023-08-18 10:29:52', '2024-02-29 09:16:08', 'nacos', '221.182.45.100', '', '9591ef9f-a49a-4900-be35-d77258bdd639', '', '', '', 'yaml', '', NULL); INSERT INTO `config_info` VALUES (138, 'ruoyi-shop-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n redis:\n host: 47.109.78.184\n port: 10020\n password: hrt123456\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://47.109.78.184:10010/hrt_shop?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: hrt123456\n # 从库数据源\n # slave:\n # username: \n # password: \n # url: \n # driver-class-name: \n seata: true # 开启seata代理，开启后默认每个数据源都代理，如果某个不需要代理可单独关闭\n\n# seata配置\nseata:\n # 默认关闭，如需启用spring.datasource.dynami.seata需要同时开启\n enabled: true\n # Seata 应用编号，默认为 ${spring.application.name}\n application-id: ${spring.application.name}\n # Seata 事务组编号，用于 TC 集群名\n tx-service-group: ruoyi-shop-group\n # 关闭自动代理\n enable-auto-data-source-proxy: false\n # 服务配置项\n service:\n # 虚拟组和分组的映射\n vgroup-mapping:\n ruoyi-shop-group: default\n config:\n type: nacos\n nacos:\n serverAddr: 127.0.0.1:5000\n group: SEATA_GROUP\n namespace: 9591ef9f-a49a-4900-be35-d77258bdd639\n userName: nacos\n password: nacos\n registry:\n type: nacos\n nacos:\n application: seata-server\n server-addr: 127.0.0.1:5000\n group: SEATA_GROUP\n namespace: 9591ef9f-a49a-4900-be35-d77258bdd639\n userName: nacos\n password: nacos\n\n\nmybatis:\n type-aliases-package: com.ruoyi.shop\n mapper-locations: classpath:mapper/**/*.xml\n\n\nmybatis-plus:\n type-aliases-package: com.ruoyi.shop\n mapper-locations: classpath:mapper/**/*.xml\n\n\n# swagger配置\nswagger:\n title: 商户模块接口文档\n license: Powered By ruoyi\n basePackage: com.ruoyi.shop.controller\n licenseUrl: https://ruoyi.vip', '92fb45c8e7f071b04e285cbd05dbc68b', '2023-08-18 10:29:52', '2023-09-04 11:22:16', 'nacos', '221.182.45.100', '', '9591ef9f-a49a-4900-be35-d77258bdd639', '', '', '', 'yaml', '', NULL); INSERT INTO `config_info` VALUES (139, 'ruoyi-order-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n redis:\n host: 47.109.78.184\n port: 10020\n password: hrt123456\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://47.109.78.184:10010/hrt_order?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: hrt123456\n # 从库数据源\n # slave:\n # username: \n # password: \n # url: \n # driver-class-name: \n seata: true # 开启seata代理，开启后默认每个数据源都代理，如果某个不需要代理可单独关闭\n\n# seata配置\nseata:\n # 默认关闭，如需启用spring.datasource.dynami.seata需要同时开启\n enabled: true\n # Seata 应用编号，默认为 ${spring.application.name}\n application-id: ${spring.application.name}\n # Seata 事务组编号，用于 TC 集群名\n tx-service-group: ruoyi-order-group\n # 关闭自动代理\n enable-auto-data-source-proxy: false\n # 服务配置项\n service:\n # 虚拟组和分组的映射\n vgroup-mapping:\n ruoyi-order-group: default\n config:\n type: nacos\n nacos:\n serverAddr: 127.0.0.1:5000\n group: SEATA_GROUP\n namespace: 9591ef9f-a49a-4900-be35-d77258bdd639\n userName: nacos\n password: nacos\n registry:\n type: nacos\n nacos:\n application: seata-server\n server-addr: 127.0.0.1:5000\n group: SEATA_GROUP\n namespace: 9591ef9f-a49a-4900-be35-d77258bdd639\n userName: nacos\n password: nacos\n\n\nmybatis:\n type-aliases-package: com.ruoyi.order\n mapper-locations: classpath:mapper/**/*.xml\n\nmybatis-plus:\n type-aliases-package: com.ruoyi.order\n mapper-locations: classpath:mapper/**/*.xml\n\n\n# swagger配置\nswagger:\n title: 订单模块接口文档\n license: Powered By ruoyi\n basePackage: com.ruoyi.order.controller\n licenseUrl: https://ruoyi.vip', 'db74f505be64d4f9df73f298bd86ce7c', '2023-08-18 10:29:52', '2023-10-20 14:57:55', 'nacos', '221.182.45.100', '', '9591ef9f-a49a-4900-be35-d77258bdd639', '', '', '', 'yaml', '', NULL); INSERT INTO `config_info` VALUES (140, 'ruoyi-goods-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n redis:\n host: 47.109.78.184\n port: 10020\n password: hrt123456\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://47.109.78.184:10010/hrt_goods?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: hrt123456\n # 从库数据源\n # slave:\n # username: \n # password: \n # url: \n # driver-class-name: \n seata: true # 开启seata代理，开启后默认每个数据源都代理，如果某个不需要代理可单独关闭\n\n# seata配置\nseata:\n # 默认关闭，如需启用spring.datasource.dynami.seata需要同时开启\n enabled: true\n # Seata 应用编号，默认为 ${spring.application.name}\n application-id: ${spring.application.name}\n # Seata 事务组编号，用于 TC 集群名\n tx-service-group: ruoyi-goods-group\n # 关闭自动代理\n enable-auto-data-source-proxy: false\n # 服务配置项\n service:\n # 虚拟组和分组的映射\n vgroup-mapping:\n ruoyi-goods-group: default\n config:\n type: nacos\n nacos:\n serverAddr: 127.0.0.1:5000\n group: SEATA_GROUP\n namespace: 9591ef9f-a49a-4900-be35-d77258bdd639\n userName: nacos\n password: nacos\n registry:\n type: nacos\n nacos:\n application: seata-server\n server-addr: 127.0.0.1:5000\n group: SEATA_GROUP\n namespace: 9591ef9f-a49a-4900-be35-d77258bdd639\n userName: nacos\n password: nacos\n\n\nmybatis:\n type-aliases-package: com.ruoyi.goods\n mapper-locations: classpath:mapper/**/*.xml\n\nmybatis-plus:\n type-aliases-package: com.ruoyi.goods\n mapper-locations: classpath:mapper/**/*.xml\n\n\n# swagger配置\nswagger:\n title: 订单模块接口文档\n license: Powered By ruoyi\n basePackage: com.ruoyi.goods.controller\n licenseUrl: https://ruoyi.vip', '6357f5f7666b390bc98f55b311488690', '2023-08-18 10:29:52', '2023-09-04 11:22:42', 'nacos', '221.182.45.100', '', '9591ef9f-a49a-4900-be35-d77258bdd639', '', '', '', 'yaml', '', NULL); INSERT INTO `config_info` VALUES (157, 'seataServer.yml', 'DEFAULT_GROUP', 'service:\r\n vgroupMapping:\r\n ruoyi-system-group: default\r\nstore:\r\n db:\r\n datasource: druid\r\n dbType: mysql\r\n driverClassName: com.mysql.jdbc.Driver #此处请注意 5.x版本请使用com.mysql.jdbc.Driver 8以上版本请使用 com.mysql.cj.jdbc.Driver\r\n url: jdbc:mysql://127.0.0.1:10010/ry-seata?useUnicode=true #创建的库(后边有教程)\r\n user: root #数据库账号（自行修改）\r\n password: hrt123456 #数据库密码（自行修改）\r\n globalTable: global_table\r\n lockTable: lock_table\r\n branchTable: branch_table\r\n maxConn: 30\r\n maxWait: 5000\r\n minConn: 5\r\n queryLimit: 100\r\n mode: db', '7a1a49ea5162a75a09571b0ae595ed50', '2023-09-04 01:25:20', '2023-09-04 01:25:20', NULL, '221.182.45.100', '', '9591ef9f-a49a-4900-be35-d77258bdd639', NULL, NULL, NULL, 'yaml', NULL, NULL); INSERT INTO `config_info` VALUES (158, 'service.vgroupMapping.ruoyi-order-group', 'SEATA_GROUP', 'default', 'c21f969b5f03d33d43e04f8f136e7682', '2023-09-04 01:31:11', '2023-09-04 01:31:53', 'nacos', '221.182.45.100', '', '9591ef9f-a49a-4900-be35-d77258bdd639', '', '', '', 'yaml', '', NULL); INSERT INTO `config_info` VALUES (159, 'service.vgroupMapping.ruoyi-goods-group', 'SEATA_GROUP', 'default', 'c21f969b5f03d33d43e04f8f136e7682', '2023-09-04 01:31:38', '2023-09-04 01:31:38', NULL, '221.182.45.100', '', '9591ef9f-a49a-4900-be35-d77258bdd639', NULL, NULL, NULL, 'yaml', NULL, NULL); INSERT INTO `config_info` VALUES (162, 'service.vgroupMapping.ruoyi-shop-group', 'SEATA_GROUP', 'default', 'c21f969b5f03d33d43e04f8f136e7682', '2023-09-04 01:33:01', '2023-09-04 01:33:01', NULL, '221.182.45.100', '', '9591ef9f-a49a-4900-be35-d77258bdd639', NULL, NULL, NULL, 'yaml', NULL, NULL); INSERT INTO `config_info` VALUES (163, 'service.vgroupMapping.ruoyi-member-group', 'SEATA_GROUP', 'default', 'c21f969b5f03d33d43e04f8f136e7682', '2023-09-04 01:33:37', '2023-09-04 01:33:37', NULL, '221.182.45.100', '', '9591ef9f-a49a-4900-be35-d77258bdd639', NULL, NULL, NULL, 'yaml', NULL, NULL); INSERT INTO `config_info` VALUES (164, 'service.vgroupMapping.ruoyi-system-group', 'SEATA_GROUP', 'default', 'c21f969b5f03d33d43e04f8f136e7682', '2023-09-04 01:34:16', '2023-09-04 01:34:16', NULL, '221.182.45.100', '', '9591ef9f-a49a-4900-be35-d77258bdd639', NULL, NULL, NULL, 'yaml', NULL, NULL); INSERT INTO `config_info` VALUES (202, 'application-dev.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\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', 'aaa73b809cfd4d0058893aa13da57806', '2023-11-13 08:52:13', '2023-11-13 08:52:13', NULL, '221.182.45.100', '', 'e1a7e419-e8c7-4d7d-8a0a-c00ab6ccfccd', NULL, NULL, NULL, 'yaml', NULL, NULL); INSERT INTO `config_info` VALUES (203, 'ruoyi-gateway-dev.yml', 'DEFAULT_GROUP', 'spring:\n redis:\n host: 127.0.0.1\n port: 10020\n password: hrt123456\n database: 0\n cloud:\n gateway:\n globalcors:\n cors-configurations:\n \'[/**]\':\n allowedOrigins: \"*\" \n allowedMethods: \"*\" \n allowedHeaders: \"*\"\n maxAge: 360000 \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-member\n uri: lb://ruoyi-member\n predicates:\n - Path=/member/**\n filters:\n - StripPrefix=1\n # 商户服务\n - id: ruoyi-shop\n uri: lb://ruoyi-shop\n predicates:\n - Path=/shop/**\n filters:\n - StripPrefix=1\n # 订单服务\n - id: ruoyi-order\n uri: lb://ruoyi-order\n predicates:\n - Path=/order/**\n filters:\n - StripPrefix=1\n # 商品服务\n - id: ruoyi-goods\n uri: lb://ruoyi-goods\n predicates:\n - Path=/goods/**\n filters:\n - StripPrefix=1\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/h5/oauthUrl\n - /auth/h5/oauthStaffUrl\n - /auth/h5/oauthUser\n - /auth/h5/oauthStaff\n - /auth/login\n - /auth/miniLogin\n - /auth/miniRegister\n - /auth/register\n - /*/v2/api-docs\n - /file/uploadOSS\n - /file/batchUploadOSS\n - /system/app/config/getAppAgreement\n - /system/app/home/getAdvert\n - /system/app/home/getHomeBanner\n - /system/app/home/getQuickEntry\n - /system/app/home/getPop\n - /system/qywx/qywxNotify\n - /shop/app/home/getShopInfo\n - /goods/app/goods/getGoodsInfo\n - /shop/app/home/getNearbyShop\n - /goods/app/home/pageRecommendGoods\n - /goods/app/home/pageActivityGoods\n - /goods/app/home/pageShopGoods\n - /goods/app/activity/pageAppActivityGoods\n - /system/mgt/config/getCustomConfig\n - /order/app/notify/payNotify\n - /shop/mgt/shop/merchantBasicdataNotify\n - /order/app/notify/wechatPaymentCallback\n - /order/app/notify/wechatPaymentRefundCallback\n\n ', '1330bb8d129bd18ea9b1ee6b81314b59', '2023-11-13 08:52:13', '2023-11-13 09:43:52', 'nacos', '221.182.45.100', '', 'e1a7e419-e8c7-4d7d-8a0a-c00ab6ccfccd', '', '', '', 'yaml', '', NULL); INSERT INTO `config_info` VALUES (204, 'ruoyi-auth-dev.yml', 'DEFAULT_GROUP', 'spring:\n redis:\n host: 127.0.0.1\n port: 10020\n password: hrt123456\n database: 0\n# swagger配置\nswagger:\n title: 授权登录接口文档\n license: Powered By 鸿瑞堂\n basePackage: com.ruoyi.auth.controller\n licenseUrl: https://ruoyi.vip\n\nh5:\n redirectMerchantUriBase: http://wxapp.hhhrt.cn/merchant\n redirectEmployeeUriBase: http://wxapp.hhhrt.cn/employee\n', '2a299351bd020b99ba65305adc69f92f', '2023-11-13 08:52:13', '2023-11-13 09:44:19', 'nacos', '221.182.45.100', '', 'e1a7e419-e8c7-4d7d-8a0a-c00ab6ccfccd', '', '', '', 'yaml', '', NULL); INSERT INTO `config_info` VALUES (205, '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', '2023-11-13 08:52:13', '2023-11-13 08:52:13', NULL, '221.182.45.100', '', 'e1a7e419-e8c7-4d7d-8a0a-c00ab6ccfccd', NULL, NULL, NULL, 'yaml', NULL, NULL); INSERT INTO `config_info` VALUES (206, 'ruoyi-system-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n redis:\n host: 127.0.0.1\n port: 10020\n password: hrt123456\n database: 0\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://127.0.0.1:10010/hrt_sys?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: hrt123456\n # 从库数据源\n # slave:\n # username: \n # password: \n # url: \n # driver-class-name: \n seata: true # 开启seata代理，开启后默认每个数据源都代理，如果某个不需要代理可单独关闭\n\n# seata配置\nseata:\n # 默认关闭，如需启用spring.datasource.dynami.seata需要同时开启\n enabled: true\n # Seata 应用编号，默认为 ${spring.application.name}\n application-id: ${spring.application.name}\n # Seata 事务组编号，用于 TC 集群名\n tx-service-group: ruoyi-system-group\n # 关闭自动代理\n enable-auto-data-source-proxy: false\n # 服务配置项\n service:\n # 虚拟组和分组的映射\n vgroup-mapping:\n ruoyi-system-group: default\n config:\n type: nacos\n nacos:\n serverAddr: 47.109.78.184:5000\n group: SEATA_GROUP\n namespace: e1a7e419-e8c7-4d7d-8a0a-c00ab6ccfccd\n userName: nacos\n password: nacos\n registry:\n type: nacos\n nacos:\n application: seata-server\n server-addr: 47.109.78.184:5000\n group: SEATA_GROUP\n namespace: e1a7e419-e8c7-4d7d-8a0a-c00ab6ccfccd\n userName: nacos\n password: nacos\n\n\nmybatis:\n type-aliases-package: com.ruoyi.system\n mapper-locations: classpath:mapper/**/*.xml\n configuration:\n map-underscore-to-camel-case: true\n # org.apache.ibatis.logging.nologging.NoLoggingImpl\n #log-impl: org.apache.ibatis.logging.nologging.NoLoggingImpl\n log-impl: org.apache.ibatis.logging.stdout.StdOutImpl\n\nmybatis-plus:\n type-aliases-package: com.ruoyi.system\n mapper-locations: classpath:mapper/**/*.xml\n configuration:\n map-underscore-to-camel-case: true\n log-impl: org.apache.ibatis.logging.stdout.StdOutImpl\n\n# swagger配置\nswagger:\n title: 系统模块接口文档\n license: Powered By ruoyi\n basePackage: com.ruoyi.system.controller\n licenseUrl: https://ruoyi.vip', 'd532af68f3a53df63f4b6eaeb5ba359a', '2023-11-13 08:52:13', '2023-11-13 09:45:27', 'nacos', '221.182.45.100', '', 'e1a7e419-e8c7-4d7d-8a0a-c00ab6ccfccd', '', '', '', 'yaml', '', NULL); INSERT INTO `config_info` VALUES (207, 'ruoyi-gen-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n redis:\n host: 127.0.0.1\n port: 10020\n password: hrt123456\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://127.0.0.1:10010/hongruitang?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: hrt123456\n\n# mybatis配置\nmybatis:\n # 搜索指定包别名\n typeAliasesPackage: com.ruoyi.gen.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\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', '1797240c0e8c2e6402a81f46979c8bc2', '2023-11-13 08:52:13', '2023-11-13 09:45:54', 'nacos', '221.182.45.100', '', 'e1a7e419-e8c7-4d7d-8a0a-c00ab6ccfccd', '', '', '', 'yaml', '', NULL); INSERT INTO `config_info` VALUES (208, 'ruoyi-job-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n redis:\n host: 127.0.0.1\n port: 10020\n password: hrt123456\n database: 0\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: 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', 'ed94d986977d9bdb0acd851ec0f5da6d', '2023-11-13 08:52:13', '2023-11-13 09:46:19', 'nacos', '221.182.45.100', '', 'e1a7e419-e8c7-4d7d-8a0a-c00ab6ccfccd', '', '', '', 'yaml', '', NULL); INSERT INTO `config_info` VALUES (209, 'ruoyi-file-dev.yml', 'DEFAULT_GROUP', '# 本地文件上传 \nfile:\n domain: http://127.0.0.1:9300\n path: D:/ruoyi/uploadPath\n prefix: /statics\n\n# spring配置\nspring:\n redis:\n host: 127.0.0.1\n port: 10020\n password: hrt123456', 'd3c38e7e760e219019592b99248c1b56', '2023-11-13 08:52:13', '2023-11-13 09:46:49', 'nacos', '221.182.45.100', '', 'e1a7e419-e8c7-4d7d-8a0a-c00ab6ccfccd', '', '', '', 'yaml', '', NULL); INSERT INTO `config_info` VALUES (210, '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', '2023-11-13 08:52:13', '2023-11-13 08:52:13', NULL, '221.182.45.100', '', 'e1a7e419-e8c7-4d7d-8a0a-c00ab6ccfccd', NULL, NULL, NULL, 'text', NULL, NULL); INSERT INTO `config_info` VALUES (211, 'ruoyi-member-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n redis:\n host: 127.0.0.1\n port: 10020\n password: hrt123456\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://8.137.105.173:10010/hrt_member?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: hrt123456\n # 从库数据源\n # slave:\n # username: \n # password: \n # url: \n # driver-class-name: \n primary: master\n seata: true # 开启seata代理，开启后默认每个数据源都代理，如果某个不需要代理可单独关闭\n# seata配置\nseata:\n # 默认关闭，如需启用spring.datasource.dynami.seata需要同时开启\n enabled: true\n # Seata 应用编号，默认为 ${spring.application.name}\n application-id: ${spring.application.name}\n # Seata 事务组编号，用于 TC 集群名\n tx-service-group: ruoyi-member-group\n # 关闭自动代理\n enable-auto-data-source-proxy: false\n # 服务配置项\n service:\n # 虚拟组和分组的映射\n vgroup-mapping:\n ruoyi-member-group: default\n config:\n type: nacos\n nacos:\n serverAddr: 47.109.78.184:5000\n group: SEATA_GROUP\n namespace: e1a7e419-e8c7-4d7d-8a0a-c00ab6ccfccd\n userName: nacos\n password: nacos\n registry:\n type: nacos\n nacos:\n application: seata-server\n server-addr: 47.109.78.184:5000\n group: SEATA_GROUP\n namespace: e1a7e419-e8c7-4d7d-8a0a-c00ab6ccfccd\n userName: nacos\n password: nacos\n\nmybatis:\n type-aliases-package: com.ruoyi.member\n mapper-locations: classpath:mapper/**/*.xml\n\n\nmybatis-plus:\n type-aliases-package: com.ruoyi.member\n mapper-locations: classpath:mapper/**/*.xml\n\n\n# swagger配置\nswagger:\n title: 会员模块接口文档\n license: Powered By ruoyi\n basePackage: com.ruoyi.member.controller\n licenseUrl: https://ruoyi.vip', '7ac6afeab251a87cad75e76dc9870dd4', '2023-11-13 08:52:13', '2024-03-06 08:45:28', 'nacos', '221.182.45.100', '', 'e1a7e419-e8c7-4d7d-8a0a-c00ab6ccfccd', '', '', '', 'yaml', '', NULL); INSERT INTO `config_info` VALUES (212, 'ruoyi-shop-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n redis:\n host: 127.0.0.1\n port: 10020\n password: hrt123456\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://127.0.0.1:10010/hrt_shop?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: hrt123456\n # 从库数据源\n # slave:\n # username: \n # password: \n # url: \n # driver-class-name: \n seata: true # 开启seata代理，开启后默认每个数据源都代理，如果某个不需要代理可单独关闭\n\n# seata配置\nseata:\n # 默认关闭，如需启用spring.datasource.dynami.seata需要同时开启\n enabled: true\n # Seata 应用编号，默认为 ${spring.application.name}\n application-id: ${spring.application.name}\n # Seata 事务组编号，用于 TC 集群名\n tx-service-group: ruoyi-shop-group\n # 关闭自动代理\n enable-auto-data-source-proxy: false\n # 服务配置项\n service:\n # 虚拟组和分组的映射\n vgroup-mapping:\n ruoyi-shop-group: default\n config:\n type: nacos\n nacos:\n serverAddr: 47.109.78.184:5000\n group: SEATA_GROUP\n namespace: e1a7e419-e8c7-4d7d-8a0a-c00ab6ccfccd\n userName: nacos\n password: nacos\n registry:\n type: nacos\n nacos:\n application: seata-server\n server-addr: 47.109.78.184:5000\n group: SEATA_GROUP\n namespace: e1a7e419-e8c7-4d7d-8a0a-c00ab6ccfccd\n userName: nacos\n password: nacos\n\n\nmybatis:\n type-aliases-package: com.ruoyi.shop\n mapper-locations: classpath:mapper/**/*.xml\n\n\nmybatis-plus:\n type-aliases-package: com.ruoyi.shop\n mapper-locations: classpath:mapper/**/*.xml\n\n\n# swagger配置\nswagger:\n title: 商户模块接口文档\n license: Powered By ruoyi\n basePackage: com.ruoyi.shop.controller\n licenseUrl: https://ruoyi.vip', 'a6d6152d293cba5a1c594d05c4666195', '2023-11-13 08:52:13', '2023-11-13 09:48:34', 'nacos', '221.182.45.100', '', 'e1a7e419-e8c7-4d7d-8a0a-c00ab6ccfccd', '', '', '', 'yaml', '', NULL); INSERT INTO `config_info` VALUES (213, 'ruoyi-order-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n redis:\n host: 127.0.0.1\n port: 10020\n password: hrt123456\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://8.137.105.173:10010/hrt_order?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: hrt123456\n # 从库数据源\n # slave:\n # username: \n # password: \n # url: \n # driver-class-name: \n seata: true # 开启seata代理，开启后默认每个数据源都代理，如果某个不需要代理可单独关闭\n\n# seata配置\nseata:\n # 默认关闭，如需启用spring.datasource.dynami.seata需要同时开启\n enabled: true\n # Seata 应用编号，默认为 ${spring.application.name}\n application-id: ${spring.application.name}\n # Seata 事务组编号，用于 TC 集群名\n tx-service-group: ruoyi-order-group\n # 关闭自动代理\n enable-auto-data-source-proxy: false\n # 服务配置项\n service:\n # 虚拟组和分组的映射\n vgroup-mapping:\n ruoyi-order-group: default\n config:\n type: nacos\n nacos:\n serverAddr: 47.109.78.184:5000\n group: SEATA_GROUP\n namespace: e1a7e419-e8c7-4d7d-8a0a-c00ab6ccfccd\n userName: nacos\n password: nacos\n registry:\n type: nacos\n nacos:\n application: seata-server\n server-addr: 47.109.78.184:5000\n group: SEATA_GROUP\n namespace: e1a7e419-e8c7-4d7d-8a0a-c00ab6ccfccd\n userName: nacos\n password: nacos\n\n\nmybatis:\n type-aliases-package: com.ruoyi.order\n mapper-locations: classpath:mapper/**/*.xml\n\nmybatis-plus:\n type-aliases-package: com.ruoyi.order\n mapper-locations: classpath:mapper/**/*.xml\n\n\n# swagger配置\nswagger:\n title: 订单模块接口文档\n license: Powered By ruoyi\n basePackage: com.ruoyi.order.controller\n licenseUrl: https://ruoyi.vip', '6c00ab313cbc8d334676640082140772', '2023-11-13 08:52:13', '2024-03-05 03:35:42', 'nacos', '221.182.45.100', '', 'e1a7e419-e8c7-4d7d-8a0a-c00ab6ccfccd', '', '', '', 'yaml', '', NULL); INSERT INTO `config_info` VALUES (214, 'ruoyi-goods-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring:\n redis:\n host: 127.0.0.1\n port: 10020\n password: hrt123456\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://127.0.0.1:10010/hrt_goods?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: hrt123456\n # 从库数据源\n # slave:\n # username: \n # password: \n # url: \n # driver-class-name: \n seata: true # 开启seata代理，开启后默认每个数据源都代理，如果某个不需要代理可单独关闭\n\n# seata配置\nseata:\n # 默认关闭，如需启用spring.datasource.dynami.seata需要同时开启\n enabled: true\n # Seata 应用编号，默认为 ${spring.application.name}\n application-id: ${spring.application.name}\n # Seata 事务组编号，用于 TC 集群名\n tx-service-group: ruoyi-goods-group\n # 关闭自动代理\n enable-auto-data-source-proxy: false\n # 服务配置项\n service:\n # 虚拟组和分组的映射\n vgroup-mapping:\n ruoyi-goods-group: default\n config:\n type: nacos\n nacos:\n serverAddr: 47.109.78.184:5000\n group: SEATA_GROUP\n namespace: e1a7e419-e8c7-4d7d-8a0a-c00ab6ccfccd\n userName: nacos\n password: nacos\n registry:\n type: nacos\n nacos:\n application: seata-server\n server-addr: 47.109.78.184:5000\n group: SEATA_GROUP\n namespace: e1a7e419-e8c7-4d7d-8a0a-c00ab6ccfccd\n userName: nacos\n password: nacos\n\n\nmybatis:\n type-aliases-package: com.ruoyi.goods\n mapper-locations: classpath:mapper/**/*.xml\n\nmybatis-plus:\n type-aliases-package: com.ruoyi.goods\n mapper-locations: classpath:mapper/**/*.xml\n\n\n# swagger配置\nswagger:\n title: 订单模块接口文档\n license: Powered By ruoyi\n basePackage: com.ruoyi.goods.controller\n licenseUrl: https://ruoyi.vip', 'ff7a8cebef10571eb23e69d34985b299', '2023-11-13 08:52:13', '2023-11-13 09:49:33', 'nacos', '221.182.45.100', '', 'e1a7e419-e8c7-4d7d-8a0a-c00ab6ccfccd', '', '', '', 'yaml', '', NULL); INSERT INTO `config_info` VALUES (215, 'seataServer.yml', 'DEFAULT_GROUP', 'service:\r\n vgroupMapping:\r\n ruoyi-system-group: default\r\nstore:\r\n db:\r\n datasource: druid\r\n dbType: mysql\r\n driverClassName: com.mysql.jdbc.Driver #此处请注意 5.x版本请使用com.mysql.jdbc.Driver 8以上版本请使用 com.mysql.cj.jdbc.Driver\r\n url: jdbc:mysql://127.0.0.1:10010/ry-seata?useUnicode=true #创建的库(后边有教程)\r\n user: root #数据库账号（自行修改）\r\n password: hrt123456 #数据库密码（自行修改）\r\n globalTable: global_table\r\n lockTable: lock_table\r\n branchTable: branch_table\r\n maxConn: 30\r\n maxWait: 5000\r\n minConn: 5\r\n queryLimit: 100\r\n mode: db', '7a1a49ea5162a75a09571b0ae595ed50', '2023-11-13 08:52:13', '2023-11-13 08:52:13', NULL, '221.182.45.100', '', 'e1a7e419-e8c7-4d7d-8a0a-c00ab6ccfccd', NULL, NULL, NULL, 'yaml', NULL, NULL); INSERT INTO `config_info` VALUES (216, 'service.vgroupMapping.ruoyi-order-group', 'SEATA_GROUP', 'default', 'c21f969b5f03d33d43e04f8f136e7682', '2023-11-13 08:52:13', '2023-11-13 08:52:13', NULL, '221.182.45.100', '', 'e1a7e419-e8c7-4d7d-8a0a-c00ab6ccfccd', NULL, NULL, NULL, 'text', NULL, NULL); INSERT INTO `config_info` VALUES (217, 'service.vgroupMapping.ruoyi-goods-group', 'SEATA_GROUP', 'default', 'c21f969b5f03d33d43e04f8f136e7682', '2023-11-13 08:52:13', '2023-11-13 08:52:13', NULL, '221.182.45.100', '', 'e1a7e419-e8c7-4d7d-8a0a-c00ab6ccfccd', NULL, NULL, NULL, 'text', NULL, NULL); INSERT INTO `config_info` VALUES (218, 'service.vgroupMapping.ruoyi-shop-group', 'SEATA_GROUP', 'default', 'c21f969b5f03d33d43e04f8f136e7682', '2023-11-13 08:52:13', '2023-11-13 08:52:13', NULL, '221.182.45.100', '', 'e1a7e419-e8c7-4d7d-8a0a-c00ab6ccfccd', NULL, NULL, NULL, 'text', NULL, NULL); INSERT INTO `config_info` VALUES (219, 'service.vgroupMapping.ruoyi-member-group', 'SEATA_GROUP', 'default', 'c21f969b5f03d33d43e04f8f136e7682', '2023-11-13 08:52:13', '2023-11-13 08:52:13', NULL, '221.182.45.100', '', 'e1a7e419-e8c7-4d7d-8a0a-c00ab6ccfccd', NULL, NULL, NULL, 'text', NULL, NULL); INSERT INTO `config_info` VALUES (220, 'service.vgroupMapping.ruoyi-system-group', 'SEATA_GROUP', 'default', 'c21f969b5f03d33d43e04f8f136e7682', '2023-11-13 08:52:13', '2023-11-13 08:52:13', NULL, '221.182.45.100', '', 'e1a7e419-e8c7-4d7d-8a0a-c00ab6ccfccd', NULL, NULL, NULL, 'text', NULL, 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(0) 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(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间', `gmt_modified` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) 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 '租户字段', 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(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间', `gmt_modified` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) 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(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间', `gmt_modified` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) 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(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0), `gmt_modified` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0), `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 '租户字段', 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 = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '多租户改造' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of his_config_info -- ---------------------------- -- ---------------------------- -- 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 -- ---------------------------- INSERT INTO `permissions` VALUES ('ROLE_ADMIN', ':*:*', 'rw'); -- ---------------------------- -- 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(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间', `gmt_modified` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) 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 = 4 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'tenant_info' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tenant_info -- ---------------------------- INSERT INTO `tenant_info` VALUES (2, '1', '9591ef9f-a49a-4900-be35-d77258bdd639', 'pro', '生产环境', 'nacos', 1692353757325, 1692353757325); INSERT INTO `tenant_info` VALUES (3, '1', 'e1a7e419-e8c7-4d7d-8a0a-c00ab6ccfccd', 'test', '测试环境', 'nacos', 1699865369569, 1699865369569); -- ---------------------------- -- 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); INSERT INTO `users` VALUES ('Se', '$2a$10$VS2kOS7EYQL6DKvGVd4XlONe4Wpl3qcBxPrao03EVYbP5GLL8WQ8.', 1); SET FOREIGN_KEY_CHECKS = 1;