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

photopost_comments

Field Type Null Default
id  int(11) No   
username  varchar(32) No   
userid  int(11) No 
date  int(15) No 
rating  float(12,2) Yes  NULL 
comment  text No   
photo  int(11) No 
cat  int(11) No 
approved  int(2) No 
ipaddress  varchar(32) Yes 


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 0 id
id_2 UNIQUE 0 id
username_2 UNIQUE 0 username
userid_2 UNIQUE 0 userid
date_2 UNIQUE 0 date
photo_3 UNIQUE 0 photo
cat_3 UNIQUE 0 cat
approved_2 UNIQUE 0 approved
date_3 UNIQUE 0 date
username_5 UNIQUE 0 username
userid_3 UNIQUE 0 userid
cat_4 UNIQUE 0 cat
approved_3 UNIQUE 0 approved
photo_4 UNIQUE 0 photo
id_3 UNIQUE 0 id
id_5 UNIQUE 0 id
approved_6 UNIQUE 0 approved
date_5 UNIQUE 0 date
photo_6 UNIQUE 0 photo
userid_6 UNIQUE 0 userid
cat_7 UNIQUE 0 cat
username_9 UNIQUE 0 username
rating_2 UNIQUE None rating
ipaddress_2 UNIQUE None ipaddress
rating_3 UNIQUE None rating
ipaddress_5 UNIQUE None ipaddress
rating_5 UNIQUE None rating
ipaddress_8 UNIQUE None ipaddress
photo INDEX None photo
cat INDEX None cat
id INDEX None id
username INDEX None username
userid INDEX None userid
date INDEX None date
rating INDEX None rating
photo_2 INDEX None photo
cat_2 INDEX None cat
approved INDEX None approved
ipaddress INDEX None ipaddress
rating_4 INDEX None rating
username_6 INDEX None username
date_4 INDEX None date
ipaddress_4 INDEX None ipaddress
cat_5 INDEX None cat
photo_5 INDEX None photo
userid_4 INDEX None userid
id_4 INDEX None id
approved_4 INDEX None approved
approved_5 INDEX None approved
userid_5 INDEX None userid
ipaddress_7 INDEX None ipaddress
date_6 INDEX None date
cat_6 INDEX None cat
username_8 INDEX None username
photo_7 INDEX None photo
rating_6 INDEX None rating
id_6 INDEX None id
username_3 INDEX None username
comment INDEX None comment
ipaddress_3 INDEX None ipaddress
username_4 INDEX None username
ipaddress_6 INDEX None ipaddress
comment_2 INDEX None comment
username_7 INDEX None username


 Space usage :
Type Usage
Data 0 Bytes
Index 3,072 Bytes
Total 3,072 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 0
Next Autoindex 1
Creation Jan 19, 2018 at 10:37 PM
Last update Jan 19, 2018 at 10:37 PM