1 Star 1 Fork 0

duckula / duckula-ops

Create your Gitee Account
Explore and code with more than 6 million developers,Free private repositories !:)
Sign up
Clone or download
duckula.sql 77.91 KB
Copy Edit Web IDE Raw Blame History
偏锋书生 authored 2021-07-07 11:41 . 支持新的租户
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678
/*
Navicat Premium Data Transfer
Source Server : local80
Source Server Type : MySQL
Source Server Version : 80016
Source Host : localhost:3306
Source Schema : duckula
Target Server Type : MySQL
Target Server Version : 80016
File Encoding : 65001
Date: 04/07/2021 20:54:42
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for common_checkpoint
-- ----------------------------
DROP TABLE IF EXISTS `common_checkpoint`;
CREATE TABLE `common_checkpoint` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'checkpointName',
`checkpoint_type` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '检查点类型',
`host` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '检查点主机',
`port` int(255) NULL DEFAULT 3306 COMMENT '端口',
`default_db` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '检查点使用的数据库,不填为tams',
`username` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '登陆用户名',
`password` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '登陆密码',
`user_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '所属用户',
`com_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '所属公司',
`remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '备注',
`tenant_id` bigint(20) NOT NULL COMMENT '租户id',
`create_by` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '创建者',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_by` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '更新者',
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1344625760717586439 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of common_checkpoint
-- ----------------------------
INSERT INTO `common_checkpoint` VALUES (1344625760717586434, 'localhost_56', 'Mysql', 'docker.for.win.localhost', 3307, 'tams', 'root', 'mysql', NULL, NULL, '', 0, NULL, NULL, NULL, NULL);
-- ----------------------------
-- Table structure for common_consumer
-- ----------------------------
DROP TABLE IF EXISTS `common_consumer`;
CREATE TABLE `common_consumer` (
`id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
`name` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'consumer名称',
`topic` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '监听的topic,只能监听一个',
`rule` varchar(2000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '规则',
`version_id` bigint(255) NULL DEFAULT NULL COMMENT 'duckula监听的版本',
`deploy_id` bigint(20) NULL DEFAULT NULL COMMENT '部署ID配置',
`user_id` bigint(11) NULL DEFAULT NULL COMMENT '用户id',
`middleware_kafka_id` bigint(20) NULL DEFAULT NULL COMMENT '要监听的kafka配置',
`middleware_id` bigint(20) NULL DEFAULT NULL COMMENT '目的中间件配置',
`instance_id` bigint(20) NULL DEFAULT NULL COMMENT '幂等时的反查实例',
`group_id` int(11) NULL DEFAULT NULL COMMENT '组id,监听组',
`attr_config` varchar(2000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '附加的配置',
`tenant_id` bigint(20) NOT NULL COMMENT '租户id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1344920682272215042 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of common_consumer
-- ----------------------------
INSERT INTO `common_consumer` VALUES (1344920682272215041, 'localhost_56_es', 'demo', 'test`user_info``{\'index\':\'demo\'}`&test`user_addr``{\'index\':\'demo\'}`', 2, 1344624860489924609, NULL, 1344626763013636097, 1344916023692316673, 1344625457763008514, NULL, '{\'common.es.auto.create.index_join.demo\': \'db:test|tb:user_info|db1:test|tb1:user_addr|rela1:user_id|shardsNum:12\'}', 0);
-- ----------------------------
-- Table structure for common_deploy
-- ----------------------------
DROP TABLE IF EXISTS `common_deploy`;
CREATE TABLE `common_deploy` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(60) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
`deploy` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '部署类型: k8s/docker/host',
`env` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '环境:开发/测试/预发/演示/生产',
`namespace` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '名称空间',
`url` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
`token` varchar(2000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
`config` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT 'config配置文件',
`user_id` bigint(20) NULL DEFAULT NULL COMMENT 'user表用户id',
`host` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '用户名,deploy为host才启作用',
`port` int(255) NULL DEFAULT 22 COMMENT 'SSH端口',
`pwd_duckula` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'duckula启动程序用密码,不保留root密码',
`hostsconfig` varchar(2000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '需要配置的config,对于\"host\"类型启作用',
`is_init` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '是否初始化,yes:已初始化 no:未初始化 创建duckula用户,创建环境变量创建目录',
`docker_login` varchar(1000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'docker类型需要的登陆脚本',
`is_default` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '是否默认值,yes:是默认某个用户环境的部署机器 no:不是',
`version_id` bigint(255) NULL DEFAULT NULL COMMENT '当前的版本,host和docker模式需要升级',
`remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '备注',
`tenant_id` bigint(20) NOT NULL COMMENT '租户id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1344624860489924610 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '部署相关配置,默认为:k8s环境配置' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of common_deploy
-- ----------------------------
INSERT INTO `common_deploy` VALUES (1344624860489924609, 'localhost-k8s', 'k8s', 'dev', 'default', NULL, NULL, 'apiVersion: v1\nclusters:\n- cluster:\n server: https://rd.xforceplus.com/k8s/clusters/c-d2xss\n name: aws-crc-mocklocal\n- cluster:\n certificate-authority-data: LS0tLS1CRUdJTiBDRVJUSUZJQ0FURS0tLS0tCk1JSUMvekNDQW1pZ0F3SUJBZ0lEQ2V5Qk1BMEdDU3FHU0liM0RRRUJDd1VBTUdJeEN6QUpCZ05WQkFZVEFrTk8KTVJFd0R3WURWUVFJREFoYWFHVkthV0Z1WnpFUk1BOEdBMVVFQnd3SVNHRnVaMXBvYjNVeEVEQU9CZ05WQkFvTQpCMEZzYVdKaFltRXhEREFLQmdOVkJBc01BMEZEVXpFTk1Bc0dBMVVFQXd3RWNtOXZkREFlRncweE9EQTVNVE14Ck16RTRNREJhRncwek9EQTVNRGd4TXpJek5EbGFNR294S2pBb0JnTlZCQW9USVdNNU9HUmlNemd6Tm1NMU5UUTAKWVRVeFlUSmhNMk14TTJNME1EQTVNbVppTlRFUU1BNEdBMVVFQ3hNSFpHVm1ZWFZzZERFcU1DZ0dBMVVFQXhNaApZems0WkdJek9ETTJZelUxTkRSaE5URmhNbUV6WXpFell6UXdNRGt5Wm1JMU1JR2ZNQTBHQ1NxR1NJYjNEUUVCCkFRVUFBNEdOQURDQmlRS0JnUURDODFwekticWpQU0RnMkEyRE9VVkRpc1RDL05WanZzNjlWOHhyOWoxekdubTUKRVc4eGh0ZmtVRFhiMDdUN25mT2lHbVRCaUQxVERYT3VLT3laakhxVXVBaStNK04wSkxPMzBOWHd0RmljOFljOQpLYjNhaUc5SnYxYU9BM1JJU2xqUkpZalRRN1BtTlRFVHdBRTVDdFkzMTZpcmF2WnRBUElHd2xWR0JWT1Nxd0lECkFRQUJvNEc2TUlHM01BNEdBMVVkRHdFQi93UUVBd0lDckRBUEJnTlZIUk1CQWY4RUJUQURBUUgvTUI4R0ExVWQKSXdRWU1CYUFGSVZhLzkwanpTVnZXRUZ2bm0xRk9adFlmWFgvTUR3R0NDc0dBUVVGQndFQkJEQXdMakFzQmdncgpCZ0VGQlFjd0FZWWdhSFIwY0RvdkwyTmxjblJ6TG1GamN5NWhiR2w1ZFc0dVkyOXRMMjlqYzNBd05RWURWUjBmCkJDNHdMREFxb0NpZ0pvWWthSFIwY0RvdkwyTmxjblJ6TG1GamN5NWhiR2w1ZFc0dVkyOXRMM0p2YjNRdVkzSnMKTUEwR0NTcUdTSWIzRFFFQkN3VUFBNEdCQUllMm9SdWNZUXFHY1QvY01jVjZlcUEwUnNKVHlpTW1tSGhiZ0JMNApwRmFPbFMrNTdQYWNUZUY0NXNFdkg2cUFXWE1vZEE0bFdHWjZCYTdYK1JpVTFPbHhKaGoxRGo2Y3JrWlp2VEhnCmc2Z2oxKzczQTREWmFzTWxnNmlzRm94bDJsd2VIbFlJQkMvTG5rRk9aUE5oS1RMR0tjWlBySXpUVGx1TkZ5eEwKQ1lYaAotLS0tLUVORCBDRVJUSUZJQ0FURS0tLS0tCg==\n server: https://114.55.184.142:6443\n name: dev\n- cluster:\n certificate-authority-data: LS0tLS1CRUdJTiBDRVJUSUZJQ0FURS0tLS0tCk1JSUN5RENDQWJDZ0F3SUJBZ0lCQURBTkJna3Foa2lHOXcwQkFRc0ZBREFWTVJNd0VRWURWUVFERXdwcmRXSmwKY201bGRHVnpNQjRYRFRJd01EUXhNREUyTURFeU1Wb1hEVE13TURRd09ERTJNREV5TVZvd0ZURVRNQkVHQTFVRQpBeE1LYTNWaVpYSnVaWFJsY3pDQ0FTSXdEUVlKS29aSWh2Y05BUUVCQlFBRGdnRVBBRENDQVFvQ2dnRUJBTkN5CnI3TGhFa1Z1djh4RmV5M3NRU3dYb2p3bGQwSjdEUXhobXhrK2lNTHNaNEN5MWtOUXhMcnJsdUF6TWZOYlE4ZnoKQTVqZ1JDNEs3NjJXenZrZTg1OG5wT3prdld0ZlRtM2FMdnoxNmpKZkd1eFdETmpDaFEzVHMxNHlTUUszZFRyKwpETDVyY2lDclJha2kzbWNqSWtVKzZwcFcxb3I2Q2tHeVREQWJuMFZhaTBlOUpCK2R5YjdxVW1uTVN6TzlaYkVBCnJoMmV2ZmlsUlR1c0x6ZGNzN3BGbHVSR3RRVllmcFVGQjZpYzRieUlvWWJXZk9PdHJZNm0zTis2cHF5UzRqQksKbXlJMzIwZkZEeUlQVThBTEUzYWVqeVdQK1BFOEovZUdiekVhZlFabFFHWjcxQVlMVHNDVFVpeS9CbmxVamNHaAozVklxZkxtK1k3ZC8wL1JXaEpVQ0F3RUFBYU1qTUNFd0RnWURWUjBQQVFIL0JBUURBZ0trTUE4R0ExVWRFd0VCCi93UUZNQU1CQWY4d0RRWUpLb1pJaHZjTkFRRUxCUUFEZ2dFQkFLVjRNMFM5aklRUDlKM3d0QXVXVEp5eXVmU1AKa3U3Qjgvb1F5bWNUVk1QSENKV2pOVmN2Z3IrajgrelhGSFpjOTduNXFHci9TLzJTcWVOWXdoeHFzVmxoWXN5QwpRYXYxNE1iMEhPUEZCQ1h0YUZtN0pzbFVjdytPVGtPaVRIOXAveXpiK0hMTXlQcFM4WGxuYkZBK09ITDZYQUtxCnFDcjFrYWR4N2oxbnI3R2p3SFBNMDBubXRXakhPSUh6VHM1QVlqY0J6TXpnbXZZTDEzQkp1N2h5U2FlbVhrZVEKMzZwZkVZYjIxcldwZThVYW9SbndRTzE5anIzYllrVkttdksySnRsOXJWTS9YY2lCM1RncElzaG1hdWgvS2gyawpEVnEwUGZjZlEvZlFobGk3SEhvdC8rMkJRT2VNUGhQUGh1WG5GY2ZFUTdtRnA1QWhOZ0RERU13L3AzVT0KLS0tLS1FTkQgQ0VSVElGSUNBVEUtLS0tLQo=\n server: https://kubernetes.docker.internal:6443\n name: docker-desktop\n- cluster:\n certificate-authority-data: LS0tLS1CRUdJTiBDRVJUSUZJQ0FURS0tLS0tCk1JSURHakNDQWdLZ0F3SUJBZ0lCQURBTkJna3Foa2lHOXcwQkFRc0ZBREErTVNjd0ZBWURWUVFLRXcxaGJHbGkKWVdKaElHTnNiM1ZrTUE4R0ExVUVDaE1JYUdGdVozcG9iM1V4RXpBUkJnTlZCQU1UQ210MVltVnlibVYwWlhNdwpIaGNOTWpBeE1ESTRNRGt4TmpBMldoY05NekF4TURJMk1Ea3hOakEyV2pBK01TY3dGQVlEVlFRS0V3MWhiR2xpCllXSmhJR05zYjNWa01BOEdBMVVFQ2hNSWFHRnVaM3BvYjNVeEV6QVJCZ05WQkFNVENtdDFZbVZ5Ym1WMFpYTXcKZ2dFaU1BMEdDU3FHU0liM0RRRUJBUVVBQTRJQkR3QXdnZ0VLQW9JQkFRQ1VEWnB1Y01IdkM3SVZDNlAxZkI1awpabTJxOHlySU1LSEo3Y1F0WmFNZnJoblRybEFhOENSTmlRTStzUU15c1E4TUhRcExCM1c1aDZhNGs5T3ovNXBPCmx3UlJOMVd2eHpEVk5qRzZwMllJaGxkZ2grQXBVaDZHZ1dxclRFTGUzdmNYVERzMCtBa3RFME01Mm9xNTJIRGwKSlFUWkNXdlNxcmZuc3I2MmdFZFk3MUpmQ1VDWmdwMVJaZDlGbCt0dUFRcDUvamx6Nk1oRG1ONTVJOG51eWQvUwppckpBRm5Tak5sWmdWWTZWbTZRcEdxY3hyUkJ1RTA4Ukg4Q0hQcHNQOE1INmhqcjdDQVUzM1VONmFUMlZFOFZBCklEeWZyK29yN3BlMEJoamQwR0NyQUFLWDRXL0dva3pjemNSZ1VSbythb0tkNCtyK0grWGI4dE1saHp6YUxUTGQKQWdNQkFBR2pJekFoTUE0R0ExVWREd0VCL3dRRUF3SUNwREFQQmdOVkhSTUJBZjhFQlRBREFRSC9NQTBHQ1NxRwpTSWIzRFFFQkN3VUFBNElCQVFCb21lalZYWGtsa0NuZGlMamxuL29vVDA4cDlOZlhQUXVseDlwL2RURGIwa0c2CkZqOVpIV2RORzJvRUN0czdqZW9aNmNRTEFSTmQ3WGJOU1lMUkpRVFRQQ0NvTURhWlkra0JmbERYbzB0bGxXVEIKUndvTmszaUc5VWNMbTVLd0JabHgxamo2NS9IYWI2SUFIUFZtSjc3NG1SRkhRNkIvTWt4ZEordUJyWVVLZ0psTwpTTzRhdTBGRjN0R3BtbHpwVmhIazVVV2x4ajI0S29lMXY1dloxT2xpTG9nNmxkNVY5LzNEZ25kRHNnSEtvQklqCkx2ZHhFMjlwZ3VrZ3lyM0Jqd3FNemdnbVliaHNMWUdDUEh4OVQ2QmNybmpYbDNzOHZwbWJ2V3JJdU5wS3l3TE8KZlZTOHVtVEhaeE5mUDc1T2crUjJ2ODEyY01Eb244eGlUUm5xWVp6egotLS0tLUVORCBDRVJUSUZJQ0FURS0tLS0tCg==\n server: https://10.66.239.150:6443\n name: kubernetes\n- cluster:\n certificate-authority-data: LS0tLS1CRUdJTiBDRVJUSUZJQ0FURS0tLS0tCk1JSUMvekNDQW1pZ0F3SUJBZ0lEQzlpbE1BMEdDU3FHU0liM0RRRUJDd1VBTUdJeEN6QUpCZ05WQkFZVEFrTk8KTVJFd0R3WURWUVFJREFoYWFHVkthV0Z1WnpFUk1BOEdBMVVFQnd3SVNHRnVaMXBvYjNVeEVEQU9CZ05WQkFvTQpCMEZzYVdKaFltRXhEREFLQmdOVkJBc01BMEZEVXpFTk1Bc0dBMVVFQXd3RWNtOXZkREFlRncweE9ERXhNVGd4Ck5qRTRNREJhRncwek9ERXhNVE14TmpJek5UZGFNR294S2pBb0JnTlZCQW9USVdNMll6a3hZekEyWlRobVpEUTAKTUdWalltSmxOelF4WVRjMk9UZGpNalppTWpFUU1BNEdBMVVFQ3hNSFpHVm1ZWFZzZERFcU1DZ0dBMVVFQXhNaApZelpqT1RGak1EWmxPR1prTkRRd1pXTmlZbVUzTkRGaE56WTVOMk15Tm1JeU1JR2ZNQTBHQ1NxR1NJYjNEUUVCCkFRVUFBNEdOQURDQmlRS0JnUUMzaDZJd2hPZjhwSG9mTENiMU5CZHNPbEVTWU5MMVdld0ZmYVUvYkRUdlNvYkkKU0F4cHdORUhzNzhnRWxzdkZnTzRZc213ZE1ucGticFREZEd1ZWFxODRtdkhWQVFBTGQ4Syt3c3RhdWh6UXJVbQpWYVZiYU5XSG82NGcwb0VsOFgzYnJ3LzF6bmNmcnIwUTBkQm9HSG5zdjlCTlYrOUpHY1J0aEQxOFlkcXpRd0lECkFRQUJvNEc2TUlHM01BNEdBMVVkRHdFQi93UUVBd0lDckRBUEJnTlZIUk1CQWY4RUJUQURBUUgvTUI4R0ExVWQKSXdRWU1CYUFGSVZhLzkwanpTVnZXRUZ2bm0xRk9adFlmWFgvTUR3R0NDc0dBUVVGQndFQkJEQXdMakFzQmdncgpCZ0VGQlFjd0FZWWdhSFIwY0RvdkwyTmxjblJ6TG1GamN5NWhiR2w1ZFc0dVkyOXRMMjlqYzNBd05RWURWUjBmCkJDNHdMREFxb0NpZ0pvWWthSFIwY0RvdkwyTmxjblJ6TG1GamN5NWhiR2w1ZFc0dVkyOXRMM0p2YjNRdVkzSnMKTUEwR0NTcUdTSWIzRFFFQkN3VUFBNEdCQUcrS0JCZXNIRnVIYldZaDFqSWp5UTNGNENQZUFJZWowdHJYcHpCMQpDZU5pc3pxaXRTc2FtVC9LODFVTXppU1ZKdm5iNDNCdm9QZmhidU1HZ2tCWWU5WGc4MmlEYXNnRTdyTnlzSGYxCmpnYzg5L2NsaDBkV284QStzVFFaUndNSms5bllNYktiSzZvQ21peW9oK2ROZm1LUU56T0JHcXdlOVdjbzRSVWsKL1d6bAotLS0tLUVORCBDRVJUSUZJQ0FURS0tLS0tCg==\n server: https://47.110.187.176:6443\n name: prod\n- cluster:\n certificate-authority-data: LS0tLS1CRUdJTiBDRVJUSUZJQ0FURS0tLS0tCk1JSUMvekNDQW1pZ0F3SUJBZ0lEQ29mME1BMEdDU3FHU0liM0RRRUJDd1VBTUdJeEN6QUpCZ05WQkFZVEFrTk8KTVJFd0R3WURWUVFJREFoYWFHVkthV0Z1WnpFUk1BOEdBMVVFQnd3SVNHRnVaMXBvYjNVeEVEQU9CZ05WQkFvTQpCMEZzYVdKaFltRXhEREFLQmdOVkJBc01BMEZEVXpFTk1Bc0dBMVVFQXd3RWNtOXZkREFlRncweE9EQTVNall4Ck1EQXhNREJhRncwek9EQTVNakV4TURBMk1EaGFNR294S2pBb0JnTlZCQW9USVdNd1pHTTJOak0xWkRjNU1UazAKTnpoak9EZ3pabVZtTnpjMllXWXlOMlV6TmpFUU1BNEdBMVVFQ3hNSFpHVm1ZWFZzZERFcU1DZ0dBMVVFQXhNaApZekJrWXpZMk16VmtOemt4T1RRM09HTTRPRE5tWldZM056WmhaakkzWlRNMk1JR2ZNQTBHQ1NxR1NJYjNEUUVCCkFRVUFBNEdOQURDQmlRS0JnUUNTdi9peFJ3bEYzL3d0RHlRU0R5MVp0ZVN1WUpxMEVndHdKSUlkUDVBcmM1YXcKbHY5bkpyNU1aYzdaVTdTdURlZzNtZG8reDBGN3BOT1dhb2dFWFo3QWZMUjlYMi9QVXZnZkFtc29sRFc0bzZVego5Q080cnd5N3lRd0x6VlhrcEpDeVovaGp5MnBZaXdhUzBycFN1a2Z4QS9kM1Q0Q0dvR2Vtc3lYd3l5Mmh4UUlECkFRQUJvNEc2TUlHM01BNEdBMVVkRHdFQi93UUVBd0lDckRBUEJnTlZIUk1CQWY4RUJUQURBUUgvTUI4R0ExVWQKSXdRWU1CYUFGSVZhLzkwanpTVnZXRUZ2bm0xRk9adFlmWFgvTUR3R0NDc0dBUVVGQndFQkJEQXdMakFzQmdncgpCZ0VGQlFjd0FZWWdhSFIwY0RvdkwyTmxjblJ6TG1GamN5NWhiR2w1ZFc0dVkyOXRMMjlqYzNBd05RWURWUjBmCkJDNHdMREFxb0NpZ0pvWWthSFIwY0RvdkwyTmxjblJ6TG1GamN5NWhiR2w1ZFc0dVkyOXRMM0p2YjNRdVkzSnMKTUEwR0NTcUdTSWIzRFFFQkN3VUFBNEdCQUJoYW45VU1EK2wza01idUFSQWpteFgrNUhpNVEyY1N1QlY0OFRmNAp6TmtKUHltb0dzM2V5SUVpRmx3YldhQ1BrL2FMc1BQUDU1VXNIdzJZWktLZFY2LzVWMlN5bnRqSENZTGw0UlJzClJqRXN4L3NsNC9MbEkza0YzYXJmUlFGNW9pbEs2NUtMUUgxRmZ5UFA3MnlSbWNicFMyM1BSSFJSaUN1anJRNm0KZ2FkegotLS0tLUVORCBDRVJUSUZJQ0FURS0tLS0tCg==\n server: https://118.31.183.131:6443\n name: test\ncontexts:\n- context:\n cluster: aws-crc-mocklocal\n namespace: 94-crc-uat\n user: aws-crc-mocklocal\n name: aws-crc-mocklocal\n- context:\n cluster: dev\n user: kubernetes-admin\n name: dev\n- context:\n cluster: docker-desktop\n user: docker-desktop\n name: docker-desktop\n- context:\n cluster: docker-desktop\n user: docker-desktop\n name: docker-for-desktop\n- context:\n cluster: prod\n namespace: 81-prd\n user: \"221629722743134755\"\n name: prod\n- context:\n cluster: kubernetes\n namespace: gvp365\n user: \"284620986777284200\"\n name: taimei-test\n- context:\n cluster: test\n namespace: 35-flink-stream-dev\n user: \"249813537433882980\"\n name: test\ncurrent-context: docker-desktop\nkind: Config\npreferences: {}\nusers:\n- name: \"221629722743134755\"\n user:\n client-certificate-data: LS0tLS1CRUdJTiBDRVJUSUZJQ0FURS0tLS0tCk1JSUN6VENDQWphZ0F3SUJBZ0lERG92Uk1BMEdDU3FHU0liM0RRRUJDd1VBTUdveEtqQW9CZ05WQkFvVElXTTIKWXpreFl6QTJaVGhtWkRRME1HVmpZbUpsTnpReFlUYzJPVGRqTWpaaU1qRVFNQTRHQTFVRUN4TUhaR1ZtWVhWcwpkREVxTUNnR0ExVUVBeE1oWXpaak9URmpNRFpsT0daa05EUXdaV05pWW1VM05ERmhOelk1TjJNeU5tSXlNQjRYCkRURTVNRFF3TXpBM05EY3dNRm9YRFRJeU1EUXdNakEzTlRJd01Gb3dQekVWTUJNR0ExVUVDaE1NYzNsemRHVnQKT25WelpYSnpNUWt3QndZRFZRUUxFd0F4R3pBWkJnTlZCQU1URWpJeU1UWXlPVGN5TWpjME16RXpORGMxTlRDQgpuekFOQmdrcWhraUc5dzBCQVFFRkFBT0JqUUF3Z1lrQ2dZRUFuL0lkTllvZXdpMkZiMUN0cXh5Tzd5M1doTUw0ClRvSzZoSXpwMWRKaWhHNksydkduK05VWmRteG4wOVhwZkhjZDhZclBDWlFGZ24rUk5IYityUzFWanFYZXI3OUkKUGdCUDVSdjd1MkxaQ0Q3OHAvZEZmT3ZKNlZuSUxLN0lGY2tzR2hjRFY0TDdyeS8vS21RYlhLcGVqQ3lacEljQwpVelpBTk1XV1Zxa21SN01DQXdFQUFhT0JxekNCcURBT0JnTlZIUThCQWY4RUJBTUNCNEF3RXdZRFZSMGxCQXd3CkNnWUlLd1lCQlFVSEF3SXdEQVlEVlIwVEFRSC9CQUl3QURBOEJnZ3JCZ0VGQlFjQkFRUXdNQzR3TEFZSUt3WUIKQlFVSE1BR0dJR2gwZEhBNkx5OWpaWEowY3k1aFkzTXVZV3hwZVhWdUxtTnZiUzl2WTNOd01EVUdBMVVkSHdRdQpNQ3d3S3FBb29DYUdKR2gwZEhBNkx5OWpaWEowY3k1aFkzTXVZV3hwZVhWdUxtTnZiUzl5YjI5MExtTnliREFOCkJna3Foa2lHOXcwQkFRc0ZBQU9CZ1FDdEwySk9ZeE5EVkpGUEE1a1ZsT2RVOXQ5RG9OM3ZKK2ttM1ZDdU1BUWsKM01qK2tVeWVKbjNDdVhxSWl6Z0tCZ1ZnN293OWlPT0lQYWdRTzRGR05RVGd6UlUvb1JRMzF4VEpOc0JXY0hpRgpsZ0ppbGg1UE9YdUhKb0hESTZlZlpMYmNpOVhiMmh6TjE2MmlqKzZNa0l6bjlhQUlCemZ4VmVnRGJwb2FSbHh2CnVBPT0KLS0tLS1FTkQgQ0VSVElGSUNBVEUtLS0tLQo=\n client-key-data: LS0tLS1CRUdJTiBSU0EgUFJJVkFURSBLRVktLS0tLQpNSUlDWFFJQkFBS0JnUUNmOGgwMWloN0NMWVZ2VUsyckhJN3ZMZGFFd3ZoT2dycUVqT25WMG1LRWJvcmE4YWY0CjFSbDJiR2ZUMWVsOGR4M3hpczhKbEFXQ2Y1RTBkdjZ0TFZXT3BkNnZ2MGcrQUUvbEcvdTdZdGtJUHZ5bjkwVjgKNjhucFdjZ3Nyc2dWeVN3YUZ3TlhndnV2TC84cVpCdGNxbDZNTEpta2h3SlROa0EweFpaV3FTWkhzd0lEQVFBQgpBb0dCQUl1aXRPdHI5T1J6RjE0U0lqd1RoNW01KytFVjBlL0E0NU1hN241VTJOdGpJbWg0dHJ0ZlY0WnlwOFpoCnB5Q1pZWlBoS2xUalhGZ01oTGszOWFrOHZjYVV4QmtYT0tjRkFxYXJNdUJEZUt5TWpScUFCOEozcEpDeHQxb3UKTCtXZTh0LzllZm5GVTdOMnBIMGlaNFoxd2drTnZBc0FZTDF5TnlHSnBJYWVQS0J4QWtFQXdRSlVQdU5sWmtsWQpJQ1AwNko3WmhKSHM5SzRSc3Yxbk04Z1I3dFR5TUhjeG80MlN3clR5V3ducFdma0k4Ym0vZk9LY0lsSTBsTmQ2CjZBYk1BVUFLYVFKQkFOUWxZa3JML040blRlMXFSYjZOQjQ4SDJ5YzhPWkJRQXpXMzllUmtuQVVYVktGYnF5Ym4KQTZqSWNLRVhYWkJHSUtxZ2tGT2lCWkhpamdXMmw3UkJwYnNDUVFDU3cxeWdQWFdiWStZWStuNStiRnZtakxmcwpEbmp5Ni9HUDFIQ2VkVnA4TkFhUTRWUlpyaElqMjlPUFVPaldObkkvV21selI2TW9Fdm9vZVJLaldMa1JBa0JDClNwaEhaU3pVUXBYd1RWZ1Q3ai9oYXdRSlk2RmRQaE55c3RSc2xSL0gyMzEvbW9TRitJUkZOclV6TVhqMFAyV3YKeTlLdHY2QmI4TjZPWEh0VlFYcEhBa0IrQ1JTS1d1KzFGRWE4UFNzaWh4NXAvV0Z3WGJxZ0JnMXpxYno2cXR0KwowcERLTjRqaXV4ODF4SyttcCtpOUtzWk5lbXJsdFI0cGZKZkhnNUI3WlJ0UQotLS0tLUVORCBSU0EgUFJJVkFURSBLRVktLS0tLQo=\n- name: \"249813537433882980\"\n user:\n client-certificate-data: LS0tLS1CRUdJTiBDRVJUSUZJQ0FURS0tLS0tCk1JSUN6VENDQWphZ0F3SUJBZ0lEQ3ppVU1BMEdDU3FHU0liM0RRRUJDd1VBTUdveEtqQW9CZ05WQkFvVElXTXcKWkdNMk5qTTFaRGM1TVRrME56aGpPRGd6Wm1WbU56YzJZV1l5TjJVek5qRVFNQTRHQTFVRUN4TUhaR1ZtWVhWcwpkREVxTUNnR0ExVUVBeE1oWXpCa1l6WTJNelZrTnpreE9UUTNPR000T0RObVpXWTNOelpoWmpJM1pUTTJNQjRYCkRURTRNVEF4TVRFeU5EVXdNRm9YRFRJeE1UQXhNREV5TlRBeE4xb3dQekVWTUJNR0ExVUVDaE1NYzNsemRHVnQKT25WelpYSnpNUWt3QndZRFZRUUxFd0F4R3pBWkJnTlZCQU1URWpJME9UZ3hNelV6TnpRek16ZzRNams0TURDQgpuekFOQmdrcWhraUc5dzBCQVFFRkFBT0JqUUF3Z1lrQ2dZRUF0eWIyNXBlZkV6ZG1weXBLeW04eXk4MjB6bjZnCmJpWEMzdDFCcit3SVU0K1p0cVBHb0hoQjRiZXJ3b0NBcEsvY2MzT1Rocm92SE8vNU1LQng1YW5DT1h6SXBza3kKOG5rTEJrVTRRa2sxNjRKWTNJTisrQ016eSs5OTVSSG5aQ3cvb0RiNlZTL1RpcWxsVlVucUZjZlFWUGNlNDZzUQo5NHRFQ1BpL3hMZlZXOVVDQXdFQUFhT0JxekNCcURBT0JnTlZIUThCQWY4RUJBTUNCNEF3RXdZRFZSMGxCQXd3CkNnWUlLd1lCQlFVSEF3SXdEQVlEVlIwVEFRSC9CQUl3QURBOEJnZ3JCZ0VGQlFjQkFRUXdNQzR3TEFZSUt3WUIKQlFVSE1BR0dJR2gwZEhBNkx5OWpaWEowY3k1aFkzTXVZV3hwZVhWdUxtTnZiUzl2WTNOd01EVUdBMVVkSHdRdQpNQ3d3S3FBb29DYUdKR2gwZEhBNkx5OWpaWEowY3k1aFkzTXVZV3hwZVhWdUxtTnZiUzl5YjI5MExtTnliREFOCkJna3Foa2lHOXcwQkFRc0ZBQU9CZ1FBbUY0MUhLd3JEakt0VXpQQytxQjU5TlY3eTEvdmY3K0FJRmc2MW1QRTUKNytUOW1TcTBvaGovVytyU3NBNktjMzQwdWsrUlAvakFrZlFDZlFIVEdMa3FnKzVkZjNFeGRuRnA5dEVJZEFnYQpHUVV2cHVFckg3MzBmMVVRNmdwKzF4V2pxZnZEUUtYSkFKVTdaR3kxQ2Q4Q1hRd0tKRXVkUml2M3dDTk1pbzBiCmN3PT0KLS0tLS1FTkQgQ0VSVElGSUNBVEUtLS0tLQo=\n client-key-data: LS0tLS1CRUdJTiBSU0EgUFJJVkFURSBLRVktLS0tLQpNSUlDWHdJQkFBS0JnUUMzSnZibWw1OFROMmFuS2tyS2J6TEx6YlRPZnFCdUpjTGUzVUd2N0FoVGo1bTJvOGFnCmVFSGh0NnZDZ0lDa3I5eHpjNU9HdWk4Yzcva3dvSEhscWNJNWZNaW15VEx5ZVFzR1JUaENTVFhyZ2xqY2czNzQKSXpQTDczM2xFZWRrTEQrZ052cFZMOU9LcVdWVlNlb1Z4OUJVOXg3anF4RDNpMFFJK0wvRXQ5VmIxUUlEQVFBQgpBb0dCQUtHcUN4WFBqK0p1YkhYeHBzSzVGS1ZBbGZBUFpaelVTQVpnVnJMcUxROVZHZUZVL3VaMlAvRDFKdTh3CmJsenZ2aTlLUFZZVzBhOUJRenZnNDZoTkI5b29BN3VCKzFEcEh0NEJQSmhQM2JTbmhpdnMyL1hHMllQOEV1UlkKSldXeU0rVERuaUYxYXlrWEdEdVYzNFpESjdvbWQvU3g0Ym5JNEd3NC80ckhIaGloQWtFQTBSeTEzOEZLdUh6YQo3TElLQ3ZtKzgwMnNXU25SUWc4OUpmTXkxdGd6ZGRBYmVEOWZwYUVUWFI0R2NmYWZlWWF6RHZWVkFhTWpLdFVoCnBuNlBMNjNaandKQkFPQTRIekdpMmxMWGtGbTNiRlkyTk5Ib1h5SEQvTVhRa2Fwa1drK3hFQnV1ZUVrSm1qZ3UKM0lwNTJnNlpoUmVyWkhSOXNrMzlYMy9jaGtacDFjN0htbHNDUVFDQ2h2VlA4Z3QrRlJGaVpjKzNBaVdiSVlUUApNemNYa1FPT1NMd1hOMlVIeVJzY2VCSndCSmRkckh4QmJyd2swMXU1bnBHdEwvT25yTm9RWHpkcGY0OHBBa0VBCmdmdm5FWlp3YlFBczNlWDQ5MDI3ZDBqNEJaSWg4dWZEMm4wTTRoQXEzM0ZZcURiWjRlSkExa0pueUhqMWNGQmIKRHpGamNkVUdUUkNpQXlZTjNpOVc2d0pCQU0rWkxiZFltQnlGWW9LUlRIeFVYR29ZS3BWdkxPSlh4azNKcitaeQptQmJtVXF0Z3RIK2EwT2YyVW1CdUl2SWxzWEhhZit5cW9mNkYyQklPT1ozckk3WT0KLS0tLS1FTkQgUlNBIFBSSVZBVEUgS0VZLS0tLS0K\n- name: \"284620986777284200\"\n user:\n client-certificate-data: LS0tLS1CRUdJTiBDRVJUSUZJQ0FURS0tLS0tCk1JSURYRENDQXNXZ0F3SUJBZ0lERzBaTE1BMEdDU3FHU0liM0RRRUJDd1VBTUdveEtqQW9CZ05WQkFvVElXTTEKT0RWaE5qSmpOakl6TnpFME5HSTVZbVl3WWpFME16SXhPV0l4WXpJeVlqRVFNQTRHQTFVRUN4TUhaR1ZtWVhWcwpkREVxTUNnR0ExVUVBeE1oWXpVNE5XRTJNbU0yTWpNM01UUTBZamxpWmpCaU1UUXpNakU1WWpGak1qSmlNQjRYCkRUSXdNVEF5T0RBNU1UY3dNRm9YRFRJek1UQXlPREE1TWpJeU1Wb3dTakVWTUJNR0ExVUVDaE1NYzNsemRHVnQKT25WelpYSnpNUWt3QndZRFZRUUxFd0F4SmpBa0JnTlZCQU1USFRJNE5EWXlNRGs0TmpjM056STROREl3TUMweApOakF6T0RjMk9UUXhNSUlCSWpBTkJna3Foa2lHOXcwQkFRRUZBQU9DQVE4QU1JSUJDZ0tDQVFFQTBKTnV4N3YwCnhGNnRiVGVlald4Vy9FUUpkMXJvTCszWE9BU3YxZ1JacjJkYVJ0QUZLMyswbFR6OEZ3a0JTYlZ0MHlZVFVTelcKRjN2WXNNcVRhSldLcjJxYmVOazAvaHdPUUwzNnplNTRqTzdST3VDSklHRjB4U2czTUZCdEN4aVMvZXpua0hwQgppdjkzVDU1cWtLZURnUGh4SnFRTnhTWmxaZEZZWXljTnJaK2UrOExJdE11bFpreURFM3ZwMGZ6OUtBWFpTWlI4CkF1NlZDOEhaenVybXk4M3QzM0U2ck5QU0srY0xucjVZallTdTRmWXZJaXg3bEwxZmd5ZC9wMFlkL1E5S0xLTXgKYnJ3RGlvK3p2NHVPb0gxbVYvVUVWZ2RuWDVwMklDdGRyTzMvb21TRXlRdDVUSEFXQzQzU25mODl3U3hsWGJ6eQpwSGdWWEplT2JhNkEyUUlEQVFBQm80R3JNSUdvTUE0R0ExVWREd0VCL3dRRUF3SUhnREFUQmdOVkhTVUVEREFLCkJnZ3JCZ0VGQlFjREFqQU1CZ05WSFJNQkFmOEVBakFBTUR3R0NDc0dBUVVGQndFQkJEQXdMakFzQmdnckJnRUYKQlFjd0FZWWdhSFIwY0RvdkwyTmxjblJ6TG1GamN5NWhiR2w1ZFc0dVkyOXRMMjlqYzNBd05RWURWUjBmQkM0dwpMREFxb0NpZ0pvWWthSFIwY0RvdkwyTmxjblJ6TG1GamN5NWhiR2w1ZFc0dVkyOXRMM0p2YjNRdVkzSnNNQTBHCkNTcUdTSWIzRFFFQkN3VUFBNEdCQUFsQUF0SW4wYlFhUnhUaTUybVV0ME1kKzFzNFlIcGRnTUovV0tWVElQcjUKOW55TWRPZVhWUzVxZGVzNnQvbXRJM3IwU0kwQ2wxaWNBR1NGOTJaNU9LVjErL1lBbG9WQVRTb1VvRkNGa0xHSQp0Uk1yME5kTFlOZVpCcmE2N2Y2Q2NiWVkxdGIwY2E5aDlYdmlMVWpUSDE5bVJEbEpCSGdiTE9ldTlycnh3U3RHCi0tLS0tRU5EIENFUlRJRklDQVRFLS0tLS0KLS0tLS1CRUdJTiBDRVJUSUZJQ0FURS0tLS0tCk1JSUMvekNDQW1pZ0F3SUJBZ0lERzBZY01BMEdDU3FHU0liM0RRRUJDd1VBTUdJeEN6QUpCZ05WQkFZVEFrTk8KTVJFd0R3WURWUVFJREFoYWFHVkthV0Z1WnpFUk1BOEdBMVVFQnd3SVNHRnVaMXBvYjNVeEVEQU9CZ05WQkFvTQpCMEZzYVdKaFltRXhEREFLQmdOVkJBc01BMEZEVXpFTk1Bc0dBMVVFQXd3RWNtOXZkREFlRncweU1ERXdNamd3Ck9UQTVNREJhRncwME1ERXdNak13T1RFME5EWmFNR294S2pBb0JnTlZCQW9USVdNMU9EVmhOakpqTmpJek56RTAKTkdJNVltWXdZakUwTXpJeE9XSXhZekl5WWpFUU1BNEdBMVVFQ3hNSFpHVm1ZWFZzZERFcU1DZ0dBMVVFQXhNaApZelU0TldFMk1tTTJNak0zTVRRMFlqbGlaakJpTVRRek1qRTVZakZqTWpKaU1JR2ZNQTBHQ1NxR1NJYjNEUUVCCkFRVUFBNEdOQURDQmlRS0JnUURhQmNwRjViUTFVYzNnVGphYzhlYnNXYytCN0MrSHdHemtUNGE4VGhEWW9SeUEKQ255dEM3MEJha0NXaWJMUmFQVGg3OTV2bDlNTE90Tjg0eUNPeGkwQVBxNHhxMmtwY05aeHh2Q1FSZWFEaUo5cQo5LzZxSmJTbDh0djdvNkpqV040bC9zeHZpYkxXSEJTVlFpc1IrOTRZYUdkbG5PZFByOS8rUlhvYzJmN2hBUUlECkFRQUJvNEc2TUlHM01BNEdBMVVkRHdFQi93UUVBd0lDckRBUEJnTlZIUk1CQWY4RUJUQURBUUgvTUI4R0ExVWQKSXdRWU1CYUFGSVZhLzkwanpTVnZXRUZ2bm0xRk9adFlmWFgvTUR3R0NDc0dBUVVGQndFQkJEQXdMakFzQmdncgpCZ0VGQlFjd0FZWWdhSFIwY0RvdkwyTmxjblJ6TG1GamN5NWhiR2w1ZFc0dVkyOXRMMjlqYzNBd05RWURWUjBmCkJDNHdMREFxb0NpZ0pvWWthSFIwY0RvdkwyTmxjblJ6TG1GamN5NWhiR2w1ZFc0dVkyOXRMM0p2YjNRdVkzSnMKTUEwR0NTcUdTSWIzRFFFQkN3VUFBNEdCQUwrMUpmQjZxUTI5Y25sN0s4OWprUWFmQkR4c0lSZzg4RXovTTQ0MQpkZkRtZEJ2L1FwY1RGM2FUTDhzMjVCc2pmcUc4bmFiSmVHeEdQOERBOTh3a01UVlBENHRsVm40REt0UENLOEFqCmJ5YVZOT052Y3h2Z1Bac1NIZTNCcndmUmdhVkprU2NPMFdRYmRBdEJUelFkR1drZVZKcVlOYmoyRFM0cWhyeXMKRkFweQotLS0tLUVORCBDRVJUSUZJQ0FURS0tLS0tCg==\n client-key-data: LS0tLS1CRUdJTiBSU0EgUFJJVkFURSBLRVktLS0tLQpNSUlFb3dJQkFBS0NBUUVBMEpOdXg3djB4RjZ0YlRlZWpXeFcvRVFKZDFyb0wrM1hPQVN2MWdSWnIyZGFSdEFGCkszKzBsVHo4RndrQlNiVnQweVlUVVN6V0YzdllzTXFUYUpXS3IycWJlTmswL2h3T1FMMzZ6ZTU0ak83Uk91Q0oKSUdGMHhTZzNNRkJ0Q3hpUy9lem5rSHBCaXY5M1Q1NXFrS2VEZ1BoeEpxUU54U1psWmRGWVl5Y05yWitlKzhMSQp0TXVsWmt5REUzdnAwZno5S0FYWlNaUjhBdTZWQzhIWnp1cm15ODN0MzNFNnJOUFNLK2NMbnI1WWpZU3U0Zll2CklpeDdsTDFmZ3lkL3AwWWQvUTlLTEtNeGJyd0Rpbyt6djR1T29IMW1WL1VFVmdkblg1cDJJQ3Rkck8zL29tU0UKeVF0NVRIQVdDNDNTbmY4OXdTeGxYYnp5cEhnVlhKZU9iYTZBMlFJREFRQUJBb0lCQUZsM0UrcUtuYWZwY0h4TApnaS9wUzdwek9KaEFueDJINkd2MzNyQnZOMFQ4a1FXVXp0TGt1VUhXWWM5RHBwREdTTEJzUVpidEkzdjVQRzVBCnhrL3k3UVRuTm43MHREMVhMV25wMDMybmozL3NKRVViOE5XNTE4dUZ2MzV5MFFNVWJHQ00wSnJ4UmRIb1dIWUgKWG5CajJnMWxBNnZ1YkpXbkxaRXA1YjdLRHB6czkxdXJPUTVVSU9za0ZvMEhZVTRxU211Z2FCMHlvOW1wTzErNwp4QXRRM1hwVXQ5NDdWVmtqdCtqaHg3bEtJN2xSbUxKa05DcUZUYkRTcEI1YzBWMU04MFNzakZTZU5zS2NZbjNxClRNTkFURWFXNklnK05zaGNFSWtpZnNuK0JveU9DMmc4SUVMNDh4dGNvcFEzNUx5bTlYWVZ1aE9Hd1VPRGQxLzEKSUtJYk1RRUNnWUVBOHN5OVJMdzBMekMzT2ZlYnhlT1htWU5pS1F3K3BEOHVDS1M3aGxvL21MVVVvKzVRMStmRgozT3ZNN3BtTk9tRnhSYVlqQytCSjNWU1RQQ2NMUWdtQ1pPbEI4VFVyVldjNjZXVGVCVzc5SWlaT0Z0T1dXMlpxCms1TlNlZ3d4bWMwVWx5ZHRxWURQaFg5NFkwT3ZSeWlXa1Q3aXplbDNYNE1XbGRhbnRuV0d2cmtDZ1lFQTIrcGUKbWEweDlLTE01MEY0QjJVUjRsR2ZzV1FCUFpwT2VoYk5VZG9xTHFhRWhjRnFGTjNDc3dlYlJOcERqTUJYQ2FZNApTbDFCZitEaS95YThkNmxody9qeXIyZ1BKWVc5cHVxdkp2UzVLQzE2R0J3MWdabERoTEhqdUZHL21yNDJiTVJlCmRhaXpPMTRvcnlPdDUrN0pWMDVFbVlLUDB2SzJFSUlMTWVmUnd5RUNnWUVBbE1ldTV4S29xNDRmaU03WXptOUQKTTFlVjYrOUw1MXVydXJJdkV3bjBWSUFKME5ZMUJjaEpyN0Z5bDNiU1dzYmhJVHZIMS93dFp3bnZXdm5WNVRacwpoNmVEdCtuTHp2NTkxQXp5RzhSQ0t3M3I1Z0xyN01BYWFLbnE3VXpSakJ4bUZLV2Roak9mZG4rQTV0clA2anZOCjM5ejRJQk9EQ2EwTFJ2QU5QenBQUWtrQ2dZQU5GSUdQN21jOFA3cWtQcGFmQ2Zub1ZpYURiSWxPV3JFMFBjcjAKaFY5ZzZ2S1M2aEFmTVpsMUFJelJxWkcrKzJteDN6c1Y0VG9XR3hBbFVPNkF4NGhUR2FtRm1WRGRVSGtaUm5nbwpmd0hNUy9ncEd2UnJ3dXZySnBGKzB3M3NiRWZjYkVtYUFmQzNKVUNTT2pNTHluNGJQVUtEUnVxN0IwaWc3cnN2CnVyUVZRUUtCZ0N1eUJVQmZ6WGxyNjFnM3c5a284c2Erd0Z3My9relZhcW1YQjlNUUVKc0tFbkduK0doaTJzeG0KbUlwbmRySFVEZjBjY0VBcjhrVFA2MlZ1VHFtQlA1b2RJdDBnNVVMRENGL1JsUnFLYTNpUjE5cXBRNjliY0RaRgpEcWQvTVRib1hoSG1tN2E5SU9BTjFMV1MzZDk2Ui83bnBCSjZOTEZiVTY4ZEdvOTdzUkxFCi0tLS0tRU5EIFJTQSBQUklWQVRFIEtFWS0tLS0tCg==\n- name: aws-crc-mocklocal\n user:\n token: kubeconfig-u-jxtxnwjm2i:c7lqwldgwg5kmg47lds9zbjn2vvks7pbz47hzqrxwhclzhpr2j2kkj\n- name: docker-desktop\n user:\n client-certificate-data: LS0tLS1CRUdJTiBDRVJUSUZJQ0FURS0tLS0tCk1JSUM5RENDQWR5Z0F3SUJBZ0lJYkhtUjh0T0dWSzB3RFFZSktvWklodmNOQVFFTEJRQXdGVEVUTUJFR0ExVUUKQXhNS2EzVmlaWEp1WlhSbGN6QWVGdzB5TURBME1UQXhOakF4TWpGYUZ3MHlNVEV5TXpFeE1qRTBORGhhTURZeApGekFWQmdOVkJBb1REbk41YzNSbGJUcHRZWE4wWlhKek1Sc3dHUVlEVlFRREV4SmtiMk5yWlhJdFptOXlMV1JsCmMydDBiM0F3Z2dFaU1BMEdDU3FHU0liM0RRRUJBUVVBQTRJQkR3QXdnZ0VLQW9JQkFRRGUxbWQrcEMrRW9GaWoKQk1rZTNlbWRDQ2ZzNVN4Lzk5SUYyRnpyUG41TG1XU0ZXbHNGdFdpR0xNTm5EZDgvSTdKcUpGcDRxTDZCL3lLVQpSYWhIUnA2YzVRcEZLWVJVUm8xNnkwVFpIem5iUitqSDdWNVlwY2QzUDc0VXhLODNoMHhFZFFtanFLaW14RzNYCkkvR2Zrbkk3c2h2RlFEbWlqckVrTEw2U2lJUmkzRVR0Rk9PajZsN1E0a2hvbUpOMStMekRtaElSRGltaXlaOVoKaXIyckxkeUxXOE5JZDJHU3A3eDFPYUU0MUlBYjlKMm9XcTJMSVhVYUZuRDNqMVBZRFNQeklMSmUxcmpWdUc1ago3N3FMdVNNdlF4QktIb3NVOTdZZmFtdHcyV1NYQ1pQVlFaZTVWVExCQTB6bjc1UmZOWWdHbGRaL2hUdGlIdGtjCmMvdTkvTXR6QWdNQkFBR2pKekFsTUE0R0ExVWREd0VCL3dRRUF3SUZvREFUQmdOVkhTVUVEREFLQmdnckJnRUYKQlFjREFqQU5CZ2txaGtpRzl3MEJBUXNGQUFPQ0FRRUFQVUxkTXVMVDZvWGxQd1BhdUM0dUl6RjUxL2lhbDlwSAp6NkJKMUFzMlIzandYS1BIeWJGdHNQQ2ZVVW50K2dvUkxTNGxvb1VPSHkvTXZ3NGZPVUNtSEZUdjhvTDVvSURRCklKZzhGN0poWlhNcFA5U1ZNd0IxQXVuODlqYmRMeUEvRWRsR2xYOXpTK1NIRUtoS1d2dS9adWNHVUhjdG5Yc0QKNzFDVm1nMkN5UUx3eUZZRWp0dXNQa2pmNUhrR0I5M0NQOFFnSTIrTTRxSWNqT0M2L0FHK3ZGU3hQRmwzTENNKwphQnlTTStuM3VGbXY0cGpFMHNwaVh1Ti9mUGU5dlJOMmhGTmFMR0xmSXYxWVFWbWxyWW1VaGVJWnI5N1pKNFpVCk5md1JKd2QybmVSTVo1eHcwZHJKbWFuS0xDVUtUK0F1V1p3N0hoRTVET1BWbnVEWjczQmtCUT09Ci0tLS0tRU5EIENFUlRJRklDQVRFLS0tLS0K\n client-key-data: LS0tLS1CRUdJTiBSU0EgUFJJVkFURSBLRVktLS0tLQpNSUlFb3dJQkFBS0NBUUVBM3RabmZxUXZoS0JZb3dUSkh0M3BuUWduN09Vc2YvZlNCZGhjNno1K1M1bGtoVnBiCkJiVm9oaXpEWnczZlB5T3lhaVJhZUtpK2dmOGlsRVdvUjBhZW5PVUtSU21FVkVhTmVzdEUyUjg1MjBmb3grMWUKV0tYSGR6KytGTVN2TjRkTVJIVUpvNmlvcHNSdDF5UHhuNUp5TzdJYnhVQTVvbzZ4SkN5K2tvaUVZdHhFN1JUagpvK3BlME9KSWFKaVRkZmk4dzVvU0VRNHBvc21mV1lxOXF5M2NpMXZEU0hkaGtxZThkVG1oT05TQUcvU2RxRnF0Cml5RjFHaFp3OTQ5VDJBMGo4eUN5WHRhNDFiaHVZKys2aTdrakwwTVFTaDZMRlBlMkgycHJjTmxrbHdtVDFVR1gKdVZVeXdRTk01KytVWHpXSUJwWFdmNFU3WWg3WkhIUDd2ZnpMY3dJREFRQUJBb0lCQUFqMHdSQWI5VFQxWk5xWQpkS1RpOG1LM1V6TjRPb09pS0RUSDcyUWRET0pvOWR0T09GNVFYalVXVTN3dTJJd25HU0tlOTJ2bURGSVpPUUNRCmxDVFpOOExDaWRraHhBbkhGQ1NkU3RVWEpqSWovNzBaVXpObzVrMXFxRzhaUUptUXZJWDcxamxYcS8rWDRYcEcKSFkzMlN0VVBZWUphQkhiK0dTeUZCOXZIMU5wTVFOeHZ3cXg4NWJMLys1dHQ5UmJiZDYwdkFmc2hjM0kvd3B3VApXMXBSdUVQZ3BIYUlhd01SVmRsdnBTaTA4b0Qvc3REYWE1UVZoeEQ0SDJTazZleEZVejg0ZVExYlVxWGNFWTRKCkpKMTdsbC9GdlA2UGI2MU1MelMvZU11Qk50SG1QT3p3dmFvbnl5V3pva1lydnZmcmNyMmNCekVSWXVzelVVamkKeG1xWkkyRUNnWUVBOU9PdjM4OXlHbVB2MVA5aTd0VHhsVkhCNFV3OXRsSUFLbVh5MFN6N1NqOEdmQlhSL0tkRQprYjdKM3hPSE9UcXNUTlQrUE55cEF4TndZaUlKQXhla0dYRlpCRElHVERnRmYvRzdadTdja3F4bFVneXdWWm8yCmg1dDRCTUZMbjl4ZEh0a0h1eUNMTk13SFdpaXhONHlZTDZyVUkwQ2Noc1VmWGFFb0FXbVM3bXNDZ1lFQTZQS1gKY2piZVRKbDl3MXZXN2RUZnBKQVorUGZNSGpTdHhYRDQrYjRMY2E1b1Mxd29jNHhOSE5ZcmVRWXd4NURKL0drYgozUmppUlhiaXEyNUhSK09xbUNoa1V6aWlqTVN6THNheFFCMGlLcmU2R01ybDdMV3FZK0V2RjZ3TjFZZzU0dVAxCjlzQk5FcHhGTzNidWpqcGZxWUhIMTY3US9naEYvdDBRa0tXMVNSa0NnWUVBdi9XcWExb0ZLMEtqUU9kZithN2EKSUI0U1NEU25PejlUK2Vnb1NtZGtJM0w3OWxCMFpnUUg3K2NKL3Q4ajVHeGxtMlJxVmZMeVdRTG4yVVNzbzh2bwpTamxiZWJwc3pWb3NsWG83V0Joc3RseUVuNmhxb085ZFJ6ZExBUTh6NUgrc1R2MzQzV3BKTkgycVZiWUlGRzhVCjdHaVFHWUlRTUdSY2pkeEJxN25CL3prQ2dZQUFvQ1luK0YzQWR1a1BqVCtXZyt2VjFVMDhqZTNPWnZYUWdlMHAKUG9scFZMNlM5VHhta3duaCtmRkQ4ZkJQbU9QeCtaWkprYmVKMkRmam5mZ3pDVGw4RHgrMTJZRVdQN0Q3ZnkwYQpydmxZaEFYTDZ6K1MweW9SK3BqVngzQ0NFa3VWZ0djNHNtdUNrVWplVUFOei9sUWpjR1hJL244eEwzU0FxcmRRCnJDRkFnUUtCZ0JaKy9YVGtlZmJRTW9uaHlRYkNqM0dhdUVkNkxaYm9teTk2K0FwbHFNVlNzNlZGUUh5NFRySnUKQW5nMjdUTnVTQThGU3FyRmxCUURTZk91RW1IM0pkVm9TUFV4dHlhVmordm9CK3hrMUVqMFpNNGUvYXdudmxGOQpVR2dsaG9wNVJsU0xMam1sMGNOT0o2VDVqUCtEWG5uNXFob1B0cXUzU2VQU0QvUnlpeEg1Ci0tLS0tRU5EIFJTQSBQUklWQVRFIEtFWS0tLS0tCg==\n- name: kubernetes-admin\n user:\n client-certificate-data: LS0tLS1CRUdJTiBDRVJUSUZJQ0FURS0tLS0tCk1JSUN4akNDQWkrZ0F3SUJBZ0lJWGp5OVI0RHNLM2d3RFFZSktvWklodmNOQVFFTEJRQXdhakVxTUNnR0ExVUUKQ2hNaFl6azRaR0l6T0RNMll6VTFORFJoTlRGaE1tRXpZekV6WXpRd01Ea3labUkxTVJBd0RnWURWUVFMRXdkawpaV1poZFd4ME1Tb3dLQVlEVlFRREV5RmpPVGhrWWpNNE16WmpOVFUwTkdFMU1XRXlZVE5qTVROak5EQXdPVEptCllqVXdIaGNOTVRnd09URXpNVE14T0RBd1doY05NVGt3T1RFek1UTXpNekUyV2pBME1SY3dGUVlEVlFRS0V3NXoKZVhOMFpXMDZiV0Z6ZEdWeWN6RVpNQmNHQTFVRUF4TVFhM1ZpWlhKdVpYUmxjeTFoWkcxcGJqQ0NBU0l3RFFZSgpLb1pJaHZjTkFRRUJCUUFEZ2dFUEFEQ0NBUW9DZ2dFQkFNbllMS21yM1FRS2YxTzBaQmlHNk4yWmVzMGZ0SzRyClhHRStKaGc0L1U2VEpXOEZ3b0U1TitsS2ZXVFhubDBKbkIwbTV1OVFzS0FnRWROSEJCL0JpanF2YVZrYUt5aDAKNXhMV2tJd2FacFd6S0Z5ZXo1YlZCZ0xsV2l4VThCNkNpemZNNkhlR0xUdHRxSTNHMHVHY2VndEduU3Bid29HZwpqYWFpSVlRQld4WExxZ3ExcWtmdm9PMExxTnZwUWpLWG8wclV0VVZtUXRvdmMvOVdaclA5b2RyM1U1SHFRYXY5ClVsaS85WFZZM1NOeEhBeWtOYi8rT2dWZHFBQStTTkxWWjBZaVNOY0l2b1duYmFvWlY3M3lLeG1CVjloUE9POFcKN0hvZFlMdzdSMTI5ZFdqbmZreTVlVnVzdW9pODN0RUZNeW1zS0NBTEdjUHVrSGFZdnZEOWd4RUNBd0VBQWFNbgpNQ1V3RGdZRFZSMFBBUUgvQkFRREFnV2dNQk1HQTFVZEpRUU1NQW9HQ0NzR0FRVUZCd01DTUEwR0NTcUdTSWIzCkRRRUJDd1VBQTRHQkFDQndNODlEdWE4dHhteHlRQXJOWVFjTitLdnNjclVBWlZwWXIwOGc3QkdYSjhyVFZQcWkKSVRncnpsU1A1OGZ1MEZsL2xUVXJMbkEyRVdNaEJxbEkrQTlveFZLcG9vRDRDMUVOek9TanZCWkVqWGV5ZHpFQwpNSzVOT21jZG15ZW5pSVFmVlp4WEdWTHRzS0Vqb3hUM2Z3ZFZ0bWs0NUQ0Q2pPV1F6dUlnVjl4ZwotLS0tLUVORCBDRVJUSUZJQ0FURS0tLS0tCg==\n client-key-data: LS0tLS1CRUdJTiBSU0EgUFJJVkFURSBLRVktLS0tLQpNSUlFb3dJQkFBS0NBUUVBeWRnc3FhdmRCQXAvVTdSa0dJYm8zWmw2elIrMHJpdGNZVDRtR0RqOVRwTWxid1hDCmdUazM2VXA5Wk5lZVhRbWNIU2JtNzFDd29DQVIwMGNFSDhHS09xOXBXUm9yS0hUbkV0YVFqQnBtbGJNb1hKN1AKbHRVR0F1VmFMRlR3SG9LTE44em9kNFl0TzIyb2pjYlM0Wng2QzBhZEtsdkNnYUNOcHFJaGhBRmJGY3VxQ3JXcQpSKytnN1F1bzIrbENNcGVqU3RTMVJXWkMyaTl6LzFabXMvMmgydmRUa2VwQnEvMVNXTC8xZFZqZEkzRWNES1ExCnYvNDZCVjJvQUQ1STB0Vm5SaUpJMXdpK2hhZHRxaGxYdmZJckdZRlgyRTg0N3hic2VoMWd2RHRIWGIxMWFPZCsKVExsNVc2eTZpTHplMFFVekthd29JQXNadys2UWRwaSs4UDJERVFJREFRQUJBb0lCQUIxK0lNaUovRGxpNzBmagp5OXhwbWcwSEtCSmcxNTI3YUR3dFFKTzVnQW5ESm0wYWdsa3ZheVFEWmw4ZHdsNEYwWEhSQlYxaWhPeGd3em9ECjNtNWxjVFV4L0Vxd3NDMnhKekp4ZDUyQkhnd3hxV3dmS0dYNXFtOHg1QU1tUmcrdk0zaHIwR3ZtaHlWdjJIa2UKM0NGckk4b1IvMVQ1STJxZGN4VXVDNGVtU3hEYjl3Vjd2d01zOWRqVDBQUnFBSlN0YVdyWDVVYURyRmhkSTRoYgpxcGx3QmtySmMwL1N6OWhzRG8xZ3MxcVRHMzlMQnNKWnl3OW1ucW9TUmtFa0Q5MFhDaHgyVzk2QmllRmIxSitQCmZiQmVEV0lnb25EN1hKK3d1blZlTWJTc0t4NGVUTXJOOTVMSjhWSS91MmFLbzNHZlM1UTUzOVQ2RmVVempQcXoKUWFES2tBRUNnWUVBNWYzTGtxNmlRQnNzdDlMdzFsVzA5RTQ4bzlwTE9zbmVFYUNnT09iR2hRZUtQOUpjSksvQwpqdHA2M2hpUllVK1JOYUhiTHdEbVZOYTk5d3BjMmpzVEliS1UxYlZBa3RPMkhBMDhvNEZHZjc1ckQ1Rm9YWURwCjNhMER2SXdvdDRIUlBncXNySkZPNjk3dEMzOHVvTVhyUUNpcThETS8xNHcvL1FLLzhBZkxZZUVDZ1lFQTRLdUgKem53Y0tVWDA3Qndqcy9pOTh2MXFGVTk5d3hjZlBDZU9HMFhFUmRBNWxmVzJ3Y3FDQWxVRGFncXg3MENQSENzSgpyd2RWOS92cGQ0MXplaHhpNkhNKzg0bGRBekpUSEVUYU5nOEVSVllCMTcwNndlWURTODN3TFB5V1QyeDFwOVZICnpUaDlES0J2d291anlqb1VQK2I3SHlXaHNRVXJvV2FVcnJqMnB6RUNnWUVBclRzN29aRStEcEVwWHBCWTdPZ0QKYzF5V21rZ3JEKzNMQVhYK0dMM2lXNEx4WTk3N25ucHdUZzlNS290UXZYNGovc1NhQms1a0x4VE1ZdzRBSURRTQoxZjNmMHhSQnZoWU8vaFFPVDQxbzM0RTZ2TEFtYnY5UnA3SFF0YXpRWW1BNmpjT1dpaWlzekViT1B6R2RtbVZaCks2czJEZFJjU3V1TnF2SHVSa3BvcTZFQ2dZQkxMZHJSNDRIZzVjSGhTRUZDTmRnSitYYUlEd044UnI1eStLRjYKeXN1MHVNcXNQWDZjTmxGdXlsZk1JaXdNYlVQMkh3aXNndjNuYjJwZVVQejFQWTV6VGkwZ2ZUU2NuemhrV3ozUgpuUkRHeXRMdkNDa2pQUDZaWFI0alQ1cFVsV3lCYnNNS0R2NzVQSzVwSVNUN3hKZUdFcHF4ZjN3dHFoZEJlUHdECncyejE0UUtCZ0dDRGcxUGdDaHAreTFZamJhUUxuanUxTGRUeVRBTnJEeWNHQmxqMUt2SGlXd2pIOTZ6MExKaXUKakRmeVhIb1ZEZXZmTWIxeGdib3lZRnRCdDdjOTJZL1dSRkxsWjRHWnlKSzUwcTAxbEtjZ21YV1BDd1ZzL3F6aQpMYU9GbE1XQktENTNvejlwcTUxZy81U25sRTlVczJjQ1U4R00yS2IvTkRPdWFQeDJZMnJNCi0tLS0tRU5EIFJTQSBQUklWQVRFIEtFWS0tLS0tCg==\n', NULL, '', 22, '', NULL, 'yes', NULL, NULL, NULL, '', 0);
-- ----------------------------
-- Table structure for common_dump
-- ----------------------------
DROP TABLE IF EXISTS `common_dump`;
CREATE TABLE `common_dump` (
`id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
`name` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '监听名称',
`rule` varchar(2000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '规则',
`version_id` bigint(255) NULL DEFAULT NULL COMMENT 'duckula监听的版本',
`deploy_id` bigint(20) NULL DEFAULT NULL COMMENT '部署ID配置',
`user_id` bigint(11) NULL DEFAULT NULL COMMENT '用户id',
`middleware_id` bigint(20) NULL DEFAULT NULL COMMENT '目的中间件配置',
`instance_id` bigint(20) NULL DEFAULT NULL COMMENT '需要监听的实例配置',
`attr_config` varchar(2000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '附加的配置,如自动创建ES索引',
`tenant_id` bigint(20) NOT NULL COMMENT '租户id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1345047408696401922 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of common_dump
-- ----------------------------
INSERT INTO `common_dump` VALUES (1345047408696401921, 'localhost_56_es', 'test`user_info``{\'startId\':\'2\',\'needCols\':\'name,age\',\'index\':\'demo\',\'numDump\':\'1\'}`[{\'ruleValue\':\'rjzjh[0-9]{2}\',\'field\':\'name\',\'index\':0,\'rule\':\'regular\'}]&test`user_addr``{\'wheresql\':\'where id<3\',\'startId\':\'1\',\'needCols\':\'user_id\',\'index\':\'demo\',\'numDump\':\'1\'}`', 2, 1344624860489924609, NULL, 1344916023692316673, 1344625457763008514, '', 0);
-- ----------------------------
-- Table structure for common_instance
-- ----------------------------
DROP TABLE IF EXISTS `common_instance`;
CREATE TABLE `common_instance` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '数据库实例名',
`host` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
`port` int(255) NULL DEFAULT 3306 COMMENT '端口',
`username` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
`password` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
`is_drds` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT 'false' COMMENT 'yes:是no:不是',
`user_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '所属用户',
`com_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '所属公司',
`remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '备注',
`tenant_id` bigint(20) NULL DEFAULT NULL COMMENT '租户id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of common_instance
-- ----------------------------
INSERT INTO `common_instance` VALUES (1344625457763008514, 'localhost_56', 'docker.for.win.localhost', 3307, 'root', 'mysql', 'no', NULL, NULL, '', 0);
-- ----------------------------
-- Table structure for common_middleware
-- ----------------------------
DROP TABLE IF EXISTS `common_middleware`;
CREATE TABLE `common_middleware` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '名称',
`middleware_type` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '配置类型:ES/Mysql/Kafka',
`version` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '中间件版本',
`user_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '所属用户',
`com_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '所属公司',
`host` varchar(2000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '主机,逗号隔开',
`port` int(11) NULL DEFAULT NULL COMMENT '端口,逗号隔开',
`port2` int(11) NULL DEFAULT NULL COMMENT '端口2,如es需要2个端口',
`username` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '用户名',
`password` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '密码',
`hostsconfig` varchar(2000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '配置到主机上的hosts,如kafka配置为hosts注册node时',
`opt` varchar(8000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '选项,json类型',
`remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '备注',
`tenant_id` bigint(20) NOT NULL COMMENT '租户id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1344916023692316674 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of common_middleware
-- ----------------------------
INSERT INTO `common_middleware` VALUES (1344626763013636097, 'localhost_kafka', 'kafka', '1.X', NULL, NULL, 'docker.for.win.localhost', 9092, NULL, '', '', '', '', '', 0);
INSERT INTO `common_middleware` VALUES (1344916023692316673, 'localhost_es7', 'es', '7.X', NULL, NULL, 'docker.for.win.localhost', 9200, 9300, '', '', '', '', '本机es', 0);
-- ----------------------------
-- Table structure for common_task
-- ----------------------------
DROP TABLE IF EXISTS `common_task`;
CREATE TABLE `common_task` (
`id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
`name` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '监听名称',
`buffer_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT 'threadpoolmuli' COMMENT '缓冲类型,disruptor,threadpoolmuli',
`send_num` int(11) NULL DEFAULT 3 COMMENT '发送线程数,默认为3',
`rule` varchar(2000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '规则',
`version_id` bigint(255) NULL DEFAULT NULL COMMENT 'duckula监听的版本',
`deploy_id` bigint(20) NULL DEFAULT NULL COMMENT '部署ID配置',
`user_id` bigint(11) NULL DEFAULT NULL COMMENT '用户id',
`middleware_id` bigint(20) NULL DEFAULT NULL COMMENT '目的中间件配置',
`instance_id` bigint(20) NULL DEFAULT NULL COMMENT '需要监听的实例配置',
`checkpoint_id` bigint(255) NULL DEFAULT NULL COMMENT '检查点',
`group_id` int(11) NULL DEFAULT NULL COMMENT '组id,用于分布式锁,checkpoint mysql启作用',
`client_id` int(11) NULL DEFAULT NULL COMMENT '连接mysql的客户端,最初由id生成',
`ha_type` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'cur表示从当前最新位点启动,last表示从记录的最后位点启动,pos表示从上面设置的gtids启动',
`gtids` varchar(2000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '开始的gtid值。',
`attr_config` varchar(2000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '附加的配置,如自动创建ES索引',
`tenant_id` bigint(20) NOT NULL COMMENT '租户id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1344921618608640003 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of common_task
-- ----------------------------
INSERT INTO `common_task` VALUES (1344627208641658881, 'localhost_56_kafka', NULL, NULL, 'test`user_info``{\'topic\':\'demo\'}`[{\'ruleValue\':\'rjzjh[0-9]{2}\',\'field\':\'name\',\'index\':0,\'rule\':\'regular\'},{\'ruleValue\':\'name,age,birthday,money\',\'index\':0,\'rule\':\'colname\'},{\'ruleValue\':\'insert,update\',\'index\':0,\'rule\':\'opttype\'}]&test`user_addr``{\'topic\':\'demo\'}`[{\'ruleValue\':\'select 1 from test.user_info where id=@{user_id} and money=33 limit 0,1\',\'index\':0,\'rule\':\'sql\'}]', 2, 1344624860489924609, NULL, 1344626763013636097, 1344625457763008514, 1344625760717586434, 55977, 55977, 'last', '', '', 1403991610825912321);
INSERT INTO `common_task` VALUES (1344921618608640002, 'localhost_56_es', NULL, NULL, 'test`user_info``{\'index\':\'demo\'}`&test`user_addr``{\'index\':\'demo\'}`', 2, 1344624860489924609, NULL, 1344916023692316673, 1344625457763008514, 1344625760717586434, 47709, 47709, 'last', '', '{\'common.es.auto.create.index_join.demo\': \'db:test|tb:user_info|db1:test|tb1:user_addr|rela1:user_id|shardsNum:12\'}', 1403991610825912321);
-- ----------------------------
-- Table structure for common_version
-- ----------------------------
DROP TABLE IF EXISTS `common_version`;
CREATE TABLE `common_version` (
`id` bigint(11) NOT NULL,
`main_version` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '主程序版本',
`main_path` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '主程序存储路径',
`data_version` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '数据版本',
`data_path` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '数据存储路径',
`image_group` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '镜像库的组,如果没有配置就使用阿里云的镜像组',
`author` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '作者',
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '升级时间',
`readme` varchar(2000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '更新说明',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '不需要区分租户' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of common_version
-- ----------------------------
INSERT INTO `common_version` VALUES (1, '3.0.0', 'home:/', '3.0.0', 'home:/', 'registry.cn-hangzhou.aliyuncs.com/rjzjh/duckula', 'Andy', '2020-12-24 00:00:00', '第一个版本。。。。。。');
INSERT INTO `common_version` VALUES (2, '3.0.1', 'home:/', '3.0.1', 'home:/', 'registry.cn-hangzhou.aliyuncs.com/rjzjh/duckula', 'Andy', '2020-12-31 00:00:00', '增加过滤重要功能');
-- ----------------------------
-- Table structure for sys_global
-- ----------------------------
DROP TABLE IF EXISTS `sys_global`;
CREATE TABLE `sys_global` (
`id` bigint(20) NOT NULL,
`config_globle` varchar(5000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '分组',
`last_username` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '验证类型',
`last_updatetime` datetime(0) NULL DEFAULT NULL COMMENT '排序',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '全局对象' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_global
-- ----------------------------
INSERT INTO `sys_global` VALUES (1, '{\"total\":1,\"rows\":[{\"editor\":{\"options\":{\"validType\":\"email\"},\"type\":\"validatebox\"},\"name\":\"邮箱\",\"group\":\"管理员\"},{\"editor\":\"text\",\"name\":\"区域(region)\",\"value\":\"cn-northwest-1\",\"group\":\"AWS(亚马逊)\"},{\"editor\":\"text\",\"name\":\"accessKey\",\"value\":\"\",\"group\":\"AWS(亚马逊)\"},{\"editor\":\"text\",\"name\":\"secretKey\",\"value\":\"\",\"group\":\"AWS(亚马逊)\"},{\"editor\":\"text\",\"name\":\"bucketName\",\"group\":\"AWS(亚马逊)\"}]}', 'admin', '2021-02-20 09:08:49');
-- ----------------------------
-- Table structure for sys_group
-- ----------------------------
DROP TABLE IF EXISTS `sys_group`;
CREATE TABLE `sys_group` (
`id` bigint(11) NOT NULL AUTO_INCREMENT,
`group_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`org_id` bigint(11) NULL DEFAULT NULL,
`tenant_id` bigint(20) NOT NULL COMMENT '租户id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1404047699953139715 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_group
-- ----------------------------
INSERT INTO `sys_group` VALUES (1404047699953139714, 'duckula产品研发组', 1404033285464055809, 0);
-- ----------------------------
-- Table structure for sys_optgroup
-- ----------------------------
DROP TABLE IF EXISTS `sys_optgroup`;
CREATE TABLE `sys_optgroup` (
`id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`parent_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`is_edit` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`is_valid` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'LIST 下拉列表,值放入字典表的ID \r\n INPUT 输入值 \r\n CLASS 自定义类规则',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '不需要区分租户' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_optgroup
-- ----------------------------
INSERT INTO `sys_optgroup` VALUES ('aa', 'aa', 'bb', 'yes', 'no');
INSERT INTO `sys_optgroup` VALUES ('bb', 'bbn', '', 'yes', 'yes');
INSERT INTO `sys_optgroup` VALUES ('city', '市', 'province', 'yes', 'yes');
INSERT INTO `sys_optgroup` VALUES ('county', '区/县', 'city', 'yes', 'yes');
INSERT INTO `sys_optgroup` VALUES ('direction', '职级方向', '', 'yes', 'yes');
INSERT INTO `sys_optgroup` VALUES ('province', '省', 'state', 'no', 'yes');
INSERT INTO `sys_optgroup` VALUES ('ranks', '公司职级', 'direction', 'yes', 'yes');
INSERT INTO `sys_optgroup` VALUES ('role', '角色', NULL, 'no', 'yes');
INSERT INTO `sys_optgroup` VALUES ('state', '国家', NULL, 'no', 'yes');
-- ----------------------------
-- Table structure for sys_optitem
-- ----------------------------
DROP TABLE IF EXISTS `sys_optitem`;
CREATE TABLE `sys_optitem` (
`id` bigint(11) NOT NULL,
`item_code` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`parent_id` bigint(11) NULL DEFAULT NULL,
`parent_id_old` bigint(255) NULL DEFAULT NULL COMMENT '在对应的组被移动时临时保存',
`group_code` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`name_zh` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`name_en` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`order_no` int(11) NULL DEFAULT NULL,
`field1` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`field2` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`field3` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`field4` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`remark` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`status` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`status_parent` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`create_time` datetime(0) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '不需要分租户' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_optitem
-- ----------------------------
INSERT INTO `sys_optitem` VALUES (1, 'develop', NULL, NULL, 'role', '开发者', 'developer', 1, '', '', '', '', '', 'yes', NULL, '2021-06-17 16:45:50');
INSERT INTO `sys_optitem` VALUES (2, 'superadmin', NULL, NULL, 'role', '超级管理员', 'superadmin', 2, NULL, NULL, NULL, NULL, NULL, 'yes', NULL, '2015-12-22 10:31:50');
INSERT INTO `sys_optitem` VALUES (3, 'appadmin', NULL, NULL, 'role', 'app管理员', 'appadmin', 3, NULL, NULL, NULL, NULL, NULL, 'yes', NULL, '2015-12-22 10:31:50');
INSERT INTO `sys_optitem` VALUES (4, 'ddfadfada', 5, NULL, 'aa', '测试', 'test', NULL, NULL, NULL, NULL, NULL, NULL, 'yes', NULL, NULL);
INSERT INTO `sys_optitem` VALUES (5, 'bbb', NULL, NULL, 'bb', '测试parent', 'test parent', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_optitem` VALUES (1405453721263525890, 'zh', NULL, NULL, 'state', '中国', 'china', 1, '', '', '', '', '', 'yes', NULL, '2021-06-17 17:14:14');
INSERT INTO `sys_optitem` VALUES (1405453941368016897, 'en', NULL, NULL, 'state', '美国', 'america', NULL, '', '', '', '', '', 'yes', NULL, '2021-06-17 17:15:06');
INSERT INTO `sys_optitem` VALUES (1405454316607229954, 'bj', 1405453721263525890, NULL, 'province', '北京', 'beijing', NULL, '', '', '', '', '', 'yes', NULL, '2021-06-17 17:16:36');
INSERT INTO `sys_optitem` VALUES (1405454456197861377, 'sh', 1405453721263525890, NULL, 'province', '上海', 'shanghai', NULL, '', '', '', '', '', 'yes', NULL, '2021-06-17 17:17:09');
INSERT INTO `sys_optitem` VALUES (1405454588083556353, 'jx', 1405453721263525890, NULL, 'province', '江西', 'jiangxi', NULL, '', '', '', '', '', 'yes', NULL, '2021-06-17 17:17:41');
INSERT INTO `sys_optitem` VALUES (1405455552895111169, 'sh', NULL, NULL, 'city', '上海', 'shanghai', NULL, '', '', '', '', '', 'yes', NULL, '2021-06-17 17:21:31');
INSERT INTO `sys_optitem` VALUES (1405455959918759938, 'bs', 1405455552895111169, NULL, 'county', '宝山区', 'baoshang', NULL, '', '', '', '', '', 'yes', NULL, '2021-06-17 17:23:08');
INSERT INTO `sys_optitem` VALUES (1405712959927832578, 'dev', NULL, NULL, 'direction', '研发', 'developer', NULL, '', '', '', '', '', 'yes', NULL, '2021-06-18 10:24:21');
INSERT INTO `sys_optitem` VALUES (1405713260302913537, 'ops', NULL, NULL, 'direction', '运维', 'maintenance', NULL, '', '', '', '', '', 'yes', NULL, '2021-06-18 10:25:33');
INSERT INTO `sys_optitem` VALUES (1405715229302149121, 'dev_junior', 1405712959927832578, NULL, 'ranks', '初始研发工程师', 'Junior R&D Engineer', NULL, '', '', '', '', '', 'yes', NULL, '2021-06-18 10:33:22');
INSERT INTO `sys_optitem` VALUES (1405715720379650050, 'dev_senior', 1405712959927832578, NULL, 'ranks', '高级研发工程师', 'Senior R&D Engineer', NULL, '', '', '', '', '', 'yes', NULL, '2021-06-18 10:35:19');
INSERT INTO `sys_optitem` VALUES (1405716075226157057, 'team_manager', NULL, NULL, 'direction', '团队管理', 'team management', NULL, '', '', '', '', '', 'yes', NULL, '2021-06-18 10:36:44');
-- ----------------------------
-- Table structure for sys_org
-- ----------------------------
DROP TABLE IF EXISTS `sys_org`;
CREATE TABLE `sys_org` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`parent_id` bigint(20) NULL DEFAULT NULL COMMENT '父组织id',
`org_id_path` varchar(2000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '组织id的路径',
`org_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '组织名称',
`org_code` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '组织编码',
`unit_type` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'virtual:虚拟 entity:实体 manage:管理',
`address` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '地址',
`tenant_id` bigint(20) NOT NULL COMMENT '租户',
PRIMARY KEY (`id`) USING BTREE,
INDEX `parentGroup`(`parent_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1405764876745900035 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_org
-- ----------------------------
INSERT INTO `sys_org` VALUES (1403991610825912321, NULL, '/1403991610825912321', '系统管理公司', 'com-1623572660053001', 'ORG', '', 0);
INSERT INTO `sys_org` VALUES (1405764737687945218, 1403991610825912321, '/1403991610825912321,1405764737687945218', '测试部', NULL, 'DEPT', '', 0);
INSERT INTO `sys_org` VALUES (1405764808865284097, 1403991610825912321, '/1403991610825912321,1405764808865284097', '研发部', NULL, 'DEPT', '', 0);
INSERT INTO `sys_org` VALUES (1405764876745900034, 1403991610825912321, '/1403991610825912321,1405764876745900034', '运维部', NULL, 'DEPT', '', 0);
-- ----------------------------
-- Table structure for sys_org_rela
-- ----------------------------
DROP TABLE IF EXISTS `sys_org_rela`;
CREATE TABLE `sys_org_rela` (
`id` bigint(20) NOT NULL,
`org_id_main` bigint(20) NOT NULL,
`org_id_rela` bigint(20) NULL DEFAULT NULL,
`rela_type` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'virtual:虚拟 manage:监管 service:服务关系',
`tenant_id` bigint(20) NOT NULL COMMENT '租户id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for sys_permissions
-- ----------------------------
DROP TABLE IF EXISTS `sys_permissions`;
CREATE TABLE `sys_permissions` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '权限编号',
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '权限名',
`opt_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '操作类型,data:数据,url:功能',
`data_pattern` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '数据权限有的模式:all,like,equal,expression',
`data_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '数据权限的值,跟模式搭配使用',
`url_pattern` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '功能权限的模式:*:全部地址 pre:前缀模式,regular:正则表达式',
`url_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '功能权限用的值',
`tenant_id` bigint(20) NOT NULL COMMENT '租户id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for sys_position
-- ----------------------------
DROP TABLE IF EXISTS `sys_position`;
CREATE TABLE `sys_position` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`position_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`org_id` bigint(20) NOT NULL,
`tenant_id` bigint(20) NOT NULL COMMENT '租户id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1404073609204932611 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_position
-- ----------------------------
INSERT INTO `sys_position` VALUES (1404073609204932610, '架构师', 1404033285464055809, 0);
-- ----------------------------
-- Table structure for sys_resource
-- ----------------------------
DROP TABLE IF EXISTS `sys_resource`;
CREATE TABLE `sys_resource` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`res_code` varchar(2000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
`res_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`res_value` varchar(2000) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`res_type` varchar(10) CHARACTER SET utf32 COLLATE utf32_general_ci NOT NULL,
`icon` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
`res_level` int(11) NULL DEFAULT NULL,
`is_edit` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '1',
`is_super` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '只有超级用户可以看',
`parent_id` bigint(11) NULL DEFAULT NULL,
`show_order` bigint(11) NULL DEFAULT NULL,
`remark` varchar(2000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
`is_sync` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '是否由程序同步',
`bound1` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
`bound2` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
`bound3` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
`bound4` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
`bound5` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
`bound6` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
`bound7` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
`bound8` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
`bound9` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1405720906263252994 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '不区分租户' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_resource
-- ----------------------------
INSERT INTO `sys_resource` VALUES (1, 'operateRes', '操作资源', '0', 'OPERATE', 'icon-folder-star', 0, 'no', 'no', NULL, NULL, '资源顶层结点', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_resource` VALUES (2, 'dataRes', '数据资源', '0', 'DATA', 'icon-folder-star', 0, 'no', 'yes', NULL, NULL, '资源顶层结点', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_resource` VALUES (3, 'casManager', '系统设置', '0', 'MODULE', 'icon-folder-star', 1, 'no', 'yes', 1, 1, '模块', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_resource` VALUES (4, 'setting', '任务资源', '0', 'MODULE', 'sysmanage', 1, 'no', 'no', 1, 1, '模块', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_resource` VALUES (5, 'taskManager', '任务管理', '0', 'MODULE', 'ma', 1, 'no', 'no', 1, 1, '模块', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_resource` VALUES (6, 'monitor', '监控性能', '0', 'MODULE', 'statement', 1, 'no', 'no', 1, 1, '模块', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_resource` VALUES (7, 'tenantRes', '其它租户数据查看', '0', 'DATA', 'icon-search', 1, 'yes', 'yes', 2, 1, '如:集团可以看子公司的数据', NULL, NULL, 'yes', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_resource` VALUES (8, 'tenantResUpdate', '其它租户数据修改', '0', 'DATA', 'icon-edit', 1, 'yes', 'yes', 2, 1, '如:集团可以看子公司的数据', NULL, NULL, 'yes', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_resource` VALUES (1404404548439179266, '_cas_OrgManager', '组织管理', '/cas/OrgManager', 'URL', 'icon-user', 2, 'yes', 'yes', 3, NULL, '系统自动同步', 'yes', NULL, 'yes', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_resource` VALUES (1404404550062374913, '_cas_ResManager', '资源管理', '/cas/ResManager', 'URL', 'icon-user', 2, 'yes', 'yes', 3, NULL, '系统自动同步', 'yes', NULL, 'yes', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_resource` VALUES (1404404552566374402, '_cas_UserManager', '用户管理', '/cas/UserManager', 'URL', 'icon-user', 2, 'yes', 'yes', 3, NULL, '系统自动同步', 'yes', NULL, 'yes', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_resource` VALUES (1404404555280089089, '_runing_ConsumerManager', 'kafka消费服务管理', '/runing/ConsumerManager', 'URL', 'icon-user', 2, 'yes', 'no', 5, NULL, '系统自动同步', 'yes', NULL, 'yes', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_resource` VALUES (1404404556332859393, '_runing_DumpManager', '全量服务管理', '/runing/DumpManager', 'URL', 'icon-user', 2, 'yes', 'no', 5, NULL, '系统自动同步', 'yes', NULL, 'yes', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_resource` VALUES (1404404557448544258, '_runing_TaskManager', 'binlog监听任务管理', '/runing/TaskManager', 'URL', 'icon-user', 2, 'yes', 'no', 5, NULL, '系统自动同步', 'yes', NULL, 'yes', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_resource` VALUES (1404404558501314561, '_setting_CheckpointManager', '检查点服务管理', '/setting/CheckpointManager', 'URL', 'icon-user', 2, 'yes', 'no', 4, NULL, '系统自动同步', 'yes', NULL, 'yes', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_resource` VALUES (1404404560069984257, '_setting_DeployManager', '发布管理', '/setting/DeployManager', 'URL', 'icon-user', 2, 'yes', 'no', 4, NULL, '系统自动同步', 'yes', NULL, 'yes', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_resource` VALUES (1404404561642848257, '_setting_InstanceManager', '实例管理', '/setting/InstanceManager', 'URL', 'icon-user', 2, 'yes', 'no', 4, NULL, '系统自动同步', 'yes', NULL, 'yes', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_resource` VALUES (1404404563022774273, '_setting_MiddlewareManager', '中间件管理', '/setting/MiddlewareManager', 'URL', 'icon-user', 2, 'yes', 'no', 4, NULL, '系统自动同步', 'yes', NULL, 'yes', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_resource` VALUES (1404404564536918018, '_setting_VersionManager', 'duckula版本管理', '/setting/VersionManager', 'URL', 'icon-user', 2, 'yes', 'no', 4, NULL, '系统自动同步', 'yes', NULL, 'yes', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_resource` VALUES (1405720904841383938, '_cas_OptionItemManager', '字典管理', '/cas/OptionItemManager', 'URL', 'icon-user', 2, 'yes', 'yes', 3, NULL, '系统自动同步', 'yes', NULL, 'yes', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_resource` VALUES (1405720906263252993, '_cas_ResAllot', '资源分派', '/cas/ResAllot', 'URL', 'icon-user', 2, 'yes', 'yes', 3, NULL, '系统自动同步', 'yes', NULL, 'yes', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '角色名',
`status` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态 no:禁用 yes:正常',
`remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '备注',
`is_super` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '是否只有超级用户访问,默认为no,',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1405760902957436932 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '所有租户共用这些角色' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_role
-- ----------------------------
INSERT INTO `sys_role` VALUES (1405725733554835458, '运维管理员', 'yes', '配置任务资源', 'no');
INSERT INTO `sys_role` VALUES (1405726158106480641, '任务配置员', 'yes', '任务配置人员', 'no');
INSERT INTO `sys_role` VALUES (1405760902957436930, '系统管理员', 'yes', '整个系统的管理人员', 'yes');
INSERT INTO `sys_role` VALUES (1405760902957436931, '管理员', 'yes', '管理租户信息和权限赋值', 'no');
-- ----------------------------
-- Table structure for sys_role_assign
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_assign`;
CREATE TABLE `sys_role_assign` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`role_id` bigint(20) NULL DEFAULT NULL,
`assign_type` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '是一个枚举类型:ORG 组织 GROUP 群组 POSITION 职位 STAFF 员工',
`assign_value` bigint(20) NULL DEFAULT NULL COMMENT '按据不同的分派类型来自不同的表',
`tenant_id` bigint(20) NOT NULL COMMENT '租户id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1405768404344348676 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_role_assign
-- ----------------------------
INSERT INTO `sys_role_assign` VALUES (1405765357585104897, 1405760902957436930, 'STAFF', 1, 0);
INSERT INTO `sys_role_assign` VALUES (1405768293358870530, 1405726158106480641, 'STAFF', 1380812293954686978, 0);
INSERT INTO `sys_role_assign` VALUES (1405768404344348674, 1405725733554835458, 'STAFF', 1380812293954686979, 0);
INSERT INTO `sys_role_assign` VALUES (1405768404344348675, 1405760902957436931, 'STAFF', 1380812293954686980, 1);
-- ----------------------------
-- Table structure for sys_role_res
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_res`;
CREATE TABLE `sys_role_res` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`role_id` bigint(20) NULL DEFAULT NULL,
`res_id` bigint(20) NULL DEFAULT NULL,
`auth_code` bigint(20) NULL DEFAULT NULL COMMENT '跟据资源类型授权项来编码,如:1001 为空表示不能访问',
`tenant_id` bigint(20) NOT NULL COMMENT '租户id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1405813559281639497 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_role_res
-- ----------------------------
INSERT INTO `sys_role_res` VALUES (1405762295571222530, 1405760902957436930, 3, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405762297588682754, 1405760902957436930, 1404404548439179266, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405762298729533441, 1405760902957436930, 1404404550062374913, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405762300507918338, 1405760902957436930, 1404404552566374402, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405762301707489282, 1405760902957436930, 1405720904841383938, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405762302894477314, 1405760902957436930, 1405720906263252993, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405762304064688130, 1405760902957436930, 4, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405762307273330689, 1405760902957436930, 1404404560069984257, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405762308888137730, 1405760902957436930, 1404404561642848257, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405762310528110594, 1405760902957436930, 1404404563022774273, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405762313199882242, 1405760902957436930, 5, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405762314382675969, 1405760902957436930, 1404404555280089089, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405762316165255169, 1405760902957436930, 1404404556332859393, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405762317335465985, 1405760902957436930, 1404404557448544258, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405762318505676801, 1405760902957436930, 6, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405762593396166658, 1405725733554835458, 4, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405762594985807874, 1405725733554835458, 1404404560069984257, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405762596176990209, 1405725733554835458, 1404404561642848257, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405762597363978242, 1405725733554835458, 1404404563022774273, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405762879665803266, 1405726158106480641, 5, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405762880898928641, 1405726158106480641, 1404404555280089089, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405762881888784385, 1405726158106480641, 1404404556332859393, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405762883281293313, 1405726158106480641, 1404404557448544258, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405813559281639425, 1405725733554835458, 1404404558501314561, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405813559281639426, 1405760902957436930, 1, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405813559281639427, 1405760902957436930, 1404404558501314561, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405813559281639428, 1405760902957436930, 1404404564536918018, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405813559281639432, 1405725733554835458, 1, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405813559281639436, 1405726158106480641, 1, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405813559281639446, 1405725733554835458, 2, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405813559281639447, 1405725733554835458, 7, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405813559281639464, 1405760902957436931, 1, 1, 1);
INSERT INTO `sys_role_res` VALUES (1405813559281639465, 1405760902957436931, 3, 1, 1);
INSERT INTO `sys_role_res` VALUES (1405813559281639466, 1405760902957436931, 1404404548439179266, 1, 1);
INSERT INTO `sys_role_res` VALUES (1405813559281639467, 1405760902957436931, 1404404552566374402, 1, 1);
INSERT INTO `sys_role_res` VALUES (1405813559281639469, 1405760902957436931, 1405720906263252993, 1, 1);
INSERT INTO `sys_role_res` VALUES (1405813559281639470, 1405760902957436931, 4, 1, 1);
INSERT INTO `sys_role_res` VALUES (1405813559281639471, 1405760902957436931, 1404404558501314561, 1, 1);
INSERT INTO `sys_role_res` VALUES (1405813559281639472, 1405760902957436931, 1404404560069984257, 1, 1);
INSERT INTO `sys_role_res` VALUES (1405813559281639473, 1405760902957436931, 1404404561642848257, 1, 1);
INSERT INTO `sys_role_res` VALUES (1405813559281639474, 1405760902957436931, 1404404563022774273, 1, 1);
INSERT INTO `sys_role_res` VALUES (1405813559281639475, 1405760902957436931, 1404404564536918018, 1, 1);
INSERT INTO `sys_role_res` VALUES (1405813559281639476, 1405760902957436931, 5, 1, 1);
INSERT INTO `sys_role_res` VALUES (1405813559281639477, 1405760902957436931, 1404404555280089089, 1, 1);
INSERT INTO `sys_role_res` VALUES (1405813559281639478, 1405760902957436931, 1404404556332859393, 1, 1);
INSERT INTO `sys_role_res` VALUES (1405813559281639480, 1405760902957436931, 1, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405813559281639481, 1405760902957436931, 3, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405813559281639482, 1405760902957436931, 1404404548439179266, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405813559281639484, 1405760902957436931, 1404404552566374402, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405813559281639485, 1405760902957436931, 1405720906263252993, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405813559281639486, 1405760902957436931, 4, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405813559281639487, 1405760902957436931, 1404404558501314561, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405813559281639488, 1405760902957436931, 1404404560069984257, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405813559281639489, 1405760902957436931, 1404404561642848257, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405813559281639490, 1405760902957436931, 1404404563022774273, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405813559281639491, 1405760902957436931, 1404404564536918018, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405813559281639492, 1405760902957436931, 5, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405813559281639493, 1405760902957436931, 1404404555280089089, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405813559281639494, 1405760902957436931, 1404404556332859393, 1, 0);
INSERT INTO `sys_role_res` VALUES (1405813559281639496, 1405760902957436931, 1404404557448544258, 1, 1);
-- ----------------------------
-- Table structure for sys_tenant
-- ----------------------------
DROP TABLE IF EXISTS `sys_tenant`;
CREATE TABLE `sys_tenant` (
`id` bigint(20) NOT NULL,
`code` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '租户编码',
`name` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '租户名',
`create_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '创建时间',
`status` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '租户状态',
`status_time` datetime(0) NULL DEFAULT NULL COMMENT '状态改变时间',
`operate_reason` varchar(2000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '操作原因',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_tenant
-- ----------------------------
INSERT INTO `sys_tenant` VALUES (0, 'common', '公共资源', 'admin', 'yes', '2021-06-27 09:39:16', 'test');
INSERT INTO `sys_tenant` VALUES (1, 'demo', '示例租户', 'admin', 'yes', '2021-07-04 11:10:08', 'demo');
-- ----------------------------
-- Table structure for sys_tenant_rela
-- ----------------------------
DROP TABLE IF EXISTS `sys_tenant_rela`;
CREATE TABLE `sys_tenant_rela` (
`id` bigint(20) NOT NULL,
`tenant_main` bigint(20) NULL DEFAULT NULL COMMENT '主租户id',
`tenant_rela` bigint(20) NULL DEFAULT NULL COMMENT '从租户id',
`rela_type` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '关系类型:is:拥有 has:管理',
`status` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '关系租户状态',
`status_time` datetime(0) NULL DEFAULT NULL COMMENT '状态改变时间',
`operate_reason` varchar(2000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '操作原因',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '租户之间的关系' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '登陆ID',
`user_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'username',
`password` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
`gender` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别',
`email` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
`mobile` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号',
`status` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态 no:禁用 yes:正常',
`org_id` bigint(20) NULL DEFAULT NULL COMMENT '公司ID',
`remark` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
`minus_role` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '需要排除的角色',
`duties` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '取自于“职务”枚举值,多个职务用逗号分隔',
`tenant_id` bigint(20) NOT NULL COMMENT '租户id',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `username`(`user_name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1380812293954686988 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统用户' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO `sys_user` VALUES (1, 'admin', '$2a$10$2nMUZ5HG/P61GiB.XB7j2e.s2HCXoo6Nt3uUFsRvYfoYZynz5V84q', 'M', 'hulang6666@qq.com', '12345671123', 'yes', 1405764808865284097, '', '2016-11-11 11:11:11', '2016-11-11 11:11:11', NULL, NULL, 0);
INSERT INTO `sys_user` VALUES (1380812293954686978, 'dev', '$2a$10$DlusLX9sMq5PoeJQzrwhi.dWN5EWnTPRT5xy48aqGYabG0VB/KriS', 'M', 'rjzjh@163.com', '18964961172', 'yes', 1405764808865284097, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_user` VALUES (1380812293954686979, 'ops', '$2a$10$coHBEqZ/ZPqpOZ/4dnyfS.iB8dIVIwKcA9oSdnmp7rcKq0FMXHCeO', 'M', 'rjzjh@163.com', '18964961172', 'yes', 1405764876745900034, '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_user` VALUES (1380812293954686980, 'demo', '$2a$10$2nMUZ5HG/P61GiB.XB7j2e.s2HCXoo6Nt3uUFsRvYfoYZynz5V84q', 'M', 'rjzjh@163.com', '18964961172', 'yes', NULL, '', '2021-07-04 17:26:43', '2021-07-04 17:26:49', NULL, NULL, 1);
-- ----------------------------
-- Table structure for sys_user_group
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_group`;
CREATE TABLE `sys_user_group` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) NOT NULL,
`group_id` bigint(20) NOT NULL,
`tenant_id` bigint(20) NOT NULL COMMENT '租户id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1404785126531428355 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for sys_user_position
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_position`;
CREATE TABLE `sys_user_position` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) NULL DEFAULT NULL,
`position_id` bigint(20) NULL DEFAULT NULL,
`tenant_id` bigint(20) NOT NULL COMMENT '租户id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1404796752462688259 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
SET FOREIGN_KEY_CHECKS = 1;

Comment ( 0 )

Sign in for post a comment

Java
1
https://gitee.com/rjzjh/duckula-ops.git
git@gitee.com:rjzjh/duckula-ops.git
rjzjh
duckula-ops
duckula-ops
master

Search