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

jos_content

Field Type Null Default
id  int(11) No   
title  varchar(255) No   
alias  varchar(255) No   
title_alias  varchar(255) No   
introtext  mediumtext No   
fulltext  mediumtext No   
state  tinyint(3) No 
sectionid  int(11) No 
mask  int(11) No 
catid  int(11) No 
created  datetime No  0000-00-00 00:00:00 
created_by  int(11) No 
created_by_alias  varchar(255) No   
modified  datetime No  0000-00-00 00:00:00 
modified_by  int(11) No 
checked_out  int(11) No 
checked_out_time  datetime No  0000-00-00 00:00:00 
publish_up  datetime No  0000-00-00 00:00:00 
publish_down  datetime No  0000-00-00 00:00:00 
images  text No   
urls  text No   
attribs  text No   
version  int(11) No 
parentid  int(11) No 
ordering  int(11) No 
metakey  text No   
metadesc  text No   
access  int(11) No 
hits  int(11) No 
metadata  text No   


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 43 id
id_2 UNIQUE 43 id
title_2 UNIQUE 43 title
alias_2 UNIQUE 43 alias
modified_2 UNIQUE 43 modified
idx_section INDEX None sectionid
idx_access INDEX None access
idx_checkout INDEX None checked_out
idx_state INDEX None state
idx_catid INDEX None catid
idx_createdby INDEX None created_by
id INDEX None id
title INDEX None title
alias INDEX None alias
title_alias INDEX None title_alias
state INDEX None state
sectionid INDEX None sectionid
mask INDEX None mask
catid INDEX None catid
created INDEX None created
created_by INDEX None created_by
created_by_alias INDEX None created_by_alias
modified INDEX None modified
modified_by INDEX None modified_by
checked_out INDEX None checked_out
checked_out_time INDEX None checked_out_time
publish_up INDEX None publish_up
publish_down INDEX None publish_down
version INDEX None version
parentid INDEX None parentid
ordering INDEX None ordering
access INDEX None access
hits INDEX None hits
hits_2 INDEX None hits
title_alias_3 INDEX None title_alias
catid_2 INDEX None catid
alias_4 INDEX None alias
checked_out_time_2 INDEX None checked_out_time
parentid_2 INDEX None parentid
access_2 INDEX None access
created_2 INDEX None created
mask_2 INDEX None mask
state_2 INDEX None state
created_by_2 INDEX None created_by
ordering_2 INDEX None ordering
title_3 INDEX None title
alias_3 INDEX None alias
title_alias_2 INDEX None title_alias
introtext INDEX None introtext
fulltext INDEX None fulltext
created_by_alias_2 INDEX None created_by_alias
images INDEX None images
urls INDEX None urls
attribs INDEX None attribs
metakey INDEX None metakey
metadesc INDEX None metadesc
metadata INDEX None metadata
attribs_2 INDEX None attribs
fulltext_2 INDEX None fulltext
created_by_alias_3 INDEX None created_by_alias
title_alias_4 INDEX None title_alias
title_4 INDEX None title
metadesc_2 INDEX None metadesc
metakey_2 INDEX None metakey


 Space usage :
Type Usage
Data 65,924 Bytes
Index 4,096 Bytes
Total 70,020 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 43
Row length ø 1,533
Row size  ø 1,628 Bytes
Next Autoindex 44
Creation Oct 20, 2017 at 08:35 AM
Last update Apr 24, 2018 at 01:23 AM
Last check Apr 06, 2018 at 08:18 AM