# HG changeset patch # User jbe # Date 1459524608 -7200 # Node ID e431f1b73c358fe79d28896d1c0707d34547336d # Parent d264e48cffbffbdf650e19f9489881650c21b55d Fixed further mistake in views "updated_initiative" and "updated_or_featured_initiative" diff -r d264e48cffbf -r e431f1b73c35 core.sql --- a/core.sql Fri Apr 01 17:24:32 2016 +0200 +++ b/core.sql Fri Apr 01 17:30:08 2016 +0200 @@ -2408,7 +2408,7 @@ ( COALESCE("better_initiative"."harmonic_weight", -1), -"better_initiative"."id" ) > ( COALESCE("initiative"."harmonic_weight", -1), - -"better_initiative"."id" ) + -"initiative"."id" ) ) AS "leading", "initiative".* FROM "member" CROSS JOIN "initiative" @@ -2510,7 +2510,7 @@ ( COALESCE("better_initiative"."harmonic_weight", -1), -"better_initiative"."id" ) > ( COALESCE("initiative"."harmonic_weight", -1), - -"better_initiative"."id" ) + -"initiative"."id" ) ) AS "leading", "initiative".* FROM "member" CROSS JOIN "area" diff -r d264e48cffbf -r e431f1b73c35 update/core-update.v3.1.0-v3.2.0.sql --- a/update/core-update.v3.1.0-v3.2.0.sql Fri Apr 01 17:24:32 2016 +0200 +++ b/update/core-update.v3.1.0-v3.2.0.sql Fri Apr 01 17:30:08 2016 +0200 @@ -51,7 +51,7 @@ ( COALESCE("better_initiative"."harmonic_weight", -1), -"better_initiative"."id" ) > ( COALESCE("initiative"."harmonic_weight", -1), - -"better_initiative"."id" ) + -"initiative"."id" ) ) AS "leading", "initiative".* FROM "member" CROSS JOIN "initiative" @@ -153,7 +153,7 @@ ( COALESCE("better_initiative"."harmonic_weight", -1), -"better_initiative"."id" ) > ( COALESCE("initiative"."harmonic_weight", -1), - -"better_initiative"."id" ) + -"initiative"."id" ) ) AS "leading", "initiative".* FROM "member" CROSS JOIN "area"