summaryrefslogtreecommitdiffstats
path: root/upgrades/dbpatches/1.4/postgresql/patch/acknowledges.sql
diff options
context:
space:
mode:
Diffstat (limited to 'upgrades/dbpatches/1.4/postgresql/patch/acknowledges.sql')
-rw-r--r--upgrades/dbpatches/1.4/postgresql/patch/acknowledges.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/upgrades/dbpatches/1.4/postgresql/patch/acknowledges.sql b/upgrades/dbpatches/1.4/postgresql/patch/acknowledges.sql
index 7846291f..9cf41d86 100644
--- a/upgrades/dbpatches/1.4/postgresql/patch/acknowledges.sql
+++ b/upgrades/dbpatches/1.4/postgresql/patch/acknowledges.sql
@@ -5,7 +5,7 @@ CREATE TABLE acknowledges_tmp (
clock integer DEFAULT '0' NOT NULL,
message varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (acknowledgeid)
-);
+) with OIDS;
CREATE INDEX acknowledges_1 on acknowledges_tmp (userid);
CREATE INDEX acknowledges_2 on acknowledges_tmp (eventid);
CREATE INDEX acknowledges_3 on acknowledges_tmp (clock);