From a271599950efa21bcd7140f67af47f534b1fb769 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Wed, 12 Dec 2018 15:31:52 -0500 Subject: [PATCH] add rbdigital sql script --- .../configure_and_enable_rbdigital.sql | 233 +++++++++++++++++++++ 1 file changed, 233 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/version-upgrade/configure_and_enable_rbdigital.sql diff --git a/Open-ILS/src/sql/Pg/version-upgrade/configure_and_enable_rbdigital.sql b/Open-ILS/src/sql/Pg/version-upgrade/configure_and_enable_rbdigital.sql new file mode 100644 index 0000000000..243426f541 --- /dev/null +++ b/Open-ILS/src/sql/Pg/version-upgrade/configure_and_enable_rbdigital.sql @@ -0,0 +1,233 @@ +BEGIN; + +-- update the global flag +update config.global_flag set enabled = true where name = 'extras.enable_digital_resource_search_tab'; + +-- enter the library settings +insert into actor.org_unit_setting (org_unit, name, value) values (9, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (18, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (13, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (19, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (11, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (8, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (10, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (20, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (14, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (12, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (278, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (276, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (282, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (279, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (280, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (281, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (222, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (224, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (223, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (345, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (121, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (120, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (219, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (220, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (217, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (218, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (361, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (215, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (214, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (125, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (127, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (128, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (129, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (126, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (130, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (269, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (272, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (270, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (32, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (271, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (273, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (268, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (265, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (261, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (266, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (263, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (264, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (34, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (35, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (38, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (36, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (37, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (23, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (22, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (109, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (111, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (107, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (113, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (108, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (110, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (112, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (114, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (183, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (143, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (300, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (144, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (141, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (142, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (155, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (154, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (153, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (254, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (255, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (343, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (256, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (257, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (258, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (331, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (330, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (333, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (335, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (329, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (336, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (117, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (360, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (118, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (116, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (377, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (378, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (379, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (380, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (381, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (382, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (383, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (384, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (385, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (386, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (387, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (388, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (389, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (390, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (391, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (392, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (74, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (70, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (237, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (239, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (246, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (247, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (241, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (240, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (243, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (244, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (242, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (236, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (235, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (245, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (234, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (4, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (3, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (99, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (97, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (100, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (101, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (232, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (340, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (342, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (354, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (356, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (355, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (297, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (293, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (294, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (295, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (298, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (296, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (198, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (199, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (200, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (201, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (202, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (208, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (136, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (210, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (205, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (206, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (207, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (204, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (60, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (62, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (59, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (61, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (63, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (104, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (103, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (188, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (88, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (90, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (89, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (91, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (92, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (93, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (95, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (86, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (27, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (29, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (28, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (26, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (132, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (134, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (135, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (137, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (138, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); +insert into actor.org_unit_setting (org_unit, name, value) values (262, 'ebook_api.rbdigital.base_uri', '"https://api.rbdigital.com/v1"'); + +-- enter required data into the auth table +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('2732', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Athens Regional Library System', 'athensga.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('3960', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Augusta-Richmond County Library System', 'arcplsga.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('3961', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Catoosa County Library', 'catoosaga.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('1518', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Chattooga County Public Library', 'chattoogaga.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('3996', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Cherokee Regional Library System', 'cherokeega.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('2932', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Chestatee Regional Library', 'chestateega.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('2870', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Clayton County Library System', 'claytonga.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('3962', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Coastal Plain Regional Library System', 'coastalplainga.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('3695', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Coastal Plain Regional Library System', 'coastalplainga.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('448', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Columbia County Library', 'columbiacoga.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('100014', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'De Soto Trail Regional Library', 'desotoga.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('1658', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Dougherty County Public Library', 'doughertyga.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('4001', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Elbert County Library', 'elbertga.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('3695', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Fitzgerald-Ben Hill County Library', 'fitzbhillcoga.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('3964', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Flint River Regional Library System', 'flintriverga.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('4007', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Hart County Library', 'hartga.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('1728', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Henry County Library System', 'henryga.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('1563', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Houston County Public Library', 'houstonga.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('1675', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Kinchafoonee Regional Library', 'kinchafooneega.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('1495', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Lake Blackshear Regional Library', 'lakeblackshearga.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('2924', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Lee County Library System', 'leega.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('3348', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Live Oak Public Libraries', 'liveoakga.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('3094', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Middle Georgia Regional Library', 'mgrl.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('1494', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Moultrie-colquitt County Library System', 'moultriecolquittga.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('4006', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Mountain Regional Library System', 'mountainga.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('3350', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Newton County Library System', 'newtonga.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('1975', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Northwest Georgia Regional Library', 'ngrl.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('100006', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Ocmulgee Regional Library System', 'ocmulgeega.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('3968', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Oconee Regional Library System', 'oconeega.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('3969', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Ohoopee Regional Library System', 'ohoopeega.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('4008', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Okefenokkee Regional Library System', 'okefenokeega.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('3972', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Peach Public Libraries', 'peachga.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('100008', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Piedmont Regional Library System', 'piedmontga.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('3973', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Pine Mountain Regional Library System', 'pinemtnga.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('3974', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Roddenbery Memorial Library System', 'rmga.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('2764', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Sara Hightower Regional Library System', 'sarahightowerga.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('3975', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Satilla Regional Library System', 'satillaga.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('3976', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Screven Jenkins Regional Library System', 'sjlsga.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('2507', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Smyrna Public Library', 'smyrnaga.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('3977', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Southwest Georgia Regional Library System', 'southwestga.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('3978', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Statesboro Regional Library System', 'statesboroga.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('2069', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'The Marshes of Glynn Libraries', 'marshesofglynnga.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('3979', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Thomas County Public Library System', 'thomasga.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('3966', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Toccoa-Stephens branch of NE GA Regional Library System', 'toccoastephensga.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('2957', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Troup Harris Library System', 'thrlga.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('3980', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Twin Lakes Library System', 'twinlakesga.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('4011', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'White County branch of NE GA Regional Library System', 'whitega.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('3829', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Willis L Miller Public Library', 'southgareg.rbdigital.com', 2, 1, 1); +INSERT INTO extra.rbdigital_digital_services_authorized (digital_services_library_id, digital_services_library_token, digital_services_name, digital_services_library_url, id, library_id, home_ou) VALUES ('3982', 'ABCD22X1C-B286-4F60-9FF5-F4C5B3E57A11', 'Worth County Library System', 'worthcoga.rbdigital.com', 2, 1, 1); + +COMMIT; -- 2.11.0