Evergreen

  1. Bug #1942645
  2. Comment #2

Comment 2 for bug 1942645

Revision history for this message
Martha Driscoll (mjdriscoll) wrote :

The syntax of the database upgrade script is not quite right. The DROP and ADD need to be part of the ALTER TABLE statement. I modified the script to this:

ALTER TABLE asset.course_module_term
        DROP CONSTRAINT course_module_term_name_key;

ALTER TABLE asset.course_module_term
        ADD CONSTRAINT cmt_once_per_owning_lib UNIQUE (owning_lib, name);

The script ran and successfully dropped the constraint and added the new one. We will now test the functionality of the new constraint.