z202109g06/TMM/sql/teamessage.sql

/*
 Navicat Premium Data Transfer

 Source Server         : fan
 Source Server Type    : MySQL
 Source Server Version : 80019
 Source Host           : localhost:3306
 Source Schema         : teamessage

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

 Date: 16/11/2021 16:17:26
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

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

-- ----------------------------
-- Records of article
-- ----------------------------
INSERT INTO `article` VALUES (1, '张三', '论法外狂徒', '诺贝尔文学奖');
INSERT INTO `article` VALUES (2, '李四', '如何守护世界和平', '和平奖');
INSERT INTO `article` VALUES (3, '阿大撒', '阿四', '阿萨大');
INSERT INTO `article` VALUES (4, '阿萨大', '阿萨大', '阿萨大');

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

-- ----------------------------
-- Records of keyanproject
-- ----------------------------
INSERT INTO `keyanproject` VALUES (1, '档案管理系统', '2021-11-16 00:00:00', 'abc');
INSERT INTO `keyanproject` VALUES (2, 'asda', '2021-11-02 00:00:00', 'asd');
INSERT INTO `keyanproject` VALUES (3, '业绩项目', '2021-11-17 00:00:00', 'abc');

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

-- ----------------------------
-- Records of teachclass
-- ----------------------------
INSERT INTO `teachclass` VALUES (2, 'JAVA开发', 'ab', '56');

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

-- ----------------------------
-- Records of teachermessage
-- ----------------------------
INSERT INTO `teachermessage` VALUES (1, '陈老师', '20', '男');
INSERT INTO `teachermessage` VALUES (2, '李老师', '23', '男');
INSERT INTO `teachermessage` VALUES (3, '李四', '56', '男');
INSERT INTO `teachermessage` VALUES (4, '王五', '35', '男');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('张三', '5622');
INSERT INTO `user` VALUES ('张三', '5622');

SET FOREIGN_KEY_CHECKS = 1;