SQL result

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