From df43573960f891552c3d52486b0667e66bbca4f7 Mon Sep 17 00:00:00 2001
From: Chris Sharp <csharp@georgialibraries.org>
Date: Wed, 17 Feb 2021 10:13:30 -0500
Subject: [PATCH] add OpenAthens to stock PINES database

---
 Open-ILS/src/sql/Pg/450.schema.openathens.sql | 53 +++++++++++++++++++++++++++
 Open-ILS/src/sql/Pg/sql_file_manifest         |  1 +
 2 files changed, 54 insertions(+)
 create mode 100644 Open-ILS/src/sql/Pg/450.schema.openathens.sql

diff --git a/Open-ILS/src/sql/Pg/450.schema.openathens.sql b/Open-ILS/src/sql/Pg/450.schema.openathens.sql
new file mode 100644
index 0000000000..b3f02ffb98
--- /dev/null
+++ b/Open-ILS/src/sql/Pg/450.schema.openathens.sql
@@ -0,0 +1,53 @@
+BEGIN;
+
+CREATE TABLE config.openathens_uid_field (
+    id      SERIAL  PRIMARY KEY,
+    name    TEXT    NOT NULL
+);
+
+SELECT SETVAL('config.openathens_uid_field_id_seq'::TEXT, 100);
+
+CREATE TABLE config.openathens_name_field (
+    id      SERIAL  PRIMARY KEY,
+    name    TEXT    NOT NULL
+);
+
+SELECT SETVAL('config.openathens_name_field_id_seq'::TEXT, 100);
+
+CREATE TABLE config.openathens_identity (
+    id                          SERIAL  PRIMARY KEY,
+    active                      BOOL    NOT NULL DEFAULT true,
+    org_unit                    INT     NOT NULL REFERENCES actor.org_unit (id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED,
+    api_key                     TEXT    NOT NULL,
+    connection_id               TEXT    NOT NULL,
+    connection_uri              TEXT    NOT NULL,
+    auto_signon_enabled         BOOL    NOT NULL DEFAULT true,
+    auto_signout_enabled        BOOL    NOT NULL DEFAULT false,
+    unique_identifier           INT     NOT NULL REFERENCES config.openathens_uid_field (id) DEFAULT 1,
+    display_name                INT     NOT NULL REFERENCES config.openathens_name_field (id) DEFAULT 1,
+    release_prefix              BOOL    NOT NULL DEFAULT false,
+    release_first_given_name    BOOL    NOT NULL DEFAULT false,
+    release_second_given_name   BOOL    NOT NULL DEFAULT false,
+    release_family_name         BOOL    NOT NULL DEFAULT false,
+    release_suffix              BOOL    NOT NULL DEFAULT false,
+    release_email               BOOL    NOT NULL DEFAULT false,
+    release_home_ou             BOOL    NOT NULL DEFAULT false
+);
+
+
+INSERT INTO config.openathens_uid_field
+    (id, name)
+VALUES
+    (1,'id'),
+    (2,'usrname')
+;
+
+INSERT INTO config.openathens_name_field
+    (id, name)
+VALUES
+    (1,'id'),
+    (2,'usrname'),
+    (3,'fullname')
+;
+
+COMMIT;
diff --git a/Open-ILS/src/sql/Pg/sql_file_manifest b/Open-ILS/src/sql/Pg/sql_file_manifest
index e4f9152166..a8f1d16b6e 100644
--- a/Open-ILS/src/sql/Pg/sql_file_manifest
+++ b/Open-ILS/src/sql/Pg/sql_file_manifest
@@ -46,6 +46,7 @@ FTS_CONFIG_FILE
 
 300.schema.staged_search.sql
 400.schema.action_trigger.sql
+450.schema.openathens.sql
 
 500.view.cross-schema.sql
 
-- 
2.11.0