mysql.puroparty.com
puroparty
phorum_forums
| Server: mysql.puroparty.com
|
Database: puroparty
|
Table: phorum_forums
|
| Field | Type | Null | Default |
|---|---|---|---|
| forum_id | int(10) | No | |
| name | varchar(50) | No | |
| active | smallint(6) | No | 0 |
| description | text | Yes | NULL |
| template | varchar(50) | No | |
| folder_flag | tinyint(1) | No | 0 |
| parent_id | int(10) | No | 0 |
| list_length_flat | int(10) | No | 0 |
| list_length_threaded | int(10) | No | 0 |
| moderation | int(10) | No | 0 |
| threaded_list | tinyint(4) | No | 0 |
| threaded_read | tinyint(4) | No | 0 |
| float_to_top | tinyint(4) | No | 0 |
| check_duplicate | tinyint(4) | No | 0 |
| allow_attachment_types | varchar(100) | No | |
| max_attachment_size | int(10) | No | 0 |
| max_totalattachment_size | int(10) | No | 0 |
| max_attachments | int(10) | No | 0 |
| pub_perms | int(10) | No | 0 |
| reg_perms | int(10) | No | 0 |
| display_ip_address | smallint(5) | No | 1 |
| allow_email_notify | smallint(5) | No | 1 |
| language | varchar(100) | No | english |
| email_moderators | tinyint(1) | No | 0 |
| message_count | int(10) | No | 0 |
| sticky_count | int(10) | No | 0 |
| thread_count | int(10) | No | 0 |
| last_post_time | int(10) | No | 0 |
| display_order | int(10) | No | 0 |
| read_length | int(10) | No | 0 |
| vroot | int(10) | No | 0 |
| edit_post | tinyint(1) | No | 1 |
| template_settings | text | Yes | NULL |
| count_views | tinyint(1) | No | 0 |
| display_fixed | tinyint(1) | No | 0 |
| reverse_threading | tinyint(1) | No | 0 |
| inherit_id | int(10) | Yes | NULL |
| Keyname | Type | Cardinality | Field | |
|---|---|---|---|---|
| PRIMARY | PRIMARY | 1 | forum_id | |
| forum_id_2 | UNIQUE | 1 | forum_id | |
| name_3 | UNIQUE | 1 | name | |
| active_3 | UNIQUE | 1 | active | |
| template_2 | UNIQUE | 1 | template | |
| folder_flag_2 | UNIQUE | 1 | folder_flag | |
| parent_id_2 | UNIQUE | 1 | parent_id | |
| list_length_flat_2 | UNIQUE | 1 | list_length_flat | |
| list_length_threaded_2 | UNIQUE | 1 | list_length_threaded | |
| moderation_2 | UNIQUE | 1 | moderation | |
| threaded_list_2 | UNIQUE | 1 | threaded_list | |
| threaded_read_2 | UNIQUE | 1 | threaded_read | |
| float_to_top_2 | UNIQUE | 1 | float_to_top | |
| check_duplicate_2 | UNIQUE | 1 | check_duplicate | |
| allow_attachment_types_2 | UNIQUE | 1 | allow_attachment_types | |
| max_attachment_size_2 | UNIQUE | 1 | max_attachment_size | |
| max_totalattachment_size_2 | UNIQUE | 1 | max_totalattachment_size | |
| max_attachments_2 | UNIQUE | 1 | max_attachments | |
| pub_perms_2 | UNIQUE | 1 | pub_perms | |
| reg_perms_2 | UNIQUE | 1 | reg_perms | |
| display_ip_address_2 | UNIQUE | 1 | display_ip_address | |
| allow_email_notify_2 | UNIQUE | 1 | allow_email_notify | |
| language_2 | UNIQUE | 1 | language | |
| email_moderators_2 | UNIQUE | 1 | email_moderators | |
| message_count_2 | UNIQUE | 1 | message_count | |
| sticky_count_2 | UNIQUE | 1 | sticky_count | |
| thread_count_2 | UNIQUE | 1 | thread_count | |
| last_post_time_2 | UNIQUE | 1 | last_post_time | |
| name | INDEX | None | name | |
| active | INDEX | None | active | |
| parent_id | ||||
| group_id | INDEX | None | parent_id | |
| forum_id | INDEX | None | forum_id | |
| name_2 | INDEX | None | name | |
| active_2 | INDEX | None | active | |
| template | INDEX | None | template | |
| folder_flag | INDEX | None | folder_flag | |
| parent_id | INDEX | None | parent_id | |
| list_length_flat | INDEX | None | list_length_flat | |
| list_length_threaded | INDEX | None | list_length_threaded | |
| moderation | INDEX | None | moderation | |
| threaded_list | INDEX | None | threaded_list | |
| threaded_read | INDEX | None | threaded_read | |
| float_to_top | INDEX | None | float_to_top | |
| check_duplicate | INDEX | None | check_duplicate | |
| allow_attachment_types | INDEX | None | allow_attachment_types | |
| max_attachment_size | INDEX | None | max_attachment_size | |
| max_totalattachment_size | INDEX | None | max_totalattachment_size | |
| max_attachments | INDEX | None | max_attachments | |
| pub_perms | INDEX | None | pub_perms | |
| reg_perms | INDEX | None | reg_perms | |
| display_ip_address | INDEX | None | display_ip_address | |
| allow_email_notify | INDEX | None | allow_email_notify | |
| language | INDEX | None | language | |
| email_moderators | INDEX | None | email_moderators | |
| message_count | INDEX | None | message_count | |
| sticky_count | INDEX | None | sticky_count | |
| thread_count | INDEX | None | thread_count | |
| last_post_time | INDEX | None | last_post_time | |
| display_order | INDEX | None | display_order | |
| name_4 | INDEX | None | name | |
| description | INDEX | None | description | |
| template_3 | INDEX | None | template | |
| allow_attachment_types_3 | INDEX | None | allow_attachment_types | |
| language_3 | INDEX | None | language | |
Space usage :
|
Row Statistic :
|
|||||||||||||||||||||||||||||||