Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 25, 2024 at 08:42 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 Message') NOT NULL |
puroparty.phorum_messages.body | another tester | This is a test message. You can delete it after install using the admin.\n\nPhorum 5 Team | 7 | 88 | 0 | 0 | 36.3333 | NULL | ENUM('another tester','test #2','This is a test message. You can delete it after install using the admin.\n\nPhorum 5 Team') NOT NULL |
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.swbell.net') NOT NULL |
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.TestForum','7f9d447641d4a155bba36f406ba300a2.TestForum') NOT NULL | |
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 NULL |
puroparty.phorum_messages.meta | a:0:{} | a:3:{s:11:"recent_post";a:3:{s:7:"user_id";s:1:"1";s:6:"author";s:5:"ppcru";s:10:"message_id";s:1:"3";}s:11:"message_ids";a:1:{i:0;i:3;}s:21:"message_ids_moderator";a:1:{i:0;i:3;}} | 6 | 196 | 0 | 0 | 127.3333 | NULL | ENUM('a:0:{}','a:3:{s:11:"recent_post";a:3:{s:7:"user_id";s:1:"1";s:6:"author";s:5:"ppcru";s:10:"message_id";s:1:"2";}s:11:"message_ids";a:2:{i:0;i:1;i:1;i:2;}s:21:"message_ids_moderator";a:2:{i:0;i:1;i:1;i:2;}}','a:3:{s:11:"recent_post";a:3:{s:7:"user_id";s:1:"1";s:6:"author";s:5:"ppcru";s:10:"message_id";s:1:"3";}s:11:"message_ids";a:1:{i:0;i:3;}s:21:"message_ids_moderator";a:1:{i:0;i:3;}}') NOT NULL |
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 |