Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: phorum_forumsphorum_forums
StructureStructure BrowseBrowse SQLSQL SearchSearch InsertInsert ExportExport OperationsOperations EmptyEmpty DropDrop

   Field  Type Collation Attributes Null Default Extra Action
   int(10)   UNSIGNED No    auto_increment  Change Drop Primary Index Unique Fulltext
   varchar(50) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   smallint(6)     No  0    Change Drop Primary Index Unique Fulltext
   text latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(50) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   tinyint(1)     No  0    Change Drop Primary Index Unique Fulltext
   int(10)   UNSIGNED No  0    Change Drop Primary Index Unique Fulltext
   int(10)   UNSIGNED No  0    Change Drop Primary Index Unique Fulltext
   int(10)   UNSIGNED No  0    Change Drop Primary Index Unique Fulltext
   int(10)   UNSIGNED No  0    Change Drop Primary Index Unique Fulltext
   tinyint(4)     No  0    Change Drop Primary Index Unique Fulltext
   tinyint(4)     No  0    Change Drop Primary Index Unique Fulltext
   tinyint(4)     No  0    Change Drop Primary Index Unique Fulltext
   tinyint(4)     No  0    Change Drop Primary Index Unique Fulltext
   varchar(100) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   int(10)   UNSIGNED No  0    Change Drop Primary Index Unique Fulltext
   int(10)   UNSIGNED No  0    Change Drop Primary Index Unique Fulltext
   int(10)   UNSIGNED No  0    Change Drop Primary Index Unique Fulltext
   int(10)   UNSIGNED No  0    Change Drop Primary Index Unique Fulltext
   int(10)   UNSIGNED No  0    Change Drop Primary Index Unique Fulltext
   smallint(5)   UNSIGNED No  1    Change Drop Primary Index Unique Fulltext
   smallint(5)   UNSIGNED No  1    Change Drop Primary Index Unique Fulltext
   varchar(100) latin1_swedish_ci   No  english    Change Drop Primary Index Unique Fulltext
   tinyint(1)     No  0    Change Drop Primary Index Unique Fulltext
   int(10)   UNSIGNED No  0    Change Drop Primary Index Unique Fulltext
   int(10)   UNSIGNED No  0    Change Drop Primary Index Unique Fulltext
   int(10)   UNSIGNED No  0    Change Drop Primary Index Unique Fulltext
   int(10)   UNSIGNED No  0    Change Drop Primary Index Unique Fulltext
   int(10)   UNSIGNED No  0    Change Drop Primary Index Unique Fulltext
   int(10)   UNSIGNED No  0    Change Drop Primary Index Unique Fulltext
   int(10)   UNSIGNED No  0    Change Drop Primary Index Unique Fulltext
   tinyint(1)     No  1    Change Drop Primary Index Unique Fulltext
   text latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   tinyint(1)   UNSIGNED No  0    Change Drop Primary Index Unique Fulltext
   tinyint(1)   UNSIGNED No  0    Change Drop Primary Index Unique Fulltext
   tinyint(1)     No  0    Change Drop Primary Index Unique Fulltext
   int(10)   UNSIGNED Yes  NULL    Change Drop Primary Index Unique Fulltext
With selected: Check All  /  Uncheck All     With selected:  
Print viewPrint view    Propose table structurePropose table structureDocumentation
Add new fieldAdd new field: 
StructureStructure BrowseBrowse SQLSQL SearchSearch InsertInsert ExportExport OperationsOperations EmptyEmpty DropDrop

