Host: mysql.puroparty.com
Database: puroparty
Generation Time: Jun 14, 2024 at 09:54 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `photopost_usergroups` PROCEDURE ANALYSE();
Rows: 14
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','Unregistered') NOT NULL |
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 |