From 56bab3e9d877ad3db06e5bce5fed9e45ae5a003f Mon Sep 17 00:00:00 2001
From: Galen Charlton <gmc@equinoxinitiative.org>
Date: Fri, 6 Sep 2019 17:11:13 -0400
Subject: [PATCH] LP#1817645: (follow-up) sync schema update script
Signed-off-by: Galen Charlton <gmc@equinoxinitiative.org>
---
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