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;