1 DROP TABLE IF EXISTS `ctracker_data`;
2 CREATE TABLE IF NOT EXISTS `ctracker_data` (
3 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Running id number',
4 `remote_addr` varchar(15) NOT NULL COMMENT 'Remote address',
5 `user_agent` tinytext NOT NULL COMMENT 'User agent string',
6 `post_data` tinytext NOT NULL COMMENT 'Serialized POST data',
7 `check_worm` tinytext NOT NULL COMMENT 'Serialized GET data',
8 `check_post` tinytext NOT NULL COMMENT 'Serialized GET data',
9 `server_name` tinytext NOT NULL COMMENT 'Server''s host name',
10 `script_name` varchar(255) NOT NULL COMMENT 'Full script name',
11 `referer` varchar(255) NOT NULL COMMENT 'Referer',
12 `first_attempt` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'First attempt',
13 `last_attempt` timestamp NOT NULL COMMENT 'Last attempt',
14 `count` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Counter',
16 KEY `remote_addr` (`remote_addr`)
17 ) TYPE=InnoDB COMMENT='Gathered data of attack';