1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/update/core-update.v4.2.1-v4.2.2.sql	Fri Feb 05 12:53:00 2021 +0100
     1.3 @@ -0,0 +1,17 @@
     1.4 +BEGIN;
     1.5 +
     1.6 +CREATE OR REPLACE VIEW "liquid_feedback_version" AS
     1.7 +  SELECT * FROM (VALUES ('4.2.2', 4, 2, 2))
     1.8 +  AS "subquery"("string", "major", "minor", "revision");
     1.9 +
    1.10 +--DROP FUNCTION "closed_initiatives_in_bounding_box" (EBOX, INT4);
    1.11 +DROP INDEX "suggestion_location_idx";
    1.12 +DROP INDEX "draft_location_idx";
    1.13 +DROP INDEX "initiative_location_idx";
    1.14 +DROP INDEX "area_location_idx";
    1.15 +DROP INDEX "unit_location_idx";
    1.16 +DROP INDEX "member_location_idx";
    1.17 +
    1.18 +DROP EXTENSION latlon;
    1.19 +
    1.20 +COMMIT;