Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: jos_messagesjos_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
   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
priority_3 UNIQUE Edit Drop priority
state_3 UNIQUE Edit Drop state
user_id_to_4 UNIQUE Edit Drop user_id_to
message_id_4 UNIQUE Edit Drop message_id
folder_id_4 UNIQUE Edit Drop folder_id
date_time_4 UNIQUE Edit Drop date_time
user_id_from_4 UNIQUE Edit Drop user_id_from
date_time_5 UNIQUE Edit Drop date_time
folder_id_5 UNIQUE Edit Drop folder_id
state_6 UNIQUE Edit Drop state
message_id_6 UNIQUE Edit Drop message_id
priority_6 UNIQUE Edit Drop priority
user_id_from_6 UNIQUE Edit Drop user_id_from
user_id_to_6 UNIQUE Edit Drop user_id_to
message_id_7 UNIQUE Edit Drop message_id
user_id_to_7 UNIQUE Edit Drop user_id_to
priority_7 UNIQUE Edit Drop priority
state_7 UNIQUE Edit Drop state
date_time_8 UNIQUE Edit Drop date_time
folder_id_8 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
user_id_to_3 INDEX None  Edit Drop user_id_to
date_time_3 INDEX None  Edit Drop date_time
user_id_from_3 INDEX None  Edit Drop user_id_from
message_id_3 INDEX None  Edit Drop message_id
folder_id_3 INDEX None  Edit Drop folder_id
priority_4 INDEX None  Edit Drop priority
state_4 INDEX None  Edit Drop state
message_id_5 INDEX None  Edit Drop message_id
user_id_to_5 INDEX None  Edit Drop user_id_to
state_5 INDEX None  Edit Drop state
user_id_from_5 INDEX None  Edit Drop user_id_from
priority_5 INDEX None  Edit Drop priority
date_time_6 INDEX None  Edit Drop date_time
folder_id_6 INDEX None  Edit Drop folder_id
folder_id_7 INDEX None  Edit Drop folder_id
message_id_8 INDEX None  Edit Drop message_id
date_time_7 INDEX None  Edit Drop date_time
user_id_from_7 INDEX None  Edit Drop user_id_from
user_id_to_8 INDEX None  Edit Drop user_id_to
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
subject_4 FULLTEXT None  Edit Drop subject
message_4 FULLTEXT None  Edit Drop message
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 11:37 PM
Last update Jan 20, 2018 at 11:37 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: