liquid_feedback_core
annotate update/core-update.v4.2.1-v4.2.2.sql @ 622:5b7c4082d7b3
Version 4.2.2 with geoindices uninstalled by default
| author | jbe |
|---|---|
| date | Fri Feb 05 12:53:00 2021 +0100 (2021-02-05) |
| parents | |
| children |
| rev | line source |
|---|---|
| jbe@622 | 1 BEGIN; |
| jbe@622 | 2 |
| jbe@622 | 3 CREATE OR REPLACE VIEW "liquid_feedback_version" AS |
| jbe@622 | 4 SELECT * FROM (VALUES ('4.2.2', 4, 2, 2)) |
| jbe@622 | 5 AS "subquery"("string", "major", "minor", "revision"); |
| jbe@622 | 6 |
| jbe@622 | 7 --DROP FUNCTION "closed_initiatives_in_bounding_box" (EBOX, INT4); |
| jbe@622 | 8 DROP INDEX "suggestion_location_idx"; |
| jbe@622 | 9 DROP INDEX "draft_location_idx"; |
| jbe@622 | 10 DROP INDEX "initiative_location_idx"; |
| jbe@622 | 11 DROP INDEX "area_location_idx"; |
| jbe@622 | 12 DROP INDEX "unit_location_idx"; |
| jbe@622 | 13 DROP INDEX "member_location_idx"; |
| jbe@622 | 14 |
| jbe@622 | 15 DROP EXTENSION latlon; |
| jbe@622 | 16 |
| jbe@622 | 17 COMMIT; |