SQL result

Host: mysql.puroparty.com
Database: puroparty
Generation Time: Mar 29, 2024 at 11:39 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `ads_categories` PROCEDURE ANALYSE();
Rows: 23

Field_name Min_value Max_value Min_length Max_length Empties_or_zeros Nulls Avg_value_or_avg_length Std Optimal_fieldtype
puroparty.ads_categories.category_id 8 27 1 2 0 0 19.0000 5.2769 ENUM('8','13','14','15','16','19','20','21','22','23','24','25','27') NOT NULL
puroparty.ads_categories.category_order 1 14 1 2 0 0 7.5385 4.1808 ENUM('1','2','3','4','5','6','8','9','10','11','12','13','14') NOT NULL
puroparty.ads_categories.category_parent 0 0 1 1 13 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.ads_categories.category_title clubs/bars want to hire 8 20 0 0 12.1538 NULL ENUM('clubs/bars','entertainers','festivals','free stuff','fundraisers/benefits','happy hour','indoor concerts','non-profits','outdoor concerts','services','stuff for sale','want to buy','want to hire') NOT NULL
puroparty.ads_categories.category_desc "annual" cookoffs, fairs,<br>festivals, bazaars sell your 'good' stuff here! 13 58 0 0 30.6923 NULL ENUM('"annual" cookoffs, fairs,<br>festivals, bazaars','501(c)orgs only!','al aire libre','ask, someone might have it','benefits, bbq teams, etc;','cheap drinks here!','clubs don’t count<br>’cept for rainouts','entertainers for hire, bands,<br> djs, mcs, booking agents','gigs, job offers,<br> need help, volunteers','icehouses, bars, clubs,<br> taverns, pubs','limos, cakes, flowers, etc;','NO pesos required!','sell your \'good\' stuff here!') NOT NULL
puroparty.ads_categories.category_img     0 0 13 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.ads_categories.category_ad_types   9, 0 2 12 0 0.1538 NULL ENUM('','9,') NOT NULL
puroparty.ads_categories.category_ad_prices   0.00, 0 5 12 0 0.3846 NULL ENUM('','0.00,') NOT NULL
puroparty.ads_categories.category_optional_1     0 0 13 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.ads_categories.category_optional_1_def     0 0 13 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.ads_categories.category_optional_2     0 0 13 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.ads_categories.category_optional_2_def     0 0 13 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.ads_categories.category_optional_3     0 0 13 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.ads_categories.category_optional_3_def     0 0 13 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.ads_categories.category_optional_4     0 0 13 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.ads_categories.category_optional_4_def     0 0 13 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.ads_categories.category_optional_5     0 0 13 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.ads_categories.category_optional_5_def     0 0 13 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.ads_categories.category_subs 0 0 1 1 13 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.ads_categories.category_listings 0 5 1 1 12 0 0.3846 1.3323 ENUM('0','5') NOT NULL
puroparty.ads_categories.banner_top     0 0 13 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.ads_categories.banner_bottom     0 0 13 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.ads_categories.category_related     0 0 13 0 0.0000 NULL CHAR(0) NOT NULL