Host: mysql.puroparty.com
Database: puroparty
Generation Time: May 17, 2024 at 06:29 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `ads_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.ads_ad_types.type_id | 9 | 9 | 1 | 1 | 0 | 0 | 9.0000 | 0.0000 | ENUM('9') NOT NULL |
| puroparty.ads_ad_types.type_title | Club Ad | Club Ad | 7 | 7 | 0 | 0 | 7.0000 | NULL | ENUM('Club Ad') NOT NULL |
| puroparty.ads_ad_types.type_required | 537 | 537 | 3 | 3 | 0 | 0 | 537.0000 | 0.0000 | ENUM('537') NOT NULL |
| puroparty.ads_ad_types.type_use | 793 | 793 | 3 | 3 | 0 | 0 | 793.0000 | 0.0000 | ENUM('793') NOT NULL |
| puroparty.ads_ad_types.option1 | cover | cover | 5 | 5 | 0 | 0 | 5.0000 | NULL | ENUM('cover') NOT NULL |
| puroparty.ads_ad_types.def_option1 | door admission | door admission | 14 | 14 | 0 | 0 | 14.0000 | NULL | ENUM('door admission') NOT NULL |
| puroparty.ads_ad_types.option2 | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
| puroparty.ads_ad_types.def_option2 | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
| puroparty.ads_ad_types.option3 | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
| puroparty.ads_ad_types.def_option3 | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
| puroparty.ads_ad_types.option4 | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
| puroparty.ads_ad_types.def_option4 | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
| puroparty.ads_ad_types.option5 | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
| puroparty.ads_ad_types.def_option5 | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
| puroparty.ads_ad_types.option6 | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
| puroparty.ads_ad_types.def_option6 | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
| puroparty.ads_ad_types.option7 | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
| puroparty.ads_ad_types.def_option7 | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
| puroparty.ads_ad_types.option8 | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
| puroparty.ads_ad_types.def_option8 | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
| puroparty.ads_ad_types.option9 | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
| puroparty.ads_ad_types.def_option9 | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
| puroparty.ads_ad_types.option10 | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
| puroparty.ads_ad_types.def_option10 | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
| puroparty.ads_ad_types.template | <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 %adSeller%\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 <tr>\r\n <td colspan="2">\r\n %adDescription%\r\n </td>\r\n </tr>\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 %adSeller%\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 <tr>\r\n <td colspan="2">\r\n %adDescription%\r\n </td>\r\n </tr>\r\n</table> | 735 | 735 | 0 | 0 | 735.0000 | NULL | ENUM('<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 %adSeller%\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 <tr>\r\n <td colspan="2">\r\n %adDescription%\r\n </td>\r\n </tr>\r\n</table>') NOT NULL |