From f922d18039de167a355e0978517b76f609129225 Mon Sep 17 00:00:00 2001 From: malexander Date: Wed, 8 Dec 2021 19:12:23 +0000 Subject: [PATCH] lp-1942645 term name uniqueness dropped name uniqueness between orgs, added constraint to owning lib and name Signed-off-by: malexander --- Open-ILS/src/sql/Pg/040.schema.asset.sql | 5 +++-- .../XXXX.schema.update_course_module_term_constraints.sql | 9 +++++++++ 2 files changed, 12 insertions(+), 2 deletions(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.schema.update_course_module_term_constraints.sql diff --git a/Open-ILS/src/sql/Pg/040.schema.asset.sql b/Open-ILS/src/sql/Pg/040.schema.asset.sql index 44de65b0dc..e2692381ca 100644 --- a/Open-ILS/src/sql/Pg/040.schema.asset.sql +++ b/Open-ILS/src/sql/Pg/040.schema.asset.sql @@ -1132,10 +1132,11 @@ CREATE TABLE asset.course_module_course_materials ( CREATE TABLE asset.course_module_term ( id SERIAL PRIMARY KEY, - name TEXT UNIQUE NOT NULL, + name TEXT NOT NULL, owning_lib INT REFERENCES actor.org_unit (id), start_date TIMESTAMP WITH TIME ZONE, - end_date TIMESTAMP WITH TIME ZONE + end_date TIMESTAMP WITH TIME ZONE, + CONSTRAINT cmt_once_per_owning_lib UNIQUE (owning_lib, name) ); CREATE TABLE asset.course_module_term_course_map ( diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.update_course_module_term_constraints.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.update_course_module_term_constraints.sql new file mode 100644 index 0000000000..0b12d82319 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.update_course_module_term_constraints.sql @@ -0,0 +1,9 @@ +BEGIN; + +SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); + +ALTER TABLE asset.course_module_term; +DROP CONSTRAINT course_module_term_name_key; +ADD CONSTRAINT cmt_once_per_owning_lib UNIQUE (owning_lib, name); + +COMMIT; \ No newline at end of file -- 2.11.0