CREATE TABLE `pre` (
  `id` int(11) UNSIGNED NOT NULL auto_increment,
  `cat` char(15) NOT NULL default '',
  `title` char(255) NOT NULL default '',
  `pretime` int(10) UNSIGNED NOT NULL default '0',
  `nuketime` int(10) UNSIGNED NOT NULL default '0',
  `nukereason` char(100) default NULL,
  `genre` char(20) NOT NULL default '',
  `rlssize` int() UNSIGNED NOT NULL default '0',
  `files` smallint(5) UNSIGNED NOT NULL default '0',
  `grp` char(30) NOT NULL default '',
  `nukelock` smallint(4) UNSIGNED NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `uk_title` (`title`),
  KEY `k_pretime` (`pretime`),
  KEY `k_group` (`group`),
  KEY `k_cat` (`cat`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2576891 ;