-- MySQL dump 10.13  Distrib 5.7.12, for Win64 (x86_64)
--
-- Host: localhost    Database: kkfgl20190610
-- ------------------------------------------------------
-- 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 `ta01yhmd`
--

DROP TABLE IF EXISTS `ta01yhmd`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ta01yhmd` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `fiyhlx` int(1) NOT NULL DEFAULT '1',
  `fvyhgh` varchar(10) NOT NULL DEFAULT '工号',
  `fvyhmm` varchar(64) NOT NULL DEFAULT '密码',
  `fvyhxm` varchar(20) NOT NULL DEFAULT '姓名',
  `fvyhyx` varchar(255) NOT NULL DEFAULT '邮箱',
  `fvyhsj` varchar(20) NOT NULL DEFAULT '手机',
  `fdhdsj` datetime NOT NULL DEFAULT '2019-06-09 16:23:00',
  `fizrst` int(4) NOT NULL DEFAULT '0',
  `fisize` int(2) NOT NULL DEFAULT '12',
  `fbjhqx` bit(1) NOT NULL DEFAULT b'0',
  `fbchqx` bit(1) NOT NULL DEFAULT b'0',
  `fbscqx` bit(1) NOT NULL DEFAULT b'0',
  `fvyhsm` varchar(255) NOT NULL DEFAULT '说明',
  `fbsfky` bit(1) NOT NULL DEFAULT b'1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ta01yhmd`
--

