· 8 years ago · Jan 05, 2018, 10:56 AM
1CREATE TABLE IF NOT EXISTS `message` (
2 `m_id` int(11) NOT NULL AUTO_INCREMENT,
3 `m_text` varchar(1000) NOT NULL,
4 `m_time` datetime NOT NULL,
5 `p_id` varchar(30) NOT NULL,
6 `m_type` int(11) NOT NULL,
7 PRIMARY KEY (`m_id`),
8 KEY `p_id` (`p_id`),
9 KEY `m_id` (`m_id`,`p_id`)
10) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;