Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: bak_messagesbak_messages
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0003 sec)
SQL-query: 
SELECT *
FROM `bak_messages`
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
   int(10)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   datetime     No  0000-00-00 00:00:00    Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
   int(1)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   text utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   text utf8_general_ci   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
user_id_from_2 UNIQUE Edit Drop user_id_from
user_id_to_2 UNIQUE Edit Drop user_id_to
folder_id_2 UNIQUE Edit Drop folder_id
date_time_2 UNIQUE Edit Drop date_time
state_2 UNIQUE Edit Drop state
priority_2 UNIQUE Edit Drop priority
message_id_3 UNIQUE Edit Drop message_id
folder_id_3 UNIQUE Edit Drop folder_id
priority_3 UNIQUE Edit Drop priority
user_id_to_3 UNIQUE Edit Drop user_id_to
state_3 UNIQUE Edit Drop state
date_time_4 UNIQUE Edit Drop date_time
user_id_from_3 UNIQUE Edit Drop user_id_from
message_id_6 UNIQUE Edit Drop message_id
user_id_from_6 UNIQUE Edit Drop user_id_from
user_id_to_6 UNIQUE Edit Drop user_id_to
folder_id_6 UNIQUE Edit Drop folder_id
date_time_6 UNIQUE Edit Drop date_time
state_6 UNIQUE Edit Drop state
priority_6 UNIQUE Edit Drop priority
priority_7 UNIQUE Edit Drop priority
user_id_to_7 UNIQUE Edit Drop user_id_to
message_id_7 UNIQUE Edit Drop message_id
user_id_from_8 UNIQUE Edit Drop user_id_from
date_time_8 UNIQUE Edit Drop date_time
state_7 UNIQUE Edit Drop state
folder_id_7 UNIQUE Edit Drop folder_id
useridto_state INDEX None  Edit Drop user_id_to
state
message_id INDEX None  Edit Drop message_id
user_id_from INDEX None  Edit Drop user_id_from
user_id_to INDEX None  Edit Drop user_id_to
folder_id INDEX None  Edit Drop folder_id
date_time INDEX None  Edit Drop date_time
state INDEX None  Edit Drop state
priority INDEX None  Edit Drop priority
date_time_3 INDEX None  Edit Drop date_time
message_id_4 INDEX None  Edit Drop message_id
priority_4 INDEX None  Edit Drop priority
user_id_from_4 INDEX None  Edit Drop user_id_from
folder_id_4 INDEX None  Edit Drop folder_id
user_id_to_4 INDEX None  Edit Drop user_id_to
state_4 INDEX None  Edit Drop state
message_id_5 INDEX None  Edit Drop message_id
user_id_from_5 INDEX None  Edit Drop user_id_from
user_id_to_5 INDEX None  Edit Drop user_id_to
folder_id_5 INDEX None  Edit Drop folder_id
date_time_5 INDEX None  Edit Drop date_time
state_5 INDEX None  Edit Drop state
priority_5 INDEX None  Edit Drop priority
date_time_7 INDEX None  Edit Drop date_time
priority_8 INDEX None  Edit Drop priority
user_id_from_7 INDEX None  Edit Drop user_id_from
message_id_8 INDEX None  Edit Drop message_id
state_8 INDEX None  Edit Drop state
subject FULLTEXT None  Edit Drop subject
message FULLTEXT None  Edit Drop message
subject_2 FULLTEXT None  Edit Drop subject
message_2 FULLTEXT None  Edit Drop message
subject_3 FULLTEXT None  Edit Drop subject
message_3 FULLTEXT None  Edit Drop message
message_4 FULLTEXT None  Edit Drop message
subject_4 FULLTEXT None  Edit Drop subject
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 utf8_general_ci
Rows 0
Next Autoindex 1
Creation Jan 20, 2018 at 04:23 AM
Last update Apr 04, 2018 at 10:56 AM
Last check Apr 07, 2018 at 04:05 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: