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

   Field  Type Collation Attributes Null Default Extra Action
   int(11)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   varchar(100) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(100) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(100) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   tinyint(3)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
   tinyint(3)     No    Change Drop Primary Index Unique Fulltext
   tinyint(3)     No    Change Drop Primary Index Unique Fulltext
   tinyint(3)     No    Change Drop Primary Index Unique Fulltext
   int(11)   UNSIGNED No    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
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 32  Edit Drop id
id_2 UNIQUE 32  Edit Drop id
name_2 UNIQUE 32  Edit Drop name
id_3 UNIQUE 32  Edit Drop id
name_6 UNIQUE 32  Edit Drop name
name_7 UNIQUE 32  Edit Drop name
id_6 UNIQUE 32  Edit Drop id
id_7 UNIQUE 32  Edit Drop id
idx_folder INDEX None  Edit Drop published
client_id
access
folder
id INDEX None  Edit Drop id
name INDEX None  Edit Drop name
element INDEX None  Edit Drop element
folder INDEX None  Edit Drop folder
access INDEX None  Edit Drop access
ordering INDEX None  Edit Drop ordering
published INDEX None  Edit Drop published
iscore INDEX None  Edit Drop iscore
client_id INDEX None  Edit Drop client_id
checked_out INDEX None  Edit Drop checked_out
checked_out_time INDEX None  Edit Drop checked_out_time
name_5 INDEX None  Edit Drop name
access_2 INDEX None  Edit Drop access
folder_4 INDEX None  Edit Drop folder
ordering_2 INDEX None  Edit Drop ordering
element_4 INDEX None  Edit Drop element
checked_out_time_2 INDEX None  Edit Drop checked_out_time
checked_out_2 INDEX None  Edit Drop checked_out
published_2 INDEX None  Edit Drop published
id_4 INDEX None  Edit Drop id
client_id_2 INDEX None  Edit Drop client_id
iscore_2 INDEX None  Edit Drop iscore
id_5 INDEX None  Edit Drop id
element_5 INDEX None  Edit Drop element
client_id_3 INDEX None  Edit Drop client_id
ordering_3 INDEX None  Edit Drop ordering
iscore_3 INDEX None  Edit Drop iscore
name_8 INDEX None  Edit Drop name
access_3 INDEX None  Edit Drop access
checked_out_time_3 INDEX None  Edit Drop checked_out_time
folder_6 INDEX None  Edit Drop folder
checked_out_3 INDEX None  Edit Drop checked_out
published_3 INDEX None  Edit Drop published
checked_out_4 INDEX None  Edit Drop checked_out
access_4 INDEX None  Edit Drop access
folder_8 INDEX None  Edit Drop folder
element_7 INDEX None  Edit Drop element
ordering_4 INDEX None  Edit Drop ordering
checked_out_time_4 INDEX None  Edit Drop checked_out_time
name_3 FULLTEXT None  Edit Drop name
element_2 FULLTEXT None  Edit Drop element
folder_2 FULLTEXT None  Edit Drop folder
params FULLTEXT None  Edit Drop params
folder_3 FULLTEXT None  Edit Drop folder
name_4 FULLTEXT None  Edit Drop name
element_3 FULLTEXT None  Edit Drop element
params_2 FULLTEXT None  Edit Drop params
folder_5 FULLTEXT None  Edit Drop folder
element_6 FULLTEXT None  Edit Drop element
name_9 FULLTEXT None  Edit Drop name
params_3 FULLTEXT None  Edit Drop params
name_10 FULLTEXT None  Edit Drop name
folder_7 FULLTEXT None  Edit Drop folder
params_4 FULLTEXT None  Edit Drop params
element_8 FULLTEXT None  Edit Drop element
Create an index on  columns  
 
Space usage: 
Type Usage
Data 2,636 Bytes
Index 4,096 Bytes
Total 6,732 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Rows 32
Row length ø 82
Row size  ø 210 Bytes
Next Autoindex 34
Creation Dec 17, 2017 at 05:23 AM
Last update Dec 17, 2017 at 05:23 AM
Last check Mar 16, 2018 at 11:48 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: