Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 20, 2024 at 12:00 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `extcal_2groups` 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_2groups.group_id | 1 | 5 | 1 | 1 | 0 | 0 | 3.0000 | 1.4142 | ENUM('1','2','3','4','5') NOT NULL |
| puroparty.extcal_2groups.group_name | Administrators | Moderators | 6 | 16 | 0 | 0 | 11.0000 | NULL | ENUM('Administrators','Anonymous','Approved Posters','Banned','Moderators') NOT NULL |
| puroparty.extcal_2groups.description | Events are set to auto-approve. | The damned group. | 17 | 46 | 0 | 0 | 32.6000 | NULL | ENUM('Events are set to auto-approve.','Group of anonymous users','Members of this group have the absolute power.','Moderators can manage content of the calendar','The damned group.') NOT NULL |
| puroparty.extcal_2groups.has_admin_access | 1 | 1 | 1 | 1 | 3 | 0 | 0.4000 | 0.4899 | ENUM('0','1') NOT NULL |
| puroparty.extcal_2groups.can_manage_accounts | 1 | 1 | 1 | 1 | 4 | 0 | 0.2000 | 0.4000 | ENUM('0','1') NOT NULL |
| puroparty.extcal_2groups.can_change_settings | 1 | 1 | 1 | 1 | 4 | 0 | 0.2000 | 0.4000 | ENUM('0','1') NOT NULL |
| puroparty.extcal_2groups.can_manage_cats | 1 | 1 | 1 | 1 | 3 | 0 | 0.4000 | 0.4899 | ENUM('0','1') NOT NULL |
| puroparty.extcal_2groups.can_create_events | 1 | 1 | 1 | 1 | 2 | 0 | 0.6000 | 0.4899 | ENUM('0','1') NOT NULL |
| puroparty.extcal_2groups.can_edit_events | 1 | 1 | 1 | 1 | 3 | 0 | 0.4000 | 0.4899 | ENUM('0','1') NOT NULL |
| puroparty.extcal_2groups.can_submit_events | 1 | 1 | 1 | 1 | 2 | 0 | 0.6000 | 0.4899 | ENUM('0','1') NOT NULL |
| puroparty.extcal_2groups.upl_need_approval | 0 | 1 | 1 | 1 | 3 | 0 | 0.4000 | 0.4899 | ENUM('0','1') NOT NULL |
| puroparty.extcal_2groups.locked | 1 | 1 | 1 | 1 | 2 | 0 | 0.6000 | 0.4899 | ENUM('0','1') NOT NULL |