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

   Field  Type Collation Attributes Null Default Extra Action
   int(11)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
   varchar(30) utf8_general_ci   No  banner    Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
   varchar(100) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(200) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   datetime     Yes  NULL    Change Drop Primary Index Unique Fulltext
   tinyint(1)     No    Change Drop Primary Index Unique Fulltext
   tinyint(1)     No    Change Drop Primary Index Unique Fulltext
   datetime     No  0000-00-00 00:00:00    Change Drop Primary Index Unique Fulltext
   varchar(50) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   text utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   int(10)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   text utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   tinyint(1)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
   datetime     No  0000-00-00 00:00:00    Change Drop Primary Index Unique Fulltext
   datetime     No  0000-00-00 00:00:00    Change Drop Primary Index Unique Fulltext
   text utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   text utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
With selected: Check All  /  Uncheck All     With selected:  

Print viewPrint view    Propose table structurePropose table structureDocumentation
Add new fieldAdd new field: 


Indexes: Documentation
Keyname Type Cardinality Action Field
PRIMARY PRIMARY Edit Drop bid
bid_2 UNIQUE Edit Drop bid
name_2 UNIQUE Edit Drop name
alias_2 UNIQUE Edit Drop alias
alias_4 UNIQUE Edit Drop alias
name_6 UNIQUE Edit Drop name
viewbanner INDEX None  Edit Drop showBanner
idx_banner_catid INDEX None  Edit Drop catid
bid INDEX None  Edit Drop bid
cid INDEX None  Edit Drop cid
type INDEX None  Edit Drop type
name INDEX None  Edit Drop name
alias INDEX None  Edit Drop alias
imptotal INDEX None  Edit Drop imptotal
impmade INDEX None  Edit Drop impmade
clicks INDEX None  Edit Drop clicks
imageurl INDEX None  Edit Drop imageurl
clickurl INDEX None  Edit Drop clickurl
date INDEX None  Edit Drop date
showBanner INDEX None  Edit Drop showBanner
checked_out INDEX None  Edit Drop checked_out
checked_out_time INDEX None  Edit Drop checked_out_time
editor INDEX None  Edit Drop editor
catid INDEX None  Edit Drop catid
sticky INDEX None  Edit Drop sticky
ordering INDEX None  Edit Drop ordering
publish_up INDEX None  Edit Drop publish_up
publish_down INDEX None  Edit Drop publish_down
name_4 INDEX None  Edit Drop name
clickurl_3 INDEX None  Edit Drop clickurl
publish_down_2 INDEX None  Edit Drop publish_down
checked_out_time_2 INDEX None  Edit Drop checked_out_time
type_3 INDEX None  Edit Drop type
bid_3 INDEX None  Edit Drop bid
alias_5 INDEX None  Edit Drop alias
impmade_2 INDEX None  Edit Drop impmade
publish_up_2 INDEX None  Edit Drop publish_up
ordering_2 INDEX None  Edit Drop ordering
sticky_2 INDEX None  Edit Drop sticky
checked_out_2 INDEX None  Edit Drop checked_out
cid_2 INDEX None  Edit Drop cid
catid_2 INDEX None  Edit Drop catid
clicks_2 INDEX None  Edit Drop clicks
date_2 INDEX None  Edit Drop date
imageurl_4 INDEX None  Edit Drop imageurl
imptotal_2 INDEX None  Edit Drop imptotal
type_2 FULLTEXT None  Edit Drop type
name_3 FULLTEXT None  Edit Drop name
alias_3 FULLTEXT None  Edit Drop alias
imageurl_2 FULLTEXT None  Edit Drop imageurl
clickurl_2 FULLTEXT None  Edit Drop clickurl
editor_2 FULLTEXT None  Edit Drop editor
custombannercode FULLTEXT None  Edit Drop custombannercode
description FULLTEXT None  Edit Drop description
tags FULLTEXT None  Edit Drop tags
params FULLTEXT None  Edit Drop params
clickurl_4 FULLTEXT None  Edit Drop clickurl
name_5 FULLTEXT None  Edit Drop name
alias_6 FULLTEXT None  Edit Drop alias
imageurl_3 FULLTEXT None  Edit Drop imageurl
editor_3 FULLTEXT None  Edit Drop editor
tags_2 FULLTEXT None  Edit Drop tags
custombannercode_2 FULLTEXT None  Edit Drop custombannercode
description_2 FULLTEXT None  Edit Drop description
Create an index on  columns  
 
Space usage: 
Type Usage
Data 1,308 Bytes
Index 4,096 Bytes
Total 5,404 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Rows 8
Row length ø 163
Row size  ø 676 Bytes
Next Autoindex 9
Creation Oct 23, 2017 at 03:55 AM
Last update Apr 22, 2018 at 08:02 PM
Last check Apr 05, 2018 at 08:32 AM

Run SQL query/queries on database puropartyDocumentation     Fields: 
Or Location of the textfile: 
 Location of the textfile: 
   (Max: 2,048KB)
  Compression:
                
Character set of the file: