mohan@mohan-desktop:/usr/local/MPP$ mysql -h localhost -uadmin mpptest19 -p
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 130
Server version: 5.1.41-1.dotdeb.1 (Debian)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> DROP TABLE IF EXISTS `content`;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> CREATE TABLE `content` (
    ->   `id` int(11) NOT NULL auto_increment,
    ->   `message_text` longtext,
    ->   PRIMARY KEY  (`id`),
    ->   FULLTEXT KEY `message_text` (`message_text`)
    -> ) ENGINE=MyISAM CHARSET=utf8;
Query OK, 0 rows affected (0.00 sec)

mysql> DROP TABLE IF EXISTS `messages`;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> CREATE TABLE `messages` (
    ->   `id` int(11) NOT NULL auto_increment,
    ->   `subject` text,
    ->   `sender_id` int(11) default NULL,
    ->   `content_id` int(11) default NULL,
    ->   `content_url` varchar(255) default NULL,
    ->   `messageid` varchar(255) default NULL,
    ->   `group_name` text,
    ->   `reason` varchar(32) default NULL,
    ->   `body_hash` varchar(32) default NULL,
    ->   `received` datetime default NULL,
    ->   `unix_timestamp` int(11) default NULL,
    ->   `host_name` varchar(64) default NULL,
    ->   `location` varchar(64) default NULL,
    ->   `flag_virus` tinyint(1) default '0',
    ->   `flag_unauth` tinyint(1) default '0',
    ->   `flag_spam` tinyint(1) default '0',
    ->   PRIMARY KEY  (`id`),
    ->   KEY `body_hash` (`body_hash`),
    ->   KEY `sender_id` (`sender_id`),
    ->   KEY `content_id` (`content_id`),
    ->   KEY `content_url` (`content_url`),
    ->   KEY `received` (`received`),
    ->   KEY `unix_timestamp` (`unix_timestamp`),
    ->   KEY `messageid` (`messageid`),
    ->   KEY `reason` (`reason`),
    ->   KEY `flag_virus` (`flag_virus`),
    ->   KEY `flag_unauth` (`flag_unauth`),
    ->   KEY `flag_spam` (`flag_spam`),
    ->   FULLTEXT KEY `subject` (`subject`)
    -> ) ENGINE=MyISAM CHARSET=utf8;
Query OK, 0 rows affected (0.01 sec)

mysql> DROP TABLE IF EXISTS `user_messages`;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> CREATE TABLE `user_messages` (
    ->   `id` int(11) NOT NULL auto_increment,
    ->   `receiver_id` int(11) NOT NULL default '0',
    ->   `message_id` int(11) NOT NULL default '0',
    ->   `time_of_read` int(11) UNSIGNED DEFAULT '0' NOT NULL,
    ->   PRIMARY KEY  (`id`),
    ->   KEY `receiver_id` (`receiver_id`),
    ->   KEY `message_id` (`message_id`)
    -> ) ENGINE=MyISAM CHARSET=utf8;
Query OK, 0 rows affected (0.00 sec)

mysql> DROP TABLE IF EXISTS `details`;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> CREATE TABLE `details` (
    ->   `id` int(11) NOT NULL auto_increment,
    ->   `message_id` int(11) NOT NULL default '0',
    ->   `field_name` text NOT NULL,
    ->   `field_value` text NOT NULL,
    ->   PRIMARY KEY  (`id`),
    ->   KEY `message_id` (`message_id`)
    -> ) ENGINE=MyISAM CHARSET=utf8;
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql>
mysql>
mysql> select * from message;
Empty set (0.00 sec)

