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

SQL-query
SQL-query: 
SELECT *
FROM `photopost_usergroups`
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.photopost_usergroups.groupid 1 5 1 1 0 0 3.0000 1.4142 ENUM('1','2','3','4','5') NOT NULL
puroparty.photopost_usergroups.groupname Administrator Unregistered 5 13 0 0 9.2000 NULL ENUM('Administrator','Banned','COPPA','Registered'...
puroparty.photopost_usergroups.cpaccess 1 1 1 1 4 0 0.2000 0.4000 ENUM('0','1') NOT NULL
puroparty.photopost_usergroups.modaccess 1 1 1 1 4 0 0.2000 0.4000 ENUM('0','1') NOT NULL
puroparty.photopost_usergroups.uploads 1 1 1 1 3 0 0.4000 0.4899 ENUM('0','1') NOT NULL
puroparty.photopost_usergroups.comments 1 1 1 1 3 0 0.4000 0.4899 ENUM('0','1') NOT NULL
puroparty.photopost_usergroups.diskspace 0 0 1 1 5 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.photopost_usergroups.uploadsize 0 0 1 1 5 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.photopost_usergroups.uplimit 0 0 1 1 5 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.photopost_usergroups.editpho 1 1 1 1 3 0 0.4000 0.4899 ENUM('0','1') NOT NULL
puroparty.photopost_usergroups.editposts 1 1 1 1 3 0 0.4000 0.4899 ENUM('0','1') NOT NULL
puroparty.photopost_usergroups.useralbums 1 1 1 1 3 0 0.4000 0.4899 ENUM('0','1') NOT NULL
puroparty.photopost_usergroups.reqmod 0 0 1 1 5 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.photopost_usergroups.canassign 0 0 1 1 5 0 0.0000 0.0000 ENUM('0') NOT NULL


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