summaryrefslogtreecommitdiffstats
path: root/upgrades/dbpatches/1.4/postgresql/patch/alerts.sql
diff options
context:
space:
mode:
Diffstat (limited to 'upgrades/dbpatches/1.4/postgresql/patch/alerts.sql')
-rw-r--r--upgrades/dbpatches/1.4/postgresql/patch/alerts.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/upgrades/dbpatches/1.4/postgresql/patch/alerts.sql b/upgrades/dbpatches/1.4/postgresql/patch/alerts.sql
index 413e0ed0..d60dbe19 100644
--- a/upgrades/dbpatches/1.4/postgresql/patch/alerts.sql
+++ b/upgrades/dbpatches/1.4/postgresql/patch/alerts.sql
@@ -13,7 +13,7 @@ CREATE TABLE alerts_tmp (
error varchar(128) DEFAULT '' NOT NULL,
nextcheck integer DEFAULT '0' NOT NULL,
PRIMARY KEY (alertid)
-);
+) with OIDS;
CREATE INDEX alerts_1 on alerts_tmp (actionid);
CREATE INDEX alerts_2 on alerts_tmp (clock);
CREATE INDEX alerts_3 on alerts_tmp (triggerid);