- added events.source (Alexei)

 - renamed events.triggerid -> events.sourceid (Alexei)


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

1 files changed, 4 insertions, 3 deletions

diff --git a/upgrades/dbpatches/1.3/postgresql/patch/events.sql b/upgrades/dbpatches/1.3/postgresql/patch/events.sql
index f7e6f4f5..71ecb9f1 100644
--- a/upgrades/dbpatches/1.3/postgresql/patch/events.sql
+++ b/upgrades/dbpatches/1.3/postgresql/patch/events.sql
@@ -1,13 +1,14 @@
 CREATE TABLE events (
 	eventid		bigint	DEFAULT '0'	NOT NULL,
-	triggerid	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)
 );
-CREATE INDEX events_1 on events (triggerid,clock);
+CREATE INDEX events_1 on events (triggerid,source,clock);
 CREATE INDEX events_2 on events (clock);
 
-insert into events select * from alarms;
+insert into events select eventid,0,triggerid,clock,value,acknowledged from alarms;
 drop table alarms;