From da087bd7c8968996f98a35a0b4f68f1aa00d3704 Mon Sep 17 00:00:00 2001
From: Chris Sharp <csharp@georgialibraries.org>
Date: Fri, 4 Oct 2019 11:31:49 -0400
Subject: [PATCH] adding post-3.4 upgrade script

---
 .../Pg/version-upgrade/pines-post-3.4-upgrade.sql  | 53 ++++++++++++++++++++++
 1 file changed, 53 insertions(+)
 create mode 100644 Open-ILS/src/sql/Pg/version-upgrade/pines-post-3.4-upgrade.sql

diff --git a/Open-ILS/src/sql/Pg/version-upgrade/pines-post-3.4-upgrade.sql b/Open-ILS/src/sql/Pg/version-upgrade/pines-post-3.4-upgrade.sql
new file mode 100644
index 0000000000..55979ccf22
--- /dev/null
+++ b/Open-ILS/src/sql/Pg/version-upgrade/pines-post-3.4-upgrade.sql
@@ -0,0 +1,53 @@
+begin;
+-- insert the RBDigital URI for all GADD libs
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'ARL'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'JCL'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'LEE'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'RML'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'SRL'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'PPL'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'THRL'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'ECPL'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'HCLS'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'GCHR'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'CHAT'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'CLAYTN'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'MRLS'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'NCLS'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'ARCPLS'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'MGRL'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'CRLS'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'PMRLS'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'URRLS'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'HART'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'SJRLS'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'HOU'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'CCL'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'OCRL'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'OKRL'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'OHOOP'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'SWGRL'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'STRL'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'TLLS'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'DCPL'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'SHRL'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'BTRL'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'ORLS'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'MCCLS'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'LOPL'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'CPRL'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'KRLS'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'FRRLS'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'LBRLS'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'CHRL'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'NGRL'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'WORTH'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'PIED'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'NEG'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'SGRL'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'TCPLS'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'DTRL'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+insert into actor.org_unit_setting (org_unit, name, value) values ((select id from actor.org_unit where shortname = 'MOGL'), 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"');
+
+commit;
+
-- 
2.11.0