# HG changeset patch
# User jbe
# Date 1500057991 -7200
# Node ID 4e0ee8416bbc4f673a9ac1f8311b32ee20be375e
# Parent  f5c5d2b12726b23d6c8eb77a8cc440d07ea360f6
Updates for "delete_member" and "delete_private_data" functions

diff -r f5c5d2b12726 -r 4e0ee8416bbc core.sql
--- a/core.sql	Fri Jul 14 20:27:33 2017 +0200
+++ b/core.sql	Fri Jul 14 20:46:31 2017 +0200
@@ -6220,16 +6220,23 @@
         "notification_sample_size"     = 0,
         "notification_dow"             = NULL,
         "notification_hour"            = NULL,
+        "notification_sent"            = NULL,
         "login_recovery_expiry"        = NULL,
         "password_reset_secret"        = NULL,
         "password_reset_secret_expiry" = NULL,
         "location"                     = NULL
         WHERE "id" = "member_id_p";
       -- "text_search_data" is updated by triggers
+      DELETE FROM "member_profile"     WHERE "member_id" = "member_id_p";
+      DELETE FROM "rendered_member_statement" WHERE "member_id" = "member_id_p";
       DELETE FROM "member_image"       WHERE "member_id" = "member_id_p";
       DELETE FROM "contact"            WHERE "member_id" = "member_id_p";
       DELETE FROM "ignored_member"     WHERE "member_id" = "member_id_p";
       DELETE FROM "session"            WHERE "member_id" = "member_id_p";
+      DELETE FROM "member_application" WHERE "member_id" = "member_id_p";
+      DELETE FROM "token"              WHERE "member_id" = "member_id_p";
+      DELETE FROM "subscription"       WHERE "member_id" = "member_id_p";
+      DELETE FROM "ignored_area"       WHERE "member_id" = "member_id_p";
       DELETE FROM "ignored_initiative" WHERE "member_id" = "member_id_p";
       DELETE FROM "delegation"         WHERE "truster_id" = "member_id_p";
       DELETE FROM "non_voter"          WHERE "member_id" = "member_id_p";
@@ -6237,6 +6244,7 @@
         WHERE "direct_voter"."issue_id" = "issue"."id"
         AND "issue"."closed" ISNULL
         AND "member_id" = "member_id_p";
+      DELETE FROM "notification_initiative_sent" WHERE "member_id" = "member_id_p";
       RETURN;
     END;
   $$;
@@ -6249,6 +6257,7 @@
   LANGUAGE 'plpgsql' VOLATILE AS $$
     BEGIN
       DELETE FROM "temporary_transaction_data";
+      DELETE FROM "temporary_suggestion_counts";
       DELETE FROM "member" WHERE "activated" ISNULL;
       UPDATE "member" SET
         "invite_code"                  = NULL,
@@ -6272,20 +6281,33 @@
         "notification_sample_size"     = 0,
         "notification_dow"             = NULL,
         "notification_hour"            = NULL,
+        "notification_sent"            = NULL,
         "login_recovery_expiry"        = NULL,
         "password_reset_secret"        = NULL,
         "password_reset_secret_expiry" = NULL,
         "location"                     = NULL;
       -- "text_search_data" is updated by triggers
+      DELETE FROM "member_profile";
+      DELETE FROM "rendered_member_statement";
       DELETE FROM "member_image";
       DELETE FROM "contact";
       DELETE FROM "ignored_member";
       DELETE FROM "session";
+      DELETE FROM "system_application";
+      DELETE FROM "system_application_redirect_uri";
+      DELETE FROM "dynamic_application_scope";
+      DELETE FROM "member_application";
+      DELETE FROM "token";
+      DELETE FROM "subscription";
+      DELETE FROM "ignored_area";
       DELETE FROM "ignored_initiative";
       DELETE FROM "non_voter";
       DELETE FROM "direct_voter" USING "issue"
         WHERE "direct_voter"."issue_id" = "issue"."id"
         AND "issue"."closed" ISNULL;
