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

photopost_photos

Field Type Null Default
id  int(10) No   
user  varchar(50) No   
userid  int(8) No 
cat  int(11) No 
storeid  int(12) No 
storecat  int(12) No 
date  int(15) No 
title  varchar(75) Yes   
description  text Yes  NULL 
keywords  varchar(150) Yes  NULL 
bigimage  varchar(100) No   
width  smallint(6) Yes  NULL 
height  smallint(4) Yes  NULL 
filesize  int(10) Yes 
views  int(10) No 
medwidth  int(12) Yes 
medheight  smallint(6) Yes 
medsize  mediumint(9) Yes 
approved  tinyint(2) No 
lastpost  int(15) No 
rating  float(12,2) No  0.00 
watermarked  varchar(5) No  no 
allowprint  varchar(5) No  yes 
extra1  varchar(255) Yes  NULL 
extra2  varchar(255) Yes  NULL 
extra3  varchar(255) Yes  NULL 
extra4  varchar(255) Yes  NULL 
extra5  varchar(255) Yes  NULL 
extra6  varchar(255) Yes  NULL 
disporder  int(5) No  99999 
ipaddress  varchar(32) Yes 
numcom  int(8) No 
lastposter  varchar(255) Yes  NULL 
lastpid  int(8) No 
allowrate  int(1) No 
allowcoms  int(1) No 


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 5 id
id_2 UNIQUE 5 id
date_2 UNIQUE 5 date
bigimage_3 UNIQUE 5 bigimage
lastpost_2 UNIQUE 5 lastpost
title_2 UNIQUE None title
filesize_2 UNIQUE None filesize
lastposter_2 UNIQUE None lastposter
userid INDEX None userid
cat INDEX None cat
bigimage INDEX None bigimage
cat
id INDEX None id
user INDEX None user
userid_2 INDEX None userid
cat_2 INDEX None cat
storeid INDEX None storeid
storecat INDEX None storecat
date INDEX None date
title INDEX None title
keywords INDEX None keywords
bigimage_2 INDEX None bigimage
width INDEX None width
height INDEX None height
filesize INDEX None filesize
views INDEX None views
medwidth INDEX None medwidth
medheight INDEX None medheight
medsize INDEX None medsize
approved INDEX None approved
lastpost INDEX None lastpost
rating INDEX None rating
watermarked INDEX None watermarked
allowprint INDEX None allowprint
extra1 INDEX None extra1
extra2 INDEX None extra2
extra3 INDEX None extra3
extra4 INDEX None extra4
extra5 INDEX None extra5
extra6 INDEX None extra6
disporder INDEX None disporder
ipaddress INDEX None ipaddress
numcom INDEX None numcom
lastposter INDEX None lastposter
lastpid INDEX None lastpid
allowrate INDEX None allowrate
allowcoms INDEX None allowcoms
lastposter_4 INDEX None lastposter
lastpost_3 INDEX None lastpost
approved_2 INDEX None approved
user_2 INDEX None user
title_3 INDEX None title
description INDEX None description
keywords_2 INDEX None keywords
bigimage_4 INDEX None bigimage
watermarked_2 INDEX None watermarked
allowprint_2 INDEX None allowprint
extra1_2 INDEX None extra1
extra2_2 INDEX None extra2
extra3_2 INDEX None extra3
extra4_2 INDEX None extra4
extra5_2 INDEX None extra5
extra6_2 INDEX None extra6
ipaddress_2 INDEX None ipaddress
lastposter_3 INDEX None lastposter


 Space usage :
Type Usage
Data 628 Bytes
Index 4,096 Bytes
Total 4,724 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 5
Row length ø 125
Row size  ø 945 Bytes
Next Autoindex 6
Creation Oct 16, 2017 at 10:00 PM
Last update Oct 16, 2017 at 10:00 PM