/*
SQLyog Ultimate v12.03 (32 bit)
MySQL - 5.7.22-log : Database - dangjian
*********************************************************************
*/

SET NAMES utf8mb4;

CREATE DATABASE IF NOT EXISTS `dangjian` DEFAULT CHARACTER SET utf8mb4;

USE `dangjian`;

/* 文件库 */

DROP TABLE IF EXISTS `yl_documents`;

CREATE TABLE `yl_documents` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `name` varchar(50) NOT NULL COMMENT '原始文件名',
  `encode_name` varchar(32) NOT NULL COMMENT '转散列文件名',
  `orig_path` varchar(60) NOT NULL COMMENT '原始文件存储路径',
  `documents_category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文件分类ID',
  `extension` varchar(20) NOT NULL COMMENT '文件格式(后缀)',
  `size` int(10) unsigned NOT NULL COMMENT '文件大小',
  `creator_uuid` char(32) NOT NULL COMMENT '上传人UUID',
  `ctime` int(10) unsigned NOT NULL COMMENT '上传时间',
  `modifier_uuid` char(32) NOT NULL DEFAULT '' COMMENT '更新人UUID',
  `mtime` int(10) NOT NULL DEFAULT '0' COMMENT '最后更新时间',
  `version` int(10) unsigned NOT NULL DEFAULT '1' COMMENT '当前文件版本',
  `is_limit` enum('y','n') NOT NULL DEFAULT 'n' COMMENT '是否限制访问',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='文档表';

/*Data for the table `yl_documents` */

/*Table structure for table `yl_documents_category` */

DROP TABLE IF EXISTS `yl_documents_category`;

CREATE TABLE `yl_documents_category` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `name` varchar(100) NOT NULL COMMENT '分类名称',
  `desc` varchar(100) NOT NULL COMMENT '分类描述',
  `creator_uuid` char(32) NOT NULL COMMENT '添加操作员UUID',
  `ctime` int(10) unsigned NOT NULL COMMENT '添加时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='文档分类';

/*Data for the table `yl_documents_category` */

/*Table structure for table `yl_documents_access` */

DROP TABLE IF EXISTS `yl_documents_access`;

CREATE TABLE `yl_documents_access` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `documents_id` int(10) unsigned NOT NULL COMMENT '文件ID',
  `uuid` char(32) NOT NULL COMMENT '用户UUID',
  `permission` enum('read','write','none') NOT NULL DEFAULT 'read' COMMENT '权限',
  `expire` int(10) unsigned NOT NULL COMMENT '有效期（整型），0表示永远有效',
  `ctime` int(10) unsigned NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='文档权限';

/*Data for the table `yl_documents_access` */

/*Table structure for table `yl_documents_notify` */

DROP TABLE IF EXISTS `yl_documents_notify`;

CREATE TABLE `yl_documents_notify` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `documents_id` int(10) unsigned NOT NULL COMMENT '文件ID',
  `header` varchar(2000) NOT NULL COMMENT '请求头信息',
  `cmd` varchar(2000) NOT NULL COMMENT '操作标识',
  `body` varchar(2000) NOT NULL COMMENT '具体内容',
  `ctime` int(10) unsigned NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='文档回调通知';

/*Table structure for table `yl_documents_version` */

DROP TABLE IF EXISTS `yl_documents_version`;

CREATE TABLE `yl_documents_version` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `documents_id` int(10) unsigned NOT NULL COMMENT '文件ID',
  `version` int(10) unsigned NOT NULL COMMENT '版本号',
  `name` varchar(50) NOT NULL COMMENT '文件名',
  `size` int(10) unsigned NOT NULL COMMENT '文件大小',
  `path` char(100) NOT NULL COMMENT '文件路径',
  `ctime` int(10) unsigned NOT NULL COMMENT '版本创建时间',
  `creator_uuid` char(32) NOT NULL DEFAULT '' COMMENT '版本创建用户',
  `extension` varchar(20) NOT NULL COMMENT '文件格式(后缀)',
  `remark` varchar(200) NOT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='文档版本';

/*Data for the table `yl_documents_version` */

CREATE TABLE `yl_documents_logs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `documents_id` int(10) unsigned NOT NULL COMMENT '文件ID',
  `ctime` int(10) unsigned NOT NULL COMMENT '操作时间',
  `operator_uuid` char(32) NOT NULL DEFAULT '' COMMENT '操作用户',
  `type` enum('visit', 'save', 'rename') NOT NULL DEFAULT 'visit' COMMENT '操作类型',
  `remark` varchar(200) NOT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='文档访问历史';

