
CREATE TABLE IF NOT EXISTS {redirectsTable} (
    `id` bigint(30) NOT NULL auto_increment,
    `url` varchar(2048) NOT NULL,
    `status` bigint(20) NOT NULL,
    `type` bigint(20) NOT NULL,
    `final_dest` varchar(2048) NOT NULL,
    `code` bigint(20) NOT NULL,
    `disabled` int(10) NOT NULL default '0',
    `timestamp` bigint(30) NOT NULL,
    PRIMARY KEY  (`id`),
    KEY `status` (`status`),
    KEY `type` (`type`),
    KEY `code` (`code`),
    KEY `timestamp` (`timestamp`),
    KEY `disabled` (`disabled`),
    KEY `url` (`url`(333)) USING BTREE,
    KEY `final_dest` (`final_dest`(333)) USING BTREE
) ENGINE=MyISAM COMMENT='404 Solution Plugin Redirects Table' AUTO_INCREMENT=1

