Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: phorum_usersphorum_users
StructureStructure BrowseBrowse SQLSQL SearchSearch InsertInsert ExportExport OperationsOperations EmptyEmpty DropDrop

SQL-query
SQL-query: 
SELECT *
FROM `phorum_users`
PROCEDURE ANALYSE ( )
 [Edit] [Explain SQL] [Create PHP Code] [Refresh]



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


Print viewPrint view    Print view (with full texts)Print view (with full texts)     ExportExport