v6.00.1 Database Structure

fusion_admin

admin_id tinyint(2) unsigned NOT NULL auto_increment,
admin_rights char(2) NOT NULL default '',
admin_image varchar(50) NOT NULL default '',
admin_title varchar(50) NOT NULL default '',
admin_link varchar(100) NOT NULL default 'reserved',
admin_page tinyint(1) unsigned NOT NULL default '1',
PRIMARY KEY (admin_id)

fusion_article_cats

article_cat_id smallint(5) unsigned NOT NULL auto_increment,
article_cat_name varchar(100) NOT NULL default '',
article_cat_description varchar(200) NOT NULL default '',
article_cat_access tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (article_cat_id)

fusion_articles

article_id smallint(5) unsigned NOT NULL auto_increment,
article_cat smallint(5) unsigned NOT NULL default '0',
article_subject varchar(200) NOT NULL default '',
article_snippet text NOT NULL,
article_article text NOT NULL,
article_breaks char(1) NOT NULL default '',
article_name smallint(5) unsigned NOT NULL default '1',
article_datestamp int(10) unsigned NOT NULL default '0',
article_reads smallint(5) unsigned NOT NULL default '0',
article_allow_comments tinyint(1) unsigned NOT NULL default '1',
article_allow_ratings tinyint(1) unsigned NOT NULL default '1',
PRIMARY KEY (article_id)

fusion_blacklist

blacklist_id smallint(5) unsigned NOT NULL auto_increment,
blacklist_ip varchar(20) NOT NULL default '',
blacklist_email varchar(100) NOT NULL default '',
blacklist_reason text NOT NULL,
PRIMARY KEY (blacklist_id)

fusion_comments

comment_id smallint(5) unsigned NOT NULL auto_increment,
comment_item_id smallint(5) unsigned NOT NULL default '0',
comment_type char(1) NOT NULL default '',
comment_name varchar(50) NOT NULL default '',
comment_message text NOT NULL,
comment_smileys tinyint(1) unsigned NOT NULL default '1',
comment_datestamp int(10) unsigned NOT NULL default '0',
comment_ip varchar(20) NOT NULL default '0.0.0.0',
PRIMARY KEY (comment_id)

fusion_custom_pages

page_id smallint(5) NOT NULL auto_increment,
page_title varchar(200) NOT NULL default '',
page_access tinyint(3) unsigned NOT NULL default '0',
page_content text NOT NULL,
page_allow_comments tinyint(1) unsigned NOT NULL default '0',
page_allow_ratings tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (page_id)

fusion_download_cats

download_cat_id smallint(5) unsigned NOT NULL auto_increment,
download_cat_name varchar(100) NOT NULL default '',
download_cat_description varchar(250) NOT NULL default '',
download_cat_access tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (download_cat_id)

fusion_downloads

download_id smallint(5) unsigned NOT NULL auto_increment,
download_title varchar(100) NOT NULL default '',
download_description text NOT NULL,
download_url varchar(200) NOT NULL default '',
download_cat smallint(5) unsigned NOT NULL default '0',
download_license varchar(50) NOT NULL default '',
download_os varchar(50) NOT NULL default '',
download_version varchar(20) NOT NULL default '',
download_filesize varchar(20) NOT NULL default '',
download_datestamp int(10) unsigned NOT NULL default '0',
download_count smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (download_id)

fusion_faq_cats

faq_cat_id smallint(5) unsigned NOT NULL auto_increment,
faq_cat_name varchar(200) NOT NULL default '',
PRIMARY KEY (faq_cat_id)

fusion_faqs

faq_id smallint(5) unsigned NOT NULL auto_increment,
faq_cat_id smallint(5) unsigned NOT NULL default '0',
faq_question varchar(200) NOT NULL default '',
faq_answer text NOT NULL,
PRIMARY KEY (faq_id)


forum_attachments

attach_id smallint(5) unsigned NOT NULL auto_increment,
thread_id smallint(5) unsigned NOT NULL default '0',
post_id smallint(5) unsigned NOT NULL default '0',
attach_name varchar(100) NOT NULL default '',
attach_ext varchar(5) NOT NULL default '',
attach_size int(20) unsigned NOT NULL default '0',
PRIMARY KEY (attach_id)

forums

forum_id smallint(5) unsigned NOT NULL auto_increment,
forum_cat smallint(5) unsigned NOT NULL default '0',
forum_name varchar(100) NOT NULL default '',
forum_order smallint(5) unsigned NOT NULL default '0',
forum_description text NOT NULL,
forum_moderators text NOT NULL,
forum_access tinyint(3) unsigned NOT NULL default '0',
forum_posting tinyint(3) unsigned NOT NULL default '0',
forum_lastpost int(10) unsigned NOT NULL default '0',
forum_lastuser smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (forum_id)

