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

SQL-query
SQL-query: 
SELECT *
FROM `ads_ads`
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.ads_ads.ad_id 6 10 1 2 0 0 8.0000 1.4142 ENUM('6','7','8','9','10') NOT NULL
puroparty.ads_ads.ad_status 1 1 1 1 0 0 1.0000 0.0000 ENUM('1') NOT NULL
puroparty.ads_ads.ad_user_id 1 1 1 1 0 0 1.0000 0.0000 ENUM('1') NOT NULL
puroparty.ads_ads.ad_category 8 8 1 1 0 0 8.0000 0.0000 ENUM('8') NOT NULL
puroparty.ads_ads.ad_date_begin 2007-09-18 2007-09-18 10 10 0 0 10.0000 NULL ENUM('2007-09-18') NOT NULL
puroparty.ads_ads.ad_date_end 2007-09-25 2007-10-18 10 10 0 0 10.0000 NULL ENUM('2007-09-25','2007-10-18') NOT NULL
puroparty.ads_ads.ad_type 9 9 1 1 0 0 9.0000 0.0000 ENUM('9') NOT NULL
puroparty.ads_ads.ad_title las rosas the meridian 9 19 0 0 14.0000 NULL ENUM('las rosas','onion creek','sheltons tejano ba...
puroparty.ads_ads.ad_description all the crazy rock groups doing drugs and stuff ev... elvis at las rosas tonight for the first time in 3... 35 145 0 0 75.0000 NULL ENUM('all the crazy rock groups doing drugs and st...
puroparty.ads_ads.ad_image1 IMG_8704.jpg t_page118.jpg 10 21 0 0 14.2000 NULL ENUM('IMG_8704.jpg','page47.jpg','ppban120x60.jpg'...
puroparty.ads_ads.ad_image2 IMG_6372.jpg puropartylogo286x150.jpg 10 24 0 0 16.2000 NULL ENUM('IMG_6372.jpg','page130.jpg','page19.jpg','pp...
puroparty.ads_ads.ad_image3     0 0 5 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.ads_ads.ad_image4     0 0 5 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.ads_ads.ad_image5     0 0 5 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.ads_ads.ad_options 1 36 1 2 1 0 13.8000 13.8188 ENUM('0','1','9','23','36') NOT NULL
puroparty.ads_ads.ad_optional_1     0 0 5 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.ads_ads.ad_optional_2     0 0 5 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.ads_ads.ad_optional_3     0 0 5 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.ads_ads.ad_optional_4     0 0 5 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.ads_ads.ad_optional_5     0 0 5 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.ads_ads.ad_type_optional1     0 0 5 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.ads_ads.ad_type_optional2     0 0 5 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.ads_ads.ad_type_optional3     0 0 5 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.ads_ads.ad_type_optional4     0 0 5 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.ads_ads.ad_type_optional5     0 0 5 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.ads_ads.ad_type_optional6     0 0 5 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.ads_ads.ad_type_optional7     0 0 5 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.ads_ads.ad_type_optional8     0 0 5 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.ads_ads.ad_type_optional9     0 0 5 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.ads_ads.ad_type_optional10     0 0 5 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.ads_ads.ad_price     0 0 5 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.ads_ads.ad_condition 0 0 1 1 5 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.ads_ads.ad_views 2 5 1 1 1 0 2.6000 1.7436 ENUM('0','2','4','5') NOT NULL
puroparty.ads_ads.ad_address   112 chartres 0 12 4 0 2.4000 NULL ENUM('','112 chartres') NOT NULL
puroparty.ads_ads.ad_city   houston 0 7 4 0 1.4000 NULL ENUM('','houston') NOT NULL
puroparty.ads_ads.ad_state   tx 0 2 4 0 0.4000 NULL ENUM('','tx') NOT NULL
puroparty.ads_ads.ad_postal     0 0 5 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.ads_ads.ad_country     0 0 5 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.ads_ads.ad_city_code 0 0 1 1 5 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.ads_ads.ad_state_code 0 0 1 1 5 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.ads_ads.ad_country_code 0 0 1 1 5 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.ads_ads.ad_fee 0.00 0.00 4 4 5 0 0.00 0.00 ENUM('0.00') NOT NULL
puroparty.ads_ads.ad_anon_name     0 0 5 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.ads_ads.ad_anon_email     0 0 5 0 0.0000 NULL CHAR(0) NOT NULL


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