liquid_feedback_core

changeset 326:d59d0c3e4a18

merge
author jbe
date Sun Feb 10 18:49:01 2013 +0100 (2013-02-10)
parents a0dd8c78bd10 6529e423f8eb
children ae0da58a9858
files core.sql
line diff
     1.1 --- a/core.sql	Sun Feb 10 18:41:56 2013 +0100
     1.2 +++ b/core.sql	Sun Feb 10 18:49:01 2013 +0100
     1.3 @@ -3410,8 +3410,10 @@
     1.4          WHERE "issue_id" = "issue_id_p"
     1.5          AND "event" = 'periodic';
     1.6        DELETE FROM "direct_supporter_snapshot"
     1.7 -        WHERE "issue_id" = "issue_id_p"
     1.8 -        AND "event" = 'periodic';
     1.9 +        USING "initiative"  -- NOTE: due to missing index on issue_id
    1.10 +        WHERE "initiative"."issue_id" = "issue_id_p"
    1.11 +        AND "direct_supporter_snapshot"."initiative_id" = "initiative"."id"
    1.12 +        AND "direct_supporter_snapshot"."event" = 'periodic';
    1.13        INSERT INTO "direct_interest_snapshot"
    1.14          ("issue_id", "event", "member_id")
    1.15          SELECT
    1.16 @@ -3681,7 +3683,10 @@
    1.17        UPDATE "delegating_interest_snapshot" SET "event" = "event_p"
    1.18          WHERE "issue_id" = "issue_id_p" AND "event" = "event_v";
    1.19        UPDATE "direct_supporter_snapshot" SET "event" = "event_p"
    1.20 -        WHERE "issue_id" = "issue_id_p" AND "event" = "event_v";
    1.21 +        FROM "initiative"  -- NOTE: due to missing index on issue_id
    1.22 +        WHERE "initiative"."issue_id" = "issue_id_p"
    1.23 +        AND "direct_supporter_snapshot"."initiative_id" = "initiative"."id"
    1.24 +        AND "direct_supporter_snapshot"."event" = "event_v";
    1.25        RETURN;
    1.26      END;
    1.27    $$;
    1.28 @@ -4494,7 +4499,9 @@
    1.29          DELETE FROM "delegation"
    1.30            WHERE "issue_id" = "issue_id_p";
    1.31          DELETE FROM "supporter"
    1.32 -          WHERE "issue_id" = "issue_id_p";
    1.33 +          USING "initiative"
    1.34 +          WHERE "initiative"."issue_id" = "issue_id_p"
    1.35 +          AND "supporter"."initiative_id" = "initiative_id";
    1.36          UPDATE "issue" SET
    1.37            "state"           = "issue_row"."state",
    1.38            "closed"          = "issue_row"."closed",

Impressum / About Us