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

artists

Field Type Null Default
id  int(11) No   
name  varchar(100) No   
photo  varchar(100) No   
photo2  varchar(100) No   
photo3  varchar(100) No   
bio  text No   
message  text No   
ad  text No   
player  text No   
folder  varchar(20) No   
cd1pic  varchar(100) No   
cd1name  varchar(100) No   
cd2pic  varchar(100) No   
cd2name  varchar(100) No   
cd3pic  varchar(100) No   
cd3name  varchar(100) No   
cd4pic  varchar(100) No   
cd4name  varchar(100) No   
lyrics  text No   
thumbnail  varchar(100) No   


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 6 id
id_3 UNIQUE 6 id
name_2 UNIQUE 6 name
photo_2 UNIQUE 6 photo
photo2_2 UNIQUE 6 photo2
photo3_2 UNIQUE 6 photo3
folder_2 UNIQUE 6 folder
thumbnail_2 UNIQUE 6 thumbnail
thumbnail_6 UNIQUE 6 thumbnail
id_5 UNIQUE 6 id
name_5 UNIQUE 6 name
photo_5 UNIQUE 6 photo
photo2_5 UNIQUE 6 photo2
id INDEX None id
id_2 INDEX None id
name INDEX None name
photo INDEX None photo
photo2 INDEX None photo2
photo3 INDEX None photo3
folder INDEX None folder
cd1pic INDEX None cd1pic
cd1name INDEX None cd1name
cd2pic INDEX None cd2pic
cd2name INDEX None cd2name
cd3pic INDEX None cd3pic
cd3name INDEX None cd3name
cd4pic INDEX None cd4pic
cd4name INDEX None cd4name
thumbnail INDEX None thumbnail
cd3name_3 INDEX None cd3name
thumbnail_4 INDEX None thumbnail
cd4pic_3 INDEX None cd4pic
cd4name_4 INDEX None cd4name
id_4 INDEX None id
name_4 INDEX None name
photo_4 INDEX None photo
photo2_4 INDEX None photo2
name_3 INDEX None name
photo_3 INDEX None photo
photo2_3 INDEX None photo2
photo3_3 INDEX None photo3
bio INDEX None bio
message INDEX None message
ad INDEX None ad
player INDEX None player
folder_3 INDEX None folder
cd1pic_2 INDEX None cd1pic
cd1name_2 INDEX None cd1name
cd2pic_2 INDEX None cd2pic
cd2name_2 INDEX None cd2name
cd3pic_2 INDEX None cd3pic
cd3name_2 INDEX None cd3name
cd4pic_2 INDEX None cd4pic
cd4name_2 INDEX None cd4name
lyrics INDEX None lyrics
thumbnail_3 INDEX None thumbnail
cd3name_4 INDEX None cd3name
thumbnail_5 INDEX None thumbnail
cd4pic_4 INDEX None cd4pic
cd4name_3 INDEX None cd4name
lyrics_2 INDEX None lyrics
name_6 INDEX None name
photo_6 INDEX None photo
photo2_6 INDEX None photo2


 Space usage :
Type Usage
Data 31,504 Bytes
Index 4,096 Bytes
Total 35,600 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 6
Row length ø 5,250
Row size  ø 5,933 Bytes
Next Autoindex 7
Creation Nov 12, 2017 at 04:41 AM
Last update Jun 20, 2018 at 07:51 PM
Last check Jun 21, 2018 at 08:42 AM