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 ;