blob: f7e6f4f53b5eaf54befa4162fe2fb55cd580cd73 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
|
CREATE TABLE events (
eventid bigint DEFAULT '0' NOT NULL,
triggerid bigint DEFAULT '0' NOT NULL,
clock integer DEFAULT '0' NOT NULL,
value integer DEFAULT '0' NOT NULL,
acknowledged integer DEFAULT '0' NOT NULL,
PRIMARY KEY (eventid)
);
CREATE INDEX events_1 on events (triggerid,clock);
CREATE INDEX events_2 on events (clock);
insert into events select * from alarms;
drop table alarms;
|
