Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: photopost_photosphotopost_photos
StructureStructure BrowseBrowse SQLSQL SearchSearch InsertInsert ExportExport OperationsOperations EmptyEmpty DropDrop

SQL-query
SQL-query: 
SELECT *
FROM `photopost_photos`
PROCEDURE ANALYSE ( )
 [Edit] [Explain SQL] [Create PHP Code] [Refresh]



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','12099...
puroparty.photopost_photos.title 50_Cent_-_Curtis Forest 6 16 0 0 10.0000 NULL ENUM('50_Cent_-_Curtis','alicia','Desert_Landscape...
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_L...
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') NO...
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','12099...
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


Print viewPrint view    Print view (with full texts)Print view (with full texts)     ExportExport