blob: 40be6161755c79445b886a0bb10437eb7df1eab4 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
CREATE TABLE nodes (
nodeid integer DEFAULT '0' NOT NULL,
name varchar(64) DEFAULT '0' NOT NULL,
timezone integer DEFAULT '0' NOT NULL,
ip varchar(15) DEFAULT '' NOT NULL,
port integer DEFAULT '10051' NOT NULL,
slave_history integer DEFAULT '30' NOT NULL,
slave_trends integer DEFAULT '365' NOT NULL,
event_lastid bigint unsigned DEFAULT '0' NOT NULL,
history_lastid bigint unsigned DEFAULT '0' NOT NULL,
history_str_lastid bigint unsigned DEFAULT '0' NOT NULL,
history_uint_lastid bigint unsigned DEFAULT '0' NOT NULL,
nodetype integer DEFAULT '0' NOT NULL,
masterid integer DEFAULT '0' NOT NULL,
PRIMARY KEY (nodeid)
) ENGINE=InnoDB;
|
