1.1 --- a/update/core-update.v4.2.0-v4.2.1.sql	Fri Nov 27 15:45:31 2020 +0100
     1.2 +++ b/update/core-update.v4.2.0-v4.2.1.sql	Sat Dec 05 04:04:52 2020 +0100
     1.3 @@ -1,9 +1,9 @@
     1.4 +BEGIN;
     1.5 +
     1.6  CREATE OR REPLACE VIEW "liquid_feedback_version" AS
     1.7 -  SELECT * FROM (VALUES ('4.2.1-incomplete-update', 4, 2, -1))
     1.8 +  SELECT * FROM (VALUES ('4.2.1', 4, 2, 1))
     1.9    AS "subquery"("string", "major", "minor", "revision");
    1.10  
    1.11 -BEGIN;
    1.12 -
    1.13  ALTER TABLE "unit" ADD COLUMN "attr" JSONB NOT NULL DEFAULT '{}' CHECK (jsonb_typeof("attr") = 'object');
    1.14  COMMENT ON COLUMN "unit"."attr" IS 'Opaque data structure to store any extended attributes used by frontend or middleware';
    1.15  
    1.16 @@ -970,4 +970,25 @@
    1.17      END;
    1.18    $$;
    1.19  
    1.20 +DROP INDEX "posting_global_idx";
    1.21 +DROP INDEX "posting_unit_idx";
    1.22 +DROP INDEX "posting_area_idx";
    1.23 +DROP INDEX "posting_policy_idx";
    1.24 +DROP INDEX "posting_issue_idx";
    1.25 +DROP INDEX "posting_initiative_idx";
    1.26 +DROP INDEX "posting_suggestion_idx";
    1.27 + 
    1.28 +DROP INDEX "posting_lexeme_idx";
    1.29 +
    1.30 +DROP INDEX "event_tl_global_idx";
    1.31 +DROP INDEX "event_tl_unit_idx";
    1.32 +DROP INDEX "event_tl_area_idx";
    1.33 +DROP INDEX "event_tl_policy_idx";
    1.34 +DROP INDEX "event_tl_issue_idx";
    1.35 +DROP INDEX "event_tl_initiative_idx";
    1.36 +DROP INDEX "event_tl_suggestion_idx";
    1.37 + 
    1.38 +DROP EXTENSION IF EXISTS conflux;
    1.39 +DROP EXTENSION IF EXISTS btree_gist;
    1.40 +
    1.41  COMMIT;