Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 19, 2024 at 06:16 PM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `phorum_forums` PROCEDURE ANALYSE();
Rows: 37
Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
---|---|---|---|---|---|---|---|---|---|
puroparty.phorum_forums.forum_id | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |
puroparty.phorum_forums.name | Test Forum | Test Forum | 10 | 10 | 0 | 0 | 10.0000 | NULL | ENUM('Test Forum') NOT NULL |
puroparty.phorum_forums.active | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |
puroparty.phorum_forums.description | This is a test forum. Feel free to delete it or e... | This is a test forum. Feel free to delete it or e... | 73 | 73 | 0 | 0 | 73.0000 | NULL | ENUM('This is a test forum. Feel free to delete i... |
puroparty.phorum_forums.template | default | default | 7 | 7 | 0 | 0 | 7.0000 | NULL | ENUM('default') NOT NULL |
puroparty.phorum_forums.folder_flag | 0 | 0 | 1 | 1 | 1 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.phorum_forums.parent_id | 0 | 0 | 1 | 1 | 1 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.phorum_forums.list_length_flat | 30 | 30 | 2 | 2 | 0 | 0 | 30.0000 | 0.0000 | ENUM('30') NOT NULL |
puroparty.phorum_forums.list_length_threaded | 15 | 15 | 2 | 2 | 0 | 0 | 15.0000 | 0.0000 | ENUM('15') NOT NULL |
puroparty.phorum_forums.moderation | 0 | 0 | 1 | 1 | 1 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.phorum_forums.threaded_list | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |
puroparty.phorum_forums.threaded_read | 0 | 0 | 1 | 1 | 1 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.phorum_forums.float_to_top | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |
puroparty.phorum_forums.check_duplicate | 0 | 0 | 1 | 1 | 1 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.phorum_forums.allow_attachment_types | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.phorum_forums.max_attachment_size | 0 | 0 | 1 | 1 | 1 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.phorum_forums.max_totalattachment_size | 0 | 0 | 1 | 1 | 1 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.phorum_forums.max_attachments | 0 | 0 | 1 | 1 | 1 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.phorum_forums.pub_perms | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |
puroparty.phorum_forums.reg_perms | 15 | 15 | 2 | 2 | 0 | 0 | 15.0000 | 0.0000 | ENUM('15') NOT NULL |
puroparty.phorum_forums.display_ip_address | 0 | 0 | 1 | 1 | 1 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.phorum_forums.allow_email_notify | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |
puroparty.phorum_forums.language | english | english | 7 | 7 | 0 | 0 | 7.0000 | NULL | ENUM('english') NOT NULL |
puroparty.phorum_forums.email_moderators | 0 | 0 | 1 | 1 | 1 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.phorum_forums.message_count | 3 | 3 | 1 | 1 | 0 | 0 | 3.0000 | 0.0000 | ENUM('3') NOT NULL |
puroparty.phorum_forums.sticky_count | 0 | 0 | 1 | 1 | 1 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.phorum_forums.thread_count | 2 | 2 | 1 | 1 | 0 | 0 | 2.0000 | 0.0000 | ENUM('2') NOT NULL |
puroparty.phorum_forums.last_post_time | 1182893859 | 1182893859 | 10 | 10 | 0 | 0 | 1182893859.0000 | 0.0000 | ENUM('1182893859') NOT NULL |
puroparty.phorum_forums.display_order | 0 | 0 | 1 | 1 | 1 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.phorum_forums.read_length | 20 | 20 | 2 | 2 | 0 | 0 | 20.0000 | 0.0000 | ENUM('20') NOT NULL |
puroparty.phorum_forums.vroot | 0 | 0 | 1 | 1 | 1 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.phorum_forums.edit_post | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |
puroparty.phorum_forums.template_settings | NULL | NULL | 0 | 0 | 0 | 1 | 0.0 | NULL | CHAR(0) |
puroparty.phorum_forums.count_views | 0 | 0 | 1 | 1 | 1 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.phorum_forums.display_fixed | 0 | 0 | 1 | 1 | 1 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.phorum_forums.reverse_threading | 0 | 0 | 1 | 1 | 1 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.phorum_forums.inherit_id | NULL | NULL | 0 | 0 | 0 | 1 | 0.0 | 0.0 | CHAR(0) |