LOCK TABLES `ta01yhmd` WRITE;
/*!40000 ALTER TABLE `ta01yhmd` DISABLE KEYS */;
INSERT INTO `ta01yhmd` VALUES (1,100,'0000','00000000','帐号','0000@hevttc.edu.cn','13703351111','2019-06-13 17:45:18',0,12,'\0','\0','\0','说明','\0'),(2,0,'0001','1c7c54925f153e0aaa12758d70af17d2','高管','0001@hevttc.edu.cn','13703353520','2019-06-13 17:45:18',0,12,'\0','\0','\0','系统高级管理员，不可删除',''),(3,1,'0002','385f6dc4bb8ab29a6a67dfdf6baff779','操作员2','0002@hevttc.edu.cn','13703353521','2019-06-13 17:45:18',0,12,'\0','\0','\0','操作员1，不必删除，请在此基础上修改即可',''),(4,1,'3151','df6323471582133d0216b208ae56a6fd','赵学作','25295110@qq.com','13703353522','2019-06-13 17:45:18',0,12,'\0','\0','\0','操作员2，不必删除，请在此基础上修改即可','');
/*!40000 ALTER TABLE `ta01yhmd` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ta02xtpz`
--

DROP TABLE IF EXISTS `ta02xtpz`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ta02xtpz` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `fidhsx` int(2) NOT NULL DEFAULT '12',
  `fitsts` int(2) NOT NULL DEFAULT '15',
  `fvtzxx` varchar(255) NOT NULL DEFAULT '通知信息',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ta02xtpz`
--

LOCK TABLES `ta02xtpz` WRITE;
/*!40000 ALTER TABLE `ta02xtpz` DISABLE KEYS */;
INSERT INTO `ta02xtpz` VALUES (1,13,16,'易得优软件感谢您的信任');
/*!40000 ALTER TABLE `ta02xtpz` 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-06-09 17:46:00',
  `fvczsm` varchar(255) NOT NULL DEFAULT '操作内容',
  `fvdlip` varchar(15) NOT NULL DEFAULT '000.000.000.000',
  PRIMARY KEY (`id`),
  KEY `ta03rzjl_firyid_ta01yhmd_1` (`firyid`),
  CONSTRAINT `ta03rzjl_firyid_ta01yhmd_1` FOREIGN KEY (`firyid`) REFERENCES `ta01yhmd` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=44 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,2,'2019-06-14 10:02:00','高管  登录成功!','::1'),(2,2,'2019-06-14 10:06:58','高管  登录成功!','::1'),(3,2,'2019-06-14 10:14:29','高管  登录成功!','::1'),(4,2,'2019-06-14 11:00:06','高管  登录成功!','::1'),(29,2,'2019-06-16 15:33:51','电脑自动登录','::1'),(30,2,'2019-06-16 16:26:35','高管  登录成功!','::1'),(31,2,'2019-06-16 16:28:11','电脑自动登录','::1'),(32,2,'2019-06-16 16:43:33','成功修改系统设置','::1'),(33,2,'2019-06-16 16:43:45','成功修改系统设置','::1'),(34,2,'2019-06-16 16:44:30','备份成功！qhdeduwggl.sql','::1'),(35,2,'2019-06-16 16:44:37','备份成功！BD_20190616164437.sql','::1'),(36,2,'2019-06-16 16:44:53','删除成功！BD_20190616164437.sql','::1'),(37,2,'2019-06-16 16:46:39','电脑自动登录','::1'),(38,2,'2019-06-16 16:46:52','备份成功！BD_20190616164651.sql','::1'),(39,2,'2019-06-16 16:51:54','电脑自动登录','::1'),(40,2,'2019-06-16 16:51:58','备份成功！qhdeduwggl.sql','::1'),(41,2,'2019-06-16 16:52:03','备份成功！BD_20190616165203.sql','::1'),(42,2,'2019-06-16 16:57:05','电脑自动登录','::1'),(43,2,'2019-06-16 16:57:08','备份成功！BD_20190616165708.sql','::1');
/*!40000 ALTER TABLE `ta03rzjl` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ta04stsz`
--

DROP TABLE IF EXISTS `ta04stsz`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ta04stsz` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `fvstmc` varchar(50) NOT NULL DEFAULT '食堂名称',
  `fvcode` varchar(50) NOT NULL DEFAULT '首字母助记码',
  `fiplsx` int(2) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ta04stsz`
--

LOCK TABLES `ta04stsz` WRITE;
/*!40000 ALTER TABLE `ta04stsz` DISABLE KEYS */;
INSERT INTO `ta04stsz` VALUES (1,'第一食堂','dyst',1),(2,'第二食堂','dest',2),(3,'小餐厅','xct',3);
/*!40000 ALTER TABLE `ta04stsz` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ta05hplb`
--

DROP TABLE IF EXISTS `ta05hplb`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ta05hplb` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `fvhpmc` varchar(100) NOT NULL DEFAULT '货品名称',
  `fvcode` varchar(100) NOT NULL DEFAULT '助记码',
  `fvhplb` varchar(50) NOT NULL DEFAULT '类别',
  `fvghsm` varchar(100) NOT NULL DEFAULT '供货商',
  `fvscsm` varchar(100) NOT NULL DEFAULT '生产商',
  `fvdwmc` varchar(20) NOT NULL DEFAULT '单位名称',
  `fikcsx` int(4) NOT NULL DEFAULT '100',
  `fikcxx` int(4) NOT NULL DEFAULT '0',
  `fishid` bigint(20) NOT NULL,
  `fvszda` varchar(100) NOT NULL DEFAULT '三证档案',
  `ftjhsj` datetime NOT NULL DEFAULT '2019-06-09 18:27:00',
  `fvbzsm` varchar(255) NOT NULL DEFAULT '备注说明规格',
  PRIMARY KEY (`id`),
  KEY `ta05hplb_fishid_ta01yhmd_1` (`fishid`),
  CONSTRAINT `ta05hplb_fishid_ta01yhmd_1` FOREIGN KEY (`fishid`) REFERENCES `ta01yhmd` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ta05hplb`
--

LOCK TABLES `ta05hplb` WRITE;
/*!40000 ALTER TABLE `ta05hplb` DISABLE KEYS */;
INSERT INTO `ta05hplb` VALUES (1,'新五常大米（100斤）','xwcdm100','粮食','供货商A','五常大米','袋',100,10,3,'三证档案：20190609','2019-06-13 17:45:18','100斤/袋'),(2,'鹏泰面粉（50斤）','ptmf50','粮食','供货商A','鹏泰面粉','袋',60,10,3,'三证档案：20190610','2019-06-13 17:45:18','50斤/袋'),(3,'白菜','bc','蔬菜','供货商B','生产商A','斤',60,10,3,'三证档案：20190610','2019-06-13 17:45:18','大白菜'),(4,'鲁花色拉油（30斤）','lhsly30','油料','供货商B','鲁花','桶',20,5,3,'三证档案：20190610','2019-06-13 17:45:18','鲁花色拉油30斤每桶');
/*!40000 ALTER TABLE `ta05hplb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ta06rklb`
--

DROP TABLE IF EXISTS `ta06rklb`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ta06rklb` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `fihpid` bigint(20) NOT NULL,
  `fvrkbm` varchar(18) NOT NULL DEFAULT '入库编码18',
  `ftyxrq` datetime NOT NULL DEFAULT '2019-06-09 18:55:00',
  `firkid` bigint(20) NOT NULL,
  `firksl` int(11) NOT NULL DEFAULT '0',
  `fdjhjz` decimal(24,2) NOT NULL,
  `fvbzsm` varchar(255) NOT NULL DEFAULT '备注说明规格',
  PRIMARY KEY (`id`),
  KEY `ta06rklb_fihpid_ta05hplb_1` (`fihpid`),
  CONSTRAINT `ta06rklb_fihpid_ta05hplb_1` FOREIGN KEY (`fihpid`) REFERENCES `ta05hplb` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ta06rklb`
--

LOCK TABLES `ta06rklb` WRITE;
/*!40000 ALTER TABLE `ta06rklb` DISABLE KEYS */;
INSERT INTO `ta06rklb` VALUES (1,4,'201906121435210001','2020-06-13 17:45:18',3,22,156.00,'备注说明规格');
/*!40000 ALTER TABLE `ta06rklb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ta07kclb`
--

DROP TABLE IF EXISTS `ta07kclb`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ta07kclb` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `fihpid` bigint(20) NOT NULL,
  `fvrkbm` varchar(18) NOT NULL DEFAULT '入库编码18',
  `ftyxrq` datetime NOT NULL DEFAULT '2019-06-13 14:35:00',
  `firkid` bigint(20) NOT NULL,
  `fikcsl` int(11) NOT NULL DEFAULT '0',
  `fdzhsj` decimal(24,2) NOT NULL,
  `fvbzsm` varchar(255) NOT NULL DEFAULT '备注说明规格',
  PRIMARY KEY (`id`),
  KEY `ta07kclb_firkid_ta01yhmd_1` (`firkid`),
  KEY `ta07kclb_fihpid_ta05hplb_1` (`fihpid`),
  CONSTRAINT `ta07kclb_fihpid_ta05hplb_1` FOREIGN KEY (`fihpid`) REFERENCES `ta05hplb` (`id`),
  CONSTRAINT `ta07kclb_firkid_ta01yhmd_1` FOREIGN KEY (`firkid`) REFERENCES `ta01yhmd` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ta07kclb`
--

LOCK TABLES `ta07kclb` WRITE;
/*!40000 ALTER TABLE `ta07kclb` DISABLE KEYS */;
INSERT INTO `ta07kclb` VALUES (1,4,'201906121435210001','2020-06-13 17:45:18',3,10,156.00,'备注说明库存');
/*!40000 ALTER TABLE `ta07kclb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ta08cklb`
--

DROP TABLE IF EXISTS `ta08cklb`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ta08cklb` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `fihpid` bigint(20) NOT NULL,
  `fvrkbm` varchar(18) NOT NULL DEFAULT '入库编码18',
  `fvckbm` varchar(18) NOT NULL DEFAULT '出库编码18',
  `fistid` bigint(20) NOT NULL,
  `fickid` bigint(20) NOT NULL,
  `ftyxrq` datetime NOT NULL DEFAULT '2019-06-09 18:55:00',
  `ficklx` int(1) NOT NULL DEFAULT '1',
  `ficksl` int(11) NOT NULL DEFAULT '0',
  `fdckdj` decimal(24,2) NOT NULL,
  `fvbzsm` varchar(255) NOT NULL DEFAULT '备注说明出库说明',
  PRIMARY KEY (`id`),
  KEY `ta08cklb_fickid_ta01yhmd_1` (`fickid`),
  KEY `ta08cklb_fihpid_ta05hplb_1` (`fihpid`),
  KEY `ta08cklb_fistid_ta04stsz_1` (`fistid`),
  CONSTRAINT `ta08cklb_fickid_ta01yhmd_1` FOREIGN KEY (`fickid`) REFERENCES `ta01yhmd` (`id`),
  CONSTRAINT `ta08cklb_fihpid_ta05hplb_1` FOREIGN KEY (`fihpid`) REFERENCES `ta05hplb` (`id`),
  CONSTRAINT `ta08cklb_fistid_ta04stsz_1` FOREIGN KEY (`fistid`) REFERENCES `ta04stsz` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ta08cklb`
--

LOCK TABLES `ta08cklb` WRITE;
/*!40000 ALTER TABLE `ta08cklb` DISABLE KEYS */;
INSERT INTO `ta08cklb` VALUES (1,4,'201906121435210001','201906121435210002',1,3,'2020-06-13 17:45:18',1,12,156.00,'正常出库');
/*!40000 ALTER TABLE `ta08cklb` 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-06-16 16:57:09
