Shulou(Shulou.com)06/03 Report--

/ *

Navicat MySQL Data Transfer

Source Server: 206 docker mysql 13306

Source Server Version: 50720

Source Host: 192.168.7.206:13306

Source Database: kafkamonitor

Target Server Type: MYSQL

Target Server Version: 50720

File Encoding: 65001

Date: 2018-05-05 18:32:21

, /

SET FOREIGN_KEY_CHECKS=0

-- Table structure for groups

DROP TABLE IF EXISTS groups

CREATE TABLE groups (

Id bigint (32) NOT NULL

Name varchar (64) DEFAULT NULL

PRIMARY KEY (id)

) ENGINE=InnoDB DEFAULT CHARSET=utf8

-- Records of groups

INSERT INTO groups VALUES ('0mm,' ALL')

INSERT INTO groups VALUES ('1customers,' DEVELOPMENT')

INSERT INTO groups VALUES ('2percent,' PRODUCTION')

INSERT INTO groups VALUES ('3percent,' STAGING')

INSERT INTO groups VALUES ('44th,' TEST')

-- Table structure for offsetHistory

DROP TABLE IF EXISTS offsetHistory

CREATE TABLE offsetHistory (

Id bigint (16) unsigned NOT NULL AUTO_INCREMENT

ZookeeperId bigint (16) DEFAULT NULL

Topic varchar (255) DEFAULT NULL

PRIMARY KEY (id)

) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8

-- Records of offsetHistory

INSERT INTO offsetHistory VALUES ('1th,' 1th, 'dbsync-topic')

INSERT INTO offsetHistory VALUES ('2th,' 1th, 'test')

INSERT INTO offsetHistory VALUES ('3pm,' 1pm, 'consumer_offsets')

INSERT INTO offsetHistory VALUES ('44th,' 34th, 'test')

INSERT INTO offsetHistory VALUES ('5pm,' 3pm, 'dbsync-topic')

INSERT INTO offsetHistory VALUES ('6,'3,'_ _ consumer_offsets')

INSERT INTO offsetHistory VALUES ('74th,' 44th, 'test')

INSERT INTO offsetHistory VALUES ('84th,' 44th, 'dbsync-topic')

INSERT INTO offsetHistory VALUES ('9,'4, 'consumer_offsets')

-- Table structure for offsetPoints

DROP TABLE IF EXISTS offsetPoints

CREATE TABLE offsetPoints (

Id bigint (16) NOT NULL AUTO_INCREMENT

ConsumerGroup varchar (255) DEFAULT NULL

Timestamp timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP

OffsetHistoryId bigint (20) DEFAULT NULL

Partition int (2) DEFAULT NULL

Offset bigint (16) DEFAULT NULL

LogSize bigint (16) DEFAULT NULL

PRIMARY KEY (id)

) ENGINE=InnoDB DEFAULT CHARSET=utf8

-- Records of offsetPoints

-- Table structure for play_evolutions

DROP TABLE IF EXISTS play_evolutions

CREATE TABLE play_evolutions (

Id int (11) NOT NULL

Hash varchar (255) NOT NULL

Applied_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

Apply_script text

Revert_script text

State varchar (255) DEFAULT NULL

Last_problem text

PRIMARY KEY (id)

) ENGINE=InnoDB DEFAULT CHARSET=utf8

-- Records of play_evolutions

INSERT INTO play_evolutions VALUES ('1mm,' d8bf02bc30462083ba80bfcdefcd4d5819fae616), '2018-05-05 10 nname VARCHAR,\ nport INT,\ nstatusId LONG,\ ngroupId LONG,\ nPRIMARY KEY (name)\ n);\ n\ nCREATE TABLE groups (\ nid LONG,\ nname VARCHAR,\ nPRIMARY KEY (id)\ n);\ n\ nCREATE TABLE status (\ nid LONG,\ nname VARCHAR,\ nPRIMARY KEY (id)\ n) \ n\ nINSERT INTO groups (id, name) VALUES (0,\ 'ALL\');\ nINSERT INTO groups (id, name) VALUES (1,\ 'DEVELOPMENT\');\ nINSERT INTO groups (id, name) VALUES (2,\ 'PRODUCTION\');\ nINSERT INTO groups (id, name) VALUES (3,\ 'STAGING\');\ nINSERT INTO groups (id, name) VALUES (4,\ 'TEST\');\ n\ nINSERT INTO status (id, name) VALUES (0,\ 'CONNECTING\') \ nINSERT INTO status (id, name) VALUES (1,\ 'CONNECTED\');\ nINSERT INTO status (id, name) VALUES (2,\ 'DISCONNECTED\');\ nINSERT INTO status (id, name) VALUES (3,\ 'DELETED\');', 'DROP TABLE IF EXISTS zookeepers;\ nDROP TABLE IF EXISTS groups;\ nDROP TABLE IF EXISTS status;',' applied', 'You have an error in your SQL syntax Check the manual that corresponds to your MySQL server version for the right syntax to use near\'\ nhost VARCHAR,\ nport INT,\ nstatusId LONG,\ ngroupId LONG,\ nPRIMARY KEY (name)\ n)\'at line 2 [ERROR:1064, SQLSTATE:42000]')

INSERT INTO play_evolutions VALUES ('2colors,' f067a8799026a738d280d57a6c64352f157223a013, '2018-05-05 10 ALTER TABLE zookeepers DROP COLUMN chroot;', 27 applied',' You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near\'\'at line 1 [ERROR:1064, SQLSTATE:42000]')

INSERT INTO play_evolutions VALUES ('3mm,' 843d0d81b91da54831c4a59368197e64975afcb7mm, '2018-05-05 10 nALTER TABLE zookeepers ADD COLUMN id LONG NOT NULL AUTO_INCREMENT; 27 nALTER TABLE zookeepers ADD PRIMARY KEY (id);\ nALTER TABLE zookeepers ALTER COLUMN name SET NOT NULL;\ nALTER TABLE zookeepers ALTER COLUMN host SET NOT NULL;\ nALTER TABLE zookeepers ALTER COLUMN port SET NOT NULL;\ nALTER TABLE zookeepers ALTER COLUMN statusId SET NOT NULL;\ nALTER TABLE zookeepers ALTER COLUMN groupId SET NOT NULL;\ nALTER TABLE zookeepers ADD UNIQUE (name)) \ n\ nCREATE TABLE offsetHistory (\ nid LONG AUTO_INCREMENT PRIMARY KEY,\ nzookeeperId LONG,\ ntopic VARCHAR (255),\ nFOREIGN KEY (zookeeperId) REFERENCES zookeepers (id),\ nUNIQUE (zookeeperId, topic)\ n);\ n\ nCREATE TABLE offsetPoints (\ nid LONG AUTOINCREMENT PRIMARY KEY,\ nconsumerGroup VARCHAR (255),\ ntimestamp TIMESTAMP,\ noffsetHistoryId LONG,\ npartition INT,\ noffset LONG,\ nlogSize LONG,\ nFOREIGN KEY (offsetHistoryId) REFERENCES offsetHistory (id)\ n);\ n\ nCREATE TABLE settings (\ nkey VARCHAR (255) PRIMARY KEY,\ nvalue VARCHAR (255)\ n) \ n\ nINSERT INTO settings (key_, value) VALUES (\ 'PURGESCHEDULE\',\ '000? SUN\');\ nINSERT INTO settings (key, value) VALUES (\ 'OFFSET_FETCH_INTERVAL\',\'30\');', 'DROP TABLE IF EXISTS offsetPoints;\ nDROP TABLE IF EXISTS offsetHistory;\ nDROP TABLE IF EXISTS settings;\ n\ nALTER TABLE zookeepers DROP PRIMARY KEY;\ nALTER TABLE zookeepers DROP COLUMN id;\ nALTER TABLE zookeepers ADD PRIMARY KEY (name);\ nALTER TABLE zookeepers ALTER COLUMN host SET NULL;\ nALTER TABLE zookeepers ALTER COLUMN port SET NULL;\ nALTER TABLE zookeepers ALTER COLUMN statusId SET NULL;\ nALTER TABLE zookeepers ALTER COLUMN groupId SET NULL ',' applied', 'Incorrect table definition; there can be only one auto column and it must be defined as a key [ERROR:1075, SQLSTATE:42000]')

-- Table structure for settings

DROP TABLE IF EXISTS settings

CREATE TABLE settings (

Key_ varchar (255) DEFAULT NULL

Value varchar (255) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8

-- Records of settings

INSERT INTO settings VALUES ('PURGE_SCHEDULE',' 000? SUN')

INSERT INTO settings VALUES ('OFFSET_FETCH_INTERVAL',' 30')

-- Table structure for status

DROP TABLE IF EXISTS status

CREATE TABLE status (

Id bigint (32) NOT NULL

Name varchar (64) DEFAULT NULL

PRIMARY KEY (id)

) ENGINE=InnoDB DEFAULT CHARSET=utf8

-- Records of status

INSERT INTO status VALUES ('0mm,' CONNECTING')

INSERT INTO status VALUES ('1customers,' CONNECTED')

INSERT INTO status VALUES ('2percent,' DISCONNECTED')

INSERT INTO status VALUES ('3percent,' DELETED')

-- Table structure for zookeepers

DROP TABLE IF EXISTS zookeepers

CREATE TABLE zookeepers (

Name varchar (64) NOT NULL

Host varchar (64) NOT NULL

Port int (6) NOT NULL

StatusId bigint (32) NOT NULL

GroupId bigint (32) NOT NULL

Chroot varchar (64) DEFAULT NULL

Id bigint (16) NOT NULL AUTO_INCREMENT

PRIMARY KEY (id)

) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8

-- Records of zookeepers

INSERT INTO zookeepers VALUES ("zookeeper204'," 192.168.7.204, "2181", "1", "0", "", "1")

INSERT INTO zookeepers VALUES ('zookeeper203',' 192.168.7.203', '2181','1','0','3')

INSERT INTO zookeepers VALUES ('zookeeper201',' 192.168.7.201, '2181,' 1, 0,0,4')

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.