Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: phorum_forumsphorum_forums

phorum_forums

Field Type Null Default
forum_id  int(10) No   
name  varchar(50) No   
active  smallint(6) No 
description  text Yes  NULL 
template  varchar(50) No   
folder_flag  tinyint(1) No 
parent_id  int(10) No 
list_length_flat  int(10) No 
list_length_threaded  int(10) No 
moderation  int(10) No 
threaded_list  tinyint(4) No 
threaded_read  tinyint(4) No 
float_to_top  tinyint(4) No 
check_duplicate  tinyint(4) No 
allow_attachment_types  varchar(100) No   
max_attachment_size  int(10) No 
max_totalattachment_size  int(10) No 
max_attachments  int(10) No 
pub_perms  int(10) No 
reg_perms  int(10) No 
display_ip_address  smallint(5) No 
allow_email_notify  smallint(5) No 
language  varchar(100) No  english 
email_moderators  tinyint(1) No 
message_count  int(10) No 
sticky_count  int(10) No 
thread_count  int(10) No 
last_post_time  int(10) No 
display_order  int(10) No 
read_length  int(10) No 
vroot  int(10) No 
edit_post  tinyint(1) No 
template_settings  text Yes  NULL 
count_views  tinyint(1) No 
display_fixed  tinyint(1) No 
reverse_threading  tinyint(1) No 
inherit_id  int(10) Yes  NULL 


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 1 forum_id
forum_id_2 UNIQUE 1 forum_id
name_3 UNIQUE 1 name
active_3 UNIQUE 1 active
template_2 UNIQUE 1 template
folder_flag_2 UNIQUE 1 folder_flag
parent_id_2 UNIQUE 1 parent_id
list_length_flat_2 UNIQUE 1 list_length_flat
list_length_threaded_2 UNIQUE 1 list_length_threaded
moderation_2 UNIQUE 1 moderation
threaded_list_2 UNIQUE 1 threaded_list
threaded_read_2 UNIQUE 1 threaded_read
float_to_top_2 UNIQUE 1 float_to_top
check_duplicate_2 UNIQUE 1 check_duplicate
allow_attachment_types_2 UNIQUE 1 allow_attachment_types
max_attachment_size_2 UNIQUE 1 max_attachment_size
max_totalattachment_size_2 UNIQUE 1 max_totalattachment_size
max_attachments_2 UNIQUE 1 max_attachments
pub_perms_2 UNIQUE 1 pub_perms
reg_perms_2 UNIQUE 1 reg_perms
display_ip_address_2 UNIQUE 1 display_ip_address
allow_email_notify_2 UNIQUE 1 allow_email_notify
language_2 UNIQUE 1 language
email_moderators_2 UNIQUE 1 email_moderators
message_count_2 UNIQUE 1 message_count
sticky_count_2 UNIQUE 1 sticky_count
thread_count_2 UNIQUE 1 thread_count
last_post_time_2 UNIQUE 1 last_post_time
name INDEX None name
active INDEX None active
parent_id
group_id INDEX None parent_id
forum_id INDEX None forum_id
name_2 INDEX None name
active_2 INDEX None active
template INDEX None template
folder_flag INDEX None folder_flag
parent_id INDEX None parent_id
list_length_flat INDEX None list_length_flat
list_length_threaded INDEX None list_length_threaded
moderation INDEX None moderation
threaded_list INDEX None threaded_list
threaded_read INDEX None threaded_read
float_to_top INDEX None float_to_top
check_duplicate INDEX None check_duplicate
allow_attachment_types INDEX None allow_attachment_types
max_attachment_size INDEX None max_attachment_size
max_totalattachment_size INDEX None max_totalattachment_size
max_attachments INDEX None max_attachments
pub_perms INDEX None pub_perms
reg_perms INDEX None reg_perms
display_ip_address INDEX None display_ip_address
allow_email_notify INDEX None allow_email_notify
language INDEX None language
email_moderators INDEX None email_moderators
message_count INDEX None message_count
sticky_count INDEX None sticky_count
thread_count INDEX None thread_count
last_post_time INDEX None last_post_time
display_order INDEX None display_order
name_4 INDEX None name
description INDEX None description
template_3 INDEX None template
allow_attachment_types_3 INDEX None allow_attachment_types
language_3 INDEX None language


 Space usage :
Type Usage
Data 156 Bytes
Index 4,096 Bytes
Total 4,252 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 1
Row length ø 156
Row size  ø 4,252 Bytes
Next Autoindex 2
Creation Oct 08, 2017 at 10:29 PM
Last update Mar 30, 2018 at 09:02 PM
Last check Mar 30, 2018 at 09:02 PM