liquid_feedback_core
changeset 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 | abf04224f1e1 |
children | 8771e783d898 |
files | core.sql update/core-update.v4.0.0-v4.0.1.sql |
line diff
1.1 --- a/core.sql Fri Sep 29 22:36:20 2017 +0200 1.2 +++ b/core.sql Mon Oct 02 19:38:04 2017 +0200 1.3 @@ -6,7 +6,7 @@ 1.4 CREATE EXTENSION IF NOT EXISTS latlon; -- load pgLatLon extenstion 1.5 1.6 CREATE VIEW "liquid_feedback_version" AS 1.7 - SELECT * FROM (VALUES ('4.0.0', 4, 0, 0)) 1.8 + SELECT * FROM (VALUES ('4.0-dev', 4, 0, -1)) 1.9 AS "subquery"("string", "major", "minor", "revision"); 1.10 1.11 1.12 @@ -3633,7 +3633,7 @@ 1.13 SELECT * FROM "token" WHERE now() > "expiry" AND NOT ( 1.14 "token_type" = 'authorization' AND "used" AND EXISTS ( 1.15 SELECT NULL FROM "token" AS "other" 1.16 - WHERE "other"."authorization_token_id" = "id" ) ); 1.17 + WHERE "other"."authorization_token_id" = "token"."id" ) ); 1.18 1.19 CREATE RULE "delete" AS ON DELETE TO "expired_token" DO INSTEAD 1.20 DELETE FROM "token" WHERE "id" = OLD."id";
2.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000 2.2 +++ b/update/core-update.v4.0.0-v4.0.1.sql Mon Oct 02 19:38:04 2017 +0200 2.3 @@ -0,0 +1,13 @@ 2.4 +BEGIN; 2.5 + 2.6 +CREATE OR REPLACE VIEW "liquid_feedback_version" AS 2.7 + SELECT * FROM (VALUES ('4.0.1', 4, 0, 1)) 2.8 + AS "subquery"("string", "major", "minor", "revision"); 2.9 + 2.10 +CREATE OR REPLACE VIEW "expired_token" AS 2.11 + SELECT * FROM "token" WHERE now() > "expiry" AND NOT ( 2.12 + "token_type" = 'authorization' AND "used" AND EXISTS ( 2.13 + SELECT NULL FROM "token" AS "other" 2.14 + WHERE "other"."authorization_token_id" = "token"."id" ) ); 2.15 + 2.16 +COMMIT;