/* 多媒体*/

CREATE TABLE `yl_vod_type` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `man_id` char(32) NOT NULL COMMENT '创建分类人员，关联user表uuid',
  `type_id` varchar(20) NOT NULL DEFAULT '' COMMENT '网易云点播类型id',
  `type_name` varchar(101) NOT NULL DEFAULT '' COMMENT '分类名称',
  `description` varchar(101) NOT NULL DEFAULT '' COMMENT '分类描述',
  `ctime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
  `display` tinyint(3) NOT NULL DEFAULT '1' COMMENT '是否展示该分类 0-不展示 1-展示',
  `region_code` char(12) NOT NULL DEFAULT '' COMMENT '区域编码',
  `allow_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '默认不可删除 0-不可删除 1-可删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='点播分类列表';

CREATE TABLE `yl_vod` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `type_id` varchar(30) NOT NULL DEFAULT '' COMMENT '分类id',
  `man_id` char(32) NOT NULL COMMENT '发布人uuid，关联user表uuid',
  `vid` varchar(20) NOT NULL DEFAULT '' COMMENT '网易云 点播id',
  `vod_name` varchar(101) NOT NULL DEFAULT '' COMMENT '点播名称',
  `snapshoturl` varchar(201) NOT NULL DEFAULT '' COMMENT '视频封面',
  `downloadorigurl` varchar(1001) NOT NULL DEFAULT '' COMMENT '原始视频url',
  `initialsize` varchar(20) NOT NULL DEFAULT '' COMMENT '视频大小',
  `type` enum('video','audio','picture') NOT NULL DEFAULT 'video' COMMENT '媒资类型：video-视频，audio-音频，picture-图片',
  `status` char(2) NOT NULL DEFAULT '10' COMMENT '视频的状态，10表示初始，20表示失败，30表示处理中，40表示成功，50表示屏蔽',
  `transcoding_status` enum('100','101','102','103','200','201','202') NOT NULL DEFAULT '100' COMMENT '推流转码状态, 100表示视频未转码, 101表示视频转码中, 102表示视频已转码, 103表示网易云状态未就绪, 200表示阿里云数据丢失, 201表示网易云数据丢失, 202表示源视频丢失或已删除',
  `width` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '视频的宽',
  `height` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '视频的高',
  `ctime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
  `preview_vid` varchar(20) NOT NULL DEFAULT '' COMMENT '预览id',
  `preview_addr` varchar(1001) NOT NULL DEFAULT '' COMMENT '预览图片',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='点播表';

CREATE TABLE `yl_vod_tvurl` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `vid` varchar(20) NOT NULL DEFAULT '' COMMENT '网易云 点播id，关联vod表vid',
  `stb_type` varchar(20) NOT NULL COMMENT '机顶盒类型',
  `play_url` varchar(100) NOT NULL COMMENT '播放地址',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='TV点播播放地址';

/* 计划 */
CREATE TABLE `yl_plan` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `plan_type` enum('党员大会','支委会','党小组会','党课','主题党日','组织生活会','其他') NOT NULL DEFAULT '党员大会' COMMENT '计划类型',
  `plan_period` enum('年度','季度','月度','其他') NOT NULL DEFAULT '月度' COMMENT '计划周期',
  `organ_id` int(10) unsigned NOT NULL COMMENT '活动党组织ID，关联ORGAN表ID',
  `theme` varchar(50) NOT NULL DEFAULT '' COMMENT '主题',
  `start_time` date NOT NULL COMMENT '计划开始时间（月）',
  `address` varchar(100) NOT NULL DEFAULT '' COMMENT '计划地点',
  `agenda` varchar(2000) NOT NULL DEFAULT '' COMMENT '议程',
  `scope` varchar(50) NOT NULL DEFAULT '' COMMENT '参与范围描述',
  `uuid` char(32) NOT NULL COMMENT '计划提交人',
  `ctime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '提交时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='计划表';

