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

/*!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 */;
/*!50503 SET NAMES utf8mb4 */;
/*!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 `tb_dinner_table`
--

DROP TABLE IF EXISTS `tb_dinner_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tb_dinner_table` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `table_Name` varchar(20) DEFAULT NULL COMMENT '椁愭鍚嶇О',
  `table_status` int(11) DEFAULT '0' COMMENT '0 鏈娇鐢?1姝ｅ湪浣跨敤',
  `begin_use_date` datetime DEFAULT NULL COMMENT '椁愭寮€濮嬪崰鐢?,
  `create_date` datetime DEFAULT NULL COMMENT '椁愭鐨勫垱寤烘椂闂?,
  `update_date` datetime DEFAULT NULL COMMENT '椁愭淇℃伅鐨勪慨鏀圭殑鏃堕棿',
  `disabled` int(11) DEFAULT '0' COMMENT '1涓哄垹闄?,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_dinner_table`
--

LOCK TABLES `tb_dinner_table` WRITE;
/*!40000 ALTER TABLE `tb_dinner_table` DISABLE KEYS */;
INSERT INTO `tb_dinner_table` VALUES (1,'1鍙锋',0,'2018-10-04 00:00:00','2018-11-06 00:00:00','2020-02-21 00:00:00',0),(2,'2鍙锋',0,'2018-11-15 00:00:00','2018-11-06 00:00:00','2020-02-26 00:00:00',1),(3,'3鍙锋',0,'2018-11-13 00:00:00','2018-11-06 00:00:00','2020-02-26 15:21:40',0),(4,'4鍙锋',0,'2018-11-15 00:00:00','2018-11-06 00:00:00','2020-02-26 00:00:00',0),(5,'5鍙锋',1,'2018-11-14 00:00:00','2018-11-06 00:00:00','2020-02-20 00:00:00',0),(6,'6鍙锋',0,'2018-11-14 00:00:00','2018-11-06 00:00:00','2020-03-19 21:03:38',0),(7,'7鍙锋',0,'2018-11-13 00:00:00','2018-11-06 00:00:00','2020-02-20 21:06:05',0),(8,'8鍙锋',0,'2018-11-13 00:00:00','2018-11-14 00:00:00','2020-02-26 15:10:46',0),(9,'9鍙锋',0,'2018-11-14 00:00:00','2018-11-06 16:34:40',NULL,0),(10,'10鍙锋',0,'2018-09-14 00:00:00','2018-11-06 00:00:00','2020-02-20 21:06:10',0);
/*!40000 ALTER TABLE `tb_dinner_table` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_food`
--

DROP TABLE IF EXISTS `tb_food`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tb_food` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `food_name` varchar(20) DEFAULT NULL COMMENT '鑿滃悕',
  `foodType_id` int(11) DEFAULT NULL COMMENT '鑿滃搧绫诲瀷id',
  `price` double DEFAULT NULL COMMENT '浠锋牸',
  `discount` double DEFAULT '1' COMMENT '鎶樻墸',
  `remark` varchar(200) DEFAULT NULL COMMENT '澶囨敞',
  `img` varchar(100) DEFAULT NULL COMMENT '鑿滅殑鍥剧墖',
  `create_date` datetime DEFAULT NULL COMMENT '鑿滃搧鍒涘缓鏃堕棿',
  `update_date` datetime DEFAULT NULL COMMENT '鑿滃搧淇℃伅鏇存柊鏃堕棿',
  `disabled` int(11) DEFAULT '0' COMMENT '0 鏈垹  1宸插垹',
  PRIMARY KEY (`id`),
  KEY `fk_food_foodType_id` (`foodType_id`),
  CONSTRAINT `fk_food_foodType_id` FOREIGN KEY (`foodType_id`) REFERENCES `tb_food_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_food`
--

LOCK TABLES `tb_food` WRITE;
/*!40000 ALTER TABLE `tb_food` DISABLE KEYS */;
INSERT INTO `tb_food` VALUES (1,'骞查攨鐗涜洐',1,88.99,0.82,'榧庢姌瑕嗛鐨?,'鐗涜洐.jpg','2018-09-11 00:00:00','2020-05-23 14:18:36',0),(2,'棣欒荆锜?,1,99,0.8,'杈?,'铻冭煿.jpg',NULL,'2020-05-23 14:18:51',0),(3,'瑗跨孩鏌块浮铔嬫堡',1,22,0.8,'','瑗跨孩鏌?jpg',NULL,'2020-05-23 14:19:09',0),(4,'绱彍铔嬫堡',2,22,0.8,NULL,'绱彍姹?jpg',NULL,'2018-09-28 22:32:17',0),(5,'椴奔璞嗚厫姹?,1,39,0.8,'','椴奔.jpg',NULL,'2018-10-12 10:24:39',0),(6,'鏌犳铚傝湝姘?,4,18,0.8,NULL,'鏌犳.jpg',NULL,'2020-05-13 21:27:00',0),(7,'楦＄繀',1,12,0.8,'','楦＄繀.jpg',NULL,'2018-10-12 10:24:56',0),(19,'姘寸叜楸肩墖',1,29,0.9,'澶ц寖鐢樿开','姘寸叜楸?jpg','2018-10-02 09:57:58','2018-10-12 10:25:04',0),(20,'姘寸叜楸肩墖2',1,29,1,'','姘寸叜楸?jpg','2018-10-02 10:11:05','2018-10-10 12:05:29',0),(21,'灏忕倰鑲?,1,39,0.9,'涓?,'灏忕倰鑲?jpg','2018-10-09 15:39:22','2020-05-13 21:25:12',1),(22,'灏忕倰鑲?',1,39,0.9,'','灏忕倰鑲?.jpg','2018-10-09 15:48:27','2018-10-10 12:05:19',0),(23,'鏈ㄧ摐鐗涘ザ',12,39,0.9,'瀹炴墦瀹?,'鏈ㄧ摐鐗涘ザ.jpg','2018-10-10 21:08:42','2018-10-10 21:08:57',0);
/*!40000 ALTER TABLE `tb_food` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_food_type`
--

DROP TABLE IF EXISTS `tb_food_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tb_food_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type_name` varchar(20) DEFAULT NULL COMMENT '鑿滃搧绫诲瀷鍚嶇О',
  `create_date` datetime DEFAULT NULL COMMENT '鑿滃搧绫诲瀷鍒涘缓鏃堕棿',
  `update_date` datetime DEFAULT NULL COMMENT '鑿滃搧绫诲瀷鏇存柊鏃堕棿',
  `disabled` int(11) DEFAULT '0' COMMENT '0鏈垹  1宸插垹',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_food_type`
--

LOCK TABLES `tb_food_type` WRITE;
/*!40000 ALTER TABLE `tb_food_type` DISABLE KEYS */;
INSERT INTO `tb_food_type` VALUES (1,'鐗硅壊缇庨21','2018-09-06 21:00:00','2020-05-13 16:01:47',0),(2,'姹?,'2018-09-06 02:00:00','2020-05-13 21:29:19',0),(3,'鐢滃搧','2018-09-12 03:00:00','2020-05-13 21:28:44',1),(4,'楗枡','2018-09-18 20:00:00','2020-05-13 21:28:10',0),(5,'鍑夎彍','2018-09-22 00:00:00',NULL,1),(9,'瑗跨偣','2018-09-22 00:00:00','2020-05-05 22:55:32',1),(10,'姹?','2018-10-09 10:37:20','2020-05-05 22:55:30',1),(11,'娴嬭瘯','2018-10-10 20:55:16','2020-05-05 22:55:27',1),(12,'绯栨按','2018-10-10 20:55:21','2020-05-05 22:55:26',0),(13,'鐑共闈?,'2020-05-05 22:32:39','2020-05-05 22:55:24',1),(14,'鍖呭瓙1','2020-05-05 22:34:31','2020-05-05 22:56:23',1),(15,'鑲夊寘','2020-05-05 22:44:01','2020-05-05 22:56:11',1);
/*!40000 ALTER TABLE `tb_food_type` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_order`
--

DROP TABLE IF EXISTS `tb_order`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tb_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_code` varchar(255) DEFAULT NULL COMMENT '璁㈠崟缂栫爜',
  `table_id` int(11) DEFAULT NULL COMMENT '璁㈠崟鎵€灞為妗?,
  `total_Price` double DEFAULT NULL COMMENT '鎬讳环',
  `order_Status` int(11) DEFAULT '0' COMMENT '0宸蹭笅鍗曟湭浠樻  1宸蹭粯娆?,
  `order_Date` datetime DEFAULT NULL COMMENT '涓嬪崟鏃堕棿',
  `pay_date` datetime DEFAULT NULL COMMENT '浠樻鏃堕棿',
  `disabled` int(11) DEFAULT '0' COMMENT '0鏈垹  1宸插垹',
  `update_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `order_table_id` (`table_id`),
  CONSTRAINT `order_table_id` FOREIGN KEY (`table_id`) REFERENCES `tb_dinner_table` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_order`
--

LOCK TABLES `tb_order` WRITE;
/*!40000 ALTER TABLE `tb_order` DISABLE KEYS */;
INSERT INTO `tb_order` VALUES (8,'OP-20200220210631739bc7b0-2c4c-4fd9-b371-7a3eb764b3da',1,231.3718,1,'2020-02-20 00:00:00','2020-02-20 00:00:00',0,'2020-02-20 00:00:00'),(9,'OP-202002202107294423f3d4-46cd-4791-8211-3099eb3de6b1',1,72.97179999999999,1,'2020-02-20 21:07:29','2020-02-20 21:07:33',0,'2020-02-20 00:00:00'),(10,'OP-2020022021224777e59e46-76cb-4ad4-9a4b-d4e1fa25f760',2,72.97179999999999,1,'2020-02-20 21:22:47','2020-02-20 21:23:00',0,'2020-02-20 00:00:00'),(11,'OP-202002202126576b11cb3d-93b4-4509-aa81-1bc33bb3bcfd',3,72.97179999999999,1,'2020-02-20 21:26:57','2020-02-20 21:36:10',0,'2020-02-20 21:36:10'),(12,'OP-2020022021294842b522d4-70ef-47d5-bebe-7d0c4eaa3bc3',1,329.31539999999995,1,'2020-02-20 21:29:48','2020-02-20 21:32:15',0,'2020-02-20 00:00:00'),(13,'OP-202002202132501f29d41f-39f2-4390-8134-a7e276a5d862',1,183.3718,0,'2020-02-20 21:32:50',NULL,1,'2020-02-20 00:00:00'),(14,'OP-202002202135470c6a3c27-1d7a-47b1-9716-a64f29b4b574',8,72.97179999999999,0,'2020-02-20 21:35:47',NULL,1,'2020-02-20 21:35:53'),(15,'OP-20200220214650da3e249d-b935-48cc-ad24-480527cf5035',1,152.17,0,'2020-02-20 21:46:50',NULL,1,'2020-02-20 21:46:59'),(16,'OP-20200220214719e9429f74-eecc-445f-b579-d36255f99d22',1,72.97,1,'2020-02-20 21:47:19','2020-02-20 21:47:32',0,'2020-02-20 21:47:32'),(17,'OP-202002212014579bad695d-8073-45df-ba49-23595f013c1f',1,219.07,1,'2020-02-21 20:14:57','2020-02-21 20:15:01',0,'2020-02-21 20:15:01'),(18,'OP-202002261510442823d54c-de5d-4585-9b27-de008a823706',8,72.97,1,'2020-02-26 15:10:44','2020-02-26 15:10:46',0,'2020-02-26 15:10:46'),(19,'OP-20200226151813f984edff-635d-40a6-acee-49810d09c7d4',4,72.97,1,'2020-02-26 15:18:13','2020-02-26 15:19:46',0,'2020-02-26 15:19:46'),(20,'OP-20200226152122bd7e5645-f664-4fa8-aac3-ac9fc5508e67',3,161.77,1,'2020-02-26 15:21:22','2020-02-26 15:21:40',0,'2020-02-26 15:21:40'),(21,'OP-20200226152802d344856f-c6ca-46b8-bbf0-3b5145bbb5dd',2,96.97,1,'2020-02-26 15:28:02','2020-02-26 15:28:05',0,'2020-02-26 15:28:05'),(22,'OP-20200226153304a38635ce-395a-4431-84b8-679df8d9643c',2,233.84,1,'2020-02-26 15:33:04','2020-02-26 15:33:07',0,'2020-02-26 15:33:07'),(23,'OP-202003192103366fe9c6ef-9eae-4e13-b4e7-e99e0785f156',6,145.94,1,'2020-03-19 21:03:36','2020-03-19 21:03:38',0,'2020-03-19 21:03:38');
/*!40000 ALTER TABLE `tb_order` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_order_detail`
--

DROP TABLE IF EXISTS `tb_order_detail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tb_order_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `orderId` int(11) DEFAULT NULL COMMENT '鎵€灞炶鍗昳d',
  `food_id` int(11) DEFAULT NULL COMMENT '鑿滃搧id',
  `buyNum` int(11) DEFAULT NULL COMMENT '澶熶拱鏁伴噺',
  `discount` double DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `orderDetail_order_id` (`orderId`),
  KEY `orderDetail_food_id` (`food_id`),
  CONSTRAINT `orderDetail_food_id` FOREIGN KEY (`food_id`) REFERENCES `tb_food` (`id`),
  CONSTRAINT `orderDetail_order_id` FOREIGN KEY (`orderId`) REFERENCES `tb_order` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_order_detail`
--

LOCK TABLES `tb_order_detail` WRITE;
/*!40000 ALTER TABLE `tb_order_detail` DISABLE KEYS */;
INSERT INTO `tb_order_detail` VALUES (14,8,1,1,0.82),(15,8,2,2,0.8),(16,9,1,1,0.82),(17,10,1,1,0.82),(18,11,1,1,0.82),(19,12,1,3,0.82),(20,12,2,1,0.8),(21,12,5,1,0.8),(22,13,1,1,0.82),(23,13,2,1,0.8),(24,13,5,1,0.8),(25,14,1,1,0.82),(26,15,1,1,0.82),(27,15,2,1,0.8),(28,16,1,1,0.82),(29,17,1,1,0.82),(30,17,2,1,0.8),(31,17,19,1,0.9),(32,17,5,1,0.8),(33,17,7,1,0.8),(34,18,1,1,0.82),(35,19,1,1,0.82),(36,20,1,1,0.82),(37,20,2,1,0.8),(38,20,7,1,0.8),(39,21,1,1,0.82),(40,21,6,1,0.8),(41,21,7,1,0.8),(42,22,1,2,0.82),(43,22,22,1,0.9),(44,22,6,3,0.8),(45,22,7,1,0.8),(46,23,1,2,0.82);
/*!40000 ALTER TABLE `tb_order_detail` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_user`
--

DROP TABLE IF EXISTS `tb_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tb_user` (
  `id` int(11) NOT NULL,
  `login_name` varchar(50) DEFAULT NULL COMMENT '鐧诲綍鍚?,
  `password` varchar(50) DEFAULT NULL COMMENT '瀵嗙爜',
  `email` varchar(50) DEFAULT NULL COMMENT '閭',
  `phone` varchar(20) DEFAULT NULL COMMENT '鐢佃瘽',
  `create_time` datetime DEFAULT NULL COMMENT '鐢ㄦ埛鍒涘缓鏃堕棿',
  `disabled` int(11) DEFAULT '0' COMMENT '0 琛ㄧず姝ｅ父 1琛ㄧず宸插垹闄?,
  PRIMARY KEY (`id`),
  UNIQUE KEY `LOGIN_NAME` (`login_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_user`
--

LOCK TABLES `tb_user` WRITE;
/*!40000 ALTER TABLE `tb_user` DISABLE KEYS */;
INSERT INTO `tb_user` VALUES (1,'admin','123456','test@163.com','18998665678','2017-10-25 15:44:11',0),(2,'鏉庡洓','123456','test1@163.com','13487890989','2017-10-25 15:44:11',1),(7,'寮犳檽鏅?,'2222','10923@qq.com','13629233728','2018-03-03 11:42:30',0),(8,'鐜嬩簲','2222','10923@qq.com','13629233728','2018-03-03 11:42:49',0),(9,'瀛欓夯瀛?,'2222','10923@qq.com','13629233728','2018-03-03 13:25:52',0),(10,'寮犱笁','11111111','1095402829@qq.com',NULL,'2018-06-18 15:47:01',0),(11,'浜斾簲','123456','1095402829@qq.com','13539909243','2018-09-12 21:57:23',0),(12,'鍒樹附','123456','1095402829@qq.com','13539909243','2018-09-12 22:02:26',0),(13,'鐞惇','123456','1095402829@qq.com','13539909243','2018-09-12 22:03:29',0),(14,'wuwu','123456','1095402829@qq.com','13539909243','2018-09-12 22:04:13',0),(15,'cat','123456','1095402829@qq.com','13539909243','2018-11-19 18:28:02',0),(16,'闆峰瓙','123456','15245251@qq.com','123456','2020-02-26 14:16:32',0),(20,'wdy','123456','15245251@qq.com','123456','2020-02-26 14:41:06',0),(21,'鏂囨。','123456','12548574521@qq.com','15165165165','2020-05-23 12:31:32',0),(22,'鏀跺埌','123456','1@qq.com','13845874562','2020-05-23 12:32:49',0);
/*!40000 ALTER TABLE `tb_user` 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 2020-09-27 14:43:49