Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: phorum_pm_xrefphorum_pm_xref
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0554 sec)
SQL-query: 
SELECT *
FROM `phorum_pm_xref`
PROCEDURE ANALYSE ( )
 [Edit] [Explain SQL] [Create PHP Code] [Refresh]


   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
   varchar(10) latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   int(10)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   tinyint(1)     No    Change Drop Primary Index Unique Fulltext
   tinyint(1)     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 pm_xref_id
pm_xref_id_2 UNIQUE Edit Drop pm_xref_id
user_id_2 UNIQUE Edit Drop user_id
pm_folder_id_2 UNIQUE Edit Drop pm_folder_id
pm_message_id_2 UNIQUE Edit Drop pm_message_id
read_flag_3 UNIQUE Edit Drop read_flag
reply_flag_2 UNIQUE Edit Drop reply_flag
reply_flag_3 UNIQUE Edit Drop reply_flag
user_id_4 UNIQUE Edit Drop user_id
pm_folder_id_3 UNIQUE Edit Drop pm_folder_id
pm_message_id_4 UNIQUE Edit Drop pm_message_id
pm_xref_id_4 UNIQUE Edit Drop pm_xref_id
read_flag_5 UNIQUE Edit Drop read_flag
pm_message_id_5 UNIQUE Edit Drop pm_message_id
read_flag_6 UNIQUE Edit Drop read_flag
pm_folder_id_6 UNIQUE Edit Drop pm_folder_id
user_id_6 UNIQUE Edit Drop user_id
reply_flag_6 UNIQUE Edit Drop reply_flag
pm_xref_id_6 UNIQUE Edit Drop pm_xref_id
pm_message_id_7 UNIQUE Edit Drop pm_message_id
user_id_7 UNIQUE Edit Drop user_id
reply_flag_7 UNIQUE Edit Drop reply_flag
pm_folder_id_8 UNIQUE Edit Drop pm_folder_id
read_flag_9 UNIQUE Edit Drop read_flag
pm_xref_id_8 UNIQUE Edit Drop pm_xref_id
user_id_9 UNIQUE Edit Drop user_id
special_folder_2 UNIQUE None  Edit Drop special_folder
special_folder_5 UNIQUE None  Edit Drop special_folder
special_folder_8 UNIQUE None  Edit Drop special_folder
special_folder_10 UNIQUE None  Edit Drop special_folder
xref INDEX None  Edit Drop user_id
pm_folder_id
pm_message_id
read_flag INDEX None  Edit Drop read_flag
pm_xref_id INDEX None  Edit Drop pm_xref_id
user_id INDEX None  Edit Drop user_id
pm_folder_id INDEX None  Edit Drop pm_folder_id
special_folder INDEX None  Edit Drop special_folder
pm_message_id INDEX None  Edit Drop pm_message_id
read_flag_2 INDEX None  Edit Drop read_flag
reply_flag INDEX None  Edit Drop reply_flag
pm_xref_id_3 INDEX None  Edit Drop pm_xref_id
read_flag_4 INDEX None  Edit Drop read_flag
pm_message_id_3 INDEX None  Edit Drop pm_message_id
user_id_3 INDEX None  Edit Drop user_id
pm_folder_id_4 INDEX None  Edit Drop pm_folder_id
special_folder_6 INDEX None  Edit Drop special_folder
reply_flag_4 INDEX None  Edit Drop reply_flag
pm_xref_id_5 INDEX None  Edit Drop pm_xref_id
special_folder_7 INDEX None  Edit Drop special_folder
user_id_5 INDEX None  Edit Drop user_id
pm_folder_id_5 INDEX None  Edit Drop pm_folder_id
reply_flag_5 INDEX None  Edit Drop reply_flag
pm_message_id_6 INDEX None  Edit Drop pm_message_id
read_flag_7 INDEX None  Edit Drop read_flag
pm_folder_id_7 INDEX None  Edit Drop pm_folder_id
pm_message_id_8 INDEX None  Edit Drop pm_message_id
read_flag_8 INDEX None  Edit Drop read_flag
user_id_8 INDEX None  Edit Drop user_id
pm_xref_id_7 INDEX None  Edit Drop pm_xref_id
special_folder_12 INDEX None  Edit Drop special_folder
reply_flag_8 INDEX None  Edit Drop reply_flag
special_folder_3 FULLTEXT None  Edit Drop special_folder
special_folder_4 FULLTEXT None  Edit Drop special_folder
special_folder_9 FULLTEXT None  Edit Drop special_folder
special_folder_11 FULLTEXT None  Edit Drop special_folder
Create an index on  columns  
 
Space usage: 
Type Usage
Data 0 Bytes
Index 3,072 Bytes
Total 3,072 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 0
Next Autoindex 1
Creation Feb 21, 2018 at 09:45 AM
Last update Mar 12, 2018 at 02:24 AM
Last check Mar 27, 2018 at 12:22 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: