代码拉取完成，页面将自动刷新
Fork 仓库
加载中
确定同步？
同步操作将从 勿忘我/ssmp-wx 强制同步，此操作会覆盖自 Fork 仓库以来所做的任何修改，且无法恢复！！！
确定后同步将在后台操作，完成时将刷新页面，请耐心等待。
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361
/*
SQLyog Ultimate v12.3.1 (64 bit)
MySQL - 5.7.18-log : Database - nacos-config
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`nacos-config` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `nacos-config`;
/*Table structure for table `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) COLLATE utf8_bin NOT NULL COMMENT 'data_id',
`group_id` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`content` longtext COLLATE utf8_bin NOT NULL COMMENT 'content',
`md5` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT 'md5',
`gmt_create` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '创建时间',
`gmt_modified` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '修改时间',
`src_user` text COLLATE utf8_bin COMMENT 'source user',
`src_ip` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT 'source ip',
`app_name` varchar(128) COLLATE utf8_bin DEFAULT NULL,
`tenant_id` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT '租户字段',
`c_desc` varchar(256) COLLATE utf8_bin DEFAULT NULL,
`c_use` varchar(64) COLLATE utf8_bin DEFAULT NULL,
`effect` varchar(64) COLLATE utf8_bin DEFAULT NULL,
`type` varchar(64) COLLATE utf8_bin DEFAULT NULL,
`c_schema` text COLLATE utf8_bin,
PRIMARY KEY (`id`),
UNIQUE KEY `uk_configinfo_datagrouptenant` (`data_id`,`group_id`,`tenant_id`)
) ENGINE=InnoDB AUTO_INCREMENT=336 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_info';
/*Data for the table `config_info` */
insert into `config_info`(`id`,`data_id`,`group_id`,`content`,`md5`,`gmt_create`,`gmt_modified`,`src_user`,`src_ip`,`app_name`,`tenant_id`,`c_desc`,`c_use`,`effect`,`type`,`c_schema`) values
(11,'ssmp-wx-api-user-dev.yaml','DEV_GROUP','server:\n port: 9004\n\nspring:\n cloud:\n sentinel:\n transport:\n dashboard: 121.5.245.165:8080\n port: 8719\n zipkin:\n base-url: http://127.0.0.1:9411\n sleuth:\n sampler:\n probability: 1\n datasource:\n url: jdbc:mysql://127.0.0.1:3306/ssmp-wx-member?useUnicode=true&characterEncoding=utf-8\n username: root\n password: root\n type: com.alibaba.druid.pool.DruidDataSource\n\nsms:\n secretId: AKIDNVDg04Z0atv0rQh16uQm24oHYcPupLHw\n secretKey: ZS7VdqlSuGNEo84mDNbcNr5OTIqKbcMq\n appid: 1400489343\n sign: 贾志新个人使用\n\nseata:\n enabled: true # 开启 seata 事务\n application-id: ${spring.application.name}\n tx-service-group: my_test_tx_group\n enable-auto-data-source-proxy: true\n config:\n type: nacos\n nacos:\n serverAddr: ${spring.cloud.nacos.discovery.server-addr}\n group: SEATA_GROUP\n namespace: ${spring.cloud.nacos.discovery.namespace}\n username: \"nacos\"\n password: \"nacos\"\n registry:\n type: nacos\n nacos:\n application: seata-server # 与服务端配置一致，默认为 seata-server\n server-addr: ${spring.cloud.nacos.discovery.server-addr}\n group: SEATA_GROUP\n namespace: ${spring.cloud.nacos.discovery.namespace}\n username: \"nacos\"\n password: \"nacos\"\n','f2670c33715204ab687693122b53997e','2021-05-01 14:29:19','2021-08-06 00:48:30',NULL,'127.0.0.1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51','用户微服务','null','null','yaml','null'),
(13,'ssmp-wx-api-product-dev.yaml','DEV_GROUP','server:\n port: 9003\n\nspring:\n cloud:\n sentinel:\n transport:\n dashboard: 121.5.245.165:8080\n port: 8719\n zipkin:\n base-url: http://127.0.0.1:9411\n sleuth:\n sampler:\n probability: 1\n datasource:\n url: jdbc:mysql://127.0.0.1:3306/ssmp-wx-product?useUnicode=true&characterEncoding=utf-8\n username: root\n password: root\n driver-class-name: com.mysql.jdbc.Driver\n\n\nseata:\n enabled: true # 开启 seata 事务\n application-id: ${spring.application.name}\n tx-service-group: my_test_tx_group\n enable-auto-data-source-proxy: true\n config:\n type: nacos\n nacos:\n serverAddr: ${spring.cloud.nacos.discovery.server-addr}\n group: SEATA_GROUP\n namespace: ${spring.cloud.nacos.discovery.namespace}\n username: \"nacos\"\n password: \"nacos\"\n registry:\n type: nacos\n nacos:\n application: seata-server # 与服务端配置一致，默认为 seata-server\n server-addr: ${spring.cloud.nacos.discovery.server-addr}\n group: SEATA_GROUP\n namespace: ${spring.cloud.nacos.discovery.namespace}\n username: \"nacos\"\n password: \"nacos\"\n','2986863096012f998487fc4c751b14a5','2021-05-01 14:46:18','2021-08-06 00:48:41',NULL,'127.0.0.1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51','商品微服务','null','null','yaml','null'),
(18,'ssmp-wx-api-order-dev.yaml','DEV_GROUP','server:\n port: 9002\n\n\nspring:\n cloud:\n sentinel:\n transport:\n dashboard: 121.5.245.165:8080\n port: 8719\n zipkin:\n base-url: http://127.0.0.1:9411\n sleuth:\n sampler:\n probability: 1\n datasource:\n url: jdbc:mysql://127.0.0.1:3306/ssmp-wx-order?useUnicode=true&characterEncoding=utf-8\n username: root\n password: root\n driver-class-name: com.mysql.jdbc.Driver\n\n\nseata:\n enabled: true # 开启 seata 事务\n application-id: ${spring.application.name}\n tx-service-group: my_test_tx_group\n enable-auto-data-source-proxy: true\n config:\n type: nacos\n nacos:\n serverAddr: ${spring.cloud.nacos.discovery.server-addr}\n group: SEATA_GROUP\n namespace: ${spring.cloud.nacos.discovery.namespace}\n username: \"nacos\"\n password: \"nacos\"\n registry:\n type: nacos\n nacos:\n application: seata-server # 与服务端配置一致，默认为 seata-server\n server-addr: ${spring.cloud.nacos.discovery.server-addr}\n group: SEATA_GROUP\n namespace: ${spring.cloud.nacos.discovery.namespace}\n username: \"nacos\"\n password: \"nacos\"\n','924d2581d54d92e18f96c574d8888a9b','2021-05-01 15:07:12','2021-08-06 00:48:51',NULL,'127.0.0.1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51','订单','null','null','yaml','null'),
(29,'ssmp-wx-api-dev.yaml','DEV_GROUP','server:\n port: 9001\n tomcat:\n #tomcat线程池大小设置\n max-threads: 1000\n #tomcat初始化线程数量\n min-spare-threads: 30\n #tomcat编码\n uri-encoding: UTF-8\n max-http-header-size: 8192\n\nspring:\n cloud:\n sentinel:\n transport:\n dashboard: 121.5.245.165:8080\n port: 8719\n zipkin:\n base-url: http://127.0.0.1:9411\n sleuth:\n sampler:\n probability: 1\n # thymeleaf\n thymeleaf:\n prefix: classpath:/static/\n check-template-location: true\n suffix: .html\n encoding: utf-8\n servlet:\n content-type: text/html\n mode: HTML5\n cache: false\n redis:\n database: 0\n host: 127.0.0.1\n port: 6379\n password:\n jedis:\n pool:\n max-active: 20\n max-wait: -1\n max-idle: 10\n min-idle: 0\n timeout: 1000\nwx:\n mp:\n useRedis: false\n redisConfig:\n host: 127.0.0.1\n port: 6379\n configs:\n - appId: wxb9c84ec2e5c72d28 # 第一个公众号的appid\n secret: 23571b6925227e41a79345ae294a0fc2 # 公众号的appsecret\n token: 111 # 接口配置里的Token值\n aesKey: fx3qMEfJQXQQpUtRdpLMDySLdiXLYpoqmxXllS0er8A # 接口配置里的EncodingAESKey值\nmanagement:\n endpoints:\n web:\n exposure:\n include: \'*\'\n\n\nfeign:\n client:\n config:\n default:\n connectTimeout: 50000\n readTimeout: 50000\n hystrix:\n enabled: true\n compression:\n request:\n enabled: true\n mime-types: text/xml,application/xml,application/json\n min-request-size: 20482\n response:\n enabled: true\n useGzipDecoder: true\n\nhystrix:\n command:\n default:\n execution:\n timeout:\n enabled: true\n isolation:\n thread:\n timeoutInMilliseconds: 600000\n\ncos:\n accessKeyId: AKIDNVDg04Z0atv0rQh16uQm24oHYcPupLHw\n accessKeySecret: ZS7VdqlSuGNEo84mDNbcNr5OTIqKbcMq\n bucketName: shop-admin-1300029934\n shopImages: https://shop-admin-1300029934.cos.ap-beijing.myqcloud.com\n\n\n\nseata:\n enabled: true # 开启 seata 事务\n application-id: ${spring.application.name}\n tx-service-group: my_test_tx_group\n enable-auto-data-source-proxy: true\n config:\n type: nacos\n nacos:\n serverAddr: ${spring.cloud.nacos.discovery.server-addr}\n group: SEATA_GROUP\n namespace: ${spring.cloud.nacos.discovery.namespace}\n username: \"nacos\"\n password: \"nacos\"\n registry:\n type: nacos\n nacos:\n application: seata-server # 与服务端配置一致，默认为 seata-server\n server-addr: ${spring.cloud.nacos.discovery.server-addr}\n group: SEATA_GROUP\n namespace: ${spring.cloud.nacos.discovery.namespace}\n username: \"nacos\"\n password: \"nacos\"\n','eff596bf252906e508cec937124ff888','2021-05-17 11:29:35','2021-08-06 00:49:04',NULL,'127.0.0.1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51','null','null','null','yaml','null'),
(241,'transport.type','SEATA_GROUP','TCP','b136ef5f6a01d816991fe3cf7a6ac763','2021-05-28 00:12:58','2021-05-28 00:12:58',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(242,'transport.server','SEATA_GROUP','NIO','b6d9dfc0fb54277321cebc0fff55df2f','2021-05-28 00:13:00','2021-05-28 00:13:00',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(243,'transport.heartbeat','SEATA_GROUP','true','b326b5062b2f0e69046810717534cb09','2021-05-28 00:13:02','2021-05-28 00:13:02',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(244,'transport.enableClientBatchSendRequest','SEATA_GROUP','false','68934a3e9455fa72420237eb05902327','2021-05-28 00:13:03','2021-05-28 00:13:03',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(245,'transport.threadFactory.bossThreadPrefix','SEATA_GROUP','NettyBoss','0f8db59a3b7f2823f38a70c308361836','2021-05-28 00:13:05','2021-05-28 00:13:05',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(246,'transport.threadFactory.workerThreadPrefix','SEATA_GROUP','NettyServerNIOWorker','a78ec7ef5d1631754c4e72ae8a3e9205','2021-05-28 00:13:07','2021-05-28 00:13:07',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(247,'transport.threadFactory.serverExecutorThreadPrefix','SEATA_GROUP','NettyServerBizHandler','11a36309f3d9df84fa8b59cf071fa2da','2021-05-28 00:13:08','2021-05-28 00:13:08',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(248,'transport.threadFactory.shareBossWorker','SEATA_GROUP','false','68934a3e9455fa72420237eb05902327','2021-05-28 00:13:10','2021-05-28 00:13:10',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(249,'transport.threadFactory.clientSelectorThreadPrefix','SEATA_GROUP','NettyClientSelector','cd7ec5a06541e75f5a7913752322c3af','2021-05-28 00:13:12','2021-05-28 00:13:12',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(250,'transport.threadFactory.clientSelectorThreadSize','SEATA_GROUP','1','c4ca4238a0b923820dcc509a6f75849b','2021-05-28 00:13:13','2021-05-28 00:13:13',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(251,'transport.threadFactory.clientWorkerThreadPrefix','SEATA_GROUP','NettyClientWorkerThread','61cf4e69a56354cf72f46dc86414a57e','2021-05-28 00:13:15','2021-05-28 00:13:15',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(252,'transport.threadFactory.bossThreadSize','SEATA_GROUP','1','c4ca4238a0b923820dcc509a6f75849b','2021-05-28 00:13:17','2021-05-28 00:13:17',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(253,'transport.threadFactory.workerThreadSize','SEATA_GROUP','default','c21f969b5f03d33d43e04f8f136e7682','2021-05-28 00:13:19','2021-05-28 00:13:19',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(254,'transport.shutdown.wait','SEATA_GROUP','3','eccbc87e4b5ce2fe28308fd9f2a7baf3','2021-05-28 00:13:21','2021-05-28 00:13:21',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(255,'service.vgroupMapping.my_test_tx_group','SEATA_GROUP','default','c21f969b5f03d33d43e04f8f136e7682','2021-05-28 00:13:24','2021-05-28 00:13:24',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(256,'service.default.grouplist','SEATA_GROUP','127.0.0.1:8091','c32ce0d3e264525dcdada751f98143a3','2021-05-28 00:13:26','2021-08-04 07:30:11',NULL,'127.0.0.1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51','','','','text',''),
(257,'service.enableDegrade','SEATA_GROUP','false','68934a3e9455fa72420237eb05902327','2021-05-28 00:13:28','2021-05-28 00:13:28',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(258,'service.disableGlobalTransaction','SEATA_GROUP','false','68934a3e9455fa72420237eb05902327','2021-05-28 00:13:31','2021-05-28 00:13:31',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(259,'client.rm.asyncCommitBufferLimit','SEATA_GROUP','10000','b7a782741f667201b54880c925faec4b','2021-05-28 00:13:34','2021-05-28 00:13:34',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(260,'client.rm.lock.retryInterval','SEATA_GROUP','10','d3d9446802a44259755d38e6d163e820','2021-05-28 00:13:37','2021-05-28 00:13:37',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(261,'client.rm.lock.retryTimes','SEATA_GROUP','30','34173cb38f07f89ddbebc2ac9128303f','2021-05-28 00:13:41','2021-05-28 00:13:41',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(262,'client.rm.lock.retryPolicyBranchRollbackOnConflict','SEATA_GROUP','true','b326b5062b2f0e69046810717534cb09','2021-05-28 00:13:44','2021-05-28 00:13:44',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(263,'client.rm.reportRetryCount','SEATA_GROUP','5','e4da3b7fbbce2345d7772b0674a318d5','2021-05-28 00:13:47','2021-05-28 00:13:47',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(264,'client.rm.tableMetaCheckEnable','SEATA_GROUP','false','68934a3e9455fa72420237eb05902327','2021-05-28 00:13:50','2021-05-28 00:13:50',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(265,'client.rm.sqlParserType','SEATA_GROUP','druid','3d650fb8a5df01600281d48c47c9fa60','2021-05-28 00:13:53','2021-05-28 00:13:53',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(266,'client.rm.reportSuccessEnable','SEATA_GROUP','false','68934a3e9455fa72420237eb05902327','2021-05-28 00:13:56','2021-05-28 00:13:56',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(267,'client.rm.sagaBranchRegisterEnable','SEATA_GROUP','false','68934a3e9455fa72420237eb05902327','2021-05-28 00:13:58','2021-05-28 00:13:58',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(268,'client.tm.commitRetryCount','SEATA_GROUP','5','e4da3b7fbbce2345d7772b0674a318d5','2021-05-28 00:14:00','2021-05-28 00:14:00',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(269,'client.tm.rollbackRetryCount','SEATA_GROUP','5','e4da3b7fbbce2345d7772b0674a318d5','2021-05-28 00:14:02','2021-05-28 00:14:02',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(270,'client.tm.degradeCheck','SEATA_GROUP','false','68934a3e9455fa72420237eb05902327','2021-05-28 00:14:04','2021-05-28 00:14:04',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(271,'client.tm.degradeCheckAllowTimes','SEATA_GROUP','10','d3d9446802a44259755d38e6d163e820','2021-05-28 00:14:05','2021-05-28 00:14:05',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(272,'client.tm.degradeCheckPeriod','SEATA_GROUP','2000','08f90c1a417155361a5c4b8d297e0d78','2021-05-28 00:14:07','2021-05-28 00:14:07',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(273,'store.mode','SEATA_GROUP','db','d77d5e503ad1439f585ac494268b351b','2021-05-28 00:14:09','2021-05-28 00:14:09',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(274,'store.file.dir','SEATA_GROUP','file_store/data','6a8dec07c44c33a8a9247cba5710bbb2','2021-05-28 00:14:11','2021-05-28 00:14:11',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(275,'store.file.maxBranchSessionSize','SEATA_GROUP','16384','c76fe1d8e08462434d800487585be217','2021-05-28 00:14:12','2021-05-28 00:14:12',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(276,'store.file.maxGlobalSessionSize','SEATA_GROUP','512','10a7cdd970fe135cf4f7bb55c0e3b59f','2021-05-28 00:14:14','2021-05-28 00:14:14',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(277,'store.file.fileWriteBufferCacheSize','SEATA_GROUP','16384','c76fe1d8e08462434d800487585be217','2021-05-28 00:14:16','2021-05-28 00:14:16',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(278,'store.file.flushDiskMode','SEATA_GROUP','async','0df93e34273b367bb63bad28c94c78d5','2021-05-28 00:14:18','2021-05-28 00:14:18',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(279,'store.file.sessionReloadReadSize','SEATA_GROUP','100','f899139df5e1059396431415e770c6dd','2021-05-28 00:14:19','2021-05-28 00:14:19',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(280,'store.db.datasource','SEATA_GROUP','druid','3d650fb8a5df01600281d48c47c9fa60','2021-05-28 00:14:21','2021-05-28 00:14:21',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(281,'store.db.dbType','SEATA_GROUP','mysql','81c3b080dad537de7e10e0987a4bf52e','2021-05-28 00:14:23','2021-05-28 00:14:23',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(282,'store.db.driverClassName','SEATA_GROUP','com.mysql.jdbc.Driver','683cf0c3a5a56cec94dfac94ca16d760','2021-05-28 00:14:24','2021-05-28 00:14:24',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(283,'store.db.url','SEATA_GROUP','jdbc:mysql://127.0.0.1:3306/seata?useUnicode=true&useSSL=false&characterEncoding=utf8&serverTimezone=Asia/Shanghai\n\n','4099b81c80039e16aa30dfa91fc0d132','2021-05-28 00:14:26','2021-08-06 00:35:50',NULL,'127.0.0.1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51','','','','text',''),
(284,'store.db.user','SEATA_GROUP','root','63a9f0ea7bb98050796b649e85481845','2021-05-28 00:14:28','2021-05-28 00:14:28',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(285,'store.db.password','SEATA_GROUP','root','63a9f0ea7bb98050796b649e85481845','2021-05-28 00:14:30','2021-08-06 00:36:07',NULL,'127.0.0.1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51','','','','text',''),
(286,'store.db.minConn','SEATA_GROUP','5','e4da3b7fbbce2345d7772b0674a318d5','2021-05-28 00:14:31','2021-05-28 00:14:31',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(287,'store.db.maxConn','SEATA_GROUP','30','34173cb38f07f89ddbebc2ac9128303f','2021-05-28 00:14:33','2021-05-28 00:14:33',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(288,'store.db.globalTable','SEATA_GROUP','global_table','8b28fb6bb4c4f984df2709381f8eba2b','2021-05-28 00:14:35','2021-05-28 00:14:35',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(289,'store.db.branchTable','SEATA_GROUP','branch_table','54bcdac38cf62e103fe115bcf46a660c','2021-05-28 00:14:36','2021-05-28 00:14:36',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(290,'store.db.queryLimit','SEATA_GROUP','100','f899139df5e1059396431415e770c6dd','2021-05-28 00:14:38','2021-05-28 00:14:38',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(291,'store.db.lockTable','SEATA_GROUP','lock_table','55e0cae3b6dc6696b768db90098b8f2f','2021-05-28 00:14:40','2021-05-28 00:14:40',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(292,'store.db.maxWait','SEATA_GROUP','5000','a35fe7f7fe8217b4369a0af4244d1fca','2021-05-28 00:14:41','2021-05-28 00:14:41',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(293,'store.redis.host','SEATA_GROUP','127.0.0.1','f528764d624db129b32c21fbca0cb8d6','2021-05-28 00:14:43','2021-05-28 00:14:43',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(294,'store.redis.port','SEATA_GROUP','6379','92c3b916311a5517d9290576e3ea37ad','2021-05-28 00:14:45','2021-05-28 00:14:45',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(295,'store.redis.maxConn','SEATA_GROUP','10','d3d9446802a44259755d38e6d163e820','2021-05-28 00:14:46','2021-05-28 00:14:46',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(296,'store.redis.minConn','SEATA_GROUP','1','c4ca4238a0b923820dcc509a6f75849b','2021-05-28 00:14:48','2021-05-28 00:14:48',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(297,'store.redis.database','SEATA_GROUP','0','cfcd208495d565ef66e7dff9f98764da','2021-05-28 00:14:50','2021-05-28 00:14:50',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(298,'store.redis.password','SEATA_GROUP','null','37a6259cc0c1dae299a7866489dff0bd','2021-05-28 00:14:51','2021-05-28 00:14:51',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(299,'store.redis.queryLimit','SEATA_GROUP','100','f899139df5e1059396431415e770c6dd','2021-05-28 00:14:53','2021-05-28 00:14:53',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(300,'server.recovery.committingRetryPeriod','SEATA_GROUP','1000','a9b7ba70783b617e9998dc4dd82eb3c5','2021-05-28 00:14:55','2021-05-28 00:14:55',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(301,'server.recovery.asynCommittingRetryPeriod','SEATA_GROUP','1000','a9b7ba70783b617e9998dc4dd82eb3c5','2021-05-28 00:14:56','2021-05-28 00:14:56',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(302,'server.recovery.rollbackingRetryPeriod','SEATA_GROUP','1000','a9b7ba70783b617e9998dc4dd82eb3c5','2021-05-28 00:14:58','2021-05-28 00:14:58',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(303,'server.recovery.timeoutRetryPeriod','SEATA_GROUP','1000','a9b7ba70783b617e9998dc4dd82eb3c5','2021-05-28 00:14:59','2021-05-28 00:14:59',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(304,'server.maxCommitRetryTimeout','SEATA_GROUP','-1','6bb61e3b7bce0931da574d19d1d82c88','2021-05-28 00:15:01','2021-05-28 00:15:01',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(305,'server.maxRollbackRetryTimeout','SEATA_GROUP','-1','6bb61e3b7bce0931da574d19d1d82c88','2021-05-28 00:15:03','2021-05-28 00:15:03',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(306,'server.rollbackRetryTimeoutUnlockEnable','SEATA_GROUP','false','68934a3e9455fa72420237eb05902327','2021-05-28 00:15:05','2021-05-28 00:15:05',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(307,'client.undo.dataValidation','SEATA_GROUP','true','b326b5062b2f0e69046810717534cb09','2021-05-28 00:15:06','2021-05-28 00:15:06',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(308,'client.undo.logSerialization','SEATA_GROUP','jackson','b41779690b83f182acc67d6388c7bac9','2021-05-28 00:15:08','2021-05-28 00:15:08',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(309,'client.undo.onlyCareUpdateColumns','SEATA_GROUP','true','b326b5062b2f0e69046810717534cb09','2021-05-28 00:15:10','2021-05-28 00:15:10',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(310,'server.undo.logSaveDays','SEATA_GROUP','7','8f14e45fceea167a5a36dedd4bea2543','2021-05-28 00:15:11','2021-05-28 00:15:11',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(311,'server.undo.logDeletePeriod','SEATA_GROUP','86400000','f4c122804fe9076cb2710f55c3c6e346','2021-05-28 00:15:13','2021-05-28 00:15:13',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(312,'client.undo.logTable','SEATA_GROUP','undo_log','2842d229c24afe9e61437135e8306614','2021-05-28 00:15:15','2021-05-28 00:15:15',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(313,'client.log.exceptionRate','SEATA_GROUP','100','f899139df5e1059396431415e770c6dd','2021-05-28 00:15:16','2021-05-28 00:15:16',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(314,'transport.serialization','SEATA_GROUP','seata','b943081c423b9a5416a706524ee05d40','2021-05-28 00:15:18','2021-05-28 00:15:18',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(315,'transport.compressor','SEATA_GROUP','none','334c4a4c42fdb79d7ebc3e73b517e6f8','2021-05-28 00:15:20','2021-05-28 00:15:20',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(316,'metrics.enabled','SEATA_GROUP','false','68934a3e9455fa72420237eb05902327','2021-05-28 00:15:22','2021-05-28 00:15:22',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(317,'metrics.registryType','SEATA_GROUP','compact','7cf74ca49c304df8150205fc915cd465','2021-05-28 00:15:23','2021-05-28 00:15:23',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(318,'metrics.exporterList','SEATA_GROUP','prometheus','e4f00638b8a10e6994e67af2f832d51c','2021-05-28 00:15:25','2021-05-28 00:15:25',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL),
(319,'metrics.exporterPrometheusPort','SEATA_GROUP','9898','7b9dc501afe4ee11c56a4831e20cee71','2021-05-28 00:15:27','2021-05-28 00:15:27',NULL,'0:0:0:0:0:0:0:1','','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51',NULL,NULL,NULL,'text',NULL);
/*Table structure for table `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) COLLATE utf8_bin NOT NULL COMMENT 'data_id',
`group_id` varchar(255) COLLATE utf8_bin NOT NULL COMMENT 'group_id',
`datum_id` varchar(255) COLLATE utf8_bin NOT NULL COMMENT 'datum_id',
`content` longtext COLLATE utf8_bin NOT NULL COMMENT '内容',
`gmt_modified` datetime NOT NULL COMMENT '修改时间',
`app_name` varchar(128) COLLATE utf8_bin DEFAULT NULL,
`tenant_id` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT '租户字段',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_configinfoaggr_datagrouptenantdatum` (`data_id`,`group_id`,`tenant_id`,`datum_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='增加租户字段';
/*Data for the table `config_info_aggr` */
/*Table structure for table `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) COLLATE utf8_bin NOT NULL COMMENT 'data_id',
`group_id` varchar(128) COLLATE utf8_bin NOT NULL COMMENT 'group_id',
`app_name` varchar(128) COLLATE utf8_bin DEFAULT NULL COMMENT 'app_name',
`content` longtext COLLATE utf8_bin NOT NULL COMMENT 'content',
`beta_ips` varchar(1024) COLLATE utf8_bin DEFAULT NULL COMMENT 'betaIps',
`md5` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT 'md5',
`gmt_create` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '创建时间',
`gmt_modified` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '修改时间',
`src_user` text COLLATE utf8_bin COMMENT 'source user',
`src_ip` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT 'source ip',
`tenant_id` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT '租户字段',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_configinfobeta_datagrouptenant` (`data_id`,`group_id`,`tenant_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_info_beta';
/*Data for the table `config_info_beta` */
/*Table structure for table `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) COLLATE utf8_bin NOT NULL COMMENT 'data_id',
`group_id` varchar(128) COLLATE utf8_bin NOT NULL COMMENT 'group_id',
`tenant_id` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT 'tenant_id',
`tag_id` varchar(128) COLLATE utf8_bin NOT NULL COMMENT 'tag_id',
`app_name` varchar(128) COLLATE utf8_bin DEFAULT NULL COMMENT 'app_name',
`content` longtext COLLATE utf8_bin NOT NULL COMMENT 'content',
`md5` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT 'md5',
`gmt_create` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '创建时间',
`gmt_modified` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '修改时间',
`src_user` text COLLATE utf8_bin COMMENT 'source user',
`src_ip` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT 'source ip',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_configinfotag_datagrouptenanttag` (`data_id`,`group_id`,`tenant_id`,`tag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_info_tag';
/*Data for the table `config_info_tag` */
/*Table structure for table `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) COLLATE utf8_bin NOT NULL COMMENT 'tag_name',
`tag_type` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT 'tag_type',
`data_id` varchar(255) COLLATE utf8_bin NOT NULL COMMENT 'data_id',
`group_id` varchar(128) COLLATE utf8_bin NOT NULL COMMENT 'group_id',
`tenant_id` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT 'tenant_id',
`nid` bigint(20) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`nid`),
UNIQUE KEY `uk_configtagrelation_configidtag` (`id`,`tag_name`,`tag_type`),
KEY `idx_tenant_id` (`tenant_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_tag_relation';
/*Data for the table `config_tags_relation` */
/*Table structure for table `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) 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 NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '创建时间',
`gmt_modified` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '修改时间',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_group_id` (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='集群、各Group容量信息表';
/*Data for the table `group_capacity` */
/*Table structure for table `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) COLLATE utf8_bin NOT NULL,
`group_id` varchar(128) COLLATE utf8_bin NOT NULL,
`app_name` varchar(128) COLLATE utf8_bin DEFAULT NULL COMMENT 'app_name',
`content` longtext COLLATE utf8_bin NOT NULL,
`md5` varchar(32) COLLATE utf8_bin DEFAULT NULL,
`gmt_create` datetime NOT NULL DEFAULT '2010-05-05 00:00:00',
`gmt_modified` datetime NOT NULL DEFAULT '2010-05-05 00:00:00',
`src_user` text COLLATE utf8_bin,
`src_ip` varchar(20) COLLATE utf8_bin DEFAULT NULL,
`op_type` char(10) COLLATE utf8_bin DEFAULT NULL,
`tenant_id` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT '租户字段',
PRIMARY KEY (`nid`),
KEY `idx_gmt_create` (`gmt_create`),
KEY `idx_gmt_modified` (`gmt_modified`),
KEY `idx_did` (`data_id`)
) ENGINE=InnoDB AUTO_INCREMENT=365 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='多租户改造';
/*Data for the table `his_config_info` */
insert into `his_config_info`(`id`,`nid`,`data_id`,`group_id`,`app_name`,`content`,`md5`,`gmt_create`,`gmt_modified`,`src_user`,`src_ip`,`op_type`,`tenant_id`) values
(11,345,'ssmp-wx-api-user-dev.yaml','DEV_GROUP','','server:\n port: 9004\n\nspring:\n cloud:\n sentinel:\n transport:\n dashboard: localhost:8080\n port: 8719\n datasource:\n url: jdbc:mysql://127.0.0.1:3306/ssmp-wx-member?useUnicode=true&characterEncoding=utf-8\n username: root\n password: root\n type: com.alibaba.druid.pool.DruidDataSource\n\nsms:\n secretId: AKIDNVDg04Z0atv0rQh16uQm24oHYcPupLHw\n secretKey: ZS7VdqlSuGNEo84mDNbcNr5OTIqKbcMq\n appid: 1400489343\n sign: 贾志新个人使用\n\nseata:\n enabled: true # 开启 seata 事务\n application-id: ${spring.application.name}\n tx-service-group: my_test_tx_group\n enable-auto-data-source-proxy: true\n config:\n type: nacos\n nacos:\n serverAddr: ${spring.cloud.nacos.discovery.server-addr}\n group: SEATA_GROUP\n namespace: ${spring.cloud.nacos.discovery.namespace}\n username: \"nacos\"\n password: \"nacos\"\n registry:\n type: nacos\n nacos:\n application: seata-server # 与服务端配置一致，默认为 seata-server\n server-addr: ${spring.cloud.nacos.discovery.server-addr}\n group: SEATA_GROUP\n namespace: ${spring.cloud.nacos.discovery.namespace}\n username: \"nacos\"\n password: \"nacos\"\n','bc20bac3b3ed2ff0486b83de05581224','2010-05-05 00:00:00','2021-07-14 01:11:41',NULL,'0:0:0:0:0:0:0:1','U','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51'),
(13,346,'ssmp-wx-api-product-dev.yaml','DEV_GROUP','','server:\n port: 9003\n\nspring:\n cloud:\n sentinel:\n transport:\n dashboard: localhost:8080\n port: 8719\n datasource:\n url: jdbc:mysql://127.0.0.1:3306/ssmp-wx-product?useUnicode=true&characterEncoding=utf-8\n username: root\n password: root\n driver-class-name: com.mysql.jdbc.Driver\n\n\nseata:\n enabled: true # 开启 seata 事务\n application-id: ${spring.application.name}\n tx-service-group: my_test_tx_group\n enable-auto-data-source-proxy: true\n config:\n type: nacos\n nacos:\n serverAddr: ${spring.cloud.nacos.discovery.server-addr}\n group: SEATA_GROUP\n namespace: ${spring.cloud.nacos.discovery.namespace}\n username: \"nacos\"\n password: \"nacos\"\n registry:\n type: nacos\n nacos:\n application: seata-server # 与服务端配置一致，默认为 seata-server\n server-addr: ${spring.cloud.nacos.discovery.server-addr}\n group: SEATA_GROUP\n namespace: ${spring.cloud.nacos.discovery.namespace}\n username: \"nacos\"\n password: \"nacos\"\n','a52d2b286dd204e27d6ff2841b1d31a5','2010-05-05 00:00:00','2021-07-14 01:11:55',NULL,'0:0:0:0:0:0:0:1','U','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51'),
(18,347,'ssmp-wx-api-order-dev.yaml','DEV_GROUP','','server:\n port: 9002\n\n\nspring:\n cloud:\n sentinel:\n transport:\n dashboard: localhost:8080\n port: 8719\n datasource:\n url: jdbc:mysql://127.0.0.1:3306/ssmp-wx-order?useUnicode=true&characterEncoding=utf-8\n username: root\n password: root\n driver-class-name: com.mysql.jdbc.Driver\n\n\nseata:\n enabled: true # 开启 seata 事务\n application-id: ${spring.application.name}\n tx-service-group: my_test_tx_group\n enable-auto-data-source-proxy: true\n config:\n type: nacos\n nacos:\n serverAddr: ${spring.cloud.nacos.discovery.server-addr}\n group: SEATA_GROUP\n namespace: ${spring.cloud.nacos.discovery.namespace}\n username: \"nacos\"\n password: \"nacos\"\n registry:\n type: nacos\n nacos:\n application: seata-server # 与服务端配置一致，默认为 seata-server\n server-addr: ${spring.cloud.nacos.discovery.server-addr}\n group: SEATA_GROUP\n namespace: ${spring.cloud.nacos.discovery.namespace}\n username: \"nacos\"\n password: \"nacos\"\n','d2b52a1565d11c5c927367ed8c41646e','2010-05-05 00:00:00','2021-07-14 01:12:11',NULL,'0:0:0:0:0:0:0:1','U','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51'),
(29,348,'ssmp-wx-api-dev.yaml','DEV_GROUP','','server:\n port: 9001\n tomcat:\n #tomcat线程池大小设置\n max-threads: 1000\n #tomcat初始化线程数量\n min-spare-threads: 30\n #tomcat编码\n uri-encoding: UTF-8\n max-http-header-size: 8192\n\nspring:\n cloud:\n sentinel:\n transport:\n dashboard: localhost:8080\n port: 8719\n # thymeleaf\n thymeleaf:\n prefix: classpath:/static/\n check-template-location: true\n suffix: .html\n encoding: utf-8\n servlet:\n content-type: text/html\n mode: HTML5\n cache: false\n redis:\n database: 0\n host: 127.0.0.1\n port: 6379\n password:\n jedis:\n pool:\n max-active: 20\n max-wait: -1\n max-idle: 10\n min-idle: 0\n timeout: 1000\nwx:\n mp:\n useRedis: false\n redisConfig:\n host: 127.0.0.1\n port: 6379\n configs:\n - appId: wxb9c84ec2e5c72d28 # 第一个公众号的appid\n secret: 23571b6925227e41a79345ae294a0fc2 # 公众号的appsecret\n token: 111 # 接口配置里的Token值\n aesKey: fx3qMEfJQXQQpUtRdpLMDySLdiXLYpoqmxXllS0er8A # 接口配置里的EncodingAESKey值\nmanagement:\n endpoints:\n web:\n exposure:\n include: \'*\'\n\n\nfeign:\n client:\n config:\n default:\n connectTimeout: 50000\n readTimeout: 50000\n hystrix:\n enabled: true\n compression:\n request:\n enabled: true\n mime-types: text/xml,application/xml,application/json\n min-request-size: 20482\n response:\n enabled: true\n useGzipDecoder: true\n\nhystrix:\n command:\n default:\n execution:\n timeout:\n enabled: true\n isolation:\n thread:\n timeoutInMilliseconds: 600000\n\ncos:\n accessKeyId: AKIDNVDg04Z0atv0rQh16uQm24oHYcPupLHw\n accessKeySecret: ZS7VdqlSuGNEo84mDNbcNr5OTIqKbcMq\n bucketName: shop-admin-1300029934\n shopImages: https://shop-admin-1300029934.cos.ap-beijing.myqcloud.com\n\n\n\nseata:\n enabled: true # 开启 seata 事务\n application-id: ${spring.application.name}\n tx-service-group: my_test_tx_group\n enable-auto-data-source-proxy: true\n config:\n type: nacos\n nacos:\n serverAddr: ${spring.cloud.nacos.discovery.server-addr}\n group: SEATA_GROUP\n namespace: ${spring.cloud.nacos.discovery.namespace}\n username: \"nacos\"\n password: \"nacos\"\n registry:\n type: nacos\n nacos:\n application: seata-server # 与服务端配置一致，默认为 seata-server\n server-addr: ${spring.cloud.nacos.discovery.server-addr}\n group: SEATA_GROUP\n namespace: ${spring.cloud.nacos.discovery.namespace}\n username: \"nacos\"\n password: \"nacos\"\n','9a0c97586f9b893049cb4250722d7ddb','2010-05-05 00:00:00','2021-07-14 01:12:25',NULL,'0:0:0:0:0:0:0:1','U','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51'),
(11,349,'ssmp-wx-api-user-dev.yaml','DEV_GROUP','','server:\n port: 9004\n\nspring:\n cloud:\n sentinel:\n transport:\n dashboard: localhost:8080\n port: 8719\n zipkin:\n base-url: http://127.0.0.1:9411\n sleuth:\n sampler:\n probability: 1\n datasource:\n url: jdbc:mysql://127.0.0.1:3306/ssmp-wx-member?useUnicode=true&characterEncoding=utf-8\n username: root\n password: root\n type: com.alibaba.druid.pool.DruidDataSource\n\nsms:\n secretId: AKIDNVDg04Z0atv0rQh16uQm24oHYcPupLHw\n secretKey: ZS7VdqlSuGNEo84mDNbcNr5OTIqKbcMq\n appid: 1400489343\n sign: 贾志新个人使用\n\nseata:\n enabled: true # 开启 seata 事务\n application-id: ${spring.application.name}\n tx-service-group: my_test_tx_group\n enable-auto-data-source-proxy: true\n config:\n type: nacos\n nacos:\n serverAddr: ${spring.cloud.nacos.discovery.server-addr}\n group: SEATA_GROUP\n namespace: ${spring.cloud.nacos.discovery.namespace}\n username: \"nacos\"\n password: \"nacos\"\n registry:\n type: nacos\n nacos:\n application: seata-server # 与服务端配置一致，默认为 seata-server\n server-addr: ${spring.cloud.nacos.discovery.server-addr}\n group: SEATA_GROUP\n namespace: ${spring.cloud.nacos.discovery.namespace}\n username: \"nacos\"\n password: \"nacos\"\n','d5712871444839d767a64480c155f5f8','2010-05-05 00:00:00','2021-08-04 06:42:36',NULL,'127.0.0.1','U','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51'),
(13,350,'ssmp-wx-api-product-dev.yaml','DEV_GROUP','','server:\n port: 9003\n\nspring:\n cloud:\n sentinel:\n transport:\n dashboard: localhost:8080\n port: 8719\n zipkin:\n base-url: http://127.0.0.1:9411\n sleuth:\n sampler:\n probability: 1\n datasource:\n url: jdbc:mysql://127.0.0.1:3306/ssmp-wx-product?useUnicode=true&characterEncoding=utf-8\n username: root\n password: root\n driver-class-name: com.mysql.jdbc.Driver\n\n\nseata:\n enabled: true # 开启 seata 事务\n application-id: ${spring.application.name}\n tx-service-group: my_test_tx_group\n enable-auto-data-source-proxy: true\n config:\n type: nacos\n nacos:\n serverAddr: ${spring.cloud.nacos.discovery.server-addr}\n group: SEATA_GROUP\n namespace: ${spring.cloud.nacos.discovery.namespace}\n username: \"nacos\"\n password: \"nacos\"\n registry:\n type: nacos\n nacos:\n application: seata-server # 与服务端配置一致，默认为 seata-server\n server-addr: ${spring.cloud.nacos.discovery.server-addr}\n group: SEATA_GROUP\n namespace: ${spring.cloud.nacos.discovery.namespace}\n username: \"nacos\"\n password: \"nacos\"\n','1aaf2427c20aabe6cb4736556465e03e','2010-05-05 00:00:00','2021-08-04 06:42:52',NULL,'127.0.0.1','U','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51'),
(18,351,'ssmp-wx-api-order-dev.yaml','DEV_GROUP','','server:\n port: 9002\n\n\nspring:\n cloud:\n sentinel:\n transport:\n dashboard: localhost:8080\n port: 8719\n zipkin:\n base-url: http://127.0.0.1:9411\n sleuth:\n sampler:\n probability: 1\n datasource:\n url: jdbc:mysql://127.0.0.1:3306/ssmp-wx-order?useUnicode=true&characterEncoding=utf-8\n username: root\n password: root\n driver-class-name: com.mysql.jdbc.Driver\n\n\nseata:\n enabled: true # 开启 seata 事务\n application-id: ${spring.application.name}\n tx-service-group: my_test_tx_group\n enable-auto-data-source-proxy: true\n config:\n type: nacos\n nacos:\n serverAddr: ${spring.cloud.nacos.discovery.server-addr}\n group: SEATA_GROUP\n namespace: ${spring.cloud.nacos.discovery.namespace}\n username: \"nacos\"\n password: \"nacos\"\n registry:\n type: nacos\n nacos:\n application: seata-server # 与服务端配置一致，默认为 seata-server\n server-addr: ${spring.cloud.nacos.discovery.server-addr}\n group: SEATA_GROUP\n namespace: ${spring.cloud.nacos.discovery.namespace}\n username: \"nacos\"\n password: \"nacos\"\n','c3e194c1028420173048beaea6e7e1c7','2010-05-05 00:00:00','2021-08-04 06:43:00',NULL,'127.0.0.1','U','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51'),
(29,352,'ssmp-wx-api-dev.yaml','DEV_GROUP','','server:\n port: 9001\n tomcat:\n #tomcat线程池大小设置\n max-threads: 1000\n #tomcat初始化线程数量\n min-spare-threads: 30\n #tomcat编码\n uri-encoding: UTF-8\n max-http-header-size: 8192\n\nspring:\n cloud:\n sentinel:\n transport:\n dashboard: localhost:8080\n port: 8719\n zipkin:\n base-url: http://127.0.0.1:9411\n sleuth:\n sampler:\n probability: 1\n # thymeleaf\n thymeleaf:\n prefix: classpath:/static/\n check-template-location: true\n suffix: .html\n encoding: utf-8\n servlet:\n content-type: text/html\n mode: HTML5\n cache: false\n redis:\n database: 0\n host: 127.0.0.1\n port: 6379\n password:\n jedis:\n pool:\n max-active: 20\n max-wait: -1\n max-idle: 10\n min-idle: 0\n timeout: 1000\nwx:\n mp:\n useRedis: false\n redisConfig:\n host: 127.0.0.1\n port: 6379\n configs:\n - appId: wxb9c84ec2e5c72d28 # 第一个公众号的appid\n secret: 23571b6925227e41a79345ae294a0fc2 # 公众号的appsecret\n token: 111 # 接口配置里的Token值\n aesKey: fx3qMEfJQXQQpUtRdpLMDySLdiXLYpoqmxXllS0er8A # 接口配置里的EncodingAESKey值\nmanagement:\n endpoints:\n web:\n exposure:\n include: \'*\'\n\n\nfeign:\n client:\n config:\n default:\n connectTimeout: 50000\n readTimeout: 50000\n hystrix:\n enabled: true\n compression:\n request:\n enabled: true\n mime-types: text/xml,application/xml,application/json\n min-request-size: 20482\n response:\n enabled: true\n useGzipDecoder: true\n\nhystrix:\n command:\n default:\n execution:\n timeout:\n enabled: true\n isolation:\n thread:\n timeoutInMilliseconds: 600000\n\ncos:\n accessKeyId: AKIDNVDg04Z0atv0rQh16uQm24oHYcPupLHw\n accessKeySecret: ZS7VdqlSuGNEo84mDNbcNr5OTIqKbcMq\n bucketName: shop-admin-1300029934\n shopImages: https://shop-admin-1300029934.cos.ap-beijing.myqcloud.com\n\n\n\nseata:\n enabled: true # 开启 seata 事务\n application-id: ${spring.application.name}\n tx-service-group: my_test_tx_group\n enable-auto-data-source-proxy: true\n config:\n type: nacos\n nacos:\n serverAddr: ${spring.cloud.nacos.discovery.server-addr}\n group: SEATA_GROUP\n namespace: ${spring.cloud.nacos.discovery.namespace}\n username: \"nacos\"\n password: \"nacos\"\n registry:\n type: nacos\n nacos:\n application: seata-server # 与服务端配置一致，默认为 seata-server\n server-addr: ${spring.cloud.nacos.discovery.server-addr}\n group: SEATA_GROUP\n namespace: ${spring.cloud.nacos.discovery.namespace}\n username: \"nacos\"\n password: \"nacos\"\n','35892cd804ed803aafb7ba07c55a00f7','2010-05-05 00:00:00','2021-08-04 06:43:12',NULL,'127.0.0.1','U','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51'),
(256,353,'service.default.grouplist','SEATA_GROUP','','127.0.0.1:8091','c32ce0d3e264525dcdada751f98143a3','2010-05-05 00:00:00','2021-08-04 07:17:03',NULL,'127.0.0.1','U','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51'),
(256,354,'service.default.grouplist','SEATA_GROUP','','127.0.0.1:18091','ca0e4162b22643ef7710c2ff884efd56','2010-05-05 00:00:00','2021-08-04 07:30:11',NULL,'127.0.0.1','U','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51'),
(29,355,'ssmp-wx-api-dev.yaml','DEV_GROUP','','server:\n port: 9001\n tomcat:\n #tomcat线程池大小设置\n max-threads: 1000\n #tomcat初始化线程数量\n min-spare-threads: 30\n #tomcat编码\n uri-encoding: UTF-8\n max-http-header-size: 8192\n\nspring:\n cloud:\n sentinel:\n transport:\n dashboard: 121.5.245.165:8080\n port: 8719\n zipkin:\n base-url: http://127.0.0.1:9411\n sleuth:\n sampler:\n probability: 1\n # thymeleaf\n thymeleaf:\n prefix: classpath:/static/\n check-template-location: true\n suffix: .html\n encoding: utf-8\n servlet:\n content-type: text/html\n mode: HTML5\n cache: false\n redis:\n database: 0\n host: 127.0.0.1\n port: 6379\n password:\n jedis:\n pool:\n max-active: 20\n max-wait: -1\n max-idle: 10\n min-idle: 0\n timeout: 1000\nwx:\n mp:\n useRedis: false\n redisConfig:\n host: 127.0.0.1\n port: 6379\n configs:\n - appId: wxb9c84ec2e5c72d28 # 第一个公众号的appid\n secret: 23571b6925227e41a79345ae294a0fc2 # 公众号的appsecret\n token: 111 # 接口配置里的Token值\n aesKey: fx3qMEfJQXQQpUtRdpLMDySLdiXLYpoqmxXllS0er8A # 接口配置里的EncodingAESKey值\nmanagement:\n endpoints:\n web:\n exposure:\n include: \'*\'\n\n\nfeign:\n client:\n config:\n default:\n connectTimeout: 50000\n readTimeout: 50000\n hystrix:\n enabled: true\n compression:\n request:\n enabled: true\n mime-types: text/xml,application/xml,application/json\n min-request-size: 20482\n response:\n enabled: true\n useGzipDecoder: true\n\nhystrix:\n command:\n default:\n execution:\n timeout:\n enabled: true\n isolation:\n thread:\n timeoutInMilliseconds: 600000\n\ncos:\n accessKeyId: AKIDNVDg04Z0atv0rQh16uQm24oHYcPupLHw\n accessKeySecret: ZS7VdqlSuGNEo84mDNbcNr5OTIqKbcMq\n bucketName: shop-admin-1300029934\n shopImages: https://shop-admin-1300029934.cos.ap-beijing.myqcloud.com\n\n\n\nseata:\n enabled: true # 开启 seata 事务\n application-id: ${spring.application.name}\n tx-service-group: my_test_tx_group\n enable-auto-data-source-proxy: true\n config:\n type: nacos\n nacos:\n serverAddr: ${spring.cloud.nacos.discovery.server-addr}\n group: SEATA_GROUP\n namespace: ${spring.cloud.nacos.discovery.namespace}\n username: \"nacos\"\n password: \"nacos\"\n registry:\n type: nacos\n nacos:\n application: seata-server # 与服务端配置一致，默认为 seata-server\n server-addr: ${spring.cloud.nacos.discovery.server-addr}\n group: SEATA_GROUP\n namespace: ${spring.cloud.nacos.discovery.namespace}\n username: \"nacos\"\n password: \"nacos\"\n','eff596bf252906e508cec937124ff888','2010-05-05 00:00:00','2021-08-05 01:13:26',NULL,'127.0.0.1','U','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51'),
(11,356,'ssmp-wx-api-user-dev.yaml','DEV_GROUP','','server:\n port: 9004\n\nspring:\n cloud:\n sentinel:\n transport:\n dashboard: 121.5.245.165:8080\n port: 8719\n zipkin:\n base-url: http://127.0.0.1:9411\n sleuth:\n sampler:\n probability: 1\n datasource:\n url: jdbc:mysql://127.0.0.1:3306/ssmp-wx-member?useUnicode=true&characterEncoding=utf-8\n username: root\n password: root\n type: com.alibaba.druid.pool.DruidDataSource\n\nsms:\n secretId: AKIDNVDg04Z0atv0rQh16uQm24oHYcPupLHw\n secretKey: ZS7VdqlSuGNEo84mDNbcNr5OTIqKbcMq\n appid: 1400489343\n sign: 贾志新个人使用\n\nseata:\n enabled: true # 开启 seata 事务\n application-id: ${spring.application.name}\n tx-service-group: my_test_tx_group\n enable-auto-data-source-proxy: true\n config:\n type: nacos\n nacos:\n serverAddr: ${spring.cloud.nacos.discovery.server-addr}\n group: SEATA_GROUP\n namespace: ${spring.cloud.nacos.discovery.namespace}\n username: \"nacos\"\n password: \"nacos\"\n registry:\n type: nacos\n nacos:\n application: seata-server # 与服务端配置一致，默认为 seata-server\n server-addr: ${spring.cloud.nacos.discovery.server-addr}\n group: SEATA_GROUP\n namespace: ${spring.cloud.nacos.discovery.namespace}\n username: \"nacos\"\n password: \"nacos\"\n','f2670c33715204ab687693122b53997e','2010-05-05 00:00:00','2021-08-05 02:13:16',NULL,'127.0.0.1','U','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51'),
(13,357,'ssmp-wx-api-product-dev.yaml','DEV_GROUP','','server:\n port: 9003\n\nspring:\n cloud:\n sentinel:\n transport:\n dashboard: 121.5.245.165:8080\n port: 8719\n zipkin:\n base-url: http://127.0.0.1:9411\n sleuth:\n sampler:\n probability: 1\n datasource:\n url: jdbc:mysql://127.0.0.1:3306/ssmp-wx-product?useUnicode=true&characterEncoding=utf-8\n username: root\n password: root\n driver-class-name: com.mysql.jdbc.Driver\n\n\nseata:\n enabled: true # 开启 seata 事务\n application-id: ${spring.application.name}\n tx-service-group: my_test_tx_group\n enable-auto-data-source-proxy: true\n config:\n type: nacos\n nacos:\n serverAddr: ${spring.cloud.nacos.discovery.server-addr}\n group: SEATA_GROUP\n namespace: ${spring.cloud.nacos.discovery.namespace}\n username: \"nacos\"\n password: \"nacos\"\n registry:\n type: nacos\n nacos:\n application: seata-server # 与服务端配置一致，默认为 seata-server\n server-addr: ${spring.cloud.nacos.discovery.server-addr}\n group: SEATA_GROUP\n namespace: ${spring.cloud.nacos.discovery.namespace}\n username: \"nacos\"\n password: \"nacos\"\n','2986863096012f998487fc4c751b14a5','2010-05-05 00:00:00','2021-08-05 02:13:28',NULL,'127.0.0.1','U','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51'),
(18,358,'ssmp-wx-api-order-dev.yaml','DEV_GROUP','','server:\n port: 9002\n\n\nspring:\n cloud:\n sentinel:\n transport:\n dashboard: 121.5.245.165:8080\n port: 8719\n zipkin:\n base-url: http://127.0.0.1:9411\n sleuth:\n sampler:\n probability: 1\n datasource:\n url: jdbc:mysql://127.0.0.1:3306/ssmp-wx-order?useUnicode=true&characterEncoding=utf-8\n username: root\n password: root\n driver-class-name: com.mysql.jdbc.Driver\n\n\nseata:\n enabled: true # 开启 seata 事务\n application-id: ${spring.application.name}\n tx-service-group: my_test_tx_group\n enable-auto-data-source-proxy: true\n config:\n type: nacos\n nacos:\n serverAddr: ${spring.cloud.nacos.discovery.server-addr}\n group: SEATA_GROUP\n namespace: ${spring.cloud.nacos.discovery.namespace}\n username: \"nacos\"\n password: \"nacos\"\n registry:\n type: nacos\n nacos:\n application: seata-server # 与服务端配置一致，默认为 seata-server\n server-addr: ${spring.cloud.nacos.discovery.server-addr}\n group: SEATA_GROUP\n namespace: ${spring.cloud.nacos.discovery.namespace}\n username: \"nacos\"\n password: \"nacos\"\n','924d2581d54d92e18f96c574d8888a9b','2010-05-05 00:00:00','2021-08-05 02:13:40',NULL,'127.0.0.1','U','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51'),
(283,359,'store.db.url','SEATA_GROUP','','jdbc:mysql://bj-cynosdbmysql-grp-pfuiyndq.sql.tencentcdb.com:26503/seata?useUnicode=true&useSSL=false&characterEncoding=utf8&serverTimezone=Asia/Shanghai\n\n','eadf70277fc60da041ba95e864345f13','2010-05-05 00:00:00','2021-08-06 00:35:50',NULL,'127.0.0.1','U','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51'),
(285,360,'store.db.password','SEATA_GROUP','','Abc~123123','8adae2835a45d07dfbf6ed62e1e4906d','2010-05-05 00:00:00','2021-08-06 00:36:07',NULL,'127.0.0.1','U','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51'),
(11,361,'ssmp-wx-api-user-dev.yaml','DEV_GROUP','','server:\n port: 9004\n\nspring:\n cloud:\n sentinel:\n transport:\n dashboard: 121.5.245.165:8080\n port: 8719\n datasource:\n url: jdbc:mysql://127.0.0.1:3306/ssmp-wx-member?useUnicode=true&characterEncoding=utf-8\n username: root\n password: root\n type: com.alibaba.druid.pool.DruidDataSource\n\nsms:\n secretId: AKIDNVDg04Z0atv0rQh16uQm24oHYcPupLHw\n secretKey: ZS7VdqlSuGNEo84mDNbcNr5OTIqKbcMq\n appid: 1400489343\n sign: 贾志新个人使用\n\nseata:\n enabled: true # 开启 seata 事务\n application-id: ${spring.application.name}\n tx-service-group: my_test_tx_group\n enable-auto-data-source-proxy: true\n config:\n type: nacos\n nacos:\n serverAddr: ${spring.cloud.nacos.discovery.server-addr}\n group: SEATA_GROUP\n namespace: ${spring.cloud.nacos.discovery.namespace}\n username: \"nacos\"\n password: \"nacos\"\n registry:\n type: nacos\n nacos:\n application: seata-server # 与服务端配置一致，默认为 seata-server\n server-addr: ${spring.cloud.nacos.discovery.server-addr}\n group: SEATA_GROUP\n namespace: ${spring.cloud.nacos.discovery.namespace}\n username: \"nacos\"\n password: \"nacos\"\n','6e3972011c541336c302e623771974f2','2010-05-05 00:00:00','2021-08-06 00:48:30',NULL,'127.0.0.1','U','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51'),
(13,362,'ssmp-wx-api-product-dev.yaml','DEV_GROUP','','server:\n port: 9003\n\nspring:\n cloud:\n sentinel:\n transport:\n dashboard: 121.5.245.165:8080\n port: 8719\n datasource:\n url: jdbc:mysql://127.0.0.1:3306/ssmp-wx-product?useUnicode=true&characterEncoding=utf-8\n username: root\n password: root\n driver-class-name: com.mysql.jdbc.Driver\n\n\nseata:\n enabled: true # 开启 seata 事务\n application-id: ${spring.application.name}\n tx-service-group: my_test_tx_group\n enable-auto-data-source-proxy: true\n config:\n type: nacos\n nacos:\n serverAddr: ${spring.cloud.nacos.discovery.server-addr}\n group: SEATA_GROUP\n namespace: ${spring.cloud.nacos.discovery.namespace}\n username: \"nacos\"\n password: \"nacos\"\n registry:\n type: nacos\n nacos:\n application: seata-server # 与服务端配置一致，默认为 seata-server\n server-addr: ${spring.cloud.nacos.discovery.server-addr}\n group: SEATA_GROUP\n namespace: ${spring.cloud.nacos.discovery.namespace}\n username: \"nacos\"\n password: \"nacos\"\n','c8a64033858c1336e810e0196b8eda1b','2010-05-05 00:00:00','2021-08-06 00:48:41',NULL,'127.0.0.1','U','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51'),
(18,363,'ssmp-wx-api-order-dev.yaml','DEV_GROUP','','server:\n port: 9002\n\n\nspring:\n cloud:\n sentinel:\n transport:\n dashboard: 121.5.245.165:8080\n port: 8719\n datasource:\n url: jdbc:mysql://127.0.0.1:3306/ssmp-wx-order?useUnicode=true&characterEncoding=utf-8\n username: root\n password: root\n driver-class-name: com.mysql.jdbc.Driver\n\n\nseata:\n enabled: true # 开启 seata 事务\n application-id: ${spring.application.name}\n tx-service-group: my_test_tx_group\n enable-auto-data-source-proxy: true\n config:\n type: nacos\n nacos:\n serverAddr: ${spring.cloud.nacos.discovery.server-addr}\n group: SEATA_GROUP\n namespace: ${spring.cloud.nacos.discovery.namespace}\n username: \"nacos\"\n password: \"nacos\"\n registry:\n type: nacos\n nacos:\n application: seata-server # 与服务端配置一致，默认为 seata-server\n server-addr: ${spring.cloud.nacos.discovery.server-addr}\n group: SEATA_GROUP\n namespace: ${spring.cloud.nacos.discovery.namespace}\n username: \"nacos\"\n password: \"nacos\"\n','bc5dd367005b56f38bebd826ae952531','2010-05-05 00:00:00','2021-08-06 00:48:51',NULL,'127.0.0.1','U','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51'),
(29,364,'ssmp-wx-api-dev.yaml','DEV_GROUP','','server:\n port: 9001\n tomcat:\n #tomcat线程池大小设置\n max-threads: 1000\n #tomcat初始化线程数量\n min-spare-threads: 30\n #tomcat编码\n uri-encoding: UTF-8\n max-http-header-size: 8192\n\nspring:\n cloud:\n sentinel:\n transport:\n dashboard: 121.5.245.165:8080\n port: 8719\n # thymeleaf\n thymeleaf:\n prefix: classpath:/static/\n check-template-location: true\n suffix: .html\n encoding: utf-8\n servlet:\n content-type: text/html\n mode: HTML5\n cache: false\n redis:\n database: 0\n host: 127.0.0.1\n port: 6379\n password:\n jedis:\n pool:\n max-active: 20\n max-wait: -1\n max-idle: 10\n min-idle: 0\n timeout: 1000\nwx:\n mp:\n useRedis: false\n redisConfig:\n host: 127.0.0.1\n port: 6379\n configs:\n - appId: wxb9c84ec2e5c72d28 # 第一个公众号的appid\n secret: 23571b6925227e41a79345ae294a0fc2 # 公众号的appsecret\n token: 111 # 接口配置里的Token值\n aesKey: fx3qMEfJQXQQpUtRdpLMDySLdiXLYpoqmxXllS0er8A # 接口配置里的EncodingAESKey值\nmanagement:\n endpoints:\n web:\n exposure:\n include: \'*\'\n\n\nfeign:\n client:\n config:\n default:\n connectTimeout: 50000\n readTimeout: 50000\n hystrix:\n enabled: true\n compression:\n request:\n enabled: true\n mime-types: text/xml,application/xml,application/json\n min-request-size: 20482\n response:\n enabled: true\n useGzipDecoder: true\n\nhystrix:\n command:\n default:\n execution:\n timeout:\n enabled: true\n isolation:\n thread:\n timeoutInMilliseconds: 600000\n\ncos:\n accessKeyId: AKIDNVDg04Z0atv0rQh16uQm24oHYcPupLHw\n accessKeySecret: ZS7VdqlSuGNEo84mDNbcNr5OTIqKbcMq\n bucketName: shop-admin-1300029934\n shopImages: https://shop-admin-1300029934.cos.ap-beijing.myqcloud.com\n\n\n\nseata:\n enabled: true # 开启 seata 事务\n application-id: ${spring.application.name}\n tx-service-group: my_test_tx_group\n enable-auto-data-source-proxy: true\n config:\n type: nacos\n nacos:\n serverAddr: ${spring.cloud.nacos.discovery.server-addr}\n group: SEATA_GROUP\n namespace: ${spring.cloud.nacos.discovery.namespace}\n username: \"nacos\"\n password: \"nacos\"\n registry:\n type: nacos\n nacos:\n application: seata-server # 与服务端配置一致，默认为 seata-server\n server-addr: ${spring.cloud.nacos.discovery.server-addr}\n group: SEATA_GROUP\n namespace: ${spring.cloud.nacos.discovery.namespace}\n username: \"nacos\"\n password: \"nacos\"\n','01f6c9f3b371931dcbba15a53c96db77','2010-05-05 00:00:00','2021-08-06 00:49:04',NULL,'127.0.0.1','U','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51');
/*Table structure for table `roles` */
DROP TABLE IF EXISTS `roles`;
CREATE TABLE `roles` (
`username` varchar(50) NOT NULL,
`role` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*Data for the table `roles` */
insert into `roles`(`username`,`role`) values
('nacos','ROLE_ADMIN');
/*Table structure for table `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) 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 NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '创建时间',
`gmt_modified` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '修改时间',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_tenant_id` (`tenant_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='租户容量信息表';
/*Data for the table `tenant_capacity` */
/*Table structure for table `tenant_info` */
DROP TABLE IF EXISTS `tenant_info`;
CREATE TABLE `tenant_info` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
`kp` varchar(128) COLLATE utf8_bin NOT NULL COMMENT 'kp',
`tenant_id` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT 'tenant_id',
`tenant_name` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT 'tenant_name',
`tenant_desc` varchar(256) COLLATE utf8_bin DEFAULT NULL COMMENT 'tenant_desc',
`create_source` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT 'create_source',
`gmt_create` bigint(20) NOT NULL COMMENT '创建时间',
`gmt_modified` bigint(20) NOT NULL COMMENT '修改时间',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_tenant_info_kptenantid` (`kp`,`tenant_id`),
KEY `idx_tenant_id` (`tenant_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='tenant_info';
/*Data for the table `tenant_info` */
insert into `tenant_info`(`id`,`kp`,`tenant_id`,`tenant_name`,`tenant_desc`,`create_source`,`gmt_create`,`gmt_modified`) values
(1,'1','4b2b8c70-f969-4fb4-acb1-1aa48ff00f51','dev','测试环境','nacos',1619842350119,1619842350119);
/*Table structure for table `users` */
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`username` varchar(50) NOT NULL,
`password` varchar(500) NOT NULL,
`enabled` tinyint(1) NOT NULL,
PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*Data for the table `users` */
insert into `users`(`username`,`password`,`enabled`) values
('nacos','$2a$10$EuWPZHzz32dJN7jexM34MOeYirDdFAZm2kuWj7VEOJhhZkDrxfvUu',1);
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
Loading...
举报
请认真填写举报原因，尽可能描述详细。
请选择举报类型
误判申诉
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化