jbe@622: BEGIN;
jbe@622: 
jbe@622: CREATE OR REPLACE VIEW "liquid_feedback_version" AS
jbe@622:   SELECT * FROM (VALUES ('4.2.2', 4, 2, 2))
jbe@622:   AS "subquery"("string", "major", "minor", "revision");
jbe@622: 
jbe@622: --DROP FUNCTION "closed_initiatives_in_bounding_box" (EBOX, INT4);
jbe@622: DROP INDEX "suggestion_location_idx";
jbe@622: DROP INDEX "draft_location_idx";
jbe@622: DROP INDEX "initiative_location_idx";
jbe@622: DROP INDEX "area_location_idx";
jbe@622: DROP INDEX "unit_location_idx";
jbe@622: DROP INDEX "member_location_idx";
jbe@622: 
jbe@622: DROP EXTENSION latlon;
jbe@622: 
jbe@622: COMMIT;