Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 25, 2024 at 07:49 PM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `phorum_messages` PROCEDURE ANALYSE();
Rows: 20
Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
---|---|---|---|---|---|---|---|---|---|
puroparty.phorum_messages.message_id | 1 | 3 | 1 | 1 | 0 | 0 | 2.0000 | 0.8165 | ENUM('1','2','3') NOT NULL |
puroparty.phorum_messages.forum_id | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |
puroparty.phorum_messages.thread | 1 | 3 | 1 | 1 | 0 | 0 | 1.6667 | 0.9428 | ENUM('1','3') NOT NULL |
puroparty.phorum_messages.parent_id | 0 | 1 | 1 | 1 | 2 | 0 | 0.3333 | 0.4714 | ENUM('0','1') NOT NULL |
puroparty.phorum_messages.author | Phorum Installer | ppcru | 5 | 16 | 0 | 0 | 8.6667 | NULL | ENUM('Phorum Installer','ppcru') NOT NULL |
puroparty.phorum_messages.subject | Another Test | Test Message | 12 | 16 | 0 | 0 | 13.3333 | NULL | ENUM('Another Test','Re: Test Message','Test Messa... |
puroparty.phorum_messages.body | another tester | This is a test message. You can delete it after i... | 7 | 88 | 0 | 0 | 36.3333 | NULL | ENUM('another tester','test #2','This is a test me... |
puroparty.phorum_messages.email | 0 | 0 | 3 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.phorum_messages.ip | 127.0.0.1 | adsl-70-240-102-97.dsl.hstntx.swbell.net | 9 | 40 | 0 | 0 | 29.6667 | NULL | ENUM('127.0.0.1','adsl-70-240-102-97.dsl.hstntx.sw... |
puroparty.phorum_messages.status | 2 | 2 | 1 | 1 | 0 | 0 | 2.0000 | 0.0000 | ENUM('2') NOT NULL |
puroparty.phorum_messages.msgid | 7f9d447641d4a155bba36f406ba300a2.TestForum | 0 | 42 | 1 | 0 | 28.0000 | NULL | ENUM('','430c38de1da94adb23180f35a6371a07.TestForu... | |
puroparty.phorum_messages.modifystamp | 1182891684 | 1182893859 | 10 | 10 | 1 | 0 | 788595181.0000 | 557621000.0968 | ENUM('0','1182891684','1182893859') NOT NULL |
puroparty.phorum_messages.user_id | 0 | 1 | 1 | 1 | 1 | 0 | 0.6667 | 0.4714 | ENUM('0','1') NOT NULL |
puroparty.phorum_messages.thread_count | 1 | 2 | 1 | 1 | 1 | 0 | 1.0000 | 0.8165 | ENUM('0','1','2') NOT NULL |
puroparty.phorum_messages.moderator_post | 0 | 1 | 1 | 1 | 1 | 0 | 0.6667 | 0.4714 | ENUM('0','1') NOT NULL |
puroparty.phorum_messages.sort | 2 | 2 | 1 | 1 | 0 | 0 | 2.0000 | 0.0000 | ENUM('2') NOT NULL |
puroparty.phorum_messages.datestamp | 1182891420 | 1182893859 | 10 | 10 | 0 | 0 | 1182892321.0000 | 1431655765.3338 | ENUM('1182891420','1182891684','1182893859') NOT N... |
puroparty.phorum_messages.meta | a:0:{} | a:3:{s:11:"recent_post";a:3:{s:7:"user_id";s:1:"1"... | 6 | 196 | 0 | 0 | 127.3333 | NULL | ENUM('a:0:{}','a:3:{s:11:"recent_post";a:3:{s:7:"u... |
puroparty.phorum_messages.viewcount | 0 | 0 | 1 | 1 | 3 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.phorum_messages.closed | 0 | 0 | 1 | 1 | 3 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |