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;

Impressum / About Us