Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 23, 2024 at 08:29 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `photopost_photos` PROCEDURE ANALYSE();
Rows: 36
Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
---|---|---|---|---|---|---|---|---|---|
puroparty.photopost_photos.id | 1 | 5 | 1 | 1 | 0 | 0 | 3.0000 | 1.4142 | ENUM('1','2','3','4','5') NOT NULL |
puroparty.photopost_photos.user | puroparty | puroparty | 9 | 9 | 0 | 0 | 9.0000 | NULL | ENUM('puroparty') NOT NULL |
puroparty.photopost_photos.userid | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |
puroparty.photopost_photos.cat | 2 | 500 | 1 | 3 | 0 | 0 | 201.2000 | 243.9692 | ENUM('2','500') NOT NULL |
puroparty.photopost_photos.storeid | 0 | 0 | 1 | 1 | 5 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.photopost_photos.storecat | 0 | 0 | 1 | 1 | 5 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.photopost_photos.date | 1209961909 | 1209963519 | 10 | 10 | 0 | 0 | 1209962759.2000 | 1214800199.9906 | ENUM('1209961909','1209962011','1209962840','1209963517','1209963519') NOT NULL |
puroparty.photopost_photos.title | 50_Cent_-_Curtis | Forest | 6 | 16 | 0 | 0 | 10.0000 | NULL | ENUM('50_Cent_-_Curtis','alicia','Desert_Landscape','ff08-b','Forest') NOT NULL |
puroparty.photopost_photos.description | 0 | 0 | 5 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.photopost_photos.keywords | 0 | 0 | 5 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.photopost_photos.bigimage | 50_Cent_-_Curtis.jpg | Forest.jpg | 10 | 20 | 0 | 0 | 14.0000 | NULL | ENUM('50_Cent_-_Curtis.jpg','alicia.jpg','Desert_Landscape.jpg','ff08-b.jpg','Forest.jpg') NOT NULL |
puroparty.photopost_photos.width | 240 | 1024 | 3 | 4 | 0 | 0 | 677.6000 | 343.2326 | ENUM('240','300','800','1024') NOT NULL |
puroparty.photopost_photos.height | 184 | 768 | 3 | 3 | 0 | 0 | 514.6000 | 254.0894 | ENUM('184','240','613','768') NOT NULL |
puroparty.photopost_photos.filesize | 21649 | 664489 | 5 | 6 | 0 | 0 | 204805.2000 | 241182.3023 | ENUM('21649','43683','65342','228863','664489') NOT NULL |
puroparty.photopost_photos.views | 1 | 3 | 1 | 1 | 2 | 0 | 1.2000 | 1.1662 | ENUM('0','1','2','3') NOT NULL |
puroparty.photopost_photos.medwidth | 600 | 600 | 3 | 3 | 2 | 0 | 360.0000 | 293.9388 | ENUM('0','600') NOT NULL |
puroparty.photopost_photos.medheight | 450 | 459 | 3 | 3 | 2 | 0 | 271.8000 | 221.9481 | ENUM('0','450','459') NOT NULL |
puroparty.photopost_photos.medsize | 37345 | 64626 | 5 | 5 | 2 | 0 | 28572.4000 | 25144.9103 | ENUM('0','37345','40891','64626') NOT NULL |
puroparty.photopost_photos.approved | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |
puroparty.photopost_photos.lastpost | 1209961909 | 1209963519 | 10 | 10 | 0 | 0 | 1209962759.2000 | 1214800199.9906 | ENUM('1209961909','1209962011','1209962840','1209963517','1209963519') NOT NULL |
puroparty.photopost_photos.rating | 0.00 | 0.00 | 4 | 4 | 5 | 0 | 0.00 | 0.00 | ENUM('0.00') NOT NULL |
puroparty.photopost_photos.watermarked | no | no | 2 | 2 | 0 | 0 | 2.0000 | NULL | ENUM('no') NOT NULL |
puroparty.photopost_photos.allowprint | yes | yes | 3 | 3 | 0 | 0 | 3.0000 | NULL | ENUM('yes') NOT NULL |
puroparty.photopost_photos.extra1 | 0 | 0 | 5 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.photopost_photos.extra2 | 0 | 0 | 5 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.photopost_photos.extra3 | 0 | 0 | 5 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.photopost_photos.extra4 | 0 | 0 | 5 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.photopost_photos.extra5 | 0 | 0 | 5 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.photopost_photos.extra6 | 0 | 0 | 5 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.photopost_photos.disporder | 99999 | 99999 | 5 | 5 | 0 | 0 | 99999.0000 | 0.0000 | ENUM('99999') NOT NULL |
puroparty.photopost_photos.ipaddress | 99.158.44.10 | 99.158.44.10 | 12 | 12 | 0 | 0 | 12.0000 | NULL | ENUM('99.158.44.10') NOT NULL |
puroparty.photopost_photos.numcom | 0 | 0 | 1 | 1 | 5 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.photopost_photos.lastposter | NULL | NULL | 0 | 0 | 0 | 5 | 0.0 | NULL | CHAR(0) |
puroparty.photopost_photos.lastpid | 0 | 0 | 1 | 1 | 5 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.photopost_photos.allowrate | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |
puroparty.photopost_photos.allowcoms | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |