liquid_feedback_core

diff core.sql @ 94:fb9688f31740

Corrected "delete_member" and "delete_private_data" functions to refer to "ignored_issue" table instead of non-existing "ignored_voting" table; Delete "ignored_issue" entries in "clean_issue" function as well
author jbe
date Sun Oct 31 02:38:05 2010 +0200 (2010-10-31)
parents 425bb591bff8
children 07e6a4f11b5b
line diff
     1.1 --- a/core.sql	Sun Oct 31 02:14:18 2010 +0200
     1.2 +++ b/core.sql	Sun Oct 31 02:38:05 2010 +0200
     1.3 @@ -3327,6 +3327,8 @@
     1.4            WHERE "issue_id" = "issue_id_p";
     1.5          DELETE FROM "direct_population_snapshot"
     1.6            WHERE "issue_id" = "issue_id_p";
     1.7 +        DELETE FROM "ignored_issue"
     1.8 +          WHERE "issue_id" = "issue_id_p";
     1.9          DELETE FROM "delegation"
    1.10            WHERE "issue_id" = "issue_id_p";
    1.11          DELETE FROM "supporter"
    1.12 @@ -3386,8 +3388,8 @@
    1.13        DELETE FROM "initiative_setting" WHERE "member_id" = "member_id_p";
    1.14        DELETE FROM "suggestion_setting" WHERE "member_id" = "member_id_p";
    1.15        DELETE FROM "membership"         WHERE "member_id" = "member_id_p";
    1.16 +      DELETE FROM "ignored_issue"      WHERE "member_id" = "member_id_p";
    1.17        DELETE FROM "delegation"         WHERE "truster_id" = "member_id_p";
    1.18 -      DELETE FROM "ignored_voting"     WHERE "member_id" = "member_id_p";
    1.19        DELETE FROM "direct_voter" USING "issue"
    1.20          WHERE "direct_voter"."issue_id" = "issue"."id"
    1.21          AND "issue"."closed" ISNULL
    1.22 @@ -3440,7 +3442,7 @@
    1.23        DELETE FROM "issue_setting";
    1.24        DELETE FROM "initiative_setting";
    1.25        DELETE FROM "suggestion_setting";
    1.26 -      DELETE FROM "ignored_voting";
    1.27 +      DELETE FROM "ignored_issue";
    1.28        DELETE FROM "direct_voter" USING "issue"
    1.29          WHERE "direct_voter"."issue_id" = "issue"."id"
    1.30          AND "issue"."closed" ISNULL;

Impressum / About Us