mysql> select * from messages;
+----+---------+-----------+------------+-----------------------------------------------------+------------------------------------------------+------------+---------+-----------+---------------------+----------------+---------------+-------------+------------+-------------+-----------+
| id | subject | sender_id | content_id | content_url                                         | messageid                                      | group_name | reason  | body_hash | received            | unix_timestamp | host_name     | location    | flag_virus | flag_unauth | flag_spam |
+----+---------+-----------+------------+-----------------------------------------------------+------------------------------------------------+------------+---------+-----------+---------------------+----------------+---------------+-------------+------------+-------------+-----------+
|  1 |         |         1 |       NULL | /var/MPP/archive/50/1B/20100221_180839_103555b90.0  | <20100216205839.108D52D0731@macbook.sob.local> | ex2k7      | Archive | NULL      | 2010-02-21 18:08:39 |     1266755919 | mohan-desktop | Main office |          0 |           0 |         0 |
|  2 |         |         1 |       NULL | /var/MPP/archive/3D/57/20100221_180840_103556b90.1  | <20100216205829.4EE092D0726@macbook.sob.local> | ex2k7      | Archive | NULL      | 2010-02-21 18:08:40 |     1266755920 | mohan-desktop | Main office |          0 |           0 |         0 |
|  3 |         |         1 |       NULL | /var/MPP/archive/62/E6/20100221_180840_103555b90.2  | <20100216205823.CC1F42D0713@macbook.sob.local> | ex2k7      | Archive | NULL      | 2010-02-21 18:08:40 |     1266755920 | mohan-desktop | Main office |          0 |           0 |         0 |
|  4 |         |         1 |       NULL | /var/MPP/archive/10/F0/20100221_180841_103555b90.3  | <20100216205815.124DA2D0700@macbook.sob.local> | ex2k7      | Archive | NULL      | 2010-02-21 18:08:41 |     1266755921 | mohan-desktop | Main office |          0 |           0 |         0 |
|  5 |         |         1 |       NULL | /var/MPP/archive/74/4D/20100221_180841_103556b90.4  | <20100216205750.B692F2D06EE@macbook.sob.local> | ex2k7      | Archive | NULL      | 2010-02-21 18:08:41 |     1266755921 | mohan-desktop | Main office |          0 |           0 |         0 |
|  6 |         |         1 |       NULL | /var/MPP/archive/B9/11/20100221_180841_103556b90.5  | <20100216205745.2F4192D06E0@macbook.sob.local> | ex2k7      | Archive | NULL      | 2010-02-21 18:08:41 |     1266755921 | mohan-desktop | Main office |          0 |           0 |         0 |
|  7 |         |         1 |       NULL | /var/MPP/archive/FC/47/20100221_180842_103555b90.6  | <20100216205741.2293A2D06D3@macbook.sob.local> | ex2k7      | Archive | NULL      | 2010-02-21 18:08:42 |     1266755922 | mohan-desktop | Main office |          0 |           0 |         0 |
|  8 |         |         1 |       NULL | /var/MPP/archive/3F/0B/20100221_180842_103555b90.7  | <20100216205735.3D2A52D06C8@macbook.sob.local> | ex2k7      | Archive | NULL      | 2010-02-21 18:08:42 |     1266755922 | mohan-desktop | Main office |          0 |           0 |         0 |
|  9 |         |         1 |       NULL | /var/MPP/archive/23/D4/20100221_180843_103555b90.8  | <20100216205730.3F95B2D06BA@macbook.sob.local> | ex2k7      | Archive | NULL      | 2010-02-21 18:08:43 |     1266755923 | mohan-desktop | Main office |          0 |           0 |         0 |
| 10 |         |         1 |       NULL | /var/MPP/archive/E9/57/20100221_180843_103556b90.9  | <20100216205727.A48162D06AF@macbook.sob.local> | ex2k7      | Archive | NULL      | 2010-02-21 18:08:43 |     1266755923 | mohan-desktop | Main office |          0 |           0 |         0 |
| 11 |         |         1 |       NULL | /var/MPP/archive/F8/0B/20100221_180844_103556b90.10 | <20100216205725.DA4C32D06A4@macbook.sob.local> | ex2k7      | Archive | NULL      | 2010-02-21 18:08:44 |     1266755924 | mohan-desktop | Main office |          0 |           0 |         0 |
+----+---------+-----------+------------+-----------------------------------------------------+------------------------------------------------+------------+---------+-----------+---------------------+----------------+---------------+-------------+------------+-------------+-----------+
11 rows in set (0.00 sec)

mysql>