3 SELECT evergreen.upgrade_deps_block_check('1329', :eg_version);
5 CREATE TABLE config.openathens_uid_field (
10 INSERT INTO config.openathens_uid_field
17 SELECT SETVAL('config.openathens_uid_field_id_seq'::TEXT, 100);
19 CREATE TABLE config.openathens_name_field (
20 id SERIAL PRIMARY KEY,
24 INSERT INTO config.openathens_name_field
32 SELECT SETVAL('config.openathens_name_field_id_seq'::TEXT, 100);
34 CREATE TABLE config.openathens_identity (
35 id SERIAL PRIMARY KEY,
36 active BOOL NOT NULL DEFAULT true,
37 org_unit INT NOT NULL REFERENCES actor.org_unit (id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED,
38 api_key TEXT NOT NULL,
39 connection_id TEXT NOT NULL,
40 connection_uri TEXT NOT NULL,
41 auto_signon_enabled BOOL NOT NULL DEFAULT true,
42 auto_signout_enabled BOOL NOT NULL DEFAULT false,
43 unique_identifier INT NOT NULL REFERENCES config.openathens_uid_field (id) DEFAULT 1,
44 display_name INT NOT NULL REFERENCES config.openathens_name_field (id) DEFAULT 1,
45 release_prefix BOOL NOT NULL DEFAULT false,
46 release_first_given_name BOOL NOT NULL DEFAULT false,
47 release_second_given_name BOOL NOT NULL DEFAULT false,
48 release_family_name BOOL NOT NULL DEFAULT false,
49 release_suffix BOOL NOT NULL DEFAULT false,
50 release_email BOOL NOT NULL DEFAULT false,
51 release_home_ou BOOL NOT NULL DEFAULT false,
52 release_barcode BOOL NOT NULL DEFAULT false
56 INSERT INTO permission.perm_list ( id, code, description) VALUES
57 ( 639, 'ADMIN_OPENATHENS', oils_i18n_gettext(639,
58 'Allow a user to administer OpenAthens authentication service', 'ppl', 'description'));