Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 20, 2024 at 09:12 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `ads_ads` PROCEDURE ANALYSE();
Rows: 44
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 bar','the doghouse tavern','the meridian') NOT NULL |
puroparty.ads_ads.ad_description | all the crazy rock groups doing drugs and stuff every nite of the week. | elvis at las rosas tonight for the first time in 37 years. don't miss this show cuz he won't be back! brought to you by tjs bravo and company!!!! | 35 | 145 | 0 | 0 | 75.0000 | NULL | ENUM('all the crazy rock groups doing drugs and stuff every nite of the week.','come drink quart bottles of colt 45','come to the heights and enjoy our patio. food, drinks, carbon monoxide! ','draft beer, girls just like at the doghouse on hwy 3','elvis at las rosas tonight for the first time in 37 years. don\'t miss this show cuz he won\'t be back! brought to you by tjs bravo and company!!!!') NOT NULL |
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','pplogocham286x150.jpg','t_page118.jpg') NOT NULL |
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_logo_flat_576x446.jpg','puropartylogo286x150.jpg') NOT NULL |
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 |