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

jos_newsfeeds

Field Type Null Default
catid  int(11) No 
id  int(11) No   
name  text No   
alias  varchar(255) No   
link  text No   
filename  varchar(200) Yes  NULL 
published  tinyint(1) No 
numarticles  int(11) No 
cache_time  int(11) No  3600 
checked_out  tinyint(3) No 
checked_out_time  datetime No  0000-00-00 00:00:00 
ordering  int(11) No 
rtl  tinyint(4) No 


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 8 id
id_2 UNIQUE 8 id
alias_2 UNIQUE 8 alias
ordering_2 UNIQUE 8 ordering
ordering_3 UNIQUE 8 ordering
alias_5 UNIQUE 8 alias
id_4 UNIQUE 8 id
id_6 UNIQUE 8 id
alias_8 UNIQUE 8 alias
ordering_6 UNIQUE 8 ordering
checked_out_time_4 UNIQUE 8 checked_out_time
published INDEX None published
catid INDEX None catid
catid_2 INDEX None catid
id INDEX None id
alias INDEX None alias
filename INDEX None filename
published_2 INDEX None published
numarticles INDEX None numarticles
cache_time INDEX None cache_time
checked_out INDEX None checked_out
checked_out_time INDEX None checked_out_time
ordering INDEX None ordering
rtl INDEX None rtl
catid_3 INDEX None catid
alias_4 INDEX None alias
checked_out_time_2 INDEX None checked_out_time
checked_out_2 INDEX None checked_out
published_3 INDEX None published
rtl_2 INDEX None rtl
cache_time_2 INDEX None cache_time
numarticles_2 INDEX None numarticles
id_3 INDEX None id
ordering_4 INDEX None ordering
filename_4 INDEX None filename
rtl_3 INDEX None rtl
ordering_5 INDEX None ordering
catid_4 INDEX None catid
id_5 INDEX None id
published_4 INDEX None published
cache_time_3 INDEX None cache_time
checked_out_time_3 INDEX None checked_out_time
alias_7 INDEX None alias
checked_out_3 INDEX None checked_out
numarticles_3 INDEX None numarticles
filename_6 INDEX None filename
id_7 INDEX None id
published_5 INDEX None published
catid_5 INDEX None catid
name INDEX None name
alias_3 INDEX None alias
link INDEX None link
filename_2 INDEX None filename
link_2 INDEX None link
name_2 INDEX None name
filename_3 INDEX None filename
alias_6 INDEX None alias
link_3 INDEX None link
name_3 INDEX None name
filename_5 INDEX None filename
alias_9 INDEX None alias
link_4 INDEX None link
link_5 INDEX None link
name_4 INDEX None name


 Space usage :
Type Usage
Data 1,104 Bytes
Index 4,096 Bytes
Total 5,200 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 8
Row length ø 138
Row size  ø 650 Bytes
Next Autoindex 9
Creation Feb 24, 2018 at 08:02 AM
Last update Mar 26, 2018 at 02:50 PM
Last check Mar 26, 2018 at 11:34 PM