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

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 24-30 CREATE TABLE `auth_header` ( Link Here
24
  `authid` bigint(20) unsigned NOT NULL auto_increment,
24
  `authid` bigint(20) unsigned NOT NULL auto_increment,
25
  `authtypecode` varchar(10) NOT NULL default '',
25
  `authtypecode` varchar(10) NOT NULL default '',
26
  `datecreated` date default NULL,
26
  `datecreated` date default NULL,
27
  `datemodified` date default NULL,
27
  `modification_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
28
  `origincode` varchar(20) default NULL,
28
  `origincode` varchar(20) default NULL,
29
  `authtrees` mediumtext,
29
  `authtrees` mediumtext,
30
  `marc` blob,
30
  `marc` blob,
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +14 lines)
Lines 9867-9872 if(CheckVersion($DBversion)) { Link Here
9867
    SetVersion($DBversion);
9867
    SetVersion($DBversion);
9868
}
9868
}
9869
9869
9870
$DBversion = "3.19.00.XXX";
9871
if ( CheckVersion($DBversion) ) {
9872
    $dbh->do(q|
9873
        ALTER TABLE auth_header
9874
        CHANGE COLUMN datemodified modification_time TIMESTAMP NOT NULL default CURRENT_TIMESTAMP
9875
    |);
9876
    $dbh->do(q|
9877
        ALTER TABLE auth_header
9878
        CHANGE COLUMN modification_time modification_time TIMESTAMP NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
9879
    |);
9880
    print "Upgrade to $DBversion done (Bug 11165: Update auth_header.datemodified when updated)\n";
9881
    SetVersion ($DBversion);
9882
}
9883
9870
=head1 FUNCTIONS
9884
=head1 FUNCTIONS
9871
9885
9872
=head2 TableExists($table)
9886
=head2 TableExists($table)
9873
- 

Return to bug 11165