# HG changeset patch
# User jbe
# Date 1283198468 -7200
# Node ID c65002c1a509a4c4dcf5cf5915a898cb690643a3
# Parent  28c1af992cd385c4ad5e3d131fa5dcd158f80b72
Important bugfix, affecting correct counting of supporters/votes

Changed "trustee_id" to "truster_id" in following views:
- global_delegation
- area_delegation
- issue_delegation

Also updated comments for that views.

The new behaviour was expected by the following functions:
- membership_weight_with_skipping
- weight_of_added_delegations_for_population_snapshot
- weight_of_added_delegations_for_interest_snapshot
- weight_of_added_vote_delegations

The bug caused inactive members to falsely increase voting weight of trustees.

diff -r 28c1af992cd3 -r c65002c1a509 core.sql
--- a/core.sql	Mon Aug 16 14:45:28 2010 +0200
+++ b/core.sql	Mon Aug 30 22:01:08 2010 +0200
@@ -6,7 +6,7 @@
 BEGIN;
 
 CREATE VIEW "liquid_feedback_version" AS
-  SELECT * FROM (VALUES ('1.2.5', 1, 2, 5))
+  SELECT * FROM (VALUES ('1.2.6', 1, 2, 6))
   AS "subquery"("string", "major", "minor", "revision");
 
 
@@ -1262,10 +1262,10 @@
     "delegation"."truster_id",
     "delegation"."trustee_id"
   FROM "delegation" JOIN "member"
-  ON "delegation"."trustee_id" = "member"."id"
+  ON "delegation"."truster_id" = "member"."id"
   WHERE "delegation"."scope" = 'global' AND "member"."active";
 
-COMMENT ON VIEW "global_delegation" IS 'Global delegations to active members';
+COMMENT ON VIEW "global_delegation" IS 'Global delegations from active members';
 
 
 CREATE VIEW "area_delegation" AS
@@ -1284,7 +1284,7 @@
       "delegation"."truster_id",
       "delegation"."scope" DESC
   ) AS "subquery"
-  JOIN "member" ON "subquery"."trustee_id" = "member"."id"
+  JOIN "member" ON "subquery"."truster_id" = "member"."id"
   WHERE "member"."active";
 
 COMMENT ON VIEW "area_delegation" IS 'Active delegations for areas';
@@ -1307,7 +1307,7 @@
       "delegation"."truster_id",
       "delegation"."scope" DESC
   ) AS "subquery"
-  JOIN "member" ON "subquery"."trustee_id" = "member"."id"
+  JOIN "member" ON "subquery"."truster_id" = "member"."id"
   WHERE "member"."active";
 
 COMMENT ON VIEW "issue_delegation" IS 'Active delegations for issues';