liquid_feedback_core
diff core.sql @ 277:028a52d23e56
Marked API tables as preliminary
author | jbe |
---|---|
date | Fri Aug 10 16:50:14 2012 +0200 (2012-08-10) |
parents | b1360dc846be |
children | 0a42a2600a2b |
line diff
1.1 --- a/core.sql Fri Aug 10 15:00:07 2012 +0200 1.2 +++ b/core.sql Fri Aug 10 16:50:14 2012 +0200 1.3 @@ -173,6 +173,8 @@ 1.4 CREATE TYPE "api_access_level" AS ENUM ( 1.5 'none', 'anonymous', 'authors_pseudonymous', 'all_pseudonymous', 'everything', 'member' ); 1.6 1.7 +COMMENT ON TYPE "api_access_level" IS 'PRELIMINARY, SUBJECT TO CHANGE! Access scope for API consumers.'; 1.8 + 1.9 1.10 CREATE TABLE "api_client" ( 1.11 "id" SERIAL8 PRIMARY KEY, 1.12 @@ -201,7 +203,7 @@ 1.13 CREATE UNIQUE INDEX "api_client_non_member_client_identifier_idx" 1.14 ON "api_client" ("client_identifier") WHERE "member_id" ISNULL; 1.15 1.16 -COMMENT ON TABLE "api_client" IS 'Registered OAuth2 client for a member'; 1.17 +COMMENT ON TABLE "api_client" IS 'PRELIMINARY, SUBJECT TO CHANGE! Registered OAuth2 client for a member'; 1.18 1.19 COMMENT ON COLUMN "api_client"."name" IS 'Name of the client as chosen by member or administrator, NULL is allowed for unnamed member-registered clients'; 1.20 COMMENT ON COLUMN "api_client"."member_id" IS 'Member, who registered the client for him/herself, or NULL for clients registered by administrator'; 1.21 @@ -237,7 +239,7 @@ 1.22 CONSTRAINT "old_refresh_token_requires_current_refresh_token" 1.23 CHECK ("refresh_token" NOTNULL OR "old_refresh_token" ISNULL) ); 1.24 1.25 -COMMENT ON TABLE "api_code_grant" IS 'Issued OAuth2 authorization codes and refresh tokens'; 1.26 +COMMENT ON TABLE "api_code_grant" IS 'PRELIMINARY, SUBJECT TO CHANGE! Issued OAuth2 authorization codes and refresh tokens'; 1.27 1.28 COMMENT ON COLUMN "api_code_grant"."validity_period" IS 'Period after which no more refreshing is possible'; 1.29 COMMENT ON COLUMN "api_code_grant"."created" IS 'Date/time when authorization code (or first refresh token when there is no authorization code) has been created';