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

bak_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 0 id
catid_3 UNIQUE 0 catid
id_2 UNIQUE 0 id
alias_2 UNIQUE 0 alias
published_3 UNIQUE 0 published
numarticles_2 UNIQUE 0 numarticles
cache_time_2 UNIQUE 0 cache_time
checked_out_2 UNIQUE 0 checked_out
checked_out_time_2 UNIQUE 0 checked_out_time
ordering_2 UNIQUE 0 ordering
rtl_2 UNIQUE 0 rtl
checked_out_3 UNIQUE 0 checked_out
catid_5 UNIQUE 0 catid
cache_time_4 UNIQUE 0 cache_time
alias_4 UNIQUE 0 alias
ordering_4 UNIQUE 0 ordering
rtl_4 UNIQUE 0 rtl
checked_out_time_3 UNIQUE 0 checked_out_time
published_5 UNIQUE 0 published
id_4 UNIQUE 0 id
numarticles_4 UNIQUE 0 numarticles
numarticles_6 UNIQUE 0 numarticles
filename_2 UNIQUE None filename
filename_4 UNIQUE None filename
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
ordering_3 INDEX None ordering
cache_time_3 INDEX None cache_time
rtl_3 INDEX None rtl
catid_4 INDEX None catid
published_4 INDEX None published
id_3 INDEX None id
numarticles_3 INDEX None numarticles
alias_5 INDEX None alias
filename_5 INDEX None filename
checked_out_time_4 INDEX None checked_out_time
checked_out_4 INDEX None checked_out
filename_7 INDEX None filename
alias_7 INDEX None alias
ordering_5 INDEX None ordering
numarticles_5 INDEX None numarticles
id_5 INDEX None id
catid_6 INDEX None catid
checked_out_time_5 INDEX None checked_out_time
name INDEX None name
alias_3 INDEX None alias
link INDEX None link
filename_3 INDEX None filename
link_2 INDEX None link
name_2 INDEX None name
alias_6 INDEX None alias
filename_6 INDEX None filename
name_3 INDEX None name


 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 30, 2017 at 04:29 PM
Last update Apr 17, 2024 at 04:55 PM
Last check Apr 28, 2024 at 02:08 AM