diff options
Diffstat (limited to 'upgrades/dbpatches/1.4/postgresql/patch/images.sql')
| -rw-r--r-- | upgrades/dbpatches/1.4/postgresql/patch/images.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/upgrades/dbpatches/1.4/postgresql/patch/images.sql b/upgrades/dbpatches/1.4/postgresql/patch/images.sql index 250068ae..22c472f4 100644 --- a/upgrades/dbpatches/1.4/postgresql/patch/images.sql +++ b/upgrades/dbpatches/1.4/postgresql/patch/images.sql @@ -4,7 +4,7 @@ CREATE TABLE images_tmp ( name varchar(64) DEFAULT '0' NOT NULL, image bytea DEFAULT '' NOT NULL, PRIMARY KEY (imageid) -); +) with OIDS; CREATE INDEX images_1 on images_tmp (imagetype,name); insert into images_tmp select * from images; |