# HG changeset patch
# User jbe
# Date 1459806922 -7200
# Node ID f39c673420cbd715928e4f32578cfb14a0d5f7c0
# Parent  4a8d9f00867bab88e9084acde108ee771f3d1fc0
Use "supporter_count" instead of "harmonic_weight" to determine leading initiative for notification system

diff -r 4a8d9f00867b -r f39c673420cb core.sql
--- a/core.sql	Mon Apr 04 18:51:13 2016 +0200
+++ b/core.sql	Mon Apr 04 23:55:22 2016 +0200
@@ -2503,9 +2503,9 @@
       SELECT NULL FROM "initiative" AS "better_initiative"
       WHERE "better_initiative"."issue_id" = "initiative"."issue_id"
       AND
-        ( COALESCE("better_initiative"."harmonic_weight", -1),
+        ( COALESCE("better_initiative"."supporter_count", -1),
           -"better_initiative"."id" ) >
-        ( COALESCE("initiative"."harmonic_weight", -1),
+        ( COALESCE("initiative"."supporter_count", -1),
           -"initiative"."id" )
     ) AS "leading"
   FROM (
@@ -2537,7 +2537,7 @@
     ORDER BY
       "uf_initiative"."recipient_id",
       "initiative"."issue_id",
-      "initiative"."harmonic_weight" DESC,
+      "initiative"."supporter_count" DESC,
       "initiative"."id"
   ) AS "subquery"
   WHERE NOT EXISTS (
diff -r 4a8d9f00867b -r f39c673420cb update/core-update.v3.1.0-v3.2.0.sql
--- a/update/core-update.v3.1.0-v3.2.0.sql	Mon Apr 04 18:51:13 2016 +0200
+++ b/update/core-update.v3.1.0-v3.2.0.sql	Mon Apr 04 23:55:22 2016 +0200
@@ -222,9 +222,9 @@
       SELECT NULL FROM "initiative" AS "better_initiative"
       WHERE "better_initiative"."issue_id" = "initiative"."issue_id"
       AND
-        ( COALESCE("better_initiative"."harmonic_weight", -1),
+        ( COALESCE("better_initiative"."supporter_count", -1),
           -"better_initiative"."id" ) >
-        ( COALESCE("initiative"."harmonic_weight", -1),
+        ( COALESCE("initiative"."supporter_count", -1),
           -"initiative"."id" )
     ) AS "leading"
   FROM (
@@ -256,7 +256,7 @@
     ORDER BY
       "uf_initiative"."recipient_id",
       "initiative"."issue_id",
-      "initiative"."harmonic_weight" DESC,
+      "initiative"."supporter_count" DESC,
       "initiative"."id"
   ) AS "subquery"
   WHERE NOT EXISTS (