liquid_feedback_core
diff update/core-update.v1.2.5-v1.2.6.sql @ 72:dcaa1525c388
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 |
line diff
1.1 --- a/update/core-update.v1.2.5-v1.2.6.sql Mon Aug 30 22:45:50 2010 +0200 1.2 +++ b/update/core-update.v1.2.5-v1.2.6.sql Mon Aug 30 23:49:32 2010 +0200 1.3 @@ -11,7 +11,9 @@ 1.4 1.5 COMMENT ON VIEW "active_delegation" IS 'Delegations where the truster_id refers to an active member'; 1.6 1.7 -CREATE OR REPLACE VIEW "global_delegation" AS 1.8 +DROP VIEW "global_delegation"; 1.9 + 1.10 +CREATE VIEW "global_delegation" AS 1.11 SELECT * FROM "active_delegation" 1.12 WHERE "scope" = 'global'; 1.13