Host: mysql.puroparty.com
Database: puroparty
Generation Time: Jun 14, 2024 at 08:50 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `bos_ad_types` ORDER BY `def_option2` ASC LIMIT 0, 30;
Rows: 8
type_id | type_title | type_required | type_use | option1 | def_option1 | option2 | def_option2 | option3 | def_option3 | option4 | def_option4 | option5 | def_option5 | option6 | def_option6 | option7 | def_option7 | option8 | def_option8 | option9 | def_option9 | option10 | def_option10 | template |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22 | Artist Ad | 116249 | 124697 | state | 3|1|1|Texas | group name | 1||| | genre | 1||| | # members | 1||| | booking contact | 1||| | booking # | 1||| | <table width="100%" border="0" cellspacing="0" cel... | ||||||||
24 | Mariachis | 7705 | 7961 | state | 3|1|1|Texas | group name | 1||| | # members | 1||| | group gender | 4|2|2|all male|all female|mixed | <table width="100%" border="0" cellspacing="0" c... |
||||||||||||
25 | Halls | 5657 | 7961 | state | 3|1|1|Texas | contact# 1 | 1||| | contact #2 | 1||| | max capacity | 1||| | <table width="100%" border="0" cellspacing="0" cel... | ||||||||||||
20 | DJ Ad | 129049 | 523545 | state | 3|1|1|Texas | company name | 1||| | dj name(s) | 2||| | genre types | 2||| | genre specialties | 1||| | equip | 5|2|sound|lights | available area | 1||| | contact #1 | 1||| | contact #2 | 1||| | other comments | 2||| | <table width="100%" border="0" cellspacing="0"... |
23 | Clubs/Bars | 423449 | 524057 | state | 3|1|1|Texas| | cover charge | 1|||| | contact # | 1|||| | drink selection | 5|4||beer|draft|wine|liquor | food avail? | 4|2|2|yes|no | patio seating? | 4|2|2|yes|no | music | 5|5||piped|jukebox|karaoke|dj|band | other stuff | 5|2|pool|big screens | event mo | 3|12||jan|feb|mar|apr|may|jun|jul|aug|sep|oct|nov|... | event date | 1|||| | <table width="100%" border="0" cellspacing="0" cel... |
21 | Happy Hour Ad! | 249369 | 257817 | State | 3|1|1|Texas| | Cover Charge | 1|||| | Phone | 1|||| | Drinks Avail | 5|4||beer|draft|wine|liquor | Food Avail? | 4|2|2|yes|no | Patio Seating? | 4|2|2|yes|no | music | 5|5||piped|jukebox|karaoke|dj|band | other stuff | 5|2||pool|big screens | <table width="100%" border="0" cellspacing="0" cel... | ||||
12 | Fundraiser Ad | 3609 | 7961 | state | 3|1|1|Texas | beneficiary | 2||| | contact #1 | 1||| | contact #2 | 1||| | <table width="100%" border="0" cellspacing="0" c... |
||||||||||||
19 | Concert/Festival Ad | 32281 | 32537 | state | 3|1|1|Texas | ticket price | 2||| | headliner | 2||| | venue name | 1||| | seating | 4|3|2|indoor|outdoor|both | event month | 3|12||jan|feb|mar|apr|may|jun|jul|aug|sep|oct|nov|... | <table width="100%" border="0" cellspacing="0" cel... |