mysql.puroparty.com
puroparty
bak_messages
| Server: mysql.puroparty.com
|
Database: puroparty
|
Table: bak_messages
|
| Field | Type | Null | Default |
|---|---|---|---|
| message_id | int(10) | No | |
| user_id_from | int(10) | No | 0 |
| user_id_to | int(10) | No | 0 |
| folder_id | int(10) | No | 0 |
| date_time | datetime | No | 0000-00-00 00:00:00 |
| state | int(11) | No | 0 |
| priority | int(1) | No | 0 |
| subject | text | No | |
| message | text | No |
| 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 | |
| message_id_3 | UNIQUE | 0 | message_id | |
| folder_id_3 | UNIQUE | 0 | folder_id | |
| priority_3 | UNIQUE | 0 | priority | |
| user_id_to_3 | UNIQUE | 0 | user_id_to | |
| state_3 | UNIQUE | 0 | state | |
| date_time_4 | UNIQUE | 0 | date_time | |
| user_id_from_3 | UNIQUE | 0 | user_id_from | |
| message_id_6 | UNIQUE | 0 | message_id | |
| user_id_from_6 | UNIQUE | 0 | user_id_from | |
| user_id_to_6 | UNIQUE | 0 | user_id_to | |
| folder_id_6 | UNIQUE | 0 | folder_id | |
| date_time_6 | UNIQUE | 0 | date_time | |
| state_6 | UNIQUE | 0 | state | |
| priority_6 | UNIQUE | 0 | priority | |
| priority_7 | UNIQUE | 0 | priority | |
| user_id_to_7 | UNIQUE | 0 | user_id_to | |
| message_id_7 | UNIQUE | 0 | message_id | |
| user_id_from_8 | UNIQUE | 0 | user_id_from | |
| date_time_8 | UNIQUE | 0 | date_time | |
| state_7 | UNIQUE | 0 | state | |
| folder_id_7 | 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 | |
| date_time_3 | INDEX | None | date_time | |
| message_id_4 | INDEX | None | message_id | |
| priority_4 | INDEX | None | priority | |
| user_id_from_4 | INDEX | None | user_id_from | |
| folder_id_4 | INDEX | None | folder_id | |
| user_id_to_4 | INDEX | None | user_id_to | |
| state_4 | INDEX | None | state | |
| message_id_5 | INDEX | None | message_id | |
| user_id_from_5 | INDEX | None | user_id_from | |
| user_id_to_5 | INDEX | None | user_id_to | |
| folder_id_5 | INDEX | None | folder_id | |
| date_time_5 | INDEX | None | date_time | |
| state_5 | INDEX | None | state | |
| priority_5 | INDEX | None | priority | |
| date_time_7 | INDEX | None | date_time | |
| priority_8 | INDEX | None | priority | |
| user_id_from_7 | INDEX | None | user_id_from | |
| message_id_8 | INDEX | None | message_id | |
| 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 | |
| message_4 | INDEX | None | message | |
| subject_4 | INDEX | None | subject | |
Space usage :
|
Row Statistic :
|
|||||||||||||||||||||||||||