Fud30 attach

From FUDforum Wiki
Jump to: navigation, search

Description of FUDforum table fud30_attach. This table tracks files that are attached to messages. The Attachment Pruning ACP can be used to delete old attachments.

Fields

Column Name Datatype Can be Null? Key? Default Description
id int(11) NO PRI auto_increment
location varchar(255) NO Path to attachment on disk.
original_name varchar(255) YES Attachment's file name.
owner int(11) NO 0 References fud30_users.id.
attach_opt int(11) NO 0 Attachment options.
message_id int(11) NO MUL 0 References fud30_msg.id.
dlcount int(11) NO 0 Download counter.
mime_type int(11) NO 0 References fud30_mime.id.
fsize int(11) NO 0 Attached file size.

Keys

Index Name Uniqueness Column Name Seq in index Comments
PRIMARY UNIQUE id 1
fud30_attach_i_mp NOT UNIQUE message_id 1
fud30_attach_i_mp NOT UNIQUE attach_opt 2
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