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,

Impressum / About Us