1 files changed, 13 insertions, 0 deletions
diff --git a/upgrades/dbpatches/1.3/postgresql/patch/events.sql b/upgrades/dbpatches/1.3/postgresql/patch/events.sql
new file mode 100644
index 00000000..518f1c54
--- /dev/null
+++ b/upgrades/dbpatches/1.3/postgresql/patch/events.sql
@@ -0,0 +1,13 @@
+CREATE TABLE events (
+	eventid		bigint unsigned		DEFAULT '0'	NOT NULL,
+	triggerid		bigint unsigned		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)
+) ENGINE=InnoDB;
+CREATE INDEX events_1 on events (triggerid,clock);
+CREATE INDEX events_2 on events (clock);
+
+insert into events select * from alarms;
+drop table alarms;