mysql.puroparty.com
puroparty
phorum_users
| Server: mysql.puroparty.com
|
Database: puroparty
|
Table: phorum_users
|
| Field | Type | Null | Default |
|---|---|---|---|
| user_id | int(10) | No | |
| username | varchar(50) | No | |
| password | varchar(50) | No | |
| cookie_sessid_lt | varchar(50) | No | |
| sessid_st | varchar(50) | No | |
| sessid_st_timeout | int(10) | No | 0 |
| password_temp | varchar(50) | No | |
| varchar(100) | No | ||
| email_temp | varchar(110) | No | |
| hide_email | tinyint(1) | No | 0 |
| active | tinyint(1) | No | 0 |
| user_data | text | Yes | NULL |
| signature | text | Yes | NULL |
| threaded_list | tinyint(4) | No | 0 |
| posts | int(10) | No | 0 |
| admin | tinyint(1) | No | 0 |
| threaded_read | tinyint(4) | No | 0 |
| date_added | int(10) | No | 0 |
| date_last_active | int(10) | No | 0 |
| last_active_forum | int(10) | No | 0 |
| hide_activity | tinyint(1) | No | 0 |
| show_signature | tinyint(1) | No | 0 |
| email_notify | tinyint(1) | No | 0 |
| pm_email_notify | tinyint(1) | No | 1 |
| tz_offset | tinyint(2) | No | -99 |
| is_dst | tinyint(1) | No | 0 |
| user_language | varchar(100) | No | |
| user_template | varchar(100) | No | |
| moderator_data | text | Yes | NULL |
| moderation_email | tinyint(2) | No | 1 |
| Keyname | Type | Cardinality | Field | |
|---|---|---|---|---|
| PRIMARY | PRIMARY | 1 | user_id | |
| username | UNIQUE | 1 | username | |
| user_id_2 | UNIQUE | 1 | user_id | |
| username_3 | UNIQUE | 1 | username | |
| password_2 | UNIQUE | 1 | password | |
| cookie_sessid_lt_3 | UNIQUE | 1 | cookie_sessid_lt | |
| sessid_st_3 | UNIQUE | 1 | sessid_st | |
| sessid_st_timeout_2 | UNIQUE | 1 | sessid_st_timeout | |
| password_temp_2 | UNIQUE | 1 | password_temp | |
| email_2 | UNIQUE | 1 | ||
| email_temp_3 | UNIQUE | 1 | email_temp | |
| hide_email_2 | UNIQUE | 1 | hide_email | |
| active_3 | UNIQUE | 1 | active | |
| threaded_list_2 | UNIQUE | 1 | threaded_list | |
| posts_2 | UNIQUE | 1 | posts | |
| admin_2 | UNIQUE | 1 | admin | |
| threaded_read_2 | UNIQUE | 1 | threaded_read | |
| date_added_3 | UNIQUE | 1 | date_added | |
| date_last_active_2 | UNIQUE | 1 | date_last_active | |
| last_active_forum_2 | UNIQUE | 1 | last_active_forum | |
| hide_activity_2 | UNIQUE | 1 | hide_activity | |
| show_signature_2 | UNIQUE | 1 | show_signature | |
| email_notify_2 | UNIQUE | 1 | email_notify | |
| pm_email_notify_2 | UNIQUE | 1 | pm_email_notify | |
| tz_offset_2 | UNIQUE | 1 | tz_offset | |
| active | INDEX | None | active | |
| userpass | INDEX | None | username | |
| password | ||||
| sessid_st | INDEX | None | sessid_st | |
| cookie_sessid_lt | INDEX | None | cookie_sessid_lt | |
| activity | INDEX | None | date_last_active | |
| hide_activity | ||||
| last_active_forum | ||||
| date_added | INDEX | None | date_added | |
| email_temp | INDEX | None | email_temp | |
| user_id | INDEX | None | user_id | |
| username_2 | INDEX | None | username | |
| password | INDEX | None | password | |
| cookie_sessid_lt_2 | INDEX | None | cookie_sessid_lt | |
| sessid_st_2 | INDEX | None | sessid_st | |
| sessid_st_timeout | INDEX | None | sessid_st_timeout | |
| password_temp | INDEX | None | password_temp | |
| INDEX | None | |||
| email_temp_2 | INDEX | None | email_temp | |
| hide_email | INDEX | None | hide_email | |
| active_2 | INDEX | None | active | |
| threaded_list | INDEX | None | threaded_list | |
| posts | INDEX | None | posts | |
| admin | INDEX | None | admin | |
| threaded_read | INDEX | None | threaded_read | |
| date_added_2 | INDEX | None | date_added | |
| date_last_active | INDEX | None | date_last_active | |
| last_active_forum | INDEX | None | last_active_forum | |
| hide_activity | INDEX | None | hide_activity | |
| show_signature | INDEX | None | show_signature | |
| email_notify | INDEX | None | email_notify | |
| pm_email_notify | INDEX | None | pm_email_notify | |
| tz_offset | INDEX | None | tz_offset | |
| username_4 | INDEX | None | username | |
| password_3 | INDEX | None | password | |
| cookie_sessid_lt_4 | INDEX | None | cookie_sessid_lt | |
| sessid_st_4 | INDEX | None | sessid_st | |
| password_temp_3 | INDEX | None | password_temp | |
| email_3 | INDEX | None | ||
| email_temp_4 | INDEX | None | email_temp | |
| user_data | INDEX | None | user_data | |
| signature | INDEX | None | signature | |
Space usage :
|
Row Statistic :
|
|||||||||||||||||||||||||||||||