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

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 2742-2748 CREATE TABLE `action_logs` ( -- logs of actions taken in Koha (requires that the Link Here
2742
  `info` text, -- information about the action (usually includes SQL statement)
2742
  `info` text, -- information about the action (usually includes SQL statement)
2743
  PRIMARY KEY (`action_id`),
2743
  PRIMARY KEY (`action_id`),
2744
  KEY  (`timestamp`,`user`)
2744
  KEY  (`timestamp`,`user`)
2745
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2745
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2746
2746
2747
--
2747
--
2748
-- Table structure for table `alert`
2748
-- Table structure for table `alert`
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +7 lines)
Lines 7912-7917 if ( CheckVersion($DBversion) ) { Link Here
7912
    SetVersion($DBversion);
7912
    SetVersion($DBversion);
7913
}
7913
}
7914
7914
7915
$DBversion = "3.13.00.XXX";
7916
if ( CheckVersion($DBversion) ) {
7917
    $dbh->do("ALTER TABLE action_logs ENGINE = MYISAM");
7918
    print "Upgrade to $DBversion done (Bug 11136 - action_logs should be a MyISAM table, not InnoDB)\n";
7919
    SetVersion($DBversion);
7920
}
7921
7915
=head1 FUNCTIONS
7922
=head1 FUNCTIONS
7916
7923
7917
=head2 TableExists($table)
7924
=head2 TableExists($table)
7918
- 

Return to bug 11136