msg_push.sql 487 B

12345678910111213
  1. drop table if exists `msg_push`.`message`;
  2. create table `msg_push`.`message` (
  3. `id` int(11) not null auto_increment,
  4. `sys_name` varchar(64) not null default '',
  5. `remind_type` varchar(64) not null default '',
  6. `target` varchar(64) not null default '',
  7. `content` text not null ,
  8. `status` int(11) not null default 0,
  9. `create_at` DATETIME not null default CURRENT_TIMESTAMP,
  10. `update_at` DATETIME not null ON UPDATE CURRENT_TIMESTAMP ,
  11. primary key(`id`)
  12. )