jenkins-bot has submitted this change and it was merged. (
https://gerrit.wikimedia.org/r/374840 )
Change subject: Fix index in PostgreSQL schema
......................................................................
Fix index in PostgreSQL schema
Followup to Ic3a434c06
Change-Id: I68966726f91b1854e845b2a0757b599644749b4f
---
M maintenance/postgres/archives/patch-comment-table.sql
M maintenance/postgres/tables.sql
2 files changed, 2 insertions(+), 2 deletions(-)
Approvals:
Reedy: Looks good to me, approved
jenkins-bot: Verified
diff --git a/maintenance/postgres/archives/patch-comment-table.sql
b/maintenance/postgres/archives/patch-comment-table.sql
index a84986f..8f2b3f3 100644
--- a/maintenance/postgres/archives/patch-comment-table.sql
+++ b/maintenance/postgres/archives/patch-comment-table.sql
@@ -24,4 +24,4 @@
imgcomment_comment_id INTEGER NOT NULL,
PRIMARY KEY (imgcomment_name, imgcomment_comment_id)
);
-CREATE UNIQUE INDEX imgcomment_name ON image_comment_temp (imgcomment_rev);
+CREATE UNIQUE INDEX imgcomment_name ON image_comment_temp (imgcomment_name);
diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql
index 3516a3b..c7ace89 100644
--- a/maintenance/postgres/tables.sql
+++ b/maintenance/postgres/tables.sql
@@ -361,7 +361,7 @@
imgcomment_comment_id INTEGER NOT NULL,
PRIMARY KEY (imgcomment_name, imgcomment_comment_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,
--
To view, visit https://gerrit.wikimedia.org/r/374840
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: I68966726f91b1854e845b2a0757b599644749b4f
Gerrit-PatchSet: 1
Gerrit-Project: mediawiki/core
Gerrit-Branch: master
Gerrit-Owner: Anomie <[email protected]>
Gerrit-Reviewer: Jjanes <[email protected]>
Gerrit-Reviewer: Parent5446 <[email protected]>
Gerrit-Reviewer: Reedy <[email protected]>
Gerrit-Reviewer: jenkins-bot <>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
