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 3088-3094 DROP TABLE IF EXISTS `items_last_borrower`; Link Here
3088
CREATE TABLE `items_last_borrower` (
3088
CREATE TABLE `items_last_borrower` (
3089
  `id` int(11) NOT NULL AUTO_INCREMENT,
3089
  `id` int(11) NOT NULL AUTO_INCREMENT,
3090
  `itemnumber` int(11) NOT NULL,
3090
  `itemnumber` int(11) NOT NULL,
3091
  `borrowernumber` int(11) NOT NULL,
3091
  `borrowernumber` int(11) NULL,
3092
  `created_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
3092
  `created_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
3093
  PRIMARY KEY (`id`),
3093
  PRIMARY KEY (`id`),
3094
  UNIQUE KEY `itemnumber` (`itemnumber`),
3094
  UNIQUE KEY `itemnumber` (`itemnumber`),
3095
- 

Return to bug 23260