fusion_guestbook

guestbook_id smallint(5) unsigned NOT NULL auto_increment,
guestbook_name varchar(50) NOT NULL default '',
guestbook_email varchar(100) NOT NULL default '',
guestbook_weburl varchar(200) NOT NULL default '',
guestbook_webtitle varchar(50) NOT NULL default '',
guestbook_message text NOT NULL,
guestbook_datestamp int(10) unsigned NOT NULL default '0',
guestbook_ip varchar(20) NOT NULL default '0.0.0.0',
PRIMARY KEY (guestbook_id)

fusion_infusions

inf_id smallint(5) unsigned NOT NULL auto_increment,
inf_title varchar(100) NOT NULL default '',
inf_folder varchar(100) NOT NULL default '',
inf_version varchar(10) NOT NULL default '0',
PRIMARY KEY (inf_id)

fusion_messages

message_id smallint(5) unsigned NOT NULL auto_increment,
message_to smallint(5) unsigned NOT NULL default '0',
message_from smallint(5) unsigned NOT NULL default '0',
message_subject varchar(100) NOT NULL default '',
message_message text NOT NULL,
message_smileys char(1) NOT NULL default '',
message_read tinyint(1) unsigned NOT NULL default '0',
message_datestamp int(10) unsigned NOT NULL default '0',
message_folder tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (message_id)

fusion_messages_options

user_id smallint(5) unsigned NOT NULL default '0',
pm_email_notify tinyint(1) unsigned NOT NULL default '0',
pm_save_sent tinyint(1) unsigned NOT NULL default '0',
pm_inbox smallint(5) unsigned NOT NULL default '0',
pm_savebox smallint(5) unsigned NOT NULL default '0',
pm_sentbox smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (user_id)

fusion_new_users

user_code varchar(32) NOT NULL default '',
user_email varchar(100) NOT NULL default '',
user_datestamp int(10) unsigned NOT NULL default '0',
user_info text NOT NULL

fusion_news

news_id smallint(5) unsigned NOT NULL auto_increment,
news_subject varchar(200) NOT NULL default '',
news_news text NOT NULL,
news_extended text NOT NULL,
news_breaks char(1) NOT NULL default '',
news_name smallint(5) unsigned NOT NULL default '1',
news_datestamp int(10) unsigned NOT NULL default '0',
news_start int(10) unsigned NOT NULL default '0',
news_end int(10) unsigned NOT NULL default '0',
news_visibility tinyint(3) unsigned NOT NULL default '0',
news_reads smallint(5) unsigned NOT NULL default '0',
news_allow_comments tinyint(1) unsigned NOT NULL default '1',
news_allow_ratings tinyint(1) unsigned NOT NULL default '1',
PRIMARY KEY (news_id)

fusion_online

online_user varchar(50) NOT NULL default '',
online_ip varchar(20) NOT NULL default '',
online_lastactive int(10) unsigned NOT NULL default '0'

fusion_panels

panel_id smallint(5) unsigned NOT NULL auto_increment,
panel_name varchar(100) NOT NULL default '',
panel_filename varchar(100) NOT NULL default '',
panel_content text NOT NULL,
panel_side tinyint(1) unsigned NOT NULL default '0',
panel_order smallint(5) unsigned NOT NULL default '0',
panel_type varchar(20) NOT NULL default '',
panel_access tinyint(3) unsigned NOT NULL default '0',
panel_status tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (panel_id)

fusion_photo_albums

album_id smallint(5) unsigned NOT NULL auto_increment,
album_title varchar(50) NOT NULL default '',
album_info varchar(200) default '',
album_order smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (album_id)

fusion_photos

photo_id smallint(5) unsigned NOT NULL auto_increment,
album_id smallint(5) unsigned NOT NULL default '0',
photo_title varchar(50) NOT NULL default '',
photo_date int(10) unsigned NOT NULL default '0',
user_id smallint(5) unsigned NOT NULL default '0',
photo_views smallint(5) unsigned NOT NULL default '0',
photo_order smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (photo_id)

fusion_poll_votes

vote_id smallint(5) unsigned NOT NULL auto_increment,
vote_user smallint(5) unsigned NOT NULL default '0',
vote_opt smallint(2) unsigned NOT NULL default '0',
poll_id smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (vote_id)

