diff options
Diffstat (limited to 'upgrades/dbpatches/1.4/postgresql/patch/events.sql')
| -rw-r--r-- | upgrades/dbpatches/1.4/postgresql/patch/events.sql | 19 |
1 files changed, 10 insertions, 9 deletions
diff --git a/upgrades/dbpatches/1.4/postgresql/patch/events.sql b/upgrades/dbpatches/1.4/postgresql/patch/events.sql index 95ef6320..bfd1575d 100644 --- a/upgrades/dbpatches/1.4/postgresql/patch/events.sql +++ b/upgrades/dbpatches/1.4/postgresql/patch/events.sql @@ -1,14 +1,15 @@ CREATE TABLE events ( - eventid bigint DEFAULT '0' NOT NULL, - source integer DEFAULT '0' NOT NULL, - sourceid 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) -); + 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,triggerid,clock,value,acknowledged from alarms; +insert into events select alarmid,0,0,triggerid,clock,value,acknowledged from alarms; drop table alarms; |