liquid_feedback_core
changeset 185:b0b7e0b18d78
New table "member_application" for API
author | jbe |
---|---|
date | Fri Jul 29 20:59:23 2011 +0200 (2011-07-29) |
parents | af3d208e81be |
children | 969ce2bea98c |
files | core.sql update/core-update.v1.4.0-v1.5.0.sql |
line diff
1.1 --- a/core.sql Fri Jul 29 20:26:45 2011 +0200 1.2 +++ b/core.sql Fri Jul 29 20:59:23 2011 +0200 1.3 @@ -164,6 +164,26 @@ 1.4 COMMENT ON COLUMN "member"."statement" IS 'Freely chosen text of the member for his homepage within the system'; 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 '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, 1.22 + "last_usage" TIMESTAMPTZ ); 1.23 + 1.24 +COMMENT ON TABLE "member_application" IS 'Registered application being allowed to use the API'; 1.25 + 1.26 + 1.27 CREATE TABLE "member_history" ( 1.28 "id" SERIAL8 PRIMARY KEY, 1.29 "member_id" INT4 NOT NULL REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
2.1 --- a/update/core-update.v1.4.0-v1.5.0.sql Fri Jul 29 20:26:45 2011 +0200 2.2 +++ b/update/core-update.v1.4.0-v1.5.0.sql Fri Jul 29 20:59:23 2011 +0200 2.3 @@ -21,6 +21,24 @@ 2.4 COMMENT ON COLUMN "member"."active" IS 'Memberships, support and votes are taken into account when corresponding members are marked as active. Automatically set to FALSE, if "last_activity" is older than "system_setting"."member_ttl".'; 2.5 COMMENT ON COLUMN "member"."formatting_engine" IS 'Allows different formatting engines (i.e. wiki formats) to be used for "member"."statement"'; 2.6 2.7 +CREATE TYPE "application_access_level" AS ENUM 2.8 + ('member', 'full', 'pseudonymous', 'anonymous'); 2.9 + 2.10 +COMMENT ON TYPE "application_access_level" IS 'Access privileges for applications using the API'; 2.11 + 2.12 +CREATE TABLE "member_application" ( 2.13 + "id" SERIAL8 PRIMARY KEY, 2.14 + UNIQUE ("member_id", "name"), 2.15 + "member_id" INT4 NOT NULL REFERENCES "member" ("id") 2.16 + ON DELETE CASCADE ON UPDATE CASCADE, 2.17 + "name" TEXT NOT NULL, 2.18 + "comment" TEXT, 2.19 + "access_level" "application_access_level" NOT NULL, 2.20 + "key" TEXT NOT NULL, 2.21 + "last_usage" TIMESTAMPTZ ); 2.22 + 2.23 +COMMENT ON TABLE "member_application" IS 'Registered application being allowed to use the API'; 2.24 + 2.25 CREATE TABLE "rendered_member_statement" ( 2.26 PRIMARY KEY ("member_id", "format"), 2.27 "member_id" INT8 REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE,