# HG changeset patch # User jbe # Date 1544229443 -3600 # Node ID e7f772ca062115f1bd3972d06174afa080e610f7 # Parent 332a2177e208949d3e520648e51af763a36464a4 Removed an index on table "initiative" diff -r 332a2177e208 -r e7f772ca0621 core.sql --- a/core.sql Sat Dec 08 01:26:25 2018 +0100 +++ b/core.sql Sat Dec 08 01:37:23 2018 +0100 @@ -973,7 +973,6 @@ CONSTRAINT "eligible_at_first_rank_is_winner" CHECK ("eligible"=FALSE OR "rank"!=1 OR "winner"=TRUE), CONSTRAINT "unique_rank_per_issue" UNIQUE ("issue_id", "rank") ); CREATE INDEX "initiative_created_idx" ON "initiative" ("created"); -CREATE INDEX "initiative_revoked_idx" ON "initiative" ("revoked"); CREATE INDEX "initiative_location_idx" ON "initiative" USING gist ((GeoJSON_to_ecluster("location"))); CREATE INDEX "initiative_text_search_data_idx" ON "initiative" USING gin ("text_search_data"); CREATE INDEX "initiative_draft_text_search_data_idx" ON "initiative" USING gin ("draft_text_search_data");