Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 26, 2024 at 05:39 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `extcal_1users` 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_1users.user_id | 1 | 15 | 1 | 2 | 0 | 0 | 8.0000 | 4.3205 | ENUM('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15') NOT NULL |
puroparty.extcal_1users.username | angel1150 | reyesbe | 4 | 13 | 0 | 0 | 7.6667 | NULL | ENUM('angel1150','anon','bidaddylou210','Camel','dmunoz','ebusta','heespinoza','Jess3472','lrodriguezxx','micky2007','ppcru','puroparty','regi','regipriv','reyesbe') NOT NULL |
puroparty.extcal_1users.password | 9abec23ea7ab584b377cfc6e419e60be | f9815a7103c124304263de8276c13143 | 32 | 32 | 0 | 0 | 32.0000 | NULL | ENUM('9abec23ea7ab584b377cfc6e419e60be','a6ebe407fa6e2337cb2deb573d17791e','bd1f05d4cf6d7b8a695d0b100368061d','cb4e63c913e67452dfa42b695e029145','d0a3aaf353f3485c565507fd6e5b6d29','d16d377af76c99d27093abc22244b342','e31d751f28059199c5fb61cb3e3997cb','ec7047aaf6b5d9d8470dd2c3e925670a','f655bd89eb3e1bb03de28f3deb8af634','f80b2a97b5f7f20297356c88fea52cb7','f9815a7103c124304263de8276c13143') NOT NULL |
puroparty.extcal_1users.firstname | Ana | Mr. | 3 | 9 | 4 | 0 | 4.2667 | NULL | ENUM('','Ana','angel','Bernice','Cynthia','Deanna','edwardo','Henrietta','Jessica','luis','mickey','Mr.') NOT NULL |
puroparty.extcal_1users.lastname | Administrator | Saenz | 5 | 13 | 4 | 0 | 5.5333 | NULL | ENUM('','Administrator','bustamante','Castillo','Espinoza','mendoza','Munoz','ortega','peguero','Reyes','Rodriguez','Saenz') NOT NULL |
puroparty.extcal_1users.group_id | 1 | 6 | 1 | 1 | 0 | 0 | 3.0667 | 1.1813 | ENUM('1','3','5','6') NOT NULL |
puroparty.extcal_1users.lastvisit | 2007-04-08 23:13:45 | 2007-11-08 01:28:02 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('2007-04-08 23:13:45','2007-04-08 23:18:35','2007-04-08 23:21:42','2007-05-22 17:30:16','2007-05-28 16:14:28','2007-06-19 19:06:58','2007-06-27 03:14:23','2007-07-11 00:01:03','2007-08-20 21:23:57','2007-09-10 12:58:01','2007-09-24 15:26:38','2007-10-08 15:13:44','2007-10-10 23:12:35','2007-11-05 12:51:20','2007-11-08 01:28:02') NOT NULL |
puroparty.extcal_1users.email | angel1150@hotmail.com | rsoto@puroparty.com | 16 | 29 | 0 | 0 | 20.6000 | NULL | ENUM('angel1150@hotmail.com','bernice.reyes@UBS.COM','brooke_castillo1022@yahoo.com','deanna.munoz@yahoo.com','ebustmante0102@msn.com','elis_saenz@yahoo.com','henrie_44@yahoo.com','lrodriguezxx@hotmail.com','mcm07@sbcglobal.net','pegueroluis@yahoo.com','pp@puroparty.com','ppcru@puroparty.com','rob@puroparty.com','robert@puroparty.com','rsoto@puroparty.com') NOT NULL |
puroparty.extcal_1users.user_regdate | 2007-04-08 12:41:53 | 2007-11-08 01:28:02 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('2007-04-08 12:41:53','2007-04-08 23:01:08','2007-04-08 23:10:26','2007-04-08 23:17:33','2007-04-08 23:20:55','2007-05-22 17:30:16','2007-05-28 16:14:28','2007-06-27 03:14:23','2007-07-11 00:01:03','2007-08-20 21:23:57','2007-09-10 12:58:01','2007-09-24 15:26:38','2007-09-25 10:15:08','2007-11-05 12:38:54','2007-11-08 01:28:02') NOT NULL |
puroparty.extcal_1users.user_lang | 0 | 0 | 15 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.extcal_1users.user_website | n/a | 0 | 19 | 12 | 0 | 1.6667 | NULL | ENUM('','mcm07@sbcglobal.net','msn','n/a') NOT NULL | |
puroparty.extcal_1users.user_location | san antonio,tx | 0 | 14 | 9 | 0 | 4.1333 | NULL | ENUM('','Arizona','houston','Houston, texas','houston,texas','san antonio,tx') NOT NULL | |
puroparty.extcal_1users.user_occupation | production operator | 0 | 26 | 9 | 0 | 6.4000 | NULL | ENUM('','accordion player','Bank Specialist','corn proc. FRITO -LAY INC.','Investments','machinist','production operator') NOT NULL | |
puroparty.extcal_1users.reg_key | 106056fadb405d90980ed207ca2a40f2 | f1784cea2f29ae66cce71f3c0f0a2cd2 | 32 | 32 | 4 | 1 | 22.8571 | NULL | ENUM('','106056fadb405d90980ed207ca2a40f2','1cf0950f06bf7887ce6574b1b7fbc070','6a2914b1455424434032d7b126204011','7422c8ab8c9624616eb0e7e16b8d0c54','983dd60301e2624d10e97b0d329f9d3b','b248bae315faf91c6cc10fd50320a66a','bcd8f7235dc556bc0c9a73edafc6dcd4','d1cbfd17502047e08e5551e564c1c2d0','d8a1bf449a5bb0171cd3fe6168c8dcba','f1784cea2f29ae66cce71f3c0f0a2cd2') |
puroparty.extcal_1users.user_status | 1 | 1 | 1 | 1 | 6 | 0 | 0.6000 | 0.4899 | ENUM('0','1') NOT NULL |