首頁 探索 說明
註冊 登入
bihuisong
/
sooka-Cloud
關註 1
讚好 0
複刻 0
Files 問題管理 0 合併請求 0 Wiki
目錄樹: d21e1bf5df
分支列表 標籤列表
sooka-Cloud
/
sql
/
sooka-nacos.sql

sooka-nacos.sql 27 KB
文件歷史 原始文件

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296 
  1. /*
    2. 

  2.  Navicat Premium Data Transfer
    3. 

  3. 

  4.  Source Server         : mysql
    5. 

  5.  Source Server Type    : MySQL
    6. 

  6.  Source Server Version : 50726
    7. 

  7.  Source Host           : localhost:3306
    8. 

  8.  Source Schema         : sooka-nacos
    9. 

  9. 

  10.  Target Server Type    : MySQL
    11. 

  11.  Target Server Version : 50726
    12. 

  12.  File Encoding         : 65001
    13. 

  13. 

  14.  Date: 19/03/2024 08:41:14
    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 NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    31. 

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

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

  33.   `src_ip` varchar(50) 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.   `encrypted_data_key` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT '秘钥',
    42. 

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

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

  44. ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'config_info' ROW_FORMAT = DYNAMIC;
    45. 

  45. 

  46. -- ----------------------------
    47. 

  47. -- Records of config_info
    48. 

  48. -- ----------------------------
    49. 

  49. INSERT INTO `config_info` VALUES (1, 'application-dev.yml', 'DEFAULT_GROUP', 'spring:\n  autoconfigure:\n    exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure\n  mvc:\n    pathmatch:\n      matching-strategy: ant_path_matcher\n\n# feign 配置\nfeign:\n  sentinel:\n    enabled: true\n  okhttp:\n    enabled: true\n  httpclient:\n    enabled: false\n  client:\n    config:\n      default:\n        connectTimeout: 10000\n        readTimeout: 10000\n  compression:\n    request:\n      enabled: true\n      min-request-size: 8192\n    response:\n      enabled: true\n\n# 暴露监控端点\nmanagement:\n  endpoints:\n    web:\n      exposure:\n        include: \'*\'\n', '58dde4e3760499d3bac2d77a3a1e9018', '2020-05-20 12:00:00', '2023-12-04 08:08:23', 'nacos', '0:0:0:0:0:0:0:1', '', '', '通用配置', 'null', 'null', 'yaml', '', '');
    50. 

  50. INSERT INTO `config_info` VALUES (2, 'sooka-gateway-dev.yml', 'DEFAULT_GROUP', 'spring:\r\n  redis:\r\n    host: 127.0.0.1\r\n    port: 16379\r\n    password: sooka123456\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: sooka-auth\r\n          uri: lb://sooka-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: sooka-gen\r\n          uri: lb://sooka-gen\r\n          predicates:\r\n            - Path=/code/**\r\n          filters:\r\n            - StripPrefix=1\r\n        # 定时任务\r\n        - id: sooka-job\r\n          uri: lb://sooka-job\r\n          predicates:\r\n            - Path=/schedule/**\r\n          filters:\r\n            - StripPrefix=1\r\n        # 系统模块\r\n        - id: sooka-system\r\n          uri: lb://sooka-system\r\n          predicates:\r\n            - Path=/system/**\r\n          filters:\r\n            - StripPrefix=1\r\n        # 文件服务\r\n        - id: sooka-file\r\n          uri: lb://sooka-file\r\n          predicates:\r\n            - Path=/file/**\r\n          filters:\r\n            - StripPrefix=1\r\n\r\n# 安全配置\r\nsecurity:\r\n  # 验证码\r\n  captcha:\r\n    enabled: true\r\n    type: math\r\n  # 防止XSS攻击\r\n  xss:\r\n    enabled: true\r\n    excludeUrls:\r\n      - /system/notice\r\n  # 不校验白名单\r\n  ignore:\r\n    whites:\r\n      - /auth/logout\r\n      - /auth/login\r\n      - /auth/register\r\n      - /*/v2/api-docs\r\n      - /csrf', '57cec5abd0e0a6b77d853750344a9dc0', '2020-05-14 14:17:55', '2022-09-29 02:48:32', 'nacos', '0:0:0:0:0:0:0:1', '', '', '网关模块', 'null', 'null', 'yaml', '', '');
    51. 

  51. INSERT INTO `config_info` VALUES (3, 'sooka-auth-dev.yml', 'DEFAULT_GROUP', 'spring:\r\n  redis:\r\n    host: 127.0.0.1\r\n    port: 16379\r\n    password: sooka123456', '8bd9dada9a94822feeab40de55efced6', '2020-11-20 00:00:00', '2022-09-29 02:48:42', 'nacos', '0:0:0:0:0:0:0:1', '', '', '认证中心', 'null', 'null', 'yaml', '', '');
    52. 

  52. INSERT INTO `config_info` VALUES (4, 'sooka-monitor-dev.yml', 'DEFAULT_GROUP', '# spring\nspring:\n  security:\n    user:\n      name: sooka\n      password: 123456\n  boot:\n    admin:\n      ui:\n        title: 服务状态监控\n', '6f122fd2bfb8d45f858e7d6529a9cd44', '2020-11-20 00:00:00', '2022-09-29 02:48:54', 'nacos', '0:0:0:0:0:0:0:1', '', '', '监控中心', 'null', 'null', 'yaml', '', '');
    53. 

  53. INSERT INTO `config_info` VALUES (5, 'sooka-system-dev.yml', 'DEFAULT_GROUP', '# spring配置\r\nspring:\r\n  redis:\r\n    host: 127.0.0.1\r\n    port: 16379\r\n    password: sooka123456\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        connectTimeout: 30000\r\n        socketTimeout: 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/sooka-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\r\n            username: root\r\n            password: root\r\n          # 从库数据源\r\n          # slave:\r\n            # username: \r\n            # password: \r\n            # url: \r\n            # driver-class-name: \r\n\r\n# mybatis配置\r\nmybatis:\r\n    # 搜索指定包别名\r\n    typeAliasesPackage: com.sooka.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 sooka\r\n  licenseUrl: https://sooka.vip', '951384cd346ef1a7220ff602828d0086', '2020-11-20 00:00:00', '2024-03-18 02:56:39', 'nacos', '192.168.4.58', '', '', '系统模块', 'null', 'null', 'yaml', '', '');
    54. 

  54. INSERT INTO `config_info` VALUES (6, 'sooka-gen-dev.yml', 'DEFAULT_GROUP', '# spring配置\r\nspring:\r\n  redis:\r\n    host: 127.0.0.1\r\n    port: 16379\r\n    password: sooka123456\r\n  datasource:\r\n    driver-class-name: com.mysql.cj.jdbc.Driver\r\n    url: jdbc:mysql://localhost:3306/sooka-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\r\n    username: root\r\n    password: root\r\n\r\n# mybatis配置\r\nmybatis:\r\n    # 搜索指定包别名\r\n    typeAliasesPackage: com.sooka.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 sooka\r\n  licenseUrl: https://sooka.vip\r\n\r\n# 代码生成\r\ngen:\r\n  # 作者\r\n  author: sooka\r\n  # 默认生成包路径 system 需改成自己的模块名称 如 system monitor tool\r\n  packageName: com.sooka.system\r\n  # 自动去除表前缀，默认是false\r\n  autoRemovePre: false\r\n  # 表前缀（生成类名不会包含表前缀，多个用逗号分隔）\r\n  tablePrefix: sys_', 'eb592420b3fceae1402881887b8a6a0d', '2020-11-20 00:00:00', '2022-09-29 02:49:42', 'nacos', '0:0:0:0:0:0:0:1', '', '', '代码生成', 'null', 'null', 'yaml', '', '');
    55. 

  55. INSERT INTO `config_info` VALUES (7, 'sooka-job-dev.yml', 'DEFAULT_GROUP', '# spring配置\r\nspring:\r\n  redis:\r\n    host: 127.0.0.1\r\n    port: 16379\r\n    password: sooka123456\r\n  datasource:\r\n    driver-class-name: com.mysql.cj.jdbc.Driver\r\n    url: jdbc:mysql://localhost:3306/sooka-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\r\n    username: root\r\n    password: root\r\n\r\n# mybatis配置\r\nmybatis:\r\n    # 搜索指定包别名\r\n    typeAliasesPackage: com.sooka.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 sooka\r\n  licenseUrl: https://sooka.vip', 'edcf0e3fe13fea07b4ec08b1088f30b3', '2020-11-20 00:00:00', '2022-09-29 02:50:50', 'nacos', '0:0:0:0:0:0:0:1', '', '', '定时任务', 'null', 'null', 'yaml', '', '');
    56. 

  56. INSERT INTO `config_info` VALUES (8, 'sooka-file-dev.yml', 'DEFAULT_GROUP', '# 本地文件上传    \r\nfile:\r\n    domain: http://127.0.0.1:9300\r\n    path: D:/sooka/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, '');
    57. 

  57. INSERT INTO `config_info` VALUES (9, 'sentinel-sooka-gateway', 'DEFAULT_GROUP', '[\r\n    {\r\n        \"resource\": \"sooka-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\": \"sooka-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\": \"sooka-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\": \"sooka-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, '');
    58. 

  58. 

  59. -- ----------------------------
    60. 

  60. -- Table structure for config_info_aggr
    61. 

  61. -- ----------------------------
    62. 

  62. DROP TABLE IF EXISTS `config_info_aggr`;
    63. 

  63. CREATE TABLE `config_info_aggr`  (
    64. 

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

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

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

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

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

  69.   `gmt_modified` datetime NOT NULL COMMENT '修改时间',
    70. 

  70.   `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
    71. 

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

  72.   PRIMARY KEY (`id`) USING BTREE,
    73. 

  73.   UNIQUE INDEX `uk_configinfoaggr_datagrouptenantdatum`(`data_id`, `group_id`, `tenant_id`, `datum_id`) USING BTREE
    74. 

  74. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '增加租户字段' ROW_FORMAT = DYNAMIC;
    75. 

  75. 

  76. -- ----------------------------
    77. 

  77. -- Records of config_info_aggr
    78. 

  78. -- ----------------------------
    79. 

  79. 

  80. -- ----------------------------
    81. 

  81. -- Table structure for config_info_beta
    82. 

  82. -- ----------------------------
    83. 

  83. DROP TABLE IF EXISTS `config_info_beta`;
    84. 

  84. CREATE TABLE `config_info_beta`  (
    85. 

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

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

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

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

  89.   `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'content',
    90. 

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

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

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

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

  94.   `src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT 'source user',
    95. 

  95.   `src_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'source ip',
    96. 

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

  97.   `encrypted_data_key` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT '秘钥',
    98. 

  98.   PRIMARY KEY (`id`) USING BTREE,
    99. 

  99.   UNIQUE INDEX `uk_configinfobeta_datagrouptenant`(`data_id`, `group_id`, `tenant_id`) USING BTREE
    100. 

  100. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'config_info_beta' ROW_FORMAT = DYNAMIC;
    101. 

  101. 

  102. -- ----------------------------
    103. 

  103. -- Records of config_info_beta
    104. 

  104. -- ----------------------------
    105. 

  105. 

  106. -- ----------------------------
    107. 

  107. -- Table structure for config_info_tag
    108. 

  108. -- ----------------------------
    109. 

  109. DROP TABLE IF EXISTS `config_info_tag`;
    110. 

  110. CREATE TABLE `config_info_tag`  (
    111. 

  111.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
    112. 

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

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

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

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

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

  117.   `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'content',
    118. 

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

  119.   `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    120. 

  120.   `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
    121. 

  121.   `src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT 'source user',
    122. 

  122.   `src_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'source ip',
    123. 

  123.   PRIMARY KEY (`id`) USING BTREE,
    124. 

  124.   UNIQUE INDEX `uk_configinfotag_datagrouptenanttag`(`data_id`, `group_id`, `tenant_id`, `tag_id`) USING BTREE
    125. 

  125. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'config_info_tag' ROW_FORMAT = DYNAMIC;
    126. 

  126. 

  127. -- ----------------------------
    128. 

  128. -- Records of config_info_tag
    129. 

  129. -- ----------------------------
    130. 

  130. 

  131. -- ----------------------------
    132. 

  132. -- Table structure for config_tags_relation
    133. 

  133. -- ----------------------------
    134. 

  134. DROP TABLE IF EXISTS `config_tags_relation`;
    135. 

  135. CREATE TABLE `config_tags_relation`  (
    136. 

  136.   `id` bigint(20) NOT NULL COMMENT 'id',
    137. 

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

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

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

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

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

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

  143.   PRIMARY KEY (`nid`) USING BTREE,
    144. 

  144.   UNIQUE INDEX `uk_configtagrelation_configidtag`(`id`, `tag_name`, `tag_type`) USING BTREE,
    145. 

  145.   INDEX `idx_tenant_id`(`tenant_id`) USING BTREE
    146. 

  146. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'config_tag_relation' ROW_FORMAT = DYNAMIC;
    147. 

  147. 

  148. -- ----------------------------
    149. 

  149. -- Records of config_tags_relation
    150. 

  150. -- ----------------------------
    151. 

  151. 

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

  153. -- Table structure for group_capacity
    154. 

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

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

  156. CREATE TABLE `group_capacity`  (
    157. 

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

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

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

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

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

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

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

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

  165.   `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    166. 

  166.   `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
    167. 

  167.   PRIMARY KEY (`id`) USING BTREE,
    168. 

  168.   UNIQUE INDEX `uk_group_id`(`group_id`) USING BTREE
    169. 

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

  170. 

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

  172. -- Records of group_capacity
    173. 

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

  174. 

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

  176. -- Table structure for his_config_info
    177. 

  177. -- ----------------------------
    178. 

  178. DROP TABLE IF EXISTS `his_config_info`;
    179. 

  179. CREATE TABLE `his_config_info`  (
    180. 

  180.   `id` bigint(64) UNSIGNED NOT NULL,
    181. 

  181.   `nid` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
    182. 

  182.   `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
    183. 

  183.   `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
    184. 

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

  185.   `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
    186. 

  186.   `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
    187. 

  187.   `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    188. 

  188.   `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    189. 

  189.   `src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL,
    190. 

  190.   `src_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
    191. 

  191.   `op_type` char(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
    192. 

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

  193.   `encrypted_data_key` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT '秘钥',
    194. 

  194.   PRIMARY KEY (`nid`) USING BTREE,
    195. 

  195.   INDEX `idx_gmt_create`(`gmt_create`) USING BTREE,
    196. 

  196.   INDEX `idx_gmt_modified`(`gmt_modified`) USING BTREE,
    197. 

  197.   INDEX `idx_did`(`data_id`) USING BTREE
    198. 

  198. ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '多租户改造' ROW_FORMAT = DYNAMIC;
    199. 

  199. 

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

  201. -- Records of his_config_info
    202. 

  202. -- ----------------------------
    203. 

  203. INSERT INTO `his_config_info` VALUES (5, 1, 'sooka-system-dev.yml', 'DEFAULT_GROUP', '', '# spring配置\nspring:\n  redis:\n    host: localhost\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        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.sooka.system\n    # 配置mapper的扫描，找到所有的mapper.xml映射文件\n    mapperLocations: classpath:mapper/**/*.xml\n\n# swagger配置\nswagger:\n  title: 系统模块接口文档\n  license: Powered By sooka\n  licenseUrl: https://sooka.vip', '5d496707714b1187f90d41596cd1cc44', '2024-03-18 10:56:39', '2024-03-18 02:56:39', 'nacos', '192.168.4.58', 'U', '', NULL);
    204. 

  204. 

  205. -- ----------------------------
    206. 

  206. -- Table structure for permissions
    207. 

  207. -- ----------------------------
    208. 

  208. DROP TABLE IF EXISTS `permissions`;
    209. 

  209. CREATE TABLE `permissions`  (
    210. 

  210.   `role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    211. 

  211.   `resource` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    212. 

  212.   `action` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    213. 

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

  214. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
    215. 

  215. 

  216. -- ----------------------------
    217. 

  217. -- Records of permissions
    218. 

  218. -- ----------------------------
    219. 

  219. 

  220. -- ----------------------------
    221. 

  221. -- Table structure for roles
    222. 

  222. -- ----------------------------
    223. 

  223. DROP TABLE IF EXISTS `roles`;
    224. 

  224. CREATE TABLE `roles`  (
    225. 

  225.   `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    226. 

  226.   `role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    227. 

  227.   UNIQUE INDEX `idx_user_role`(`username`, `role`) USING BTREE
    228. 

  228. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
    229. 

  229. 

  230. -- ----------------------------
    231. 

  231. -- Records of roles
    232. 

  232. -- ----------------------------
    233. 

  233. INSERT INTO `roles` VALUES ('nacos', 'ROLE_ADMIN');
    234. 

  234. 

  235. -- ----------------------------
    236. 

  236. -- Table structure for tenant_capacity
    237. 

  237. -- ----------------------------
    238. 

  238. DROP TABLE IF EXISTS `tenant_capacity`;
    239. 

  239. CREATE TABLE `tenant_capacity`  (
    240. 

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

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

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

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

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

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

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

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

  248.   `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    249. 

  249.   `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
    250. 

  250.   PRIMARY KEY (`id`) USING BTREE,
    251. 

  251.   UNIQUE INDEX `uk_tenant_id`(`tenant_id`) USING BTREE
    252. 

  252. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '租户容量信息表' ROW_FORMAT = DYNAMIC;
    253. 

  253. 

  254. -- ----------------------------
    255. 

  255. -- Records of tenant_capacity
    256. 

  256. -- ----------------------------
    257. 

  257. 

  258. -- ----------------------------
    259. 

  259. -- Table structure for tenant_info
    260. 

  260. -- ----------------------------
    261. 

  261. DROP TABLE IF EXISTS `tenant_info`;
    262. 

  262. CREATE TABLE `tenant_info`  (
    263. 

  263.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
    264. 

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

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

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

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

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

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

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

  271.   PRIMARY KEY (`id`) USING BTREE,
    272. 

  272.   UNIQUE INDEX `uk_tenant_info_kptenantid`(`kp`, `tenant_id`) USING BTREE,
    273. 

  273.   INDEX `idx_tenant_id`(`tenant_id`) USING BTREE
    274. 

  274. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'tenant_info' ROW_FORMAT = DYNAMIC;
    275. 

  275. 

  276. -- ----------------------------
    277. 

  277. -- Records of tenant_info
    278. 

  278. -- ----------------------------
    279. 

  279. 

  280. -- ----------------------------
    281. 

  281. -- Table structure for users
    282. 

  282. -- ----------------------------
    283. 

  283. DROP TABLE IF EXISTS `users`;
    284. 

  284. CREATE TABLE `users`  (
    285. 

  285.   `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    286. 

  286.   `password` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    287. 

  287.   `enabled` tinyint(1) NOT NULL,
    288. 

  288.   PRIMARY KEY (`username`) USING BTREE
    289. 

  289. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
    290. 

  290. 

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

  292. -- Records of users
    293. 

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

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

  295. 

  296. SET FOREIGN_KEY_CHECKS = 1;
    297.