Attachment #37006 for bug #11165

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

Lines 24-30 CREATE TABLE `auth_header` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
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,




    SetVersion($DBversion);
}

$DBversion = "3.19.00.XXX";
if ( CheckVersion($DBversion) ) {
    $dbh->do(q|
        ALTER TABLE auth_header
        CHANGE COLUMN datemodified modification_time TIMESTAMP NOT NULL default CURRENT_TIMESTAMP
    |);
    $dbh->do(q|
        ALTER TABLE auth_header
        CHANGE COLUMN modification_time modification_time TIMESTAMP NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
    |);
    print "Upgrade to $DBversion done (Bug 11165: Update auth_header.datemodified when updated)\n";
    SetVersion ($DBversion);
}

=head1 FUNCTIONS

=head2 TableExists($table)
- 

Return to bug 11165

Lines 9867-9872 if(CheckVersion($DBversion)) { Link Here

(-)a/installer/data/mysql/updatedatabase.pl (-1 / +14 lines)
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	-