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"