# HG changeset patch
# User jbe
# Date 1448985389 -3600
# Node ID 8730552eee9d5fa77c81bf188dc9387896de66cd
# Parent  78e9a2071b0cb109ac70ff724720d311d6258e65
Re-added removed deprecated API tables (already accidentally removed in previous commit)

diff -r 78e9a2071b0c -r 8730552eee9d core.sql
--- a/core.sql	Fri Nov 27 01:31:37 2015 +0100
+++ b/core.sql	Tue Dec 01 16:56:29 2015 +0100
@@ -203,6 +203,30 @@
 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,