@@ -, +, @@ claims missing --- installer/data/mysql/atomicupdate/bug_28854.pl | 17 +++++++++++++++++ installer/data/mysql/kohastructure.sql | 1 + 2 files changed, 18 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_28854.pl --- a/installer/data/mysql/atomicupdate/bug_28854.pl +++ a/installer/data/mysql/atomicupdate/bug_28854.pl @@ -0,0 +1,17 @@ +use Modern::Perl; + +return { + bug_number => "28854", + description => "Add new unique index to return claims", + up => sub { + my ($args) = @_; + my ($dbh, $out) = @$args{qw(dbh out)}; + if ( !unique_key_exists('return_claims', 'item_issue') ) { + $dbh->do(q{ + ALTER TABLE return_claims + ADD UNIQUE KEY item_issue (`itemnumber`,`issue_id`) + }); + say $out "item_issue index added to return_claims"; + } + }, +}; --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -4514,6 +4514,7 @@ CREATE TABLE `return_claims` ( `resolved_on` timestamp NULL DEFAULT NULL COMMENT 'Time and date the claim was resolved', `resolved_by` int(11) DEFAULT NULL COMMENT 'ID of the staff member that resolved the claim', PRIMARY KEY (`id`), + UNIQUE KEY `item_issue` (`itemnumber`, `issue_id`), KEY `itemnumber` (`itemnumber`), KEY `rc_borrowers_ibfk` (`borrowernumber`), KEY `rc_created_by_ibfk` (`created_by`), --