Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: mega101mega101

mega101

Field Type Null Default
rank  int(2) No 
song  varchar(50) No   
playstw  char(3) No   
playslw  char(3) No   
video  varchar(200) No   
audio  longtext No   
lyrics  varchar(200) No   
label  varchar(50) No   
pic  varchar(50) No   


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 10 rank
rank_2 UNIQUE 10 rank
song_2 UNIQUE 10 song
playstw_2 UNIQUE 10 playstw
playslw_2 UNIQUE 10 playslw
pic_2 UNIQUE 10 pic
song_4 UNIQUE 10 song
playstw_3 UNIQUE 10 playstw
rank_3 UNIQUE 10 rank
pic_6 UNIQUE 10 pic
playslw_4 UNIQUE 10 playslw
rank_5 UNIQUE 10 rank
playstw_5 UNIQUE 10 playstw
pic_8 UNIQUE 10 pic
song_8 UNIQUE 10 song
playslw_6 UNIQUE 10 playslw
playslw_7 UNIQUE 10 playslw
lyrics_7 UNIQUE 10 lyrics
rank INDEX None rank
song INDEX None song
playstw INDEX None playstw
playslw INDEX None playslw
video INDEX None video
lyrics INDEX None lyrics
label INDEX None label
pic INDEX None pic
lyrics_3 INDEX None lyrics
video_3 INDEX None video
playslw_3 INDEX None playslw
playstw_4 INDEX None playstw
pic_5 INDEX None pic
label_4 INDEX None label
rank_4 INDEX None rank
song_6 INDEX None song
video_6 INDEX None video
label_5 INDEX None label
lyrics_6 INDEX None lyrics
pic_7 INDEX None pic
playstw_6 INDEX None playstw
playslw_5 INDEX None playslw
rank_6 INDEX None rank
song_9 INDEX None song
label_7 INDEX None label
video_8 INDEX None video
song_3 INDEX None song
video_2 INDEX None video
audio INDEX None audio
lyrics_2 INDEX None lyrics
label_2 INDEX None label
pic_3 INDEX None pic
lyrics_4 INDEX None lyrics
label_3 INDEX None label
pic_4 INDEX None pic
audio_2 INDEX None audio
song_5 INDEX None song
video_4 INDEX None video
lyrics_5 INDEX None lyrics
song_7 INDEX None song
video_5 INDEX None video
audio_3 INDEX None audio
pic_9 INDEX None pic
label_6 INDEX None label
video_7 INDEX None video
song_10 INDEX None song


 Space usage :
Type Usage
Data 1,424 Bytes
Index 3,072 Bytes
Total 4,496 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 10
Row length ø 142
Row size  ø 450 Bytes
Creation Feb 24, 2018 at 01:57 PM
Last update Mar 30, 2018 at 05:12 PM
Last check Apr 04, 2018 at 05:11 PM