From 418f899b60cd1569738b3166781509f6b10c0fca Mon Sep 17 00:00:00 2001 From: Kyle Huckins Date: Tue, 15 Mar 2022 19:20:55 +0000 Subject: [PATCH] lp1913816 Course Materials Owning Lib is Required - Requires an Owning Library to be set when creating or editing a Course Signed-off-by: Kyle Huckins Changes to be committed: modified: Open-ILS/src/sql/Pg/040.schema.asset.sql new file: Open-ILS/src/sql/Pg/upgrade/XXXX.schema.lp19138160-course-materials-owning-lib-shouldnt-be-null.sql --- Open-ILS/src/sql/Pg/040.schema.asset.sql | 2 +- ...ma.lp19138160-course-materials-owning-lib-shouldnt-be-null.sql | 8 ++++++++ 2 files changed, 9 insertions(+), 1 deletion(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.schema.lp19138160-course-materials-owning-lib-shouldnt-be-null.sql diff --git a/Open-ILS/src/sql/Pg/040.schema.asset.sql b/Open-ILS/src/sql/Pg/040.schema.asset.sql index e2692381ca..b40c2983dc 100644 --- a/Open-ILS/src/sql/Pg/040.schema.asset.sql +++ b/Open-ILS/src/sql/Pg/040.schema.asset.sql @@ -1099,7 +1099,7 @@ CREATE TABLE asset.course_module_course ( name TEXT NOT NULL, course_number TEXT NOT NULL, section_number TEXT, - owning_lib INT REFERENCES actor.org_unit (id), + owning_lib INT NOT NULL REFERENCES actor.org_unit (id), is_archived BOOLEAN DEFAULT false ); diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.lp19138160-course-materials-owning-lib-shouldnt-be-null.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.lp19138160-course-materials-owning-lib-shouldnt-be-null.sql new file mode 100644 index 0000000000..18b336e0e1 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.lp19138160-course-materials-owning-lib-shouldnt-be-null.sql @@ -0,0 +1,8 @@ +BEGIN; + +SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); + +ALTER TABLE asset.course_module_course + ALTER COLUMN owning_lib SET NOT NULL; + +COMMIT; \ No newline at end of file -- 2.11.0