# HG changeset patch
# User jbe
# Date 1544228785 -3600
# Node ID 332a2177e208949d3e520648e51af763a36464a4
# Parent  d955519f7471cc08e135f5fe93dd08c1d4c76d92
Reduced indices on "issue" table

diff -r d955519f7471 -r 332a2177e208 core.sql
--- a/core.sql	Fri Dec 07 17:49:53 2018 +0100
+++ b/core.sql	Sat Dec 08 01:26:25 2018 +0100
@@ -866,12 +866,8 @@
           ("fully_frozen" ISNULL OR "full_freeze_snapshot_id" NOTNULL) ) );
 CREATE INDEX "issue_state_idx" ON "issue" ("state");
 CREATE INDEX "issue_created_idx" ON "issue" ("created");
-CREATE INDEX "issue_accepted_idx" ON "issue" ("accepted");
-CREATE INDEX "issue_half_frozen_idx" ON "issue" ("half_frozen");
-CREATE INDEX "issue_fully_frozen_idx" ON "issue" ("fully_frozen");
 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_open_created_idx" ON "issue" ("created") WHERE "closed" ISNULL;
 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");