-- MySQL dump 10.13  Distrib 5.7.12, for Win64 (x86_64)
--
-- Host: localhost    Database: kyytx20190416
-- ------------------------------------------------------
-- Server version	5.7.12

/*!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 `ta01xtpz`
--

DROP TABLE IF EXISTS `ta01xtpz`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ta01xtpz` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `fisize` int(2) NOT NULL DEFAULT '12',
  `fntzxx` text,
  `fbsfzc` bit(1) NOT NULL DEFAULT b'0',
  `fbsfsh` bit(1) NOT NULL DEFAULT b'0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ta01xtpz`
--

LOCK TABLES `ta01xtpz` WRITE;
/*!40000 ALTER TABLE `ta01xtpz` DISABLE KEYS */;
INSERT INTO `ta01xtpz` VALUES (1,12,'欢迎使用预约天下','','\0');
/*!40000 ALTER TABLE `ta01xtpz` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ta02yhmc`
--

DROP TABLE IF EXISTS `ta02yhmc`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ta02yhmc` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `fvyhgh` varchar(10) NOT NULL DEFAULT '工号',
  `fvyhxm` varchar(20) NOT NULL DEFAULT '姓名',
  `fvyhmm` varchar(64) NOT NULL DEFAULT '密码',
  `fvyhdh` varchar(20) NOT NULL DEFAULT '电话',
  `fvyhyx` varchar(255) NOT NULL DEFAULT '邮箱',
  `fvwxhm` varchar(50) NOT NULL DEFAULT '微信号',
  `fvyhsm` varchar(255) NOT NULL DEFAULT '说明',
  `fbsfky` bit(1) NOT NULL DEFAULT b'1',
  `fiyhly` int(1) NOT NULL DEFAULT '1',
  `fiyhlx` int(1) NOT NULL DEFAULT '2',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ta02yhmc`
--

LOCK TABLES `ta02yhmc` WRITE;
/*!40000 ALTER TABLE `ta02yhmc` DISABLE KEYS */;
INSERT INTO `ta02yhmc` VALUES (1,'0000','帐号','dd4b21e9ef71e1291183a46b913ae6f2','13703351111','0000@hevttc.edu.cn','微信号','说明','\0',1,100),(2,'0001','高管','1c7c54925f153e0aaa12758d70af17d2','17733502897','0001@hevttc.edu.cn','17733502897','网站系统高级管理员','',1,0),(3,'3151','赵学作','b2240900bcc006fec82ce5c6212ced8f','13703353520','25295110@qq.com','教育学院','教育学院教师','',1,1),(6,'0005','测试教师','c40efb7887bb31e8b53ae82345f765f2','13703353522','0003@hevttc.edu.cn','13703353522','无','',3,1),(8,'0006','0005A','c4e03c1467e950f9e5873b6bd0895ea7','12345678901','0006@hevttc.edu.cn','12345678901','无','',2,1);
/*!40000 ALTER TABLE `ta02yhmc` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ta03rzjl`
--

DROP TABLE IF EXISTS `ta03rzjl`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ta03rzjl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `firyid` bigint(20) NOT NULL,
  `fdydsj` datetime NOT NULL DEFAULT '2019-04-15 11:08:00',
  `ftcznr` varchar(255) NOT NULL DEFAULT '操作内容',
  `fvdlip` varchar(15) NOT NULL DEFAULT '000.000.000.000',
  PRIMARY KEY (`id`),
  KEY `ta03rzjl_firyid_ta02yhmc_1` (`firyid`),
  CONSTRAINT `ta03rzjl_firyid_ta02yhmc_1` FOREIGN KEY (`firyid`) REFERENCES `ta02yhmc` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ta03rzjl`
--

LOCK TABLES `ta03rzjl` WRITE;
/*!40000 ALTER TABLE `ta03rzjl` DISABLE KEYS */;
INSERT INTO `ta03rzjl` VALUES (1,3,'2019-04-16 11:45:51','电脑自动登录','::1'),(2,2,'2019-04-16 11:46:15','高管  登录成功!','::1'),(3,2,'2019-04-16 11:46:57','电脑自动登录','::1'),(4,2,'2019-04-16 11:49:22','电脑自动登录','::1'),(5,2,'2019-04-16 11:50:34','电脑自动登录','::1'),(6,2,'2019-04-16 11:52:00','电脑自动登录','::1'),(19,2,'2019-04-16 14:14:43','0001【高管】  成功修改资料!','::1'),(20,2,'2019-04-16 14:15:09','成功初始密码：0003【测试教师】','::1'),(21,2,'2019-04-16 14:15:19','成功修改用户：4--0003【测试教师】','::1'),(22,2,'2019-04-16 14:16:05','成功修改用户：4--0003【测试教师】','::1'),(23,2,'2019-04-16 14:19:07','电脑自动登录','::1'),(36,2,'2019-04-16 14:37:41','电脑自动登录','::1'),(37,2,'2019-04-16 14:39:30','电脑自动登录','::1'),(38,2,'2019-04-16 14:41:46','电脑自动登录','::1'),(39,2,'2019-04-16 15:12:58','电脑自动登录','::1'),(40,2,'2019-04-16 15:50:12','电脑自动登录','::1'),(41,2,'2019-04-16 15:58:06','电脑自动登录','::1'),(42,2,'2019-04-16 15:58:29','备份成功！qhdeduwggl.sql','::1'),(43,2,'2019-04-16 15:58:33','删除成功！AU_20190326153740.zip','::1'),(44,2,'2019-04-16 15:58:38','删除成功！BD_20190326112646.sql','::1'),(45,2,'2019-04-16 15:58:42','删除成功！BD_20190326153359.sql','::1'),(46,2,'2019-04-16 15:58:45','删除成功！BD_20190326153734.sql','::1'),(47,2,'2019-04-16 15:58:47','备份成功！BD_20190416155847.sql','::1');
/*!40000 ALTER TABLE `ta03rzjl` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb04dxmc`
--

DROP TABLE IF EXISTS `tb04dxmc`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb04dxmc` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `fvdxmc` varchar(50) NOT NULL DEFAULT '教室名称',
  `fvdxsm` varchar(255) NOT NULL DEFAULT '教室说明',
  `fiplsx` int(2) NOT NULL DEFAULT '0',
  `figlid` bigint(20) NOT NULL,
  `fidxsl` int(2) NOT NULL DEFAULT '1',
  `fiyysl` int(2) NOT NULL DEFAULT '1',
  `fipbxm` int(2) NOT NULL DEFAULT '1',
  `fixdsc` int(1) NOT NULL DEFAULT '0',
  `fixszs` int(2) NOT NULL DEFAULT '20',
  `ftjcsz` text,
  PRIMARY KEY (`id`),
  KEY `tb04dxmc_figlid_ta02yhmc_1` (`figlid`),
  CONSTRAINT `tb04dxmc_figlid_ta02yhmc_1` FOREIGN KEY (`figlid`) REFERENCES `ta02yhmc` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb04dxmc`
--

LOCK TABLES `tb04dxmc` WRITE;
/*!40000 ALTER TABLE `tb04dxmc` DISABLE KEYS */;
INSERT INTO `tb04dxmc` VALUES (1,'养生堂针灸室','养生堂针灸室1',1,3,1,1,1,1,20,'8点段|9点段|10点段|11点段|12点段|2点段|3点段|4点段|5点段|6点段|7点段'),(2,'按摩师','养生堂按摩1',2,3,1,1,1,1,20,'8点段|9点段|10点段|11点段|12点段|2点段|3点段|4点段|5点段|6点段|7点段'),(3,'理疗室','养生堂理疗室6',3,3,6,6,1,0,12,'8-10点段|10-12点段|2-4点段|4-7点段|晚上时段');
/*!40000 ALTER TABLE `tb04dxmc` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb05pljy`
--

DROP TABLE IF EXISTS `tb05pljy`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb05pljy` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `fidxid` bigint(20) NOT NULL,
  `fijylx` int(1) NOT NULL DEFAULT '1',
  `fijyxh` int(1) NOT NULL DEFAULT '6',
  `fvjyks` varchar(8) NOT NULL DEFAULT '00000000',
  `fvjyjs` varchar(8) NOT NULL DEFAULT '00000000',
  PRIMARY KEY (`id`),
  KEY `tb05pljy_fidxid_tb04dxmc_1` (`fidxid`),
  CONSTRAINT `tb05pljy_fidxid_tb04dxmc_1` FOREIGN KEY (`fidxid`) REFERENCES `tb04dxmc` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb05pljy`
--

LOCK TABLES `tb05pljy` WRITE;
/*!40000 ALTER TABLE `tb05pljy` DISABLE KEYS */;
INSERT INTO `tb05pljy` VALUES (1,1,1,6,'00000000','00000000'),(2,1,1,7,'00000000','00000000'),(3,1,2,4,'00000000','00000000'),(4,2,1,6,'00000000','00000000'),(5,2,1,7,'00000000','00000000'),(6,2,2,4,'00000000','00000000');
/*!40000 ALTER TABLE `tb05pljy` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb06yyjh`
--

DROP TABLE IF EXISTS `tb06yyjh`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb06yyjh` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `fidxid` bigint(20) NOT NULL,
  `firyid` bigint(20) NOT NULL,
  `fvrqbm` varchar(8) NOT NULL DEFAULT '00000000',
  `fijcxh` int(1) NOT NULL DEFAULT '0',
  `fidxsl` int(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `tb06yyjh_firyid_ta02yhmc_1` (`firyid`),
  KEY `tb06yyjh_fidxid_tb04dxmc_1` (`fidxid`),
  CONSTRAINT `tb06yyjh_fidxid_tb04dxmc_1` FOREIGN KEY (`fidxid`) REFERENCES `tb04dxmc` (`id`),
  CONSTRAINT `tb06yyjh_firyid_ta02yhmc_1` FOREIGN KEY (`firyid`) REFERENCES `ta02yhmc` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb06yyjh`
--

LOCK TABLES `tb06yyjh` WRITE;
/*!40000 ALTER TABLE `tb06yyjh` DISABLE KEYS */;
INSERT INTO `tb06yyjh` VALUES (1,1,3,'20190415',1,0),(2,1,3,'20190416',1,0);
/*!40000 ALTER TABLE `tb06yyjh` 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-04-16 15:58:48
