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 3324-3329 CREATE TABLE borrower_attribute_types_branches( -- association table between bor Link Here
3324
CREATE TABLE IF NOT EXISTS `borrower_modifications` (
3324
CREATE TABLE IF NOT EXISTS `borrower_modifications` (
3325
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3325
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3326
  `verification_token` varchar(255) NOT NULL DEFAULT '',
3326
  `verification_token` varchar(255) NOT NULL DEFAULT '',
3327
  `changed_fields` MEDIUMTEXT NOT NULL DEFAULT '',
3327
  `borrowernumber` int(11) NOT NULL DEFAULT '0',
3328
  `borrowernumber` int(11) NOT NULL DEFAULT '0',
3328
  `cardnumber` varchar(32) DEFAULT NULL,
3329
  `cardnumber` varchar(32) DEFAULT NULL,
3329
  `surname` LONGTEXT,
3330
  `surname` LONGTEXT,
3330
- 

Return to bug 23151