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 3654-3660 DROP TABLE IF EXISTS `items_last_borrower`; Link Here
3654
CREATE TABLE `items_last_borrower` (
3654
CREATE TABLE `items_last_borrower` (
3655
  `id` int(11) NOT NULL AUTO_INCREMENT,
3655
  `id` int(11) NOT NULL AUTO_INCREMENT,
3656
  `itemnumber` int(11) NOT NULL,
3656
  `itemnumber` int(11) NOT NULL,
3657
  `borrowernumber` int(11) NOT NULL,
3657
  `borrowernumber` int(11) NULL,
3658
  `created_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
3658
  `created_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
3659
  PRIMARY KEY (`id`),
3659
  PRIMARY KEY (`id`),
3660
  UNIQUE KEY `itemnumber` (`itemnumber`),
3660
  UNIQUE KEY `itemnumber` (`itemnumber`),
3661
- 

Return to bug 23260