Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 20, 2024 at 01:12 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `extcal2_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.extcal2_users.user_id | 1 | 4 | 1 | 1 | 0 | 0 | 2.5000 | 1.1180 | ENUM('1','2','3','4') NOT NULL |
puroparty.extcal2_users.username | layla | thebigblogger | 5 | 13 | 0 | 0 | 8.5000 | NULL | ENUM('layla','puroparty','test123','thebigblogger'... |
puroparty.extcal2_users.password | 098f6bcd4621d373cade4e832627b4f6 | e31d751f28059199c5fb61cb3e3997cb | 32 | 32 | 0 | 0 | 32.0000 | NULL | ENUM('098f6bcd4621d373cade4e832627b4f6','9d5e3ecde... |
puroparty.extcal2_users.firstname | charlie | Mr. | 3 | 7 | 1 | 0 | 3.7500 | NULL | ENUM('','charlie','layla','Mr.') NOT NULL |
puroparty.extcal2_users.lastname | Administrator | t | 1 | 13 | 1 | 0 | 5.5000 | NULL | ENUM('','Administrator','cardenas','t') NOT NULL |
puroparty.extcal2_users.group_id | 1 | 5 | 1 | 1 | 0 | 0 | 3.0000 | 1.4142 | ENUM('1','3','5') NOT NULL |
puroparty.extcal2_users.lastvisit | 2007-01-02 22:17:01 | 2007-01-02 23:33:44 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('2007-01-02 22:17:01','2007-01-02 23:07:44','... |
puroparty.extcal2_users.email | layla@puroparty.com | robert@puroparty.com | 18 | 20 | 0 | 0 | 19.2500 | NULL | ENUM('layla@puroparty.com','news@puroparty.com','r... |
puroparty.extcal2_users.user_regdate | 2006-12-21 15:59:09 | 2007-01-02 22:17:01 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('2006-12-21 15:59:09','2006-12-29 18:00:59','... |
puroparty.extcal2_users.user_lang | 0 | 0 | 4 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.extcal2_users.user_website | 0 | 0 | 4 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.extcal2_users.user_location | houston | 0 | 9 | 2 | 0 | 4.0000 | NULL | ENUM('','bellville','houston') NOT NULL | |
puroparty.extcal2_users.user_occupation | story teller | 0 | 13 | 2 | 0 | 6.2500 | NULL | ENUM('','picker/packer','story teller') NOT NULL | |
puroparty.extcal2_users.reg_key | 340a86cbeb0f504fcab4a24cfe07dbc4 | 3f41ced368afdebd34578aea1e3af729 | 32 | 32 | 0 | 2 | 32.0000 | NULL | ENUM('340a86cbeb0f504fcab4a24cfe07dbc4','3f41ced36... |
puroparty.extcal2_users.user_status | 1 | 1 | 1 | 1 | 1 | 0 | 0.7500 | 0.4330 | ENUM('0','1') NOT NULL |