Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: bak_bannerbak_banner
StructureStructure BrowseBrowse SQLSQL SearchSearch InsertInsert ExportExport OperationsOperations EmptyEmpty DropDrop

   Field  Type Collation Attributes Null Default Extra Action
   int(11)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   int(11)     No  0    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  0    Change Drop Primary Index Unique Fulltext
   int(11)     No  0    Change Drop Primary Index Unique Fulltext
   int(11)     No  0    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  0    Change Drop Primary Index Unique Fulltext
   tinyint(1)     No  0    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  0    Change Drop Primary Index Unique Fulltext
   text utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   tinyint(1)   UNSIGNED No  0    Change Drop Primary Index Unique Fulltext
   int(11)     No  0    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: 
StructureStructure BrowseBrowse SQLSQL SearchSearch InsertInsert ExportExport OperationsOperations EmptyEmpty DropDrop

Indexes: Documentation
Keyname Type Cardinality Action Field
PRIMARY PRIMARY 0  Edit Drop bid
bid_2 UNIQUE 0  Edit Drop bid
cid_2 UNIQUE 0  Edit Drop cid
type_2 UNIQUE 0  Edit Drop type
name_2 UNIQUE 0  Edit Drop name
alias_2 UNIQUE 0  Edit Drop alias
imptotal_2 UNIQUE 0  Edit Drop imptotal
impmade_2 UNIQUE 0  Edit Drop impmade
clicks_2 UNIQUE 0  Edit Drop clicks
imageurl_2 UNIQUE 0  Edit Drop imageurl
clickurl_2 UNIQUE 0  Edit Drop clickurl
showBanner_2 UNIQUE 0  Edit Drop showBanner
checked_out_2 UNIQUE 0  Edit Drop checked_out
checked_out_time_2 UNIQUE 0  Edit Drop checked_out_time
catid_2 UNIQUE 0  Edit Drop catid
sticky_2 UNIQUE 0  Edit Drop sticky
ordering_2 UNIQUE 0  Edit Drop ordering
publish_up_2 UNIQUE 0  Edit Drop publish_up
publish_down_2 UNIQUE 0  Edit Drop publish_down
clicks_3 UNIQUE 0  Edit Drop clicks
cid_3 UNIQUE 0  Edit Drop cid
alias_4 UNIQUE 0  Edit Drop alias
imptotal_3 UNIQUE 0  Edit Drop imptotal
clickurl_5 UNIQUE 0  Edit Drop clickurl
date_2 UNIQUE None  Edit Drop date
editor_2 UNIQUE None  Edit Drop editor
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
checked_out_time_3 INDEX None  Edit Drop checked_out_time
catid_3 INDEX None  Edit Drop catid
cid_4 INDEX None  Edit Drop cid
type_3 FULLTEXT None  Edit Drop type
name_3 FULLTEXT None  Edit Drop name
alias_3 FULLTEXT None  Edit Drop alias
imageurl_3 FULLTEXT None  Edit Drop imageurl
clickurl_3 FULLTEXT None  Edit Drop clickurl
editor_3 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
params_2 FULLTEXT None  Edit Drop params
name_4 FULLTEXT None  Edit Drop name
Create an index on  columns  
 
Space usage: 
Type Usage
Data 0 Bytes
Index 4,096 Bytes
Total 4,096 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Rows 0
Next Autoindex 1
Creation Oct 18, 2017 at 02:20 PM
Last update Mar 19, 2024 at 07:11 PM
Last check Mar 19, 2024 at 07:11 PM
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: