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;