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

(-)a/installer/data/mysql/atomicupdate/bug_23151.perl (+13 lines)
Line 0 Link Here
1
use C4::Installer;
2
3
my $DBVersion = 'XXX';
4
if ( CheckVersion( $DBversion ) ) {
5
    print "Running... ";
6
    unless ( column_exists( 'borrower_modifications', 'changed_fields' ) ) {
7
        print "Running... ";
8
        $dbh->do("ALTER TABLE borrower_modifications ADD changed_fields MEDIUMTEXT AFTER verification_token;");
9
    }
10
    print "Ran\n";
11
    SetVersion( $DBversion );
12
    print "Upgrade to $DBversion done (Bug 23151 - Add borrower_modifications.changed_fields column)\n";
13
}
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 3397-3402 CREATE TABLE borrower_attribute_types_branches( -- association table between bor Link Here
3397
CREATE TABLE IF NOT EXISTS `borrower_modifications` (
3397
CREATE TABLE IF NOT EXISTS `borrower_modifications` (
3398
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3398
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3399
  `verification_token` varchar(255) NOT NULL DEFAULT '',
3399
  `verification_token` varchar(255) NOT NULL DEFAULT '',
3400
  `changed_fields` MEDIUMTEXT NOT NULL DEFAULT '',
3400
  `borrowernumber` int(11) NOT NULL DEFAULT '0',
3401
  `borrowernumber` int(11) NOT NULL DEFAULT '0',
3401
  `cardnumber` varchar(32) DEFAULT NULL,
3402
  `cardnumber` varchar(32) DEFAULT NULL,
3402
  `surname` LONGTEXT,
3403
  `surname` LONGTEXT,
3403
- 

Return to bug 23151