liquid_feedback_core

diff core.sql @ 72:dcaa1525c388

find changesets by author, revision, files, or words in the commit message
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 5745db0b1a34
children 1d4c2f9ff9d8
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

Impressum / About Us