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

bak_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 0 bid
bid_2 UNIQUE 0 bid
cid_2 UNIQUE 0 cid
type_2 UNIQUE 0 type
name_2 UNIQUE 0 name
alias_2 UNIQUE 0 alias
imptotal_2 UNIQUE 0 imptotal
impmade_2 UNIQUE 0 impmade
clicks_2 UNIQUE 0 clicks
imageurl_2 UNIQUE 0 imageurl
clickurl_2 UNIQUE 0 clickurl
showBanner_2 UNIQUE 0 showBanner
checked_out_2 UNIQUE 0 checked_out
checked_out_time_2 UNIQUE 0 checked_out_time
catid_2 UNIQUE 0 catid
sticky_2 UNIQUE 0 sticky
ordering_2 UNIQUE 0 ordering
publish_up_2 UNIQUE 0 publish_up
publish_down_2 UNIQUE 0 publish_down
clicks_3 UNIQUE 0 clicks
cid_3 UNIQUE 0 cid
alias_4 UNIQUE 0 alias
imptotal_3 UNIQUE 0 imptotal
clickurl_5 UNIQUE 0 clickurl
date_2 UNIQUE None date
editor_2 UNIQUE None editor
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
checked_out_time_3 INDEX None checked_out_time
catid_3 INDEX None catid
cid_4 INDEX None cid
type_3 INDEX None type
name_3 INDEX None name
alias_3 INDEX None alias
imageurl_3 INDEX None imageurl
clickurl_3 INDEX None clickurl
editor_3 INDEX None editor
custombannercode INDEX None custombannercode
description INDEX None description
tags INDEX None tags
params INDEX None params
clickurl_4 INDEX None clickurl
params_2 INDEX None params
name_4 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 18, 2017 at 02:20 PM
Last update Mar 26, 2018 at 05:46 AM
Last check Apr 07, 2018 at 06:20 AM