liquid_feedback_core
view 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 |
line source
1 BEGIN;
3 CREATE OR REPLACE VIEW "liquid_feedback_version" AS
4 SELECT * FROM (VALUES ('4.0.1', 4, 0, 1))
5 AS "subquery"("string", "major", "minor", "revision");
7 CREATE OR REPLACE VIEW "expired_token" AS
8 SELECT * FROM "token" WHERE now() > "expiry" AND NOT (
9 "token_type" = 'authorization' AND "used" AND EXISTS (
10 SELECT NULL FROM "token" AS "other"
11 WHERE "other"."authorization_token_id" = "token"."id" ) );
13 COMMIT;