1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/update/core-update.v4.0.0-v4.0.1.sql	Mon Oct 02 19:38:04 2017 +0200
     1.3 @@ -0,0 +1,13 @@
     1.4 +BEGIN;
     1.5 +
     1.6 +CREATE OR REPLACE VIEW "liquid_feedback_version" AS
     1.7 +  SELECT * FROM (VALUES ('4.0.1', 4, 0, 1))
     1.8 +  AS "subquery"("string", "major", "minor", "revision");
     1.9 +
    1.10 +CREATE OR REPLACE VIEW "expired_token" AS
    1.11 +  SELECT * FROM "token" WHERE now() > "expiry" AND NOT (
    1.12 +    "token_type" = 'authorization' AND "used" AND EXISTS (
    1.13 +      SELECT NULL FROM "token" AS "other"
    1.14 +      WHERE "other"."authorization_token_id" = "token"."id" ) );
    1.15 +
    1.16 +COMMIT;