12345678910111213 |
- 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`)
- )
|