Host: mysql.puroparty.com
Database: puroparty
Generation Time: Mar 29, 2024 at 08:05 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `extcal_1groups` PROCEDURE ANALYSE();
Rows: 12
Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
---|---|---|---|---|---|---|---|---|---|
puroparty.extcal_1groups.group_id | 1 | 6 | 1 | 1 | 0 | 0 | 3.5000 | 1.7078 | ENUM('1','2','3','4','5','6') NOT NULL |
puroparty.extcal_1groups.group_name | Administrators | registered priv | 6 | 15 | 0 | 0 | 10.6667 | NULL | ENUM('Administrators','Anonymous','Banned','Moderators','registered','registered priv') NOT NULL |
puroparty.extcal_1groups.description | Group of anonymous users | The damned group. | 17 | 46 | 0 | 0 | 31.0000 | NULL | ENUM('Group of anonymous users','Members of this group have the absolute power.','Moderators can manage content of the calendar','registration required','registration required, privileged','The damned group.') NOT NULL |
puroparty.extcal_1groups.has_admin_access | 1 | 1 | 1 | 1 | 4 | 0 | 0.3333 | 0.4714 | ENUM('0','1') NOT NULL |
puroparty.extcal_1groups.can_manage_accounts | 1 | 1 | 1 | 1 | 5 | 0 | 0.1667 | 0.3727 | ENUM('0','1') NOT NULL |
puroparty.extcal_1groups.can_change_settings | 1 | 1 | 1 | 1 | 5 | 0 | 0.1667 | 0.3727 | ENUM('0','1') NOT NULL |
puroparty.extcal_1groups.can_manage_cats | 1 | 1 | 1 | 1 | 4 | 0 | 0.3333 | 0.4714 | ENUM('0','1') NOT NULL |
puroparty.extcal_1groups.can_create_events | 1 | 1 | 1 | 1 | 4 | 0 | 0.3333 | 0.4714 | ENUM('0','1') NOT NULL |
puroparty.extcal_1groups.can_edit_events | 1 | 1 | 1 | 1 | 4 | 0 | 0.3333 | 0.4714 | ENUM('0','1') NOT NULL |
puroparty.extcal_1groups.can_submit_events | 1 | 1 | 1 | 1 | 4 | 0 | 0.3333 | 0.4714 | ENUM('0','1') NOT NULL |
puroparty.extcal_1groups.upl_need_approval | 0 | 1 | 1 | 1 | 2 | 0 | 0.6667 | 0.4714 | ENUM('0','1') NOT NULL |
puroparty.extcal_1groups.locked | 1 | 1 | 1 | 1 | 3 | 0 | 0.5000 | 0.5000 | ENUM('0','1') NOT NULL |