/* 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: 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'); 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'); 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: 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'); -- ---------------------------- -- 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: 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', ''); 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', ''); 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', ''); 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;