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