65 lines
6.7 KiB
SQL
65 lines
6.7 KiB
SQL
/*
|
||
Navicat Premium Data Transfer
|
||
|
||
Source Server : fateverse-demo
|
||
Source Server Type : MySQL
|
||
Source Server Version : 80036
|
||
Source Host : 10.7.127.184:3307
|
||
Source Schema : fateverse_demo_notice
|
||
|
||
Target Server Type : MySQL
|
||
Target Server Version : 80036
|
||
File Encoding : 65001
|
||
|
||
Date: 04/02/2024 21:39:01
|
||
*/
|
||
|
||
SET NAMES utf8mb4;
|
||
SET FOREIGN_KEY_CHECKS = 0;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for sys_notice
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `sys_notice`;
|
||
CREATE TABLE `sys_notice` (
|
||
`notice_id` int NOT NULL AUTO_INCREMENT COMMENT '公告ID',
|
||
`notice_title` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '公告标题',
|
||
`notice_type` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '公告类型（1通知 2公告）',
|
||
`send_type` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '发送类型',
|
||
`sender_ids` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '发送类型id',
|
||
`publish_id` int NULL DEFAULT NULL COMMENT '发布者id',
|
||
`notice_content` longblob NULL COMMENT '公告内容',
|
||
`content_type` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '内容类型: html,text等',
|
||
`cluster` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '属于那个群组',
|
||
`state` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '0' COMMENT '公告状态（0正常 1关闭）',
|
||
`create_by` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '创建者',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
||
`update_by` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '更新者',
|
||
`update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
||
`remark` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '备注',
|
||
PRIMARY KEY (`notice_id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '通知公告表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of sys_notice
|
||
-- ----------------------------
|
||
INSERT INTO `sys_notice` VALUES (1, '用户须知', '1', 'all', '[0]', NULL, 0x3C703EE5B08AE695ACE79A84E7BC98E5A283E7B3BBE7BB9FE794A8E688B7E58F8AE5BC80E58F91E88085EFBC9A3C2F703E0A3C703E266E6273703B20266E6273703B20266E6273703B20266E6273703BE68891E4BBACE99D9EE5B8B8E9AB98E585B4E59CB0E5AEA3E5B883EFBC8CE7BC98E5A283E7B3BBE7BB9FE79A84E6BA90E4BBA3E7A081E78EB0E5B7B2E5BC80E6BA90EFBC8CE585A8E99DA2E99DA2E59091E7A4BEE58CBAE5BC80E694BEE38082E8BF99E4B880E586B3E5AE9AE698AFE4B8BAE4BA86E4BF83E8BF9BE5BC80E58F91E88085E4B98BE997B4E79A84E59088E4BD9CEFBC8CE585B1E5908CE68EA8E58AA8E7BC98E5A283E7B3BBE7BB9FE79A84E4B88DE696ADE58F91E5B195E4B88EE5AE8CE59684E38082E9809AE8BF87E5BC80E6BA90EFBC8CE68891E4BBACE5B88CE69C9BE883BDE5A49FE6BF80E58F91E69BB4E5A49AE5889BE696B0EFBC8CE58AA0E9809FE7B3BBE7BB9FE79A84E8BFADE4BBA3E69BB4E696B0EFBC8CE5B9B6E4B8BAE794A8E688B7E68F90E4BE9BE69BB4E5BCBAE5A4A7E38081E781B5E6B4BBE79A84E58A9FE883BDE380823C2F703E0A3C703E266E6273703B20266E6273703B20266E6273703B20266E6273703B20E7BC98E5A283E7B3BBE7BB9FE698AFE4B880E5A597E59FBAE4BA8E537072696E6720436C6F7564E5BEAEE69C8DE58AA1E69EB6E69E84E79A84E5BFABE9809FE5BC80E58F91E59FBAE7A180E7B3BBE7BB9FEFBC8CE4BBA552424143E69D83E99990E7AEA1E79086E4B8BAE6A0B8E5BF83EFBC8CE5908CE697B6E58C85E590ABE4BA86E4BBA3E7A081E7949FE68890E38081E9809AE79FA5E585ACE5918AE7AD89E8BE85E58AA9E58A9FE883BDE6A8A1E59D97E38082E79BAEE5898DE5B7B2E7BB8FE6B6B5E79B96E4BA86E794A8E688B7E7AEA1E79086E38081E887AAE5AE9AE4B989E69FA5E8AFA2E38081E697A5E5BF97E8AEB0E5BD95E38081E6B688E681AFE9809AE79FA5E38081E4BBA3E7A081E7949FE68890E38081E69D83E99990E6A0A1E9AA8CE7AD89E5A49AE4B8AAE58A9FE883BDE6A8A1E59D97EFBC8CE4B8BAE682A8E79A84E9A1B9E79BAEE68F90E4BE9BE585A8E99DA2E79A84E694AFE68C813C2F703E0A3C703E266E6273703B20266E6273703B20266E6273703B20266E6273703B20E59CA8E5BC80E6BA90E79A84E59FBAE7A180E4B88AEFBC8CE682A8E58FAFE4BBA5E6A0B9E68DAEE5AE9EE99985E99C80E6B182E5AFB9E7B3BBE7BB9FE8BF9BE8A18CE5AE9AE588B6EFBC8CE4B99FE58FAFE4BBA5E8B4A1E78CAEE4BBA3E7A081E38081E68F90E587BAE5BBBAE8AEAEE585B1E5908CE68EA8E58AA8E7BC98E5A283E7B3BBE7BB9FE79A84E58F91E5B195E38082E68891E4BBACE79BB8E4BFA1E5BC80E6BA90E883BDE5A49FE6BF80E58F91E69BB4E5A49AE79A84E5889BE6848FE5928CE699BAE685A7EFBC8CE4B8BAE5BC80E58F91E88085E7A4BEE58CBAE5B8A6E69DA5E69BB4E5A4A7E79A84E4BBB7E580BC3C2F703E0A3C703E266E6273703B20266E6273703B20266E6273703B20266E6273703BE68891E4BBACE8AF9AE68C9AE59CB0E98280E8AFB7E682A8E58F82E4B88EE588B0E7BC98E5A283E7B3BBE7BB9FE79A84E5BC80E6BA90E7A4BEE58CBAE4B8ADEFBC8CE4B880E8B5B7E58886E4BAABE7BB8FE9AA8CEFBC8CE585B1E5908CE5AE8CE59684E7B3BBE7BB9FE38082E59CA8E8BF99E4B8AAE5BC80E6BA90E79A84E69785E7A88BE4B8ADEFBC8CE8AEA9E68891E4BBACE690BAE6898BE5898DE8A18CEFBC8CE585B1E5908CE5889BE980A0E69BB4E58AA0E4BC98E7A780E38081E5BCBAE5A4A7E79A84E5BC80E58F91E59FBAE7A180E7B3BBE7BB9FE380823C2F703E0A3C703EE6849FE8B0A2E682A8E4B880E79BB4E4BBA5E69DA5E5AFB9E7BC98E5A283E7B3BBE7BB9FE79A84E694AFE68C81E4B88EE4BFA1E4BBBB213C2F703E0A3C703EE7BC98E5A283E7B3BBE7BB9FE5BC80E58F91E59BA2E9989FE695ACE4B88A3C2F703E0A3C703E5B476974487562E4BB93E5BA93E993BEE68EA55D3A20266E6273703B3C6120687265663D2268747470733A2F2F6769746875622E636F6D2F6661746576657273652F666174657665727365223E476974687562E5908EE7ABAFE59CB0E59D803C2F613E20266E6273703B20266E6273703B3C6120687265663D2268747470733A2F2F6769746875622E636F6D2F6661746576657273652F6661746576657273652D767565223E476974687562E5898DE7ABAF567565E59CB0E59D803C2F613E3C2F703E0A3C703E5B4769746565E4BB93E5BA93E993BEE68EA55D3A203C6120687265663D2268747470733A2F2F67697465652E636F6D2F6661746576657273652F666174657665727365223E4769746565E5908EE7ABAFE59CB0E59D803C2F613E266E6273703B20266E6273703B3C6120687265663D2268747470733A2F2F67697465652E636F6D2F6661746576657273652F6661746576657273652D767565223E4769746565E5898DE7ABAF567565E59CB0E59D803C2F613E3C2F703E, 'html', 'notice', '1', NULL, '2024-02-04 21:36:06', NULL, NULL, NULL);
|
||
|
||
-- ----------------------------
|
||
-- Table structure for sys_user_notice
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `sys_user_notice`;
|
||
CREATE TABLE `sys_user_notice` (
|
||
`notice_id` int NOT NULL COMMENT '公告ID',
|
||
`user_id` int NULL DEFAULT NULL COMMENT '用户id',
|
||
`state` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '状态 0 未读 1 已读',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间'
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of sys_user_notice
|
||
-- ----------------------------
|
||
INSERT INTO `sys_user_notice` VALUES (1, 1, '0', '2024-02-04 21:36:06');
|
||
|
||
SET FOREIGN_KEY_CHECKS = 1;
|