1.1 --- a/update/core-update.v3.2.2-v4.0.0.sql	Fri Jul 14 20:20:26 2017 +0200
     1.2 +++ b/update/core-update.v3.2.2-v4.0.0.sql	Fri Jul 14 20:27:33 2017 +0200
     1.3 @@ -660,6 +660,15 @@
     1.4  CREATE INDEX "non_voter_issue_id_idx" ON "non_voter" ("issue_id");
     1.5  
     1.6  
     1.7 +DROP TABLE "setting";
     1.8 +DROP TABLE "setting_map";
     1.9 +DROP TABLE "member_relation_setting";
    1.10 +DROP TABLE "unit_setting";
    1.11 +DROP TABLE "area_setting";
    1.12 +DROP TABLE "initiative_setting";
    1.13 +DROP TABLE "suggestion_setting";
    1.14 +
    1.15 +
    1.16  ALTER TABLE "event" ADD COLUMN "other_member_id" INT4    REFERENCES "member" ("id") ON DELETE RESTRICT ON UPDATE CASCADE;
    1.17  ALTER TABLE "event" ADD COLUMN "scope"           "delegation_scope";
    1.18  ALTER TABLE "event" ADD COLUMN "unit_id"         INT4    REFERENCES "unit" ("id") ON DELETE CASCADE ON UPDATE CASCADE;
    1.19 @@ -3233,18 +3242,11 @@
    1.20          "location"                     = NULL
    1.21          WHERE "id" = "member_id_p";
    1.22        -- "text_search_data" is updated by triggers
    1.23 -      DELETE FROM "setting"            WHERE "member_id" = "member_id_p";
    1.24 -      DELETE FROM "setting_map"        WHERE "member_id" = "member_id_p";
    1.25 -      DELETE FROM "member_relation_setting" WHERE "member_id" = "member_id_p";
    1.26        DELETE FROM "member_image"       WHERE "member_id" = "member_id_p";
    1.27        DELETE FROM "contact"            WHERE "member_id" = "member_id_p";
    1.28        DELETE FROM "ignored_member"     WHERE "member_id" = "member_id_p";
    1.29        DELETE FROM "session"            WHERE "member_id" = "member_id_p";
    1.30 -      DELETE FROM "area_setting"       WHERE "member_id" = "member_id_p";
    1.31 -      DELETE FROM "issue_setting"      WHERE "member_id" = "member_id_p";
    1.32        DELETE FROM "ignored_initiative" WHERE "member_id" = "member_id_p";
    1.33 -      DELETE FROM "initiative_setting" WHERE "member_id" = "member_id_p";
    1.34 -      DELETE FROM "suggestion_setting" WHERE "member_id" = "member_id_p";
    1.35        DELETE FROM "delegation"         WHERE "truster_id" = "member_id_p";
    1.36        DELETE FROM "non_voter"          WHERE "member_id" = "member_id_p";
    1.37        DELETE FROM "direct_voter" USING "issue"
    1.38 @@ -3289,18 +3291,11 @@
    1.39          "password_reset_secret_expiry" = NULL,
    1.40          "location"                     = NULL;
    1.41        -- "text_search_data" is updated by triggers
    1.42 -      DELETE FROM "setting";
    1.43 -      DELETE FROM "setting_map";
    1.44 -      DELETE FROM "member_relation_setting";
    1.45        DELETE FROM "member_image";
    1.46        DELETE FROM "contact";
    1.47        DELETE FROM "ignored_member";
    1.48        DELETE FROM "session";
    1.49 -      DELETE FROM "area_setting";
    1.50 -      DELETE FROM "issue_setting";
    1.51        DELETE FROM "ignored_initiative";
    1.52 -      DELETE FROM "initiative_setting";
    1.53 -      DELETE FROM "suggestion_setting";
    1.54        DELETE FROM "non_voter";
    1.55        DELETE FROM "direct_voter" USING "issue"
    1.56          WHERE "direct_voter"."issue_id" = "issue"."id"