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 (‘0‘, ‘ALL‘);
INSERT INTO groups VALUES (‘1‘, ‘DEVELOPMENT‘);
INSERT INTO groups VALUES (‘2‘, ‘PRODUCTION‘);
INSERT INTO groups VALUES (‘3‘, ‘STAGING‘);
INSERT INTO groups VALUES (‘4‘, ‘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 (‘1‘, ‘1‘, ‘dbsync-topic‘);
INSERT INTO offsetHistory VALUES (‘2‘, ‘1‘, ‘test‘);
INSERT INTO offsetHistory VALUES (‘3‘, ‘1‘, ‘consumer_offsets‘);
INSERT INTO offsetHistory VALUES (‘4‘, ‘3‘, ‘test‘);
INSERT INTO offsetHistory VALUES (‘5‘, ‘3‘, ‘dbsync-topic‘);
<