صفحهٔ اصلی گشت‌و‌گذار راهنما
ثبت نام ورود
dz_farming
/
forest-mall-cloud
4
0
انشعاب 0
پرونده‌ها مشکلات 0 درخواست واکشی 0 ویکی
درخت: 7310a7b6d9
شاخه‌ها تگ‌ها
forest-mall-clo...
/
sql
/
版本对应数据库
/
2.0
/
2021-2-5
/
forest-config-nacos.sql

forest-config-nacos.sql 27 KB
تاريخچه خام

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264 
  1. /*
    2. 

  2.  Navicat Premium Data Transfer
    3. 

  3. 

  4.  Source Server         : 172.16.90.64_3306
    5. 

  5.  Source Server Type    : MySQL
    6. 

  6.  Source Server Version : 50730
    7. 

  7.  Source Host           : 172.16.90.64:3306
    8. 

  8.  Source Schema         : forest-config-nacos
    9. 

  9. 

  10.  Target Server Type    : MySQL
    11. 

  11.  Target Server Version : 50730
    12. 

  12.  File Encoding         : 65001
    13. 

  13. 

  14.  Date: 05/02/2021 18:03:05
    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 = 66 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 (54, 'forest-common.yml', 'DEFAULT_GROUP', 'secure:\r\n  ignored:\r\n    urls:\r\n      - /swagger-ui.html\r\n      - /swagger-resources/**\r\n      - /swagger/**\r\n      - /**/v2/api-docs\r\n      - /**/*.js\r\n      - /**/*.css\r\n      - /**/*.png\r\n      - /**/*.ico\r\n      - /webjars/springfox-swagger-ui/**\r\n      - /actuator/**\r\n      - /druid/**\r\n      - /home/**\r\n      - /product/**\r\n      - /wechat/h5/authorize\r\n      - /wechat/h5/userInfo\r\n      - /admin/login\r\n      - /sso/login\r\n      - /sso/getLoginCode\r\n      - /sso/register\r\n      - /sso/getAuthCode\r\n      - /admin/register\r\n      - /admin/info\r\n      - /admin/logout\r\n      - /minio/upload\r\n      - /sso/loginPhone\r\n      - /product/import\r\n      - /big/**\r\n      - /bigData/**\r\n      - /first/upload\r\n      - /doc.html\r\n      - /sso/**\r\n      - /wechat/**\r\n      - /brand/**\r\n      - /app/payResult\r\n\r\nqiniu:\r\n  accessKey: FLWUJxiZY1_N-5d6J_jsdgbqyjVDUg86ghZHsaQW\r\n  bucket: forestcloud\r\n  path: http://fqn.hongweisoft.com/\r\n  processName: \'null\'\r\n  secretKey: So55w4fQ2dTQ6uMlWuUywmKG8ZTqVhWfr_3Ii7GI  ', '69720b920d4f36307512d14e8db1f619', '2020-11-10 18:00:16', '2020-12-10 09:49:57', NULL, '172.16.90.8', '公共配置文件', '', '公共配置文件', 'null', 'null', 'yaml', 'null');
    49. 

  49. INSERT INTO `config_info` VALUES (61, 'forest-portal.yml', 'DEFAULT_GROUP', 'spring:\r\n  datasource:\r\n    url: jdbc:mysql://172.16.90.64:3306/forest-cloud-mall?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai\r\n    username: root\r\n    password: 123456\r\n    druid:\r\n      initial-size: 5\r\n      min-idle: 10\r\n      max-active: 20\r\n      web-stat-filter:\r\n        exclusions: \"*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*\"\r\n      stat-view-servlet:\r\n        login-username: druid\r\n        login-password: druid\r\n  boot:\r\n    admin:\r\n      client:\r\n        url: http://localhost:9091\r\n  data:\r\n    mongodb:\r\n      host: 172.16.90.64\r\n      port: 27017\r\n      database: mall-port\r\n  redis:\r\n    host: 172.16.90.64\r\n    database: 0\r\n    port: 6379\r\n    password: \r\n    timeout: 300ms\r\n\r\n  rabbitmq:\r\n    host: 172.16.90.64\r\n    port: 5672\r\n    virtual-host: /forest\r\n    username: forest\r\n    password: 123456\r\n    publisher-confirms: true\r\nmyredis:\r\n  address: redis://${spring.redis.host}:${spring.redis.port}\r\n  password: ${spring.redis.password}\r\n  \r\nlogging:\r\n  level:\r\n    org.springframework.data.mongodb.core: debug\r\n    com.hwrj.cloud.portal.mapper: debug\r\n    com.hwrj.cloud.portal.dao: debug\r\nmybatis:\r\n  mapper-locations:\r\n    - classpath:dao/*.xml\r\n    - classpath*:com/**/mapper/*.xml\r\nrabbitmq:\r\n  queue:\r\n    name:\r\n      cancelOrder: cancelOrderQueue\r\nredis:\r\n  database: forest\r\n  key:\r\n    authCode: \'ums:authCode\'\r\n    telLoginCode: \'ums:authCode\'\r\n    orderId: \'oms:orderId\'\r\n    member: \'ums:member\'\r\n    token: \'ums:token\'\r\n  expire:\r\n    authCode: 90\r\n    authLoginCode: 240\r\n    common: 86400\r\njwt:\r\n  tokenHeader: Authorization\r\n  secret: forest-admin-secret\r\n  expiration: 604800\r\n  tokenHead: Bearer\r\n  \r\nforest:\r\n  wx: \r\n    password: forest123456\r\n\r\nsms:\r\n  accessKeyId: LTAICB9TH0OAN3yJ\r\n  accessKeySecret: lCuyL3MUQRLfoVw39W0NqWdVGoLV60\r\n  signName: hywa\r\n  \r\nwx:\r\n  mp:\r\n    aesKey: 123\r\n    appId: wxbe90cc7c5233dd84\r\n    secret: ec4a18ce1a7bcf17cf592c3d57cec68a\r\n    token: 123\r\n    url: http://wx.hw.hongweisoft.com/fqb/forest-portal/wechat/h5/userInfo\r\n    before: http://172.16.90.25:8080\r\n  pay:\r\n    appId: wxbe90cc7c5233dd84\r\n    mchId: 1583849731\r\n    mchKey: B5F5A628C91D869F4CA357D2BCD63006\r\n    wxpayAppcallbackurl: http://wx.hw.hongweisoft.com/fqb/forest-portal/app/payResult', 'f4a61cb7f176c1b3b9fc3b087279621b', '2020-11-11 09:24:39', '2021-02-04 14:48:53', NULL, '0:0:0:0:0:0:0:1', 'forest-portal', '', 'null', 'null', 'null', 'yaml', 'null');
    50. 

  50. INSERT INTO `config_info` VALUES (62, 'forest-gateway.yml', 'DEFAULT_GROUP', 'spring:\r\n  redis:\r\n    host: 172.16.90.64\r\n    database: 0\r\n    port: 6379\r\n    password: \r\n    timeout: 300ms\r\n  boot:\r\n    admin:\r\n      client:\r\n        url: http://localhost:9091\r\nmanagement:\r\n  endpoints:\r\n    web:\r\n      exposure:\r\n        include: \'*\'\r\n  endpoint:\r\n    health:\r\n      show-details: always\r\n      \r\njwt:\r\n  tokenHeader: Authorization\r\n  secret: forest-admin-secret\r\n  expiration: 604800\r\n  tokenHead: Bearer\r\n  \r\nredis:\r\n  database: forest\r\n  key:\r\n    admin: \'ums:admin\'\r\n    token: \'ums:token\'\r\n    resourceList: \'ums:resourceList\'\r\n  expire:\r\n    common: 86400', 'fdbce19012bdb76ab1ccead808fa1d02', '2020-11-11 09:26:33', '2021-02-04 14:49:39', NULL, '0:0:0:0:0:0:0:1', 'forest-gateway', '', 'null', 'null', 'null', 'yaml', 'null');
    51. 

  51. INSERT INTO `config_info` VALUES (65, 'forest-admin.yml', 'DEFAULT_GROUP', 'spring:\r\n  datasource:\r\n    url: jdbc:mysql://172.16.90.64:3306/forest-cloud-mall?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai\r\n    username: root\r\n    password: 123456\r\n    druid:\r\n      initial-size: 5\r\n      min-idle: 10\r\n      max-active: 20\r\n      web-stat-filter:\r\n        exclusions: \"*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*\"\r\n      stat-view-servlet:\r\n        login-username: druid\r\n        login-password: druid\r\n  redis:\r\n    host: 172.16.90.64\r\n    database: 0\r\n    port: 6379\r\n    password: \r\n    timeout: 300ms\r\n  zipkin:\r\n    base-url: http://localhost:9411\r\n    locator:\r\n      discovery:\r\n        enabled: true\r\n  sleuth:\r\n    sampler:\r\n      probability: 1.0\r\n  boot:\r\n    admin:\r\n      client:\r\n        url: http://localhost:8095\r\n\r\nmanagement:\r\n  endpoints:\r\n    web:\r\n      exposure:\r\n        include: \'*\'\r\n  endpoint:\r\n    health:\r\n      show-details: always\r\nmybatis:\r\n  mapper-locations:\r\n    - classpath:dao/*.xml\r\n    - classpath*:com/**/mapper/*.xml\r\nlogging:\r\n  level:\r\n    root: info \r\n    com.hwrj.cloud: debug\r\n\r\n  sleuth:\r\n    sampler:\r\n      probability: 1.0\r\n  boot:\r\n    admin:\r\n      client:\r\n        url: http://localhost:9091\r\n\r\njwt:\r\n  tokenHeader: Authorization\r\n  secret: forest-admin-secret\r\n  expiration: 604800\r\n  tokenHead: Bearer\r\n\r\nredis:\r\n  database: forest\r\n  key:\r\n    admin: \'ums:admin\'\r\n    token: \'ums:token\'\r\n    resourceList: \'ums:resourceList\'\r\n  expire:\r\n    common: 86400', '71dd24ba2b58b105986c6ec0240e0cc2', '2020-11-11 09:30:47', '2021-02-04 14:48:18', NULL, '0:0:0:0:0:0:0:1', 'forest-admin', '', 'null', 'null', 'null', 'yaml', 'null');
    52. 

  52. 

  53. -- ----------------------------
    54. 

  54. -- Table structure for config_info_aggr
    55. 

  55. -- ----------------------------
    56. 

  56. DROP TABLE IF EXISTS `config_info_aggr`;
    57. 

  57. CREATE TABLE `config_info_aggr`  (
    58. 

  58.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
    59. 

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

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

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

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

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

  64.   `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
    65. 

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

  66.   PRIMARY KEY (`id`) USING BTREE,
    67. 

  67.   UNIQUE INDEX `uk_configinfoaggr_datagrouptenantdatum`(`data_id`, `group_id`, `tenant_id`, `datum_id`) USING BTREE
    68. 

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

  69. 

  70. -- ----------------------------
    71. 

  71. -- Table structure for config_info_beta
    72. 

  72. -- ----------------------------
    73. 

  73. DROP TABLE IF EXISTS `config_info_beta`;
    74. 

  74. CREATE TABLE `config_info_beta`  (
    75. 

  75.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
    76. 

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

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

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

  79.   `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'content',
    80. 

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

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

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

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

  84.   `src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT 'source user',
    85. 

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

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

  87.   PRIMARY KEY (`id`) USING BTREE,
    88. 

  88.   UNIQUE INDEX `uk_configinfobeta_datagrouptenant`(`data_id`, `group_id`, `tenant_id`) USING BTREE
    89. 

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

  90. 

  91. -- ----------------------------
    92. 

  92. -- Table structure for config_info_tag
    93. 

  93. -- ----------------------------
    94. 

  94. DROP TABLE IF EXISTS `config_info_tag`;
    95. 

  95. CREATE TABLE `config_info_tag`  (
    96. 

  96.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
    97. 

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

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

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

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

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

  102.   `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'content',
    103. 

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

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

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

  106.   `src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT 'source user',
    107. 

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

  108.   PRIMARY KEY (`id`) USING BTREE,
    109. 

  109.   UNIQUE INDEX `uk_configinfotag_datagrouptenanttag`(`data_id`, `group_id`, `tenant_id`, `tag_id`) USING BTREE
    110. 

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

  111. 

  112. -- ----------------------------
    113. 

  113. -- Table structure for config_tags_relation
    114. 

  114. -- ----------------------------
    115. 

  115. DROP TABLE IF EXISTS `config_tags_relation`;
    116. 

  116. CREATE TABLE `config_tags_relation`  (
    117. 

  117.   `id` bigint(20) NOT NULL COMMENT 'id',
    118. 

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

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

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

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

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

  123.   `nid` bigint(20) NOT NULL AUTO_INCREMENT,
    124. 

  124.   PRIMARY KEY (`nid`) USING BTREE,
    125. 

  125.   UNIQUE INDEX `uk_configtagrelation_configidtag`(`id`, `tag_name`, `tag_type`) USING BTREE,
    126. 

  126.   INDEX `idx_tenant_id`(`tenant_id`) USING BTREE
    127. 

  127. ) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'config_tag_relation' ROW_FORMAT = Dynamic;
    128. 

  128. 

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

  130. -- Records of config_tags_relation
    131. 

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

  132. INSERT INTO `config_tags_relation` VALUES (65, '后台管理', NULL, 'forest-admin.yml', 'DEFAULT_GROUP', '', 10);
    133. 

  133. 

  134. -- ----------------------------
    135. 

  135. -- Table structure for group_capacity
    136. 

  136. -- ----------------------------
    137. 

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

  138. CREATE TABLE `group_capacity`  (
    139. 

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

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

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

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

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

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

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

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

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

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

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

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

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

  152. 

  153. -- ----------------------------
    154. 

  154. -- Table structure for his_config_info
    155. 

  155. -- ----------------------------
    156. 

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

  157. CREATE TABLE `his_config_info`  (
    158. 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  176. 

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

  178. -- Records of his_config_info
    179. 

  179. -- ----------------------------
    180. 

  180. INSERT INTO `his_config_info` VALUES (65, 221, 'forest-admin.yml', 'DEFAULT_GROUP', 'forest-admin', 'spring:\r\n  datasource:\r\n    url: jdbc:mysql://172.16.90.253:3306/forest-cloud-mall?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai\r\n    username: root\r\n    password: 123456\r\n    druid:\r\n      initial-size: 5\r\n      min-idle: 10\r\n      max-active: 20\r\n      web-stat-filter:\r\n        exclusions: \"*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*\"\r\n      stat-view-servlet:\r\n        login-username: druid\r\n        login-password: druid\r\n  redis:\r\n    host: 172.16.90.253\r\n    database: 0\r\n    port: 6379\r\n    password: 123456\r\n    timeout: 300ms\r\n  zipkin:\r\n    base-url: http://localhost:9411\r\n    locator:\r\n      discovery:\r\n        enabled: true\r\n  sleuth:\r\n    sampler:\r\n      probability: 1.0\r\n  boot:\r\n    admin:\r\n      client:\r\n        url: http://localhost:8095\r\n\r\nmanagement:\r\n  endpoints:\r\n    web:\r\n      exposure:\r\n        include: \'*\'\r\n  endpoint:\r\n    health:\r\n      show-details: always\r\nmybatis:\r\n  mapper-locations:\r\n    - classpath:dao/*.xml\r\n    - classpath*:com/**/mapper/*.xml\r\nlogging:\r\n  level:\r\n    root: info \r\n    com.hwrj.cloud: debug\r\n\r\n  sleuth:\r\n    sampler:\r\n      probability: 1.0\r\n  boot:\r\n    admin:\r\n      client:\r\n        url: http://localhost:9091\r\n\r\njwt:\r\n  tokenHeader: Authorization\r\n  secret: forest-admin-secret\r\n  expiration: 604800\r\n  tokenHead: Bearer\r\n\r\nredis:\r\n  database: forest\r\n  key:\r\n    admin: \'ums:admin\'\r\n    token: \'ums:token\'\r\n    resourceList: \'ums:resourceList\'\r\n  expire:\r\n    common: 86400', '8894d85b8bc9cb7d39f1ce41d207934d', '2021-02-04 14:48:35', '2021-02-04 14:48:18', NULL, '0:0:0:0:0:0:0:1', 'U', '');
    181. 

  181. INSERT INTO `his_config_info` VALUES (61, 222, 'forest-portal.yml', 'DEFAULT_GROUP', 'forest-portal', 'spring:\r\n  datasource:\r\n    url: jdbc:mysql://172.16.90.253:3306/forest-cloud-mall?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai\r\n    username: root\r\n    password: 123456\r\n    druid:\r\n      initial-size: 5\r\n      min-idle: 10\r\n      max-active: 20\r\n      web-stat-filter:\r\n        exclusions: \"*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*\"\r\n      stat-view-servlet:\r\n        login-username: druid\r\n        login-password: druid\r\n  boot:\r\n    admin:\r\n      client:\r\n        url: http://localhost:9091\r\n  data:\r\n    mongodb:\r\n      host: 172.16.90.253\r\n      port: 27017\r\n      database: mall-port\r\n  redis:\r\n    host: 172.16.90.253\r\n    database: 0\r\n    port: 6379\r\n    password: 123456\r\n    timeout: 300ms\r\n\r\n  rabbitmq:\r\n    host: 172.16.90.64\r\n    port: 5672\r\n    virtual-host: /forest\r\n    username: forest\r\n    password: 123456\r\n    publisher-confirms: true\r\nmyredis:\r\n  address: redis://${spring.redis.host}:${spring.redis.port}\r\n  password: ${spring.redis.password}\r\n  \r\nlogging:\r\n  level:\r\n    org.springframework.data.mongodb.core: debug\r\n    com.hwrj.cloud.portal.mapper: debug\r\n    com.hwrj.cloud.portal.dao: debug\r\nmybatis:\r\n  mapper-locations:\r\n    - classpath:dao/*.xml\r\n    - classpath*:com/**/mapper/*.xml\r\nrabbitmq:\r\n  queue:\r\n    name:\r\n      cancelOrder: cancelOrderQueue\r\nredis:\r\n  database: forest\r\n  key:\r\n    authCode: \'ums:authCode\'\r\n    telLoginCode: \'ums:authCode\'\r\n    orderId: \'oms:orderId\'\r\n    member: \'ums:member\'\r\n    token: \'ums:token\'\r\n  expire:\r\n    authCode: 90\r\n    authLoginCode: 240\r\n    common: 86400\r\njwt:\r\n  tokenHeader: Authorization\r\n  secret: forest-admin-secret\r\n  expiration: 604800\r\n  tokenHead: Bearer\r\n  \r\nforest:\r\n  wx: \r\n    password: forest123456\r\n\r\nsms:\r\n  accessKeyId: LTAICB9TH0OAN3yJ\r\n  accessKeySecret: lCuyL3MUQRLfoVw39W0NqWdVGoLV60\r\n  signName: hywa\r\n  \r\nwx:\r\n  mp:\r\n    aesKey: 123\r\n    appId: wxbe90cc7c5233dd84\r\n    secret: ec4a18ce1a7bcf17cf592c3d57cec68a\r\n    token: 123\r\n    url: http://wx.hw.hongweisoft.com/fqb/forest-portal/wechat/h5/userInfo\r\n    before: http://172.16.90.25:8080\r\n  pay:\r\n    appId: wxbe90cc7c5233dd84\r\n    mchId: 1583849731\r\n    mchKey: B5F5A628C91D869F4CA357D2BCD63006\r\n    wxpayAppcallbackurl: http://wx.hw.hongweisoft.com/fqb/forest-portal/app/payResult', '130d044d680d275136a29858b149cddf', '2021-02-04 14:49:09', '2021-02-04 14:48:53', NULL, '0:0:0:0:0:0:0:1', 'U', '');
    182. 

  182. INSERT INTO `his_config_info` VALUES (62, 223, 'forest-gateway.yml', 'DEFAULT_GROUP', 'forest-gateway', 'spring:\r\n  redis:\r\n    host: 172.16.90.253\r\n    database: 0\r\n    port: 6379\r\n    password: 123456\r\n    timeout: 300ms\r\n  boot:\r\n    admin:\r\n      client:\r\n        url: http://localhost:9091\r\nmanagement:\r\n  endpoints:\r\n    web:\r\n      exposure:\r\n        include: \'*\'\r\n  endpoint:\r\n    health:\r\n      show-details: always\r\n      \r\njwt:\r\n  tokenHeader: Authorization\r\n  secret: forest-admin-secret\r\n  expiration: 604800\r\n  tokenHead: Bearer\r\n  \r\nredis:\r\n  database: forest\r\n  key:\r\n    admin: \'ums:admin\'\r\n    token: \'ums:token\'\r\n    resourceList: \'ums:resourceList\'\r\n  expire:\r\n    common: 86400', 'b8f6553b7c61c358a679ac28f96fd2ad', '2021-02-04 14:49:31', '2021-02-04 14:49:15', NULL, '0:0:0:0:0:0:0:1', 'U', '');
    183. 

  183. INSERT INTO `his_config_info` VALUES (62, 224, 'forest-gateway.yml', 'DEFAULT_GROUP', 'forest-gateway', 'spring:\r\n  redis:\r\n    host: 172.16.90.64\r\n    database: 0\r\n    port: 6379\r\n    password: \r\n    timeout: 300ms\r\n  boot:\r\n    admin:\r\n      client:\r\n        url: http://localhost:9091\r\nmanagement:\r\n  endpoints:\r\n    web:\r\n      exposure:\r\n        include: \'*\'\r\n  endpoint:\r\n    health:\r\n      show-details: always\r\n      \r\njwt:\r\n  tokenHeader: Authorization\r\n  secret: forest-admin-secret\r\n  expiration: 604800\r\n  tokenHead: Bearer\r\n  \r\nredis:\r\n  database: forest\r\n  key:\r\n    admin: \'ums:admin\'\r\n    token: \'ums:token\'\r\n    resourceList: \'ums:resourceList\'\r\n  expire:\r\n    common: 86400', 'fdbce19012bdb76ab1ccead808fa1d02', '2021-02-04 14:49:56', '2021-02-04 14:49:39', NULL, '0:0:0:0:0:0:0:1', 'U', '');
    184. 

  184. 

  185. -- ----------------------------
    186. 

  186. -- Table structure for permissions
    187. 

  187. -- ----------------------------
    188. 

  188. DROP TABLE IF EXISTS `permissions`;
    189. 

  189. CREATE TABLE `permissions`  (
    190. 

  190.   `role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    191. 

  191.   `resource` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    192. 

  192.   `action` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    193. 

  193.   UNIQUE INDEX `uk_role_permission`(`role`, `resource`, `action`) USING BTREE
    194. 

  194. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
    195. 

  195. 

  196. -- ----------------------------
    197. 

  197. -- Table structure for roles
    198. 

  198. -- ----------------------------
    199. 

  199. DROP TABLE IF EXISTS `roles`;
    200. 

  200. CREATE TABLE `roles`  (
    201. 

  201.   `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    202. 

  202.   `role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    203. 

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

  204. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
    205. 

  205. 

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

  207. -- Records of roles
    208. 

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

  209. INSERT INTO `roles` VALUES ('nacos', 'ROLE_ADMIN');
    210. 

  210. 

  211. -- ----------------------------
    212. 

  212. -- Table structure for tenant_capacity
    213. 

  213. -- ----------------------------
    214. 

  214. DROP TABLE IF EXISTS `tenant_capacity`;
    215. 

  215. CREATE TABLE `tenant_capacity`  (
    216. 

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

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

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

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

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

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

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

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

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

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

  226.   PRIMARY KEY (`id`) USING BTREE,
    227. 

  227.   UNIQUE INDEX `uk_tenant_id`(`tenant_id`) USING BTREE
    228. 

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

  229. 

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

  231. -- Table structure for tenant_info
    232. 

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

  233. DROP TABLE IF EXISTS `tenant_info`;
    234. 

  234. CREATE TABLE `tenant_info`  (
    235. 

  235.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
    236. 

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

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

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

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

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

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

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

  243.   PRIMARY KEY (`id`) USING BTREE,
    244. 

  244.   UNIQUE INDEX `uk_tenant_info_kptenantid`(`kp`, `tenant_id`) USING BTREE,
    245. 

  245.   INDEX `idx_tenant_id`(`tenant_id`) USING BTREE
    246. 

  246. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'tenant_info' ROW_FORMAT = Dynamic;
    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.