/*
Navicat MySQL Data Transfer

Source Server         : 阿里云
Source Server Version : 50728
Source Host           : 182.92.98.89:3306
Source Database       : SuperDir

Target Server Type    : MYSQL
Target Server Version : 50728
File Encoding         : 65001

Date: 2021-07-06 23:11:55
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for Dir
-- ----------------------------
DROP TABLE IF EXISTS `Dir`;
CREATE TABLE `Dir` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `intro` longtext NOT NULL,
  `title1` varchar(255) DEFAULT NULL,
  `title2` varchar(255) DEFAULT NULL,
  `title3` varchar(255) DEFAULT NULL,
  `collect` int(11) NOT NULL DEFAULT '1',
  `title1_content` varchar(255) DEFAULT NULL,
  `title2_content` varchar(255) DEFAULT NULL,
  `title3_content` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name_ind` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for Dir_new
-- ----------------------------
DROP TABLE IF EXISTS `Dir_new`;
CREATE TABLE `Dir_new` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `intro` longtext NOT NULL,
  `fieldData` longtext,
  `collect` int(11) NOT NULL DEFAULT '1',
  `fileNum` int(11) unsigned DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name_ind` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for poster
-- ----------------------------
DROP TABLE IF EXISTS `poster`;
CREATE TABLE `poster` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rev_content` longtext,
  `confirm_content` longtext,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for questions
-- ----------------------------
DROP TABLE IF EXISTS `questions`;
CREATE TABLE `questions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `question` varchar(255) DEFAULT NULL,
  `A` varchar(255) DEFAULT NULL,
  `B` varchar(255) DEFAULT NULL,
  `C` varchar(255) DEFAULT NULL,
  `D` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for st
-- ----------------------------
DROP TABLE IF EXISTS `st`;
CREATE TABLE `st` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `num` int(11) DEFAULT NULL,
  `plate` int(11) DEFAULT NULL,
  `_describe` varchar(255) DEFAULT NULL,
  `score` int(11) DEFAULT NULL,
  `level` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=188 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `_class` varchar(255) DEFAULT NULL,
  `dmt` varchar(255) DEFAULT NULL,
  `wechat` varchar(255) DEFAULT NULL,
  `part` varchar(255) DEFAULT NULL,
  `group` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=235 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for student_all
-- ----------------------------
DROP TABLE IF EXISTS `student_all`;
CREATE TABLE `student_all` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=178 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for student_positive
-- ----------------------------
DROP TABLE IF EXISTS `student_positive`;
CREATE TABLE `student_positive` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `aca` varchar(255) DEFAULT NULL,
  `_class` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `grade` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1021 DEFAULT CHARSET=utf8mb4;