liquid_feedback_core
diff core.sql @ 48:74c985baf082
Function "delete_member_data"(...) deletes outgoing delegations
(v1.0.1 with update script)
(v1.0.1 with update script)
author | jbe |
---|---|
date | Tue Apr 20 18:01:07 2010 +0200 (2010-04-20) |
parents | 5a01d558565b |
children | c45df7907da6 |
line diff
1.1 --- a/core.sql Thu Apr 15 21:29:11 2010 +0200 1.2 +++ b/core.sql Tue Apr 20 18:01:07 2010 +0200 1.3 @@ -6,7 +6,7 @@ 1.4 BEGIN; 1.5 1.6 CREATE VIEW "liquid_feedback_version" AS 1.7 - SELECT * FROM (VALUES ('1.0.0', 1, 0, 0)) 1.8 + SELECT * FROM (VALUES ('1.0.1', 1, 0, 1)) 1.9 AS "subquery"("string", "major", "minor", "revision"); 1.10 1.11 1.12 @@ -3224,6 +3224,7 @@ 1.13 DELETE FROM "member_relation_setting" WHERE "member_id" = "member_id_p"; 1.14 DELETE FROM "member_image" WHERE "member_id" = "member_id_p"; 1.15 DELETE FROM "contact" WHERE "member_id" = "member_id_p"; 1.16 + DELETE FROM "delegation" WHERE "truster_id" = "member_id_p"; 1.17 DELETE FROM "area_setting" WHERE "member_id" = "member_id_p"; 1.18 DELETE FROM "issue_setting" WHERE "member_id" = "member_id_p"; 1.19 DELETE FROM "initiative_setting" WHERE "member_id" = "member_id_p";