X-Git-Url: https://git.heureux-cyclage.org/?a=blobdiff_plain;ds=sidebyside;f=maintenance%2Fpostgres%2Ftables.sql;h=eea9e68514e1eeb01eafc0f014a68567fae12653;hb=ca01c9ff7f62556f76bba61cad4cfbcbc9519828;hp=3516a3be2b2e91294804d3e32dabd44741107b10;hpb=11cf01dd9a8512ad4d9bded43cf22ebd38af8818;p=lhc%2Fweb%2Fwiklou.git

diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql
index 3516a3be2b..eea9e68514 100644
--- a/maintenance/postgres/tables.sql
+++ b/maintenance/postgres/tables.sql
@@ -358,10 +358,10 @@ CREATE INDEX img_sha1          ON image (img_sha1);
 
 CREATE TABLE image_comment_temp (
 	imgcomment_name       TEXT NOT NULL,
-	imgcomment_comment_id INTEGER NOT NULL,
-	PRIMARY KEY (imgcomment_name, imgcomment_comment_id)
+	imgcomment_description_id INTEGER NOT NULL,
+	PRIMARY KEY (imgcomment_name, imgcomment_description_id)
 );
-CREATE UNIQUE INDEX imgcomment_name ON image_comment_temp (imgcomment_rev);
+CREATE UNIQUE INDEX imgcomment_name ON image_comment_temp (imgcomment_name);
 
 CREATE TABLE oldimage (
   oi_name          TEXT         NOT NULL,