|
-- ----------------------------
|
-- 系统通知表
|
-- ----------------------------
|
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;
|
