Ana Sayfa Keşfet Yardım
Üye Ol Giriş Yap
uskycloud
/
usky-cloud
2
0
Çatalla 0
Dosyalar Sorunlar 0 Değişiklik İstekleri 0 Wiki
Ağaç: a220bc7fb2
Dallar Biçim İmleri
usky-cloud
/
sql
/
ry_config_20220114.sql

ry_config_20220114.sql 20 KB
Geçmiş Ham

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214 
  1. DROP DATABASE IF EXISTS `CREATE DATABASE  `usky-config` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
    2. 

  2. 

  3. SET NAMES utf8mb4;
    4. 

  4. SET FOREIGN_KEY_CHECKS = 0;
    5. 

  5. 

  6. USE `usky-config`;
    7. 

  7. 

  8. /******************************************/
    9. 

  9. /*   表名称 = config_info   */
    10. 

  10. /******************************************/
    11. 

  11. CREATE TABLE `config_info` (
    12. 

  12.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
    13. 

  13.   `data_id` varchar(255) NOT NULL COMMENT 'data_id',
    14. 

  14.   `group_id` varchar(255) DEFAULT NULL,
    15. 

  15.   `content` longtext NOT NULL COMMENT 'content',
    16. 

  16.   `md5` varchar(32) DEFAULT NULL COMMENT 'md5',
    17. 

  17.   `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    18. 

  18.   `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
    19. 

  19.   `src_user` text COMMENT 'source user',
    20. 

  20.   `src_ip` varchar(50) DEFAULT NULL COMMENT 'source ip',
    21. 

  21.   `app_name` varchar(128) DEFAULT NULL,
    22. 

  22.   `tenant_id` varchar(128) DEFAULT '' COMMENT '租户字段',
    23. 

  23.   `c_desc` varchar(256) DEFAULT NULL,
    24. 

  24.   `c_use` varchar(64) DEFAULT NULL,
    25. 

  25.   `effect` varchar(64) DEFAULT NULL,
    26. 

  26.   `type` varchar(64) DEFAULT NULL,
    27. 

  27.   `c_schema` text,
    28. 

  28.   PRIMARY KEY (`id`),
    29. 

  29.   UNIQUE KEY `uk_configinfo_datagrouptenant` (`data_id`,`group_id`,`tenant_id`)
    30. 

  30. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_info';
    31. 

  31. 

  32. insert into config_info(id, data_id, group_id, content, md5, gmt_create, gmt_modified, src_user, src_ip, app_name, tenant_id, c_desc, c_use, effect, type, c_schema) values 
    33. 

  33. (1,'application-dev.yml','DEFAULT_GROUP','spring:\n  main:\n    allow-circular-references: true\n    allow-bean-definition-overriding: true\n  autoconfigure:\n    exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure\n  mvc:\n    pathmatch:\n      matching-strategy: ant_path_matcher\n  cloud:\n    sentinel:\n      filter:\n        # sentinel 在 springboot 2.6.x 不兼容问题的处理\n        enabled: false\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','e6a8dafc6fcec97f777836bea3ed5028','2020-05-20 12:00:00','2022-01-14 02:20:19','nacos','0:0:0:0:0:0:0:1','','','通用配置','null','null','yaml','null'),
    34. 

  34. (2,'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','2020-05-14 14:17:55','2021-07-30 09:07:14',NULL,'0:0:0:0:0:0:0:1','','','网关模块','null','null','yaml','null'),
    35. 

  35. (3,'ruoyi-auth-dev.yml','DEFAULT_GROUP','spring: \r\n  redis:\r\n    host: localhost\r\n    port: 6379\r\n    password: \r\n','b7354e1eb62c2d846d44a796d9ec6930','2020-11-20 00:00:00','2021-02-28 21:06:58',NULL,'0:0:0:0:0:0:0:1','','','认证中心','null','null','yaml','null'),
    36. 

  36. (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','d8997d0707a2fd5d9fc4e8409da38129','2020-11-20 00:00:00','2020-12-21 16:28:07',NULL,'0:0:0:0:0:0:0:1','','','监控中心','null','null','yaml','null'),
    37. 

  37. (5,'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','ac8913dee679e65bb7d482df5f267d4e','2020-11-20 00:00:00','2021-01-27 10:42:25',NULL,'0:0:0:0:0:0:0:1','','','系统模块','null','null','yaml','null'),
    38. 

  38. (6,'ruoyi-gen-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    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# 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\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','8c79f64a4cca9b821a03dc8b27a2d8eb','2020-11-20 00:00:00','2021-01-26 10:36:45',NULL,'0:0:0:0:0:0:0:1','','','代码生成','null','null','yaml','null'),
    39. 

  39. (7,'ruoyi-job-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    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# 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','d6dfade9a2c93c463ae857cd503cb172','2020-11-20 00:00:00','2021-01-26 10:36:04',NULL,'0:0:0:0:0:0:0:1','','','定时任务','null','null','yaml','null'),
    40. 

  40. (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'),
    41. 

  41. (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');
    42. 

  42. 

  43. 

  44. /******************************************/
    45. 

  45. /*   表名称 = config_info_aggr   */
    46. 

  46. /******************************************/
    47. 

  47. CREATE TABLE `config_info_aggr` (
    48. 

  48.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
    49. 

  49.   `data_id` varchar(255) NOT NULL COMMENT 'data_id',
    50. 

  50.   `group_id` varchar(255) NOT NULL COMMENT 'group_id',
    51. 

  51.   `datum_id` varchar(255) NOT NULL COMMENT 'datum_id',
    52. 

  52.   `content` longtext NOT NULL COMMENT '内容',
    53. 

  53.   `gmt_modified` datetime NOT NULL COMMENT '修改时间',
    54. 

  54.   `app_name` varchar(128) DEFAULT NULL,
    55. 

  55.   `tenant_id` varchar(128) DEFAULT '' COMMENT '租户字段',
    56. 

  56.   PRIMARY KEY (`id`),
    57. 

  57.   UNIQUE KEY `uk_configinfoaggr_datagrouptenantdatum` (`data_id`,`group_id`,`tenant_id`,`datum_id`)
    58. 

  58. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='增加租户字段';
    59. 

  59. 

  60. 

  61. /******************************************/
    62. 

  62. /*   表名称 = config_info_beta   */
    63. 

  63. /******************************************/
    64. 

  64. CREATE TABLE `config_info_beta` (
    65. 

  65.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
    66. 

  66.   `data_id` varchar(255) NOT NULL COMMENT 'data_id',
    67. 

  67.   `group_id` varchar(128) NOT NULL COMMENT 'group_id',
    68. 

  68.   `app_name` varchar(128) DEFAULT NULL COMMENT 'app_name',
    69. 

  69.   `content` longtext NOT NULL COMMENT 'content',
    70. 

  70.   `beta_ips` varchar(1024) DEFAULT NULL COMMENT 'betaIps',
    71. 

  71.   `md5` varchar(32) DEFAULT NULL COMMENT 'md5',
    72. 

  72.   `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    73. 

  73.   `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
    74. 

  74.   `src_user` text COMMENT 'source user',
    75. 

  75.   `src_ip` varchar(50) DEFAULT NULL COMMENT 'source ip',
    76. 

  76.   `tenant_id` varchar(128) DEFAULT '' COMMENT '租户字段',
    77. 

  77.   PRIMARY KEY (`id`),
    78. 

  78.   UNIQUE KEY `uk_configinfobeta_datagrouptenant` (`data_id`,`group_id`,`tenant_id`)
    79. 

  79. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_info_beta';
    80. 

  80. 

  81. /******************************************/
    82. 

  82. /*   表名称 = config_info_tag   */
    83. 

  83. /******************************************/
    84. 

  84. CREATE TABLE `config_info_tag` (
    85. 

  85.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
    86. 

  86.   `data_id` varchar(255) NOT NULL COMMENT 'data_id',
    87. 

  87.   `group_id` varchar(128) NOT NULL COMMENT 'group_id',
    88. 

  88.   `tenant_id` varchar(128) DEFAULT '' COMMENT 'tenant_id',
    89. 

  89.   `tag_id` varchar(128) NOT NULL COMMENT 'tag_id',
    90. 

  90.   `app_name` varchar(128) DEFAULT NULL COMMENT 'app_name',
    91. 

  91.   `content` longtext NOT NULL COMMENT 'content',
    92. 

  92.   `md5` varchar(32) DEFAULT NULL COMMENT 'md5',
    93. 

  93.   `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    94. 

  94.   `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
    95. 

  95.   `src_user` text COMMENT 'source user',
    96. 

  96.   `src_ip` varchar(50) DEFAULT NULL COMMENT 'source ip',
    97. 

  97.   PRIMARY KEY (`id`),
    98. 

  98.   UNIQUE KEY `uk_configinfotag_datagrouptenanttag` (`data_id`,`group_id`,`tenant_id`,`tag_id`)
    99. 

  99. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_info_tag';
    100. 

  100. 

  101. /******************************************/
    102. 

  102. /*   表名称 = config_tags_relation   */
    103. 

  103. /******************************************/
    104. 

  104. CREATE TABLE `config_tags_relation` (
    105. 

  105.   `id` bigint(20) NOT NULL COMMENT 'id',
    106. 

  106.   `tag_name` varchar(128) NOT NULL COMMENT 'tag_name',
    107. 

  107.   `tag_type` varchar(64) DEFAULT NULL COMMENT 'tag_type',
    108. 

  108.   `data_id` varchar(255) NOT NULL COMMENT 'data_id',
    109. 

  109.   `group_id` varchar(128) NOT NULL COMMENT 'group_id',
    110. 

  110.   `tenant_id` varchar(128) DEFAULT '' COMMENT 'tenant_id',
    111. 

  111.   `nid` bigint(20) NOT NULL AUTO_INCREMENT,
    112. 

  112.   PRIMARY KEY (`nid`),
    113. 

  113.   UNIQUE KEY `uk_configtagrelation_configidtag` (`id`,`tag_name`,`tag_type`),
    114. 

  114.   KEY `idx_tenant_id` (`tenant_id`)
    115. 

  115. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_tag_relation';
    116. 

  116. 

  117. /******************************************/
    118. 

  118. /*   表名称 = group_capacity   */
    119. 

  119. /******************************************/
    120. 

  120. CREATE TABLE `group_capacity` (
    121. 

  121.   `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
    122. 

  122.   `group_id` varchar(128) NOT NULL DEFAULT '' COMMENT 'Group ID，空字符表示整个集群',
    123. 

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

  124.   `usage` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '使用量',
    125. 

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

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

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

  128.   `max_history_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最大变更历史数量',
    129. 

  129.   `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    130. 

  130.   `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
    131. 

  131.   PRIMARY KEY (`id`),
    132. 

  132.   UNIQUE KEY `uk_group_id` (`group_id`)
    133. 

  133. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='集群、各Group容量信息表';
    134. 

  134. 

  135. /******************************************/
    136. 

  136. /*   表名称 = his_config_info   */
    137. 

  137. /******************************************/
    138. 

  138. CREATE TABLE `his_config_info` (
    139. 

  139.   `id` bigint(64) unsigned NOT NULL,
    140. 

  140.   `nid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    141. 

  141.   `data_id` varchar(255) NOT NULL,
    142. 

  142.   `group_id` varchar(128) NOT NULL,
    143. 

  143.   `app_name` varchar(128) DEFAULT NULL COMMENT 'app_name',
    144. 

  144.   `content` longtext NOT NULL,
    145. 

  145.   `md5` varchar(32) DEFAULT NULL,
    146. 

  146.   `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    147. 

  147.   `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    148. 

  148.   `src_user` text,
    149. 

  149.   `src_ip` varchar(50) DEFAULT NULL,
    150. 

  150.   `op_type` char(10) DEFAULT NULL,
    151. 

  151.   `tenant_id` varchar(128) DEFAULT '' COMMENT '租户字段',
    152. 

  152.   PRIMARY KEY (`nid`),
    153. 

  153.   KEY `idx_gmt_create` (`gmt_create`),
    154. 

  154.   KEY `idx_gmt_modified` (`gmt_modified`),
    155. 

  155.   KEY `idx_did` (`data_id`)
    156. 

  156. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='多租户改造';
    157. 

  157. 

  158. 

  159. /******************************************/
    160. 

  160. /*   数据库全名 = nacos_config   */
    161. 

  161. /*   表名称 = tenant_capacity   */
    162. 

  162. /******************************************/
    163. 

  163. CREATE TABLE `tenant_capacity` (
    164. 

  164.   `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
    165. 

  165.   `tenant_id` varchar(128) NOT NULL DEFAULT '' COMMENT 'Tenant ID',
    166. 

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

  167.   `usage` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '使用量',
    168. 

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

  169.   `max_aggr_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '聚合子配置最大个数',
    170. 

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

  171.   `max_history_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最大变更历史数量',
    172. 

  172.   `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    173. 

  173.   `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
    174. 

  174.   PRIMARY KEY (`id`),
    175. 

  175.   UNIQUE KEY `uk_tenant_id` (`tenant_id`)
    176. 

  176. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='租户容量信息表';
    177. 

  177. 

  178. 

  179. CREATE TABLE `tenant_info` (
    180. 

  180.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
    181. 

  181.   `kp` varchar(128) NOT NULL COMMENT 'kp',
    182. 

  182.   `tenant_id` varchar(128) default '' COMMENT 'tenant_id',
    183. 

  183.   `tenant_name` varchar(128) default '' COMMENT 'tenant_name',
    184. 

  184.   `tenant_desc` varchar(256) DEFAULT NULL COMMENT 'tenant_desc',
    185. 

  185.   `create_source` varchar(32) DEFAULT NULL COMMENT 'create_source',
    186. 

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

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

  188.   PRIMARY KEY (`id`),
    189. 

  189.   UNIQUE KEY `uk_tenant_info_kptenantid` (`kp`,`tenant_id`),
    190. 

  190.   KEY `idx_tenant_id` (`tenant_id`)
    191. 

  191. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='tenant_info';
    192. 

  192. 

  193. CREATE TABLE `users` (
    194. 

  194. 	`username` varchar(50) NOT NULL PRIMARY KEY,
    195. 

  195. 	`password` varchar(500) NOT NULL,
    196. 

  196. 	`enabled` boolean NOT NULL
    197. 

  197. );
    198. 

  198. 

  199. CREATE TABLE `roles` (
    200. 

  200. 	`username` varchar(50) NOT NULL,
    201. 

  201. 	`role` varchar(50) NOT NULL,
    202. 

  202. 	UNIQUE INDEX `idx_user_role` (`username` ASC, `role` ASC) USING BTREE
    203. 

  203. );
    204. 

  204. 

  205. CREATE TABLE `permissions` (
    206. 

  206.     `role` varchar(50) NOT NULL,
    207. 

  207.     `resource` varchar(255) NOT NULL,
    208. 

  208.     `action` varchar(8) NOT NULL,
    209. 

  209.     UNIQUE INDEX `uk_role_permission` (`role`,`resource`,`action`) USING BTREE
    210. 

  210. );
    211. 

  211. 

  212. INSERT INTO users (username, password, enabled) VALUES ('nacos', '$2a$10$EuWPZHzz32dJN7jexM34MOeYirDdFAZm2kuWj7VEOJhhZkDrxfvUu', TRUE);
    213. 

  213. 

  214. INSERT INTO roles (username, role) VALUES ('nacos', 'ROLE_ADMIN');
    215.