Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 26, 2024 at 04:00 PM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `photopost_users` PROCEDURE ANALYSE();
Rows: 21
Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
---|---|---|---|---|---|---|---|---|---|
puroparty.photopost_users.userid | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |
puroparty.photopost_users.usergroupid | 5 | 5 | 1 | 1 | 0 | 0 | 5.0000 | 0.0000 | ENUM('5') NOT NULL |
puroparty.photopost_users.username | puroparty | puroparty | 9 | 9 | 0 | 0 | 9.0000 | NULL | ENUM('puroparty') NOT NULL |
puroparty.photopost_users.password | e31d751f28059199c5fb61cb3e3997cb | e31d751f28059199c5fb61cb3e3997cb | 32 | 32 | 0 | 0 | 32.0000 | NULL | ENUM('e31d751f28059199c5fb61cb3e3997cb') NOT NULL |
puroparty.photopost_users.email | robert1999@gmail.com | robert1999@gmail.com | 20 | 20 | 0 | 0 | 20.0000 | NULL | ENUM('robert1999@gmail.com') NOT NULL |
puroparty.photopost_users.homepage | NULL | NULL | 0 | 0 | 0 | 1 | 0.0 | NULL | CHAR(0) |
puroparty.photopost_users.icq | NULL | NULL | 0 | 0 | 0 | 1 | 0.0 | NULL | CHAR(0) |
puroparty.photopost_users.aim | NULL | NULL | 0 | 0 | 0 | 1 | 0.0 | NULL | CHAR(0) |
puroparty.photopost_users.yahoo | NULL | NULL | 0 | 0 | 0 | 1 | 0.0 | NULL | CHAR(0) |
puroparty.photopost_users.joindate | 1209961475 | 1209961475 | 10 | 10 | 0 | 0 | 1209961475.0000 | 0.0000 | ENUM('1209961475') NOT NULL |
puroparty.photopost_users.posts | 5 | 5 | 1 | 1 | 0 | 0 | 5.0000 | 0.0000 | ENUM('5') NOT NULL |
puroparty.photopost_users.birthday | 0000-00-00 | 0000-00-00 | 10 | 10 | 0 | 0 | 10.0000 | NULL | ENUM('0000-00-00') NOT NULL |
puroparty.photopost_users.ipaddress | NULL | NULL | 0 | 0 | 0 | 1 | 0.0 | NULL | CHAR(0) |
puroparty.photopost_users.location | NULL | NULL | 0 | 0 | 0 | 1 | 0.0 | NULL | CHAR(0) |
puroparty.photopost_users.interests | NULL | NULL | 0 | 0 | 0 | 1 | 0.0 | NULL | CHAR(0) |
puroparty.photopost_users.occupation | NULL | NULL | 0 | 0 | 0 | 1 | 0.0 | NULL | CHAR(0) |
puroparty.photopost_users.bio | NULL | NULL | 0 | 0 | 0 | 1 | 0.0 | NULL | CHAR(0) |
puroparty.photopost_users.site | NULL | NULL | 0 | 0 | 0 | 1 | 0.0 | NULL | CHAR(0) |
puroparty.photopost_users.offset | 0 | 0 | 1 | 1 | 1 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.photopost_users.views | 6 | 6 | 1 | 1 | 0 | 0 | 6.0000 | 0.0000 | ENUM('6') NOT NULL |
puroparty.photopost_users.cellphone | NULL | NULL | 0 | 0 | 0 | 1 | 0.0 | NULL | CHAR(0) |