ホーム エクスプローラ ヘルプ
登録 サインイン
ruoyi
/
RuoYi-Cloud
同期ミラー https://gitee.com/y_project/RuoYi-Cloud.git
2
0
フォーク 0
ファイル 課題 0 Wiki
ブランチ: springboot3
ブランチ タグ
RuoYi-Cloud
/
sql
/
ry_config_20240914.sql

ry_config_20240914.sql 20 KB
パーマリンク 履歴 Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219 
  1. DROP DATABASE IF EXISTS `ry-config`;
    2. 

  2. 

  3. CREATE DATABASE  `ry-config` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
    4. 

  4. 

  5. SET NAMES utf8mb4;
    6. 

  6. SET FOREIGN_KEY_CHECKS = 0;
    7. 

  7. 

  8. USE `ry-config`;
    9. 

  9. 

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

  11. /*   表名称 = config_info   */
    12. 

  12. /******************************************/
    13. 

  13. CREATE TABLE `config_info` (
    14. 

  14.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
    15. 

  15.   `data_id` varchar(255) NOT NULL COMMENT 'data_id',
    16. 

  16.   `group_id` varchar(255) DEFAULT NULL,
    17. 

  17.   `content` longtext NOT NULL COMMENT 'content',
    18. 

  18.   `md5` varchar(32) DEFAULT NULL COMMENT 'md5',
    19. 

  19.   `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    20. 

  20.   `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
    21. 

  21.   `src_user` text COMMENT 'source user',
    22. 

  22.   `src_ip` varchar(50) DEFAULT NULL COMMENT 'source ip',
    23. 

  23.   `app_name` varchar(128) DEFAULT NULL,
    24. 

  24.   `tenant_id` varchar(128) DEFAULT '' COMMENT '租户字段',
    25. 

  25.   `c_desc` varchar(256) DEFAULT NULL,
    26. 

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

  27.   `effect` varchar(64) DEFAULT NULL,
    28. 

  28.   `type` varchar(64) DEFAULT NULL,
    29. 

  29.   `c_schema` text,
    30. 

  30.   `encrypted_data_key` text COMMENT '秘钥',
    31. 

  31.   PRIMARY KEY (`id`),
    32. 

  32.   UNIQUE KEY `uk_configinfo_datagrouptenant` (`data_id`,`group_id`,`tenant_id`)
    33. 

  33. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_info';
    34. 

  34. 

  35. 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, encrypted_data_key) values 
    36. 

  36. (1,'application-dev.yml','DEFAULT_GROUP','spring:\n  autoconfigure:\n    exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure\n\n# feign 配置\nfeign:\n  sentinel:\n    enabled: true\n  okhttp:\n    enabled: true\n  httpclient:\n    enabled: false\n  client:\n    config:\n      default:\n        connectTimeout: 10000\n        readTimeout: 10000\n  compression:\n    request:\n      enabled: true\n      min-request-size: 8192\n    response:\n      enabled: true\n\n# 暴露监控端点\nmanagement:\n  endpoints:\n    web:\n      exposure:\n        include: \'*\'\n','9928f41dfb10386ad38b3254af5692e0','2020-05-20 12:00:00','2024-08-29 12:14:45','nacos','0:0:0:0:0:0:0:1','','','通用配置','null','null','yaml','',''),
    37. 

  37. (2,'ruoyi-gateway-dev.yml','DEFAULT_GROUP','spring:\n  data:\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  # 不校验白名单\n  ignore:\n    whites:\n      - /auth/logout\n      - /auth/login\n      - /auth/register\n      - /*/v2/api-docs\n      - /*/v3/api-docs\n      - /csrf\n\n# springdoc配置\nspringdoc:\n  webjars:\n    # 访问前缀\n    prefix:\n','8c27a047f057fc05e5fc223adeb9c685','2020-05-14 14:17:55','2024-09-14 04:49:34','nacos','0:0:0:0:0:0:0:1','','','网关模块','null','null','yaml','',''),
    38. 

  38. (3,'ruoyi-auth-dev.yml','DEFAULT_GROUP','spring:\n  data:\n    redis:\n      host: localhost\n      port: 6379\n      password: \n','72565b1a725e013154ee57c8fd3045c4','2020-11-20 00:00:00','2024-09-14 04:49:42','nacos','0:0:0:0:0:0:0:1','','','认证中心','null','null','yaml','',''),
    39. 

  39. (4,'ruoyi-monitor-dev.yml','DEFAULT_GROUP','# spring\nspring:\n  security:\n    user:\n      name: ruoyi\n      password: 123456\n  boot:\n    admin:\n      ui:\n        title: 若依服务状态监控\n','6f122fd2bfb8d45f858e7d6529a9cd44','2020-11-20 00:00:00','2024-08-29 12:15:11','nacos','0:0:0:0:0:0:0:1','','','监控中心','null','null','yaml','',''),
    40. 

  40. (5,'ruoyi-system-dev.yml','DEFAULT_GROUP','# spring配置\nspring:\n  data:\n    redis:\n      host: localhost\n      port: 6379\n      password: \n  datasource:\n    druid:\n      stat-view-servlet:\n        enabled: true\n        loginUsername: ruoyi\n        loginPassword: 123456\n    dynamic:\n      druid:\n        initial-size: 5\n        min-idle: 5\n        maxActive: 20\n        maxWait: 60000\n        connectTimeout: 30000\n        socketTimeout: 60000\n        timeBetweenEvictionRunsMillis: 60000\n        minEvictableIdleTimeMillis: 300000\n        validationQuery: SELECT 1 FROM DUAL\n        testWhileIdle: true\n        testOnBorrow: false\n        testOnReturn: false\n        poolPreparedStatements: true\n        maxPoolPreparedStatementPerConnectionSize: 20\n        filters: stat,slf4j\n        connectionProperties: druid.stat.mergeSql\\=true;druid.stat.slowSqlMillis\\=5000\n      datasource:\n          # 主库数据源\n          master:\n            driver-class-name: com.mysql.cj.jdbc.Driver\n            url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n            username: root\n            password: password\n          # 从库数据源\n          # slave:\n            # username: \n            # password: \n            # url: \n            # driver-class-name: \n\n# mybatis配置\nmybatis:\n    # 搜索指定包别名\n    typeAliasesPackage: com.ruoyi.system\n    # 配置mapper的扫描，找到所有的mapper.xml映射文件\n    mapperLocations: classpath:mapper/**/*.xml\n\n# springdoc配置\nspringdoc:\n  gatewayUrl: http://localhost:8080/${spring.application.name}\n  api-docs:\n    # 是否开启接口文档\n    enabled: true\n  info:\n    # 标题\n    title: \'系统模块接口文档\'\n    # 描述\n    description: \'系统模块接口描述\'\n    # 作者信息\n    contact:\n      name: RuoYi\n      url: https://ruoyi.vip\n','a79ae256018abb7f3bbaba923baeb6af','2020-11-20 00:00:00','2024-09-14 04:49:54','nacos','0:0:0:0:0:0:0:1','','','系统模块','null','null','yaml','',''),
    41. 

  41. (6,'ruoyi-gen-dev.yml','DEFAULT_GROUP','# spring配置\nspring:\n  data:\n    redis:\n      host: localhost\n      port: 6379\n      password: \n  datasource:\n    driver-class-name: com.mysql.cj.jdbc.Driver\n    url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n    username: root\n    password: password\n\n# mybatis配置\nmybatis:\n    # 搜索指定包别名\n    typeAliasesPackage: com.ruoyi.gen.domain\n    # 配置mapper的扫描，找到所有的mapper.xml映射文件\n    mapperLocations: classpath:mapper/**/*.xml\n\n# springdoc配置\nspringdoc:\n  gatewayUrl: http://localhost:8080/${spring.application.name}\n  api-docs:\n    # 是否开启接口文档\n    enabled: true\n  info:\n    # 标题\n    title: \'代码生成接口文档\'\n    # 描述\n    description: \'代码生成接口描述\'\n    # 作者信息\n    contact:\n      name: RuoYi\n      url: https://ruoyi.vip\n\n# 代码生成\ngen:\n  # 作者\n  author: ruoyi\n  # 默认生成包路径 system 需改成自己的模块名称 如 system monitor tool\n  packageName: com.ruoyi.system\n  # 自动去除表前缀，默认是false\n  autoRemovePre: false\n  # 表前缀（生成类名不会包含表前缀，多个用逗号分隔）\n  tablePrefix: sys_\n','de4d5a0b67715af58e54fc4907698931','2020-11-20 00:00:00','2024-09-14 04:50:01','nacos','0:0:0:0:0:0:0:1','','','代码生成','null','null','yaml','',''),
    42. 

  42. (7,'ruoyi-job-dev.yml','DEFAULT_GROUP','# spring配置\nspring:\n  data:\n    redis:\n      host: localhost\n      port: 6379\n      password: \n  datasource:\n    driver-class-name: com.mysql.cj.jdbc.Driver\n    url: jdbc:mysql://localhost:3306/ry-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n    username: root\n    password: password\n\n# mybatis配置\nmybatis:\n    # 搜索指定包别名\n    typeAliasesPackage: com.ruoyi.job.domain\n    # 配置mapper的扫描，找到所有的mapper.xml映射文件\n    mapperLocations: classpath:mapper/**/*.xml\n\n# springdoc配置\nspringdoc:\n  gatewayUrl: http://localhost:8080/${spring.application.name}\n  api-docs:\n    # 是否开启接口文档\n    enabled: true\n  info:\n    # 标题\n    title: \'定时任务接口文档\'\n    # 描述\n    description: \'定时任务接口描述\'\n    # 作者信息\n    contact:\n      name: RuoYi\n      url: https://ruoyi.vip\n','225445e638148dbcbadda8d9774ce3fd','2020-11-20 00:00:00','2024-09-14 04:50:12','nacos','0:0:0:0:0:0:0:1','','','定时任务','null','null','yaml','',''),
    43. 

  43. (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,''),
    44. 

  44. (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,'');
    45. 

  45. 

  46. 

  47. /******************************************/
    48. 

  48. /*   表名称 = config_info_aggr   */
    49. 

  49. /******************************************/
    50. 

  50. CREATE TABLE `config_info_aggr` (
    51. 

  51.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
    52. 

  52.   `data_id` varchar(255) NOT NULL COMMENT 'data_id',
    53. 

  53.   `group_id` varchar(255) NOT NULL COMMENT 'group_id',
    54. 

  54.   `datum_id` varchar(255) NOT NULL COMMENT 'datum_id',
    55. 

  55.   `content` longtext NOT NULL COMMENT '内容',
    56. 

  56.   `gmt_modified` datetime NOT NULL COMMENT '修改时间',
    57. 

  57.   `app_name` varchar(128) DEFAULT NULL,
    58. 

  58.   `tenant_id` varchar(128) DEFAULT '' COMMENT '租户字段',
    59. 

  59.   PRIMARY KEY (`id`),
    60. 

  60.   UNIQUE KEY `uk_configinfoaggr_datagrouptenantdatum` (`data_id`,`group_id`,`tenant_id`,`datum_id`)
    61. 

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

  62. 

  63. 

  64. /******************************************/
    65. 

  65. /*   表名称 = config_info_beta   */
    66. 

  66. /******************************************/
    67. 

  67. CREATE TABLE `config_info_beta` (
    68. 

  68.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
    69. 

  69.   `data_id` varchar(255) NOT NULL COMMENT 'data_id',
    70. 

  70.   `group_id` varchar(128) NOT NULL COMMENT 'group_id',
    71. 

  71.   `app_name` varchar(128) DEFAULT NULL COMMENT 'app_name',
    72. 

  72.   `content` longtext NOT NULL COMMENT 'content',
    73. 

  73.   `beta_ips` varchar(1024) DEFAULT NULL COMMENT 'betaIps',
    74. 

  74.   `md5` varchar(32) DEFAULT NULL COMMENT 'md5',
    75. 

  75.   `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    76. 

  76.   `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
    77. 

  77.   `src_user` text COMMENT 'source user',
    78. 

  78.   `src_ip` varchar(50) DEFAULT NULL COMMENT 'source ip',
    79. 

  79.   `tenant_id` varchar(128) DEFAULT '' COMMENT '租户字段',
    80. 

  80.   `encrypted_data_key` text COMMENT '秘钥',
    81. 

  81.   PRIMARY KEY (`id`),
    82. 

  82.   UNIQUE KEY `uk_configinfobeta_datagrouptenant` (`data_id`,`group_id`,`tenant_id`)
    83. 

  83. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_info_beta';
    84. 

  84. 

  85. /******************************************/
    86. 

  86. /*   表名称 = config_info_tag   */
    87. 

  87. /******************************************/
    88. 

  88. CREATE TABLE `config_info_tag` (
    89. 

  89.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
    90. 

  90.   `data_id` varchar(255) NOT NULL COMMENT 'data_id',
    91. 

  91.   `group_id` varchar(128) NOT NULL COMMENT 'group_id',
    92. 

  92.   `tenant_id` varchar(128) DEFAULT '' COMMENT 'tenant_id',
    93. 

  93.   `tag_id` varchar(128) NOT NULL COMMENT 'tag_id',
    94. 

  94.   `app_name` varchar(128) DEFAULT NULL COMMENT 'app_name',
    95. 

  95.   `content` longtext NOT NULL COMMENT 'content',
    96. 

  96.   `md5` varchar(32) DEFAULT NULL COMMENT 'md5',
    97. 

  97.   `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    98. 

  98.   `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
    99. 

  99.   `src_user` text COMMENT 'source user',
    100. 

  100.   `src_ip` varchar(50) DEFAULT NULL COMMENT 'source ip',
    101. 

  101.   PRIMARY KEY (`id`),
    102. 

  102.   UNIQUE KEY `uk_configinfotag_datagrouptenanttag` (`data_id`,`group_id`,`tenant_id`,`tag_id`)
    103. 

  103. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_info_tag';
    104. 

  104. 

  105. /******************************************/
    106. 

  106. /*   表名称 = config_tags_relation   */
    107. 

  107. /******************************************/
    108. 

  108. CREATE TABLE `config_tags_relation` (
    109. 

  109.   `id` bigint(20) NOT NULL COMMENT 'id',
    110. 

  110.   `tag_name` varchar(128) NOT NULL COMMENT 'tag_name',
    111. 

  111.   `tag_type` varchar(64) DEFAULT NULL COMMENT 'tag_type',
    112. 

  112.   `data_id` varchar(255) NOT NULL COMMENT 'data_id',
    113. 

  113.   `group_id` varchar(128) NOT NULL COMMENT 'group_id',
    114. 

  114.   `tenant_id` varchar(128) DEFAULT '' COMMENT 'tenant_id',
    115. 

  115.   `nid` bigint(20) NOT NULL AUTO_INCREMENT,
    116. 

  116.   PRIMARY KEY (`nid`),
    117. 

  117.   UNIQUE KEY `uk_configtagrelation_configidtag` (`id`,`tag_name`,`tag_type`),
    118. 

  118.   KEY `idx_tenant_id` (`tenant_id`)
    119. 

  119. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_tag_relation';
    120. 

  120. 

  121. /******************************************/
    122. 

  122. /*   表名称 = group_capacity   */
    123. 

  123. /******************************************/
    124. 

  124. CREATE TABLE `group_capacity` (
    125. 

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

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

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

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

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

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

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

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

  133.   `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    134. 

  134.   `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
    135. 

  135.   PRIMARY KEY (`id`),
    136. 

  136.   UNIQUE KEY `uk_group_id` (`group_id`)
    137. 

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

  138. 

  139. /******************************************/
    140. 

  140. /*   表名称 = his_config_info   */
    141. 

  141. /******************************************/
    142. 

  142. CREATE TABLE `his_config_info` (
    143. 

  143.   `id` bigint(64) unsigned NOT NULL,
    144. 

  144.   `nid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    145. 

  145.   `data_id` varchar(255) NOT NULL,
    146. 

  146.   `group_id` varchar(128) NOT NULL,
    147. 

  147.   `app_name` varchar(128) DEFAULT NULL COMMENT 'app_name',
    148. 

  148.   `content` longtext NOT NULL,
    149. 

  149.   `md5` varchar(32) DEFAULT NULL,
    150. 

  150.   `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    151. 

  151.   `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    152. 

  152.   `src_user` text,
    153. 

  153.   `src_ip` varchar(50) DEFAULT NULL,
    154. 

  154.   `op_type` char(10) DEFAULT NULL,
    155. 

  155.   `tenant_id` varchar(128) DEFAULT '' COMMENT '租户字段',
    156. 

  156.   `encrypted_data_key` text COMMENT '秘钥',
    157. 

  157.   PRIMARY KEY (`nid`),
    158. 

  158.   KEY `idx_gmt_create` (`gmt_create`),
    159. 

  159.   KEY `idx_gmt_modified` (`gmt_modified`),
    160. 

  160.   KEY `idx_did` (`data_id`)
    161. 

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

  162. 

  163. 

  164. /******************************************/
    165. 

  165. /*   数据库全名 = nacos_config   */
    166. 

  166. /*   表名称 = tenant_capacity   */
    167. 

  167. /******************************************/
    168. 

  168. CREATE TABLE `tenant_capacity` (
    169. 

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

  170.   `tenant_id` varchar(128) NOT NULL DEFAULT '' COMMENT 'Tenant ID',
    171. 

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

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

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

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

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

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

  177.   `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    178. 

  178.   `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
    179. 

  179.   PRIMARY KEY (`id`),
    180. 

  180.   UNIQUE KEY `uk_tenant_id` (`tenant_id`)
    181. 

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

  182. 

  183. 

  184. CREATE TABLE `tenant_info` (
    185. 

  185.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
    186. 

  186.   `kp` varchar(128) NOT NULL COMMENT 'kp',
    187. 

  187.   `tenant_id` varchar(128) default '' COMMENT 'tenant_id',
    188. 

  188.   `tenant_name` varchar(128) default '' COMMENT 'tenant_name',
    189. 

  189.   `tenant_desc` varchar(256) DEFAULT NULL COMMENT 'tenant_desc',
    190. 

  190.   `create_source` varchar(32) DEFAULT NULL COMMENT 'create_source',
    191. 

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

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

  193.   PRIMARY KEY (`id`),
    194. 

  194.   UNIQUE KEY `uk_tenant_info_kptenantid` (`kp`,`tenant_id`),
    195. 

  195.   KEY `idx_tenant_id` (`tenant_id`)
    196. 

  196. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='tenant_info';
    197. 

  197. 

  198. CREATE TABLE `users` (
    199. 

  199. 	`username` varchar(50) NOT NULL PRIMARY KEY,
    200. 

  200. 	`password` varchar(500) NOT NULL,
    201. 

  201. 	`enabled` boolean NOT NULL
    202. 

  202. );
    203. 

  203. 

  204. CREATE TABLE `roles` (
    205. 

  205. 	`username` varchar(50) NOT NULL,
    206. 

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

  207. 	UNIQUE INDEX `idx_user_role` (`username` ASC, `role` ASC) USING BTREE
    208. 

  208. );
    209. 

  209. 

  210. CREATE TABLE `permissions` (
    211. 

  211.     `role` varchar(50) NOT NULL,
    212. 

  212.     `resource` varchar(255) NOT NULL,
    213. 

  213.     `action` varchar(8) NOT NULL,
    214. 

  214.     UNIQUE INDEX `uk_role_permission` (`role`,`resource`,`action`) USING BTREE
    215. 

  215. );
    216. 

  216. 

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

  218. 

  219. INSERT INTO roles (username, role) VALUES ('nacos', 'ROLE_ADMIN');
    220.