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

Table holding user groups

SQL-query
SQL-query: 
SELECT *
FROM `extcal2_groups`
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.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


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