From c6f92c9528b41d3acbda7db9658c3348d5e29843 Mon Sep 17 00:00:00 2001 From: Kyle Huckins Date: Sun, 20 Mar 2022 23:43:22 +0000 Subject: [PATCH] lp1907927 Fix sql Formatting - Set upgrade script formatting to LF from CRLF - Set temporary callnumber to Text rather than Int Signed-off-by: Kyle Huckins --- Open-ILS/src/sql/Pg/040.schema.asset.sql | 2 +- ...chema.lp1907927-edit-items-attached-to-course.sql | 20 ++++++++++---------- 2 files changed, 11 insertions(+), 11 deletions(-) diff --git a/Open-ILS/src/sql/Pg/040.schema.asset.sql b/Open-ILS/src/sql/Pg/040.schema.asset.sql index 1c3688c6f9..419b254cae 100644 --- a/Open-ILS/src/sql/Pg/040.schema.asset.sql +++ b/Open-ILS/src/sql/Pg/040.schema.asset.sql @@ -1130,7 +1130,7 @@ CREATE TABLE asset.course_module_course_materials ( temporary_location INT REFERENCES asset.copy_location, temporary_status INT REFERENCES config.copy_status, temporary_circ_modifier TEXT, --REFERENCES config.circ_modifier - temporary_callnumber INT REFERENCES asset.call_number, + temporary_callnumber TEXT, --REFERENCES asset.call_number, unique (course, item, record) ); diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.lp1907927-edit-items-attached-to-course.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.lp1907927-edit-items-attached-to-course.sql index a0d904f358..4831acce34 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.lp1907927-edit-items-attached-to-course.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.lp1907927-edit-items-attached-to-course.sql @@ -1,11 +1,11 @@ -BEGIN; - -SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); - -ALTER TABLE asset.course_module_course_materials - ADD COLUMN temporary_location INT REFERENCES asset.copy_location, - ADD COLUMN temporary_status INT REFERENCES config.copy_status, - ADD COLUMN temporary_circ_modifier TEXT, --REFERENCES config.circ_modifier - ADD COLUMN temporary_callnumber INT REFERENCES asset.call_number; - +BEGIN; + +SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); + +ALTER TABLE asset.course_module_course_materials + ADD COLUMN temporary_location INT REFERENCES asset.copy_location, + ADD COLUMN temporary_status INT REFERENCES config.copy_status, + ADD COLUMN temporary_circ_modifier TEXT, --REFERENCES config.circ_modifier + ADD COLUMN temporary_callnumber TEXT; + COMMIT; \ No newline at end of file -- 2.11.0