From 65355627ca6810ae43f7364255b93a772b3cb567 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Mon, 15 Aug 2022 14:36:38 -0400 Subject: [PATCH] remove extra OpenAthens file --- Open-ILS/src/sql/Pg/450.schema.openathens.sql | 53 --------------------------- 1 file changed, 53 deletions(-) delete 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 deleted file mode 100644 index b3f02ffb98..0000000000 --- a/Open-ILS/src/sql/Pg/450.schema.openathens.sql +++ /dev/null @@ -1,53 +0,0 @@ -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; -- 2.11.0