mysql.puroparty.com
puroparty
phorum_pm_messages
| Server: mysql.puroparty.com
|
Database: puroparty
|
Table: phorum_pm_messages
|
| Field | Type | Null | Default |
|---|---|---|---|
| pm_message_id | int(10) | No | |
| from_user_id | int(10) | No | 0 |
| from_username | varchar(50) | No | |
| subject | varchar(100) | No | |
| message | text | No | |
| datestamp | int(10) | No | 0 |
| meta | mediumtext | Yes | NULL |
| Keyname | Type | Cardinality | Field | |
|---|---|---|---|---|
| PRIMARY | PRIMARY | 0 | pm_message_id | |
| pm_message_id_2 | UNIQUE | 0 | pm_message_id | |
| from_user_id_2 | UNIQUE | 0 | from_user_id | |
| from_username_2 | UNIQUE | 0 | from_username | |
| subject_2 | UNIQUE | 0 | subject | |
| datestamp_2 | UNIQUE | 0 | datestamp | |
| from_user_id_4 | UNIQUE | 0 | from_user_id | |
| from_username_4 | UNIQUE | 0 | from_username | |
| datestamp_3 | UNIQUE | 0 | datestamp | |
| subject_6 | UNIQUE | 0 | subject | |
| pm_message_id_4 | UNIQUE | 0 | pm_message_id | |
| datestamp_5 | UNIQUE | 0 | datestamp | |
| subject_7 | UNIQUE | 0 | subject | |
| from_user_id_5 | UNIQUE | 0 | from_user_id | |
| from_username_9 | UNIQUE | 0 | from_username | |
| pm_message_id_6 | UNIQUE | 0 | pm_message_id | |
| from_user_id_8 | UNIQUE | 0 | from_user_id | |
| datestamp_7 | UNIQUE | 0 | datestamp | |
| from_username_10 | UNIQUE | 0 | from_username | |
| subject_12 | UNIQUE | 0 | subject | |
| pm_message_id_8 | UNIQUE | 0 | pm_message_id | |
| from_user_id_9 | UNIQUE | 0 | from_user_id | |
| from_username_13 | UNIQUE | 0 | from_username | |
| datestamp_9 | UNIQUE | 0 | datestamp | |
| pm_message_id | INDEX | None | pm_message_id | |
| from_user_id | INDEX | None | from_user_id | |
| from_username | INDEX | None | from_username | |
| subject | INDEX | None | subject | |
| datestamp | INDEX | None | datestamp | |
| from_user_id_3 | INDEX | None | from_user_id | |
| pm_message_id_3 | INDEX | None | pm_message_id | |
| subject_5 | INDEX | None | subject | |
| from_username_6 | INDEX | None | from_username | |
| datestamp_4 | INDEX | None | datestamp | |
| datestamp_6 | INDEX | None | datestamp | |
| from_username_8 | INDEX | None | from_username | |
| subject_8 | INDEX | None | subject | |
| pm_message_id_5 | INDEX | None | pm_message_id | |
| from_user_id_6 | INDEX | None | from_user_id | |
| from_user_id_7 | INDEX | None | from_user_id | |
| pm_message_id_7 | INDEX | None | pm_message_id | |
| subject_11 | INDEX | None | subject | |
| datestamp_8 | INDEX | None | datestamp | |
| from_username_12 | INDEX | None | from_username | |
| subject_14 | INDEX | None | subject | |
| from_user_id_10 | INDEX | None | from_user_id | |
| from_username_3 | INDEX | None | from_username | |
| subject_3 | INDEX | None | subject | |
| message | INDEX | None | message | |
| meta | INDEX | None | meta | |
| subject_4 | INDEX | None | subject | |
| message_2 | INDEX | None | message | |
| from_username_5 | INDEX | None | from_username | |
| meta_2 | INDEX | None | meta | |
| message_3 | INDEX | None | message | |
| meta_3 | INDEX | None | meta | |
| from_username_7 | INDEX | None | from_username | |
| subject_9 | INDEX | None | subject | |
| meta_4 | INDEX | None | meta | |
| message_4 | INDEX | None | message | |
| subject_10 | INDEX | None | subject | |
| from_username_11 | INDEX | None | from_username | |
| subject_13 | INDEX | None | subject | |
| message_5 | INDEX | None | message | |
Space usage :
|
Row Statistic :
|
|||||||||||||||||||||||||||