Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: bak_pluginsbak_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_5 UNIQUE 32  Edit Drop name
id_6 UNIQUE 32  Edit Drop id
name_8 UNIQUE 32  Edit Drop name
name_10 UNIQUE 32  Edit Drop name
id_8 UNIQUE 32  Edit Drop id
client_id_5 UNIQUE 32  Edit Drop client_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
checked_out_time_2 INDEX None  Edit Drop checked_out_time
access_2 INDEX None  Edit Drop access
id_4 INDEX None  Edit Drop id
ordering_2 INDEX None  Edit Drop ordering
iscore_2 INDEX None  Edit Drop iscore
checked_out_2 INDEX None  Edit Drop checked_out
name_6 INDEX None  Edit Drop name
client_id_2 INDEX None  Edit Drop client_id
published_2 INDEX None  Edit Drop published
element_4 INDEX None  Edit Drop element
id_5 INDEX None  Edit Drop id
name_7 INDEX None  Edit Drop name
element_5 INDEX None  Edit Drop element
folder_4 INDEX None  Edit Drop folder
access_3 INDEX None  Edit Drop access
ordering_3 INDEX None  Edit Drop ordering
published_3 INDEX None  Edit Drop published
iscore_3 INDEX None  Edit Drop iscore
client_id_3 INDEX None  Edit Drop client_id
checked_out_3 INDEX None  Edit Drop checked_out
checked_out_time_3 INDEX None  Edit Drop checked_out_time
folder_6 INDEX None  Edit Drop folder
iscore_4 INDEX None  Edit Drop iscore
id_7 INDEX None  Edit Drop id
ordering_4 INDEX None  Edit Drop ordering
checked_out_time_4 INDEX None  Edit Drop checked_out_time
published_4 INDEX None  Edit Drop published
access_4 INDEX None  Edit Drop access
client_id_4 INDEX None  Edit Drop client_id
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
element_3 FULLTEXT None  Edit Drop element
name_4 FULLTEXT None  Edit Drop name
folder_3 FULLTEXT None  Edit Drop folder
params_2 FULLTEXT None  Edit Drop params
name_9 FULLTEXT None  Edit Drop name
element_6 FULLTEXT None  Edit Drop element
folder_5 FULLTEXT None  Edit Drop folder
params_3 FULLTEXT None  Edit Drop params
name_11 FULLTEXT None  Edit Drop name
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 04:33 PM
Last update Jun 10, 2018 at 09:31 PM
Last check Jun 20, 2018 at 01:15 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: