PHP-Fusion v6.00.200 duombazės turinys
Parašė Graudonas 2006 liepos 24 21:07:30
borland447_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)
borland447_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_sorting varchar(50) NOT NULL default 'article_subject ASC',
article_cat_access tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (article_cat_id)
borland447_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)
borland447_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)
borland447_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)
borland447_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)
borland447_download_cats
download_cat_id smallint(5) unsigned NOT NULL auto_increment,
download_cat_name varchar(100) NOT NULL default '',
download_cat_description text NOT NULL,
download_cat_sorting varchar(50) NOT NULL default 'download_title ASC',
download_cat_access tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (download_cat_id)
borland447_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)
borland447_faq_cats
faq_cat_id smallint(5) unsigned NOT NULL auto_increment,
faq_cat_name varchar(200) NOT NULL default '',
faq_cat_description varchar(250) NOT NULL default '',
PRIMARY KEY (faq_cat_id)
borland447_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)
borland447_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)
borland447_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)
borland447_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)
borland447_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)
borland447_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)
borland447_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
borland447_news
news_id smallint(5) unsigned NOT NULL auto_increment,
news_subject varchar(200) NOT NULL default '',
news_cat smallint(5) unsigned NOT NULL default '0',
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)
borland447_news_cats
news_cat_id smallint(5) unsigned NOT NULL auto_increment,
news_cat_name varchar(100) NOT NULL default '',
news_cat_image varchar(100) NOT NULL default '',
PRIMARY KEY (news_cat_id)
borland447_online
online_user varchar(50) NOT NULL default '',
online_ip varchar(20) NOT NULL default '',
online_lastactive int(10) unsigned NOT NULL default '0'
borland447_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)
borland447_photo_albums
album_id smallint(5) unsigned NOT NULL auto_increment,
album_title varchar(100) NOT NULL default '',
album_info varchar(200) default '',
album_order smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (album_id)
borland447_photos
photo_id smallint(5) unsigned NOT NULL auto_increment,
album_id smallint(5) unsigned NOT NULL default '0',
photo_title varchar(100) 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)
borland447_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)
borland447_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)
borland447_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)
borland447_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)
borland447_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',
db_backup_folder varchar(200) NOT NULL default 'db_backups/',
tinymce_enabled tinyint(1) unsigned NOT NULL default '0',
smtp_host varchar(200) NOT NULL default '',
smtp_username varchar(100) NOT NULL default '',
smtp_password varchar(100) NOT NULL default '',
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
borland447_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)
borland447_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)
borland447_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)
borland447_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)
borland447_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)
borland447_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 '101',
user_status tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (user_id)
borland447_vcode
vcode_datestamp int(10) unsigned NOT NULL default '0',
vcode_1 varchar(5) NOT NULL default '',
vcode_2 varchar(32) NOT NULL default ''
borland447_weblink_cats
weblink_cat_id smallint(5) unsigned NOT NULL auto_increment,
weblink_cat_name varchar(100) NOT NULL default '',
weblink_cat_description text NOT NULL,
weblink_cat_sorting varchar(50) NOT NULL default 'weblink_name ASC',
weblink_cat_access tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (weblink_cat_id)
borland447_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)