Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 25, 2024 at 04:28 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.extcal_2users.password | 0aa08b5c91758a166d13e7cd3f455951 | f66c54467198093c357c8288fdc30198 | 32 | 32 | 0 | 0 | 32.0000 | NULL | ENUM('0aa08b5c91758a166d13e7cd3f455951','5a105e8b9... |
puroparty.extcal_2users.firstname | Emily | Sofia | 3 | 6 | 2 | 0 | 3.4286 | NULL | ENUM('','Emily','layla','monica','Mr.','Sofia') NO... |
puroparty.extcal_2users.lastname | Administrator | soto | 4 | 13 | 2 | 0 | 4.8571 | NULL | ENUM('','Administrator','aguilar','Arcos','Gomez',... |
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','... |
puroparty.extcal_2users.email | emilylarcos@yahoo.com | test@test.com | 13 | 25 | 0 | 0 | 21.1429 | NULL | ENUM('emilylarcos@yahoo.com','giggles200384@hotmai... |
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','... |
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','89e377cdb... |
puroparty.extcal_2users.user_status | 1 | 1 | 1 | 1 | 4 | 0 | 0.4286 | 0.4949 | ENUM('0','1') NOT NULL |