Domovská stránka Prehľadávať Pomoc
Registrovať Prihlásiť sa
liulc
/
ShangHaiLifeECIF
forknuté z liulc/dgtis-cloud
Pridať medzi pozorované 2
Hviezda 0
Fork 0
Súbory
Strom: a80b358ab1
Branche Tagy
ShangHaiLife...
/
sql
/
nacos2020年11月3日.sql

nacos2020年11月3日.sql 23 KB
História Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265 
  1. /*
    2. 

  2.  Navicat Premium Data Transfer
    3. 

  3. 

  4.  Source Server         : 10.32.2.231
    5. 

  5.  Source Server Type    : MySQL
    6. 

  6.  Source Server Version : 50731
    7. 

  7.  Source Host           : 10.32.2.231:3306
    8. 

  8.  Source Schema         : nacos
    9. 

  9. 

  10.  Target Server Type    : MySQL
    11. 

  11.  Target Server Version : 50731
    12. 

  12.  File Encoding         : 65001
    13. 

  13. 

  14.  Date: 03/11/2020 09:41:44
    15. 

  15. */
    16. 

  16. 

  17. SET NAMES utf8mb4;
    18. 

  18. SET FOREIGN_KEY_CHECKS = 0;
    19. 

  19. 

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

  21. -- Table structure for config_info
    22. 

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

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

  24. CREATE TABLE `config_info`  (
    25. 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  44. 

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

  46. -- Records of config_info
    47. 

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

  48. INSERT INTO `config_info` VALUES (1, 'application-dev.yml', 'DEFAULT_GROUP', 'spring:\n  main:\n    allow-bean-definition-overriding: true\n\n#请求处理的超时时间\nribbon:\n  ReadTimeout: 10000\n  ConnectTimeout: 10000\n\n# feign 配置\nfeign:\n  sentinel:\n    enabled: true\n  okhttp:\n    enabled: true\n  httpclient:\n    enabled: false\n  client:\n    config:\n      default:\n        connectTimeout: 10000\n        readTimeout: 10000\n  compression:\n    request:\n      enabled: true\n    response:\n      enabled: true\n\n# 暴露监控端点\nmanagement:\n  endpoints:\n    web:\n      exposure:\n        include: \'*\'\n', '57470c6d167154919418fa150863b7fb', '2020-11-03 01:40:00', '2020-11-03 01:40:00', NULL, '192.168.100.197', '', 'dgtis-cloud', NULL, NULL, NULL, 'yaml', NULL);
    49. 

  49. INSERT INTO `config_info` VALUES (1, 'dgtis-gateway-dev.yml', 'DEFAULT_GROUP', 'spring:\r\n  redis:\r\n    host: 10.32.2.232\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: dgtis-auth\r\n          uri: lb://dgtis-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: dgtis-gen\r\n          uri: lb://dgtis-gen\r\n          predicates:\r\n            - Path=/code/**\r\n          filters:\r\n            - StripPrefix=1\r\n        # 定时任务\r\n        - id: dgtis-job\r\n          uri: lb://dgtis-job\r\n          predicates:\r\n            - Path=/schedule/**\r\n          filters:\r\n            - StripPrefix=1\r\n        # 系统模块\r\n        - id: dgtis-system\r\n          uri: lb://dgtis-system\r\n          predicates:\r\n            - Path=/system/**\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', '3dc65f689fa45e886dfee7d9e6422d21', '2020-11-03 01:40:00', '2020-11-03 01:40:00', NULL, '192.168.100.197', '', 'dgtis-cloud', NULL, NULL, NULL, 'yaml', NULL);
    50. 

  50. INSERT INTO `config_info` VALUES (1, 'dgtis-auth-dev.yml', 'DEFAULT_GROUP', 'spring: \r\n  datasource:\r\n    driver-class-name: com.mysql.cj.jdbc.Driver\r\n    url: jdbc:mysql://10.32.2.231:3306/shanghailifeecif?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\r\n    username: root\r\n    password: 123456\r\n  redis:\r\n    host: 10.32.2.232\r\n    port: 6379\r\n    password: \r\n', 'db21fc72925482f67ff3beddd5b56d98', '2020-11-03 01:40:00', '2020-11-03 01:40:00', NULL, '192.168.100.197', '', 'dgtis-cloud', NULL, NULL, NULL, 'yaml', NULL);
    51. 

  51. INSERT INTO `config_info` VALUES (1, 'dgtis-monitor-dev.yml', 'DEFAULT_GROUP', '# Spring\r\nspring: \r\n  security:\r\n    user:\r\n      name: dgtis\r\n      password: 123456\r\n  boot:\r\n    admin:\r\n      ui:\r\n        title: 通誉服务状态监控\r\n', 'cdf43516f723c84c25e4f456bf478e6e', '2020-11-03 01:40:00', '2020-11-03 01:40:00', NULL, '192.168.100.197', '', 'dgtis-cloud', NULL, NULL, NULL, 'yaml', NULL);
    52. 

  52. INSERT INTO `config_info` VALUES (1, 'dgtis-system-dev.yml', 'DEFAULT_GROUP', '# Spring\r\nspring: \r\n  redis:\r\n    host: 10.32.2.232\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://10.32.2.231:3306/shanghailifeecif?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\r\n    username: root\r\n    password: 123456\r\n\r\n# Mybatis配置\r\nmybatis:\r\n    # 搜索指定包别名\r\n    typeAliasesPackage: com.dgtis.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 dgtis\r\n  licenseUrl: https://dgtis.vip\r\n  authorization:\r\n    name: dgtis OAuth\r\n    auth-regex: ^.*$\r\n    authorization-scope-list:\r\n      - scope: server\r\n        description: 客户端授权范围\r\n    token-url-list:\r\n      - http://localhost:8080/auth/oauth/token\r\n', 'b138e672ea2c4fa4c5c7579f6f879518', '2020-11-03 01:40:00', '2020-11-03 01:40:00', NULL, '192.168.100.197', '', 'dgtis-cloud', NULL, NULL, NULL, 'yaml', NULL);
    53. 

  53. INSERT INTO `config_info` VALUES (1, 'dgtis-gen-dev.yml', 'DEFAULT_GROUP', '# Spring\r\nspring: \r\n  redis:\r\n    host: 10.32.2.232\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://10.32.2.231:3306/shanghailifeecif?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\r\n    username: root\r\n    password: 123456\r\n\r\n# Mybatis配置\r\nmybatis:\r\n    # 搜索指定包别名\r\n    typeAliasesPackage: com.dgtis.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 dgtis\r\n  licenseUrl: https://dgtis.vip\r\n  authorization:\r\n    name: dgtis OAuth\r\n    auth-regex: ^.*$\r\n    authorization-scope-list:\r\n      - scope: server\r\n        description: 客户端授权范围\r\n    token-url-list:\r\n      - http://localhost:8080/auth/oauth/token\r\n\r\n# 代码生成\r\ngen: \r\n  # 作者\r\n  author: dgtis\r\n  # 默认生成包路径 system 需改成自己的模块名称 如 system monitor tool\r\n  packageName: com.dgtis.system\r\n  # 自动去除表前缀，默认是false\r\n  autoRemovePre: false\r\n  # 表前缀（生成类名不会包含表前缀，多个用逗号分隔）\r\n  tablePrefix: sys_\r\n', 'e5b3d7ce79588a3a924a76284495e60e', '2020-11-03 01:40:00', '2020-11-03 01:40:00', NULL, '192.168.100.197', '', 'dgtis-cloud', NULL, NULL, NULL, 'yaml', NULL);
    54. 

  54. INSERT INTO `config_info` VALUES (1, 'dgtis-job-dev.yml', 'DEFAULT_GROUP', '# Spring\r\nspring: \r\n  redis:\r\n    host: 10.32.2.232\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://10.32.2.231:3306/shanghailifeecif?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\r\n    username: root\r\n    password: 123456\r\n\r\n# Mybatis配置\r\nmybatis:\r\n    # 搜索指定包别名\r\n    typeAliasesPackage: com.dgtis.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 dgtis\r\n  licenseUrl: https://dgtis.vip\r\n  authorization:\r\n    name: dgtis OAuth\r\n    auth-regex: ^.*$\r\n    authorization-scope-list:\r\n      - scope: server\r\n        description: 客户端授权范围\r\n    token-url-list:\r\n      - http://localhost:8080/auth/oauth/token\r\n', 'c7091c638d851997fbb24cf18fdd92dc', '2020-11-03 01:40:00', '2020-11-03 01:40:00', NULL, '192.168.100.197', '', 'dgtis-cloud', NULL, NULL, NULL, 'yaml', NULL);
    55. 

  55. INSERT INTO `config_info` VALUES (1, 'sentinel-dgtis-gateway', 'DEFAULT_GROUP', '[\r\n    {\r\n        \"resource\": \"dgtis-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\": \"dgtis-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\": \"dgtis-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\": \"dgtis-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]', 'c752776a14b00d9d0173938ce1d47f77', '2020-11-03 01:40:00', '2020-11-03 01:40:00', NULL, '192.168.100.197', '', 'dgtis-cloud', NULL, NULL, NULL, 'json', NULL);
    56. 

  56. 

  57. -- ----------------------------
    58. 

  58. -- Table structure for config_info_aggr
    59. 

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

  60. DROP TABLE IF EXISTS `config_info_aggr`;
    61. 

  61. CREATE TABLE `config_info_aggr`  (
    62. 

  62.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
    63. 

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

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

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

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

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

  68.   `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
    69. 

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

  70.   PRIMARY KEY (`id`) USING BTREE,
    71. 

  71.   UNIQUE INDEX `uk_configinfoaggr_datagrouptenantdatum`(`data_id`, `group_id`, `tenant_id`, `datum_id`) USING BTREE
    72. 

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

  73. 

  74. -- ----------------------------
    75. 

  75. -- Table structure for config_info_beta
    76. 

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

  77. DROP TABLE IF EXISTS `config_info_beta`;
    78. 

  78. CREATE TABLE `config_info_beta`  (
    79. 

  79.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
    80. 

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

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

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

  83.   `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'content',
    84. 

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

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

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

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

  88.   `src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT 'source user',
    89. 

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

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

  91.   PRIMARY KEY (`id`) USING BTREE,
    92. 

  92.   UNIQUE INDEX `uk_configinfobeta_datagrouptenant`(`data_id`, `group_id`, `tenant_id`) USING BTREE
    93. 

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

  94. 

  95. -- ----------------------------
    96. 

  96. -- Table structure for config_info_tag
    97. 

  97. -- ----------------------------
    98. 

  98. DROP TABLE IF EXISTS `config_info_tag`;
    99. 

  99. CREATE TABLE `config_info_tag`  (
    100. 

  100.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
    101. 

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

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

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

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

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

  106.   `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'content',
    107. 

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

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

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

  110.   `src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT 'source user',
    111. 

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

  112.   PRIMARY KEY (`id`) USING BTREE,
    113. 

  113.   UNIQUE INDEX `uk_configinfotag_datagrouptenanttag`(`data_id`, `group_id`, `tenant_id`, `tag_id`) USING BTREE
    114. 

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

  115. 

  116. -- ----------------------------
    117. 

  117. -- Table structure for config_tags_relation
    118. 

  118. -- ----------------------------
    119. 

  119. DROP TABLE IF EXISTS `config_tags_relation`;
    120. 

  120. CREATE TABLE `config_tags_relation`  (
    121. 

  121.   `id` bigint(20) NOT NULL COMMENT 'id',
    122. 

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

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

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

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

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

  127.   `nid` bigint(20) NOT NULL AUTO_INCREMENT,
    128. 

  128.   PRIMARY KEY (`nid`) USING BTREE,
    129. 

  129.   UNIQUE INDEX `uk_configtagrelation_configidtag`(`id`, `tag_name`, `tag_type`) USING BTREE,
    130. 

  130.   INDEX `idx_tenant_id`(`tenant_id`) USING BTREE
    131. 

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

  132. 

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

  134. -- Table structure for group_capacity
    135. 

  135. -- ----------------------------
    136. 

  136. DROP TABLE IF EXISTS `group_capacity`;
    137. 

  137. CREATE TABLE `group_capacity`  (
    138. 

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

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

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

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

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

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

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

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

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

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

  148.   PRIMARY KEY (`id`) USING BTREE,
    149. 

  149.   UNIQUE INDEX `uk_group_id`(`group_id`) USING BTREE
    150. 

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

  151. 

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

  153. -- Table structure for his_config_info
    154. 

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

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

  156. CREATE TABLE `his_config_info`  (
    157. 

  157.   `id` bigint(64) UNSIGNED NOT NULL,
    158. 

  158.   `nid` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
    159. 

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

  160.   `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
    161. 

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

  162.   `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
    163. 

  163.   `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
    164. 

  164.   `gmt_create` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
    165. 

  165.   `gmt_modified` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
    166. 

  166.   `src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL,
    167. 

  167.   `src_ip` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
    168. 

  168.   `op_type` char(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
    169. 

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

  170.   PRIMARY KEY (`nid`) USING BTREE,
    171. 

  171.   INDEX `idx_gmt_create`(`gmt_create`) USING BTREE,
    172. 

  172.   INDEX `idx_gmt_modified`(`gmt_modified`) USING BTREE,
    173. 

  173.   INDEX `idx_did`(`data_id`) USING BTREE
    174. 

  174. ) ENGINE = InnoDB AUTO_INCREMENT = 42 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '多租户改造' ROW_FORMAT = Dynamic;
    175. 

  175. 

  176. -- ----------------------------
    177. 

  177. -- Records of his_config_info
    178. 

  178. -- ----------------------------
    179. 

  179. 

  180. -- ----------------------------
    181. 

  181. -- Table structure for permissions
    182. 

  182. -- ----------------------------
    183. 

  183. DROP TABLE IF EXISTS `permissions`;
    184. 

  184. CREATE TABLE `permissions`  (
    185. 

  185.   `role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    186. 

  186.   `resource` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    187. 

  187.   `action` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    188. 

  188.   UNIQUE INDEX `uk_role_permission`(`role`, `resource`, `action`) USING BTREE
    189. 

  189. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
    190. 

  190. 

  191. -- ----------------------------
    192. 

  192. -- Table structure for roles
    193. 

  193. -- ----------------------------
    194. 

  194. DROP TABLE IF EXISTS `roles`;
    195. 

  195. CREATE TABLE `roles`  (
    196. 

  196.   `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    197. 

  197.   `role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    198. 

  198.   UNIQUE INDEX `idx_user_role`(`username`, `role`) USING BTREE
    199. 

  199. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
    200. 

  200. 

  201. -- ----------------------------
    202. 

  202. -- Records of roles
    203. 

  203. -- ----------------------------
    204. 

  204. INSERT INTO `roles` VALUES ('nacos', 'ROLE_ADMIN');
    205. 

  205. 

  206. -- ----------------------------
    207. 

  207. -- Table structure for tenant_capacity
    208. 

  208. -- ----------------------------
    209. 

  209. DROP TABLE IF EXISTS `tenant_capacity`;
    210. 

  210. CREATE TABLE `tenant_capacity`  (
    211. 

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

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

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

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

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

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

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

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

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

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

  221.   PRIMARY KEY (`id`) USING BTREE,
    222. 

  222.   UNIQUE INDEX `uk_tenant_id`(`tenant_id`) USING BTREE
    223. 

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

  224. 

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

  226. -- Table structure for tenant_info
    227. 

  227. -- ----------------------------
    228. 

  228. DROP TABLE IF EXISTS `tenant_info`;
    229. 

  229. CREATE TABLE `tenant_info`  (
    230. 

  230.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
    231. 

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

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

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

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

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

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

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

  238.   PRIMARY KEY (`id`) USING BTREE,
    239. 

  239.   UNIQUE INDEX `uk_tenant_info_kptenantid`(`kp`, `tenant_id`) USING BTREE,
    240. 

  240.   INDEX `idx_tenant_id`(`tenant_id`) USING BTREE
    241. 

  241. ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'tenant_info' ROW_FORMAT = Dynamic;
    242. 

  242. 

  243. -- ----------------------------
    244. 

  244. -- Records of tenant_info
    245. 

  245. -- ----------------------------
    246. 

  246. INSERT INTO `tenant_info` VALUES (1, '1', 'dgtis-cloud', 'dgtis-cloud', '基础项目框架', 'nacos', 1604367573056, 1604367573056);
    247. 

  247. 

  248. -- ----------------------------
    249. 

  249. -- Table structure for users
    250. 

  250. -- ----------------------------
    251. 

  251. DROP TABLE IF EXISTS `users`;
    252. 

  252. CREATE TABLE `users`  (
    253. 

  253.   `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    254. 

  254.   `password` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    255. 

  255.   `enabled` tinyint(1) NOT NULL,
    256. 

  256.   PRIMARY KEY (`username`) USING BTREE
    257. 

  257. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
    258. 

  258. 

  259. -- ----------------------------
    260. 

  260. -- Records of users
    261. 

  261. -- ----------------------------
    262. 

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

  263. 

  264. SET FOREIGN_KEY_CHECKS = 1;
    265. 

  265.