Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 26, 2024 at 10:07 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `phorum_users` PROCEDURE ANALYSE();
Rows: 30
Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
---|---|---|---|---|---|---|---|---|---|
puroparty.phorum_users.user_id | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |
puroparty.phorum_users.username | ppcru | ppcru | 5 | 5 | 0 | 0 | 5.0000 | NULL | ENUM('ppcru') NOT NULL |
puroparty.phorum_users.password | e31d751f28059199c5fb61cb3e3997cb | e31d751f28059199c5fb61cb3e3997cb | 32 | 32 | 0 | 0 | 32.0000 | NULL | ENUM('e31d751f28059199c5fb61cb3e3997cb') NOT NULL |
puroparty.phorum_users.cookie_sessid_lt | 4face78eadbf6d3988bd8c6df0ff5699 | 4face78eadbf6d3988bd8c6df0ff5699 | 32 | 32 | 0 | 0 | 32.0000 | NULL | ENUM('4face78eadbf6d3988bd8c6df0ff5699') NOT NULL |
puroparty.phorum_users.sessid_st | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.phorum_users.sessid_st_timeout | 0 | 0 | 1 | 1 | 1 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.phorum_users.password_temp | e31d751f28059199c5fb61cb3e3997cb | e31d751f28059199c5fb61cb3e3997cb | 32 | 32 | 0 | 0 | 32.0000 | NULL | ENUM('e31d751f28059199c5fb61cb3e3997cb') NOT NULL |
puroparty.phorum_users.email | robert1999@gmail.com | robert1999@gmail.com | 20 | 20 | 0 | 0 | 20.0000 | NULL | ENUM('robert1999@gmail.com') NOT NULL |
puroparty.phorum_users.email_temp | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.phorum_users.hide_email | 0 | 0 | 1 | 1 | 1 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.phorum_users.active | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |
puroparty.phorum_users.user_data | NULL | NULL | 0 | 0 | 0 | 1 | 0.0 | NULL | CHAR(0) |
puroparty.phorum_users.signature | NULL | NULL | 0 | 0 | 0 | 1 | 0.0 | NULL | CHAR(0) |
puroparty.phorum_users.threaded_list | 0 | 0 | 1 | 1 | 1 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.phorum_users.posts | 2 | 2 | 1 | 1 | 0 | 0 | 2.0000 | 0.0000 | ENUM('2') NOT NULL |
puroparty.phorum_users.admin | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |
puroparty.phorum_users.threaded_read | 0 | 0 | 1 | 1 | 1 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.phorum_users.date_added | 1182891458 | 1182891458 | 10 | 10 | 0 | 0 | 1182891458.0000 | 0.0000 | ENUM('1182891458') NOT NULL |
puroparty.phorum_users.date_last_active | 1182891458 | 1182891458 | 10 | 10 | 0 | 0 | 1182891458.0000 | 0.0000 | ENUM('1182891458') NOT NULL |
puroparty.phorum_users.last_active_forum | 0 | 0 | 1 | 1 | 1 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.phorum_users.hide_activity | 0 | 0 | 1 | 1 | 1 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.phorum_users.show_signature | 0 | 0 | 1 | 1 | 1 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.phorum_users.email_notify | 0 | 0 | 1 | 1 | 1 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.phorum_users.pm_email_notify | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |
puroparty.phorum_users.tz_offset | -99 | -99 | 3 | 3 | 0 | 0 | -99.0000 | 0.0000 | ENUM('-99') NOT NULL |
puroparty.phorum_users.is_dst | 0 | 0 | 1 | 1 | 1 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.phorum_users.user_language | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.phorum_users.user_template | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.phorum_users.moderator_data | NULL | NULL | 0 | 0 | 0 | 1 | 0.0 | NULL | CHAR(0) |
puroparty.phorum_users.moderation_email | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |