localhost - predb

archive
Field 	Type 	Null 	Default 	Comments
release_id  	int(11) 	No  	0  	 
release_name  	varchar(255) 	No  	  	 
release_added  	int(11) 	No  	0  	 
section_id  	int(11) 	No  	0  	 
section_filter_pattern  	varchar(255) 	No  	  	 
section_name_alt  	varchar(255) 	No  	  	 
group_id  	int(11) 	No  	0  	 
release_flag  	int(11) 	No  	0  	 
release_flagged  	enum('YES', 'NO') 	No  	NO  	 
release_flagged_pattern  	varchar(255) 	No  	  	 
alt_section_id  	int(11) 	No  	0  	 
release_filecount  	int(11) 	No  	0  	 
release_size  	float 	No  	0  	 
release_genre  	varchar(255) 	No  	  	 
release_nuke_time  	int(11) 	No  	0  	 
release_nuke_reason  	varchar(255) 	No  	  	 
release_nuke_count  	int(11) 	No  	0  	 
release_unnuke_time  	int(11) 	No  	0  	 
release_unnuke_reason  	varchar(255) 	No  	  	 
release_unnuke_count  	int(11) 	No  	0  	 
release_from_nickchan_id  	int(11) 	No  	0  	 
nuke_from_nickchan_id  	int(11) 	No  	0  	 
unnuke_from_nickchan_id  	int(11) 	No  	0  	 
section_determined_time  	int(11) 	No  	0  	 
flag_determined_time  	int(11) 	No  	0  	 

groups
Field 	Type 	Null 	Default 	Comments
group_id  	int(11) 	No  	0  	 
group_name  	varchar(64) 	No  	  	 
group_release_count  	int(11) 	No  	0  	 
group_nuked_releases_count  	int(11) 	No  	0  	 
group_nuke_count  	int(11) 	No  	0  	 
group_unnuke_count  	int(11) 	No  	0  	 
group_stats_refreshed  	int(11) 	No  	0  	 
stats_synced  	enum('YES', 'NO') 	No  	YES  	 
nukes
Field 	Type 	Null 	Default 	Comments
nuke_id  	int(11) 	No  	  	 
release_id  	int(11) 	No  	0  	 
nuke_type  	varchar(32) 	No  	  	 
nuke_time  	int(11) 	No  	0  	 
nuke_reason  	varchar(255) 	No  	  	 

releases
Field 	Type 	Null 	Default 	Comments
id  	int(11) 	No  	  	 
release_id  	int(11) 	No  	0  	 
release_name  	varchar(255) 	No  	  	 
release_added  	int(11) 	No  	0  	 
section_id  	int(11) 	No  	0  	 
section_filter_pattern  	varchar(255) 	No  	  	 
section_name_alt  	varchar(255) 	No  	  	 
group_id  	int(11) 	No  	0  	 
release_nuked  	varchar(255) 	No  	  	 
release_nuked_time  	int(11) 	No  	0  	 
release_unnuked  	varchar(255) 	No  	  	 
release_unnuked_time  	int(11) 	No  	0  	 
release_nukecount  	int(11) 	No  	0  	 
release_flag  	int(11) 	No  	0  	 
release_flagged  	enum('YES', 'NO') 	No  	NO  	 
release_flagged_pattern  	varchar(255) 	No  	  	 
alt_section_id  	int(11) 	No  	0  	 
release_filecount  	int(11) 	No  	0  	 
release_size  	float 	No  	0  	 
release_genre  	varchar(255) 	No  	  	 
release_nuke_time  	int(11) 	No  	0  	 
release_nuke_reason  	varchar(255) 	No  	  	 
release_nuke_count  	int(11) 	No  	0  	 
release_unnuke_time  	int(11) 	No  	0  	 
release_unnuke_reason  	varchar(255) 	No  	  	 
release_unnuke_count  	int(11) 	No  	0  	 
release_from_nickchan_id  	int(11) 	No  	0  	 
nuke_from_nickchan_id  	int(11) 	No  	0  	 
unnuke_from_nickchan_id  	int(11) 	No  	0  	 

sections
Field 	Type 	Null 	Default 	Comments
section_id  	int(11) 	No  	  	 
section_name  	varchar(64) 	No  	  	 
section_color  	mediumint(2) 	No  	0  	 
section_release_count  	int(11) 	No  	0  	 
section_nuked_releases_count  	int(11) 	No  	0  	 
section_nuke_count  	int(11) 	No  	0  	 
section_unnuke_count  	int(11) 	No  	0  	 
stats_synced  	enum('YES', 'NO') 	No  	YES