notice/doc/sql/message.sql

drop table if exists `notice`.`message`;
create table `notice`.`message`(
    `id` int(11) not null auto_increment,
    `msg_type_id` int(11) not null default 0,
    `msg_content` text not null ,
    `target` varchar(64) not null default '',
    `push_count` int(11) not null default 0,
    `push_limit` int(11) not null default 0,
    `status` int(11) not null default 0,
    `create_at` DATETIME not null default CURRENT_TIMESTAMP,
    `update_at` DATETIME not null ON UPDATE CURRENT_TIMESTAMP ,
    primary key(`id`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8 comment '消息';
-- create table `user`(
--     `id` int(11) not null auto_increment,
--     openid varchar(64) not null default '',
--     phone varchar(64) not null default '',
--     primary key (`id`)
-- )ENGINE=InnoDB DEFAULT CHARSET=utf8 comment='用户表';


drop table if exists `msg_push`.`message`;
create table `msg_push`.`message` (
    `id` int(11) not null auto_increment,
    `sys_name` varchar(64) not null default '',
    `remind_type` varchar(64) not null default '',
    `target` varchar(64) not null default '',
    `content` text not null ,
    `status` int(11) not null default 0,
    `create_at` DATETIME not null default CURRENT_TIMESTAMP,
    `update_at` DATETIME not null ON UPDATE CURRENT_TIMESTAMP ,
     primary key(`id`)
)