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 3730-3736 DROP TABLE IF EXISTS `items_last_borrower`; Link Here
3730
CREATE TABLE `items_last_borrower` (
3730
CREATE TABLE `items_last_borrower` (
3731
  `id` int(11) NOT NULL AUTO_INCREMENT,
3731
  `id` int(11) NOT NULL AUTO_INCREMENT,
3732
  `itemnumber` int(11) NOT NULL,
3732
  `itemnumber` int(11) NOT NULL,
3733
  `borrowernumber` int(11) NOT NULL,
3733
  `borrowernumber` int(11) NULL,
3734
  `created_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
3734
  `created_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
3735
  PRIMARY KEY (`id`),
3735
  PRIMARY KEY (`id`),
3736
  UNIQUE KEY `itemnumber` (`itemnumber`),
3736
  UNIQUE KEY `itemnumber` (`itemnumber`),
3737
- 

Return to bug 23260