summaryrefslogtreecommitdiffstats
path: root/upgrades/dbpatches/1.4/postgresql/patch/mappings.sql
diff options
context:
space:
mode:
Diffstat (limited to 'upgrades/dbpatches/1.4/postgresql/patch/mappings.sql')
-rw-r--r--upgrades/dbpatches/1.4/postgresql/patch/mappings.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/upgrades/dbpatches/1.4/postgresql/patch/mappings.sql b/upgrades/dbpatches/1.4/postgresql/patch/mappings.sql
index 8c3d013d..e4b02eaa 100644
--- a/upgrades/dbpatches/1.4/postgresql/patch/mappings.sql
+++ b/upgrades/dbpatches/1.4/postgresql/patch/mappings.sql
@@ -4,7 +4,7 @@ CREATE TABLE mappings_tmp (
value varchar(64) DEFAULT '' NOT NULL,
newvalue varchar(64) DEFAULT '' NOT NULL,
PRIMARY KEY (mappingid)
-);
+) with OIDS;
CREATE INDEX mappings_1 on mappings_tmp (valuemapid);
insert into mappings_tmp select * from mappings;