liquid_feedback_core
changeset 278:0a42a2600a2b
Included old API tables maked as "deprecated" to allow testing with alpha api and preliminary authorization interface after core update to v2.1
author | jbe |
---|---|
date | Fri Aug 10 21:39:50 2012 +0200 (2012-08-10) |
parents | 028a52d23e56 |
children | 03897de17853 |
files | core.sql |
line diff
1.1 --- a/core.sql Fri Aug 10 16:50:14 2012 +0200 1.2 +++ b/core.sql Fri Aug 10 21:39:50 2012 +0200 1.3 @@ -170,6 +170,26 @@ 1.4 COMMENT ON COLUMN "member"."statement" IS 'Freely chosen text of the member for his/her profile'; 1.5 1.6 1.7 +CREATE TYPE "application_access_level" AS ENUM 1.8 + ('member', 'full', 'pseudonymous', 'anonymous'); 1.9 + 1.10 +COMMENT ON TYPE "application_access_level" IS 'DEPRECATED, WILL BE REMOVED! Access privileges for applications using the API'; 1.11 + 1.12 + 1.13 +CREATE TABLE "member_application" ( 1.14 + "id" SERIAL8 PRIMARY KEY, 1.15 + UNIQUE ("member_id", "name"), 1.16 + "member_id" INT4 NOT NULL REFERENCES "member" ("id") 1.17 + ON DELETE CASCADE ON UPDATE CASCADE, 1.18 + "name" TEXT NOT NULL, 1.19 + "comment" TEXT, 1.20 + "access_level" "application_access_level" NOT NULL, 1.21 + "key" TEXT NOT NULL UNIQUE, 1.22 + "last_usage" TIMESTAMPTZ ); 1.23 + 1.24 +COMMENT ON TABLE "member_application" IS 'DEPRECATED, WILL BE REMOVED! Registered application being allowed to use the API'; 1.25 + 1.26 + 1.27 CREATE TYPE "api_access_level" AS ENUM ( 1.28 'none', 'anonymous', 'authors_pseudonymous', 'all_pseudonymous', 'everything', 'member' ); 1.29