/*
 Navicat Premium Data Transfer

 Source Server         : 172.16.90.64_3306
 Source Server Type    : MySQL
 Source Server Version : 50730
 Source Host           : 172.16.90.64:3306
 Source Schema         : forest-config-nacos

 Target Server Type    : MySQL
 Target Server Version : 50730
 File Encoding         : 65001

 Date: 05/02/2021 18:03:05
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for config_info
-- ----------------------------
DROP TABLE IF EXISTS `config_info`;
CREATE TABLE `config_info`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id',
  `group_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'content',
  `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'md5',
  `gmt_create` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '修改时间',
  `src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT 'source user',
  `src_ip` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'source ip',
  `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT '租户字段',
  `c_desc` varchar(256) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `c_use` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `effect` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `type` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `c_schema` text CHARACTER SET utf8 COLLATE utf8_bin NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uk_configinfo_datagrouptenant`(`data_id`, `group_id`, `tenant_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 66 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'config_info' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of config_info
-- ----------------------------
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: [REDACTED]\r\n  bucket: forestcloud\r\n  path: http://fqn.hongweisoft.com/\r\n  processName: \'null\'\r\n  secretKey: [REDACTED]  ', '69720b920d4f36307512d14e8db1f619', '2020-11-10 18:00:16', '2020-12-10 09:49:57', NULL, '172.16.90.8', '公共配置文件', '', '公共配置文件', 'null', 'null', 'yaml', 'null');
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: [REDACTED]    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: [REDACTED]  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: [REDACTED]    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: [REDACTED]  accessKeyId: [REDACTED]\r\n  accessKeySecret: [REDACTED]\r\n  signName: hywa\r\n  \r\nwx:\r\n  mp:\r\n    aesKey: 123\r\n    appId: wxbe90cc7c5233dd84\r\n    secret: [REDACTED]\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: [REDACTED]\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');
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');
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: [REDACTED]    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: [REDACTED]  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');

-- ----------------------------
-- Table structure for config_info_aggr
-- ----------------------------
DROP TABLE IF EXISTS `config_info_aggr`;
CREATE TABLE `config_info_aggr`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id',
  `group_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'group_id',
  `datum_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'datum_id',
  `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '内容',
  `gmt_modified` datetime(0) NOT NULL COMMENT '修改时间',
  `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT '租户字段',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uk_configinfoaggr_datagrouptenantdatum`(`data_id`, `group_id`, `tenant_id`, `datum_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '增加租户字段' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for config_info_beta
-- ----------------------------
DROP TABLE IF EXISTS `config_info_beta`;
CREATE TABLE `config_info_beta`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id',
  `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'group_id',
  `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'app_name',
  `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'content',
  `beta_ips` varchar(1024) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'betaIps',
  `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'md5',
  `gmt_create` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '修改时间',
  `src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT 'source user',
  `src_ip` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'source ip',
  `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT '租户字段',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uk_configinfobeta_datagrouptenant`(`data_id`, `group_id`, `tenant_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'config_info_beta' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for config_info_tag
-- ----------------------------
DROP TABLE IF EXISTS `config_info_tag`;
CREATE TABLE `config_info_tag`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id',
  `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'group_id',
  `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT 'tenant_id',
  `tag_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'tag_id',
  `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'app_name',
  `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'content',
  `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'md5',
  `gmt_create` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '修改时间',
  `src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT 'source user',
  `src_ip` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'source ip',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uk_configinfotag_datagrouptenanttag`(`data_id`, `group_id`, `tenant_id`, `tag_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'config_info_tag' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for config_tags_relation
-- ----------------------------
DROP TABLE IF EXISTS `config_tags_relation`;
CREATE TABLE `config_tags_relation`  (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `tag_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'tag_name',
  `tag_type` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'tag_type',
  `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id',
  `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'group_id',
  `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT 'tenant_id',
  `nid` bigint(20) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`nid`) USING BTREE,
  UNIQUE INDEX `uk_configtagrelation_configidtag`(`id`, `tag_name`, `tag_type`) USING BTREE,
  INDEX `idx_tenant_id`(`tenant_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'config_tag_relation' ROW_FORMAT = Dynamic;

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

-- ----------------------------
-- Table structure for group_capacity
-- ----------------------------
DROP TABLE IF EXISTS `group_capacity`;
CREATE TABLE `group_capacity`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'Group ID，空字符表示整个集群',
  `quota` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '配额，0表示使用默认值',
  `usage` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '使用量',
  `max_size` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '单个配置大小上限，单位为字节，0表示使用默认值',
  `max_aggr_count` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '聚合子配置最大个数，，0表示使用默认值',
  `max_aggr_size` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '单个聚合数据的子配置大小上限，单位为字节，0表示使用默认值',
  `max_history_count` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最大变更历史数量',
  `gmt_create` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uk_group_id`(`group_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '集群、各Group容量信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for his_config_info
-- ----------------------------
DROP TABLE IF EXISTS `his_config_info`;
CREATE TABLE `his_config_info`  (
  `id` bigint(64) UNSIGNED NOT NULL,
  `nid` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'app_name',
  `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `gmt_create` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
  `gmt_modified` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
  `src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL,
  `src_ip` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `op_type` char(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT '租户字段',
  PRIMARY KEY (`nid`) USING BTREE,
  INDEX `idx_gmt_create`(`gmt_create`) USING BTREE,
  INDEX `idx_gmt_modified`(`gmt_modified`) USING BTREE,
  INDEX `idx_did`(`data_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 225 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '多租户改造' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of his_config_info
-- ----------------------------
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: [REDACTED]    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: [REDACTED]  redis:\r\n    host: 172.16.90.253\r\n    database: 0\r\n    port: 6379\r\n    password: [REDACTED]    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', '');
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: [REDACTED]    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: [REDACTED]  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: [REDACTED]    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: [REDACTED]    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: [REDACTED]  accessKeyId: [REDACTED]\r\n  accessKeySecret: [REDACTED]\r\n  signName: hywa\r\n  \r\nwx:\r\n  mp:\r\n    aesKey: 123\r\n    appId: wxbe90cc7c5233dd84\r\n    secret: [REDACTED]\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: [REDACTED]\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', '');
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: [REDACTED]    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', '');
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', '');

-- ----------------------------
-- Table structure for permissions
-- ----------------------------
DROP TABLE IF EXISTS `permissions`;
CREATE TABLE `permissions`  (
  `role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `resource` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `action` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  UNIQUE INDEX `uk_role_permission`(`role`, `resource`, `action`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for roles
-- ----------------------------
DROP TABLE IF EXISTS `roles`;
CREATE TABLE `roles`  (
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  UNIQUE INDEX `idx_user_role`(`username`, `role`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of roles
-- ----------------------------
INSERT INTO `roles` VALUES ('nacos', 'ROLE_ADMIN');

-- ----------------------------
-- Table structure for tenant_capacity
-- ----------------------------
DROP TABLE IF EXISTS `tenant_capacity`;
CREATE TABLE `tenant_capacity`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'Tenant ID',
  `quota` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '配额，0表示使用默认值',
  `usage` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '使用量',
  `max_size` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '单个配置大小上限，单位为字节，0表示使用默认值',
  `max_aggr_count` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '聚合子配置最大个数',
  `max_aggr_size` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '单个聚合数据的子配置大小上限，单位为字节，0表示使用默认值',
  `max_history_count` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最大变更历史数量',
  `gmt_create` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uk_tenant_id`(`tenant_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '租户容量信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tenant_info
-- ----------------------------
DROP TABLE IF EXISTS `tenant_info`;
CREATE TABLE `tenant_info`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `kp` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'kp',
  `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT 'tenant_id',
  `tenant_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT 'tenant_name',
  `tenant_desc` varchar(256) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'tenant_desc',
  `create_source` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'create_source',
  `gmt_create` bigint(20) NOT NULL COMMENT '创建时间',
  `gmt_modified` bigint(20) NOT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uk_tenant_info_kptenantid`(`kp`, `tenant_id`) USING BTREE,
  INDEX `idx_tenant_id`(`tenant_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'tenant_info' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`  (
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `password` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  PRIMARY KEY (`username`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES ('nacos', '$2a$10$EuWPZHzz32dJN7jexM34MOeYirDdFAZm2kuWj7VEOJhhZkDrxfvUu', 1);

SET FOREIGN_KEY_CHECKS = 1;