fusion_polls

poll_id smallint(5) unsigned NOT NULL auto_increment,
poll_title varchar(200) NOT NULL default '',
poll_opt_0 varchar(200) NOT NULL default '',
poll_opt_1 varchar(200) NOT NULL default '',
poll_opt_2 varchar(200) NOT NULL default '',
poll_opt_3 varchar(200) NOT NULL default '',
poll_opt_4 varchar(200) NOT NULL default '',
poll_opt_5 varchar(200) NOT NULL default '',
poll_opt_6 varchar(200) NOT NULL default '',
poll_opt_7 varchar(200) NOT NULL default '',
poll_opt_8 varchar(200) NOT NULL default '',
poll_opt_9 varchar(200) NOT NULL default '',
poll_started int(10) unsigned NOT NULL default '0',
poll_ended int(10) unsigned NOT NULL default '0',
PRIMARY KEY (poll_id)

fusion_posts

forum_id smallint(5) unsigned NOT NULL default '0',
thread_id smallint(5) unsigned NOT NULL default '0',
post_id smallint(5) unsigned NOT NULL auto_increment,
post_subject varchar(100) NOT NULL default '',
post_message text NOT NULL,
post_showsig tinyint(1) unsigned NOT NULL default '0',
post_smileys tinyint(1) unsigned NOT NULL default '1',
post_author smallint(5) unsigned NOT NULL default '0',
post_datestamp int(10) unsigned NOT NULL default '0',
post_ip varchar(20) NOT NULL default '0.0.0.0',
post_edituser smallint(5) unsigned NOT NULL default '0',
post_edittime int(10) unsigned NOT NULL default '0',
PRIMARY KEY (post_id)

fusion_ratings

rating_id smallint(5) unsigned NOT NULL auto_increment,
rating_item_id smallint(5) unsigned NOT NULL default '0',
rating_type char(1) NOT NULL default '',
rating_user smallint(5) unsigned NOT NULL default '0',
rating_vote tinyint(1) unsigned NOT NULL default '0',
rating_datestamp int(10) unsigned NOT NULL default '0',
rating_ip varchar(20) NOT NULL default '0.0.0.0',
PRIMARY KEY (rating_id)

fusion_settings

sitename varchar(200) NOT NULL default '',
siteurl varchar(200) NOT NULL default '',
sitebanner varchar(200) NOT NULL default '',
siteemail varchar(100) NOT NULL default '',
siteusername varchar(30) NOT NULL default '',
siteintro text NOT NULL,
description text NOT NULL,
keywords text NOT NULL,
footer text NOT NULL,
opening_page varchar(100) NOT NULL default '',
locale varchar(20) NOT NULL default 'English',
theme varchar(100) NOT NULL default '',
shortdate varchar(50) NOT NULL default '',
longdate varchar(50) NOT NULL default '',
forumdate varchar(50) NOT NULL default '',
subheaderdate varchar(50) NOT NULL default '',
timeoffset char(3) NOT NULL default '0',
numofthreads smallint(2) unsigned NOT NULL default '5',
attachments tinyint(1) unsigned NOT NULL default '0',
attachmax int(12) unsigned NOT NULL default '150000',
attachtypes varchar(150) NOT NULL default '.gif,.jpg,.png,.zip,.rar,.tar',
enable_registration tinyint(1) unsigned NOT NULL default '1',
email_verification tinyint(1) unsigned NOT NULL default '1',
admin_activation tinyint(1) unsigned NOT NULL default '0',
display_validation tinyint(1) unsigned NOT NULL default '1',
validation_method varchar(5) NOT NULL default 'image',
album_image_w smallint(3) unsigned NOT NULL default '80',
album_image_h smallint(3) unsigned NOT NULL default '60',
thumb_image_w smallint(3) unsigned NOT NULL default '120',
thumb_image_h smallint(3) unsigned NOT NULL default '100',
thumb_compression char(3) NOT NULL default 'gd2',
album_comments tinyint(1) unsigned NOT NULL default '1',
albums_per_row smallint(2) unsigned NOT NULL default '4',
albums_per_page smallint(2) unsigned NOT NULL default '16',
thumbs_per_row smallint(2) unsigned NOT NULL default '4',
thumbs_per_page smallint(2) unsigned NOT NULL default '12',
album_max_w smallint(4) unsigned NOT NULL default '400',
album_max_h smallint(4) unsigned NOT NULL default '300',
album_max_b int(10) unsigned NOT NULL default '150000',
bad_words_enabled tinyint(1) unsigned NOT NULL default '0',
bad_words text NOT NULL,
bad_word_replace varchar(20) NOT NULL default '[censored]',
guestposts tinyint(1) unsigned NOT NULL default '0',
numofshouts tinyint(2) unsigned NOT NULL default '10',
counter bigint(20) unsigned NOT NULL default '0',
version varchar(10) NOT NULL default '6.00',
maintenance tinyint(1) unsigned NOT NULL default '0',
maintenance_message text NOT NULL

