-- ----------------------------
2023-09-04
-- ----------------------------
ALTER TABLE mortals_xhx_room ADD COLUMN   `fileName` varchar(256)  default ''    COMMENT '文件名称';
ALTER TABLE mortals_xhx_room ADD COLUMN   `filePath` varchar(256)  default ''    COMMENT '文件相对路径地址';

-- ----------------------------
-- 通知公告表
-- ----------------------------
DROP TABLE IF EXISTS `mortals_xhx_notice`;
CREATE TABLE mortals_xhx_notice(
    `id` bigint(20)   AUTO_INCREMENT   COMMENT '主键ID，主键，自增长',
    `title` varchar(256) NOT NULL     COMMENT '标题',
    `noticeContent` mediumtext      COMMENT '公告内容',
    `filePath` varchar(512)      COMMENT '公告文件路径',
    `fileName` varchar(512)      COMMENT '公告文件名称',
    `remark` varchar(256)      COMMENT '备注',
    `createUserId` bigint(20) NOT NULL     COMMENT '创建用户',
    `createTime` datetime NOT NULL     COMMENT '创建时间',
    `updateUserId` bigint(20)      COMMENT '更新用户',
    `updateTime` datetime      COMMENT '更新时间',
PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='通知公告';
-- ----------------------------
-- 房间公告表
-- ----------------------------
DROP TABLE IF EXISTS `mortals_xhx_notice_room`;
CREATE TABLE mortals_xhx_notice_room(
    `id` bigint(20)   AUTO_INCREMENT   COMMENT '主键ID，主键，自增长',
    `noticeId` bigint(20)      COMMENT '公告id',
    `title` varchar(256) NOT NULL     COMMENT '公告标题',
    `roomId` bigint(20)      COMMENT '房间id',
    `roomName` varchar(256) NOT NULL     COMMENT '房间名称',
    `remark` varchar(256)      COMMENT '备注',
    `createUserId` bigint(20) NOT NULL     COMMENT '创建用户',
    `createTime` datetime NOT NULL     COMMENT '创建时间',
    `updateUserId` bigint(20)      COMMENT '更新用户',
    `updateTime` datetime      COMMENT '更新时间',
PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='房间公告';


-- ----------------------------
-- 通知公告菜单 SQL
-- ----------------------------
INSERT INTO `mortals_xhx_menu` VALUES (null, '通知公告', '/notice/list', 0,'', 1, 1, 0, 0,'',NULL, NULL, NULL, 0, 0, 1, NULL, NULL, NULL);

-- ----------------------------
-- 通知公告资源路径 SQL
-- ----------------------------
INSERT INTO `mortals_xhx_resource` VALUES (null, '通知公告-菜单管理-查看', '/notice/list,/notice/view,/notice/info,/notice/export,/notice/exportExcel,/notice/downloadTemplate,/notice/download', 3, 0, NULL, NULL, NULL, 0);
INSERT INTO `mortals_xhx_resource` VALUES (null, '通知公告-菜单管理-维护', '/notice/add,/notice/edit,/notice/delete,/notice/logicDelete,/notice/save,/notice/importData', 3, 0, NULL, NULL, NULL, 0);

-- ----------------------------
-- 通知公告参数 SQL
-- ----------------------------
-- ----------------------------
-- 房间公告菜单 SQL
-- ----------------------------
INSERT INTO `mortals_xhx_menu` VALUES (null, '房间公告', '/notice/room/list', 0,'', 1, 1, 0, 0,'',NULL, NULL, NULL, 0, 0, 1, NULL, NULL, NULL);

-- ----------------------------
-- 房间公告资源路径 SQL
-- ----------------------------
INSERT INTO `mortals_xhx_resource` VALUES (null, '房间公告-菜单管理-查看', '/notice/room/list,/notice/room/view,/notice/room/info,/notice/room/export,/notice/room/exportExcel,/notice/room/downloadTemplate,/notice/room/download', 3, 0, NULL, NULL, NULL, 0);
INSERT INTO `mortals_xhx_resource` VALUES (null, '房间公告-菜单管理-维护', '/notice/room/add,/notice/room/edit,/notice/room/delete,/notice/room/logicDelete,/notice/room/save,/notice/room/importData', 3, 0, NULL, NULL, NULL, 0);


-- ----------------------------
2023-09-14
-- ----------------------------
ALTER TABLE mortals_xhx_workman ADD COLUMN   `fileName` varchar(256)  default ''    COMMENT '文件名称';
ALTER TABLE mortals_xhx_workman ADD COLUMN   `filePath` varchar(256)  default ''    COMMENT '文件相对路径地址';