+      DELETE FROM "event_processed";
+      DELETE FROM "notification_initiative_sent";
+      DELETE FROM "newsletter";
       RETURN;
     END;
   $$;
diff -r f5c5d2b12726 -r 4e0ee8416bbc update/core-update.v3.2.2-v4.0.0.sql
--- a/update/core-update.v3.2.2-v4.0.0.sql	Fri Jul 14 20:27:33 2017 +0200
+++ b/update/core-update.v3.2.2-v4.0.0.sql	Fri Jul 14 20:46:31 2017 +0200
@@ -3236,16 +3236,23 @@
         "notification_sample_size"     = 0,
         "notification_dow"             = NULL,
         "notification_hour"            = NULL,
+        "notification_sent"            = NULL,
         "login_recovery_expiry"        = NULL,
         "password_reset_secret"        = NULL,
         "password_reset_secret_expiry" = NULL,
         "location"                     = NULL
         WHERE "id" = "member_id_p";
       -- "text_search_data" is updated by triggers
+      DELETE FROM "member_profile"     WHERE "member_id" = "member_id_p";
+      DELETE FROM "rendered_member_statement" WHERE "member_id" = "member_id_p";
       DELETE FROM "member_image"       WHERE "member_id" = "member_id_p";
       DELETE FROM "contact"            WHERE "member_id" = "member_id_p";
       DELETE FROM "ignored_member"     WHERE "member_id" = "member_id_p";
       DELETE FROM "session"            WHERE "member_id" = "member_id_p";
+      DELETE FROM "member_application" WHERE "member_id" = "member_id_p";
+      DELETE FROM "token"              WHERE "member_id" = "member_id_p";
+      DELETE FROM "subscription"       WHERE "member_id" = "member_id_p";
+      DELETE FROM "ignored_area"       WHERE "member_id" = "member_id_p";
       DELETE FROM "ignored_initiative" WHERE "member_id" = "member_id_p";
       DELETE FROM "delegation"         WHERE "truster_id" = "member_id_p";
       DELETE FROM "non_voter"          WHERE "member_id" = "member_id_p";
@@ -3253,6 +3260,7 @@
         WHERE "direct_voter"."issue_id" = "issue"."id"
         AND "issue"."closed" ISNULL
         AND "member_id" = "member_id_p";
+      DELETE FROM "notification_initiative_sent" WHERE "member_id" = "member_id_p";
       RETURN;
     END;
   $$;
@@ -3263,6 +3271,7 @@
   LANGUAGE 'plpgsql' VOLATILE AS $$
     BEGIN
       DELETE FROM "temporary_transaction_data";
+      DELETE FROM "temporary_suggestion_counts";
       DELETE FROM "member" WHERE "activated" ISNULL;
       UPDATE "member" SET
         "invite_code"                  = NULL,
@@ -3286,20 +3295,33 @@
         "notification_sample_size"     = 0,
         "notification_dow"             = NULL,
         "notification_hour"            = NULL,
+        "notification_sent"            = NULL,
         "login_recovery_expiry"        = NULL,
         "password_reset_secret"        = NULL,
         "password_reset_secret_expiry" = NULL,
         "location"                     = NULL;
       -- "text_search_data" is updated by triggers
+      DELETE FROM "member_profile";
+      DELETE FROM "rendered_member_statement";
       DELETE FROM "member_image";
       DELETE FROM "contact";
       DELETE FROM "ignored_member";
       DELETE FROM "session";
+      DELETE FROM "system_application";
+      DELETE FROM "system_application_redirect_uri";
+      DELETE FROM "dynamic_application_scope";
+      DELETE FROM "member_application";
+      DELETE FROM "token";
+      DELETE FROM "subscription";
+      DELETE FROM "ignored_area";
       DELETE FROM "ignored_initiative";
       DELETE FROM "non_voter";
       DELETE FROM "direct_voter" USING "issue"
         WHERE "direct_voter"."issue_id" = "issue"."id"
         AND "issue"."closed" ISNULL;
+      DELETE FROM "event_processed";
+      DELETE FROM "notification_initiative_sent";
+      DELETE FROM "newsletter";
       RETURN;
     END;
   $$;