# HG changeset patch
# User jbe
# Date 1359832876 -3600
# Node ID 727926e290e73055fcae3895d0dcb0fdf0648e9b
# Parent  3e450a518197d6eeacbe9f87201db66e3f9e7758
Set "harmonic_weight" to zero instead of null, where there are no supporters

diff -r 3e450a518197 -r 727926e290e7 core.sql
--- a/core.sql	Fri Feb 01 20:14:43 2013 +0100
+++ b/core.sql	Sat Feb 02 20:21:16 2013 +0100
@@ -3158,6 +3158,8 @@
           "i" := "i" + 1;
         END LOOP;
       END LOOP;
+      UPDATE "initiative" SET "harmonic_weight" = 0
+        WHERE "issue_id" = "issue_id_p" AND "harmonic_weight" ISNULL;
     END;
   $$;
 
@@ -3268,6 +3270,8 @@
           "i" := "i" + 1;
         END LOOP;
       END LOOP;
+      UPDATE "suggestion" SET "harmonic_weight" = 0
+        WHERE "initiative_id" = "initiative_id_p" AND "harmonic_weight" ISNULL;
     END;
   $$;
 
diff -r 3e450a518197 -r 727926e290e7 update/core-update.v2.1.0-v2.1.1.sql
--- a/update/core-update.v2.1.0-v2.1.1.sql	Fri Feb 01 20:14:43 2013 +0100
+++ b/update/core-update.v2.1.0-v2.1.1.sql	Sat Feb 02 20:21:16 2013 +0100
@@ -112,6 +112,8 @@
           "i" := "i" + 1;
         END LOOP;
       END LOOP;
+      UPDATE "initiative" SET "harmonic_weight" = 0
+        WHERE "issue_id" = "issue_id_p" AND "harmonic_weight" ISNULL;
     END;
   $$;
 
@@ -219,6 +221,8 @@
           "i" := "i" + 1;
         END LOOP;
       END LOOP;
+      UPDATE "suggestion" SET "harmonic_weight" = 0
+        WHERE "initiative_id" = "initiative_id_p" AND "harmonic_weight" ISNULL;
     END;
   $$;