blob: 4576949d6f6cc9bfbf7cfb01858ac6a09bc0a2ee (
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 DEFAULT '0' NOT NULL,
history_lastid bigint DEFAULT '0' NOT NULL,
history_str_lastid bigint DEFAULT '0' NOT NULL,
history_uint_lastid bigint DEFAULT '0' NOT NULL,
nodetype integer DEFAULT '0' NOT NULL,
masterid integer DEFAULT '0' NOT NULL,
PRIMARY KEY (nodeid)
) with OIDS;
|
