Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 18, 2024 at 08:34 PM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `photopost_categories` PROCEDURE ANALYSE();
Rows: 47
Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
---|---|---|---|---|---|---|---|---|---|
puroparty.photopost_categories.id | 1 | 500 | 1 | 3 | 0 | 0 | 167.6667 | 234.9955 | ENUM('1','2','500') NOT NULL |
puroparty.photopost_categories.catname | A Category | Member Galleries | 4 | 16 | 0 | 0 | 10.0000 | NULL | ENUM('A Category','Main','Member Galleries') NOT N... |
puroparty.photopost_categories.description | Photos of a particular subject | 0 | 46 | 1 | 0 | 25.3333 | NULL | ENUM('','Individual user galleries - any photo cat... | |
puroparty.photopost_categories.catorder | 1 | 2 | 1 | 1 | 0 | 0 | 1.3333 | 0.4714 | ENUM('1','2') NOT NULL |
puroparty.photopost_categories.thumbs | no | yes | 2 | 3 | 0 | 0 | 2.6667 | NULL | ENUM('no','yes') NOT NULL |
puroparty.photopost_categories.parent | 0 | 1 | 1 | 1 | 2 | 0 | 0.3333 | 0.4714 | ENUM('0','1') NOT NULL |
puroparty.photopost_categories.header | NULL | NULL | 0 | 0 | 0 | 3 | 0.0 | NULL | CHAR(0) |
puroparty.photopost_categories.footer | NULL | NULL | 0 | 0 | 0 | 3 | 0.0 | NULL | CHAR(0) |
puroparty.photopost_categories.headtags | NULL | NULL | 0 | 0 | 0 | 3 | 0.0 | NULL | CHAR(0) |
puroparty.photopost_categories.private | no | no | 2 | 2 | 0 | 0 | 2.0000 | NULL | ENUM('no') NOT NULL |
puroparty.photopost_categories.ugnoview | NULL | NULL | 0 | 0 | 0 | 3 | 0.0 | NULL | CHAR(0) |
puroparty.photopost_categories.ugnoupload | NULL | NULL | 0 | 0 | 0 | 3 | 0.0 | NULL | CHAR(0) |
puroparty.photopost_categories.ugnopost | NULL | NULL | 0 | 0 | 0 | 3 | 0.0 | NULL | CHAR(0) |
puroparty.photopost_categories.ugnovote | NULL | NULL | 0 | 0 | 0 | 3 | 0.0 | NULL | CHAR(0) |
puroparty.photopost_categories.ugnoanno | NULL | NULL | 0 | 0 | 0 | 3 | 0.0 | NULL | CHAR(0) |
puroparty.photopost_categories.children | 2 | 2 | 1 | 1 | 2 | 0 | 0.3333 | NULL | ENUM('','2') NOT NULL |
puroparty.photopost_categories.albums | NULL | NULL | 0 | 0 | 0 | 3 | 0.0 | NULL | CHAR(0) |
puroparty.photopost_categories.subalbum | 0 | 0 | 1 | 1 | 3 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.photopost_categories.lastpost | 0 | 0 | 1 | 1 | 3 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.photopost_categories.lastphoto | 5 | 5 | 1 | 1 | 0 | 0 | 5.0000 | 0.0000 | ENUM('5') NOT NULL |
puroparty.photopost_categories.photos | 0 | 5 | 1 | 1 | 1 | 0 | 2.6667 | 2.0548 | ENUM('0','3','5') NOT NULL |
puroparty.photopost_categories.posts | 0 | 0 | 1 | 1 | 3 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.photopost_categories.password | NULL | NULL | 0 | 0 | 0 | 3 | 0.0 | NULL | CHAR(0) |
puroparty.photopost_categories.cattype | c | c | 1 | 1 | 0 | 0 | 1.0000 | NULL | ENUM('c') NOT NULL |
puroparty.photopost_categories.theme | NULL | NULL | 0 | 0 | 0 | 3 | 0.0 | NULL | CHAR(0) |
puroparty.photopost_categories.thumbtype | 0 | 0 | 1 | 1 | 3 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.photopost_categories.catdepth | NULL | NULL | 0 | 0 | 0 | 3 | 0.0 | NULL | CHAR(0) |
puroparty.photopost_categories.watermark | 0 | 0 | 3 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.photopost_categories.sortorder | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |
puroparty.photopost_categories.extra1 | NULL | NULL | 0 | 0 | 0 | 3 | 0.0 | NULL | CHAR(0) |
puroparty.photopost_categories.extra2 | NULL | NULL | 0 | 0 | 0 | 3 | 0.0 | NULL | CHAR(0) |
puroparty.photopost_categories.extra3 | NULL | NULL | 0 | 0 | 0 | 3 | 0.0 | NULL | CHAR(0) |
puroparty.photopost_categories.extra4 | NULL | NULL | 0 | 0 | 0 | 3 | 0.0 | NULL | CHAR(0) |
puroparty.photopost_categories.extra5 | NULL | NULL | 0 | 0 | 0 | 3 | 0.0 | NULL | CHAR(0) |
puroparty.photopost_categories.extra6 | NULL | NULL | 0 | 0 | 0 | 3 | 0.0 | NULL | CHAR(0) |
puroparty.photopost_categories.thumbnail | 0 | 3 | 1 | 1 | 2 | 0 | 1.0000 | 1.4142 | ENUM('0','3') NOT NULL |
puroparty.photopost_categories.maximages | 0 | 0 | 1 | 1 | 3 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.photopost_categories.canzip | no | no | 2 | 2 | 0 | 0 | 2.0000 | NULL | ENUM('no') NOT NULL |
puroparty.photopost_categories.frames | 0 | 0 | 1 | 1 | 0 | 0 | 1.0000 | NULL | ENUM('0') NOT NULL |
puroparty.photopost_categories.intro | no | no | 2 | 2 | 0 | 0 | 2.0000 | NULL | ENUM('no') NOT NULL |
puroparty.photopost_categories.introtitle | NULL | NULL | 0 | 0 | 0 | 3 | 0.0 | NULL | CHAR(0) |
puroparty.photopost_categories.introcopy | NULL | NULL | 0 | 0 | 0 | 3 | 0.0 | NULL | CHAR(0) |
puroparty.photopost_categories.moderators | NULL | NULL | 0 | 0 | 0 | 3 | 0.0 | NULL | CHAR(0) |
puroparty.photopost_categories.numextra | 0 | 0 | 1 | 1 | 3 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.photopost_categories.ratingtype | 0 | 0 | 1 | 1 | 3 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.photopost_categories.takevotes | 0 | 0 | 1 | 1 | 3 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.photopost_categories.ismember | 0 | 0 | 1 | 1 | 3 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |