Field	Type	Collation	Null	Default	Extra
id	int(10)		No		auto_increment
pretime	timestamp		No	CURRENT_TIMESTAMP	
name	varchar(255)	latin1_general_ci	No		
groupname	varchar(25)	latin1_general_ci	No		
category	varchar(25)	latin1_general_ci	No		
nuketime	timestamp		No	0000-00-00 00:00:00	
nuke	int(1)		No	0	
nuke_reason	varchar(255)	latin1_general_ci	No		
unnuke	int(1)		No	0	
unnuke_reason	varchar(255)	latin1_general_ci	No	



SQL


CREATE TABLE `releases` (
 `id` int(10) NOT NULL auto_increment,
 `pretime` timestamp NOT NULL default CURRENT_TIMESTAMP,
 `name` varchar(255) collate latin1_general_ci NOT NULL default '',
 `groupname` varchar(25) collate latin1_general_ci NOT NULL,
 `category` varchar(25) collate latin1_general_ci NOT NULL,
 `nuketime` timestamp NOT NULL default '0000-00-00 00:00:00',
 `nuke` int(1) NOT NULL default '0',
 `nuke_reason` varchar(255) collate latin1_general_ci NOT NULL default '',
 `unnuke` int(1) NOT NULL default '0',
 `unnuke_reason` varchar(255) collate latin1_general_ci NOT NULL default '',
 PRIMARY KEY  (`name`),
 UNIQUE KEY `id` (`id`),
 KEY `type` (`category`),
 KEY `group` (`groupname`),
 KEY `pretime` (`pretime`)
) NGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1099613 ;