Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 26, 2024 at 03:42 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `extcal_users` 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_users.user_id | 1 | 25 | 1 | 2 | 0 | 0 | 13.0000 | 7.2111 | ENUM('1','2','3','4','5','6','7','8','9','10','11'... |
| puroparty.extcal_users.username | amellado | test2 | 4 | 13 | 0 | 0 | 7.7600 | NULL | ENUM('amellado','Annabad','badame','bar0404','chri... |
| puroparty.extcal_users.password | 098f6bcd4621d373cade4e832627b4f6 | f80b2a97b5f7f20297356c88fea52cb7 | 32 | 32 | 0 | 0 | 32.0000 | NULL | ENUM('098f6bcd4621d373cade4e832627b4f6','16b5f0187... |
| puroparty.extcal_users.firstname | admin | test | 3 | 9 | 7 | 0 | 3.9200 | NULL | ENUM('','admin','Alice','Anna','Barbara','Dana','d... |
| puroparty.extcal_users.lastname | VILLARREAL | 0 | 10 | 8 | 0 | 4.6000 | NULL | ENUM('','Benavidez','coronado','Espinoza','Flores'... | |
| puroparty.extcal_users.group_id | 1 | 5 | 1 | 1 | 0 | 0 | 2.9200 | 0.6882 | ENUM('1','3','5') NOT NULL |
| puroparty.extcal_users.lastvisit | 2006-02-09 19:56:06 | 2007-01-02 23:03:29 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('2006-02-09 19:56:06','2006-02-14 14:50:44','... |
| puroparty.extcal_users.email | allofusforever@yahoo.com | vettyrcian@yahoo.com | 13 | 32 | 0 | 0 | 21.8000 | NULL | ENUM('allofusforever@yahoo.com','amellado@houston.... |
| puroparty.extcal_users.user_regdate | 2006-01-04 10:17:47 | 2006-12-21 10:20:09 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('2006-01-04 10:17:47','2006-01-04 10:45:56','... |
| puroparty.extcal_users.user_lang | 0 | 0 | 25 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
| puroparty.extcal_users.user_website | yahoo | 0 | 5 | 23 | 0 | 0.3600 | NULL | ENUM('','test','yahoo') NOT NULL | |
| puroparty.extcal_users.user_location | test | 0 | 27 | 14 | 0 | 4.4800 | NULL | ENUM('','Bellaire/West U','Houston','houston, texa... | |
| puroparty.extcal_users.user_occupation | youth alcohol/drug prevention instructor | 0 | 40 | 12 | 0 | 7.5200 | NULL | ENUM('','Bartender','Bookkeeper','bus driver','Com... | |
| puroparty.extcal_users.reg_key | 0 | 0 | 23 | 2 | 0.0000 | NULL | CHAR(0) | ||
| puroparty.extcal_users.user_status | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |