2 -- Dumping database structure for kafka_center
3 CREATE DATABASE IF NOT EXISTS `kafka_center` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin */;
7 -- Dumping structure for table kafka_center.alert_group
8 CREATE TABLE IF NOT EXISTS `alert_group` (
9 `id` int(11) NOT NULL AUTO_INCREMENT,
10 `cluster_id` int(11) NOT NULL,
11 `topic_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
12 `consummer_group` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
13 `consummer_api` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
14 `threshold` int(11) DEFAULT NULL,
15 `dispause` int(11) DEFAULT NULL,
16 `mail_to` varchar(1000) COLLATE utf8_bin NOT NULL DEFAULT '',
17 `webhook` varchar(1000) COLLATE utf8_bin NOT NULL DEFAULT '',
18 `create_date` datetime DEFAULT NULL,
19 `owner_id` int(11) DEFAULT NULL,
20 `team_id` int(11) DEFAULT NULL,
21 `disable_alerta` tinyint(1) DEFAULT 0,
22 `enable` tinyint(1) NOT NULL DEFAULT 1,
24 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
26 -- Data exporting was unselected.
29 -- Dumping structure for table kafka_center.cluster_info
30 CREATE TABLE IF NOT EXISTS `cluster_info` (
31 `id` int(11) NOT NULL AUTO_INCREMENT,
32 `name` varchar(255) COLLATE utf8_bin NOT NULL,
33 `zk_address` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
34 `broker` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
35 `create_time` datetime DEFAULT NULL,
36 `comments` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
37 `enable` int(11) DEFAULT NULL,
38 `broker_size` int(4) DEFAULT 0,
39 `kafka_version` varchar(10) COLLATE utf8_bin DEFAULT '',
40 `location` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
41 `graf_addr` varchar(255) COLLATE utf8_bin DEFAULT '',
43 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
45 -- Data exporting was unselected.
48 -- Dumping structure for table kafka_center.ksql_info
49 CREATE TABLE IF NOT EXISTS `ksql_info` (
50 `id` int(11) NOT NULL AUTO_INCREMENT,
51 `cluster_id` int(11) DEFAULT NULL,
52 `cluster_name` varchar(255) DEFAULT NULL,
53 `ksql_url` varchar(255) DEFAULT NULL,
54 `ksql_serverId` varchar(255) DEFAULT NULL,
55 `version` varchar(255) DEFAULT NULL,
56 `team_ids` varchar(200) DEFAULT NULL,
58 ) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8;
59 -- Data exporting was unselected.
62 -- Dumping structure for table kafka_center.task_info
63 CREATE TABLE IF NOT EXISTS `task_info` (
64 `id` int(11) NOT NULL AUTO_INCREMENT,
65 `cluster_ids` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
66 `location` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '',
67 `topic_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
68 `partition` int(11) DEFAULT NULL,
69 `replication` int(11) DEFAULT NULL,
70 `message_rate` int(50) DEFAULT NULL,
71 `ttl` int(11) DEFAULT NULL,
72 `owner_id` int(11) DEFAULT NULL,
73 `team_id` int(11) DEFAULT NULL,
74 `comments` varchar(1000) COLLATE utf8_bin NOT NULL DEFAULT '',
75 `create_time` datetime DEFAULT NULL,
76 `approved` int(11) DEFAULT NULL,
77 `approved_id` int(11) DEFAULT NULL,
78 `approved_time` datetime DEFAULT NULL,
79 `approval_opinions` varchar(1000) COLLATE utf8_bin DEFAULT '',
81 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
83 -- Data exporting was unselected.
86 -- Dumping structure for table kafka_center.team_info
87 CREATE TABLE IF NOT EXISTS `team_info` (
88 `id` int(11) NOT NULL AUTO_INCREMENT,
89 `name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
90 `own` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
91 `alarm_group` varchar(255) COLLATE utf8_bin DEFAULT NULL,
93 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
95 -- Data exporting was unselected.
98 -- Dumping structure for table kafka_center.topic_collection
99 CREATE TABLE IF NOT EXISTS `topic_collection` (
100 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
101 `cluster_id` int(11) NOT NULL,
102 `user_id` int(11) NOT NULL,
103 `name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
104 `type` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
106 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
108 -- Data exporting was unselected.
111 -- Dumping structure for table kafka_center.topic_info
112 CREATE TABLE IF NOT EXISTS `topic_info` (
113 `id` int(11) NOT NULL AUTO_INCREMENT,
114 `cluster_id` int(11) NOT NULL,
115 `topic_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
116 `partition` int(11) DEFAULT NULL,
117 `replication` int(11) DEFAULT NULL,
118 `ttl` bigint(11) DEFAULT NULL,
119 `config` varchar(512) COLLATE utf8_bin DEFAULT NULL,
120 `owner_id` int(11) DEFAULT NULL,
121 `team_id` int(11) DEFAULT NULL,
122 `comments` varchar(1000) COLLATE utf8_bin NOT NULL DEFAULT '',
123 `create_time` datetime DEFAULT NULL,
124 `file_size` bigint(20) NOT NULL DEFAULT -1,
126 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
128 -- Data exporting was unselected.
131 -- Dumping structure for table kafka_center.user_info
132 CREATE TABLE IF NOT EXISTS `user_info` (
133 `id` int(11) NOT NULL AUTO_INCREMENT,
134 `name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
135 `real_name` varchar(255) COLLATE utf8_bin DEFAULT '',
136 `email` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
137 `role` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '100',
138 `create_time` datetime DEFAULT NULL,
139 `password` varchar(255) COLLATE utf8_bin DEFAULT '',
141 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
143 -- Data exporting was unselected.
146 -- Dumping structure for table kafka_center.user_team
147 CREATE TABLE IF NOT EXISTS `user_team` (
148 `id` int(11) NOT NULL AUTO_INCREMENT,
149 `user_id` int(11) DEFAULT NULL,
150 `team_id` int(11) DEFAULT NULL,
152 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
154 -- Data exporting was unselected.
156 -- Dumping structure for table kafka_center.ksql_history
157 CREATE TABLE IF NOT EXISTS `ksql_history` (
158 `id` int(20) NOT NULL AUTO_INCREMENT,
159 `name` varchar(255) DEFAULT NULL,
160 `ksql_server_id` varchar(255) DEFAULT NULL,
161 `user` varchar(255) DEFAULT NULL,
162 `date` datetime DEFAULT current_timestamp(),
163 `operate` text DEFAULT NULL,
164 `type` varchar(255) DEFAULT NULL,
165 `script` text DEFAULT NULL,
167 ) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8mb4;
169 -- Dumping structure for table kafka_center.ksql_info
170 CREATE TABLE IF NOT EXISTS `ksql_info` (
171 `id` int(11) NOT NULL AUTO_INCREMENT,
172 `cluster_id` int(11) DEFAULT NULL,
173 `cluster_name` varchar(255) DEFAULT NULL,
174 `ksql_url` varchar(255) DEFAULT NULL,
175 `ksql_serverId` varchar(255) DEFAULT NULL,
176 `version` varchar(255) DEFAULT NULL,
177 `team_ids` varchar(200) DEFAULT NULL,
179 ) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8mb4;
181 -- Dumping structure for table kafka_center.kstream
182 CREATE TABLE IF NOT EXISTS `kstream` (
183 `id` int(11) NOT NULL AUTO_INCREMENT,
184 `name` varchar(233) NOT NULL,
185 `team_id` int(11) DEFAULT NULL,
186 `cluster_id` int(11) DEFAULT NULL,
187 `owner_id` int(11) DEFAULT NULL,
188 `stream_type` int(11) DEFAULT NULL,
189 `config` varchar(255) DEFAULT NULL,
190 `topic` varchar(255) DEFAULT NULL,
191 `script` text DEFAULT NULL,
192 `create_time` datetime DEFAULT NULL,
194 ) ENGINE=InnoDB AUTO_INCREMENT=579 DEFAULT CHARSET=utf8mb4;
196 -- Dumping structure for table kafka_center.ktable
197 CREATE TABLE IF NOT EXISTS `ktable` (
198 `id` int(10) NOT NULL AUTO_INCREMENT,
199 `cluster_id` int(10) DEFAULT NULL,
200 `name` varchar(255) DEFAULT NULL,
201 `script` mediumtext DEFAULT NULL,
202 `topic` varchar(240) DEFAULT NULL,
203 `owner_id` int(10) DEFAULT NULL,
204 `team_id` int(10) DEFAULT NULL,
205 `create_time` datetime DEFAULT NULL,
207 ) ENGINE=InnoDB AUTO_INCREMENT=238 DEFAULT CHARSET=utf8mb4;
209 -- Dumping structure for table kafka_center.connect_info
210 CREATE TABLE IF NOT EXISTS `connect_info` (
211 `id` int(10) NOT NULL AUTO_INCREMENT,
212 `name` varchar(200) DEFAULT NULL,
213 `cluster_id` int(10) DEFAULT NULL,
214 `url` varchar(255) DEFAULT NULL,
215 `version` varchar(20) DEFAULT NULL,
216 `create_time` datetime DEFAULT current_timestamp(),
217 `team_ids` varchar(20) DEFAULT NULL,
218 `connectors` int(20) DEFAULT NULL,
220 ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4;
222 -- Dumping structure for table kafka_center.connect_job
223 CREATE TABLE IF NOT EXISTS `connect_job` (
224 `id` int(20) NOT NULL AUTO_INCREMENT,
225 `name` varchar(200) DEFAULT NULL,
226 `cluster_id` int(20) DEFAULT NULL,
227 `type` varchar(50) DEFAULT NULL,
228 `class_name` varchar(255) DEFAULT NULL,
229 `state` varchar(100) DEFAULT NULL,
230 `script` mediumtext DEFAULT NULL,
231 `owner_id` int(20) DEFAULT NULL,
232 `team_id` int(20) DEFAULT NULL,
233 `create_time` datetime DEFAULT current_timestamp(),
235 ) ENGINE=InnoDB AUTO_INCREMENT=794 DEFAULT CHARSET=utf8mb4;