liquid_feedback_core
view update/core-update.v1.2.6-v1.2.7.sql @ 478:2f79434d0226
Added preliminary update script
| author | jbe | 
|---|---|
| date | Thu Mar 31 20:35:10 2016 +0200 (2016-03-31) | 
| parents | dcaa1525c388 | 
| children | 
 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;