/* 台账 */
CREATE TABLE `yl_standing_book` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `type` enum('党员大会','支委会','党小组会','党课','主题党日','组织生活会','其他') NOT NULL DEFAULT '党员大会' COMMENT '类型',
  `organ_id` int(10) unsigned NOT NULL COMMENT '活动党组织ID，关联ORGAN表ID',
  `theme` varchar(50) NOT NULL DEFAULT '' COMMENT '主题',
  `start_time` datetime NOT NULL COMMENT '开始时间',
  `end_time` datetime NOT NULL COMMENT '结束时间',
  `address` varchar(100) NOT NULL DEFAULT '' COMMENT '地点',
  `agenda` varchar(2000) NOT NULL DEFAULT '' COMMENT '议程',
  `hoster` varchar(50) NOT NULL DEFAULT '' COMMENT '主持人',
  `status` enum('草稿','未开始','进行中','已完成') NOT NULL DEFAULT '草稿' COMMENT '状态',
  `scope` varchar(50) NOT NULL DEFAULT '' COMMENT '参与范围描述',
  `uuid` char(32) NOT NULL COMMENT '计划提交人',
  `ctime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '提交时间',
  `qr_sign` varchar(60) NOT NULL DEFAULT '' COMMENT '保存后生成签到二维码',
  `plan_id` int(10) unsigned NOT NULL COMMENT '计划ID，关联PLAN表ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='台账基础表';

CREATE TABLE `yl_standing_book_sign_in` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `standing_book_id` int(10) unsigned NOT NULL COMMENT '台账ID，关联standing_book表ID',
  `uuid` char(32) NOT NULL COMMENT '签到人员UUID',
  `status` enum('正常','补签','缺席','请假') NOT NULL DEFAULT '正常' COMMENT '签到状态',
  `ctime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '签到时间',
  `manager_uuid` char(32) NOT NULL COMMENT '补签管理员',
  `stime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '补签时间',
  `remark` varchar(200) NOT NULL DEFAULT '' COMMENT '备注',
  `user_type` enum('参加人员','其他人员') NOT NULL DEFAULT '参加人员' COMMENT '人员类型',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='台账签到表';

CREATE TABLE `yl_standing_book_vote` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `standing_book_id` int(10) unsigned NOT NULL COMMENT '台账ID，关联standing_book表ID',
  `type` enum('consult','vote') NOT NULL DEFAULT 'consult' COMMENT '表决形式,consult-事项征询,vote-人物评选',
  `vote_id` int(10) unsigned NOT NULL COMMENT '关联征询表或评选表ID',
  `is_open` char(0) COMMENT '是否公开',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='台账表决表';

CREATE TABLE `yl_standing_book_documents` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `standing_book_id` int(10) unsigned NOT NULL COMMENT '台账ID，关联standing_book表ID',
  `documents_id` int(10) unsigned NOT NULL COMMENT '文档ID，关联documents表ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='台账会议文档表';

CREATE TABLE `yl_standing_book_material` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `standing_book_id` int(10) unsigned NOT NULL COMMENT '台账ID，关联standing_book表ID',
  `vid` varchar(20) NOT NULL COMMENT '点播VID，关联VOD表VID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='台账会议实况表';

CREATE TABLE `yl_standing_book_note` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `standing_book_id` int(10) unsigned NOT NULL COMMENT '台账ID，关联standing_book表ID',
  `person` varchar(50) NOT NULL COMMENT '记录人员',
  `content` varchar(2000) NOT NULL COMMENT '记录内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='台账会议记录表';

CREATE TABLE `yl_standing_book_summary` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `standing_book_id` int(10) unsigned NOT NULL COMMENT '台账ID，关联standing_book表ID',
  `summary` varchar(2000) NOT NULL COMMENT '心得体会',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='台账心得体会表';

CREATE TABLE `yl_standing_book_test` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `standing_book_id` int(10) unsigned NOT NULL COMMENT '台账ID，关联standing_book表ID',
  `online_test_id` int(10) unsigned NOT NULL COMMENT '在线测试ID，关联online_test表ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='台账在线测试表';

/* 征询、评选、测试 */
CREATE TABLE `yl_consult` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `c_title` varchar(101) NOT NULL DEFAULT '' COMMENT '征询标题',
  `c_pic` varchar(201) NOT NULL DEFAULT '' COMMENT '有图征询图片',
  `c_content` varchar(301) NOT NULL DEFAULT '' COMMENT '征询内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='事项征询表';

CREATE TABLE `yl_consult_option` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `consult_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '征询ID，对应consult表ID',
  `option_desc` varchar(301) NOT NULL DEFAULT '' COMMENT '选项描述',
  `vote_number` mediumint(8) NOT NULL DEFAULT '0' COMMENT '投票数',
  `consult_adj` mediumint(8) NOT NULL DEFAULT '0' COMMENT '微调票数，可以是负数',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='征询选项表';

