1.1 --- a/core.sql	Fri Nov 27 15:45:31 2020 +0100
     1.2 +++ b/core.sql	Sat Dec 05 04:04:52 2020 +0100
     1.3 @@ -3,12 +3,10 @@
     1.4  
     1.5  BEGIN;
     1.6  
     1.7 -CREATE EXTENSION IF NOT EXISTS btree_gist;
     1.8  CREATE EXTENSION IF NOT EXISTS latlon;
     1.9 -CREATE EXTENSION IF NOT EXISTS conflux;
    1.10  
    1.11  CREATE VIEW "liquid_feedback_version" AS
    1.12 -  SELECT * FROM (VALUES ('4.2.0', 4, 2, 0))
    1.13 +  SELECT * FROM (VALUES ('4.2.1', 4, 2, 1))
    1.14    AS "subquery"("string", "major", "minor", "revision");
    1.15  
    1.16  
    1.17 @@ -1403,13 +1401,6 @@
    1.18            "initiative_id" ISNULL OR "issue_id" NOTNULL ),
    1.19          CONSTRAINT "suggestion_requires_initiative" CHECK (
    1.20            "suggestion_id" ISNULL OR "initiative_id" NOTNULL ) );
    1.21 -CREATE INDEX "posting_global_idx" ON "posting" USING gist ((pstamp("author_id", "id")));
    1.22 -CREATE INDEX "posting_unit_idx" ON "posting" USING gist ("unit_id", (pstamp("author_id", "id"))) WHERE "unit_id" NOTNULL;
    1.23 -CREATE INDEX "posting_area_idx" ON "posting" USING gist ("area_id", (pstamp("author_id", "id"))) WHERE "area_id" NOTNULL;
    1.24 -CREATE INDEX "posting_policy_idx" ON "posting" USING gist ("policy_id", (pstamp("author_id", "id"))) WHERE "policy_id" NOTNULL;
    1.25 -CREATE INDEX "posting_issue_idx" ON "posting" USING gist ("issue_id", (pstamp("author_id", "id"))) WHERE "issue_id" NOTNULL;
    1.26 -CREATE INDEX "posting_initiative_idx" ON "posting" USING gist ("initiative_id", (pstamp("author_id", "id"))) WHERE "initiative_id" NOTNULL;
    1.27 -CREATE INDEX "posting_suggestion_idx" ON "posting" USING gist ("suggestion_id", (pstamp("author_id", "id"))) WHERE "suggestion_id" NOTNULL;
    1.28  
    1.29  COMMENT ON TABLE "posting" IS 'Text postings of members; a text posting may optionally be associated to a unit, area, policy, issue, initiative, or suggestion';
    1.30  
    1.31 @@ -1420,7 +1411,6 @@
    1.32          "posting_id"            INT8,
    1.33          "lexeme"                TEXT,
    1.34          "author_id"             INT4 );
    1.35 -CREATE INDEX "posting_lexeme_idx" ON "posting_lexeme" USING gist ("lexeme", (pstamp("author_id", "posting_id")));
    1.36  
    1.37  COMMENT ON TABLE "posting_lexeme" IS 'Helper table to allow searches for hashtags.';
    1.38  
    1.39 @@ -1773,14 +1763,6 @@
    1.40              "text_value"      ISNULL  AND
    1.41              "old_text_value"  ISNULL )) );
    1.42  CREATE INDEX "event_occurrence_idx" ON "event" ("occurrence");
    1.43 -CREATE INDEX "event_tl_global_idx" ON "event" USING gist ((pstamp("member_id", "id")));
    1.44 -CREATE INDEX "event_tl_unit_idx" ON "event" USING gist ("unit_id", (pstamp("member_id", "id"))) WHERE "unit_id" NOTNULL;
    1.45 -CREATE INDEX "event_tl_area_idx" ON "event" USING gist ("area_id", (pstamp("member_id", "id"))) WHERE "area_id" NOTNULL;
    1.46 -CREATE INDEX "event_tl_policy_idx" ON "event" USING gist ("policy_id", (pstamp("member_id", "id"))) WHERE "policy_id" NOTNULL;
    1.47 -CREATE INDEX "event_tl_issue_idx" ON "event" USING gist ("issue_id", (pstamp("member_id", "id"))) WHERE "issue_id" NOTNULL;
    1.48 -CREATE INDEX "event_tl_initiative_idx" ON "event" USING gist ("initiative_id", (pstamp("member_id", "id"))) WHERE "initiative_id" NOTNULL;
    1.49 -CREATE INDEX "event_tl_suggestion_idx" ON "event" USING gist ("suggestion_id", (pstamp("member_id", "id"))) WHERE "suggestion_id" NOTNULL;
    1.50 -
    1.51  
    1.52  COMMENT ON TABLE "event" IS 'Event table, automatically filled by triggers';
    1.53