- 4 => array(
- 'ALTER TABLE `ctracker`.`ctracker_data` ADD INDEX `remote_proxy_last` ( `remote_addr`, `proxy_addr`, `last_attempt` DESC )',
- ),
- );
+ [
+ 'ALTER TABLE `ctracker_data` ADD INDEX `remote_proxy_last` ( `remote_addr`, `proxy_addr`, `last_attempt` DESC )',
+ ],
+
+ // HTTP request method
+ [
+ "ALTER TABLE `ctracker_data` ADD `request_method` VARCHAR( 255 ) NULL DEFAULT NULL COMMENT 'HTTP request method' AFTER `referer`, ADD INDEX ( `request_method` )",
+ ],
+
+ // Index on count
+ [
+ 'ALTER TABLE `ctracker_data` ADD INDEX `count` (`count`)',
+ ],
+
+ // Log also UA after check
+ [
+ "ALTER TABLE `ctracker_data`
+ ADD `check_ua` tinytext COLLATE 'utf8_general_ci' NULL COMMENT 'User agent after check' AFTER `post_data`,
+ CHANGE `check_worm` `check_get` tinytext COLLATE 'utf8_general_ci' NOT NULL COMMENT 'GET data after check' AFTER `check_ua`,
+ CHANGE `check_post` `check_post` tinytext COLLATE 'utf8_general_ci' NOT NULL COMMENT 'POST data after check' AFTER `check_worm`",
+ ],
+
+ // View for request methods
+ [
+ 'CREATE VIEW `view_most_request_methods` AS
+ SELECT SQL_CALC_FOUND_ROWS COUNT(`id`) AS `total_rows`, `request_method`
+ FROM `ctracker_data`
+ GROUP BY `request_method`'
+ ],
+ ];