blob: 237cbcba1a67f398c88c467251401835cf4cd182 (
plain)
1
2
3
4
5
6
7
8
9
|
CREATE TABLE history_sync (
id serial ,
nodeid bigint DEFAULT '0' NOT NULL,
itemid bigint DEFAULT '0' NOT NULL,
clock integer DEFAULT '0' NOT NULL,
value numeric(16,4) DEFAULT '0.0000' NOT NULL,
PRIMARY KEY (id)
);
CREATE INDEX history_sync_1 on history_sync (nodeid,id);
|