
-- ----------------------------
-- 系统通知表
-- ----------------------------
create table sys_notice (
id        bigint NOT NULL AUTO_INCREMENT,
title      varchar(50)     not null                   comment '公告标题',
type       tinyint         not null                   comment '公告类型（1通知 2公告）',
content    longblob        default null               comment '公告内容',
status            tinyint         default 0                comment '公告状态（0正常 1关闭）',
create_by         varchar(64)     default ''                 comment '创建者',
create_time       datetime NOT NULL DEFAULT CURRENT_TIMESTAMP         comment '创建时间',
update_by         varchar(64)     default ''                 comment '更新者',
update_time       datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP comment '更新时间',
remark            varchar(255)    default null               comment '备注',
primary key (id)
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT =  '通知公告表' ROW_FORMAT = Dynamic;