Home Explore Help
Sign In
sckj
/
online_exam_system
2
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Branch: master
Branches Tags
online_exam_...
/
sql
/
ry_config_20210128.sql

ry_config_20210128.sql 20 KB
Permalink History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216 
  1. DROP DATABASE IF EXISTS `train-config`;
    2. 

  2. 

  3. CREATE DATABASE  `train-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 `train-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(20) 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.   PRIMARY KEY (`id`),
    31. 

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

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

  33. 

  34. 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 
    35. 

  35. (1,'application-dev.yml','DEFAULT_GROUP','spring:\n  main:\n    allow-bean-definition-overriding: true\n  autoconfigure:\n    exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure\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','c07e6f7321493f6d5390d0a08bffb75a','2019-11-29 16:31:20','2020-12-21 15:29:24',NULL,'0:0:0:0:0:0:0:1','','','通用配置','null','null','yaml','null'),
    36. 

  36. (2,'ruoyi-gateway-dev.yml','DEFAULT_GROUP','spring:\r\n  redis:\r\n    host: localhost\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','ef4a58daf989827334b3aac1c9d68392','2020-05-14 14:17:55','2020-11-18 17:53:23',NULL,'0:0:0:0:0:0:0:1','','','网关模块','null','null','yaml','null'),
    37. 

  37. (3,'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://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  redis:\r\n    host: localhost\r\n    port: 6379\r\n    password: \r\n','868c15010a7a15c027d4c90a48aabb3e','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'),
    38. 

  38. (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'),
    39. 

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

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

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

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

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

  44. 

  45. 

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

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

  48. /******************************************/
    49. 

  49. CREATE TABLE `config_info_aggr` (
    50. 

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

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

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

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

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

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

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

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

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

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

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

  61. 

  62. 

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

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

  65. /******************************************/
    66. 

  66. CREATE TABLE `config_info_beta` (
    67. 

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

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

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

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

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

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

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

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

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

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

  77.   `src_ip` varchar(20) DEFAULT NULL COMMENT 'source ip',
    78. 

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

  79.   PRIMARY KEY (`id`),
    80. 

  80.   UNIQUE KEY `uk_configinfobeta_datagrouptenant` (`data_id`,`group_id`,`tenant_id`)
    81. 

  81. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_info_beta';
    82. 

  82. 

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

  84. /*   表名称 = config_info_tag   */
    85. 

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

  86. CREATE TABLE `config_info_tag` (
    87. 

  87.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
    88. 

  88.   `data_id` varchar(255) NOT NULL COMMENT 'data_id',
    89. 

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

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

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

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

  93.   `content` longtext NOT NULL COMMENT 'content',
    94. 

  94.   `md5` varchar(32) DEFAULT NULL COMMENT 'md5',
    95. 

  95.   `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    96. 

  96.   `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
    97. 

  97.   `src_user` text COMMENT 'source user',
    98. 

  98.   `src_ip` varchar(20) DEFAULT NULL COMMENT 'source ip',
    99. 

  99.   PRIMARY KEY (`id`),
    100. 

  100.   UNIQUE KEY `uk_configinfotag_datagrouptenanttag` (`data_id`,`group_id`,`tenant_id`,`tag_id`)
    101. 

  101. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_info_tag';
    102. 

  102. 

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

  104. /*   表名称 = config_tags_relation   */
    105. 

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

  106. CREATE TABLE `config_tags_relation` (
    107. 

  107.   `id` bigint(20) NOT NULL COMMENT 'id',
    108. 

  108.   `tag_name` varchar(128) NOT NULL COMMENT 'tag_name',
    109. 

  109.   `tag_type` varchar(64) DEFAULT NULL COMMENT 'tag_type',
    110. 

  110.   `data_id` varchar(255) NOT NULL COMMENT 'data_id',
    111. 

  111.   `group_id` varchar(128) NOT NULL COMMENT 'group_id',
    112. 

  112.   `tenant_id` varchar(128) DEFAULT '' COMMENT 'tenant_id',
    113. 

  113.   `nid` bigint(20) NOT NULL AUTO_INCREMENT,
    114. 

  114.   PRIMARY KEY (`nid`),
    115. 

  115.   UNIQUE KEY `uk_configtagrelation_configidtag` (`id`,`tag_name`,`tag_type`),
    116. 

  116.   KEY `idx_tenant_id` (`tenant_id`)
    117. 

  117. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_tag_relation';
    118. 

  118. 

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

  120. /*   表名称 = group_capacity   */
    121. 

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

  122. CREATE TABLE `group_capacity` (
    123. 

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

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

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

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

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

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

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

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

  131.   `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    132. 

  132.   `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
    133. 

  133.   PRIMARY KEY (`id`),
    134. 

  134.   UNIQUE KEY `uk_group_id` (`group_id`)
    135. 

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

  136. 

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

  138. /*   表名称 = his_config_info   */
    139. 

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

  140. CREATE TABLE `his_config_info` (
    141. 

  141.   `id` bigint(64) unsigned NOT NULL,
    142. 

  142.   `nid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    143. 

  143.   `data_id` varchar(255) NOT NULL,
    144. 

  144.   `group_id` varchar(128) NOT NULL,
    145. 

  145.   `app_name` varchar(128) DEFAULT NULL COMMENT 'app_name',
    146. 

  146.   `content` longtext NOT NULL,
    147. 

  147.   `md5` varchar(32) DEFAULT NULL,
    148. 

  148.   `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    149. 

  149.   `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    150. 

  150.   `src_user` text,
    151. 

  151.   `src_ip` varchar(20) DEFAULT NULL,
    152. 

  152.   `op_type` char(10) DEFAULT NULL,
    153. 

  153.   `tenant_id` varchar(128) DEFAULT '' COMMENT '租户字段',
    154. 

  154.   PRIMARY KEY (`nid`),
    155. 

  155.   KEY `idx_gmt_create` (`gmt_create`),
    156. 

  156.   KEY `idx_gmt_modified` (`gmt_modified`),
    157. 

  157.   KEY `idx_did` (`data_id`)
    158. 

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

  159. 

  160. 

  161. /******************************************/
    162. 

  162. /*   数据库全名 = nacos_config   */
    163. 

  163. /*   表名称 = tenant_capacity   */
    164. 

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

  165. CREATE TABLE `tenant_capacity` (
    166. 

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

  167.   `tenant_id` varchar(128) NOT NULL DEFAULT '' COMMENT 'Tenant ID',
    168. 

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

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

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

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

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

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

  174.   `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    175. 

  175.   `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
    176. 

  176.   PRIMARY KEY (`id`),
    177. 

  177.   UNIQUE KEY `uk_tenant_id` (`tenant_id`)
    178. 

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

  179. 

  180. 

  181. CREATE TABLE `tenant_info` (
    182. 

  182.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
    183. 

  183.   `kp` varchar(128) NOT NULL COMMENT 'kp',
    184. 

  184.   `tenant_id` varchar(128) default '' COMMENT 'tenant_id',
    185. 

  185.   `tenant_name` varchar(128) default '' COMMENT 'tenant_name',
    186. 

  186.   `tenant_desc` varchar(256) DEFAULT NULL COMMENT 'tenant_desc',
    187. 

  187.   `create_source` varchar(32) DEFAULT NULL COMMENT 'create_source',
    188. 

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

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

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

  191.   UNIQUE KEY `uk_tenant_info_kptenantid` (`kp`,`tenant_id`),
    192. 

  192.   KEY `idx_tenant_id` (`tenant_id`)
    193. 

  193. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='tenant_info';
    194. 

  194. 

  195. CREATE TABLE `users` (
    196. 

  196. 	`username` varchar(50) NOT NULL PRIMARY KEY,
    197. 

  197. 	`password` varchar(500) NOT NULL,
    198. 

  198. 	`enabled` boolean NOT NULL
    199. 

  199. );
    200. 

  200. 

  201. CREATE TABLE `roles` (
    202. 

  202. 	`username` varchar(50) NOT NULL,
    203. 

  203. 	`role` varchar(50) NOT NULL,
    204. 

  204. 	UNIQUE INDEX `idx_user_role` (`username` ASC, `role` ASC) USING BTREE
    205. 

  205. );
    206. 

  206. 

  207. CREATE TABLE `permissions` (
    208. 

  208.     `role` varchar(50) NOT NULL,
    209. 

  209.     `resource` varchar(512) NOT NULL,
    210. 

  210.     `action` varchar(8) NOT NULL,
    211. 

  211.     UNIQUE INDEX `uk_role_permission` (`role`,`resource`,`action`) USING BTREE
    212. 

  212. );
    213. 

  213. 

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

  215. 

  216. INSERT INTO roles (username, role) VALUES ('nacos', 'ROLE_ADMIN');
    217.