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

jos_banner

Field Type Null Default
bid  int(11) No   
cid  int(11) No 
type  varchar(30) No  banner 
name  varchar(255) No   
alias  varchar(255) No   
imptotal  int(11) No 
impmade  int(11) No 
clicks  int(11) No 
imageurl  varchar(100) No   
clickurl  varchar(200) No   
date  datetime Yes  NULL 
showBanner  tinyint(1) No 
checked_out  tinyint(1) No 
checked_out_time  datetime No  0000-00-00 00:00:00 
editor  varchar(50) Yes  NULL 
custombannercode  text Yes  NULL 
catid  int(10) No 
description  text No   
sticky  tinyint(1) No 
ordering  int(11) No 
publish_up  datetime No  0000-00-00 00:00:00 
publish_down  datetime No  0000-00-00 00:00:00 
tags  text No   
params  text No   


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 8 bid
bid_2 UNIQUE 8 bid
name_2 UNIQUE 8 name
alias_2 UNIQUE 8 alias
alias_4 UNIQUE 8 alias
name_6 UNIQUE 8 name
viewbanner INDEX None showBanner
idx_banner_catid INDEX None catid
bid INDEX None bid
cid INDEX None cid
type INDEX None type
name INDEX None name
alias INDEX None alias
imptotal INDEX None imptotal
impmade INDEX None impmade
clicks INDEX None clicks
imageurl INDEX None imageurl
clickurl INDEX None clickurl
date INDEX None date
showBanner INDEX None showBanner
checked_out INDEX None checked_out
checked_out_time INDEX None checked_out_time
editor INDEX None editor
catid INDEX None catid
sticky INDEX None sticky
ordering INDEX None ordering
publish_up INDEX None publish_up
publish_down INDEX None publish_down
name_4 INDEX None name
clickurl_3 INDEX None clickurl
publish_down_2 INDEX None publish_down
checked_out_time_2 INDEX None checked_out_time
type_3 INDEX None type
bid_3 INDEX None bid
alias_5 INDEX None alias
impmade_2 INDEX None impmade
publish_up_2 INDEX None publish_up
ordering_2 INDEX None ordering
sticky_2 INDEX None sticky
checked_out_2 INDEX None checked_out
cid_2 INDEX None cid
catid_2 INDEX None catid
clicks_2 INDEX None clicks
date_2 INDEX None date
imageurl_4 INDEX None imageurl
imptotal_2 INDEX None imptotal
type_2 INDEX None type
name_3 INDEX None name
alias_3 INDEX None alias
imageurl_2 INDEX None imageurl
clickurl_2 INDEX None clickurl
editor_2 INDEX None editor
custombannercode INDEX None custombannercode
description INDEX None description
tags INDEX None tags
params INDEX None params
clickurl_4 INDEX None clickurl
name_5 INDEX None name
alias_6 INDEX None alias
imageurl_3 INDEX None imageurl
editor_3 INDEX None editor
tags_2 INDEX None tags
custombannercode_2 INDEX None custombannercode
description_2 INDEX None description


 Space usage :
Type Usage
Data 1,308 Bytes
Index 4,096 Bytes
Total 5,404 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 8
Row length ø 163
Row size  ø 676 Bytes
Next Autoindex 9
Creation Oct 23, 2017 at 03:55 AM
Last update Apr 24, 2018 at 01:23 AM
Last check Apr 05, 2018 at 08:32 AM