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

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 2679-2685 CREATE TABLE `action_logs` ( -- logs of actions taken in Koha (requires that the Link Here
2679
  `info` text, -- information about the action (usually includes SQL statement)
2679
  `info` text, -- information about the action (usually includes SQL statement)
2680
  PRIMARY KEY (`action_id`),
2680
  PRIMARY KEY (`action_id`),
2681
  KEY  (`timestamp`,`user`)
2681
  KEY  (`timestamp`,`user`)
2682
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2682
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2683
2683
2684
--
2684
--
2685
-- Table structure for table `alert`
2685
-- Table structure for table `alert`
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +7 lines)
Lines 7330-7335 if ( CheckVersion($DBversion) ) { Link Here
7330
    SetVersion($DBversion);
7330
    SetVersion($DBversion);
7331
}
7331
}
7332
7332
7333
$DBversion = "3.13.00.XXX";
7334
if ( CheckVersion($DBversion) ) {
7335
    $dbh->do("ALTER TABLE action_logs ENGINE = MYISAM");
7336
    print "Upgrade to $DBversion done (Bug 11136 - action_logs should be a MyISAM table, not InnoDB)\n";
7337
    SetVersion($DBversion);
7338
}
7339
7333
=head1 FUNCTIONS
7340
=head1 FUNCTIONS
7334
7341
7335
=head2 TableExists($table)
7342
=head2 TableExists($table)
7336
- 

Return to bug 11136