Host: mysql.puroparty.com
Database: puroparty
Generation Time: May 19, 2024 at 11:16 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `extcal2_groups` PROCEDURE ANALYSE();
Rows: 9
Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
---|---|---|---|---|---|---|---|---|---|
puroparty.extcal2_groups.group_id | 1 | 5 | 1 | 1 | 0 | 0 | 3.0000 | 1.4142 | ENUM('1','2','3','4','5') NOT NULL |
puroparty.extcal2_groups.group_name | Administrators | Moderators | 6 | 16 | 0 | 0 | 11.0000 | NULL | ENUM('Administrators','Anonymous','Approved Poster... |
puroparty.extcal2_groups.description | Group of anonymous users | The damned group. | 17 | 46 | 0 | 0 | 30.4000 | NULL | ENUM('Group of anonymous users','Members of this g... |
puroparty.extcal2_groups.has_admin_access | 1 | 1 | 1 | 1 | 3 | 0 | 0.4000 | 0.4899 | ENUM('0','1') NOT NULL |
puroparty.extcal2_groups.can_manage_accounts | 1 | 1 | 1 | 1 | 4 | 0 | 0.2000 | 0.4000 | ENUM('0','1') NOT NULL |
puroparty.extcal2_groups.can_change_settings | 1 | 1 | 1 | 1 | 4 | 0 | 0.2000 | 0.4000 | ENUM('0','1') NOT NULL |
puroparty.extcal2_groups.can_manage_cats | 1 | 1 | 1 | 1 | 4 | 0 | 0.2000 | 0.4000 | ENUM('0','1') NOT NULL |
puroparty.extcal2_groups.upl_need_approval | 0 | 1 | 1 | 1 | 3 | 0 | 0.4000 | 0.4899 | ENUM('0','1') NOT NULL |
puroparty.extcal2_groups.locked | 1 | 1 | 1 | 1 | 1 | 0 | 0.8000 | 0.4000 | ENUM('0','1') NOT NULL |