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 10035-10040 if ( CheckVersion($DBversion) ) { Link Here
10035
    SetVersion ($DBversion);
10035
    SetVersion ($DBversion);
10036
}
10036
}
10037
10037
10038
$DBversion = "3.19.00.XXX";
10039
if ( CheckVersion($DBversion) ) {
10040
    $dbh->do(q|
10041
        ALTER TABLE auth_header
10042
        CHANGE COLUMN datemodified modification_time TIMESTAMP NOT NULL default CURRENT_TIMESTAMP
10043
    |);
10044
    $dbh->do(q|
10045
        ALTER TABLE auth_header
10046
        CHANGE COLUMN modification_time modification_time TIMESTAMP NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
10047
    |);
10048
    print "Upgrade to $DBversion done (Bug 11165: Update auth_header.datemodified when updated)\n";
10049
    SetVersion ($DBversion);
10050
}
10051
10038
# DEVELOPER PROCESS, search for anything to execute in the db_update directory
10052
# DEVELOPER PROCESS, search for anything to execute in the db_update directory
10039
# SEE bug 13068
10053
# SEE bug 13068
10040
# if there is anything in the atomicupdate, read and execute it.
10054
# if there is anything in the atomicupdate, read and execute it.
10041
- 

Return to bug 11165