Stuff

CREATE TABLE `predb` (
  `id` int(10) NOT NULL auto_increment,
  `section` varchar(20) NOT NULL default '',
  `rlsname` varchar(255) NOT NULL default '',
  `grp` varchar(50) NOT NULL default '',
  `status` decimal(1,0) NOT NULL default '0',
  `nukereason` varchar(255) default NULL,
  `pretime` decimal(10,0) NOT NULL default '0',
  `size` int(8) default NULL,
  `files` int(6) default NULL,
  `genre` varchar(50) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `rlsname` (`rlsname`),
  KEY `grp` (`grp`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 ;