· 9 years ago · May 02, 2017, 04:02 PM
1mohan@mohan-desktop:/usr/local/MPP$ mysql -h localhost -uadmin mpptest19 -p
2Enter password:
3Reading table information for completion of table and column names
4You can turn off this feature to get a quicker startup with -A
5
6Welcome to the MySQL monitor. Commands end with ; or \g.
7Your MySQL connection id is 130
8Server version: 5.1.41-1.dotdeb.1 (Debian)
9
10Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
11
12mysql> DROP TABLE IF EXISTS `content`;
13Query OK, 0 rows affected, 1 warning (0.00 sec)
14
15mysql> CREATE TABLE `content` (
16 -> `id` int(11) NOT NULL auto_increment,
17 -> `message_text` longtext,
18 -> PRIMARY KEY (`id`),
19 -> FULLTEXT KEY `message_text` (`message_text`)
20 -> ) ENGINE=MyISAM CHARSET=utf8;
21Query OK, 0 rows affected (0.00 sec)
22
23mysql> DROP TABLE IF EXISTS `messages`;
24Query OK, 0 rows affected, 1 warning (0.00 sec)
25
26mysql> CREATE TABLE `messages` (
27 -> `id` int(11) NOT NULL auto_increment,
28 -> `subject` text,
29 -> `sender_id` int(11) default NULL,
30 -> `content_id` int(11) default NULL,
31 -> `content_url` varchar(255) default NULL,
32 -> `messageid` varchar(255) default NULL,
33 -> `group_name` text,
34 -> `reason` varchar(32) default NULL,
35 -> `body_hash` varchar(32) default NULL,
36 -> `received` datetime default NULL,
37 -> `unix_timestamp` int(11) default NULL,
38 -> `host_name` varchar(64) default NULL,
39 -> `location` varchar(64) default NULL,
40 -> `flag_virus` tinyint(1) default '0',
41 -> `flag_unauth` tinyint(1) default '0',
42 -> `flag_spam` tinyint(1) default '0',
43 -> PRIMARY KEY (`id`),
44 -> KEY `body_hash` (`body_hash`),
45 -> KEY `sender_id` (`sender_id`),
46 -> KEY `content_id` (`content_id`),
47 -> KEY `content_url` (`content_url`),
48 -> KEY `received` (`received`),
49 -> KEY `unix_timestamp` (`unix_timestamp`),
50 -> KEY `messageid` (`messageid`),
51 -> KEY `reason` (`reason`),
52 -> KEY `flag_virus` (`flag_virus`),
53 -> KEY `flag_unauth` (`flag_unauth`),
54 -> KEY `flag_spam` (`flag_spam`),
55 -> FULLTEXT KEY `subject` (`subject`)
56 -> ) ENGINE=MyISAM CHARSET=utf8;
57Query OK, 0 rows affected (0.01 sec)
58
59mysql> DROP TABLE IF EXISTS `user_messages`;
60Query OK, 0 rows affected, 1 warning (0.00 sec)
61
62mysql> CREATE TABLE `user_messages` (
63 -> `id` int(11) NOT NULL auto_increment,
64 -> `receiver_id` int(11) NOT NULL default '0',
65 -> `message_id` int(11) NOT NULL default '0',
66 -> `time_of_read` int(11) UNSIGNED DEFAULT '0' NOT NULL,
67 -> PRIMARY KEY (`id`),
68 -> KEY `receiver_id` (`receiver_id`),
69 -> KEY `message_id` (`message_id`)
70 -> ) ENGINE=MyISAM CHARSET=utf8;
71Query OK, 0 rows affected (0.00 sec)
72
73mysql> DROP TABLE IF EXISTS `details`;
74Query OK, 0 rows affected, 1 warning (0.00 sec)
75
76mysql> CREATE TABLE `details` (
77 -> `id` int(11) NOT NULL auto_increment,
78 -> `message_id` int(11) NOT NULL default '0',
79 -> `field_name` text NOT NULL,
80 -> `field_value` text NOT NULL,
81 -> PRIMARY KEY (`id`),
82 -> KEY `message_id` (`message_id`)
83 -> ) ENGINE=MyISAM CHARSET=utf8;
84Query OK, 0 rows affected (0.00 sec)
85
86mysql>
87mysql>
88mysql>
89mysql> select * from message;
90Empty set (0.00 sec)
91
92mysql> select * from messages;
93+----+---------+-----------+------------+-----------------------------------------------------+------------------------------------------------+------------+---------+-----------+---------------------+----------------+---------------+-------------+------------+-------------+-----------+
94| 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 |
95+----+---------+-----------+------------+-----------------------------------------------------+------------------------------------------------+------------+---------+-----------+---------------------+----------------+---------------+-------------+------------+-------------+-----------+
96| 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 |
97| 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 |
98| 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 |
99| 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 |
100| 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 |
101| 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 |
102| 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 |
103| 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 |
104| 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 |
105| 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 |
106| 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 |
107+----+---------+-----------+------------+-----------------------------------------------------+------------------------------------------------+------------+---------+-----------+---------------------+----------------+---------------+-------------+------------+-------------+-----------+
10811 rows in set (0.00 sec)
109
110mysql>