mysql.puroparty.com
puroparty
phorum_files
| Server: mysql.puroparty.com
|
Database: puroparty
|
Table: phorum_files
|
| Field | Type | Null | Default |
|---|---|---|---|
| file_id | int(11) | No | |
| user_id | int(11) | No | 0 |
| filename | varchar(255) | No | |
| filesize | int(11) | No | 0 |
| file_data | mediumtext | No | |
| add_datetime | int(10) | No | 0 |
| message_id | int(10) | No | 0 |
| link | varchar(10) | No |
| Keyname | Type | Cardinality | Field | |
|---|---|---|---|---|
| PRIMARY | PRIMARY | 0 | file_id | |
| file_id_2 | UNIQUE | 0 | file_id | |
| user_id_2 | UNIQUE | 0 | user_id | |
| filename_2 | UNIQUE | 0 | filename | |
| filesize_2 | UNIQUE | 0 | filesize | |
| add_datetime_3 | UNIQUE | 0 | add_datetime | |
| message_id_2 | UNIQUE | 0 | message_id | |
| link_2 | UNIQUE | 0 | link | |
| file_id_3 | UNIQUE | 0 | file_id | |
| add_datetime_4 | UNIQUE | 0 | add_datetime | |
| filesize_3 | UNIQUE | 0 | filesize | |
| filename_5 | UNIQUE | 0 | filename | |
| link_5 | UNIQUE | 0 | link | |
| user_id_4 | UNIQUE | 0 | user_id | |
| message_id_4 | UNIQUE | 0 | message_id | |
| filename_7 | UNIQUE | 0 | filename | |
| message_id_5 | UNIQUE | 0 | message_id | |
| file_id_5 | UNIQUE | 0 | file_id | |
| add_datetime_6 | UNIQUE | 0 | add_datetime | |
| link_9 | UNIQUE | 0 | link | |
| user_id_5 | UNIQUE | 0 | user_id | |
| filesize_5 | UNIQUE | 0 | filesize | |
| file_id_7 | UNIQUE | 0 | file_id | |
| message_id_7 | UNIQUE | 0 | message_id | |
| filename_11 | UNIQUE | 0 | filename | |
| message_id_8 | UNIQUE | 0 | message_id | |
| add_datetime | INDEX | None | add_datetime | |
| message_id_link | INDEX | None | message_id | |
| link | ||||
| file_id | INDEX | None | file_id | |
| user_id | INDEX | None | user_id | |
| filename | INDEX | None | filename | |
| filesize | INDEX | None | filesize | |
| add_datetime_2 | INDEX | None | add_datetime | |
| message_id | INDEX | None | message_id | |
| link | INDEX | None | link | |
| message_id_3 | INDEX | None | message_id | |
| filename_6 | INDEX | None | filename | |
| file_id_4 | INDEX | None | file_id | |
| user_id_3 | INDEX | None | user_id | |
| link_6 | INDEX | None | link | |
| add_datetime_5 | INDEX | None | add_datetime | |
| filesize_4 | INDEX | None | filesize | |
| filename_8 | INDEX | None | filename | |
| link_7 | INDEX | None | link | |
| file_id_6 | INDEX | None | file_id | |
| message_id_6 | INDEX | None | message_id | |
| user_id_6 | INDEX | None | user_id | |
| add_datetime_7 | INDEX | None | add_datetime | |
| filesize_6 | INDEX | None | filesize | |
| link_10 | INDEX | None | link | |
| filename_10 | INDEX | None | filename | |
| user_id_7 | INDEX | None | user_id | |
| filename_3 | INDEX | None | filename | |
| file_data | INDEX | None | file_data | |
| link_3 | INDEX | None | link | |
| link_4 | INDEX | None | link | |
| file_data_2 | INDEX | None | file_data | |
| filename_4 | INDEX | None | filename | |
| link_8 | INDEX | None | link | |
| filename_9 | INDEX | None | filename | |
| file_data_3 | INDEX | None | file_data | |
| link_11 | INDEX | None | link | |
| file_data_4 | INDEX | None | file_data | |
| link_12 | INDEX | None | link | |
Space usage :
|
Row Statistic :
|
|||||||||||||||||||||||||||