liquid_feedback_core

diff update/core-update.v2.1.0-v2.1.1.sql @ 316:727926e290e7

Set "harmonic_weight" to zero instead of null, where there are no supporters
author jbe
date Sat Feb 02 20:21:16 2013 +0100 (2013-02-02)
parents 3e450a518197
children 09e2805decd3
line diff
     1.1 --- a/update/core-update.v2.1.0-v2.1.1.sql	Fri Feb 01 20:14:43 2013 +0100
     1.2 +++ b/update/core-update.v2.1.0-v2.1.1.sql	Sat Feb 02 20:21:16 2013 +0100
     1.3 @@ -112,6 +112,8 @@
     1.4            "i" := "i" + 1;
     1.5          END LOOP;
     1.6        END LOOP;
     1.7 +      UPDATE "initiative" SET "harmonic_weight" = 0
     1.8 +        WHERE "issue_id" = "issue_id_p" AND "harmonic_weight" ISNULL;
     1.9      END;
    1.10    $$;
    1.11  
    1.12 @@ -219,6 +221,8 @@
    1.13            "i" := "i" + 1;
    1.14          END LOOP;
    1.15        END LOOP;
    1.16 +      UPDATE "suggestion" SET "harmonic_weight" = 0
    1.17 +        WHERE "initiative_id" = "initiative_id_p" AND "harmonic_weight" ISNULL;
    1.18      END;
    1.19    $$;
    1.20  

Impressum / About Us