liquid_feedback_core

changeset 269:cbe1d7bb1d40

Added "parallel_access" and "old_refresh_token" to API tables
author jbe
date Wed Aug 08 16:57:52 2012 +0200 (2012-08-08)
parents 739ed2d3d372
children b555a544c724
files core.sql
line diff
     1.1 --- a/core.sql	Wed Aug 08 16:28:24 2012 +0200
     1.2 +++ b/core.sql	Wed Aug 08 16:57:52 2012 +0200
     1.3 @@ -185,6 +185,7 @@
     1.4          "member_authorization"  BOOLEAN         NOT NULL,
     1.5          "public_access_level"   "api_access_level",
     1.6          "access_level"          "api_access_level" NOT NULL,
     1.7 +        "parallel_access"       BOOLEAN         NOT NULL,
     1.8          "validity_period"       INTERVAL        NOT NULL,
     1.9          "last_usage"            TIMESTAMPTZ     NOT NULL,
    1.10          CONSTRAINT "public_access_level_set_if_and_only_if_system_client"
    1.11 @@ -201,7 +202,8 @@
    1.12  COMMENT ON COLUMN "api_client"."member_authorization" IS 'Allow OAuth2 Authorization Code Grant and Implicit Grant, in which case the "client_identifier" is used as the redirection endpoint';
    1.13  COMMENT ON COLUMN "api_client"."public_access_level"  IS 'Access level for OAuth2 Client Credentials Grant';
    1.14  COMMENT ON COLUMN "api_client"."access_level"         IS 'Access level for OAuth2 Authorization Code Grant and Implicit Grant';
    1.15 -COMMENT ON COLUMN "api_client"."validity_period"      IS 'Life time of an OAuth2 refresh token';
    1.16 +COMMENT ON COLUMN "api_client"."parallel_access"      IS 'Multiple entries in "api_access" table allowed';
    1.17 +COMMENT ON COLUMN "api_client"."validity_period"      IS 'Period after which an entry in the "api_access" table expires';
    1.18  
    1.19  
    1.20  CREATE TABLE "api_access" (
    1.21 @@ -214,6 +216,7 @@
    1.22          "authorization_code"    TEXT,
    1.23          "refreshed"             TIMESTAMPTZ,
    1.24          "refresh_token"         TEXT,
    1.25 +        "old_refresh_token"     TEXT,
    1.26          CONSTRAINT "one_of_authorization_code_and_refresh_token_set"
    1.27            CHECK ("authorization_code" NOTNULL OR "refresh_token" NOTNULL),
    1.28          CONSTRAINT "refresh_token_if_and_only_if_refreshed"

Impressum / About Us