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  

Impressum / About Us