View | Details | Raw Unified | Return to bug 28854
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_28854.pl (+7 lines)
Lines 44-48 return { Link Here
44
              ( 'BundleNotLoanValue', $nfl_val, '', 'Sets the NOT_LOAN AV value that represents "Added to bundle" as a not for loan value', 'Free')
44
              ( 'BundleNotLoanValue', $nfl_val, '', 'Sets the NOT_LOAN AV value that represents "Added to bundle" as a not for loan value', 'Free')
45
        });
45
        });
46
        say $out "System preferences added and set";
46
        say $out "System preferences added and set";
47
48
        if( index_exists( 'return_claims', 'issue_id' ) ) {
49
            $dbh->do(q{
50
                ALTER TABLE return_claims DROP INDEX issue_id
51
            });
52
            say $out "Dropped unique constraint on issue_id in return_claims";
53
        }
47
    }
54
    }
48
}
55
}
(-)a/installer/data/mysql/kohastructure.sql (-2 lines)
Lines 4462-4468 CREATE TABLE `return_claims` ( Link Here
4462
  `resolved_on` timestamp NULL DEFAULT NULL COMMENT 'Time and date the claim was resolved',
4462
  `resolved_on` timestamp NULL DEFAULT NULL COMMENT 'Time and date the claim was resolved',
4463
  `resolved_by` int(11) DEFAULT NULL COMMENT 'ID of the staff member that resolved the claim',
4463
  `resolved_by` int(11) DEFAULT NULL COMMENT 'ID of the staff member that resolved the claim',
4464
  PRIMARY KEY (`id`),
4464
  PRIMARY KEY (`id`),
4465
  UNIQUE KEY `issue_id` (`issue_id`),
4466
  KEY `itemnumber` (`itemnumber`),
4465
  KEY `itemnumber` (`itemnumber`),
4467
  KEY `rc_borrowers_ibfk` (`borrowernumber`),
4466
  KEY `rc_borrowers_ibfk` (`borrowernumber`),
4468
  KEY `rc_created_by_ibfk` (`created_by`),
4467
  KEY `rc_created_by_ibfk` (`created_by`),
4469
- 

Return to bug 28854