1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
CREATE TABLE events (
eventid bigint DEFAULT '0' NOT NULL,
source integer DEFAULT '0' NOT NULL,
object integer DEFAULT '0' NOT NULL,
objectid 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)
) with OIDS;
CREATE INDEX events_1 on events (object,objectid,clock);
CREATE INDEX events_2 on events (clock);
insert into events select alarmid,0,0,triggerid,clock,value,acknowledged from alarms;
drop table alarms;
|
