liquid_feedback_core
changeset 617:8e9d0878b5dc
Bugfix in function "featured_initiative" regarding reference to "issue_privilege" instead of "privilege"
| author | jbe |
|---|---|
| date | Mon Oct 05 16:18:17 2020 +0200 (2020-10-05) |
| parents | ae53fc96c953 |
| children | 5b3b20f1278d |
| files | core.sql update/core-update.v4.2.0-v4.2.1.sql |
line diff
1.1 --- a/core.sql Tue Jul 28 18:57:20 2020 +0200 1.2 +++ b/core.sql Mon Oct 05 16:18:17 2020 +0200 1.3 @@ -4174,8 +4174,8 @@ 1.4 "privilege"."member_id" = "recipient_id_p" AND 1.5 "privilege"."unit_id" = "area"."unit_id" 1.6 LEFT JOIN "issue_privilege" ON 1.7 - "privilege"."member_id" = "recipient_id_p" AND 1.8 - "privilege"."issue_id" = "initiative"."issue_id" 1.9 + "issue_privilege"."member_id" = "recipient_id_p" AND 1.10 + "issue_privilege"."issue_id" = "initiative"."issue_id" 1.11 LEFT JOIN "subscription" ON 1.12 "subscription"."member_id" = "recipient_id_p" AND 1.13 "subscription"."unit_id" = "area"."unit_id"
2.1 --- a/update/core-update.v4.2.0-v4.2.1.sql Tue Jul 28 18:57:20 2020 +0200 2.2 +++ b/update/core-update.v4.2.0-v4.2.1.sql Mon Oct 05 16:18:17 2020 +0200 2.3 @@ -184,8 +184,8 @@ 2.4 "privilege"."member_id" = "recipient_id_p" AND 2.5 "privilege"."unit_id" = "area"."unit_id" 2.6 LEFT JOIN "issue_privilege" ON 2.7 - "privilege"."member_id" = "recipient_id_p" AND 2.8 - "privilege"."issue_id" = "initiative"."issue_id" 2.9 + "issue_privilege"."member_id" = "recipient_id_p" AND 2.10 + "issue_privilege"."issue_id" = "initiative"."issue_id" 2.11 LEFT JOIN "subscription" ON 2.12 "subscription"."member_id" = "recipient_id_p" AND 2.13 "subscription"."unit_id" = "area"."unit_id"