# HG changeset patch
# User jbe
# Date 1544201393 -3600
# Node ID d955519f7471cc08e135f5fe93dd08c1d4c76d92
# Parent  c918d08f5a8060b5b8b1be1ca908d9c8fb107234
Renamed indices on issue to match naming convention

diff -r c918d08f5a80 -r d955519f7471 core.sql
--- a/core.sql	Fri Dec 07 15:57:34 2018 +0100
+++ b/core.sql	Fri Dec 07 17:49:53 2018 +0100
@@ -872,10 +872,10 @@
 CREATE INDEX "issue_closed_idx" ON "issue" ("closed");
 CREATE INDEX "issue_created_idx_open" ON "issue" ("created") WHERE "closed" ISNULL;
 CREATE INDEX "issue_closed_idx_canceled" ON "issue" ("closed") WHERE "fully_frozen" ISNULL;
-CREATE INDEX "issue_latest_snapshot_id" ON "issue" ("latest_snapshot_id");
-CREATE INDEX "issue_admission_snapshot_id" ON "issue" ("admission_snapshot_id");
-CREATE INDEX "issue_half_freeze_snapshot_id" ON "issue" ("half_freeze_snapshot_id");
-CREATE INDEX "issue_full_freeze_snapshot_id" ON "issue" ("full_freeze_snapshot_id");
+CREATE INDEX "issue_latest_snapshot_id_idx" ON "issue" ("latest_snapshot_id");
+CREATE INDEX "issue_admission_snapshot_id_idx" ON "issue" ("admission_snapshot_id");
+CREATE INDEX "issue_half_freeze_snapshot_id_idx" ON "issue" ("half_freeze_snapshot_id");
+CREATE INDEX "issue_full_freeze_snapshot_id_idx" ON "issue" ("full_freeze_snapshot_id");
 
 COMMENT ON TABLE "issue" IS 'Groups of initiatives';