annotate update/core-update.v4.0.0-v4.0.1.sql @ 574:2cb4a7d9e6e9
Bugfix in "expired_token" view: added missing qualifier to avoid authorization codes to be deleted when used
author |
jbe |
date |
Mon Oct 02 19:38:04 2017 +0200 (2017-10-02) |
parents |
|
children |
8771e783d898 |
rev |
line source |
jbe@574
|
1 BEGIN;
|
jbe@574
|
2
|
jbe@574
|
3 CREATE OR REPLACE VIEW "liquid_feedback_version" AS
|
jbe@574
|
4 SELECT * FROM (VALUES ('4.0.1', 4, 0, 1))
|
jbe@574
|
5 AS "subquery"("string", "major", "minor", "revision");
|
jbe@574
|
6
|
jbe@574
|
7 CREATE OR REPLACE VIEW "expired_token" AS
|
jbe@574
|
8 SELECT * FROM "token" WHERE now() > "expiry" AND NOT (
|
jbe@574
|
9 "token_type" = 'authorization' AND "used" AND EXISTS (
|
jbe@574
|
10 SELECT NULL FROM "token" AS "other"
|
jbe@574
|
11 WHERE "other"."authorization_token_id" = "token"."id" ) );
|
jbe@574
|
12
|
jbe@574
|
13 COMMIT;
|