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;