liquid_feedback_core
changeset 448:8730552eee9d
Re-added removed deprecated API tables (already accidentally removed in previous commit)
author | jbe |
---|---|
date | Tue Dec 01 16:56:29 2015 +0100 (2015-12-01) |
parents | 78e9a2071b0c |
children | 6cef981cdcdf |
files | core.sql |
line diff
1.1 --- a/core.sql Fri Nov 27 01:31:37 2015 +0100 1.2 +++ b/core.sql Tue Dec 01 16:56:29 2015 +0100 1.3 @@ -203,6 +203,30 @@ 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,