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

jos_core_acl_aro_groups

Field Type Null Default
id  int(11) No   
parent_id  int(11) No 
name  varchar(255) No   
lft  int(11) No 
rgt  int(11) No 
value  varchar(255) No   


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 11 id
id_2 UNIQUE 11 id
name_2 UNIQUE 11 name
lft_2 UNIQUE 11 lft
rgt_2 UNIQUE 11 rgt
value_2 UNIQUE 11 value
name_4 UNIQUE 11 name
lft_3 UNIQUE 11 lft
value_6 UNIQUE 11 value
rgt_4 UNIQUE 11 rgt
id_3 UNIQUE 11 id
id_6 UNIQUE 11 id
name_7 UNIQUE 11 name
value_8 UNIQUE 11 value
lft_6 UNIQUE 11 lft
rgt_6 UNIQUE 11 rgt
value_10 UNIQUE 11 value
id_7 UNIQUE 11 id
name_10 UNIQUE 11 name
id_9 UNIQUE 11 id
name_11 UNIQUE 11 name
value_14 UNIQUE 11 value
rgt_8 UNIQUE 11 rgt
lft_9 UNIQUE 11 lft
lft_10 UNIQUE 11 lft
jos_gacl_parent_id_aro_groups INDEX None parent_id
jos_gacl_lft_rgt_aro_groups INDEX None lft
rgt
id INDEX None id
parent_id INDEX None parent_id
name INDEX None name
lft INDEX None lft
rgt INDEX None rgt
value INDEX None value
value_5 INDEX None value
rgt_3 INDEX None rgt
parent_id_2 INDEX None parent_id
name_6 INDEX None name
lft_4 INDEX None lft
id_4 INDEX None id
id_5 INDEX None id
value_7 INDEX None value
lft_5 INDEX None lft
rgt_5 INDEX None rgt
parent_id_3 INDEX None parent_id
name_9 INDEX None name
lft_7 INDEX None lft
id_8 INDEX None id
parent_id_4 INDEX None parent_id
value_11 INDEX None value
id_10 INDEX None id
value_13 INDEX None value
rgt_7 INDEX None rgt
name_12 INDEX None name
lft_8 INDEX None lft
name_14 INDEX None name
rgt_9 INDEX None rgt
name_3 INDEX None name
value_3 INDEX None value
value_4 INDEX None value
name_5 INDEX None name
name_8 INDEX None name
value_9 INDEX None value
value_12 INDEX None value
name_13 INDEX None name


 Space usage :
Type Usage
Data 464 Bytes
Index 3,072 Bytes
Total 3,536 Bytes
   Row Statistic :
Statements Value
Format dynamic
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