صفحهٔ اصلی گشت‌و‌گذار راهنما
ثبت نام ورود
zrd
/
server
1
0
انشعاب 0
پرونده‌ها مشکلات 0 درخواست واکشی 0 ویکی
درخت: f91b07cca0
شاخه‌ها تگ‌ها
server
/
build-cloud
/
sql
/
config.sql

config.sql 80 KB
تاريخچه خام

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399 
  1. /*
    2. 

  2.  Navicat Premium Data Transfer
    3. 

  3. 

  4.  Source Server         : 167
    5. 

  5.  Source Server Type    : MySQL
    6. 

  6.  Source Server Version : 50734
    7. 

  7.  Source Host           : 192.168.0.167:3306
    8. 

  8.  Source Schema         : config
    9. 

  9. 

  10.  Target Server Type    : MySQL
    11. 

  11.  Target Server Version : 50734
    12. 

  12.  File Encoding         : 65001
    13. 

  13. 

  14.  Date: 06/08/2021 17:13:04
    15. 

  15. */
    16. 

  16. 

  17. SET NAMES utf8mb4;
    18. 

  18. SET FOREIGN_KEY_CHECKS = 0;
    19. 

  19. 

  20. -- ----------------------------
    21. 

  21. -- Table structure for config_info
    22. 

  22. -- ----------------------------
    23. 

  23. DROP TABLE IF EXISTS `config_info`;
    24. 

  24. CREATE TABLE `config_info`  (
    25. 

  25.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
    26. 

  26.   `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id',
    27. 

  27.   `group_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
    28. 

  28.   `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'content',
    29. 

  29.   `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'md5',
    30. 

  30.   `gmt_create` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
    31. 

  31.   `gmt_modified` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '修改时间',
    32. 

  32.   `src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT 'source user',
    33. 

  33.   `src_ip` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'source ip',
    34. 

  34.   `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
    35. 

  35.   `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT '租户字段',
    36. 

  36.   `c_desc` varchar(256) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
    37. 

  37.   `c_use` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
    38. 

  38.   `effect` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
    39. 

  39.   `type` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
    40. 

  40.   `c_schema` text CHARACTER SET utf8 COLLATE utf8_bin NULL,
    41. 

  41.   PRIMARY KEY (`id`) USING BTREE,
    42. 

  42.   UNIQUE INDEX `uk_configinfo_datagrouptenant`(`data_id`, `group_id`, `tenant_id`) USING BTREE
    43. 

  43. ) ENGINE = InnoDB AUTO_INCREMENT = 134 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'config_info' ROW_FORMAT = Dynamic;
    44. 

  44. 

  45. -- ----------------------------
    46. 

  46. -- Records of config_info
    47. 

  47. -- ----------------------------
    48. 

  48. INSERT INTO `config_info` VALUES (1, 'application-dev.yml', 'DEFAULT_GROUP', 'spring:\n  main:\n    allow-bean-definition-overriding: true\n\n#请求处理的超时时间\nribbon:\n  ReadTimeout: 100000\n  ConnectTimeout: 100000\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: 100000\n        readTimeout: 100000\n  compression:\n    request:\n      enabled: true\n    response:\n      enabled: true\n\n# 暴露监控端点\nmanagement:\n  endpoints:\n    web:\n      exposure:\n        include: \'*\'\n', '7f429d2fe6d113b518599b51151ca476', '2019-11-29 16:31:20', '2020-12-24 02:30:25', NULL, '192.168.0.140', '', '', '通用配置', 'null', 'null', 'yaml', 'null');
    49. 

  49. INSERT INTO `config_info` VALUES (2, 'ruoyi-gateway-dev.yml', 'DEFAULT_GROUP', 'spring:\n  redis:\n    host: 192.168.0.167\n    port: 6379\n    password: \n  cloud:\n    gateway:\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# 安全配置\nsecurity:\n  # 验证码\n  captcha:\n    enabled: true\n    type: math\n  # 防止XSS攻击\n  xss:\n    enabled: true\n    excludeUrls:\n      - /system/notice\n  # 不校验白名单\n  ignore:\n    whites:\n      - /auth/logout\n      - /auth/login\n      - /auth/register\n      - /*/v2/api-docs\n      - /csrf\n', 'e77b7a55078de2d3f4d1a5fcca08a077', '2020-05-14 14:17:55', '2021-08-06 09:03:01', NULL, '192.168.0.247', '', '', '网关模块', 'null', 'null', 'yaml', 'null');
    50. 

  50. INSERT INTO `config_info` VALUES (3, 'ruoyi-auth-dev.yml', 'DEFAULT_GROUP', 'spring: \n  datasource:\n    driver-class-name: com.mysql.cj.jdbc.Driver\n    url: jdbc:mysql://192.168.0.167:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n    username: root\n    password: root\n  redis:\n    host: 192.168.0.167\n    port: 6379\n    password: \n', '2e8b0bba86032003e2a1c850d793d7ae', '2020-11-20 00:00:00', '2021-08-06 07:24:55', NULL, '192.168.0.247', '', '', '认证中心', 'null', 'null', 'yaml', 'null');
    51. 

  51. INSERT INTO `config_info` VALUES (4, 'ruoyi-monitor-dev.yml', 'DEFAULT_GROUP', '# Spring\r\nspring: \r\n  security:\r\n    user:\r\n      name: ruoyi\r\n      password: 123456\r\n  boot:\r\n    admin:\r\n      ui:\r\n        title: 若依服务状态监控\r\n', '8e49d78998a7780d780305aeefe4fb1b', '2020-11-20 00:00:00', '2020-11-20 00:00:00', NULL, '0:0:0:0:0:0:0:1', '', '', '监控中心', 'null', 'null', 'yaml', 'null');
    52. 

  52. INSERT INTO `config_info` VALUES (5, 'ruoyi-system-dev.yml', 'DEFAULT_GROUP', '# spring配置\nspring: \n  redis:\n    host: 192.168.0.167\n    port: 6379\n    password: \n  datasource:\n    druid:\n      stat-view-servlet:\n        enabled: true\n        loginUsername: admin\n        loginPassword: 123456\n    dynamic:\n      druid:\n        initial-size: 5\n        min-idle: 5\n        maxActive: 20\n        maxWait: 60000\n        timeBetweenEvictionRunsMillis: 60000\n        minEvictableIdleTimeMillis: 300000\n        validationQuery: SELECT 1 FROM DUAL\n        testWhileIdle: true\n        testOnBorrow: false\n        testOnReturn: false\n        poolPreparedStatements: true\n        maxPoolPreparedStatementPerConnectionSize: 20\n        filters: stat,slf4j\n        connectionProperties: druid.stat.mergeSql\\=true;druid.stat.slowSqlMillis\\=5000\n      datasource:\n          # 主库数据源\n          master:\n            driver-class-name: com.mysql.cj.jdbc.Driver\n            url: jdbc:mysql://192.168.0.167:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n            username: root\n            password: root\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: false\n  # Seata 应用编号，默认为 ${spring.application.name}\n  application-id: ${spring.application.name}\n  # Seata 事务组编号，用于 TC 集群名\n  tx-service-group: ${spring.application.name}-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: 192.168.0.167:8848\n      group: SEATA_GROUP\n      namespace:\n  registry:\n    type: nacos\n    nacos:\n      application: seata-server\n      server-addr: 192.168.0.167:8848\n      namespace:\n\n# mybatis配置\nmybatis-plus:\n    # 搜索指定包别名\n    typeAliasesPackage: com.ruoyi.system\n    # 配置mapper的扫描，找到所有的mapper.xml映射文件\n    mapperLocations: classpath:mapper/**/*.xml\n    global-config:\n      db-config:\n        #主键类型 AUTO:\"数据库ID自增\" INPUT:\"用户输入ID\",ID_WORKER:\"全局唯一ID (数字类型唯一ID)\", UUID:\"全局唯一ID UUID\";\n        id-type: auto\n    configuration:\n        # 是否开启自动驼峰命名规则映射:从数据库列名到Java属性驼峰命名的类似映射\n        map-underscore-to-camel-case: true\n        # 返回map时true:当查询数据为空时字段返回为null,false:不加这个查询数据为空时，字段将被隐藏\n        call-setters-on-nulls: true\n        # 这个配置会将执行的sql打印出来，在开发或测试的时候可以用\n        log-impl: org.apache.ibatis.logging.stdout.StdOutImpl\n\n\n# swagger配置\nswagger:\n  title: 系统模块接口文档\n  license: Powered By ruoyi\n  licenseUrl: https://ruoyi.vip', '4eb352ce3f60d0b82f6d36a3c2c4eb01', '2020-11-20 00:00:00', '2021-08-06 09:07:39', NULL, '192.168.0.247', '', '', '系统模块', 'null', 'null', 'yaml', 'null');
    53. 

  53. INSERT INTO `config_info` VALUES (6, 'ruoyi-gen-dev.yml', 'DEFAULT_GROUP', '# Spring\nspring: \n  redis:\n    host: 192.168.0.167\n    port: 6379\n    password: \n  datasource: \n    driver-class-name: com.mysql.cj.jdbc.Driver\n    url: jdbc:mysql://192.168.0.167:3306/ry-gen?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n    username: root\n    password: root\n  flyway:\n    baseline-on-migrate: true\n# Mybatis配置\nmybatis-plus:\n    # 搜索指定包别名\n    typeAliasesPackage: com.ruoyi.gen.domain\n    # 配置mapper的扫描，找到所有的mapper.xml映射文件\n    mapperLocations: classpath:mapper/**/*.xml\n    global-config:\n      db-config:\n        #主键类型 AUTO:\"数据库ID自增\" INPUT:\"用户输入ID\",ID_WORKER:\"全局唯一ID (数字类型唯一ID)\", UUID:\"全局唯一ID UUID\";\n        id-type: auto\n    configuration:\n        # 是否开启自动驼峰命名规则映射:从数据库列名到Java属性驼峰命名的类似映射\n        map-underscore-to-camel-case: true\n        # 返回map时true:当查询数据为空时字段返回为null,false:不加这个查询数据为空时，字段将被隐藏\n        call-setters-on-nulls: true\n        # 这个配置会将执行的sql打印出来，在开发或测试的时候可以用\n        log-impl: org.apache.ibatis.logging.stdout.StdOutImpl\n# swagger 配置\nswagger:\n  title: 代码生成接口文档\n  license: Powered By ruoyi\n  licenseUrl: https://ruoyi.vip\n  authorization:\n    name: RuoYi OAuth\n    auth-regex: ^.*$\n    authorization-scope-list:\n      - scope: server\n        description: 客户端授权范围\n    token-url-list:\n      - http://localhost:8080/auth/oauth/token\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', 'b796019a3cf5715f25214ae69b186104', '2020-11-20 00:00:00', '2021-08-06 07:35:24', NULL, '192.168.0.247', '', '', '代码生成', 'null', 'null', 'yaml', 'null');
    54. 

  54. INSERT INTO `config_info` VALUES (7, 'ruoyi-job-dev.yml', 'DEFAULT_GROUP', '# Spring\nspring: \n  redis:\n    host: 192.168.0.167\n    port: 6379\n    password: \n  datasource:\n    driver-class-name: com.mysql.cj.jdbc.Driver\n    url: jdbc:mysql://192.168.0.167:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n    username: root\n    password: root\n\n# Mybatis配置\nmybatis-plus:\n    # 搜索指定包别名\n    typeAliasesPackage: com.ruoyi.job.domain\n    # 配置mapper的扫描，找到所有的mapper.xml映射文件\n    mapperLocations: classpath:mapper/**/*.xml\n    global-config:\n      db-config:\n        #主键类型 AUTO:\"数据库ID自增\" INPUT:\"用户输入ID\",ID_WORKER:\"全局唯一ID (数字类型唯一ID)\", UUID:\"全局唯一ID UUID\";\n        id-type: auto\n    configuration:\n        # 是否开启自动驼峰命名规则映射:从数据库列名到Java属性驼峰命名的类似映射\n        map-underscore-to-camel-case: true\n        # 返回map时true:当查询数据为空时字段返回为null,false:不加这个查询数据为空时，字段将被隐藏\n        call-setters-on-nulls: true\n        # 这个配置会将执行的sql打印出来，在开发或测试的时候可以用\n        log-impl: org.apache.ibatis.logging.stdout.StdOutImpl\n# swagger 配置\nswagger:\n  title: 定时任务接口文档\n  license: Powered By ruoyi\n  licenseUrl: https://ruoyi.vip\n  authorization:\n    name: RuoYi OAuth\n    auth-regex: ^.*$\n    authorization-scope-list:\n      - scope: server\n        description: 客户端授权范围\n    token-url-list:\n      - http://localhost:8080/auth/oauth/token\n', '04f9ac13305b6d3c715ac8763cbefc6c', '2020-11-20 00:00:00', '2021-08-06 07:56:46', NULL, '192.168.0.247', '', '', '定时任务', 'null', 'null', 'yaml', 'null');
    55. 

  55. INSERT INTO `config_info` VALUES (8, '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# FastDFS配置\nfdfs:\n  domain: http://8.129.231.12\n  soTimeout: 3000\n  connectTimeout: 2000\n  trackerList: 8.129.231.12:22122\n\n# Minio配置\nminio:\n  url: http://192.168.0.167:4000\n  accessKey: admin\n  secretKey: admin123\n  bucketName: test', 'b77c2a4451f7fee1dfe7759db08a8129', '2020-11-20 00:00:00', '2021-08-06 07:57:09', NULL, '192.168.0.247', '', '', '文件服务', 'null', 'null', 'yaml', 'null');
    56. 

  56. 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');
    57. 

  57. INSERT INTO `config_info` VALUES (14, 'ruoyi-gateway.yml', 'DEFAULT_GROUP', 'spring:\r\n  redis:\r\n    host: 172.21.41.195\r\n    port: 6379\r\n    password: \r\n  cloud:\r\n    gateway:\r\n      discovery:\r\n        locator:\r\n          lowerCaseServiceId: true\r\n          enabled: true\r\n      routes:\r\n        # 认证中心\r\n        - id: ruoyi-auth\r\n          uri: lb://ruoyi-auth\r\n          predicates:\r\n            - Path=/auth/**\r\n          filters:\r\n            # 验证码处理\r\n            - CacheRequestFilter\r\n            - ValidateCodeFilter\r\n            - StripPrefix=1\r\n        # 代码生成\r\n        - id: ruoyi-gen\r\n          uri: lb://ruoyi-gen\r\n          predicates:\r\n            - Path=/code/**\r\n          filters:\r\n            - StripPrefix=1\r\n        # 定时任务\r\n        - id: ruoyi-job\r\n          uri: lb://ruoyi-job\r\n          predicates:\r\n            - Path=/schedule/**\r\n          filters:\r\n            - StripPrefix=1\r\n        # 系统模块\r\n        - id: ruoyi-system\r\n          uri: lb://ruoyi-system\r\n          predicates:\r\n            - Path=/system/**\r\n          filters:\r\n            - StripPrefix=1\r\n        # 文件服务\r\n        - id: ruoyi-file\r\n          uri: lb://ruoyi-file\r\n          predicates:\r\n            - Path=/file/**\r\n          filters:\r\n            - StripPrefix=1\r\n\r\n# 不校验白名单\r\nignore:\r\n  whites:\r\n    - /auth/logout\r\n    - /auth/login\r\n    - /*/v2/api-docs\r\n    - /csrf\r\n', '9eef00e22965cb3dc16cd78e30c76b39', '2020-12-22 21:04:28', '2021-01-20 00:45:42', NULL, '192.168.128.1', '', '', '', '', '', 'yaml', '');
    58. 

  58. INSERT INTO `config_info` VALUES (15, 'application-dev-bak.yml', 'DEFAULT_GROUP', 'spring:\n  main:\n    allow-bean-definition-overriding: true\n\n#请求处理的超时时间\nribbon:\n  ReadTimeout: 10000\n  ConnectTimeout: 10000\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', '57470c6d167154919418fa150863b7fb', '2020-12-23 03:08:47', '2020-12-23 03:08:47', NULL, '192.168.0.140', '', '', NULL, NULL, NULL, 'yaml', NULL);
    59. 

  59. INSERT INTO `config_info` VALUES (16, 'ruoyi-gateway-dev-bak.yml', 'DEFAULT_GROUP', 'spring:\r\n  redis:\r\n    host: 192.168.0.222\r\n    port: 6379\r\n    password: \r\n  cloud:\r\n    gateway:\r\n      discovery:\r\n        locator:\r\n          lowerCaseServiceId: true\r\n          enabled: true\r\n      routes:\r\n        # 认证中心\r\n        - id: ruoyi-auth\r\n          uri: lb://ruoyi-auth\r\n          predicates:\r\n            - Path=/auth/**\r\n          filters:\r\n            # 验证码处理\r\n            - CacheRequestFilter\r\n            - ValidateCodeFilter\r\n            - StripPrefix=1\r\n        # 代码生成\r\n        - id: ruoyi-gen\r\n          uri: lb://ruoyi-gen\r\n          predicates:\r\n            - Path=/code/**\r\n          filters:\r\n            - StripPrefix=1\r\n        # 定时任务\r\n        - id: ruoyi-job\r\n          uri: lb://ruoyi-job\r\n          predicates:\r\n            - Path=/schedule/**\r\n          filters:\r\n            - StripPrefix=1\r\n        # 系统模块\r\n        - id: ruoyi-system\r\n          uri: lb://ruoyi-system\r\n          predicates:\r\n            - Path=/system/**\r\n          filters:\r\n            - StripPrefix=1\r\n        # 文件服务\r\n        - id: ruoyi-file\r\n          uri: lb://ruoyi-file\r\n          predicates:\r\n            - Path=/file/**\r\n          filters:\r\n            - StripPrefix=1\r\n\r\n# 不校验白名单\r\nignore:\r\n  whites:\r\n    - /auth/logout\r\n    - /auth/login\r\n    - /*/v2/api-docs\r\n    - /csrf\r\n', 'cbe259b236f899f64b6859aff3882a1c', '2020-12-23 03:08:47', '2020-12-23 03:08:47', NULL, '192.168.0.140', '', '', NULL, NULL, NULL, 'yaml', NULL);
    60. 

  60. INSERT INTO `config_info` VALUES (17, 'ruoyi-auth-dev-bak.yml', 'DEFAULT_GROUP', 'spring: \r\n  datasource:\r\n    driver-class-name: com.mysql.cj.jdbc.Driver\r\n    url: jdbc:mysql://192.168.0.222:3308/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\r\n    username: root\r\n    password: 123456\r\n  redis:\r\n    host: 192.168.0.222\r\n    port: 6379\r\n    password: \r\n', '1b18ba9896574265beb7a79ed64715e9', '2020-12-23 03:08:47', '2020-12-23 03:08:47', NULL, '192.168.0.140', '', '', NULL, NULL, NULL, 'yaml', NULL);
    61. 

  61. INSERT INTO `config_info` VALUES (18, 'ruoyi-monitor-dev-bak.yml', 'DEFAULT_GROUP', '# Spring\r\nspring: \r\n  security:\r\n    user:\r\n      name: ruoyi\r\n      password: 123456\r\n  boot:\r\n    admin:\r\n      ui:\r\n        title: 若依服务状态监控\r\n', '8e49d78998a7780d780305aeefe4fb1b', '2020-12-23 03:08:47', '2020-12-23 03:08:47', NULL, '192.168.0.140', '', '', NULL, NULL, NULL, 'yaml', NULL);
    62. 

  62. INSERT INTO `config_info` VALUES (19, 'ruoyi-system-dev-bak.yml', 'DEFAULT_GROUP', '# Spring\r\nspring: \r\n  redis:\r\n    host: 192.168.0.222\r\n    port: 6379\r\n    password: \r\n  datasource:\r\n    driver-class-name: com.mysql.cj.jdbc.Driver\r\n    url: jdbc:mysql://192.168.0.222:3308/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\r\n    username: root\r\n    password: 123456\r\n\r\n# Mybatis配置\r\nmybatis:\r\n    # 搜索指定包别名\r\n    typeAliasesPackage: com.ruoyi.system\r\n    # 配置mapper的扫描，找到所有的mapper.xml映射文件\r\n    mapperLocations: classpath:mapper/**/*.xml\r\n\r\n# swagger 配置\r\nswagger:\r\n  title: 系统模块接口文档\r\n  license: Powered By ruoyi\r\n  licenseUrl: https://ruoyi.vip\r\n  authorization:\r\n    name: RuoYi OAuth\r\n    auth-regex: ^.*$\r\n    authorization-scope-list:\r\n      - scope: server\r\n        description: 客户端授权范围\r\n    token-url-list:\r\n      - http://localhost:8080/auth/oauth/token\r\n', 'eab92b88b9cab8bf33967fe12074809a', '2020-12-23 03:08:47', '2020-12-23 03:08:47', NULL, '192.168.0.140', '', '', NULL, NULL, NULL, 'yaml', NULL);
    63. 

  63. INSERT INTO `config_info` VALUES (20, 'ruoyi-gen-dev-bak.yml', 'DEFAULT_GROUP', '# Spring\r\nspring: \r\n  redis:\r\n    host: 192.168.0.222\r\n    port: 6379\r\n    password: \r\n  datasource: \r\n    driver-class-name: com.mysql.cj.jdbc.Driver\r\n    url: jdbc:mysql://192.168.0.222:3308/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\r\n    username: root\r\n    password: 123456\r\n\r\n# Mybatis配置\r\nmybatis:\r\n    # 搜索指定包别名\r\n    typeAliasesPackage: com.ruoyi.gen.domain\r\n    # 配置mapper的扫描，找到所有的mapper.xml映射文件\r\n    mapperLocations: classpath:mapper/**/*.xml\r\n\r\n# swagger 配置\r\nswagger:\r\n  title: 代码生成接口文档\r\n  license: Powered By ruoyi\r\n  licenseUrl: https://ruoyi.vip\r\n  authorization:\r\n    name: RuoYi OAuth\r\n    auth-regex: ^.*$\r\n    authorization-scope-list:\r\n      - scope: server\r\n        description: 客户端授权范围\r\n    token-url-list:\r\n      - http://localhost:8080/auth/oauth/token\r\n\r\n# 代码生成\r\ngen: \r\n  # 作者\r\n  author: ruoyi\r\n  # 默认生成包路径 system 需改成自己的模块名称 如 system monitor tool\r\n  packageName: com.ruoyi.system\r\n  # 自动去除表前缀，默认是false\r\n  autoRemovePre: false\r\n  # 表前缀（生成类名不会包含表前缀，多个用逗号分隔）\r\n  tablePrefix: sys_\r\n', '44a9111558d711c44eba43d51f147e71', '2020-12-23 03:08:47', '2020-12-23 03:08:47', NULL, '192.168.0.140', '', '', NULL, NULL, NULL, 'yaml', NULL);
    64. 

  64. INSERT INTO `config_info` VALUES (21, 'ruoyi-job-dev-bak.yml', 'DEFAULT_GROUP', '# Spring\r\nspring: \r\n  redis:\r\n    host: 192.168.0.222\r\n    port: 6379\r\n    password: \r\n  datasource:\r\n    driver-class-name: com.mysql.cj.jdbc.Driver\r\n    url: jdbc:mysql://192.168.0.222:3308/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\r\n    username: root\r\n    password: 123456\r\n\r\n# Mybatis配置\r\nmybatis:\r\n    # 搜索指定包别名\r\n    typeAliasesPackage: com.ruoyi.job.domain\r\n    # 配置mapper的扫描，找到所有的mapper.xml映射文件\r\n    mapperLocations: classpath:mapper/**/*.xml\r\n\r\n# swagger 配置\r\nswagger:\r\n  title: 定时任务接口文档\r\n  license: Powered By ruoyi\r\n  licenseUrl: https://ruoyi.vip\r\n  authorization:\r\n    name: RuoYi OAuth\r\n    auth-regex: ^.*$\r\n    authorization-scope-list:\r\n      - scope: server\r\n        description: 客户端授权范围\r\n    token-url-list:\r\n      - http://localhost:8080/auth/oauth/token\r\n', 'ca32cfa3f18844cedea106a1afe33587', '2020-12-23 03:08:47', '2020-12-23 03:08:47', NULL, '192.168.0.140', '', '', NULL, NULL, NULL, 'yaml', NULL);
    65. 

  65. INSERT INTO `config_info` VALUES (22, 'ruoyi-file-dev-bak.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://127.0.0.1\r\n  soTimeout: 3000\r\n  connectTimeout: 2000\r\n  trackerList: 127.0.0.1:22122', 'e6aae59c07b40c652044268052841566', '2020-12-23 03:08:47', '2020-12-23 03:08:47', NULL, '192.168.0.140', '', '', NULL, NULL, NULL, 'yaml', NULL);
    66. 

  66. INSERT INTO `config_info` VALUES (23, 'ruoyi-file-dev11.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');
    67. 

  67. INSERT INTO `config_info` VALUES (37, 'transport.server', 'SEATA_GROUP', 'NIO', 'b6d9dfc0fb54277321cebc0fff55df2f', '2021-02-03 02:47:12', '2021-02-03 02:47:12', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    68. 

  68. INSERT INTO `config_info` VALUES (38, 'transport.heartbeat', 'SEATA_GROUP', 'true', 'b326b5062b2f0e69046810717534cb09', '2021-02-03 02:47:13', '2021-02-03 02:47:13', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    69. 

  69. INSERT INTO `config_info` VALUES (39, 'transport.enableClientBatchSendRequest', 'SEATA_GROUP', 'false', '68934a3e9455fa72420237eb05902327', '2021-02-03 02:47:14', '2021-02-03 02:47:14', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    70. 

  70. INSERT INTO `config_info` VALUES (40, 'transport.threadFactory.bossThreadPrefix', 'SEATA_GROUP', 'NettyBoss', '0f8db59a3b7f2823f38a70c308361836', '2021-02-03 02:47:17', '2021-02-03 02:47:17', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    71. 

  71. INSERT INTO `config_info` VALUES (41, 'transport.threadFactory.workerThreadPrefix', 'SEATA_GROUP', 'NettyServerNIOWorker', 'a78ec7ef5d1631754c4e72ae8a3e9205', '2021-02-03 02:47:21', '2021-02-03 02:47:21', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    72. 

  72. INSERT INTO `config_info` VALUES (42, 'transport.threadFactory.serverExecutorThreadPrefix', 'SEATA_GROUP', 'NettyServerBizHandler', '11a36309f3d9df84fa8b59cf071fa2da', '2021-02-03 02:47:21', '2021-02-03 02:47:21', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    73. 

  73. INSERT INTO `config_info` VALUES (43, 'transport.threadFactory.shareBossWorker', 'SEATA_GROUP', 'false', '68934a3e9455fa72420237eb05902327', '2021-02-03 02:47:22', '2021-02-03 02:47:22', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    74. 

  74. INSERT INTO `config_info` VALUES (44, 'transport.threadFactory.clientSelectorThreadPrefix', 'SEATA_GROUP', 'NettyClientSelector', 'cd7ec5a06541e75f5a7913752322c3af', '2021-02-03 02:47:23', '2021-02-03 02:47:23', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    75. 

  75. INSERT INTO `config_info` VALUES (45, 'transport.threadFactory.clientSelectorThreadSize', 'SEATA_GROUP', '1', 'c4ca4238a0b923820dcc509a6f75849b', '2021-02-03 02:47:24', '2021-02-03 02:47:24', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    76. 

  76. INSERT INTO `config_info` VALUES (46, 'transport.threadFactory.clientWorkerThreadPrefix', 'SEATA_GROUP', 'NettyClientWorkerThread', '61cf4e69a56354cf72f46dc86414a57e', '2021-02-03 02:47:24', '2021-02-03 02:47:24', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    77. 

  77. INSERT INTO `config_info` VALUES (47, 'transport.threadFactory.bossThreadSize', 'SEATA_GROUP', '1', 'c4ca4238a0b923820dcc509a6f75849b', '2021-02-03 02:47:24', '2021-02-03 02:47:24', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    78. 

  78. INSERT INTO `config_info` VALUES (48, 'transport.threadFactory.workerThreadSize', 'SEATA_GROUP', 'default', 'c21f969b5f03d33d43e04f8f136e7682', '2021-02-03 02:47:24', '2021-02-03 02:47:24', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    79. 

  79. INSERT INTO `config_info` VALUES (49, 'transport.shutdown.wait', 'SEATA_GROUP', '3', 'eccbc87e4b5ce2fe28308fd9f2a7baf3', '2021-02-03 02:47:25', '2021-02-03 02:47:25', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    80. 

  80. INSERT INTO `config_info` VALUES (50, 'service.vgroupMapping.my_test_tx_group', 'SEATA_GROUP', 'default', 'c21f969b5f03d33d43e04f8f136e7682', '2021-02-03 02:47:26', '2021-02-03 02:47:26', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    81. 

  81. INSERT INTO `config_info` VALUES (51, 'service.default.grouplist', 'SEATA_GROUP', '172.21.41.195:8091', '7b089a5f5f3e3642f07cbb60dc65a714', '2021-02-03 02:47:27', '2021-02-03 02:47:27', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    82. 

  82. INSERT INTO `config_info` VALUES (52, 'service.enableDegrade', 'SEATA_GROUP', 'false', '68934a3e9455fa72420237eb05902327', '2021-02-03 02:47:27', '2021-02-03 02:47:27', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    83. 

  83. INSERT INTO `config_info` VALUES (53, 'service.disableGlobalTransaction', 'SEATA_GROUP', 'false', '68934a3e9455fa72420237eb05902327', '2021-02-03 02:47:28', '2021-02-03 02:47:28', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    84. 

  84. INSERT INTO `config_info` VALUES (54, 'client.rm.asyncCommitBufferLimit', 'SEATA_GROUP', '10000', 'b7a782741f667201b54880c925faec4b', '2021-02-03 02:47:29', '2021-02-03 02:47:29', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    85. 

  85. INSERT INTO `config_info` VALUES (55, 'client.rm.lock.retryInterval', 'SEATA_GROUP', '10', 'd3d9446802a44259755d38e6d163e820', '2021-02-03 02:47:29', '2021-02-03 02:47:29', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    86. 

  86. INSERT INTO `config_info` VALUES (56, 'client.rm.lock.retryTimes', 'SEATA_GROUP', '30', '34173cb38f07f89ddbebc2ac9128303f', '2021-02-03 02:47:29', '2021-02-03 02:47:29', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    87. 

  87. INSERT INTO `config_info` VALUES (57, 'client.rm.lock.retryPolicyBranchRollbackOnConflict', 'SEATA_GROUP', 'true', 'b326b5062b2f0e69046810717534cb09', '2021-02-03 02:47:30', '2021-02-03 02:47:30', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    88. 

  88. INSERT INTO `config_info` VALUES (58, 'client.rm.reportRetryCount', 'SEATA_GROUP', '5', 'e4da3b7fbbce2345d7772b0674a318d5', '2021-02-03 02:47:30', '2021-02-03 02:47:30', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    89. 

  89. INSERT INTO `config_info` VALUES (59, 'client.rm.tableMetaCheckEnable', 'SEATA_GROUP', 'false', '68934a3e9455fa72420237eb05902327', '2021-02-03 02:47:30', '2021-02-03 02:47:30', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    90. 

  90. INSERT INTO `config_info` VALUES (60, 'client.rm.tableMetaCheckerInterval', 'SEATA_GROUP', '60000', '2b4226dd7ed6eb2d419b881f3ae9c97c', '2021-02-03 02:47:31', '2021-02-03 02:47:31', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    91. 

  91. INSERT INTO `config_info` VALUES (61, 'client.rm.sqlParserType', 'SEATA_GROUP', 'druid', '3d650fb8a5df01600281d48c47c9fa60', '2021-02-03 02:47:31', '2021-02-03 02:47:31', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    92. 

  92. INSERT INTO `config_info` VALUES (62, 'client.rm.reportSuccessEnable', 'SEATA_GROUP', 'false', '68934a3e9455fa72420237eb05902327', '2021-02-03 02:47:32', '2021-02-03 02:47:32', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    93. 

  93. INSERT INTO `config_info` VALUES (63, 'client.rm.sagaBranchRegisterEnable', 'SEATA_GROUP', 'false', '68934a3e9455fa72420237eb05902327', '2021-02-03 02:47:32', '2021-02-03 02:47:32', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    94. 

  94. INSERT INTO `config_info` VALUES (64, 'client.tm.commitRetryCount', 'SEATA_GROUP', '5', 'e4da3b7fbbce2345d7772b0674a318d5', '2021-02-03 02:47:33', '2021-02-03 02:47:33', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    95. 

  95. INSERT INTO `config_info` VALUES (65, 'client.tm.rollbackRetryCount', 'SEATA_GROUP', '5', 'e4da3b7fbbce2345d7772b0674a318d5', '2021-02-03 02:47:33', '2021-02-03 02:47:33', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    96. 

  96. INSERT INTO `config_info` VALUES (66, 'client.tm.defaultGlobalTransactionTimeout', 'SEATA_GROUP', '60000', '2b4226dd7ed6eb2d419b881f3ae9c97c', '2021-02-03 02:47:34', '2021-02-03 02:47:34', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    97. 

  97. INSERT INTO `config_info` VALUES (67, 'client.tm.degradeCheck', 'SEATA_GROUP', 'false', '68934a3e9455fa72420237eb05902327', '2021-02-03 02:47:34', '2021-02-03 02:47:34', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    98. 

  98. INSERT INTO `config_info` VALUES (68, 'client.tm.degradeCheckAllowTimes', 'SEATA_GROUP', '10', 'd3d9446802a44259755d38e6d163e820', '2021-02-03 02:47:35', '2021-02-03 02:47:35', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    99. 

  99. INSERT INTO `config_info` VALUES (69, 'client.tm.degradeCheckPeriod', 'SEATA_GROUP', '2000', '08f90c1a417155361a5c4b8d297e0d78', '2021-02-03 02:47:36', '2021-02-03 02:47:36', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    100. 

  100. INSERT INTO `config_info` VALUES (70, 'store.mode', 'SEATA_GROUP', 'file', '8c7dd922ad47494fc02c388e12c00eac', '2021-02-03 02:47:36', '2021-02-03 02:47:36', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    101. 

  101. INSERT INTO `config_info` VALUES (71, 'store.file.dir', 'SEATA_GROUP', 'file_store/data', '6a8dec07c44c33a8a9247cba5710bbb2', '2021-02-03 02:47:37', '2021-02-03 02:47:37', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    102. 

  102. INSERT INTO `config_info` VALUES (72, 'store.file.maxBranchSessionSize', 'SEATA_GROUP', '16384', 'c76fe1d8e08462434d800487585be217', '2021-02-03 02:47:38', '2021-02-03 02:47:38', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    103. 

  103. INSERT INTO `config_info` VALUES (73, 'store.file.maxGlobalSessionSize', 'SEATA_GROUP', '512', '10a7cdd970fe135cf4f7bb55c0e3b59f', '2021-02-03 02:47:38', '2021-02-03 02:47:38', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    104. 

  104. INSERT INTO `config_info` VALUES (74, 'store.file.fileWriteBufferCacheSize', 'SEATA_GROUP', '16384', 'c76fe1d8e08462434d800487585be217', '2021-02-03 02:47:38', '2021-02-03 02:47:38', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    105. 

  105. INSERT INTO `config_info` VALUES (75, 'store.file.flushDiskMode', 'SEATA_GROUP', 'async', '0df93e34273b367bb63bad28c94c78d5', '2021-02-03 02:47:39', '2021-02-03 02:47:39', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    106. 

  106. INSERT INTO `config_info` VALUES (76, 'store.file.sessionReloadReadSize', 'SEATA_GROUP', '100', 'f899139df5e1059396431415e770c6dd', '2021-02-03 02:47:39', '2021-02-03 02:47:39', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    107. 

  107. INSERT INTO `config_info` VALUES (77, 'store.db.datasource', 'SEATA_GROUP', 'druid', '3d650fb8a5df01600281d48c47c9fa60', '2021-02-03 02:47:39', '2021-02-03 02:47:39', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    108. 

  108. INSERT INTO `config_info` VALUES (78, 'store.db.dbType', 'SEATA_GROUP', 'mysql', '81c3b080dad537de7e10e0987a4bf52e', '2021-02-03 02:47:39', '2021-02-03 02:47:39', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    109. 

  109. INSERT INTO `config_info` VALUES (79, 'store.db.driverClassName', 'SEATA_GROUP', 'com.mysql.jdbc.Driver', '683cf0c3a5a56cec94dfac94ca16d760', '2021-02-03 02:47:40', '2021-02-03 02:47:40', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    110. 

  110. INSERT INTO `config_info` VALUES (80, 'store.db.url', 'SEATA_GROUP', 'jdbc:mysql://172.21.41.195:3306/sy-seata?useUnicode=true&rewriteBatchedStatements=true', '354abd2820eadae2547f34184a61fcbf', '2021-02-03 02:47:40', '2021-02-03 02:47:40', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    111. 

  111. INSERT INTO `config_info` VALUES (81, 'store.db.user', 'SEATA_GROUP', 'root', '63a9f0ea7bb98050796b649e85481845', '2021-02-03 02:47:41', '2021-02-03 02:47:41', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    112. 

  112. INSERT INTO `config_info` VALUES (82, 'store.db.password', 'SEATA_GROUP', '123456', 'e10adc3949ba59abbe56e057f20f883e', '2021-02-03 02:47:41', '2021-02-03 02:47:41', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    113. 

  113. INSERT INTO `config_info` VALUES (83, 'store.db.minConn', 'SEATA_GROUP', '5', 'e4da3b7fbbce2345d7772b0674a318d5', '2021-02-03 02:47:42', '2021-02-03 02:47:42', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    114. 

  114. INSERT INTO `config_info` VALUES (84, 'store.db.maxConn', 'SEATA_GROUP', '30', '34173cb38f07f89ddbebc2ac9128303f', '2021-02-03 02:47:42', '2021-02-03 02:47:42', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    115. 

  115. INSERT INTO `config_info` VALUES (85, 'store.db.globalTable', 'SEATA_GROUP', 'global_table', '8b28fb6bb4c4f984df2709381f8eba2b', '2021-02-03 02:47:43', '2021-02-03 02:47:43', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    116. 

  116. INSERT INTO `config_info` VALUES (86, 'store.db.branchTable', 'SEATA_GROUP', 'branch_table', '54bcdac38cf62e103fe115bcf46a660c', '2021-02-03 02:47:43', '2021-02-03 02:47:43', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    117. 

  117. INSERT INTO `config_info` VALUES (87, 'store.db.queryLimit', 'SEATA_GROUP', '100', 'f899139df5e1059396431415e770c6dd', '2021-02-03 02:47:44', '2021-02-03 02:47:44', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    118. 

  118. INSERT INTO `config_info` VALUES (88, 'store.db.lockTable', 'SEATA_GROUP', 'lock_table', '55e0cae3b6dc6696b768db90098b8f2f', '2021-02-03 02:47:44', '2021-02-03 02:47:44', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    119. 

  119. INSERT INTO `config_info` VALUES (89, 'store.db.maxWait', 'SEATA_GROUP', '5000', 'a35fe7f7fe8217b4369a0af4244d1fca', '2021-02-03 02:47:45', '2021-02-03 02:47:45', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    120. 

  120. INSERT INTO `config_info` VALUES (90, 'store.redis.mode', 'SEATA_GROUP', 'single', 'dd5c07036f2975ff4bce568b6511d3bc', '2021-02-03 02:47:45', '2021-02-03 02:47:45', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    121. 

  121. INSERT INTO `config_info` VALUES (91, 'store.redis.single.host', 'SEATA_GROUP', '127.0.0.1', 'f528764d624db129b32c21fbca0cb8d6', '2021-02-03 02:47:46', '2021-02-03 02:47:46', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    122. 

  122. INSERT INTO `config_info` VALUES (92, 'store.redis.single.port', 'SEATA_GROUP', '6379', '92c3b916311a5517d9290576e3ea37ad', '2021-02-03 02:47:46', '2021-02-03 02:47:46', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    123. 

  123. INSERT INTO `config_info` VALUES (93, 'store.redis.maxConn', 'SEATA_GROUP', '10', 'd3d9446802a44259755d38e6d163e820', '2021-02-03 02:47:47', '2021-02-03 02:47:47', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    124. 

  124. INSERT INTO `config_info` VALUES (94, 'store.redis.minConn', 'SEATA_GROUP', '1', 'c4ca4238a0b923820dcc509a6f75849b', '2021-02-03 02:47:47', '2021-02-03 02:47:47', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    125. 

  125. INSERT INTO `config_info` VALUES (95, 'store.redis.maxTotal', 'SEATA_GROUP', '100', 'f899139df5e1059396431415e770c6dd', '2021-02-03 02:47:47', '2021-02-03 02:47:47', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    126. 

  126. INSERT INTO `config_info` VALUES (96, 'store.redis.database', 'SEATA_GROUP', '0', 'cfcd208495d565ef66e7dff9f98764da', '2021-02-03 02:47:48', '2021-02-03 02:47:48', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    127. 

  127. INSERT INTO `config_info` VALUES (97, 'store.redis.queryLimit', 'SEATA_GROUP', '100', 'f899139df5e1059396431415e770c6dd', '2021-02-03 02:47:49', '2021-02-03 02:47:49', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    128. 

  128. INSERT INTO `config_info` VALUES (98, 'server.recovery.committingRetryPeriod', 'SEATA_GROUP', '1000', 'a9b7ba70783b617e9998dc4dd82eb3c5', '2021-02-03 02:47:49', '2021-02-03 02:47:49', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    129. 

  129. INSERT INTO `config_info` VALUES (99, 'server.recovery.asynCommittingRetryPeriod', 'SEATA_GROUP', '1000', 'a9b7ba70783b617e9998dc4dd82eb3c5', '2021-02-03 02:47:50', '2021-02-03 02:47:50', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    130. 

  130. INSERT INTO `config_info` VALUES (100, 'server.recovery.rollbackingRetryPeriod', 'SEATA_GROUP', '1000', 'a9b7ba70783b617e9998dc4dd82eb3c5', '2021-02-03 02:47:50', '2021-02-03 02:47:50', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    131. 

  131. INSERT INTO `config_info` VALUES (101, 'server.recovery.timeoutRetryPeriod', 'SEATA_GROUP', '1000', 'a9b7ba70783b617e9998dc4dd82eb3c5', '2021-02-03 02:47:51', '2021-02-03 02:47:51', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    132. 

  132. INSERT INTO `config_info` VALUES (102, 'server.maxCommitRetryTimeout', 'SEATA_GROUP', '-1', '6bb61e3b7bce0931da574d19d1d82c88', '2021-02-03 02:47:51', '2021-02-03 02:47:51', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    133. 

  133. INSERT INTO `config_info` VALUES (103, 'server.maxRollbackRetryTimeout', 'SEATA_GROUP', '-1', '6bb61e3b7bce0931da574d19d1d82c88', '2021-02-03 02:47:52', '2021-02-03 02:47:52', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    134. 

  134. INSERT INTO `config_info` VALUES (104, 'server.rollbackRetryTimeoutUnlockEnable', 'SEATA_GROUP', 'false', '68934a3e9455fa72420237eb05902327', '2021-02-03 02:47:52', '2021-02-03 02:47:52', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    135. 

  135. INSERT INTO `config_info` VALUES (105, 'client.undo.dataValidation', 'SEATA_GROUP', 'true', 'b326b5062b2f0e69046810717534cb09', '2021-02-03 02:47:53', '2021-02-03 02:47:53', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    136. 

  136. INSERT INTO `config_info` VALUES (106, 'client.undo.logSerialization', 'SEATA_GROUP', 'jackson', 'b41779690b83f182acc67d6388c7bac9', '2021-02-03 02:47:53', '2021-02-03 02:47:53', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    137. 

  137. INSERT INTO `config_info` VALUES (107, 'client.undo.onlyCareUpdateColumns', 'SEATA_GROUP', 'true', 'b326b5062b2f0e69046810717534cb09', '2021-02-03 02:47:54', '2021-02-03 02:47:54', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    138. 

  138. INSERT INTO `config_info` VALUES (108, 'server.undo.logSaveDays', 'SEATA_GROUP', '7', '8f14e45fceea167a5a36dedd4bea2543', '2021-02-03 02:47:54', '2021-02-03 02:47:54', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    139. 

  139. INSERT INTO `config_info` VALUES (109, 'server.undo.logDeletePeriod', 'SEATA_GROUP', '86400000', 'f4c122804fe9076cb2710f55c3c6e346', '2021-02-03 02:47:54', '2021-02-03 02:47:54', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    140. 

  140. INSERT INTO `config_info` VALUES (110, 'client.undo.logTable', 'SEATA_GROUP', 'undo_log', '2842d229c24afe9e61437135e8306614', '2021-02-03 02:47:54', '2021-02-03 02:47:54', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    141. 

  141. INSERT INTO `config_info` VALUES (111, 'client.undo.compress.enable', 'SEATA_GROUP', 'true', 'b326b5062b2f0e69046810717534cb09', '2021-02-03 02:47:55', '2021-02-03 02:47:55', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    142. 

  142. INSERT INTO `config_info` VALUES (112, 'client.undo.compress.type', 'SEATA_GROUP', 'zip', 'adcdbd79a8d84175c229b192aadc02f2', '2021-02-03 02:47:55', '2021-02-03 02:47:55', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    143. 

  143. INSERT INTO `config_info` VALUES (113, 'client.undo.compress.threshold', 'SEATA_GROUP', '64k', 'bd44a6458bdbff0b5cac721ba361f035', '2021-02-03 02:47:55', '2021-02-03 02:47:55', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    144. 

  144. INSERT INTO `config_info` VALUES (114, 'log.exceptionRate', 'SEATA_GROUP', '100', 'f899139df5e1059396431415e770c6dd', '2021-02-03 02:47:55', '2021-02-03 02:47:55', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    145. 

  145. INSERT INTO `config_info` VALUES (115, 'transport.serialization', 'SEATA_GROUP', 'seata', 'b943081c423b9a5416a706524ee05d40', '2021-02-03 02:47:56', '2021-02-03 02:47:56', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    146. 

  146. INSERT INTO `config_info` VALUES (116, 'transport.compressor', 'SEATA_GROUP', 'none', '334c4a4c42fdb79d7ebc3e73b517e6f8', '2021-02-03 02:47:56', '2021-02-03 02:47:56', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    147. 

  147. INSERT INTO `config_info` VALUES (117, 'metrics.enabled', 'SEATA_GROUP', 'false', '68934a3e9455fa72420237eb05902327', '2021-02-03 02:47:56', '2021-02-03 02:47:56', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    148. 

  148. INSERT INTO `config_info` VALUES (118, 'metrics.registryType', 'SEATA_GROUP', 'compact', '7cf74ca49c304df8150205fc915cd465', '2021-02-03 02:47:57', '2021-02-03 02:47:57', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    149. 

  149. INSERT INTO `config_info` VALUES (119, 'metrics.exporterList', 'SEATA_GROUP', 'prometheus', 'e4f00638b8a10e6994e67af2f832d51c', '2021-02-03 02:47:57', '2021-02-03 02:47:57', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    150. 

  150. INSERT INTO `config_info` VALUES (120, 'metrics.exporterPrometheusPort', 'SEATA_GROUP', '9898', '7b9dc501afe4ee11c56a4831e20cee71', '2021-02-03 02:47:57', '2021-02-03 02:47:57', NULL, '192.168.128.1', '', '', NULL, NULL, NULL, NULL, NULL);
    151. 

  151. 

  152. -- ----------------------------
    153. 

  153. -- Table structure for config_info_aggr
    154. 

  154. -- ----------------------------
    155. 

  155. DROP TABLE IF EXISTS `config_info_aggr`;
    156. 

  156. CREATE TABLE `config_info_aggr`  (
    157. 

  157.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
    158. 

  158.   `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id',
    159. 

  159.   `group_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'group_id',
    160. 

  160.   `datum_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'datum_id',
    161. 

  161.   `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '内容',
    162. 

  162.   `gmt_modified` datetime(0) NOT NULL COMMENT '修改时间',
    163. 

  163.   `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
    164. 

  164.   `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT '租户字段',
    165. 

  165.   PRIMARY KEY (`id`) USING BTREE,
    166. 

  166.   UNIQUE INDEX `uk_configinfoaggr_datagrouptenantdatum`(`data_id`, `group_id`, `tenant_id`, `datum_id`) USING BTREE
    167. 

  167. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '增加租户字段' ROW_FORMAT = Dynamic;
    168. 

  168. 

  169. -- ----------------------------
    170. 

  170. -- Records of config_info_aggr
    171. 

  171. -- ----------------------------
    172. 

  172. 

  173. -- ----------------------------
    174. 

  174. -- Table structure for config_info_beta
    175. 

  175. -- ----------------------------
    176. 

  176. DROP TABLE IF EXISTS `config_info_beta`;
    177. 

  177. CREATE TABLE `config_info_beta`  (
    178. 

  178.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
    179. 

  179.   `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id',
    180. 

  180.   `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'group_id',
    181. 

  181.   `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'app_name',
    182. 

  182.   `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'content',
    183. 

  183.   `beta_ips` varchar(1024) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'betaIps',
    184. 

  184.   `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'md5',
    185. 

  185.   `gmt_create` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
    186. 

  186.   `gmt_modified` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '修改时间',
    187. 

  187.   `src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT 'source user',
    188. 

  188.   `src_ip` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'source ip',
    189. 

  189.   `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT '租户字段',
    190. 

  190.   PRIMARY KEY (`id`) USING BTREE,
    191. 

  191.   UNIQUE INDEX `uk_configinfobeta_datagrouptenant`(`data_id`, `group_id`, `tenant_id`) USING BTREE
    192. 

  192. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'config_info_beta' ROW_FORMAT = Dynamic;
    193. 

  193. 

  194. -- ----------------------------
    195. 

  195. -- Records of config_info_beta
    196. 

  196. -- ----------------------------
    197. 

  197. 

  198. -- ----------------------------
    199. 

  199. -- Table structure for config_info_tag
    200. 

  200. -- ----------------------------
    201. 

  201. DROP TABLE IF EXISTS `config_info_tag`;
    202. 

  202. CREATE TABLE `config_info_tag`  (
    203. 

  203.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
    204. 

  204.   `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id',
    205. 

  205.   `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'group_id',
    206. 

  206.   `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT 'tenant_id',
    207. 

  207.   `tag_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'tag_id',
    208. 

  208.   `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'app_name',
    209. 

  209.   `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'content',
    210. 

  210.   `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'md5',
    211. 

  211.   `gmt_create` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
    212. 

  212.   `gmt_modified` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '修改时间',
    213. 

  213.   `src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT 'source user',
    214. 

  214.   `src_ip` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'source ip',
    215. 

  215.   PRIMARY KEY (`id`) USING BTREE,
    216. 

  216.   UNIQUE INDEX `uk_configinfotag_datagrouptenanttag`(`data_id`, `group_id`, `tenant_id`, `tag_id`) USING BTREE
    217. 

  217. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'config_info_tag' ROW_FORMAT = Dynamic;
    218. 

  218. 

  219. -- ----------------------------
    220. 

  220. -- Records of config_info_tag
    221. 

  221. -- ----------------------------
    222. 

  222. 

  223. -- ----------------------------
    224. 

  224. -- Table structure for config_tags_relation
    225. 

  225. -- ----------------------------
    226. 

  226. DROP TABLE IF EXISTS `config_tags_relation`;
    227. 

  227. CREATE TABLE `config_tags_relation`  (
    228. 

  228.   `id` bigint(20) NOT NULL COMMENT 'id',
    229. 

  229.   `tag_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'tag_name',
    230. 

  230.   `tag_type` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'tag_type',
    231. 

  231.   `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id',
    232. 

  232.   `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'group_id',
    233. 

  233.   `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT 'tenant_id',
    234. 

  234.   `nid` bigint(20) NOT NULL AUTO_INCREMENT,
    235. 

  235.   PRIMARY KEY (`nid`) USING BTREE,
    236. 

  236.   UNIQUE INDEX `uk_configtagrelation_configidtag`(`id`, `tag_name`, `tag_type`) USING BTREE,
    237. 

  237.   INDEX `idx_tenant_id`(`tenant_id`) USING BTREE
    238. 

  238. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'config_tag_relation' ROW_FORMAT = Dynamic;
    239. 

  239. 

  240. -- ----------------------------
    241. 

  241. -- Records of config_tags_relation
    242. 

  242. -- ----------------------------
    243. 

  243. 

  244. -- ----------------------------
    245. 

  245. -- Table structure for group_capacity
    246. 

  246. -- ----------------------------
    247. 

  247. DROP TABLE IF EXISTS `group_capacity`;
    248. 

  248. CREATE TABLE `group_capacity`  (
    249. 

  249.   `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
    250. 

  250.   `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'Group ID，空字符表示整个集群',
    251. 

  251.   `quota` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '配额，0表示使用默认值',
    252. 

  252.   `usage` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '使用量',
    253. 

  253.   `max_size` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '单个配置大小上限，单位为字节，0表示使用默认值',
    254. 

  254.   `max_aggr_count` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '聚合子配置最大个数，，0表示使用默认值',
    255. 

  255.   `max_aggr_size` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '单个聚合数据的子配置大小上限，单位为字节，0表示使用默认值',
    256. 

  256.   `max_history_count` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最大变更历史数量',
    257. 

  257.   `gmt_create` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
    258. 

  258.   `gmt_modified` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '修改时间',
    259. 

  259.   PRIMARY KEY (`id`) USING BTREE,
    260. 

  260.   UNIQUE INDEX `uk_group_id`(`group_id`) USING BTREE
    261. 

  261. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '集群、各Group容量信息表' ROW_FORMAT = Dynamic;
    262. 

  262. 

  263. -- ----------------------------
    264. 

  264. -- Records of group_capacity
    265. 

  265. -- ----------------------------
    266. 

  266. 

  267. -- ----------------------------
    268. 

  268. -- Table structure for his_config_info
    269. 

  269. -- ----------------------------
    270. 

  270. DROP TABLE IF EXISTS `his_config_info`;
    271. 

  271. CREATE TABLE `his_config_info`  (
    272. 

  272.   `id` bigint(64) UNSIGNED NOT NULL,
    273. 

  273.   `nid` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
    274. 

  274.   `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
    275. 

  275.   `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
    276. 

  276.   `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'app_name',
    277. 

  277.   `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
    278. 

  278.   `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
    279. 

  279.   `gmt_create` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
    280. 

  280.   `gmt_modified` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
    281. 

  281.   `src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL,
    282. 

  282.   `src_ip` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
    283. 

  283.   `op_type` char(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
    284. 

  284.   `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT '租户字段',
    285. 

  285.   PRIMARY KEY (`nid`) USING BTREE,
    286. 

  286.   INDEX `idx_gmt_create`(`gmt_create`) USING BTREE,
    287. 

  287.   INDEX `idx_gmt_modified`(`gmt_modified`) USING BTREE,
    288. 

  288.   INDEX `idx_did`(`data_id`) USING BTREE
    289. 

  289. ) ENGINE = InnoDB AUTO_INCREMENT = 136 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '多租户改造' ROW_FORMAT = Dynamic;
    290. 

  290. 

  291. -- ----------------------------
    292. 

  292. -- Records of his_config_info
    293. 

  293. -- ----------------------------
    294. 

  294. INSERT INTO `his_config_info` VALUES (2, 123, 'ruoyi-gateway-dev.yml', 'DEFAULT_GROUP', '', 'spring:\r\n  redis:\r\n    host: 172.21.41.195\r\n    port: 6379\r\n    password: \r\n  cloud:\r\n    gateway:\r\n      discovery:\r\n        locator:\r\n          lowerCaseServiceId: true\r\n          enabled: true\r\n      routes:\r\n        # 认证中心\r\n        - id: ruoyi-auth\r\n          uri: lb://ruoyi-auth\r\n          predicates:\r\n            - Path=/auth/**\r\n          filters:\r\n            # 验证码处理\r\n            - CacheRequestFilter\r\n            - ValidateCodeFilter\r\n            - StripPrefix=1\r\n        # 代码生成\r\n        - id: ruoyi-gen\r\n          uri: lb://ruoyi-gen\r\n          predicates:\r\n            - Path=/code/**\r\n          filters:\r\n            - StripPrefix=1\r\n        # 定时任务\r\n        - id: ruoyi-job\r\n          uri: lb://ruoyi-job\r\n          predicates:\r\n            - Path=/schedule/**\r\n          filters:\r\n            - StripPrefix=1\r\n        # 系统模块\r\n        - id: ruoyi-system\r\n          uri: lb://ruoyi-system\r\n          predicates:\r\n            - Path=/system/**\r\n          filters:\r\n            - StripPrefix=1\r\n        # 文件服务\r\n        - id: ruoyi-file\r\n          uri: lb://ruoyi-file\r\n          predicates:\r\n            - Path=/file/**\r\n          filters:\r\n            - StripPrefix=1\r\n\r\n# 不校验白名单\r\nignore:\r\n  whites:\r\n    - /auth/logout\r\n    - /auth/login\r\n    - /*/v2/api-docs\r\n    - /csrf\r\n', '77acde83f52e684c8e1975f518ccd4c2', '2021-08-06 07:18:03', '2021-08-06 07:18:04', NULL, '192.168.0.247', 'U', '');
    295. 

  295. INSERT INTO `his_config_info` VALUES (3, 124, 'ruoyi-auth-dev.yml', 'DEFAULT_GROUP', '', 'spring: \r\n  datasource:\r\n    driver-class-name: com.mysql.cj.jdbc.Driver\r\n    url: jdbc:mysql://172.21.41.195:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\r\n    username: root\r\n    password: 123456\r\n  redis:\r\n    host: 172.21.41.195\r\n    port: 6379\r\n    password: \r\n', 'eae0b29654870bc0e60a7f4f3729003c', '2021-08-06 07:24:55', '2021-08-06 07:24:55', NULL, '192.168.0.247', 'U', '');
    296. 

  296. INSERT INTO `his_config_info` VALUES (5, 125, 'ruoyi-system-dev.yml', 'DEFAULT_GROUP', '', '# spring配置\r\nspring: \r\n  redis:\r\n    host: 172.21.41.195\r\n    port: 6379\r\n    password: \r\n  datasource: \r\n    driver-class-name: com.mysql.cj.jdbc.Driver\r\n    url: jdbc:mysql://172.21.41.195:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\r\n    username: root\r\n    password: 123456\r\n      # seata: true    # 开启seata代理，开启后默认每个数据源都代理，如果某个不需要代理可单独关闭\r\n\r\n# seata配置\r\nseata:\r\n  # 默认关闭，如需启用spring.datasource.dynami.seata需要同时开启\r\n  enabled: false\r\n  # Seata 应用编号，默认为 ${spring.application.name}\r\n  application-id: ${spring.application.name}\r\n  # Seata 事务组编号，用于 TC 集群名\r\n  tx-service-group: ${spring.application.name}-group\r\n  # 关闭自动代理\r\n  enable-auto-data-source-proxy: false\r\n  # 服务配置项\r\n  service:\r\n    # 虚拟组和分组的映射\r\n    vgroup-mapping:\r\n      ruoyi-system-group: default\r\n  config:\r\n    type: nacos\r\n    nacos:\r\n      serverAddr: 172.21.41.195:7002\r\n      group: SEATA_GROUP\r\n      namespace:\r\n  registry:\r\n    type: nacos\r\n    nacos:\r\n      application: seata-server\r\n      server-addr: 172.21.41.195:7002\r\n      namespace:\r\n\r\n# mybatis配置\r\nmybatis-plus:\r\n    # 搜索指定包别名\r\n    typeAliasesPackage: com.ruoyi.system\r\n    # 配置mapper的扫描，找到所有的mapper.xml映射文件\r\n    mapperLocations: classpath:mapper/**/*.xml\r\n    global-config:\r\n      db-config:\r\n        #主键类型 AUTO:\"数据库ID自增\" INPUT:\"用户输入ID\",ID_WORKER:\"全局唯一ID (数字类型唯一ID)\", UUID:\"全局唯一ID UUID\";\r\n        id-type: auto\r\n    configuration:\r\n        # 是否开启自动驼峰命名规则映射:从数据库列名到Java属性驼峰命名的类似映射\r\n        map-underscore-to-camel-case: true\r\n        # 返回map时true:当查询数据为空时字段返回为null,false:不加这个查询数据为空时，字段将被隐藏\r\n        call-setters-on-nulls: true\r\n        # 这个配置会将执行的sql打印出来，在开发或测试的时候可以用\r\n        log-impl: org.apache.ibatis.logging.stdout.StdOutImpl\r\n\r\n# swagger配置\r\nswagger:\r\n  title: 系统模块接口文档\r\n  license: Powered By ruoyi\r\n  licenseUrl: https://ruoyi.vip', 'eae54e0ac303001152402c75d3d09cf9', '2021-08-06 07:29:04', '2021-08-06 07:29:05', NULL, '192.168.0.247', 'U', '');
    297. 

  297. INSERT INTO `his_config_info` VALUES (6, 126, 'ruoyi-gen-dev.yml', 'DEFAULT_GROUP', '', '# Spring\r\nspring: \r\n  redis:\r\n    host: 172.21.41.195\r\n    port: 6379\r\n    password: \r\n  datasource: \r\n    driver-class-name: com.mysql.cj.jdbc.Driver\r\n    url: jdbc:mysql://172.21.41.195:3306/ry-gen?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\r\n    username: root\r\n    password: 123456\r\n\r\n# Mybatis配置\r\nmybatis-plus:\r\n    # 搜索指定包别名\r\n    typeAliasesPackage: com.ruoyi.gen.domain\r\n    # 配置mapper的扫描，找到所有的mapper.xml映射文件\r\n    mapperLocations: classpath:mapper/**/*.xml\r\n    global-config:\r\n      db-config:\r\n        #主键类型 AUTO:\"数据库ID自增\" INPUT:\"用户输入ID\",ID_WORKER:\"全局唯一ID (数字类型唯一ID)\", UUID:\"全局唯一ID UUID\";\r\n        id-type: auto\r\n    configuration:\r\n        # 是否开启自动驼峰命名规则映射:从数据库列名到Java属性驼峰命名的类似映射\r\n        map-underscore-to-camel-case: true\r\n        # 返回map时true:当查询数据为空时字段返回为null,false:不加这个查询数据为空时，字段将被隐藏\r\n        call-setters-on-nulls: true\r\n        # 这个配置会将执行的sql打印出来，在开发或测试的时候可以用\r\n        log-impl: org.apache.ibatis.logging.stdout.StdOutImpl\r\n# swagger 配置\r\nswagger:\r\n  title: 代码生成接口文档\r\n  license: Powered By ruoyi\r\n  licenseUrl: https://ruoyi.vip\r\n  authorization:\r\n    name: RuoYi OAuth\r\n    auth-regex: ^.*$\r\n    authorization-scope-list:\r\n      - scope: server\r\n        description: 客户端授权范围\r\n    token-url-list:\r\n      - http://localhost:8080/auth/oauth/token\r\n\r\n# 代码生成\r\ngen: \r\n  # 作者\r\n  author: ruoyi\r\n  # 默认生成包路径 system 需改成自己的模块名称 如 system monitor tool\r\n  packageName: com.ruoyi.system\r\n  # 自动去除表前缀，默认是false\r\n  autoRemovePre: false\r\n  # 表前缀（生成类名不会包含表前缀，多个用逗号分隔）\r\n  tablePrefix: sys_\r\n', '5d51f2bb73e97a388f72a4940bfa7f8f', '2021-08-06 07:31:11', '2021-08-06 07:31:11', NULL, '192.168.0.247', 'U', '');
    298. 

  298. INSERT INTO `his_config_info` VALUES (6, 127, 'ruoyi-gen-dev.yml', 'DEFAULT_GROUP', '', '# Spring\nspring: \n  redis:\n    host: 192.168.0.167\n    port: 6379\n    password: \n  datasource: \n    driver-class-name: com.mysql.cj.jdbc.Driver\n    url: jdbc:mysql://192.168.0.167:3306/ry-gen?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n    username: root\n    password: root\n\n# Mybatis配置\nmybatis-plus:\n    # 搜索指定包别名\n    typeAliasesPackage: com.ruoyi.gen.domain\n    # 配置mapper的扫描，找到所有的mapper.xml映射文件\n    mapperLocations: classpath:mapper/**/*.xml\n    global-config:\n      db-config:\n        #主键类型 AUTO:\"数据库ID自增\" INPUT:\"用户输入ID\",ID_WORKER:\"全局唯一ID (数字类型唯一ID)\", UUID:\"全局唯一ID UUID\";\n        id-type: auto\n    configuration:\n        # 是否开启自动驼峰命名规则映射:从数据库列名到Java属性驼峰命名的类似映射\n        map-underscore-to-camel-case: true\n        # 返回map时true:当查询数据为空时字段返回为null,false:不加这个查询数据为空时，字段将被隐藏\n        call-setters-on-nulls: true\n        # 这个配置会将执行的sql打印出来，在开发或测试的时候可以用\n        log-impl: org.apache.ibatis.logging.stdout.StdOutImpl\n# swagger 配置\nswagger:\n  title: 代码生成接口文档\n  license: Powered By ruoyi\n  licenseUrl: https://ruoyi.vip\n  authorization:\n    name: RuoYi OAuth\n    auth-regex: ^.*$\n    authorization-scope-list:\n      - scope: server\n        description: 客户端授权范围\n    token-url-list:\n      - http://localhost:8080/auth/oauth/token\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', '264b7aecf7c2d988697b40c5696fbd63', '2021-08-06 07:35:23', '2021-08-06 07:35:24', NULL, '192.168.0.247', 'U', '');
    299. 

  299. INSERT INTO `his_config_info` VALUES (7, 128, 'ruoyi-job-dev.yml', 'DEFAULT_GROUP', '', '# Spring\r\nspring: \r\n  redis:\r\n    host: 172.21.41.195\r\n    port: 6379\r\n    password: \r\n  datasource:\r\n    driver-class-name: com.mysql.cj.jdbc.Driver\r\n    url: jdbc:mysql://172.21.41.195:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\r\n    username: root\r\n    password: 123456\r\n\r\n# Mybatis配置\r\nmybatis-plus:\r\n    # 搜索指定包别名\r\n    typeAliasesPackage: com.ruoyi.job.domain\r\n    # 配置mapper的扫描，找到所有的mapper.xml映射文件\r\n    mapperLocations: classpath:mapper/**/*.xml\r\n    global-config:\r\n      db-config:\r\n        #主键类型 AUTO:\"数据库ID自增\" INPUT:\"用户输入ID\",ID_WORKER:\"全局唯一ID (数字类型唯一ID)\", UUID:\"全局唯一ID UUID\";\r\n        id-type: auto\r\n    configuration:\r\n        # 是否开启自动驼峰命名规则映射:从数据库列名到Java属性驼峰命名的类似映射\r\n        map-underscore-to-camel-case: true\r\n        # 返回map时true:当查询数据为空时字段返回为null,false:不加这个查询数据为空时，字段将被隐藏\r\n        call-setters-on-nulls: true\r\n        # 这个配置会将执行的sql打印出来，在开发或测试的时候可以用\r\n        log-impl: org.apache.ibatis.logging.stdout.StdOutImpl\r\n# swagger 配置\r\nswagger:\r\n  title: 定时任务接口文档\r\n  license: Powered By ruoyi\r\n  licenseUrl: https://ruoyi.vip\r\n  authorization:\r\n    name: RuoYi OAuth\r\n    auth-regex: ^.*$\r\n    authorization-scope-list:\r\n      - scope: server\r\n        description: 客户端授权范围\r\n    token-url-list:\r\n      - http://localhost:8080/auth/oauth/token\r\n', '376f0f555c464d1150440af6f8186c38', '2021-08-06 07:56:45', '2021-08-06 07:56:46', NULL, '192.168.0.247', 'U', '');
    300. 

  300. INSERT INTO `his_config_info` VALUES (8, 129, '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://172.21.41.195:4000\r\n  accessKey: admin\r\n  secretKey: admin123\r\n  bucketName: test', '15a4f9cc1979fb27735ef03ab3737963', '2021-08-06 07:57:08', '2021-08-06 07:57:09', NULL, '192.168.0.247', 'U', '');
    301. 

  301. INSERT INTO `his_config_info` VALUES (2, 130, 'ruoyi-gateway-dev.yml', 'DEFAULT_GROUP', '', 'spring:\n  redis:\n    host: 192.168.0.167\n    port: 6379\n    password: \n  cloud:\n    gateway:\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# 不校验白名单\nignore:\n  whites:\n    - /auth/logout\n    - /auth/login\n    - /*/v2/api-docs\n    - /csrf\n', '843ee9a0c6078c089d985a23379f5f71', '2021-08-06 08:44:50', '2021-08-06 08:44:50', NULL, '192.168.0.247', 'U', '');
    302. 

  302. INSERT INTO `his_config_info` VALUES (2, 131, 'ruoyi-gateway-dev.yml', 'DEFAULT_GROUP', '', 'spring:\n  redis:\n    host: 192.168.0.167\n    port: 6379\n    password: \n  cloud:\n    gateway:\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# 安全配置\nsecurity:\n # 验证码\n  captcha:   \n    enabled: true\n    type: math\\n  \n# 防止XSS攻击\nxss:\n  enabled: true\n  xcludeUrls:      - /system/notice\n   \n# 不校验白名单\nignore:\n  whites:\n    - /auth/logout\n    - /auth/login\n    - /*/v2/api-docs\n    - /csrf\n', '4a6c6ea92d89cef74fee229b0341e47c', '2021-08-06 08:45:15', '2021-08-06 08:45:16', NULL, '192.168.0.247', 'U', '');
    303. 

  303. INSERT INTO `his_config_info` VALUES (2, 132, 'ruoyi-gateway-dev.yml', 'DEFAULT_GROUP', '', 'spring:\n  redis:\n    host: 192.168.0.167\n    port: 6379\n    password: \n  cloud:\n    gateway:\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# 安全配置\nsecurity:\n # 验证码\n  captcha:   \n    enabled: true\n    type: math\\n  \n# 防止XSS攻击\nxss:\n  enabled: true\n # xcludeUrls:      - /system/notice\n   \n# 不校验白名单\nignore:\n  whites:\n    - /auth/logout\n    - /auth/login\n    - /*/v2/api-docs\n    - /csrf\n', 'd09db95d87e26937df4dd5fcd6414b2b', '2021-08-06 08:47:56', '2021-08-06 08:47:57', NULL, '192.168.0.247', 'U', '');
    304. 

  304. INSERT INTO `his_config_info` VALUES (2, 133, 'ruoyi-gateway-dev.yml', 'DEFAULT_GROUP', '', 'spring:\n  redis:\n    host: 192.168.0.167\n    port: 6379\n    password: \n  cloud:\n    gateway:\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# 安全配置\nsecurity:\n # 验证码\n  captcha:   \n    enabled: true\n    type: math \n# 防止XSS攻击\nxss:\n  enabled: true\n # xcludeUrls:      - /system/notice\n   \n# 不校验白名单\nignore:\n  whites:\n    - /auth/logout\n    - /auth/login\n    - /*/v2/api-docs\n    - /csrf\n', 'e4344a8020f7cac5893a198e5624cc60', '2021-08-06 08:56:35', '2021-08-06 08:56:35', NULL, '192.168.0.247', 'U', '');
    305. 

  305. INSERT INTO `his_config_info` VALUES (2, 134, 'ruoyi-gateway-dev.yml', 'DEFAULT_GROUP', '', 'spring:\n  redis:\n    host: localhost\n    port: 6379\n    password: \n  cloud:\n    gateway:\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# 安全配置\nsecurity:\n  # 验证码\n  captcha:\n    enabled: true\n    type: math\n  # 防止XSS攻击\n  xss:\n    enabled: true\n    excludeUrls:\n      - /system/notice\n  # 不校验白名单\n  ignore:\n    whites:\n      - /auth/logout\n      - /auth/login\n      - /auth/register\n      - /*/v2/api-docs\n      - /csrf\n', '2f5a6b5a4ccf20b5801c5cf842456ec6', '2021-08-06 09:03:01', '2021-08-06 09:03:01', NULL, '192.168.0.247', 'U', '');
    306. 

  306. INSERT INTO `his_config_info` VALUES (5, 135, 'ruoyi-system-dev.yml', 'DEFAULT_GROUP', '', '# spring配置\r\nspring: \r\n  redis:\r\n    host: localhost\r\n    port: 6379\r\n    password: \r\n  datasource:\r\n    druid:\r\n      stat-view-servlet:\r\n        enabled: true\r\n        loginUsername: admin\r\n        loginPassword: 123456\r\n    dynamic:\r\n      druid:\r\n        initial-size: 5\r\n        min-idle: 5\r\n        maxActive: 20\r\n        maxWait: 60000\r\n        timeBetweenEvictionRunsMillis: 60000\r\n        minEvictableIdleTimeMillis: 300000\r\n        validationQuery: SELECT 1 FROM DUAL\r\n        testWhileIdle: true\r\n        testOnBorrow: false\r\n        testOnReturn: false\r\n        poolPreparedStatements: true\r\n        maxPoolPreparedStatementPerConnectionSize: 20\r\n        filters: stat,slf4j\r\n        connectionProperties: druid.stat.mergeSql\\=true;druid.stat.slowSqlMillis\\=5000\r\n      datasource:\r\n          # 主库数据源\r\n          master:\r\n            driver-class-name: com.mysql.cj.jdbc.Driver\r\n            url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\r\n            username: root\r\n            password: password\r\n          # 从库数据源\r\n          # slave:\r\n            # username: \r\n            # password: \r\n            # url: \r\n            # driver-class-name: \r\n      # seata: true    # 开启seata代理，开启后默认每个数据源都代理，如果某个不需要代理可单独关闭\r\n\r\n# seata配置\r\nseata:\r\n  # 默认关闭，如需启用spring.datasource.dynami.seata需要同时开启\r\n  enabled: false\r\n  # Seata 应用编号，默认为 ${spring.application.name}\r\n  application-id: ${spring.application.name}\r\n  # Seata 事务组编号，用于 TC 集群名\r\n  tx-service-group: ${spring.application.name}-group\r\n  # 关闭自动代理\r\n  enable-auto-data-source-proxy: false\r\n  # 服务配置项\r\n  service:\r\n    # 虚拟组和分组的映射\r\n    vgroup-mapping:\r\n      ruoyi-system-group: default\r\n  config:\r\n    type: nacos\r\n    nacos:\r\n      serverAddr: 127.0.0.1:8848\r\n      group: SEATA_GROUP\r\n      namespace:\r\n  registry:\r\n    type: nacos\r\n    nacos:\r\n      application: seata-server\r\n      server-addr: 127.0.0.1:8848\r\n      namespace:\r\n\r\n# mybatis配置\r\nmybatis:\r\n    # 搜索指定包别名\r\n    typeAliasesPackage: com.ruoyi.system\r\n    # 配置mapper的扫描，找到所有的mapper.xml映射文件\r\n    mapperLocations: classpath:mapper/**/*.xml\r\n\r\n# swagger配置\r\nswagger:\r\n  title: 系统模块接口文档\r\n  license: Powered By ruoyi\r\n  licenseUrl: https://ruoyi.vip', '26650028d48ca98b672573275cc9770b', '2021-08-06 09:07:38', '2021-08-06 09:07:39', NULL, '192.168.0.247', 'U', '');
    307. 

  307. 

  308. -- ----------------------------
    309. 

  309. -- Table structure for permissions
    310. 

  310. -- ----------------------------
    311. 

  311. DROP TABLE IF EXISTS `permissions`;
    312. 

  312. CREATE TABLE `permissions`  (
    313. 

  313.   `role` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    314. 

  314.   `resource` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    315. 

  315.   `action` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    316. 

  316.   UNIQUE INDEX `uk_role_permission`(`role`, `resource`, `action`) USING BTREE
    317. 

  317. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    318. 

  318. 

  319. -- ----------------------------
    320. 

  320. -- Records of permissions
    321. 

  321. -- ----------------------------
    322. 

  322. 

  323. -- ----------------------------
    324. 

  324. -- Table structure for roles
    325. 

  325. -- ----------------------------
    326. 

  326. DROP TABLE IF EXISTS `roles`;
    327. 

  327. CREATE TABLE `roles`  (
    328. 

  328.   `username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    329. 

  329.   `role` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    330. 

  330.   UNIQUE INDEX `idx_user_role`(`username`, `role`) USING BTREE
    331. 

  331. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    332. 

  332. 

  333. -- ----------------------------
    334. 

  334. -- Records of roles
    335. 

  335. -- ----------------------------
    336. 

  336. INSERT INTO `roles` VALUES ('nacos', 'ROLE_ADMIN');
    337. 

  337. 

  338. -- ----------------------------
    339. 

  339. -- Table structure for tenant_capacity
    340. 

  340. -- ----------------------------
    341. 

  341. DROP TABLE IF EXISTS `tenant_capacity`;
    342. 

  342. CREATE TABLE `tenant_capacity`  (
    343. 

  343.   `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
    344. 

  344.   `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'Tenant ID',
    345. 

  345.   `quota` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '配额，0表示使用默认值',
    346. 

  346.   `usage` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '使用量',
    347. 

  347.   `max_size` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '单个配置大小上限，单位为字节，0表示使用默认值',
    348. 

  348.   `max_aggr_count` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '聚合子配置最大个数',
    349. 

  349.   `max_aggr_size` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '单个聚合数据的子配置大小上限，单位为字节，0表示使用默认值',
    350. 

  350.   `max_history_count` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最大变更历史数量',
    351. 

  351.   `gmt_create` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
    352. 

  352.   `gmt_modified` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '修改时间',
    353. 

  353.   PRIMARY KEY (`id`) USING BTREE,
    354. 

  354.   UNIQUE INDEX `uk_tenant_id`(`tenant_id`) USING BTREE
    355. 

  355. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '租户容量信息表' ROW_FORMAT = Dynamic;
    356. 

  356. 

  357. -- ----------------------------
    358. 

  358. -- Records of tenant_capacity
    359. 

  359. -- ----------------------------
    360. 

  360. 

  361. -- ----------------------------
    362. 

  362. -- Table structure for tenant_info
    363. 

  363. -- ----------------------------
    364. 

  364. DROP TABLE IF EXISTS `tenant_info`;
    365. 

  365. CREATE TABLE `tenant_info`  (
    366. 

  366.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
    367. 

  367.   `kp` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'kp',
    368. 

  368.   `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT 'tenant_id',
    369. 

  369.   `tenant_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT 'tenant_name',
    370. 

  370.   `tenant_desc` varchar(256) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'tenant_desc',
    371. 

  371.   `create_source` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'create_source',
    372. 

  372.   `gmt_create` bigint(20) NOT NULL COMMENT '创建时间',
    373. 

  373.   `gmt_modified` bigint(20) NOT NULL COMMENT '修改时间',
    374. 

  374.   PRIMARY KEY (`id`) USING BTREE,
    375. 

  375.   UNIQUE INDEX `uk_tenant_info_kptenantid`(`kp`, `tenant_id`) USING BTREE,
    376. 

  376.   INDEX `idx_tenant_id`(`tenant_id`) USING BTREE
    377. 

  377. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'tenant_info' ROW_FORMAT = Dynamic;
    378. 

  378. 

  379. -- ----------------------------
    380. 

  380. -- Records of tenant_info
    381. 

  381. -- ----------------------------
    382. 

  382. 

  383. -- ----------------------------
    384. 

  384. -- Table structure for users
    385. 

  385. -- ----------------------------
    386. 

  386. DROP TABLE IF EXISTS `users`;
    387. 

  387. CREATE TABLE `users`  (
    388. 

  388.   `username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    389. 

  389.   `password` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    390. 

  390.   `enabled` tinyint(1) NOT NULL,
    391. 

  391.   PRIMARY KEY (`username`) USING BTREE
    392. 

  392. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    393. 

  393. 

  394. -- ----------------------------
    395. 

  395. -- Records of users
    396. 

  396. -- ----------------------------
    397. 

  397. INSERT INTO `users` VALUES ('nacos', '$2a$10$EuWPZHzz32dJN7jexM34MOeYirDdFAZm2kuWj7VEOJhhZkDrxfvUu', 1);
    398. 

  398. 

  399. SET FOREIGN_KEY_CHECKS = 1;
    400.