Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 25, 2024 at 08:24 PM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `pics` PROCEDURE ANALYSE();
Rows: 9
| Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
|---|---|---|---|---|---|---|---|---|---|
| puroparty.pics.month | 00 | 12 | 2 | 2 | 4 | 0 | 1.9892 | NULL | ENUM('','00','01','02','03','04','05','06','07','08','09','10','11','12') NOT NULL |
| puroparty.pics.day | 00 | sa | 2 | 2 | 4 | 0 | 1.9892 | NULL | ENUM('','00','01','02','03','04','05','06','07','08','09','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','sa') NOT NULL |
| puroparty.pics.year | 2002 | 2008 | 4 | 4 | 2 | 0 | 1999.1077 | 103.8676 | ENUM('0','2002','2003','2004','2005','2006','2007','2008') NOT NULL |
| puroparty.pics.link1 | <A \r\nHREF=javascript:popUp2('http://www.puroparty.us/shoots/2006/neighborhood/neighborhood_12_21_06/Album1.htm')><img src=http://www.puroparty.us/shoots/2006/neighborhood/neighborhood_12_21_06/Albums/Album1/Thumb/PC210006.jpg><br><font color=red><br>christmas party<br>the neighborhood bar<br>houston, tx<br>thu, dec 21, 2006</font></a> | <A HREF=javascript:popUp2(http://www.puroparty.us/shoots/2006/grammys/grammys_02_08_06/Album1.htm')><img src=http://www.puroparty.us/shoots/2006/grammys/grammys_02_08_06/Albums/Album1/Thumb/IMG_3412.jpg><br><font color=red><br>48th annual grammy awards<br>avizo, little joe, las tres divas<br>los angeles, ca<br>wed, feb 8, 2006</font></a> | 231 | 401 | 2 | 0 | 295.6581 | NULL | TEXT NOT NULL |
| puroparty.pics.entertainer | vital | 0 | 71 | 311 | 0 | 11.3190 | NULL | ENUM('','adalberto santaigo','adalberto, latin breed','agresivo','alazzan, los hermanos cortez, mariachi continental','alazzan, milagro','albert zamora','alicia villareal, fey, alek syntek, kumbia kings','alison nieves & nebula','ambixion, vital','angel y dorado','angelique','augustine ramirez','avanze','aventura','avizo','avizo, carlos maldonado y grupo fuerte, johnny bustamante','avizo, little joe, las tres divas','avizo, los hermanos cortez','avizo, sunny ozuna, adalberto, augustine ramirez, los hermanos cortez','ballet folklorico tuxtepec','bill clinton','bobby pulido','bronco, jennifer pena','cafe tacuba','cano estremera','carlos maldonado y grupo fuerte','carlos maldonado y grupo fuerte, alberto y ensueno','carlos maldonado y grupo fuerte, david lee garza y los musicales','carlos maldonado y grupo fuerte, fiel','carlos maldonado y grupo fuerte, los gavilanes de la cumbia','carlos mencia','celso torres','chelsea','chente barrera','complice, johnny & the heartbreakers, emilio navaira','conjunto complejo','danielle peck','david lee garza y los musicales','david lee garza y los musicales, la mafia','david lee garza y los musicales, avizo','david lee garza y los musicales, complice','david lee garza y los musicales, el charro negro','david lee garza y los musicales, ram herrera','david lee garza, avizo, tina y los gallitos','david marez','david marez, avizo','del castillo','dj luis, dj gen','duelo','eddie gonzalez','edward james olmos, myrka dellanos, bobby pulido','emilio navaira','emilio navaira, negami','emilio navaira, stampede','encuentro norteno, los gallitos','essencia','f7','fiel','fiel, carlos maldonado y grupo fuerte','fiel, invicto','fiel, leo y los dominatez','fito olivares','fito olivares, mensaje','gary hobbs','gary hobbs, little joe, jay perez, la sombra, shelly lares','gary hobbs, shelly lares, fiel, tina y los gallitos','gloria estefan, paulina rubio, pete astudillo, jay perez','grupo animo','grupo badd','grupo kache','grupo karizma','halloween','hillary','hometown boys','impozzible','impozzible and jp y sueno','impozzible, invicto','invicto','jaime y los chamacos','jaime y los chamacos, chente barrera, los texmaniacs','jaime y los chamacos, paula deanda, baby bash','jaime y los chamacos, shelly lares, mariachi meca','javier galvan y fama','javier galvan y fama, elida','jay perez','jay perez & chente barrera','jay perez, avizo, grupo caliente','jennifer pena','jesse serrata, bobby naranjo','jessy serrata','jessy serrata, cha cha jimenez','jimmy edward, bob gallarza','jimmy gonzalez','jimmy gonzalez, duelo','joe lopez','joe lopez, emilio navaira','joe lopez, jimmy gonzalez','johnny bustamante','johnny cruz, los hermanos cortez','jp y sueno, los hermanos cortez','julissa bermudez, frankie needles','k1','kosmic latte','kumbia kings, jimmy gonzalez','la conquista, la fuerza, sesi','la fiebre','la ley','la lupita','la mafia','la mafia, los palominos','la raza connection','la sombra, jay perez','la traizion','la tropa f','la tropa f, chente barrera, tina y los gallitos','la tropa f, la sombra','la tropa f, vida, marcos orozco','latin breed','latin express, avizo','laura canales, augustine ramirez, avizo','laura canales, johnny hernandez','lisa y aventura','little joe','little joe, carlos maldonado y grupo fuerte, negami','little joe, jaime y los chamacos, tina y los gallitos','little joe, roberto pulido, ruben ramos, stefani, javier galvan y fama','los cardenales','los desperadoz','los desperadoz, avizo','los desperadoz, invicto','los desperadoz, tina y los gallitos','los dos gilbertos','los garcia bros','los garcia bros, ruben ramos, dj kane','los gavilanes de la cumbia','los gavilanes de la cumbia, mensaje, grupo ligado','los hermanos cortez','los hermanos cortez cd release party','los hermanos cortez, conjunto cruz','los hermanos cortez, fiel, carlos maldonado y grupo fuerte','los hermanos cortez, los big katz, los monarcas','los hermanos cortez, los tejano boys, reflejo','los lobos','los lonely boys','los monarcas','los palominos','los tejano boys','los texmaniacs, aldo sierra','los top kats, los hermanos cortez, jaime y los chamacos','los tres acordiones, los big kats','maldita vecindad','mana','mando y la venganza','marcos orozco','marky lee','mary frometa','melanie','mensaje','michael salgado','mike robles, jeff garcia, juan villareal, felipe esparza','mingo saldivar','norma zenteno','paquito acosta jr','paquito guzman','pio trevino','play n skillz, f7','pression','ram herrera','ram herrera, marcos hernandez','ram herrera, negami, carlos maldonado y grupo fuerte','ramon ayala','ramon ayala, david lee garza y los musicales, emilio navaira, joe lopez','ramon ayala, invasores, jimena, poder, iman, explosion nortena','ramon ayala, jay perez, fiel','rapture','relampago, relicario','roberto pulido','roberto pulido, david lee garza y los musicales','ruben ramos','ruben ramos, chente barrera','ruben ramos, david marez, avizo','ruben ramos, johnny hernandez, tina y los gallitos','ruben ramos, shelly lares, adalberto','sambow','sangre latina','skylites','stampede & pression','stampede, f7','steve jordan','sunny ozuna','sunny ozuna, augustine ramirez, freddie martinez, carlos guzman, avizo','sunny ozuna, avizo','tejano boys','texas latino','thalia, india, ana barbara, pepe aguilar','tina y los gallitos','tj funk','troops-644th in iraq','victimas del dr. cerebro','vida','vital') NOT NULL | |
| puroparty.pics.eventname | 23rd annual festival chicano | ttma kickoff party | 3 | 50 | 306 | 0 | 11.6057 | NULL | ENUM('','23rd annual festival chicano','24th annual tejano music awards','25th annual chicano festival','3rd anniversary party','43rd anniversary of los aguilares','4th of july celebration','99 cent fridays','99 cent tejano fridays','99 cent thirstday','99 cent thirstdays','after party','after party headquarters','after party on the plaza','after-downtown party','after-jones plaza','after-party','after-party on the plaza','alex fuentes and buddies','backstage pre grand opening','bandido radio','bea\'s birthday','big bertha','big bertha y los amigos tent','bill for hillary','blackhawk cook-off','blackhawk cookoff','bnet radio fundraiser','bru-ja ha october fiesta','car show','cd release','celebs rally','chicano festival','christ the king church bazaar','christmas party','cinco de mayo celebration','cmas conference','cmas conference after-party','dj screwfest','dorantes\' 25th anniversary','downtown after party','DSCtejano roots hall of fame - class of 2006','east end festival','east end spring fiesta','east-end spring festival','el gran paro','fan fare','fan fare parties','festival','festival chicano','festival de la cosecha','festival latino','festival norteno','fiesta houston','fiesta houston 2005','fiesta san antonio','fort bend county bbq cook-off','frontier fiesta','fuerte cd release party','go tejano committee fashion show','go tejano day','go tejano fashion show','go tejano-thon','grammys','grand opening','grand-opening','halloween','hillary campaign 2008','hillary rally','hillary texas victory party','hispanic bbq championship of texas','Hispanic Cookoff','hls&r','hls&r bbq cook-off','hls&r cook-off','hls&r cook-off part','hls&r rodeo','hls&rbbq cookoff','holy name church bazaar','hot carribean nights','hot country nights','houston international festival','houston rodeo cookoff','houston texans tailgating','HPSO Mixer','immaculate heart church bazaar','jacinto city cook off','jacinto city cook-off','jacinto city cookoff','jacinto city cookoff friday','jacinto city cookoff saturday','jacinto city cookoff saturday part','jaime de anda benefit dance','jimmy and joe reunion','joe soto inauguration party','Joe Soto Victory Celebration','july tour','kc fall extravaganza','latino book festival','little joe\'s tejano blast','los gavilanes cd release party','los tres amigos concert','luz\'s b-day','mariachi contest','mariachi invitational','mary sue\'s b-day','mayor joe soto victory celebration','mean gene bash','memorial day celebration','mexican freedom fest','monico cortez benefit','ms. bea\'s birthday','national tejano music convention','nclr latino expo','new year\'s day','new year\'s eve bash','new years eve party','new\'s year eve','noche de pasion','orale crew','party on the patio','party on the plaza','party on the plaza pre-party','pasadena cook off','pasadena cook-off','pasadena cookoff','pasadena/cookoff','pc cookers casino trip','pc cookers pachanga','plsr cook-off','pop','pop after party','pop after-party','pop afterparty','pop plaza after-party','pop/rock en la plaza','pre-opening','private party w/ john cruz','psl&r after-party','puro chorizo cookers pachanga 3','puroparty tejano fridays','puroparty thirstdays reloaded','PuroParty.com Premier','que onda magazine 7th year anniversary','ram cd release & bd','rodeo cook-off','rodeo houston','roy meza\'s after-party','roy meza\'s downtown party','roy meza\'s party at','roy meza\'s party at gp','roy meza\'s summer series','salsa on the plaza','selena vive press conference','selena vive!','selena vive! after-party','sendoff party','signs on to a label','soho nites','southbelt cook-off','st. joseph church bazaar','st. joseph festival','strawberry festival','summer series after party','super bowl 38 - main event','tejano academy bowling tourney','tejano fan fair','tejano fridays','tejano mania','tejano music awards','tejano music awards fan fair','tejano music convention','tejano music national convention & las vegas revue','tejano roundup part','tejano thursdays','tejas records artist showcase','tejas records party','thanksgiving parade','the afterparty','the roof','the ultimate tejano party','tma fan fair','ttma kick-off party','ttma kickoff fan fair','ttma kickoff party') NOT NULL |
| puroparty.pics.venue | 610 arena | zazz | 4 | 32 | 24 | 0 | 14.9341 | NULL | ENUM('','610 arena','almeda mall','apollo club','arena theatre','astrodome','astroworld','azteca fairgrounds','backstage sports bar','bandido radio studio','baytown fairgrounds','bb wolf\'s','bea\'s island club','best times sports bar','blackhawk park','blanco ballroom','brazoria county fairgrounds','broadway billiards','cadillac bar','christ the king church','city streets','club 511','club 713','club desperado','club desperados','club hypnotiq','club olympus','club rodeaux','club zazz','cwa union hall','cynthia woods mitchell pavilion','delta downs casino','doghouse lounge','donerakis','downtown houston','el regio','elvia\'s cantina','emi\'s patio bar','emiliano\'s cantina','emiliano\'s sports bar','emilianos sports bar','escapade','fiesta ballroom','fish plaza','fort bend county fairgrounds','freedom world ranch','freeman coliseum','gabby\'s hall','george r brown convention center','gnl icehouse','graham central station','grand casino coushatta','grand hotel','guadalupe plaza','h & h icehouse','hallabaloos','hard rock cafe','havana bar','hcc se','hcc-se','hillary campaign hq','hillary hq','hilton hotel - las vegas','hilton hotel - hobby','hilton hotel - las vegas','hobby center','holy name church','homeplate','humble civic center','ibew hall','immaculate heart of mary church','iraq','jacinto city courthouse','jone plaza','jones plaza','julian\'s sports bar','kc hall - whitney oaks','kickapoo casino','kool city','la placita','la villita','las rosas','las rosas mexican restaurant','main street','malibu\'s','mama faye\'s','market square','mason park','meadowcreek lanes','memorial park','metropolis','miller outdoor theatre','morelos hall','ok corral','old galvi\'s','original neighborhood bar','palmer\'s ice house','palmer\'s icehouse','pasadena fairgrounds','pasadena town square','planeta rojo','r&r sports bar','red door','reliant center','reliant park','reliant stadium','rockefellers','rocky\'s club','rodeo disco','roy meza\'s beer garden','roy\'s on broadway','rumba club','sands restaurant','seven lounge','silver eagle ballroom','silverado saloon','sky bar','spjst lodge','st. joseph church','st. joseph\'s church','stafford center','staples center','sullivan\'s','tejano country','the drinking room','the warehouse','tjs bravo office','toc bar','tom bass park','u of h','university of houston','verizon wireless theater','wescott','westheimer street','zazz') NOT NULL |
| puroparty.pics.city | alice | vinton, la | 4 | 15 | 3 | 0 | 7.6312 | NULL | ENUM('','alice','alvin','angleton','austin','baytown','columbus, oh','corpus christi','eagle pass','el campo','houston','houston, tx','humble','iraq','jacinto city','kinder, la','laredo','las vegas','las vegas, nv','los angeles, ca','louisville, ky','pasadena','pearland','rosenberg','san antonio','seguin','south houston','stafford','texas city','the woodlands','vinton, la') NOT NULL |
| puroparty.pics.weekday | \r | wed | 1 | 9 | 4 | 0 | 3.7941 | NULL | ENUM('\r','','aug','feb\r','fri\r','fri','friday','mon\r','mon','sat\r','sat','saturday','sun\r','sun','thu\r','thu','thur\r','thur','thus\r','thus-sat\r','tue\r','tue','tues\r','tues','wed\r','wed') NOT NULL |