SQL result

Host: mysql.puroparty.com
Database: puroparty
Generation Time: Mar 28, 2024 at 08:20 PM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `extcal_1categories` PROCEDURE ANALYSE();
Rows: 8

Field_name Min_value Max_value Min_length Max_length Empties_or_zeros Nulls Avg_value_or_avg_length Std Optimal_fieldtype
puroparty.extcal_1categories.cat_id 1 53944 1 5 0 0 2848.1579 12043.4065 ENUM('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','53944') NOT NULL
puroparty.extcal_1categories.cat_parent 0 9 1 1 18 0 0.4737 2.0097 ENUM('0','9') NOT NULL
puroparty.extcal_1categories.cat_name 1511878819 wharton and more 3 16 0 0 8.0000 NULL ENUM('1511878819','arizona','austin','beaumont','california','corpus christi','dfw','General','houston','mexico','other','private','san antonio','tba','the valley','victoria','waco','west texas','wharton and more') NOT NULL
puroparty.extcal_1categories.description \0 wharton, el campo, bay city 1 28 0 0 15.6316 NULL ENUM('\0','austin msa','beaumont/port arthur area','corpus christi msa','dallas/fort worth msa','houston msa','lower rio grande valley','mexico events','non major msa in tx','private gigs','sa msa','state of arizona','state of california','This is the default category','to be announced','victoria msa','waco area','west tx area','wharton, el campo, bay city') NOT NULL
puroparty.extcal_1categories.color #000000 3872 4 7 0 0 6.8421 NULL ENUM('#000000','#0066CC','#00FF00','#33FFCC','#505054','#663300','#993399','#BBBBBB','#FF9900','#FFFF00','3872') NOT NULL
puroparty.extcal_1categories.bgcolor #EEF0F0 2070-08-29 7 10 0 0 7.1579 NULL ENUM('#EEF0F0','2070-08-29') NOT NULL
puroparty.extcal_1categories.options 0 53 1 2 1 0 4.5789 11.4217 ENUM('0','2','53') NOT NULL
puroparty.extcal_1categories.enabled 1 1 1 1 1 0 0.9474 0.2233 ENUM('0','1') NOT NULL