liquid_feedback_core: 77d9eccc167c update/core-update.v1.2.6-v1.2.7.sql

liquid_feedback_core

Execute update script from v2.1.0 to v2.2.0 in isolation level REPEATABLE READ
as needed by function "set_harmonic_initiative_weights"

line source

1 BEGIN;

3 CREATE OR REPLACE VIEW "liquid_feedback_version" AS

4 SELECT * FROM (VALUES ('1.2.7', 1, 2, 7))

5 AS "subquery"("string", "major", "minor", "revision");

7 DROP VIEW "global_delegation";

9 CREATE VIEW "global_delegation" AS

10 SELECT "id", "truster_id", "trustee_id"

11 FROM "active_delegation" WHERE "scope" = 'global';

13 COMMIT;