Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 20, 2024 at 02:45 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `bak_core_acl_aro_groups` PROCEDURE ANALYSE();
Rows: 6
| Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
|---|---|---|---|---|---|---|---|---|---|
| puroparty.bak_core_acl_aro_groups.id | 17 | 30 | 2 | 2 | 0 | 0 | 23.0909 | 4.3160 | ENUM('17','18','19','20','21','23','24','25','28','29','30') NOT NULL |
| puroparty.bak_core_acl_aro_groups.parent_id | 0 | 30 | 1 | 2 | 1 | 0 | 21.4545 | 8.1169 | ENUM('0','17','18','19','20','23','24','28','29','30') NOT NULL |
| puroparty.bak_core_acl_aro_groups.name | Administrator | USERS | 4 | 19 | 0 | 0 | 9.8182 | NULL | ENUM('Administrator','Author','Editor','Manager','Public Backend','Public Frontend','Publisher','Registered','ROOT','Super Administrator','USERS') NOT NULL |
| puroparty.bak_core_acl_aro_groups.lft | 1 | 16 | 1 | 2 | 0 | 0 | 7.8182 | 5.3397 | ENUM('1','2','3','4','5','6','7','13','14','15','16') NOT NULL |
| puroparty.bak_core_acl_aro_groups.rgt | 8 | 22 | 1 | 2 | 0 | 0 | 15.1818 | 4.9876 | ENUM('8','9','10','11','12','17','18','19','20','21','22') NOT NULL |
| puroparty.bak_core_acl_aro_groups.value | Administrator | USERS | 4 | 19 | 0 | 0 | 9.8182 | NULL | ENUM('Administrator','Author','Editor','Manager','Public Backend','Public Frontend','Publisher','Registered','ROOT','Super Administrator','USERS') NOT NULL |