Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 26, 2024 at 11:29 PM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `extcal_events` PROCEDURE ANALYSE();
Rows: 22
| Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
|---|---|---|---|---|---|---|---|---|---|
| puroparty.extcal_events.id | 4 | 127 | 1 | 3 | 0 | 0 | 65.9421 | 35.0547 | TINYINT(3) UNSIGNED NOT NULL |
| puroparty.extcal_events.title | 15th Annual Go Tejano Committee Mariachi Invitational | Walkout | 4 | 81 | 0 | 0 | 23.5868 | NULL | ENUM('15th Annual Go Tejano Committee Mariachi Invitational','2006 MS LATINA/TEEN LATINA UNITED STATES PAGEANTS','23rd Ann Go Tejano Committe\'s Scholarship Dance','25th annual tejano conjunto festival','Annual Fish Fry','Austin High Class of \'96 Fundraiser','Avizo Grammy Sendoff Party','BBQ Benefit','BBQ Benefit for Isidor Meza, Sr.','BIRTHDAY PARTY !','borderfest 2006 - carnaval','Buffalo Fred\'s BBQ Cook-Off','Carlos Mencia','charro days baile ranchero','charro days saturday nite dance','Chicano-Latino Empowerment through the Arts','Club Desperado Grand Opening!','College Wednesdays','David Lee Garza','David Marez','Emilio Navaira','En Vivo Los Big Kats','FESTIVAL DE LA COSECHA','Fiesta Fridays','Fiesta in San Antonio','Film "Walk Out"','Fish Fry','FORT BEND COUNTY FAIRGROUND COOKOFF','Gary Hobbs at Cook-off','Go Tejano Annual Scholarship Dance w/ David Lee & Despoz','Go Tejano Committee 15th Annual Mariachi Invitational','Go Tejano Committee Fashion Show and Dance','Go Tejano Committee Mariachi Invitational','Grupo Solido','Hallabaloo','HALLABALOOS','Hispanic BBQ Championship of Texas','HLS&R Cook-off','Hometown Boys at Cook-off','Impozzible, John Cruz, Los Monarcas, & Boni Mauricio','Jacinto City Cook-Off','jalapeno festival','JAY PEREZ "LIVE"','Jiame Y Los Chamacos','Joe Lopez Valentine\'s Day','John Cruz','Juanes','Ladies Night','Latin Breed','latinos represent who dey is!','Leo y Los Dominantez','Liberty Band\'s 1st Annual Black & White Ball','Los Aguilares 46th Anniversary Dance','Los Big Chihuahuas at Despo','LOS DOS GILBERTOS','Los Gallos / Volatil CD Release','Los Garcia Brothers','Los Hermanos Cortez','Los MONARCAS at the American Legion in Wharton, TX','MAK\'S ICEHOUSE','Mardi Gras Galveston','maria williams salsa band','Memorial Weekend Superfest','Menudo & Tripa Cookoff','MILBY HISPANIC ALUMNI ASSOCIATION "OCTOBER "FEAST" & MATINEE DANCE','My Birthday','Neighborhood X-Mas Party','P.O.P. Pre-Party!!!!','party on the plaza','Party on the Plaza Begins!','pasadena strawberry festival','PCC 1st Anniversary Pachanga','Pio Trevino, Festivo','PLML FanFair','PLS&R BBQ COOKOFF','Puro Chicanisimo Tejanismo Night','Ramon Ayala @HLSR','Ricardo Arjona','Ricardo Aronja','Rick Trevino at Cook-off','Ricky Martin','Ruben Ramos','Ruben\'s Ice House','Sonora Carruseles & MC Magic at POP','Sunny Sauceda & Festivo at BIC','Super Saturdays','SuperBowl Sunday w/ Impozzible & Boni','Tejano Dance-Grupo Excito','Tejano Dance-Los Hermanos Cortez','Tejano Fridays','Tejano Music Awards','TEJANO SATURDAYS','Tejano Tuesdays','Test','The BIG THIRSTDAY Party','The Hometown Boys','Thirstdays Reloaded at BIC','Tripa & Menudo Cookoff','TTMA Fanfair','TTMA Kick-Off','Viva Vegas','Walkout') NOT NULL |
| puroparty.extcal_events.description | " A Night of Legends"\r\nFreddy Martinez, Agustin Ramirez, Sunny Ozuna, Carlos Guzman, y Los Aguilares\r\n\r\nAlso featuring: Mario Montez "La Voz de Romance"\r\ny Grupo Sierra\r\n\r\nRiverside Hall\r\nEast Bernard, TX | • Events 1:00-4:30 pm\r\n• Sammy Kershaw 4:30-6:00 pm\r\n• Jalapeño Eating Contest 6:00-6:30 pm\r\n• Mariachi Contest Winners/Grito Contest 6:30-7:30 pm\r\n• Los Peppers 7:00-8:00 pm\r\n• Jimmy Gonzalez 8:30-9:30 pm\r\n• Costumbre 10:00-11:00 pm\r\n• Solido 11:00 pm-1:00 am\r\n | 4 | 720 | 0 | 0 | 180.2810 | NULL | TEXT NOT NULL |
| puroparty.extcal_events.contact | www.PCCookers.com | 0 | 156 | 67 | 0 | 20.2149 | NULL | ENUM('','(210) 271-3151','(210) 674-5507 or (210) 204-9107','(956) 843-2302 or 843-2286\r\n','281-642-4587','713-692-1935','713-943-1400\r\nWWW.HALLABALOOS.COM','956-542-4245','AMERICA GAMARRA\r\n321-443-3131','AMERICA GAMARRA 321-443-3131','American Legion, 221 W. Park St., Wharton, TX 77488','Bea\'s IC 713-944-2720','Bea\'s Island Club 713-944-2720','Becky Hernandez\r\n832-654-6751','Call Danny Tijerina, Jalapeño Festival President, at 337-6511 for more information or for schedule changes.','Easy or Helen Meza\r\nMeza\'s Courtyard\r\n3517 Navigation Blvd\r\n713.224.MEZA (6392)','Eliza Deleon: 713.645.0763 or \r\nRobert Moreno: 713.644.6963/713.825.6424','For more info, \r\ncontact Miguel Aguilar @ (210)393-7814','For more information and or you may be interested in entering your cooking team please feel free to contact Sylvia or Anna @ 713-910-3004, or 281-788-5162. ','For more information visit www.PCCookers.com or call 713-820-3616','For more information you may contact Sylvia or Anna at 713-910-3004 or 281-788-5162.','For more information, contact Miguel Aguilar @ (210)393-7814','Frank D Flores 832-434-3395','Get your tickets at Ticketmaster','Hector Martinez - 832-250-7325\r\nTravis Lemos - 832-875-6655','Isidor or Helen Meza\r\n713.224.6392\r\n','Joe L Hernandez 281.686.3556','Joe L. Hernandez 281-686-3556','Joe L. Hernandez @ 281.686.3556','Lorenzo Cano\r\n713 743-3133','Lorenzo Cano\r\nAssociate Director\r\nUniversity of Houston\r\nCenter for Mexican American Studies\r\n713 743-3136','MAK\'S \r\n\r\n4017 MC KINNEY ST \r\n\r\n713-227-5405','MAK\'S \r\n4017 MC KINNEY ST \r\nHOUSTON TX\r\n\r\n713-227-5405 ','MAK\'S ICEHOUSE \r\n\r\n4017 MC KINNEY ST\r\n\r\n713-227-5405','mariawilliams 713.661.1609','Max Rios \r\n(713)206-4353','Meza\'s Courtyard\r\nContact: Easy Meza\r\n3517 Navigation Blvd.\r\nHouston, Texas 77003\r\n713.224.6392','Miguel Aguilar \r\n(210) 393-7814\r\n\r\nJR Ramos\r\n(832)519-3434','More info at www.PCCookers.com or call 713-820-3616 or 281-642-4587','PARTIES@HALLABALOOS.COM','Phone: (281) 991-9500','Ruben\'s Ice House\r\n1606 Ahresns ','Tejano Roots 361-701-6028','University of Houston\r\nCenter for Mexican American Studies\r\nLorenzo Cano\r\nAssociate Director\r\n713 743-3136\r\n\r\n','www.lasvegascalienteusa.com','www.PCCookers.com') NOT NULL | |
| puroparty.extcal_events.url | www.wbcalaredo.org/index.html | 0 | 100 | 81 | 0 | 8.9421 | NULL | ENUM('','beasislandclub.com','milbyhispanic.org','mslatinaunitedstates.com','puroparty.com/desperado','www.beasislandclub.com','www.borderfest.org','www.charrodaysfiesta.com/','www.class.uh.edu','www.class.uh.edu/cmas','WWW.FBCFA.ORG','www.guadalupeculturalarts.org','WWW.HALLABALOOS.COM','www.losgallos@losgallosmusic.com','www.makeminetexas.info','www.makemnetexas.info','www.mezacourtyard.4t.com','WWW.MSLATINAUNITEDSTATES.COM','www.pccookers.com','www.popdowntown.com','www.puroparty.com/beas','www.puroparty.com/desperado','www.puroparty.com/flyers/pcc.jpg','www.rodeohouston.com','www.strawberryfest.org/index.html','www.tejanorootshalloffame.org/','www.ticketmaster.com/event/0C003B7EEB4ACD93?cce_tid=7257327781E5E334C3D5D25652C3D46757E58C&brand=pac','www.ticketmaster.com/event/0C003B8DC63D6302?cce_tid=1E5FD29946E6A196C64627476179317D5856&brand=pace','www.wbcalaredo.org/index.html') NOT NULL | |
| puroparty.extcal_events.email | www.roymezas.com | 0 | 38 | 78 | 0 | 8.0826 | NULL | ENUM('','adeleon7@sbcglobal.net','annbenavidez@sbcglobal.net','bert@strawberryfest.org','bobby@libertyband-sa.com','fdflores@hotmail.com','GONE','GONEFISHINGKATY@YAHOO.COM','hmartinez@gordonsonline.com','info@makeminetexas.info','joelaw53@sbcglobal.net','jrramos82@aol.com','lca','lcano@mail.uh.edu','llongoria9@houston.rr.com','losgallos@losgallosmusic.com','louielouie@pccookers.com','mariawilliamsband@sbcglobal.net','mezacourtyard@yahoo.com','mslatinaunitedstatespageants@yahoo.com','PARTIES@HALLABALOOS.COM','popdowntown@gmail.com','rehernazdez@deloitte','rosi@fun-folks-unlimited.com','www.roymezas.com') NOT NULL | |
| puroparty.extcal_events.picture | f607_charrodays.jpg | 0 | 24 | 113 | 0 | 1.3140 | NULL | ENUM('','028a_charrodays.jpg','2dfb_conjuntoposter.jpg','3010_jalapenofest.jpg','6d4c_arjona.jpg','8910_arjona.jpg','ad9d_i98264367_34419.jpg','e1b2_strawberryfest.jpg','f607_charrodays.jpg') NOT NULL | |
| puroparty.extcal_events.cat | 1 | 7 | 1 | 1 | 0 | 0 | 2.4298 | 1.1701 | ENUM('1','2','3','4','5','7') NOT NULL |
| puroparty.extcal_events.day | 1 | 30 | 1 | 2 | 0 | 0 | 15.6281 | 8.0352 | ENUM('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','17','18','19','20','21','22','23','24','25','26','27','28','29','30') NOT NULL |
| puroparty.extcal_events.month | 1 | 12 | 1 | 2 | 0 | 0 | 4.5372 | 3.4186 | ENUM('1','2','3','4','5','6','7','8','9','10','11','12') NOT NULL |
| puroparty.extcal_events.year | 2006 | 2007 | 4 | 4 | 0 | 0 | 2006.0083 | 0.0905 | ENUM('2006','2007') NOT NULL |
| puroparty.extcal_events.approved | 1 | 1 | 1 | 1 | 46 | 0 | 0.6198 | 0.4854 | ENUM('0','1') NOT NULL |
| puroparty.extcal_events.start_date | 2006-01-05 08:00:00 | 2007-02-03 18:30:00 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('2006-01-05 08:00:00','2006-01-06 08:00:00','2006-01-06 20:00:00','2006-01-07 11:00:00','2006-01-07 20:00:00','2006-01-08 20:00:00','2006-01-10 08:00:00','2006-01-11 20:00:00','2006-01-12 08:00:00','2006-01-12 20:00:00','2006-01-13 08:00:00','2006-01-14 08:00:00','2006-01-18 20:00:00','2006-01-19 08:00:00','2006-01-19 20:00:00','2006-01-20 08:00:00','2006-01-20 16:00:00','2006-01-22 08:00:00','2006-01-27 08:00:00','2006-01-28 08:00:00','2006-01-28 19:30:00','2006-01-29 08:00:00','2006-02-04 08:00:00','2006-02-04 18:30:00','2006-02-05 08:00:00','2006-02-11 08:00:00','2006-02-12 08:00:00','2006-02-14 08:00:00','2006-02-16 20:00:00','2006-02-17 16:00:00','2006-02-18 13:00:00','2006-02-23 08:00:00','2006-02-24 08:00:00','2006-02-24 16:00:00','2006-02-24 21:00:00','2006-02-25 08:00:00','2006-02-25 21:00:00','2006-03-02 10:00:00','2006-03-10 08:00:00','2006-03-10 13:00:00','2006-03-11 18:00:00','2006-03-12 07:00:00','2006-03-12 13:00:00','2006-03-14 20:00:00','2006-03-18 11:00:00','2006-03-21 20:00:00','2006-03-23 13:30:00','2006-04-13 08:00:00','2006-04-13 19:00:00','2006-04-14 11:00:00','2006-04-19 08:00:00','2006-04-20 08:00:00','2006-04-22 06:00:00','2006-04-22 08:00:00','2006-05-01 07:00:00','2006-05-09 08:00:00','2006-05-10 12:00:00','2006-05-19 10:00:00','2006-06-01 08:30:00','2006-06-02 08:00:00','2006-06-03 08:00:00','2006-06-03 20:00:00','2006-06-09 19:00:00','2006-06-13 17:00:00','2006-06-24 21:00:00','2006-06-25 13:00:00','2006-06-25 14:00:00','2006-07-22 20:00:00','2006-08-04 20:00:00','2006-08-05 08:00:00','2006-08-07 08:00:00','2006-08-11 08:00:00','2006-08-11 20:00:00','2006-08-12 20:00:00','2006-08-13 08:00:00','2006-08-18 20:00:00','2006-08-19 08:00:00','2006-08-26 11:00:00','2006-08-26 20:00:00','2006-09-08 08:00:00','2006-09-15 20:00:00','2006-09-23 21:00:00','2006-09-29 20:00:00','2006-09-30 20:00:00','2006-10-05 20:00:00','2006-10-28 10:00:00','2006-10-29 12:00:00','2006-11-11 19:00:00','2006-11-12 17:00:00','2006-11-13 08:00:00','2006-11-17 19:00:00','2006-12-09 20:00:00','2006-12-21 08:00:00','2006-12-30 08:00:00','2006-12-30 20:00:00','2007-02-03 18:30:00') NOT NULL |
| puroparty.extcal_events.end_date | 2006-01-05 23:59:59 | 2007-02-03 23:59:59 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('2006-01-05 23:59:59','2006-01-06 23:59:59','2006-01-07 23:59:59','2006-01-08 23:59:59','2006-01-10 23:59:59','2006-01-11 23:59:59','2006-01-12 23:59:59','2006-01-13 23:59:59','2006-01-14 23:59:59','2006-01-18 23:59:59','2006-01-19 23:59:59','2006-01-20 23:59:59','2006-01-21 23:59:59','2006-01-22 23:59:59','2006-01-27 23:59:59','2006-01-28 23:59:59','2006-01-29 23:59:59','2006-02-04 23:59:59','2006-02-05 23:59:59','2006-02-11 23:59:59','2006-02-12 23:59:59','2006-02-14 23:59:59','2006-02-16 23:59:59','2006-02-18 23:59:59','2006-02-23 23:59:59','2006-02-24 23:59:59','2006-02-25 23:59:59','2006-03-05 23:59:59','2006-03-10 23:59:59','2006-03-11 22:00:00','2006-03-11 23:59:59','2006-03-12 23:59:59','2006-03-15 01:00:00','2006-03-18 23:59:59','2006-03-22 01:00:00','2006-03-24 14:30:00','2006-03-24 16:30:00','2006-04-13 22:00:00','2006-04-14 23:59:59','2006-04-15 16:00:00','2006-04-19 23:59:59','2006-04-20 23:59:59','2006-04-22 23:59:59','2006-05-03 07:00:00','2006-05-12 23:59:59','2006-05-21 23:59:59','2006-05-28 23:59:59','2006-06-03 23:59:59','2006-06-05 23:59:59','2006-06-10 23:00:00','2006-06-13 22:00:00','2006-06-24 23:59:59','2006-06-25 23:59:59','2006-07-22 23:59:59','2006-08-04 23:59:59','2006-08-05 23:59:59','2006-08-07 23:59:59','2006-08-11 23:59:59','2006-08-12 01:00:00','2006-08-12 23:59:59','2006-08-13 23:59:59','2006-08-18 23:59:59','2006-08-19 23:59:59','2006-08-26 23:59:59','2006-09-08 23:59:59','2006-09-15 23:59:59','2006-09-23 23:59:59','2006-09-29 23:59:59','2006-09-30 23:59:59','2006-10-07 23:59:59','2006-10-28 23:59:59','2006-10-29 23:59:59','2006-11-11 23:59:59','2006-11-12 23:59:59','2006-11-13 23:59:59','2006-11-17 23:59:59','2006-11-19 23:59:59','2006-12-09 23:59:59','2006-12-21 23:59:59','2006-12-30 23:59:59','2007-02-03 23:59:59') NOT NULL |
| puroparty.extcal_events.recur_type | year | 0 | 4 | 111 | 0 | 0.3223 | NULL | ENUM('','day','week','year') NOT NULL | |
| puroparty.extcal_events.recur_val | 0 | 1 | 1 | 1 | 111 | 0 | 0.0826 | 0.2753 | ENUM('0','1') NOT NULL |
| puroparty.extcal_events.recur_end_type | 0 | 2 | 1 | 1 | 112 | 0 | 0.1322 | 0.4801 | ENUM('0','1','2') NOT NULL |
| puroparty.extcal_events.recur_count | 1 | 10 | 1 | 2 | 0 | 0 | 1.0826 | 0.8191 | ENUM('1','2','10') NOT NULL |
| puroparty.extcal_events.recur_until | 2006-01-04 | 2007-06-26 | 10 | 10 | 0 | 0 | 10.0000 | NULL | ENUM('2006-01-04','2006-01-05','2006-01-06','2006-01-07','2006-01-08','2006-01-12','2006-01-13','2006-01-14','2006-01-19','2006-01-20','2006-01-21','2006-01-22','2006-01-27','2006-01-28','2006-01-29','2006-02-03','2006-02-04','2006-02-05','2006-02-11','2006-02-12','2006-02-14','2006-02-15','2006-02-17','2006-02-22','2006-02-23','2006-02-24','2006-02-25','2006-03-03','2006-03-06','2006-03-08','2006-03-09','2006-03-14','2006-03-21','2006-03-23','2006-03-28','2006-03-29','2006-03-31','2006-04-05','2006-04-13','2006-04-19','2006-04-20','2006-04-22','2006-05-01','2006-05-22','2006-05-24','2006-05-28','2006-05-30','2006-06-13','2006-07-22','2006-08-01','2006-08-05','2006-08-11','2006-08-12','2006-08-13','2006-08-18','2006-08-19','2006-08-25','2006-08-26','2006-09-08','2006-09-21','2006-09-27','2006-09-29','2006-09-30','2006-10-03','2006-10-16','2006-11-09','2006-11-10','2006-11-13','2006-11-24','2006-12-09','2006-12-21','2006-12-30','2007-02-03','2007-06-26') NOT NULL |
| puroparty.extcal_events.user_id | 0 | 0 | 1 | 1 | 121 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
| puroparty.extcal_events.group_id | 0 | 0 | 1 | 1 | 121 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
| puroparty.extcal_events.showevent | 3 | 3 | 1 | 1 | 0 | 0 | 1.0000 | NULL | ENUM('3') NOT NULL |