- fixed PostgreSQL upgrade patch (Alexei)

git-svn-id: svn://svn.zabbix.com/trunk@4353 97f52cf1-0a1b-0410-bd0e-c28be96e8082

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;