Anonymous avatar Anonymous committed dcaa152

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

Comments (0)

Files changed (3)

 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");
 
 
 
 
 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';
 

update/core-update.v1.2.5-v1.2.6.sql

 
 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';
 

update/core-update.v1.2.6-v1.2.7.sql

+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;
Tip: Filter by directory path e.g. /media app.js to search for public/media/app.js.
Tip: Use camelCasing e.g. ProjME to search for ProjectModifiedEvent.java.
Tip: Filter by extension type e.g. /repo .js to search for all .js files in the /repo directory.
Tip: Separate your search with spaces e.g. /ssh pom.xml to search for src/ssh/pom.xml.
Tip: Use ↑ and ↓ arrow keys to navigate and return to view the file.
Tip: You can also navigate files with Ctrl+j (next) and Ctrl+k (previous) and view the file with Ctrl+o.
Tip: You can also navigate files with Alt+j (next) and Alt+k (previous) and view the file with Alt+o.