text: -- MySQL dump 10.13  Distrib 5.6.42, for Linux (x86_64)
  --
  -- Host: localhost    Database: sign_myzju_cn
  -- ------------------------------------------------------
  -- Server version	5.6.42-log
  
  /*!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 `class`
  --
  
  DROP TABLE IF EXISTS `class`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `class` (
    `detailId` int(11) NOT NULL AUTO_INCREMENT,
    `courseId` varchar(20) NOT NULL,
    `section` int(11) NOT NULL,
    `sectionSpan` int(11) NOT NULL,
    `week` int(11) NOT NULL,
    `classRoom` varchar(80) NOT NULL,
    PRIMARY KEY (`detailId`)
  ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `class`
  --
  
  LOCK TABLES `class` WRITE;
  /*!40000 ALTER TABLE `class` DISABLE KEYS */;
  INSERT INTO `class` VALUES (1,'c1',1,4,5,'理四220'),(2,'c2',6,3,3,'理四224'),(3,'c3',1,2,2,'理四220'),(4,'c3',6,2,4,'理四220'),(5,'c4',6,2,5,'教5-205');
  /*!40000 ALTER TABLE `class` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `course`
  --
  
  DROP TABLE IF EXISTS `course`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `course` (
    `courseId` varchar(20) NOT NULL,
    `cname` varchar(50) NOT NULL,
    `des` text NOT NULL,
    `tno` varchar(20) NOT NULL,
    PRIMARY KEY (`courseId`) USING BTREE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `course`
  --
  
  LOCK TABLES `course` WRITE;
  /*!40000 ALTER TABLE `course` DISABLE KEYS */;
  INSERT INTO `course` VALUES ('c1','智能终端与移动应用开发','Android开发课程','pengbin'),('c2','物联网开发','物联网导论与物联网应用开发','caijp'),('c3','Java EE','java EE开发课程','pengbin'),('c4','计算机网络原理','讲解计算机网络结构与网络协议','caijp');
  /*!40000 ALTER TABLE `course` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `cs`
  --
  
  DROP TABLE IF EXISTS `cs`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `cs` (
    `csid` int(11) NOT NULL AUTO_INCREMENT,
    `courseid` varchar(20) NOT NULL,
    `sno` varchar(20) NOT NULL,
    PRIMARY KEY (`csid`) USING BTREE
  ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `cs`
  --
  
  LOCK TABLES `cs` WRITE;
  /*!40000 ALTER TABLE `cs` DISABLE KEYS */;
  INSERT INTO `cs` VALUES (1,'c1','31601081'),(2,'c1','31601082'),(3,'c2','31601081'),(4,'c2','31601082'),(5,'c3','31601081'),(6,'c3','31601082'),(7,'c4','31601081'),(8,'c4','31601082');
  /*!40000 ALTER TABLE `cs` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `sign`
  --
  
  DROP TABLE IF EXISTS `sign`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `sign` (
    `signid` int(11) NOT NULL AUTO_INCREMENT,
    `detailid` int(11) NOT NULL,
    `addtime` int(11) NOT NULL,
    `bssid` text NOT NULL,
    `endtime` int(11) DEFAULT NULL,
    PRIMARY KEY (`signid`)
  ) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `sign`
  --
  
  --
  -- Table structure for table `ss`
  --
  
  DROP TABLE IF EXISTS `ss`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `ss` (
    `ssid` int(11) NOT NULL AUTO_INCREMENT,
    `sno` varchar(20) NOT NULL,
    `signid` int(11) NOT NULL,
    `signtime` int(11) NOT NULL,
    PRIMARY KEY (`ssid`)
  ) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `ss`
  --
  
  --
  -- Table structure for table `student`
  --
  
  DROP TABLE IF EXISTS `student`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `student` (
    `sno` varchar(20) NOT NULL,
    `sname` varchar(50) NOT NULL,
    `pwd` varchar(50) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `student`
  --
  
  LOCK TABLES `student` WRITE;
  /*!40000 ALTER TABLE `student` DISABLE KEYS */;
  INSERT INTO `student` VALUES ('31601082','test',MD5('123456')),('31601081','test',MD5('123456'));
  /*!40000 ALTER TABLE `student` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `teacher`
  --
  
  DROP TABLE IF EXISTS `teacher`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `teacher` (
    `tno` varchar(50) NOT NULL,
    `tname` varchar(50) NOT NULL,
    `pwd` varchar(50) NOT NULL,
    PRIMARY KEY (`tno`),
    UNIQUE KEY `tno` (`tno`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `teacher`
  --
  
  LOCK TABLES `teacher` WRITE;
  /*!40000 ALTER TABLE `teacher` DISABLE KEYS */;
  INSERT INTO `teacher` VALUES ('admin','teacher',MD5('123456'));
  /*!40000 ALTER TABLE `teacher` ENABLE KEYS */;
  UNLOCK TABLES;
  /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  
  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  
  -- Dump completed on 2019-01-11  9:56:07
  