Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: jos_core_acl_aro_groupsjos_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
name_4 UNIQUE 11  Edit Drop name
lft_3 UNIQUE 11  Edit Drop lft
value_6 UNIQUE 11  Edit Drop value
rgt_4 UNIQUE 11  Edit Drop rgt
id_3 UNIQUE 11  Edit Drop id
id_6 UNIQUE 11  Edit Drop id
name_7 UNIQUE 11  Edit Drop name
value_8 UNIQUE 11  Edit Drop value
lft_6 UNIQUE 11  Edit Drop lft
rgt_6 UNIQUE 11  Edit Drop rgt
value_10 UNIQUE 11  Edit Drop value
id_7 UNIQUE 11  Edit Drop id
name_10 UNIQUE 11  Edit Drop name
id_9 UNIQUE 11  Edit Drop id
name_11 UNIQUE 11  Edit Drop name
value_14 UNIQUE 11  Edit Drop value
rgt_8 UNIQUE 11  Edit Drop rgt
lft_9 UNIQUE 11  Edit Drop lft
lft_10 UNIQUE 11  Edit Drop lft
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
value_5 INDEX None  Edit Drop value
rgt_3 INDEX None  Edit Drop rgt
parent_id_2 INDEX None  Edit Drop parent_id
name_6 INDEX None  Edit Drop name
lft_4 INDEX None  Edit Drop lft
id_4 INDEX None  Edit Drop id
id_5 INDEX None  Edit Drop id
value_7 INDEX None  Edit Drop value
lft_5 INDEX None  Edit Drop lft
rgt_5 INDEX None  Edit Drop rgt
parent_id_3 INDEX None  Edit Drop parent_id
name_9 INDEX None  Edit Drop name
lft_7 INDEX None  Edit Drop lft
id_8 INDEX None  Edit Drop id
parent_id_4 INDEX None  Edit Drop parent_id
value_11 INDEX None  Edit Drop value
id_10 INDEX None  Edit Drop id
value_13 INDEX None  Edit Drop value
rgt_7 INDEX None  Edit Drop rgt
name_12 INDEX None  Edit Drop name
lft_8 INDEX None  Edit Drop lft
name_14 INDEX None  Edit Drop name
rgt_9 INDEX None  Edit Drop rgt
name_3 FULLTEXT None  Edit Drop name
value_3 FULLTEXT None  Edit Drop value
value_4 FULLTEXT None  Edit Drop value
name_5 FULLTEXT None  Edit Drop name
name_8 FULLTEXT None  Edit Drop name
value_9 FULLTEXT None  Edit Drop value
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 Mar 20, 2018 at 07:31 PM
Last update Mar 28, 2018 at 02:30 AM
Last check Apr 03, 2018 at 02:43 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: