liquid_feedback_core
changeset 485:e431f1b73c35
Fixed further mistake in views "updated_initiative" and "updated_or_featured_initiative"
author | jbe |
---|---|
date | Fri Apr 01 17:30:08 2016 +0200 (2016-04-01) |
parents | d264e48cffbf |
children | 9aa403a05261 |
files | core.sql update/core-update.v3.1.0-v3.2.0.sql |
line diff
1.1 --- a/core.sql Fri Apr 01 17:24:32 2016 +0200 1.2 +++ b/core.sql Fri Apr 01 17:30:08 2016 +0200 1.3 @@ -2408,7 +2408,7 @@ 1.4 ( COALESCE("better_initiative"."harmonic_weight", -1), 1.5 -"better_initiative"."id" ) > 1.6 ( COALESCE("initiative"."harmonic_weight", -1), 1.7 - -"better_initiative"."id" ) 1.8 + -"initiative"."id" ) 1.9 ) AS "leading", 1.10 "initiative".* 1.11 FROM "member" CROSS JOIN "initiative" 1.12 @@ -2510,7 +2510,7 @@ 1.13 ( COALESCE("better_initiative"."harmonic_weight", -1), 1.14 -"better_initiative"."id" ) > 1.15 ( COALESCE("initiative"."harmonic_weight", -1), 1.16 - -"better_initiative"."id" ) 1.17 + -"initiative"."id" ) 1.18 ) AS "leading", 1.19 "initiative".* 1.20 FROM "member" CROSS JOIN "area"
2.1 --- a/update/core-update.v3.1.0-v3.2.0.sql Fri Apr 01 17:24:32 2016 +0200 2.2 +++ b/update/core-update.v3.1.0-v3.2.0.sql Fri Apr 01 17:30:08 2016 +0200 2.3 @@ -51,7 +51,7 @@ 2.4 ( COALESCE("better_initiative"."harmonic_weight", -1), 2.5 -"better_initiative"."id" ) > 2.6 ( COALESCE("initiative"."harmonic_weight", -1), 2.7 - -"better_initiative"."id" ) 2.8 + -"initiative"."id" ) 2.9 ) AS "leading", 2.10 "initiative".* 2.11 FROM "member" CROSS JOIN "initiative" 2.12 @@ -153,7 +153,7 @@ 2.13 ( COALESCE("better_initiative"."harmonic_weight", -1), 2.14 -"better_initiative"."id" ) > 2.15 ( COALESCE("initiative"."harmonic_weight", -1), 2.16 - -"better_initiative"."id" ) 2.17 + -"initiative"."id" ) 2.18 ) AS "leading", 2.19 "initiative".* 2.20 FROM "member" CROSS JOIN "area"