liquid_feedback_core
changeset 593:e7f772ca0621
Removed an index on table "initiative"
author | jbe |
---|---|
date | Sat Dec 08 01:37:23 2018 +0100 (2018-12-08) |
parents | 332a2177e208 |
children | a2c156197bc7 |
files | core.sql |
line diff
1.1 --- a/core.sql Sat Dec 08 01:26:25 2018 +0100 1.2 +++ b/core.sql Sat Dec 08 01:37:23 2018 +0100 1.3 @@ -973,7 +973,6 @@ 1.4 CONSTRAINT "eligible_at_first_rank_is_winner" CHECK ("eligible"=FALSE OR "rank"!=1 OR "winner"=TRUE), 1.5 CONSTRAINT "unique_rank_per_issue" UNIQUE ("issue_id", "rank") ); 1.6 CREATE INDEX "initiative_created_idx" ON "initiative" ("created"); 1.7 -CREATE INDEX "initiative_revoked_idx" ON "initiative" ("revoked"); 1.8 CREATE INDEX "initiative_location_idx" ON "initiative" USING gist ((GeoJSON_to_ecluster("location"))); 1.9 CREATE INDEX "initiative_text_search_data_idx" ON "initiative" USING gin ("text_search_data"); 1.10 CREATE INDEX "initiative_draft_text_search_data_idx" ON "initiative" USING gin ("draft_text_search_data");