Indexes: Documentation
Keyname Type Cardinality Action Field
PRIMARY PRIMARY 1  Edit Drop forum_id
forum_id_2 UNIQUE 1  Edit Drop forum_id
name_3 UNIQUE 1  Edit Drop name
active_3 UNIQUE 1  Edit Drop active
template_2 UNIQUE 1  Edit Drop template
folder_flag_2 UNIQUE 1  Edit Drop folder_flag
parent_id_2 UNIQUE 1  Edit Drop parent_id
list_length_flat_2 UNIQUE 1  Edit Drop list_length_flat
list_length_threaded_2 UNIQUE 1  Edit Drop list_length_threaded
moderation_2 UNIQUE 1  Edit Drop moderation
threaded_list_2 UNIQUE 1  Edit Drop threaded_list
threaded_read_2 UNIQUE 1  Edit Drop threaded_read
float_to_top_2 UNIQUE 1  Edit Drop float_to_top
check_duplicate_2 UNIQUE 1  Edit Drop check_duplicate
allow_attachment_types_2 UNIQUE 1  Edit Drop allow_attachment_types
max_attachment_size_2 UNIQUE 1  Edit Drop max_attachment_size
max_totalattachment_size_2 UNIQUE 1  Edit Drop max_totalattachment_size
max_attachments_2 UNIQUE 1  Edit Drop max_attachments
pub_perms_2 UNIQUE 1  Edit Drop pub_perms
reg_perms_2 UNIQUE 1  Edit Drop reg_perms
display_ip_address_2 UNIQUE 1  Edit Drop display_ip_address
allow_email_notify_2 UNIQUE 1  Edit Drop allow_email_notify
language_2 UNIQUE 1  Edit Drop language
email_moderators_2 UNIQUE 1  Edit Drop email_moderators
message_count_2 UNIQUE 1  Edit Drop message_count
sticky_count_2 UNIQUE 1  Edit Drop sticky_count
thread_count_2 UNIQUE 1  Edit Drop thread_count
last_post_time_2 UNIQUE 1  Edit Drop last_post_time
name INDEX None  Edit Drop name
active INDEX None  Edit Drop active
parent_id
group_id INDEX None  Edit Drop parent_id
forum_id INDEX None  Edit Drop forum_id
name_2 INDEX None  Edit Drop name
active_2 INDEX None  Edit Drop active
template INDEX None  Edit Drop template
folder_flag INDEX None  Edit Drop folder_flag
parent_id INDEX None  Edit Drop parent_id
list_length_flat INDEX None  Edit Drop list_length_flat
list_length_threaded INDEX None  Edit Drop list_length_threaded
moderation INDEX None  Edit Drop moderation
threaded_list INDEX None  Edit Drop threaded_list
threaded_read INDEX None  Edit Drop threaded_read
float_to_top INDEX None  Edit Drop float_to_top
check_duplicate INDEX None  Edit Drop check_duplicate
allow_attachment_types INDEX None  Edit Drop allow_attachment_types
max_attachment_size INDEX None  Edit Drop max_attachment_size
max_totalattachment_size INDEX None  Edit Drop max_totalattachment_size
max_attachments INDEX None  Edit Drop max_attachments
pub_perms INDEX None  Edit Drop pub_perms
reg_perms INDEX None  Edit Drop reg_perms
display_ip_address INDEX None  Edit Drop display_ip_address
allow_email_notify INDEX None  Edit Drop allow_email_notify
language INDEX None  Edit Drop language
email_moderators INDEX None  Edit Drop email_moderators
message_count INDEX None  Edit Drop message_count
sticky_count INDEX None  Edit Drop sticky_count
thread_count INDEX None  Edit Drop thread_count
last_post_time INDEX None  Edit Drop last_post_time
display_order INDEX None  Edit Drop display_order
name_4 FULLTEXT None  Edit Drop name
description FULLTEXT None  Edit Drop description
template_3 FULLTEXT None  Edit Drop template
allow_attachment_types_3 FULLTEXT None  Edit Drop allow_attachment_types
language_3 FULLTEXT None  Edit Drop language
Create an index on  columns  
 
Space usage: 
Type Usage
Data 156 Bytes
Index 4,096 Bytes
Total 4,252 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
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 10, 2024 at 01:43 AM
Run SQL query/queries on database puropartyDocumentation     Fields: 
Or Location of the textfile: 
 Location of the textfile: 
   (Max: 2,048KB)
  Compression:
                
Character set of the file: