Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: extcal_1groupsextcal_1groups
StructureStructure BrowseBrowse SQLSQL SearchSearch InsertInsert ExportExport OperationsOperations EmptyEmpty DropDrop

Table holding user groups

SQL-query
SQL-query: 
SELECT *
FROM `extcal_1groups`
PROCEDURE ANALYSE ( )
 [Edit] [Explain SQL] [Create PHP Code] [Refresh]



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','Modera...
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 g...
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


Print viewPrint view    Print view (with full texts)Print view (with full texts)     ExportExport