Fud30 forum

From FUDforum Wiki
Jump to: navigation, search

Description of FUDforum table fud30_forum. This table contains information about the board's forums. For more information, see Forum Manager.

Fields

Column Name Datatype Can be Null? Key? Default Description
id int(11) NO PRI auto_increment
cat_id int(11) NO MUL 0 References fud30_cat.id.
name varchar(255) NO Forum's name.
descr text YES Forum description.
parent int NO 0 Parent forum id (used for nested forums)
url_redirect varchar(255) YES URL for redirection.
post_passwd varchar(32) YES Password (if Password Posting is enabled).
forum_icon varchar(255) YES Icon to display next to forum.
date_created bigint(20) NO 0 Date forum was created.
thread_count int(11) NO 0 Number of topics in form.
post_count int(11) NO 0 Number of messages in forum.
last_post_id int(11) NO MUL 0 References fud30_msg.id.
view_order int(11) NO 0 Position in list.
max_attach_size int(11) NO 0 Maximum attachment size.
max_file_attachments int(11) NO 1 Maximum number of attachments allowed.
moderators text YES Serialized list of Forum moderators.
message_threshold int(11) NO 0 Maximum size of the message DISPLAYED without a reveal link (0 == unlimited).
forum_opt int(11) NO 16 Options (see below).

Keys

Index Name Uniqueness Column Name Seq in index Comments
PRIMARY UNIQUE id 1
fud30_forum_i_c NOT UNIQUE cat_id 1
fud30_forum_i_lpi NOT UNIQUE last_post_id 1

Options

  • 1 = anon_forum (ON/OFF)
  • 2 = moderated (ON/OFF)
  • 4 = passwd_posting (ON/OFF)
  • 8 = tag_style NONE
  • 16 = tag_style (BBCode/HTML)
  • 32 = mod_attach (ON/OFF)
  • 64 = always_notify_mods (ON/OFF)
FUDforum tables

fud30_action log | fud30_ann forums | fud30_announce | fud30_attach | fud30_avatar | fud30_blocked_logins | fud30_bookmarks | fud30_buddy | fud30_calendar | fud30_cat | fud30_custom_fields | fud30_custom_tags | fud30_email_block | fud30_ext_block | fud30_fc_view | fud30_fl_1 | fud30_fl_pg | fud30_fl_pm | fud30_forum | fud30_forum_notify | fud30_forum_read | fud30_geoip | fud30_group_cache | fud30_group_members | fud30_group_resources | fud30_groups | fud30_index | fud30_ip_block | fud30_jobs | fud30_level | fud30_mime | fud30_mlist | fud30_mod | fud30_msg | fud30_msg_report | fud30_msg_store | fud30_nntp | fud30_pages | fud30_plugins | fud30_pmsg | fud30_poll | fud30_poll_opt | fud30_poll_opt_track | fud30_read | fud30_replace | fud30_search | fud30_search cache | fud30_ses | fud30_smiley | fud30_spiders | fud30_stats_cache | fud30_themes | fud30_thr_exchange | fud30_thread | fud30_thread_notify | fud30_thread_rate_track | fud30_title_index | fud30_tv_1 | fud30_user_ignore | fud30_users | fud30_xmlagg

Languages
Personal tools