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

jos_messages

Field Type Null Default
message_id  int(10) No   
user_id_from  int(10) No 
user_id_to  int(10) No 
folder_id  int(10) No 
date_time  datetime No  0000-00-00 00:00:00 
state  int(11) No 
priority  int(1) No 
subject  text No   
message  text No   


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 0 message_id
message_id_2 UNIQUE 0 message_id
user_id_from_2 UNIQUE 0 user_id_from
user_id_to_2 UNIQUE 0 user_id_to
folder_id_2 UNIQUE 0 folder_id
date_time_2 UNIQUE 0 date_time
state_2 UNIQUE 0 state
priority_2 UNIQUE 0 priority
priority_3 UNIQUE 0 priority
state_3 UNIQUE 0 state
user_id_to_4 UNIQUE 0 user_id_to
message_id_4 UNIQUE 0 message_id
folder_id_4 UNIQUE 0 folder_id
date_time_4 UNIQUE 0 date_time
user_id_from_4 UNIQUE 0 user_id_from
date_time_5 UNIQUE 0 date_time
folder_id_5 UNIQUE 0 folder_id
state_6 UNIQUE 0 state
message_id_6 UNIQUE 0 message_id
priority_6 UNIQUE 0 priority
user_id_from_6 UNIQUE 0 user_id_from
user_id_to_6 UNIQUE 0 user_id_to
message_id_7 UNIQUE 0 message_id
user_id_to_7 UNIQUE 0 user_id_to
priority_7 UNIQUE 0 priority
state_7 UNIQUE 0 state
date_time_8 UNIQUE 0 date_time
folder_id_8 UNIQUE 0 folder_id
useridto_state INDEX None user_id_to
state
message_id INDEX None message_id
user_id_from INDEX None user_id_from
user_id_to INDEX None user_id_to
folder_id INDEX None folder_id
date_time INDEX None date_time
state INDEX None state
priority INDEX None priority
user_id_to_3 INDEX None user_id_to
date_time_3 INDEX None date_time
user_id_from_3 INDEX None user_id_from
message_id_3 INDEX None message_id
folder_id_3 INDEX None folder_id
priority_4 INDEX None priority
state_4 INDEX None state
message_id_5 INDEX None message_id
user_id_to_5 INDEX None user_id_to
state_5 INDEX None state
user_id_from_5 INDEX None user_id_from
priority_5 INDEX None priority
date_time_6 INDEX None date_time
folder_id_6 INDEX None folder_id
folder_id_7 INDEX None folder_id
message_id_8 INDEX None message_id
date_time_7 INDEX None date_time
user_id_from_7 INDEX None user_id_from
user_id_to_8 INDEX None user_id_to
state_8 INDEX None state
subject INDEX None subject
message INDEX None message
subject_2 INDEX None subject
message_2 INDEX None message
subject_3 INDEX None subject
message_3 INDEX None message
subject_4 INDEX None subject
message_4 INDEX None message


 Space usage :
Type Usage
Data 0 Bytes
Index 3,072 Bytes
Total 3,072 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 0
Next Autoindex 1
Creation Jan 20, 2018 at 11:37 PM
Last update Jan 20, 2018 at 11:37 PM