From 56bab3e9d877ad3db06e5bce5fed9e45ae5a003f Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Fri, 6 Sep 2019 17:11:13 -0400 Subject: [PATCH] LP#1817645: (follow-up) sync schema update script Signed-off-by: Galen Charlton --- Open-ILS/src/sql/Pg/upgrade/XXXX.schema.remoteauth.sql | 5 ++--- 1 file changed, 2 insertions(+), 3 deletions(-) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.remoteauth.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.remoteauth.sql index 6936d7e3bf..0b6df554fa 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.remoteauth.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.remoteauth.sql @@ -1,7 +1,5 @@ BEGIN; -INSERT INTO config.upgrade_log (version) VALUES ('XXXX'); - INSERT INTO permission.perm_list ( id, code, description ) VALUES ( 615, 'ADMIN_REMOTEAUTH', oils_i18n_gettext( 615, 'Administer remote patron authentication', 'ppl', 'description' )); @@ -15,7 +13,8 @@ CREATE TABLE config.remoteauth_profile ( restrict_to_org BOOLEAN NOT NULL DEFAULT TRUE, allow_inactive BOOL NOT NULL DEFAULT FALSE, allow_expired BOOL NOT NULL DEFAULT FALSE, - block_list TEXT + block_list TEXT, + usr_activity_type INT REFERENCES config.usr_activity_type(id) ON UPDATE CASCADE ON DELETE RESTRICT DEFERRABLE INITIALLY DEFERRED ); CREATE OR REPLACE FUNCTION actor.permit_remoteauth (profile_name TEXT, userid BIGINT) RETURNS TEXT AS $func$ -- 2.11.0