SQL result

Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 25, 2024 at 07:07 PM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `bos_ad_types` PROCEDURE ANALYSE();
Rows: 25

Field_name Min_value Max_value Min_length Max_length Empties_or_zeros Nulls Avg_value_or_avg_length Std Optimal_fieldtype
puroparty.bos_ad_types.type_id 12 25 2 2 0 0 20.7500 3.7997 ENUM('12','19','20','21','22','23','24','25') NOT NULL
puroparty.bos_ad_types.type_title Artist Ad Mariachis 5 19 0 0 10.5000 NULL ENUM('Artist Ad','Clubs/Bars','Concert/Festival Ad','DJ Ad','Fundraiser Ad','Halls','Happy Hour Ad!','Mariachis') NOT NULL
puroparty.bos_ad_types.type_required 3609 423449 4 6 0 0 120921.0000 139567.5369 ENUM('3609','5657','7705','32281','116249','129049','249369','423449') NOT NULL
puroparty.bos_ad_types.type_use 7961 524057 4 6 0 0 185817.0000 210884.7975 ENUM('7961','32537','124697','257817','523545','524057') NOT NULL
puroparty.bos_ad_types.option1 state state 5 5 0 0 5.0000 NULL ENUM('state') NOT NULL
puroparty.bos_ad_types.def_option1 3|1|1|Texas 3|1|1|Texas| 11 12 0 0 11.2500 NULL ENUM('3|1|1|Texas','3|1|1|Texas|') NOT NULL
puroparty.bos_ad_types.option2 beneficiary ticket price 10 12 0 0 11.1250 NULL ENUM('beneficiary','company name','contact# 1','cover charge','group name','ticket price') NOT NULL
puroparty.bos_ad_types.def_option2 1||| 2||| 4 5 0 0 4.2500 NULL ENUM('1|||','1||||','2|||') NOT NULL
puroparty.bos_ad_types.option3 # members Phone 5 10 1 0 7.7500 NULL ENUM('','# members','contact #','contact #1','contact #2','dj name(s)','headliner','Phone') NOT NULL
puroparty.bos_ad_types.def_option3 1||| 2||| 4 5 1 0 3.7500 NULL ENUM('','1|||','1||||','2|||') NOT NULL
puroparty.bos_ad_types.option4 contact #2 venue name 10 15 2 0 8.7500 NULL ENUM('','contact #2','drink selection','genre types','group gender','max capacity','venue name') NOT NULL
puroparty.bos_ad_types.def_option4 1||| 5|4||beer|draft|wine|liquor 4 31 2 0 9.2500 NULL ENUM('','1|||','2|||','4|2|2|all male|all female|mixed','5|4||beer|draft|wine|liquor') NOT NULL
puroparty.bos_ad_types.option5   seating 0 17 3 0 6.5000 NULL ENUM('','Drinks Avail','food avail?','genre','genre specialties','seating') NOT NULL
puroparty.bos_ad_types.def_option5   5|4||beer|draft|wine|liquor 0 27 3 0 9.0000 NULL ENUM('','1|||','4|2|2|yes|no','4|3|2|indoor|outdoor|both','5|4||beer|draft|wine|liquor') NOT NULL
puroparty.bos_ad_types.option6   patio seating? 0 14 3 0 6.2500 NULL ENUM('','# members','equip','event month','Food Avail?','patio seating?') NOT NULL
puroparty.bos_ad_types.def_option6   5|2|sound|lights 0 54 3 0 12.2500 NULL ENUM('','1|||','3|12||jan|feb|mar|apr|may|jun|jul|aug|sep|oct|nov|dec|','4|2|2|yes|no','5|2|sound|lights') NOT NULL
puroparty.bos_ad_types.option7   Patio Seating? 0 15 4 0 6.0000 NULL ENUM('','available area','booking contact','music','Patio Seating?') NOT NULL
puroparty.bos_ad_types.def_option7   5|5||piped|jukebox|karaoke|dj|band 0 34 4 0 6.7500 NULL ENUM('','1|||','4|2|2|yes|no','5|5||piped|jukebox|karaoke|dj|band') NOT NULL
puroparty.bos_ad_types.option8   other stuff 0 11 4 0 4.3750 NULL ENUM('','booking #','contact #1','music','other stuff') NOT NULL
puroparty.bos_ad_types.def_option8   5|5||piped|jukebox|karaoke|dj|band 0 34 4 0 7.7500 NULL ENUM('','1|||','5|2|pool|big screens','5|5||piped|jukebox|karaoke|dj|band') NOT NULL
puroparty.bos_ad_types.option9   other stuff 0 11 5 0 3.6250 NULL ENUM('','contact #2','event mo','other stuff') NOT NULL
puroparty.bos_ad_types.def_option9   5|2||pool|big screens 0 54 5 0 9.8750 NULL ENUM('','1|||','3|12||jan|feb|mar|apr|may|jun|jul|aug|sep|oct|nov|dec|','5|2||pool|big screens') NOT NULL
puroparty.bos_ad_types.option10   other comments 0 14 6 0 3.0000 NULL ENUM('','event date','other comments') NOT NULL
puroparty.bos_ad_types.def_option10   2||| 0 5 6 0 1.1250 NULL ENUM('','1||||','2|||') NOT NULL
puroparty.bos_ad_types.template \r\n\r\n<table width="100%" border="0" cellspacing="0" cellpadding="3">\r\n <tr>\r\n  <td class="headtd" width="50%">%adTitle%</td>\r\n  <td class="headtd" width="50%" align="right">%adNumber%</td>\r\n </tr>\r\n <tr>\r\n  <td valign="top" width="50%">\r\n\r\n   <!--%adSeller%-------------------rrs----------------->\r\n   %adDescription% <!-- added rrs -->\r\n   %adPrice%\r\n   %adCondition%\r\n   %adCity%\r\n   %adState%\r\n   %adPostal%\r\n   %adCountry%\r\n   %adTypeOpt1%\r\n   %adTypeOpt2%\r\n   %adTypeOpt3%\r\n   %adTypeOpt4%\r\n   %adTypeOpt5%\r\n   %adTypeOpt6%\r\n   %adTypeOpt7%\r\n   %adTypeOpt8%\r\n   %adTypeOpt9%\r\n   %adTypeOpt10%\r\n   %adCatOpt1%\r\n   %adCatOpt2%\r\n   %adCatOpt3%\r\n   %adCatOpt4%\r\n   %adCatOpt5%\r\n  </td>\r\n  <td valign="top" width="50%">\r\n   %adImages%\r\n  </td>\r\n </tr>\r\n<!-- rrs\r\n <tr>\r\n  <td colspan=&quot;2&quot;>\r\n   %adDescription%\r\n  </td>\r\n </tr>\r\n -->\r\n</table> <table width="100%" border="0" cellspacing="0" cellpadding="3">\r\n <tr>\r\n  <td class="headtd" width="50%">%adTitle%</td>\r\n  <td class="headtd" width="50%" align="right">%adNumber%</td>\r\n </tr>\r\n <tr>\r\n  <td valign="top" width="50%">\r\n\r\n   <!--%adSeller%-------------------rrs----------------->\r\n   %adDescription% <!-- added rrs -->\r\n   %adPrice%\r\n   %adCondition%\r\n   %adCity%\r\n   %adState%\r\n   %adPostal%\r\n   %adCountry%\r\n   %adTypeOpt1%\r\n   %adTypeOpt2%\r\n   %adTypeOpt3%\r\n   %adTypeOpt4%\r\n   %adTypeOpt5%\r\n   %adTypeOpt6%\r\n   %adTypeOpt7%\r\n   %adTypeOpt8%\r\n   %adTypeOpt9%\r\n   %adTypeOpt10%\r\n   %adCatOpt1%\r\n   %adCatOpt2%\r\n   %adCatOpt3%\r\n   %adCatOpt4%\r\n   %adCatOpt5%\r\n  </td>\r\n  <td valign="top" width="50%">\r\n   %adImages%\r\n  </td>\r\n </tr>\r\n<!-- rrs\r\n <tr>\r\n  <td colspan=&quot;2&quot;>\r\n   %adDescription%\r\n  </td>\r\n </tr>\r\n -->\r\n</table> 846 850 0 0 847.0000 NULL ENUM('\r\n\r\n<table width="100%" border="0" cellspacing="0" cellpadding="3">\r\n <tr>\r\n  <td class="headtd" width="50%">%adTitle%</td>\r\n  <td class="headtd" width="50%" align="right">%adNumber%</td>\r\n </tr>\r\n <tr>\r\n  <td valign="top" width="50%">\r\n\r\n   <!--%adSeller%-------------------rrs----------------->\r\n   %adDescription% <!-- added rrs -->\r\n   %adPrice%\r\n   %adCondition%\r\n   %adCity%\r\n   %adState%\r\n   %adPostal%\r\n   %adCountry%\r\n   %adTypeOpt1%\r\n   %adTypeOpt2%\r\n   %adTypeOpt3%\r\n   %adTypeOpt4%\r\n   %adTypeOpt5%\r\n   %adTypeOpt6%\r\n   %adTypeOpt7%\r\n   %adTypeOpt8%\r\n   %adTypeOpt9%\r\n   %adTypeOpt10%\r\n   %adCatOpt1%\r\n   %adCatOpt2%\r\n   %adCatOpt3%\r\n   %adCatOpt4%\r\n   %adCatOpt5%\r\n  </td>\r\n  <td valign="top" width="50%">\r\n   %adImages%\r\n  </td>\r\n </tr>\r\n<!-- rrs\r\n <tr>\r\n  <td colspan=&quot;2&quot;>\r\n   %adDescription%\r\n  </td>\r\n </tr>\r\n -->\r\n</table>','\r\n<table width="100%" border="0" cellspacing="0" cellpadding="3">\r\n <tr>\r\n  <td class="headtd" width="50%">%adTitle%</td>\r\n  <td class="headtd" width="50%" align="right">%adNumber%</td>\r\n </tr>\r\n <tr>\r\n  <td valign="top" width="50%">\r\n\r\n   <!--%adSeller%-------------------rrs----------------->\r\n   %adDescription% <!-- added rrs -->\r\n   %adPrice%\r\n   %adCondition%\r\n   %adCity%\r\n   %adState%\r\n   %adPostal%\r\n   %adCountry%\r\n   %adTypeOpt1%\r\n   %adTypeOpt2%\r\n   %adTypeOpt3%\r\n   %adTypeOpt4%\r\n   %adTypeOpt5%\r\n   %adTypeOpt6%\r\n   %adTypeOpt7%\r\n   %adTypeOpt8%\r\n   %adTypeOpt9%\r\n   %adTypeOpt10%\r\n   %adCatOpt1%\r\n   %adCatOpt2%\r\n   %adCatOpt3%\r\n   %adCatOpt4%\r\n   %adCatOpt5%\r\n  </td>\r\n  <td valign="top" width="50%">\r\n   %adImages%\r\n  </td>\r\n </tr>\r\n<!-- rrs\r\n <tr>\r\n  <td colspan=&quot;2&quot;>\r\n   %adDescription%\r\n  </td>\r\n </tr>\r\n -->\r\n</table>','<table width="100%" border="0" cellspacing="0" cellpadding="3">\r\n <tr>\r\n  <td class="headtd" width="50%">%adTitle%</td>\r\n  <td class="headtd" width="50%" align="right">%adNumber%</td>\r\n </tr>\r\n <tr>\r\n  <td valign="top" width="50%">\r\n\r\n   <!--%adSeller%-------------------rrs----------------->\r\n   %adDescription% <!-- added rrs -->\r\n   %adPrice%\r\n   %adCondition%\r\n   %adCity%\r\n   %adState%\r\n   %adPostal%\r\n   %adCountry%\r\n   %adTypeOpt1%\r\n   %adTypeOpt2%\r\n   %adTypeOpt3%\r\n   %adTypeOpt4%\r\n   %adTypeOpt5%\r\n   %adTypeOpt6%\r\n   %adTypeOpt7%\r\n   %adTypeOpt8%\r\n   %adTypeOpt9%\r\n   %adTypeOpt10%\r\n   %adCatOpt1%\r\n   %adCatOpt2%\r\n   %adCatOpt3%\r\n   %adCatOpt4%\r\n   %adCatOpt5%\r\n  </td>\r\n  <td valign="top" width="50%">\r\n   %adImages%\r\n  </td>\r\n </tr>\r\n<!-- rrs\r\n <tr>\r\n  <td colspan=&quot;2&quot;>\r\n   %adDescription%\r\n  </td>\r\n </tr>\r\n -->\r\n</table>') NOT NULL