liquid_feedback_core

changeset 449:6cef981cdcdf

Removed deprecated API tables
author jbe
date Tue Dec 01 17:03:13 2015 +0100 (2015-12-01)
parents 8730552eee9d
children 4434b4d69def
files core.sql
line diff
     1.1 --- a/core.sql	Tue Dec 01 16:56:29 2015 +0100
     1.2 +++ b/core.sql	Tue Dec 01 17:03:13 2015 +0100
     1.3 @@ -203,30 +203,6 @@
     1.4  COMMENT ON COLUMN "member"."statement"            IS 'Freely chosen text of the member for his/her profile';
     1.5  
     1.6  
     1.7 --- DEPRECATED API TABLES --
     1.8 -
     1.9 -CREATE TYPE "application_access_level" AS ENUM
    1.10 -  ('member', 'full', 'pseudonymous', 'anonymous');
    1.11 -
    1.12 -COMMENT ON TYPE "application_access_level" IS 'DEPRECATED, WILL BE REMOVED! Access privileges for applications using the API';
    1.13 -
    1.14 -
    1.15 -CREATE TABLE "member_application" (
    1.16 -        "id"                    SERIAL8         PRIMARY KEY,
    1.17 -        UNIQUE ("member_id", "name"),
    1.18 -        "member_id"             INT4            NOT NULL REFERENCES "member" ("id")
    1.19 -                                                ON DELETE CASCADE ON UPDATE CASCADE,
    1.20 -        "name"                  TEXT            NOT NULL,
    1.21 -        "comment"               TEXT,
    1.22 -        "access_level" "application_access_level" NOT NULL,
    1.23 -        "key"                   TEXT            NOT NULL UNIQUE,
    1.24 -        "last_usage"            TIMESTAMPTZ );
    1.25 -
    1.26 -COMMENT ON TABLE "member_application" IS 'DEPRECATED, WILL BE REMOVED! Registered application being allowed to use the API';
    1.27 -
    1.28 --- END OF DEPRECARED API TABLES --
    1.29 -
    1.30 -
    1.31  CREATE TABLE "member_history" (
    1.32          "id"                    SERIAL8         PRIMARY KEY,
    1.33          "member_id"             INT4            NOT NULL REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE,

Impressum / About Us