Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 17, 2024 at 08:23 PM
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','12','13','14','15','16','17','18','19','20','21','22','23','24','25') NOT NULL |
puroparty.extcal_users.username | amellado | test2 | 4 | 13 | 0 | 0 | 7.7600 | NULL | ENUM('amellado','Annabad','badame','bar0404','christina','cnicasio','Dana','dherrera','DRuiz','Heespinoza','icoronado','ihernandez','IloveJorge','localoca','MAGNOLIAQUEEN','Marty','NOrtiz','ppcru','puretexican','puroparty','rickgomez20','rodeorosie','rs9981','test','test2') NOT NULL |
puroparty.extcal_users.password | 098f6bcd4621d373cade4e832627b4f6 | f80b2a97b5f7f20297356c88fea52cb7 | 32 | 32 | 0 | 0 | 32.0000 | NULL | ENUM('098f6bcd4621d373cade4e832627b4f6','16b5f018766a033d8872041a0580340d','1a1f8fc1ed40b5e676f1bb7a9620cc3b','1c642bad0e4defd87bae35aa556dbbaa','3424a11a4708b2d9f476fc7ab3b6fc81','404ef2dd47141a8bc997a00d0d70b9aa','4deb63432416a6466d8b67fb52f1bbd7','6573d506acbc3037202fdc46d5d6222e','6818bab4da85a3a138cdfa35cfc7a64f','6b5d7dfecdc59b0b3daf74cfe147fde4','6cf963dfc6315b07889673303734c02b','7236d0ba5865264b6f6068e7c1e8d361','7315ac7ba3b60a5b053886fa49f98ed6','97f4c16fa18cace67d533cd4279f83b4','9fd8301ac24fb88e65d9d7cd1dd1b1ec','a14f16c9f6dd87e85679cb382b9e7322','b0210eb60aff5851b7607227b8530521','cc03e747a6afbbcbf8be7668acfebee5','d2cfcb745a74ab8ccdcd9e1e63e534d2','d67326a22642a324aa1b0745f2f17abb','e31d751f28059199c5fb61cb3e3997cb','e9ee6c9c1f38f0fb57f072a0fb5e3663','f384cbf762027c540f0b30abb10663d2','f80b2a97b5f7f20297356c88fea52cb7') NOT NULL |
puroparty.extcal_users.firstname | admin | test | 3 | 9 | 7 | 0 | 3.9200 | NULL | ENUM('','admin','Alice','Anna','Barbara','Dana','debra','Des','Diana','DIANNE','Henrietta','irene','Margie','Marty','Norma','official','Richard','Rosie','test') NOT NULL |
puroparty.extcal_users.lastname | VILLARREAL | 0 | 10 | 8 | 0 | 4.6000 | NULL | ENUM('','Benavidez','coronado','Espinoza','Flores','Garcia','Gomez','Harviston','Herrera','Ibarra','Mellado','morales','Ortiz','ozuna','Rodriguez','Ruiz','test','VILLARREAL') NOT NULL | |
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','2006-03-04 08:37:17','2006-03-06 12:40:41','2006-03-29 03:30:19','2006-04-03 09:29:34','2006-04-10 15:35:46','2006-04-13 13:16:40','2006-04-13 15:44:55','2006-06-13 15:23:58','2006-06-22 23:21:09','2006-06-28 15:53:53','2006-08-24 16:06:56','2006-08-28 14:44:42','2006-08-30 13:25:01','2006-09-17 14:29:26','2006-10-12 10:35:49','2006-10-16 17:40:08','2006-11-10 07:04:54','2006-11-17 16:26:44','2006-12-21 09:47:43','2006-12-21 10:20:09','2006-12-21 10:21:40','2007-01-02 23:00:24','2007-01-02 23:03:29') NOT NULL |
puroparty.extcal_users.email | allofusforever@yahoo.com | vettyrcian@yahoo.com | 13 | 32 | 0 | 0 | 21.8000 | NULL | ENUM('allofusforever@yahoo.com','amellado@houston.rr.com','annbenavidez@sbcglobal.net','badame@handt.com','bibarra@rpsionline.com','celnic24@yahoo.com','desherrera@gmail.com','dozuna@1lsteele.com','drodriguez147@yahoo.com','DStallings@PhoenixChildrens.Com','GONEFISHINGKATY@YAHOO.COM','henrie_44@yahoo.com','irenehmorales2006@yahoo.com','maria.ramirez.swxw@statefarm.com','news@puroparty.com','puretexican@yahoo.com','puroparty@puroparty.com','rickgomez20@yahoo.com','robert1999@gmail.com','rosielflores@hotmail.com','rs9981@gmail.com','sweetie1255us@yahoo.com','test@test.com','veteransdad@yahoo.com','vettyrcian@yahoo.com') NOT NULL |
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','2006-02-09 14:46:02','2006-02-09 19:56:06','2006-02-14 14:50:16','2006-03-04 08:37:17','2006-03-06 12:40:41','2006-03-29 03:30:19','2006-04-03 09:29:34','2006-04-10 15:35:46','2006-04-13 13:16:21','2006-04-13 15:44:55','2006-04-21 13:18:12','2006-06-13 15:23:58','2006-06-22 23:20:32','2006-06-28 15:53:53','2006-08-28 14:44:42','2006-08-30 13:21:04','2006-09-17 14:28:37','2006-10-12 10:35:49','2006-10-16 17:40:08','2006-11-10 07:04:29','2006-11-17 16:26:44','2006-12-21 09:47:19','2006-12-21 10:20:09') NOT NULL |
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, texas','King-Phillips Insurance Agy','MAGNOLIA','northeast','Phoenix','test') NOT NULL | |
puroparty.extcal_users.user_occupation | youth alcohol/drug prevention instructor | 0 | 40 | 12 | 0 | 7.5200 | NULL | ENUM('','Bartender','Bookkeeper','bus driver','Committee member','FireFighter','hair stylist','Industrial Ironworker','operations manager','Patient Registration Rep','secertery','SELF','test','youth alcohol/drug prevention instructor') NOT NULL | |
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 |