upgrades/dbpatches/1.3/postgresql/patch/node_configlog.sql


1
2
3
4
5
6
7
8
9
10
11
12

CREATE TABLE node_configlog (
	conflogid	bigint DEFAULT '0'	NOT NULL,
	nodeid		bigint DEFAULT '0'	NOT NULL,
	tablename	varchar(64)		DEFAULT ''	NOT NULL,
	recordid	bigint DEFAULT '0'	NOT NULL,
	operation	integer		DEFAULT '0'	NOT NULL,
	sync_master	integer		DEFAULT '0'	NOT NULL,
	sync_slave	integer		DEFAULT '0'	NOT NULL,
	PRIMARY KEY (nodeid,conflogid)
);
CREATE INDEX node_configlog_configlog_1 on node_configlog (conflogid);
CREATE INDEX node_configlog_configlog_2 on node_configlog (nodeid,tablename);