2017-04-02.sql 374 B

12345678910
  1. CREATE TABLE `notice` (
  2. `id` VARCHAR(36) NOT NULL,
  3. `aid` VARCHAR(36) NULL,
  4. `notice_type` VARCHAR(16) NULL COMMENT '通知类型',
  5. `content` VARCHAR(36) NULL COMMENT '通知内容',
  6. `create_time` DATETIME NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  7. `readed` INT(1) NULL,
  8. PRIMARY KEY (`id`))
  9. ENGINE = InnoDB
  10. COMMENT = '流转状态通知表';