Host: mysql.puroparty.com
Database: puroparty
Generation Time: May 15, 2024 at 12:35 PM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `mega101` 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.mega101.rank | 1 | 10 | 1 | 2 | 0 | 0 | 5.5000 | 2.8723 | ENUM('1','2','3','4','5','6','7','8','9','10') NOT NULL |
puroparty.mega101.song | Angel y Khriz - Ven Bailalo | Xtreme - Te Extrano | 12 | 46 | 0 | 0 | 28.3000 | NULL | ENUM('Angel y Khriz - Ven Bailalo','Aventura & Don Omar - Ella y Yo','Chris Brown f/Juelz Santana - Run It','Daddy Yankee - Rompe','Kumbia Kings - Na Na Na (Dulce Nina)','Luny Tunes f/Wisin & Yandel - Rakata','Ricky Martin f/Fat Joe & Amerie - I Don\'t Care','Shakira - No','T-Pain - I\'m Sprung','Xtreme - Te Extrano') NOT NULL |
puroparty.mega101.playstw | 37 | 66 | 2 | 2 | 0 | 0 | 2.0000 | NULL | ENUM('37','38','44','46','47','50','59','62','63','66') NOT NULL |
puroparty.mega101.playslw | 25 | 74 | 2 | 2 | 0 | 0 | 2.0000 | NULL | ENUM('25','31','36','44','60','61','64','70','73','74') NOT NULL |
puroparty.mega101.video | 0 | 0 | 10 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.mega101.audio | <OBJECT classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"\r\n codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,47,0"\r\n WIDTH="40" HEIGHT="40" id="wimpy_button_1">\r\n <PARAM NAME=movie VALUE="wimpy_button.swf?theFile=example2.mp3">\r\n <PARAM NAME=quality VALUE=high>\r\n <PARAM NAME=bgcolor VALUE=#006666>\r\n <EMBED src="wimpy_button.swf?theFile=example2.mp3" quality=high bgcolor=#006666 WIDTH="40" HEIGHT="40" NAME="wimpy_button_1"\r\n TYPE="application/x-shockwave-flash" PLUGINSPAGE="http://www.macromedia.com/go/getflashplayer"></EMBED>\r\n</OBJECT> | 0 | 587 | 9 | 0 | 58.7000 | NULL | ENUM('','<OBJECT classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"\r\n codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,47,0"\r\n WIDTH="40" HEIGHT="40" id="wimpy_button_1">\r\n <PARAM NAME=movie VALUE="wimpy_button.swf?theFile=example2.mp3">\r\n <PARAM NAME=quality VALUE=high>\r\n <PARAM NAME=bgcolor VALUE=#006666>\r\n <EMBED src="wimpy_button.swf?theFile=example2.mp3" quality=high bgcolor=#006666 WIDTH="40" HEIGHT="40" NAME="wimpy_button_1"\r\n TYPE="application/x-shockwave-flash" PLUGINSPAGE="http://www.macromedia.com/go/getflashplayer"></EMBED>\r\n</OBJECT>') NOT NULL | |
puroparty.mega101.lyrics | - | <a href=http://www.puroparty.com/lyricdetail.php?id=571 target=blank>Lyrics</a> | 1 | 79 | 0 | 0 | 8.8000 | NULL | ENUM('-','<a href=http://www.puroparty.com/lyricdetail.php?id=571 target=blank>Lyrics</a>') NOT NULL |
puroparty.mega101.label | Columbia | SGZ | 3 | 22 | 0 | 0 | 13.0000 | NULL | ENUM('Columbia','El Cartel/Interscope','EMI Latin','Epic','Jive/Zomba Label Group','Mas Flow/Universal','MVP/Machete Music','Premium','SGZ') NOT NULL |
puroparty.mega101.pic | angelykhriz.jpg | xtreme.jpg | 9 | 15 | 0 | 0 | 12.9000 | NULL | ENUM('angelykhriz.jpg','aventura.jpg','chrisbrown.jpg','daddyyankee.jpg','kumbiakings.jpg','lunytunes.jpg','rickymartin.jpg','shakira.jpg','tpain.jpg','xtreme.jpg') NOT NULL |