· 6 years ago · Mar 14, 2019, 04:58 PM
1CREATE TABLE IF NOT EXISTS `messages` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `from` int(11) DEFAULT NULL,
4 `to` int(11) DEFAULT NULL,
5 `title` varchar(120) DEFAULT NULL,
6 `text` tinytext,
7 `time` int(11) DEFAULT NULL,
8 `delete_from` tinyint(1) DEFAULT NULL,
9 `delete_to` tinyint(1) DEFAULT NULL,
10 `unread` tinyint(1) DEFAULT NULL,
11 PRIMARY KEY (`id`),
12 KEY `from` (`from`),
13 KEY `to` (`to`)
14) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;