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

   Field  Type Collation Attributes Null Default Extra Action
   int(11)     No    auto_increment  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
   varchar(255) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   text utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   tinyint(1)     No    Change Drop Primary Index Unique Fulltext
   time     Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(50) utf8_general_ci   Yes  NULL    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 cid
cid_2 UNIQUE Edit Drop cid
name_2 UNIQUE Edit Drop name
contact_2 UNIQUE Edit Drop contact
email_2 UNIQUE Edit Drop email
checked_out_2 UNIQUE Edit Drop checked_out
checked_out_3 UNIQUE Edit Drop checked_out
cid_3 UNIQUE Edit Drop cid
contact_4 UNIQUE Edit Drop contact
name_5 UNIQUE Edit Drop name
email_6 UNIQUE Edit Drop email
name_7 UNIQUE Edit Drop name
checked_out_6 UNIQUE Edit Drop checked_out
cid_5 UNIQUE Edit Drop cid
email_9 UNIQUE Edit Drop email
contact_8 UNIQUE Edit Drop contact
checked_out_7 UNIQUE Edit Drop checked_out
contact_11 UNIQUE Edit Drop contact
email_10 UNIQUE Edit Drop email
checked_out_time_2 UNIQUE None  Edit Drop checked_out_time
editor_2 UNIQUE None  Edit Drop editor
editor_4 UNIQUE None  Edit Drop editor
checked_out_time_3 UNIQUE None  Edit Drop checked_out_time
checked_out_time_5 UNIQUE None  Edit Drop checked_out_time
editor_9 UNIQUE None  Edit Drop editor
cid INDEX None  Edit Drop cid
name INDEX None  Edit Drop name
contact INDEX None  Edit Drop contact
email INDEX None  Edit Drop email
checked_out INDEX None  Edit Drop checked_out
checked_out_time INDEX None  Edit Drop checked_out_time
editor INDEX None  Edit Drop editor
email_4 INDEX None  Edit Drop email
name_4 INDEX None  Edit Drop name
editor_5 INDEX None  Edit Drop editor
checked_out_4 INDEX None  Edit Drop checked_out
contact_5 INDEX None  Edit Drop contact
cid_4 INDEX None  Edit Drop cid
checked_out_time_4 INDEX None  Edit Drop checked_out_time
contact_7 INDEX None  Edit Drop contact
name_8 INDEX None  Edit Drop name
checked_out_5 INDEX None  Edit Drop checked_out
email_8 INDEX None  Edit Drop email
editor_8 INDEX None  Edit Drop editor
cid_6 INDEX None  Edit Drop cid
checked_out_time_6 INDEX None  Edit Drop checked_out_time
contact_10 INDEX None  Edit Drop contact
name_3 FULLTEXT None  Edit Drop name
contact_3 FULLTEXT None  Edit Drop contact
email_3 FULLTEXT None  Edit Drop email
extrainfo FULLTEXT None  Edit Drop extrainfo
editor_3 FULLTEXT None  Edit Drop editor
editor_6 FULLTEXT None  Edit Drop editor
name_6 FULLTEXT None  Edit Drop name
email_5 FULLTEXT None  Edit Drop email
extrainfo_2 FULLTEXT None  Edit Drop extrainfo
contact_6 FULLTEXT None  Edit Drop contact
editor_7 FULLTEXT None  Edit Drop editor
email_7 FULLTEXT None  Edit Drop email
name_9 FULLTEXT None  Edit Drop name
extrainfo_3 FULLTEXT None  Edit Drop extrainfo
contact_9 FULLTEXT None  Edit Drop contact
extrainfo_4 FULLTEXT None  Edit Drop extrainfo
editor_10 FULLTEXT None  Edit Drop editor
Create an index on  columns  
 
Space usage: 
Type Usage
Data 72 Bytes
Index 3,072 Bytes
Total 3,144 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Rows 1
Row length ø 72
Row size  ø 3,144 Bytes
Next Autoindex 2
Creation Dec 13, 2017 at 08:00 AM
Last update Mar 26, 2018 at 02:19 PM
Last check Mar 26, 2018 at 02:19 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: