/* The "username" and "location" fields reference a lookup table.

    This log table has an advantages over the old one: 
    1) Storing a redirect is not necessary to have a line in the log.
        This allows us to log ignored requests without creating a redirect for them. 
        This is useful when requests are ignored based on the user agent.  
*/

CREATE TABLE IF NOT EXISTS {wp_abj404_logsv2} (
    `id` bigint(40) NOT NULL auto_increment,
    `timestamp` bigint(40) NOT NULL,
    `user_ip` varchar(512) NOT NULL,
    `referrer` varchar(512) DEFAULT NULL,
    `requested_url` varchar(2048) NOT NULL,
    `requested_url_detail` varchar(2048) DEFAULT NULL,
    `username` bigint(20) DEFAULT NULL,
    `dest_url` varchar(512) NOT NULL,
    `min_log_id` tinyint(1) DEFAULT NULL,
    PRIMARY KEY  (`id`),
    KEY `timestamp` (`timestamp`),
    KEY `requested_url` (`requested_url`(190)) USING BTREE,
    KEY `username` (`username`) USING BTREE,
    KEY `min_log_id` (`min_log_id`),
    KEY `idx_requested_url_timestamp` (`requested_url`(190), `timestamp`)
) COMMENT='404 Solution Plugin Logs Table. Use MyISAM because optimize table is slow otherwise.' AUTO_INCREMENT=1

