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