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

photopost_categories

Field Type Null Default
id  int(12) No   
catname  varchar(255) No   
description  varchar(255) Yes  NULL 
catorder  mediumint(4) No  9999 
thumbs  varchar(4) No  yes 
parent  int(5) No 
header  varchar(200) Yes  NULL 
footer  varchar(200) Yes  NULL 
headtags  varchar(200) Yes  NULL 
private  varchar(5) No  no 
ugnoview  varchar(255) Yes  NULL 
ugnoupload  varchar(255) Yes  NULL 
ugnopost  varchar(255) Yes  NULL 
ugnovote  varchar(255) Yes  NULL 
ugnoanno  varchar(255) Yes  NULL 
children  text Yes  NULL 
albums  text Yes  NULL 
subalbum  int(12) No 
lastpost  int(11) Yes  NULL 
lastphoto  int(11) Yes  NULL 
photos  int(11) Yes 
posts  int(11) Yes 
password  varchar(24) Yes  NULL 
cattype  varchar(4) No 
theme  varchar(32) Yes  NULL 
thumbtype  int(2) Yes 
catdepth  varchar(6) Yes  NULL 
watermark  varchar(250) No   
sortorder  int(2) No 
extra1  varchar(250) Yes  NULL 
extra2  varchar(250) Yes  NULL 
extra3  varchar(250) Yes  NULL 
extra4  varchar(250) Yes  NULL 
extra5  varchar(250) Yes  NULL 
extra6  varchar(250) Yes  NULL 
thumbnail  int(15) No 
maximages  int(12) No 
canzip  char(3) No  no 
frames  varchar(32) No 
intro  char(3) No  no 
introtitle  varchar(128) Yes  NULL 
introcopy  text Yes  NULL 
moderators  text Yes  NULL 
numextra  int(3) No 
ratingtype  int(1) No 
takevotes  int(1) No 
ismember  smallint(1) No 


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 3 id
id_2 UNIQUE 3 id
catname_2 UNIQUE 3 catname
sortorder_2 UNIQUE 3 sortorder
description_2 UNIQUE None description
header_2 UNIQUE None header
footer_2 UNIQUE None footer
headtags_2 UNIQUE None headtags
ugnoview_2 UNIQUE None ugnoview
ugnoupload_2 UNIQUE None ugnoupload
ugnopost_2 UNIQUE None ugnopost
ugnovote_2 UNIQUE None ugnovote
ugnoanno_2 UNIQUE None ugnoanno
photos_2 UNIQUE None photos
password_2 UNIQUE None password
theme_2 UNIQUE None theme
catdepth_2 UNIQUE None catdepth
parent INDEX None parent
id INDEX None id
catname INDEX None catname
description INDEX None description
catorder INDEX None catorder
thumbs INDEX None thumbs
parent_2 INDEX None parent
header INDEX None header
footer INDEX None footer
headtags INDEX None headtags
private INDEX None private
ugnoview INDEX None ugnoview
ugnoupload INDEX None ugnoupload
ugnopost INDEX None ugnopost
ugnovote INDEX None ugnovote
ugnoanno INDEX None ugnoanno
subalbum INDEX None subalbum
lastpost INDEX None lastpost
lastphoto INDEX None lastphoto
photos INDEX None photos
posts INDEX None posts
password INDEX None password
cattype INDEX None cattype
theme INDEX None theme
thumbtype INDEX None thumbtype
catdepth INDEX None catdepth
watermark INDEX None watermark
sortorder INDEX None sortorder
catname_3 INDEX None catname
description_3 INDEX None description
thumbs_2 INDEX None thumbs
header_3 INDEX None header
footer_3 INDEX None footer
headtags_3 INDEX None headtags
private_2 INDEX None private
ugnoview_3 INDEX None ugnoview
ugnoupload_3 INDEX None ugnoupload
ugnopost_3 INDEX None ugnopost
ugnovote_3 INDEX None ugnovote
ugnoanno_3 INDEX None ugnoanno
children INDEX None children
albums INDEX None albums
password_3 INDEX None password
cattype_2 INDEX None cattype
theme_3 INDEX None theme
catdepth_3 INDEX None catdepth
watermark_2 INDEX None watermark


 Space usage :
Type Usage
Data 324 Bytes
Index 4,096 Bytes
Total 4,420 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 3
Row length ø 108
Row size  ø 1,473 Bytes
Next Autoindex 501
Creation Oct 09, 2017 at 01:47 AM
Last update Oct 09, 2017 at 01:47 AM