|
Line 0
Link Here
|
|
|
1 |
$DBversion = 'XXX'; # will be replaced by the RM |
| 2 |
if( CheckVersion( $DBversion ) ) { |
| 3 |
if( !TableExists( 'return_claims' ) ) { |
| 4 |
$dbh->do(q{ |
| 5 |
CREATE TABLE IF NOT EXISTS return_claims ( |
| 6 |
id int(11) auto_increment, |
| 7 |
itemnumber int(11) NOT NULL, |
| 8 |
issue_id int(11) NULL DEFAULT NULL, |
| 9 |
old_issue_id int(11) NULL DEFAULT NULL, |
| 10 |
borrowernumber int(11) NOT NULL, |
| 11 |
notes MEDIUMTEXT DEFAULT NULL, |
| 12 |
created_on TIMESTAMP NULL, |
| 13 |
created_by int(11) NULL DEFAULT NULL, |
| 14 |
updated_on TIMESTAMP NULL ON UPDATE CURRENT_TIMESTAMP, |
| 15 |
updated_by int(11) NULL DEFAULT NULL, |
| 16 |
resolution varchar(80) NULL DEFAULT NULL, |
| 17 |
resolved_on TIMESTAMP NULL DEFAULT NULL, |
| 18 |
resolved_by int(11) NULL DEFAULT NULL, |
| 19 |
PRIMARY KEY (`id`), |
| 20 |
KEY `itemnumber` (`itemnumber`), |
| 21 |
CONSTRAINT `rc_issues_ibfk` FOREIGN KEY (`issue_id`) REFERENCES `issues` (`issue_id`) ON DELETE SET NULL ON UPDATE CASCADE, |
| 22 |
CONSTRAINT `rc_old_issues_ibfk` FOREIGN KEY (`old_issue_id`) REFERENCES `issues` (`issue_id`) ON DELETE SET NULL ON UPDATE CASCADE, |
| 23 |
CONSTRAINT `rc_items_ibfk` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 24 |
CONSTRAINT `rc_borrowers_ibfk` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 25 |
CONSTRAINT `rc_created_by_ibfk` FOREIGN KEY (`created_by`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
| 26 |
CONSTRAINT `rc_updated_by_ibfk` FOREIGN KEY (`updated_by`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
| 27 |
CONSTRAINT `rc_resolved_by_ibfk` FOREIGN KEY (`resolved_by`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE |
| 28 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 29 |
}); |
| 30 |
} |
| 31 |
|
| 32 |
$dbh->do(q{ |
| 33 |
INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES |
| 34 |
('ClaimReturnedChargeFee', 'ask', 'ask|charge|no_charge', 'Controls whether or not a lost item fee is charged for return claims', 'Choice'), |
| 35 |
('ClaimReturnedLostValue', '', '', 'Sets the LOST AV value that represents "Claims returned" as a lost value', 'Free'), |
| 36 |
('ClaimReturnedWarningThreshold', '', '', 'Sets the number of return claims past which the librarian will be warned the patron has many return claims', 'Integer'); |
| 37 |
}); |
| 38 |
|
| 39 |
$dbh->do(q{ |
| 40 |
INSERT INTO `authorised_values` ( category, authorised_value, lib, ) |
| 41 |
VALUES |
| 42 |
( |
| 43 |
'RETURN_CLAIM_RESOLUTION', 'RET_BY_PATRON', 'Returned by patron' |
| 44 |
), |
| 45 |
( |
| 46 |
'RETURN_CLAIM_RESOLUTION', 'FOUND_IN_LIB', 'Found in library', |
| 47 |
); |
| 48 |
}); |
| 49 |
|
| 50 |
SetVersion( $DBversion ); |
| 51 |
print "Upgrade to $DBversion done (Bug 14697 - Extend and enhance 'Claims returned' lost status)\n"; |
| 52 |
} |