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

(-)a/Koha/Patron/Modification.pm (-2 lines)
Lines 70-77 sub store { Link Here
70
        };
70
        };
71
    }
71
    }
72
72
73
    $self->changed_fields('') unless defined $self->changed_fields;
74
75
    return $self->SUPER::store();
73
    return $self->SUPER::store();
76
}
74
}
77
75
(-)a/installer/data/mysql/atomicupdate/bug_25086.perl (+9 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
     
5
    $dbh->do( "ALTER TABLE borrower_modifications MODIFY changed_fields MEDIUMTEXT DEFAULT NULL" );
6
7
    # Always end with this (adjust the bug info)
8
    NewVersion( $DBversion, 25086, "Set changed_fields column of borrower_modifications as nullable");
9
}
(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 3387-3393 CREATE TABLE borrower_attribute_types_branches( -- association table between bor Link Here
3387
CREATE TABLE IF NOT EXISTS `borrower_modifications` (
3387
CREATE TABLE IF NOT EXISTS `borrower_modifications` (
3388
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3388
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3389
  `verification_token` varchar(255) NOT NULL DEFAULT '',
3389
  `verification_token` varchar(255) NOT NULL DEFAULT '',
3390
  `changed_fields` MEDIUMTEXT NOT NULL,
3390
  `changed_fields` MEDIUMTEXT DEFAULT NULL,
3391
  `borrowernumber` int(11) NOT NULL DEFAULT '0',
3391
  `borrowernumber` int(11) NOT NULL DEFAULT '0',
3392
  `cardnumber` varchar(32) DEFAULT NULL,
3392
  `cardnumber` varchar(32) DEFAULT NULL,
3393
  `surname` LONGTEXT,
3393
  `surname` LONGTEXT,
3394
- 

Return to bug 25086