# HG changeset patch # User jbe # Date 1448985793 -3600 # Node ID 6cef981cdcdf90c3c0c45ff521082cec8a891cd2 # Parent 8730552eee9d5fa77c81bf188dc9387896de66cd Removed deprecated API tables diff -r 8730552eee9d -r 6cef981cdcdf core.sql --- a/core.sql Tue Dec 01 16:56:29 2015 +0100 +++ b/core.sql Tue Dec 01 17:03:13 2015 +0100 @@ -203,30 +203,6 @@ COMMENT ON COLUMN "member"."statement" IS 'Freely chosen text of the member for his/her profile'; --- DEPRECATED API TABLES -- - -CREATE TYPE "application_access_level" AS ENUM - ('member', 'full', 'pseudonymous', 'anonymous'); - -COMMENT ON TYPE "application_access_level" IS 'DEPRECATED, WILL BE REMOVED! Access privileges for applications using the API'; - - -CREATE TABLE "member_application" ( - "id" SERIAL8 PRIMARY KEY, - UNIQUE ("member_id", "name"), - "member_id" INT4 NOT NULL REFERENCES "member" ("id") - ON DELETE CASCADE ON UPDATE CASCADE, - "name" TEXT NOT NULL, - "comment" TEXT, - "access_level" "application_access_level" NOT NULL, - "key" TEXT NOT NULL UNIQUE, - "last_usage" TIMESTAMPTZ ); - -COMMENT ON TABLE "member_application" IS 'DEPRECATED, WILL BE REMOVED! Registered application being allowed to use the API'; - --- END OF DEPRECARED API TABLES -- - - CREATE TABLE "member_history" ( "id" SERIAL8 PRIMARY KEY, "member_id" INT4 NOT NULL REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE,