DROP TABLE IF EXISTS `message`;
SET character_set_client = utf8mb4 ;
CREATE TABLE `message` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `from_id` int(11) DEFAULT NULL,
 `to_id` int(11) DEFAULT NULL,
 `conversation_id` varchar(45) NOT NULL,
 `content` text,
 `status` int(11) DEFAULT NULL COMMENT '0-未读;1-已读;2-删除;',
 `create_time` timestamp NULL DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `index_from_id` (`from_id`),
 KEY `index_to_id` (`to_id`),
 KEY `index_conversation_id` (`conversation_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;