blob: 19f2ef4cc4d204c4288b45d96fbff8c69e524aa9 (
plain)
1
2
3
4
5
6
7
8
9
|
CREATE TABLE history_uint_sync (
id serial ,
nodeid bigint unsigned DEFAULT '0' NOT NULL,
itemid bigint unsigned DEFAULT '0' NOT NULL,
clock integer DEFAULT '0' NOT NULL,
value bigint unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (id)
);
CREATE INDEX history_uint_sync_1 on history_uint_sync (nodeid,id);
|