Eye/scripts/updates/2-4-3/mysql-optimize-index.sql

ALTER TABLE `syslog` DROP INDEX `timestamp`, ADD INDEX `timestamp` (`timestamp`) USING BTREE;
ALTER TABLE `syslog` ADD INDEX(`level`);
ALTER TABLE `syslog` ADD FULLTEXT(`customer`);
ALTER TABLE `syslog` ADD INDEX(`auth_id`);

ALTER TABLE `mac_history` DROP INDEX `timestamp`, ADD INDEX `timestamp` (`timestamp`) USING BTREE;
ALTER TABLE `mac_history` DROP INDEX `timestamp_2`;
ALTER TABLE `mac_history` ADD INDEX(`mac`);
ALTER TABLE `mac_history` ADD INDEX(`ip`);