From ae9c4d5502675286e490a6830b51a9a92bc86e25 Mon Sep 17 00:00:00 2001 From: Kyle Huckins Date: Fri, 6 Dec 2019 09:09:16 +0000 Subject: [PATCH] Course Material Course-Item Constraint - Prevent users from associating duplicate items to a course. Signed-off-by: Kyle Huckins Changes to be committed: modified: Open-ILS/src/sql/Pg/040.schema.asset.sql modified: Open-ILS/src/sql/Pg/upgrade/XXXX.schema.course-materials-module.sql --- Open-ILS/src/sql/Pg/040.schema.asset.sql | 3 ++- Open-ILS/src/sql/Pg/upgrade/XXXX.schema.course-materials-module.sql | 3 ++- 2 files changed, 4 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/040.schema.asset.sql b/Open-ILS/src/sql/Pg/040.schema.asset.sql index 4fd2f01da2..8756473d87 100644 --- a/Open-ILS/src/sql/Pg/040.schema.asset.sql +++ b/Open-ILS/src/sql/Pg/040.schema.asset.sql @@ -1129,7 +1129,8 @@ CREATE TABLE asset.course_module_course_materials ( original_location INT REFERENCES asset.copy_location, original_status INT REFERENCES config.copy_status, original_circ_modifier TEXT, --REFERENCES config.circ_modifier - original_callnumber INT REFERENCES asset.call_number + original_callnumber INT REFERENCES asset.call_number, + unique (course, item) ); CREATE TABLE asset.course_module_non_cat_course_materials ( diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.course-materials-module.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.course-materials-module.sql index bbfcde2ef8..b725d30079 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.course-materials-module.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.course-materials-module.sql @@ -26,7 +26,8 @@ CREATE TABLE asset.course_module_course_materials ( original_location INT REFERENCES asset.copy_location, original_status INT REFERENCES config.copy_status, original_circ_modifier TEXT REFERENCES config.circ_modifier, - original_callnumber INT REFERENCES asset.call_number + original_callnumber INT REFERENCES asset.call_number, + unique (course, item) ); CREATE TABLE asset.course_module_non_cat_course_materials ( -- 2.11.0