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