Open-ILS/src/sql/Pg/upgrade/XXXX.schema.update_course_module_term_constraints.sql

   1 BEGIN;\r
   2 \r
   3 SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);\r
   4 \r
   5 ALTER TABLE asset.course_module_term\r
   6         DROP CONSTRAINT course_module_term_name_key;\r
   7 \r
   8 ALTER TABLE asset.course_module_term\r
   9         ADD CONSTRAINT cmt_once_per_owning_lib UNIQUE (owning_lib, name);\r
  10 \r
  11 COMMIT;\r