Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 25, 2024 at 05:15 PM
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'... |
| puroparty.extcal_1users.username | angel1150 | reyesbe | 4 | 13 | 0 | 0 | 7.6667 | NULL | ENUM('angel1150','anon','bidaddylou210','Camel','d... |
| puroparty.extcal_1users.password | 9abec23ea7ab584b377cfc6e419e60be | f9815a7103c124304263de8276c13143 | 32 | 32 | 0 | 0 | 32.0000 | NULL | ENUM('9abec23ea7ab584b377cfc6e419e60be','a6ebe407f... |
| puroparty.extcal_1users.firstname | Ana | Mr. | 3 | 9 | 4 | 0 | 4.2667 | NULL | ENUM('','Ana','angel','Bernice','Cynthia','Deanna'... |
| puroparty.extcal_1users.lastname | Administrator | Saenz | 5 | 13 | 4 | 0 | 5.5333 | NULL | ENUM('','Administrator','bustamante','Castillo','E... |
| 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','... |
| puroparty.extcal_1users.email | angel1150@hotmail.com | rsoto@puroparty.com | 16 | 29 | 0 | 0 | 20.6000 | NULL | ENUM('angel1150@hotmail.com','bernice.reyes@UBS.CO... |
| 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','... |
| 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 NUL... | |
| puroparty.extcal_1users.user_location | san antonio,tx | 0 | 14 | 9 | 0 | 4.1333 | NULL | ENUM('','Arizona','houston','Houston, texas','hous... | |
| puroparty.extcal_1users.user_occupation | production operator | 0 | 26 | 9 | 0 | 6.4000 | NULL | ENUM('','accordion player','Bank Specialist','corn... | |
| puroparty.extcal_1users.reg_key | 106056fadb405d90980ed207ca2a40f2 | f1784cea2f29ae66cce71f3c0f0a2cd2 | 32 | 32 | 4 | 1 | 22.8571 | NULL | ENUM('','106056fadb405d90980ed207ca2a40f2','1cf095... |
| puroparty.extcal_1users.user_status | 1 | 1 | 1 | 1 | 6 | 0 | 0.6000 | 0.4899 | ENUM('0','1') NOT NULL |