Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: jos_usersjos_users

SQL-query
SQL-query: 
SELECT *
FROM `jos_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.jos_users.id 62 62 2 2 0 0 62.0000 0.0000 ENUM('62') NOT NULL
puroparty.jos_users.name Administrator Administrator 13 13 0 0 13.0000 NULL ENUM('Administrator') NOT NULL
puroparty.jos_users.username admin admin 5 5 0 0 5.0000 NULL ENUM('admin') NOT NULL
puroparty.jos_users.email ppcru@puroparty.com ppcru@puroparty.com 19 19 0 0 19.0000 NULL ENUM('ppcru@puroparty.com') NOT NULL
puroparty.jos_users.password 8b66edaca480556dcc25f752170305e9:JznPsHxLnnH8jFl5d... 8b66edaca480556dcc25f752170305e9:JznPsHxLnnH8jFl5d... 65 65 0 0 65.0000 NULL ENUM('8b66edaca480556dcc25f752170305e9:JznPsHxLnnH...
puroparty.jos_users.usertype Super Administrator Super Administrator 19 19 0 0 19.0000 NULL ENUM('Super Administrator') NOT NULL
puroparty.jos_users.block 0 0 1 1 1 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.jos_users.sendEmail 1 1 1 1 0 0 1.0000 0.0000 ENUM('1') NOT NULL
puroparty.jos_users.gid 25 25 2 2 0 0 25.0000 0.0000 ENUM('25') NOT NULL
puroparty.jos_users.registerDate 2008-08-25 16:31:12 2008-08-25 16:31:12 19 19 0 0 19.0000 NULL ENUM('2008-08-25 16:31:12') NOT NULL
puroparty.jos_users.lastvisitDate 2008-08-25 21:48:48 2008-08-25 21:48:48 19 19 0 0 19.0000 NULL ENUM('2008-08-25 21:48:48') NOT NULL
puroparty.jos_users.activation     0 0 1 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.jos_users.params     0 0 1 0 0.0000 NULL CHAR(0) NOT NULL



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