Host: mysql.puroparty.com
Database: puroparty
Generation Time: May 14, 2024 at 10:44 PM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `jos_users` PROCEDURE ANALYSE();
Rows: 13
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 | 63 | 2 | 2 | 0 | 0 | 62.5000 | 0.5000 | ENUM('62','63') NOT NULL |
puroparty.jos_users.name | Administrator | AlexWolf | 8 | 13 | 0 | 0 | 10.5000 | NULL | ENUM('Administrator','AlexWolf') NOT NULL |
puroparty.jos_users.username | admin | AlexWolf | 5 | 8 | 0 | 0 | 6.5000 | NULL | ENUM('admin','AlexWolf') NOT NULL |
puroparty.jos_users.email | ale9074885@gmail.com | ppcru@puroparty.com | 19 | 20 | 0 | 0 | 19.5000 | NULL | ENUM('ale9074885@gmail.com','ppcru@puroparty.com') NOT NULL |
puroparty.jos_users.password | 8b66edaca480556dcc25f752170305e9:JznPsHxLnnH8jFl5dCahVe2mLNtEXOTp | ac22c6056c19cf79a839068017959360:3BFdrPTQNXzcdcmBfsIr5UZWP3Ufzup3 | 65 | 65 | 0 | 0 | 65.0000 | NULL | ENUM('8b66edaca480556dcc25f752170305e9:JznPsHxLnnH8jFl5dCahVe2mLNtEXOTp','ac22c6056c19cf79a839068017959360:3BFdrPTQNXzcdcmBfsIr5UZWP3Ufzup3') NOT NULL |
puroparty.jos_users.usertype | Super Administrator | Super Administrator | 19 | 19 | 1 | 0 | 9.5000 | NULL | ENUM('','Super Administrator') NOT NULL |
puroparty.jos_users.block | 0 | 1 | 1 | 1 | 1 | 0 | 0.5000 | 0.5000 | ENUM('0','1') NOT NULL |
puroparty.jos_users.sendEmail | 1 | 1 | 1 | 1 | 1 | 0 | 0.5000 | 0.5000 | ENUM('0','1') NOT NULL |
puroparty.jos_users.gid | 18 | 25 | 2 | 2 | 0 | 0 | 21.5000 | 3.5000 | ENUM('18','25') NOT NULL |
puroparty.jos_users.registerDate | 2008-08-25 16:31:12 | 2019-05-24 16:39:49 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('2008-08-25 16:31:12','2019-05-24 16:39:49') NOT NULL |
puroparty.jos_users.lastvisitDate | 0000-00-00 00:00:00 | 2008-08-25 21:48:48 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('0000-00-00 00:00:00','2008-08-25 21:48:48') NOT NULL |
puroparty.jos_users.activation | 16112c8b11ff0fac6705110c3e9f5cbc | 0 | 32 | 1 | 0 | 16.0000 | NULL | ENUM('','16112c8b11ff0fac6705110c3e9f5cbc') NOT NULL | |
puroparty.jos_users.params | \n | 0 | 1 | 1 | 0 | 0.5000 | NULL | ENUM('\n','') NOT NULL |