fusion_shoutbox

shout_id smallint(5) unsigned NOT NULL auto_increment,
shout_name varchar(50) NOT NULL default '',
shout_message varchar(200) NOT NULL default '',
shout_datestamp int(10) unsigned NOT NULL default '0',
shout_ip varchar(20) NOT NULL default '0.0.0.0',
PRIMARY KEY (shout_id)

fusion_site_links

link_id smallint(5) unsigned NOT NULL auto_increment,
link_name varchar(100) NOT NULL default '',
link_url varchar(200) NOT NULL default '',
link_visibility tinyint(3) unsigned NOT NULL default '0',
link_position tinyint(1) unsigned NOT NULL default '1',
link_window tinyint(1) unsigned NOT NULL default '0',
link_order smallint(2) unsigned NOT NULL default '0',
PRIMARY KEY (link_id)

fusion_submissions

submit_id smallint(5) unsigned NOT NULL auto_increment,
submit_type char(1) NOT NULL default '',
submit_user smallint(5) unsigned NOT NULL default '0',
submit_datestamp int(10) unsigned NOT NULL default '0',
submit_criteria text NOT NULL,
PRIMARY KEY (submit_id)

fusion_threads

forum_id smallint(5) unsigned NOT NULL default '0',
thread_id smallint(5) unsigned NOT NULL auto_increment,
thread_subject varchar(100) NOT NULL default '',
thread_author smallint(5) unsigned NOT NULL default '0',
thread_views smallint(5) unsigned NOT NULL default '0',
thread_lastpost int(10) unsigned NOT NULL default '0',
thread_lastuser smallint(5) unsigned NOT NULL default '0',
thread_sticky tinyint(1) unsigned NOT NULL default '0',
thread_locked tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (thread_id)

fusion_user_groups

group_id tinyint(3) unsigned NOT NULL auto_increment,
group_name varchar(100) NOT NULL default '',
group_description varchar(200) NOT NULL default '',
PRIMARY KEY (group_id)

fusion_users

user_id smallint(5) unsigned NOT NULL auto_increment,
user_name varchar(30) NOT NULL default '',
user_password varchar(32) NOT NULL default '',
user_email varchar(100) NOT NULL default '',
user_hide_email tinyint(1) unsigned NOT NULL default '1',
user_location varchar(50) NOT NULL default '',
user_birthdate date NOT NULL default '0000-00-00',
user_aim varchar(16) NOT NULL default '',
user_icq varchar(15) NOT NULL default '',
user_msn varchar(100) NOT NULL default '',
user_yahoo varchar(100) NOT NULL default '',
user_web varchar(200) NOT NULL default '',
user_theme varchar(100) NOT NULL default 'Default',
user_offset char(3) NOT NULL default '0',
user_avatar varchar(100) NOT NULL default '',
user_sig text NOT NULL,
user_posts smallint(5) unsigned NOT NULL default '0',
user_joined int(10) unsigned NOT NULL default '0',
user_lastvisit int(10) unsigned NOT NULL default '0',
user_ip varchar(20) NOT NULL default '0.0.0.0',
user_rights text NOT NULL,
user_groups text NOT NULL,
user_level tinyint(3) unsigned NOT NULL default '250',
user_status tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (user_id)

fusion_vcode

vcode_datestamp int(10) unsigned NOT NULL default '0',
vcode_1 varchar(5) NOT NULL default '',
vcode_2 varchar(32) NOT NULL default ''

fusion_weblink_cats

weblink_cat_id smallint(5) unsigned NOT NULL auto_increment,
weblink_cat_name varchar(100) NOT NULL default '',
weblink_cat_description varchar(200) NOT NULL default '',
weblink_cat_access tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (weblink_cat_id)

fusion_weblinks

weblink_id smallint(5) unsigned NOT NULL auto_increment,
weblink_name varchar(100) NOT NULL default '',
weblink_description text NOT NULL,
weblink_url varchar(200) NOT NULL default '',

weblink_cat smallint(5) unsigned NOT NULL default '0',
weblink_datestamp int(10) unsigned NOT NULL default '0',
weblink_count smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (weblink_id)