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

(-)a/installer/data/mysql/atomicupdate/bug_24329.perl (+8 lines)
Line 0 Link Here
1
$DBversion = 'XXX'; # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
    $dbh->do( "ALTER TABLE action_logs MODIFY COLUMN `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP" );
4
5
    # Always end with this (adjust the bug info)
6
    SetVersion( $DBversion );
7
    print "Upgrade to $DBversion done (Bug 24329 - Do not update action_log.timestamp)\n";
8
}
(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 2749-2755 CREATE TABLE `account_offsets` ( Link Here
2749
DROP TABLE IF EXISTS `action_logs`;
2749
DROP TABLE IF EXISTS `action_logs`;
2750
CREATE TABLE `action_logs` ( -- logs of actions taken in Koha (requires that the logs be turned on)
2750
CREATE TABLE `action_logs` ( -- logs of actions taken in Koha (requires that the logs be turned on)
2751
  `action_id` int(11) NOT NULL auto_increment, -- unique identifier for each action
2751
  `action_id` int(11) NOT NULL auto_increment, -- unique identifier for each action
2752
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time the action took place
2752
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP, -- the date and time the action took place
2753
  `user` int(11) NOT NULL default 0, -- the staff member who performed the action (borrowers.borrowernumber)
2753
  `user` int(11) NOT NULL default 0, -- the staff member who performed the action (borrowers.borrowernumber)
2754
  `module` MEDIUMTEXT, -- the module this action was taken against
2754
  `module` MEDIUMTEXT, -- the module this action was taken against
2755
  `action` MEDIUMTEXT, -- the action (includes things like DELETED, ADDED, MODIFY, etc)
2755
  `action` MEDIUMTEXT, -- the action (includes things like DELETED, ADDED, MODIFY, etc)
2756
- 

Return to bug 24329