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,