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

   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(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
   varchar(255) 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 11  Edit Drop id
id_2 UNIQUE 11  Edit Drop id
name_2 UNIQUE 11  Edit Drop name
lft_2 UNIQUE 11  Edit Drop lft
rgt_2 UNIQUE 11  Edit Drop rgt
value_2 UNIQUE 11  Edit Drop value
id_3 UNIQUE 11  Edit Drop id
lft_3 UNIQUE 11  Edit Drop lft
name_6 UNIQUE 11  Edit Drop name
rgt_4 UNIQUE 11  Edit Drop rgt
value_5 UNIQUE 11  Edit Drop value
id_6 UNIQUE 11  Edit Drop id
name_8 UNIQUE 11  Edit Drop name
lft_6 UNIQUE 11  Edit Drop lft
rgt_6 UNIQUE 11  Edit Drop rgt
value_8 UNIQUE 11  Edit Drop value
id_8 UNIQUE 11  Edit Drop id
name_11 UNIQUE 11  Edit Drop name
lft_8 UNIQUE 11  Edit Drop lft
rgt_8 UNIQUE 11  Edit Drop rgt
value_11 UNIQUE 11  Edit Drop value
lft_9 UNIQUE 11  Edit Drop lft
id_10 UNIQUE 11  Edit Drop id
rgt_10 UNIQUE 11  Edit Drop rgt
name_14 UNIQUE 11  Edit Drop name
jos_gacl_parent_id_aro_groups INDEX None  Edit Drop parent_id
jos_gacl_lft_rgt_aro_groups INDEX None  Edit Drop lft
rgt
id INDEX None  Edit Drop id
parent_id INDEX None  Edit Drop parent_id
name INDEX None  Edit Drop name
lft INDEX None  Edit Drop lft
rgt INDEX None  Edit Drop rgt
value INDEX None  Edit Drop value
rgt_3 INDEX None  Edit Drop rgt
parent_id_2 INDEX None  Edit Drop parent_id
lft_4 INDEX None  Edit Drop lft
name_5 INDEX None  Edit Drop name
id_4 INDEX None  Edit Drop id
value_4 INDEX None  Edit Drop value
id_5 INDEX None  Edit Drop id
parent_id_3 INDEX None  Edit Drop parent_id
name_7 INDEX None  Edit Drop name
lft_5 INDEX None  Edit Drop lft
rgt_5 INDEX None  Edit Drop rgt
value_7 INDEX None  Edit Drop value
id_7 INDEX None  Edit Drop id
parent_id_4 INDEX None  Edit Drop parent_id
name_10 INDEX None  Edit Drop name
lft_7 INDEX None  Edit Drop lft
rgt_7 INDEX None  Edit Drop rgt
value_10 INDEX None  Edit Drop value
parent_id_5 INDEX None  Edit Drop parent_id
rgt_9 INDEX None  Edit Drop rgt
id_9 INDEX None  Edit Drop id
lft_10 INDEX None  Edit Drop lft
name_3 FULLTEXT None  Edit Drop name
value_3 FULLTEXT None  Edit Drop value
name_4 FULLTEXT None  Edit Drop name
value_6 FULLTEXT None  Edit Drop value
name_9 FULLTEXT None  Edit Drop name
value_9 FULLTEXT None  Edit Drop value
name_12 FULLTEXT None  Edit Drop name
value_12 FULLTEXT None  Edit Drop value
name_13 FULLTEXT None  Edit Drop name
Create an index on  columns  
 
Space usage: 
Type Usage
Data 464 Bytes
Index 3,072 Bytes
Total 3,536 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Rows 11
Row length ø 42
Row size  ø 321 Bytes
Next Autoindex 31
Creation Dec 15, 2017 at 07:24 AM
Last update Apr 06, 2018 at 01:32 AM
Last check Apr 06, 2018 at 02:44 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: