# HG changeset patch
# User jbe
# Date 1283204972 -7200
# Node ID dcaa1525c38812eae0a0615b1217ac3bd9c63fa2
# Parent  7626e290d53774851846d327a4e30c637cbf01f4
Removed unintentionally inserted extra columns in view "global_delegation" in previous commit; Update script from v1.2.5 to v1.2.6 also works with PostgreSQL 8.3 now; Update script from v1.2.6 to v1.2.7 added

diff -r 7626e290d537 -r dcaa1525c388 core.sql
--- a/core.sql	Mon Aug 30 22:45:50 2010 +0200
+++ b/core.sql	Mon Aug 30 23:49:32 2010 +0200
@@ -6,7 +6,7 @@
 BEGIN;
 
 CREATE VIEW "liquid_feedback_version" AS
-  SELECT * FROM (VALUES ('1.2.6', 1, 2, 6))
+  SELECT * FROM (VALUES ('1.2.7', 1, 2, 7))
   AS "subquery"("string", "major", "minor", "revision");
 
 
@@ -1265,7 +1265,8 @@
 
 
 CREATE VIEW "global_delegation" AS
-  SELECT * FROM "active_delegation" WHERE "scope" = 'global';
+  SELECT "id", "truster_id", "trustee_id"
+  FROM "active_delegation" WHERE "scope" = 'global';
 
 COMMENT ON VIEW "global_delegation" IS 'Global delegations from active members';
 
diff -r 7626e290d537 -r dcaa1525c388 update/core-update.v1.2.5-v1.2.6.sql
--- a/update/core-update.v1.2.5-v1.2.6.sql	Mon Aug 30 22:45:50 2010 +0200
+++ b/update/core-update.v1.2.5-v1.2.6.sql	Mon Aug 30 23:49:32 2010 +0200
@@ -11,7 +11,9 @@
 
 COMMENT ON VIEW "active_delegation" IS 'Delegations where the truster_id refers to an active member';
 
-CREATE OR REPLACE VIEW "global_delegation" AS
+DROP VIEW "global_delegation";
+
+CREATE VIEW "global_delegation" AS
   SELECT * FROM "active_delegation"
   WHERE "scope" = 'global';
 
diff -r 7626e290d537 -r dcaa1525c388 update/core-update.v1.2.6-v1.2.7.sql
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/update/core-update.v1.2.6-v1.2.7.sql	Mon Aug 30 23:49:32 2010 +0200
@@ -0,0 +1,13 @@
+BEGIN;
+ 
+CREATE OR REPLACE VIEW "liquid_feedback_version" AS
+  SELECT * FROM (VALUES ('1.2.7', 1, 2, 7))
+  AS "subquery"("string", "major", "minor", "revision");
+
+DROP VIEW "global_delegation";
+
+CREATE VIEW "global_delegation" AS
+  SELECT "id", "truster_id", "trustee_id"
+  FROM "active_delegation" WHERE "scope" = 'global';
+
+COMMIT;