iHFKc2AN

1CREATE DATABASE  IF NOT EXISTS `restaurantdb` /*!40100 DEFAULT CHARACTER SET utf8 */;
2USE `restaurantdb`;
3-- MySQL dump 10.13  Distrib 5.7.13, for linux-glibc2.5 (x86_64)
4--
5-- Host: localhost    Database: restaurantdb
6-- ------------------------------------------------------
7-- Server version	5.7.16
8
9/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
10/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
11/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
12/*!40101 SET NAMES utf8 */;
13/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
14/*!40103 SET TIME_ZONE='+00:00' */;
15/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
16/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
17/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
18/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
19
20--
21-- Table structure for table `client`
22--
23
24DROP TABLE IF EXISTS `client`;
25/*!40101 SET @saved_cs_client     = @@character_set_client */;
26/*!40101 SET character_set_client = utf8 */;
27CREATE TABLE `client` (
28  `id` int(11) NOT NULL AUTO_INCREMENT,
29  `employee_id` int(11) NOT NULL,
30  `order_id` int(11) NOT NULL,
31  `table_number` int(11) DEFAULT '0',
32  `paid_status` int(11) DEFAULT '0',
33  `register_date` timestamp(6) NULL DEFAULT NULL,
34  PRIMARY KEY (`id`),
35  KEY `fk_client_1_idx` (`employee_id`),
36  KEY `fk_client_2_idx` (`order_id`),
37  CONSTRAINT `fk_client_1` FOREIGN KEY (`employee_id`) REFERENCES `employee` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
38  CONSTRAINT `fk_client_2` FOREIGN KEY (`order_id`) REFERENCES `order` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
39) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=cp1251;
40/*!40101 SET character_set_client = @saved_cs_client */;
41
42--
43-- Dumping data for table `client`
44--
45
46LOCK TABLES `client` WRITE;
47/*!40000 ALTER TABLE `client` DISABLE KEYS */;
48INSERT INTO `client` VALUES (1,1,1,1,1,'2016-10-31 07:13:55.644000'),(2,1,5,2,0,'2016-10-31 07:14:00.644000'),(3,1,8,3,0,'2016-10-31 07:14:55.644000'),(4,1,9,4,0,'2016-10-31 07:18:38.003000'),(5,1,10,1,1,'2016-01-11 08:00:00.000000'),(6,1,11,5,0,'2016-10-31 09:58:03.433000'),(7,1,12,2,0,'2016-01-01 08:00:00.000000'),(8,1,13,9,0,'2016-11-13 14:16:34.400000'),(9,1,14,3,0,'2017-01-01 07:00:00.000000');
49/*!40000 ALTER TABLE `client` ENABLE KEYS */;
50UNLOCK TABLES;
51
52--
53-- Table structure for table `employee`
54--
55
56DROP TABLE IF EXISTS `employee`;
57/*!40101 SET @saved_cs_client     = @@character_set_client */;
58/*!40101 SET character_set_client = utf8 */;
59CREATE TABLE `employee` (
60  `id` int(11) NOT NULL AUTO_INCREMENT,
61  `login` varchar(45) CHARACTER SET utf8 NOT NULL,
62  `password` varchar(45) CHARACTER SET utf8 NOT NULL,
63  `fio` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
64  PRIMARY KEY (`id`),
65  UNIQUE KEY `login_UNIQUE` (`login`)
66) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=cp1251;
67/*!40101 SET character_set_client = @saved_cs_client */;
68
69--
70-- Dumping data for table `employee`
71--
72
73LOCK TABLES `employee` WRITE;
74/*!40000 ALTER TABLE `employee` DISABLE KEYS */;
75INSERT INTO `employee` VALUES (1,'test','test','test'),(2,'admin','admin','admin');
76/*!40000 ALTER TABLE `employee` ENABLE KEYS */;
77UNLOCK TABLES;
78
79--
80-- Table structure for table `food`
81--
82
83DROP TABLE IF EXISTS `food`;
84/*!40101 SET @saved_cs_client     = @@character_set_client */;
85/*!40101 SET character_set_client = utf8 */;
86CREATE TABLE `food` (
87  `id` int(11) NOT NULL AUTO_INCREMENT,
88  `cost` int(11) NOT NULL,
89  `name` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
90  `removed` tinyint(1) NOT NULL DEFAULT '0',
91  PRIMARY KEY (`id`)
92) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=cp1251;
93/*!40101 SET character_set_client = @saved_cs_client */;
94
95--
96-- Dumping data for table `food`
97--
98
99LOCK TABLES `food` WRITE;
100/*!40000 ALTER TABLE `food` DISABLE KEYS */;
101INSERT INTO `food` VALUES (1,0,'Столик',0),(2,270,'Салат Цезарь',0),(3,300,'Жареные крылышки',0),(4,100,'Окрошка',0),(12,200,'Венские колбаски',0),(13,40,'Лимонад',0),(14,100,'Борщ',0),(15,10,'Свежий хлеб',0);
102/*!40000 ALTER TABLE `food` ENABLE KEYS */;
103UNLOCK TABLES;
104
105--
106-- Table structure for table `order`
107--
108
109DROP TABLE IF EXISTS `order`;
110/*!40101 SET @saved_cs_client     = @@character_set_client */;
111/*!40101 SET character_set_client = utf8 */;
112CREATE TABLE `order` (
113  `id` int(11) NOT NULL AUTO_INCREMENT,
114  `food_id` int(11) NOT NULL,
115  `count` int(11) NOT NULL,
116  `date` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
117  `status` varchar(10) DEFAULT NULL,
118  PRIMARY KEY (`id`,`food_id`),
119  UNIQUE KEY `date_UNIQUE` (`date`),
120  KEY `fk_order_1_idx` (`food_id`),
121  CONSTRAINT `fk_order_1` FOREIGN KEY (`food_id`) REFERENCES `food` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
122) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
123/*!40101 SET character_set_client = @saved_cs_client */;
124
125--
126-- Dumping data for table `order`
127--
128
129LOCK TABLES `order` WRITE;
130/*!40000 ALTER TABLE `order` DISABLE KEYS */;
131INSERT INTO `order` VALUES (1,1,3,'2016-10-31 08:59:48.715000','1'),(1,2,2,'2016-10-31 09:34:53.686000','0'),(1,3,2,'2016-10-31 08:59:32.491000','0'),(1,4,2,'2016-10-31 08:02:14.796000','0'),(5,1,1,'2016-10-31 07:02:46.420000','1'),(5,3,1,'2016-10-31 08:58:14.626000','0'),(8,1,2,'2016-10-31 08:59:36.979000','1'),(8,2,2,'2016-10-31 08:59:39.043000','0'),(8,3,3,'2016-10-31 08:59:41.418000','0'),(9,1,1,'2016-10-31 07:18:38.003000','1'),(10,1,1,'2016-01-11 08:00:00.000000','1'),(11,1,1,'2016-10-31 09:58:03.433000','1'),(12,1,1,'2016-01-01 08:00:00.000000','1'),(13,1,1,'2016-11-13 14:16:34.400000','1'),(14,1,1,'2017-01-01 07:00:00.000000','1');
132/*!40000 ALTER TABLE `order` ENABLE KEYS */;
133UNLOCK TABLES;
134
135--
136-- Table structure for table `reservation`
137--
138
139DROP TABLE IF EXISTS `reservation`;
140/*!40101 SET @saved_cs_client     = @@character_set_client */;
141/*!40101 SET character_set_client = utf8 */;
142CREATE TABLE `reservation` (
143  `id` int(11) NOT NULL AUTO_INCREMENT,
144  `client_id` int(11) NOT NULL,
145  `table_number` int(11) NOT NULL,
146  `date` datetime NOT NULL,
147  `mobile_number` varchar(11) DEFAULT NULL,
148  PRIMARY KEY (`id`),
149  KEY `fk_reservation_1_idx` (`client_id`),
150  CONSTRAINT `fk_reservation_1` FOREIGN KEY (`client_id`) REFERENCES `client` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
151) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
152/*!40101 SET character_set_client = @saved_cs_client */;
153
154--
155-- Dumping data for table `reservation`
156--
157
158LOCK TABLES `reservation` WRITE;
159/*!40000 ALTER TABLE `reservation` DISABLE KEYS */;
160INSERT INTO `reservation` VALUES (1,5,1,'2016-01-11 11:00:00','89503457898'),(2,7,2,'2016-01-01 11:00:00','89081411174'),(3,9,3,'2017-01-01 10:00:00','89304034700');
161/*!40000 ALTER TABLE `reservation` ENABLE KEYS */;
162UNLOCK TABLES;
163/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
164
165/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
166/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
167/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
168/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
169/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
170/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
171/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
172
173-- Dump completed on 2016-11-13 18:53:00