CREATE TABLE `yl_consult_record` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `consult_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '征询ID，对应consult表ID',
  `option_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '征询选项,对应option表ID',
  `uuid` varchar(32) NOT NULL DEFAULT '' COMMENT '用户uuid，关联user表uuid,主要用于移动和h5端',
  `stb_type` enum('stb_id','ca_no','stb_ip') NOT NULL DEFAULT 'stb_id' COMMENT '机顶盒唯一标识类型',
  `stb_id` varchar(51) NOT NULL DEFAULT '' COMMENT '机顶盒唯一标识',
  `join_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00' COMMENT '投票时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='征询结果表';

CREATE TABLE `yl_vote` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `title` varchar(101) NOT NULL DEFAULT '' COMMENT '参选者名称',
  `pic` varchar(201) NOT NULL DEFAULT '' COMMENT '参选者照片',
  `content` varchar(3002) NOT NULL DEFAULT '' COMMENT '参选者简介',
  `vote_number` mediumint(8) NOT NULL DEFAULT '0' COMMENT '当前累计票数',
  `vote_adj` mediumint(8) NOT NULL DEFAULT '0' COMMENT '微调票数，可以是负数',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='人物评选表';

CREATE TABLE `yl_vote_record` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `uuid` varchar(32) NOT NULL DEFAULT '' COMMENT '用户uuid，关联user表uuid,主要用于移动和h5端',
  `stb_type` enum('stb_id','ca_no','stb_ip') NOT NULL DEFAULT 'stb_id' COMMENT '机顶盒唯一标识类型',
  `stb_id` varchar(51) NOT NULL DEFAULT '' COMMENT '机顶盒唯一标识',
  `join_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00' COMMENT '答题时间',
  `vote_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '评选选项ID, 对应vote表ID',
  `score` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='评选结果表';

CREATE TABLE `yl_online_test` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `title` varchar(51) NOT NULL COMMENT '标题',
  `desc` varchar(2000) NOT NULL COMMENT '描述',
  `icon_path` varchar(200) NOT NULL COMMENT '封面',
  `question_ids` varchar(200) NOT NULL COMMENT '测试包含的所有题目id集合，多个用逗号隔开',
  `is_limit` enum('y','n') NOT NULL DEFAULT 'n' COMMENT '是否限时答题',
  `start_time` datetime NOT NULL COMMENT '开始时间',
  `end_time` datetime NOT NULL COMMENT '结束时间',
  `creator_uuid` char(32) NOT NULL COMMENT '创建者',
  `ctime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='在线测试表';

CREATE TABLE `yl_question` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `type` enum('单选','多选','是非题') NOT NULL DEFAULT '单选' COMMENT '题目类型',
  `ques_title` varchar(101) NOT NULL DEFAULT '' COMMENT '问题标题',
  `ques_content` varchar(301) NOT NULL DEFAULT '' COMMENT '问题描述',
  `ques_pic` varchar(101) NOT NULL DEFAULT '' COMMENT '图片',
  `standard_answer` varchar(21) NOT NULL DEFAULT '' COMMENT '问题标准答案',
  `score` tinyint(2) NOT NULL DEFAULT '0' COMMENT '分数',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='题目表';

CREATE TABLE `yl_question_option` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `question_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '题目ID，对应question表ID',
  `option_name` char(1) NOT NULL DEFAULT '' COMMENT '选项名',
  `option_value` varchar(301) NOT NULL DEFAULT '' COMMENT '选项值',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='题目选项表';

CREATE TABLE `yl_question_record` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `question_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '题目ID, 对应question表ID',
  `quesopt_name` varchar(11) NOT NULL COMMENT '题目答案,对应question_option表name，多个name以逗号隔开',
  `uuid` char(32) NOT NULL DEFAULT '' COMMENT '用户uuid，关联user表uuid,主要用于移动和h5端',
  `stb_type` enum('stb_id','ca_no','stb_ip') NOT NULL DEFAULT 'stb_id' COMMENT '机顶盒唯一标识类型',
  `stb_id` varchar(51) NOT NULL DEFAULT '' COMMENT '机顶盒唯一标识',
  `score` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '答对该题获得的分值',
  `join_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00' COMMENT '答题时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='答题结果表';