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

   Field  Type Collation Attributes Null Default Extra Action
   int(10)   UNSIGNED No    auto_increment  Change Drop Primary Index Unique Fulltext
   int(10)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   int(10)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   int(10)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   varchar(37) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   text latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(100) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   tinyint(4)     No    Change Drop Primary Index Unique Fulltext
   varchar(100) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   int(10)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   int(10)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   int(10)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   tinyint(3)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   tinyint(4)     No    Change Drop Primary Index Unique Fulltext
   int(10)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   mediumtext latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   int(10)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   tinyint(4)     No    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: 

Indexes: Documentation
Keyname Type Cardinality Action Field
PRIMARY PRIMARY Edit Drop message_id
message_id_2 UNIQUE Edit Drop message_id
subject_2 UNIQUE Edit Drop subject
msgid_2 UNIQUE Edit Drop msgid
modifystamp_2 UNIQUE Edit Drop modifystamp
thread_count_2 UNIQUE Edit Drop thread_count
datestamp_2 UNIQUE Edit Drop datestamp
thread_count_3 UNIQUE Edit Drop thread_count
msgid_5 UNIQUE Edit Drop msgid
subject_4 UNIQUE Edit Drop subject
datestamp_4 UNIQUE Edit Drop datestamp
modifystamp_4 UNIQUE Edit Drop modifystamp
thread_message INDEX None  Edit Drop thread
message_id
thread_forum INDEX None  Edit Drop thread
forum_id
special_threads INDEX None  Edit Drop sort
forum_id
status_forum INDEX None  Edit Drop status
forum_id
list_page_float INDEX None  Edit Drop forum_id
parent_id
modifystamp
list_page_flat INDEX None  Edit Drop forum_id
parent_id
thread
post_count INDEX None  Edit Drop forum_id
status
parent_id
dup_check INDEX None  Edit Drop forum_id
author
subject
datestamp
forum_max_message INDEX None  Edit Drop forum_id
message_id
status
parent_id
last_post_time INDEX None  Edit Drop forum_id
status
modifystamp
next_prev_thread INDEX None  Edit Drop forum_id
status
thread
user_id INDEX None  Edit Drop user_id
message_id INDEX None  Edit Drop message_id
forum_id INDEX None  Edit Drop forum_id
thread INDEX None  Edit Drop thread
parent_id INDEX None  Edit Drop parent_id
author INDEX None  Edit Drop author
subject INDEX None  Edit Drop subject
email INDEX None  Edit Drop email
ip INDEX None  Edit Drop ip
status INDEX None  Edit Drop status
msgid INDEX None  Edit Drop msgid
modifystamp INDEX None  Edit Drop modifystamp
user_id_2 INDEX None  Edit Drop user_id
thread_count INDEX None  Edit Drop thread_count
moderator_post INDEX None  Edit Drop moderator_post
sort INDEX None  Edit Drop sort
datestamp INDEX None  Edit Drop datestamp
viewcount INDEX None  Edit Drop viewcount
closed INDEX None  Edit Drop closed
user_id_3 INDEX None  Edit Drop user_id
modifystamp_3 INDEX None  Edit Drop modifystamp
email_3 INDEX None  Edit Drop email
msgid_4 INDEX None  Edit Drop msgid
viewcount_2 INDEX None  Edit Drop viewcount
forum_id_2 INDEX None  Edit Drop forum_id
sort_2 INDEX None  Edit Drop sort
moderator_post_2 INDEX None  Edit Drop moderator_post
thread_2 INDEX None  Edit Drop thread
parent_id_2 INDEX None  Edit Drop parent_id
datestamp_3 INDEX None  Edit Drop datestamp
thread_count_4 INDEX None  Edit Drop thread_count
author_2 FULLTEXT None  Edit Drop author
subject_3 FULLTEXT None  Edit Drop subject
body FULLTEXT None  Edit Drop body
email_2 FULLTEXT None  Edit Drop email
ip_2 FULLTEXT None  Edit Drop ip
msgid_3 FULLTEXT None  Edit Drop msgid
meta FULLTEXT None  Edit Drop meta
msgid_6 FULLTEXT None  Edit Drop msgid
ip_3 FULLTEXT None  Edit Drop ip
email_4 FULLTEXT None  Edit Drop email
Create an index on  columns  
 
Space usage: 
Type Usage
Data 868 Bytes
Index 4,096 Bytes
Total 4,964 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 3
Row length ø 289
Row size  ø 1,655 Bytes
Next Autoindex 4
Creation Oct 19, 2017 at 12:40 PM
Last update Apr 08, 2018 at 08:01 PM
Last check Apr 08, 2018 at 08:01 PM

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: