liquid_feedback_core

diff core.sql @ 48:74c985baf082

Function "delete_member_data"(...) deletes outgoing delegations
(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";

Impressum / About Us