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

(-)a/installer/data/mysql/atomicupdate/bug_23260.perl (+8 lines)
Line 0 Link Here
1
$DBversion = 'XXX'; # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
    # you can use $dbh here like:
4
    $dbh->do( "ALTER TABLE items_last_borrower MODIFY COLUMN `borrowernumber` int(11) default NULL" );
5
6
    SetVersion( $DBversion );
7
    print "Upgrade to $DBversion done (Bug 23260 - make borrowernumber from items_last_borrower nullable)\n";
8
}
(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 1723-1729 CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r Link Here
1723
CREATE TABLE IF NOT EXISTS `items_last_borrower` (
1723
CREATE TABLE IF NOT EXISTS `items_last_borrower` (
1724
  `id` int(11) NOT NULL AUTO_INCREMENT,
1724
  `id` int(11) NOT NULL AUTO_INCREMENT,
1725
  `itemnumber` int(11) NOT NULL,
1725
  `itemnumber` int(11) NOT NULL,
1726
  `borrowernumber` int(11) NOT NULL,
1726
  `borrowernumber` int(11) default NULL,
1727
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1727
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1728
  PRIMARY KEY (`id`),
1728
  PRIMARY KEY (`id`),
1729
  UNIQUE KEY `itemnumber` (`itemnumber`),
1729
  UNIQUE KEY `itemnumber` (`itemnumber`),
1730
- 

Return to bug 23260