Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 25, 2024 at 10:19 PM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `extcal_2users` PROCEDURE ANALYSE();
Rows: 15
Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
---|---|---|---|---|---|---|---|---|---|
puroparty.extcal_2users.user_id | 1 | 7 | 1 | 1 | 0 | 0 | 4.0000 | 2.0000 | ENUM('1','2','3','4','5','6','7') NOT NULL |
puroparty.extcal_2users.username | emilylarcos | test | 4 | 11 | 0 | 0 | 7.2857 | NULL | ENUM('emilylarcos','jdeleon2741','layla','mona721','puroparty','sofy','test') NOT NULL |
puroparty.extcal_2users.password | 0aa08b5c91758a166d13e7cd3f455951 | f66c54467198093c357c8288fdc30198 | 32 | 32 | 0 | 0 | 32.0000 | NULL | ENUM('0aa08b5c91758a166d13e7cd3f455951','5a105e8b9d40e1329780d62ea2265d8a','71b3b26aaa319e0cdf6fdb8429c112b0','c48ba993d35c3abe0380f91738fe2a34','e19d5cd5af0378da05f63f891c7467af','e31d751f28059199c5fb61cb3e3997cb','f66c54467198093c357c8288fdc30198') NOT NULL |
puroparty.extcal_2users.firstname | Emily | Sofia | 3 | 6 | 2 | 0 | 3.4286 | NULL | ENUM('','Emily','layla','monica','Mr.','Sofia') NOT NULL |
puroparty.extcal_2users.lastname | Administrator | soto | 4 | 13 | 2 | 0 | 4.8571 | NULL | ENUM('','Administrator','aguilar','Arcos','Gomez','soto') NOT NULL |
puroparty.extcal_2users.group_id | 1 | 5 | 1 | 1 | 0 | 0 | 2.8571 | 1.1249 | ENUM('1','2','3','5') NOT NULL |
puroparty.extcal_2users.lastvisit | 2007-01-03 00:02:47 | 2007-04-08 22:23:01 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('2007-01-03 00:02:47','2007-02-14 10:14:09','2007-02-21 16:24:55','2007-03-05 10:38:55','2007-03-19 14:58:31','2007-03-28 23:26:00','2007-04-08 22:23:01') NOT NULL |
puroparty.extcal_2users.email | emilylarcos@yahoo.com | test@test.com | 13 | 25 | 0 | 0 | 21.1429 | NULL | ENUM('emilylarcos@yahoo.com','giggles200384@hotmail.com','jdeleon2741@sbcglobal.net','jzniniesmertina@yahoo.com','layla@puroparty.com','robert1999@gmail.com','test@test.com') NOT NULL |
puroparty.extcal_2users.user_regdate | 2007-01-02 23:47:29 | 2007-03-28 23:26:00 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('2007-01-02 23:47:29','2007-01-02 23:51:59','2007-01-08 21:00:34','2007-02-21 16:24:55','2007-03-05 10:38:55','2007-03-19 14:58:31','2007-03-28 23:26:00') NOT NULL |
puroparty.extcal_2users.user_lang | 0 | 0 | 7 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.extcal_2users.user_website | 0 | 0 | 7 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.extcal_2users.user_location | 0 | 0 | 7 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.extcal_2users.user_occupation | picker/packer | 0 | 13 | 6 | 0 | 1.8571 | NULL | ENUM('','picker/packer') NOT NULL | |
puroparty.extcal_2users.reg_key | 862b0dc088726866807bc358d5d95c02 | ec0c88580e20947f3c02387fc30a79dc | 32 | 32 | 0 | 3 | 32.0000 | NULL | ENUM('862b0dc088726866807bc358d5d95c02','89e377cdbbc96be06850ba9d6120bb86','b181e985c4d492d1f83a3e4679f341ab','ec0c88580e20947f3c02387fc30a79dc') |
puroparty.extcal_2users.user_status | 1 | 1 | 1 | 1 | 4 | 0 | 0.4286 | 0.4949 | ENUM('0','1') NOT NULL |