liquid_feedback_core

changeset 72:dcaa1525c388 v1.2.7

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
author jbe
date Mon Aug 30 23:49:32 2010 +0200 (2010-08-30)
parents 7626e290d537
children b95f2b9cb144
files core.sql update/core-update.v1.2.5-v1.2.6.sql update/core-update.v1.2.6-v1.2.7.sql
line diff
     1.1 --- a/core.sql	Mon Aug 30 22:45:50 2010 +0200
     1.2 +++ b/core.sql	Mon Aug 30 23:49:32 2010 +0200
     1.3 @@ -6,7 +6,7 @@
     1.4  BEGIN;
     1.5  
     1.6  CREATE VIEW "liquid_feedback_version" AS
     1.7 -  SELECT * FROM (VALUES ('1.2.6', 1, 2, 6))
     1.8 +  SELECT * FROM (VALUES ('1.2.7', 1, 2, 7))
     1.9    AS "subquery"("string", "major", "minor", "revision");
    1.10  
    1.11  
    1.12 @@ -1265,7 +1265,8 @@
    1.13  
    1.14  
    1.15  CREATE VIEW "global_delegation" AS
    1.16 -  SELECT * FROM "active_delegation" WHERE "scope" = 'global';
    1.17 +  SELECT "id", "truster_id", "trustee_id"
    1.18 +  FROM "active_delegation" WHERE "scope" = 'global';
    1.19  
    1.20  COMMENT ON VIEW "global_delegation" IS 'Global delegations from active members';
    1.21  
     2.1 --- a/update/core-update.v1.2.5-v1.2.6.sql	Mon Aug 30 22:45:50 2010 +0200
     2.2 +++ b/update/core-update.v1.2.5-v1.2.6.sql	Mon Aug 30 23:49:32 2010 +0200
     2.3 @@ -11,7 +11,9 @@
     2.4  
     2.5  COMMENT ON VIEW "active_delegation" IS 'Delegations where the truster_id refers to an active member';
     2.6  
     2.7 -CREATE OR REPLACE VIEW "global_delegation" AS
     2.8 +DROP VIEW "global_delegation";
     2.9 +
    2.10 +CREATE VIEW "global_delegation" AS
    2.11    SELECT * FROM "active_delegation"
    2.12    WHERE "scope" = 'global';
    2.13  
     3.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     3.2 +++ b/update/core-update.v1.2.6-v1.2.7.sql	Mon Aug 30 23:49:32 2010 +0200
     3.3 @@ -0,0 +1,13 @@
     3.4 +BEGIN;
     3.5 + 
     3.6 +CREATE OR REPLACE VIEW "liquid_feedback_version" AS
     3.7 +  SELECT * FROM (VALUES ('1.2.7', 1, 2, 7))
     3.8 +  AS "subquery"("string", "major", "minor", "revision");
     3.9 +
    3.10 +DROP VIEW "global_delegation";
    3.11 +
    3.12 +CREATE VIEW "global_delegation" AS
    3.13 +  SELECT "id", "truster_id", "trustee_id"
    3.14 +  FROM "active_delegation" WHERE "scope" = 'global';
    3.15 +
    3.16 +COMMIT;

Impressum / About Us