liquid_feedback_core

changeset 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
files core.sql update/core-update.v2.1.0-v2.1.1.sql
line diff
     1.1 --- a/core.sql	Fri Feb 01 20:14:43 2013 +0100
     1.2 +++ b/core.sql	Sat Feb 02 20:21:16 2013 +0100
     1.3 @@ -3158,6 +3158,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 @@ -3268,6 +3270,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  
     2.1 --- a/update/core-update.v2.1.0-v2.1.1.sql	Fri Feb 01 20:14:43 2013 +0100
     2.2 +++ b/update/core-update.v2.1.0-v2.1.1.sql	Sat Feb 02 20:21:16 2013 +0100
     2.3 @@ -112,6 +112,8 @@
     2.4            "i" := "i" + 1;
     2.5          END LOOP;
     2.6        END LOOP;
     2.7 +      UPDATE "initiative" SET "harmonic_weight" = 0
     2.8 +        WHERE "issue_id" = "issue_id_p" AND "harmonic_weight" ISNULL;
     2.9      END;
    2.10    $$;
    2.11  
    2.12 @@ -219,6 +221,8 @@
    2.13            "i" := "i" + 1;
    2.14          END LOOP;
    2.15        END LOOP;
    2.16 +      UPDATE "suggestion" SET "harmonic_weight" = 0
    2.17 +        WHERE "initiative_id" = "initiative_id_p" AND "harmonic_weight" ISNULL;
    2.18      END;
    2.19    $$;
    2.20  

Impressum / About Us