From 62621c1276586681ec9a0ac1bc0b21473730bd00 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Tue, 12 Nov 2019 07:37:17 -0500 Subject: [PATCH] LP#1772680 - Correct schema definition to align with intended use. Signed-off-by: Chris Sharp --- Open-ILS/src/sql/Pg/upgrade/YYYY.schema.extras_rbdigital.sql | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/upgrade/YYYY.schema.extras_rbdigital.sql b/Open-ILS/src/sql/Pg/upgrade/YYYY.schema.extras_rbdigital.sql index f0cf35eda7..1ca91abf0b 100644 --- a/Open-ILS/src/sql/Pg/upgrade/YYYY.schema.extras_rbdigital.sql +++ b/Open-ILS/src/sql/Pg/upgrade/YYYY.schema.extras_rbdigital.sql @@ -19,12 +19,12 @@ INSERT INTO extra.rbdigital_digital_services (id, name, is_enabled, search_uri, INSERT INTO extra.rbdigital_digital_services (id, name, is_enabled, search_uri, vendor_key, display_order, api_url) VALUES (2, 'RBdigital', false, '/ebook_api/rbdigital/results', 'rbdigital', 2, 'http://api.rbdigitalstage.com/v1'); CREATE TABLE extra.rbdigital_digital_services_authorized ( - digital_services_id SMALLSERIAL PRIMARY KEY, + id SERIAL PRIMARY KEY, + digital_services_id INTEGER NOT NULL REFERENCES extra.rbdigital_digital_services (id) DEFERRABLE INITIALLY DEFERRED, digital_services_library_id CHARACTER VARYING(64), digital_services_library_token CHARACTER VARYING(64), digital_services_name CHARACTER VARYING(100), digital_services_library_url CHARACTER VARYING(250), - id SERIAL NOT NULL, library_id INTEGER, home_ou INTEGER ); @@ -48,3 +48,5 @@ CREATE TABLE extra.rbdigital_search_fields ( ); COMMENT ON TABLE extra.rbdigital_search_fields IS 'The purpose of this table is to map the Evergreen search fields to the analogous fields for each digital service. Therefore each integrated digital service will have a record in this table.'; + +COMMIT; -- 2.11.0