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

bak_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 0 id
id_2 UNIQUE 0 id
title_2 UNIQUE 0 title
alias_2 UNIQUE 0 alias
title_alias_2 UNIQUE 0 title_alias
state_2 UNIQUE 0 state
sectionid_2 UNIQUE 0 sectionid
mask_2 UNIQUE 0 mask
catid_2 UNIQUE 0 catid
created_2 UNIQUE 0 created
created_by_2 UNIQUE 0 created_by
created_by_alias_2 UNIQUE 0 created_by_alias
modified_2 UNIQUE 0 modified
modified_by_2 UNIQUE 0 modified_by
checked_out_2 UNIQUE 0 checked_out
checked_out_time_2 UNIQUE 0 checked_out_time
publish_up_2 UNIQUE 0 publish_up
publish_down_2 UNIQUE 0 publish_down
version_2 UNIQUE 0 version
parentid_2 UNIQUE 0 parentid
ordering_2 UNIQUE 0 ordering
access_2 UNIQUE 0 access
hits_2 UNIQUE 0 hits
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
state_3 INDEX None state
title_3 INDEX None title
alias_3 INDEX None alias
title_alias_3 INDEX None title_alias
introtext INDEX None introtext
fulltext INDEX None fulltext
created_by_alias_3 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


 Space usage :
Type Usage
Data 0 Bytes
Index 4,096 Bytes
Total 4,096 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 0
Next Autoindex 1
Creation Oct 16, 2017 at 06:23 PM
Last update Mar 26, 2018 at 03:25 AM
Last check Apr 06, 2018 at 11:48 PM