From 59dad1046c31bf378d0fcc3ee357f239b7788010 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Wed, 23 Nov 2022 10:05:37 -0500 Subject: [PATCH] SQL: remove OpenAthens installation --- .../Pg/version-upgrade/3.9.1-3.10.0-upgrade-db.sql | 108 ++++++++++----------- 1 file changed, 54 insertions(+), 54 deletions(-) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/3.9.1-3.10.0-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/3.9.1-3.10.0-upgrade-db.sql index 925c271306..2bc40b5aff 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/3.9.1-3.10.0-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/3.9.1-3.10.0-upgrade-db.sql @@ -18,60 +18,60 @@ VALUES ( SELECT evergreen.upgrade_deps_block_check('1329', :eg_version); -CREATE TABLE config.openathens_uid_field ( - id SERIAL PRIMARY KEY, - name TEXT NOT NULL -); - -INSERT INTO config.openathens_uid_field - (id, name) -VALUES - (1,'id'), - (2,'usrname') -; - -SELECT SETVAL('config.openathens_uid_field_id_seq'::TEXT, 100); - -CREATE TABLE config.openathens_name_field ( - id SERIAL PRIMARY KEY, - name TEXT NOT NULL -); - -INSERT INTO config.openathens_name_field - (id, name) -VALUES - (1,'id'), - (2,'usrname'), - (3,'fullname') -; - -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, - release_barcode BOOL NOT NULL DEFAULT false -); - - -INSERT INTO permission.perm_list ( id, code, description) VALUES - ( 639, 'ADMIN_OPENATHENS', oils_i18n_gettext(639, - 'Allow a user to administer OpenAthens authentication service', 'ppl', 'description')); +--CREATE TABLE config.openathens_uid_field ( +-- id SERIAL PRIMARY KEY, +-- name TEXT NOT NULL +--); +-- +--INSERT INTO config.openathens_uid_field +-- (id, name) +--VALUES +-- (1,'id'), +-- (2,'usrname') +--; +-- +--SELECT SETVAL('config.openathens_uid_field_id_seq'::TEXT, 100); +-- +--CREATE TABLE config.openathens_name_field ( +-- id SERIAL PRIMARY KEY, +-- name TEXT NOT NULL +--); +-- +--INSERT INTO config.openathens_name_field +-- (id, name) +--VALUES +-- (1,'id'), +-- (2,'usrname'), +-- (3,'fullname') +--; +-- +--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, +-- release_barcode BOOL NOT NULL DEFAULT false +--); +-- +-- +--INSERT INTO permission.perm_list ( id, code, description) VALUES +-- ( 639, 'ADMIN_OPENATHENS', oils_i18n_gettext(639, +-- 'Allow a user to administer OpenAthens authentication service', 'ppl', 'description')); -- 2.11.0