DB_51Aspx/ssm13f51.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

-- MySQL dump 10.13  Distrib 5.7.31, for Linux (x86_64)
--
-- Host: localhost    Database: ssm13f51
-- ------------------------------------------------------
-- Server version	5.7.31

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `ceshijieguo`
--

DROP TABLE IF EXISTS `ceshijieguo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ceshijieguo` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `bianhao` varchar(200) NOT NULL COMMENT '编号',
  `mingcheng` varchar(200) DEFAULT NULL COMMENT '名称',
  `xuehao` varchar(200) DEFAULT NULL COMMENT '学号',
  `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
  `jiankangchengdu` varchar(200) DEFAULT NULL COMMENT '健康程度',
  `ceshijieguo` longtext COMMENT '测试结果',
  `jianyi` longtext COMMENT '建议',
  `zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',
  `zixunshixingming` varchar(200) DEFAULT NULL COMMENT '咨询师姓名',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8 COMMENT='测试结果';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ceshijieguo`
--

LOCK TABLES `ceshijieguo` WRITE;
/*!40000 ALTER TABLE `ceshijieguo` DISABLE KEYS */;
INSERT INTO `ceshijieguo` VALUES (71,'2021-01-08 03:12:14','编号1','名称1','学号1','姓名1','正常','测试结果1','建议1','账号1','咨询师姓名1'),(72,'2021-01-08 03:12:14','编号2','名称2','学号2','姓名2','正常','测试结果2','建议2','账号2','咨询师姓名2'),(73,'2021-01-08 03:12:14','编号3','名称3','学号3','姓名3','正常','测试结果3','建议3','账号3','咨询师姓名3'),(74,'2021-01-08 03:12:14','编号4','名称4','学号4','姓名4','正常','测试结果4','建议4','账号4','咨询师姓名4'),(75,'2021-01-08 03:12:14','编号5','名称5','学号5','姓名5','正常','测试结果5','建议5','账号5','咨询师姓名5'),(76,'2021-01-08 03:12:14','编号6','名称6','学号6','姓名6','正常','测试结果6','建议6','账号6','咨询师姓名6');
/*!40000 ALTER TABLE `ceshijieguo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ceshitimu`
--

DROP TABLE IF EXISTS `ceshitimu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ceshitimu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',