z202109g06/teamessage.sql

/*
 Navicat Premium Data Transfer

 Source Server         : test
 Source Server Type    : MySQL
 Source Server Version : 50562
 Source Host           : localhost:3306
 Source Schema         : teamessage

 Target Server Type    : MySQL
 Target Server Version : 50562
 File Encoding         : 65001

 Date: 30/11/2021 10:43:48
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for article
-- ----------------------------
DROP TABLE IF EXISTS `article`;
CREATE TABLE `article`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `authArticle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  `titleArticle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  `prizeArticle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Compact;

-- ----------------------------
-- Records of article
-- ----------------------------
INSERT INTO `article` VALUES (1, '鲁迅', '朝花夕拾', '诺贝尔文学奖');
INSERT INTO `article` VALUES (3, '刘庆', '粒子运动', '新青年科学奖');
INSERT INTO `article` VALUES (5, '李欢', '重力在不同环境下的变化', '新科技奖');
INSERT INTO `article` VALUES (6, '林生', '环保装置的多重利用设计', '青年新概念创新奖');

-- ----------------------------
-- Table structure for keyanproject
-- ----------------------------
DROP TABLE IF EXISTS `keyanproject`;
CREATE TABLE `keyanproject`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `projectName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  `projectDate` datetime NULL DEFAULT NULL,
  `projectAuthor` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Compact;

-- ----------------------------
-- Records of keyanproject
-- ----------------------------
INSERT INTO `keyanproject` VALUES (1, '管理项目', '2021-11-16 00:00:00', 'AA');
INSERT INTO `keyanproject` VALUES (3, '粒子极限速度测试', '2021-07-14 00:00:00', '林老师');
INSERT INTO `keyanproject` VALUES (4, '粒子碰撞试验', '2021-02-10 00:00:00', '燕老师');
INSERT INTO `keyanproject` VALUES (5, '电子与质子的速度测试', '2021-10-11 00:00:00', '方老师');

-- ----------------------------
-- Table structure for teachclass
-- ----------------------------
DROP TABLE IF EXISTS `teachclass`;
CREATE TABLE `teachclass`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ClassName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  `ClassTeacherName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  `ClassTime` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Compact;

-- ----------------------------
-- Records of teachclass
-- ----------------------------
INSERT INTO `teachclass` VALUES (5, 'UI课程', '林老师', '45分钟');
INSERT INTO `teachclass` VALUES (6, 'java项目', '黄老师', '50分钟');
INSERT INTO `teachclass` VALUES (7, 'web课程', '方老师', '50分钟');
INSERT INTO `teachclass` VALUES (8, 'python爬虫', '晋老师', '50分钟');

-- ----------------------------
-- Table structure for teachermessage
-- ----------------------------
DROP TABLE IF EXISTS `teachermessage`;
CREATE TABLE `teachermessage`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `TeaName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  `TeaAge` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  `TeaSex` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Compact;

-- ----------------------------
-- Records of teachermessage
-- ----------------------------
INSERT INTO `teachermessage` VALUES (3, '李老师', '23', '男');
INSERT INTO `teachermessage` VALUES (5, '陈老师', '23', '女');
INSERT INTO `teachermessage` VALUES (6, '黄老师', '26', '男');
INSERT INTO `teachermessage` VALUES (7, '车老师', '28', '女');
INSERT INTO `teachermessage` VALUES (8, '房老师', '34', '男');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Compact;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, '张三', '123');
INSERT INTO `user` VALUES (2, '张三', '123');
INSERT INTO `user` VALUES (3, 'zhangsan', '123');
INSERT INTO `user` VALUES (4, 'zhang', '123');

SET FOREIGN_KEY_CHECKS = 1;