kafka-eagle数据库脚本，表结构和数据

1.表结构

CREATE TABLE ke_metrics(

`cluster` varchar(500),

`broker` varchar(500),

`type` varchar(500),

`key` varchar(500),

`value` varchar(500),

`timespan` varchar(500),

`tm` varchar(500));

 

CREATE TABLE ke_users(

rtxno varchar(500),

username varchar(500),

password varchar(500),

email varchar(500),

realname varchar(500));

 

CREATE TABLE ke_alarm(

`cluster` varchar(500),

`group` varchar(500),

`topic` varchar(500),

`lag` varchar(500),

`owner` varchar(500),

`created` varchar(500),

`modify` varchar(500));

 

CREATE TABLE ke_clusters(

`type` varchar(500),

`cluster` varchar(500),

`server` varchar(500),

`owner` varchar(500),

`created` varchar(500),

`modify` varchar(500));

 

CREATE TABLE ke_lag(

`cluster` varchar(500),

`group` varchar(500),

`topic` varchar(500),

`lag` varchar(500),

`timespan` varchar(500),

`tm` varchar(500));

 

CREATE TABLE ke_resources(

name varchar(500),

url varchar(500),

parent_id varchar(500));

 

CREATE TABLE ke_role_resource(

role_id varchar(500),

resource_id varchar(500));

 

CREATE TABLE ke_user_role(

user_id varchar(500),

role_id varchar(500));

2.数据

INSERT INTO `ke_users` VALUES ('123', 'admin', '123456', '123', '132', '123');