/*
 Navicat MySQL Data Transfer

 Source Server         : 192.168.1.232
 Source Server Type    : MySQL
 Source Server Version : 50548
 Source Host           : 192.168.1.232
 Source Database       : liexin_message

 Target Server Type    : MySQL
 Target Server Version : 50548
 File Encoding         : utf-8

 Date: 02/21/2019 16:32:13 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `lie_delay_message`
-- ----------------------------
DROP TABLE IF EXISTS `lie_delay_message`;
CREATE TABLE `lie_delay_message` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(200) NOT NULL DEFAULT '' COMMENT '队列名',
  `content` text NOT NULL COMMENT '消息内容',
  `status` tinyint(1) unsigned DEFAULT '0' COMMENT '1 已经处理了  5处理失败',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
  `expect_send_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '期望发送时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=194 DEFAULT CHARSET=utf8mb4 COMMENT='延时消息任务表';

SET FOREIGN_KEY_CHECKS = 1;