Y0K9D4vE

1CREATE DATABASE  IF NOT EXISTS `beer_restaurant` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
2USE `beer_restaurant`;
3-- MySQL dump 10.13  Distrib 8.0.18, for Win64 (x86_64)
4--
5-- Host: 127.0.0.1    Database: beer_restaurant
6-- ------------------------------------------------------
7-- Server version	8.0.18
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/*!50503 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 `beer`
22--
23
24DROP TABLE IF EXISTS `beer`;
25/*!40101 SET @saved_cs_client     = @@character_set_client */;
26/*!50503 SET character_set_client = utf8mb4 */;
27CREATE TABLE `beer` (
28  `ID` int(11) NOT NULL,
29  `ID_RESTAURANT` int(11) DEFAULT NULL,
30  `TITLE` varchar(45) DEFAULT NULL,
31  `GRADE` varchar(45) DEFAULT NULL,
32  `COST` float DEFAULT NULL,
33  PRIMARY KEY (`ID`),
34  KEY `BEER_RESTAURANT_FK_idx` (`ID_RESTAURANT`),
35  CONSTRAINT `BEER_RESTAURANT_FK` FOREIGN KEY (`ID_RESTAURANT`) REFERENCES `restaurant` (`ID`)
36) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
37/*!40101 SET character_set_client = @saved_cs_client */;
38
39--
40-- Dumping data for table `beer`
41--
42
43LOCK TABLES `beer` WRITE;
44/*!40000 ALTER TABLE `beer` DISABLE KEYS */;
45INSERT INTO `beer` VALUES (1,1,'Lidskae Svetlae','Lager',2.8),(2,1,'Lidskae Aksamitnae','Dark',2.8),(3,1,'Lidskae Brugge Evening','Cherry',3.6),(4,1,'Lidskae Pislner','Lager',2.9),(5,2,'Lidskae Svetlae','Lager',2.8),(6,2,'Lidskae Aksamitnae','Dark',2.8),(7,3,'Lidskae Svetlae','Lager',3),(8,3,'Lidskae Aksamitnae','Dark',3),(9,3,'Lidskae Brugge Evening','Cherry',3.8),(10,3,'Lidskae Pislner','Lager',3),(11,3,'Taler Lager','Lager',3.5);
46/*!40000 ALTER TABLE `beer` ENABLE KEYS */;
47UNLOCK TABLES;
48
49--
50-- Table structure for table `client`
51--
52
53DROP TABLE IF EXISTS `client`;
54/*!40101 SET @saved_cs_client     = @@character_set_client */;
55/*!50503 SET character_set_client = utf8mb4 */;
56CREATE TABLE `client` (
57  `ID` int(11) NOT NULL,
58  PRIMARY KEY (`ID`),
59  UNIQUE KEY `ID_UNIQUE` (`ID`)
60) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
61/*!40101 SET character_set_client = @saved_cs_client */;
62
63--
64-- Dumping data for table `client`
65--
66
67LOCK TABLES `client` WRITE;
68/*!40000 ALTER TABLE `client` DISABLE KEYS */;
69INSERT INTO `client` VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12),(13),(14),(15),(16);
70/*!40000 ALTER TABLE `client` ENABLE KEYS */;
71UNLOCK TABLES;
72
73--
74-- Table structure for table `complains`
75--
76
77DROP TABLE IF EXISTS `complains`;
78/*!40101 SET @saved_cs_client     = @@character_set_client */;
79/*!50503 SET character_set_client = utf8mb4 */;
80CREATE TABLE `complains` (
81  `ID_RESTAURANT` int(11) NOT NULL,
82  `ID_CLIENT` int(11) NOT NULL,
83  `DESCRIPTION` varchar(200) DEFAULT NULL,
84  `DATE` date DEFAULT NULL,
85  `ID` int(11) NOT NULL,
86  PRIMARY KEY (`ID`),
87  KEY `ID_CLIENT_idx` (`ID_CLIENT`),
88  KEY `COMPLAIN_RESTAURANT_FK_idx` (`ID_RESTAURANT`),
89  CONSTRAINT `COMPLAIN_CLIENT_FK` FOREIGN KEY (`ID_CLIENT`) REFERENCES `client` (`ID`),
90  CONSTRAINT `COMPLAIN_RESTAURANT_FK` FOREIGN KEY (`ID_RESTAURANT`) REFERENCES `restaurant` (`ID`)
91) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
92/*!40101 SET character_set_client = @saved_cs_client */;
93
94--
95-- Dumping data for table `complains`
96--
97
98LOCK TABLES `complains` WRITE;
99/*!40000 ALTER TABLE `complains` DISABLE KEYS */;
100INSERT INTO `complains` VALUES (1,2,'Нерасторопные официанты','2022-10-20',1),(1,5,'Долгое обслуживание','2022-10-20',2),(2,1,'Плохой выбор','2023-10-20',3),(2,5,'Маленький выбор','2024-10-20',4);
101/*!40000 ALTER TABLE `complains` ENABLE KEYS */;
102UNLOCK TABLES;
103
104--
105-- Table structure for table `includes`
106--
107
108DROP TABLE IF EXISTS `includes`;
109/*!40101 SET @saved_cs_client     = @@character_set_client */;
110/*!50503 SET character_set_client = utf8mb4 */;
111CREATE TABLE `includes` (
112  `ID_ORDER` int(11) NOT NULL,
113  `ID_BEER` int(11) NOT NULL,
114  `ID` int(11) NOT NULL,
115  PRIMARY KEY (`ID`),
116  KEY `INCLUDES_BEER_FK_idx` (`ID_BEER`),
117  KEY `INCLUDES_ORDER_FK_idx` (`ID_ORDER`),
118  CONSTRAINT `INCLUDES_BEER_FK` FOREIGN KEY (`ID_BEER`) REFERENCES `beer` (`ID`),
119  CONSTRAINT `INCLUDES_ORDER_FK` FOREIGN KEY (`ID_ORDER`) REFERENCES `order` (`ID`)
120) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
121/*!40101 SET character_set_client = @saved_cs_client */;
122
123--
124-- Dumping data for table `includes`
125--
126
127LOCK TABLES `includes` WRITE;
128/*!40000 ALTER TABLE `includes` DISABLE KEYS */;
129INSERT INTO `includes` VALUES (1,1,1),(1,2,2),(1,4,3),(1,3,4),(2,1,5),(2,2,6),(3,3,7),(3,3,8),(4,5,9),(4,5,10),(5,6,11),(5,6,12),(5,6,13),(5,5,14),(6,5,15),(6,5,16),(6,5,17),(7,8,18),(8,8,19),(8,11,20);
130/*!40000 ALTER TABLE `includes` ENABLE KEYS */;
131UNLOCK TABLES;
132
133--
134-- Table structure for table `order`
135--
136
137DROP TABLE IF EXISTS `order`;
138/*!40101 SET @saved_cs_client     = @@character_set_client */;
139/*!50503 SET character_set_client = utf8mb4 */;
140CREATE TABLE `order` (
141  `ID` int(11) NOT NULL,
142  `TABLE` int(11) NOT NULL,
143  `AMOUNT` float NOT NULL,
144  `ID_WAITER` int(11) DEFAULT NULL,
145  `ID_CLIENT` int(11) DEFAULT NULL,
146  PRIMARY KEY (`ID`),
147  UNIQUE KEY `ID_UNIQUE` (`ID`),
148  KEY `ORDER_WAITER_FK_idx` (`ID_WAITER`),
149  CONSTRAINT `ORDER_WAITER_FK` FOREIGN KEY (`ID_WAITER`) REFERENCES `waiter` (`ID`)
150) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
151/*!40101 SET character_set_client = @saved_cs_client */;
152
153--
154-- Dumping data for table `order`
155--
156
157LOCK TABLES `order` WRITE;
158/*!40000 ALTER TABLE `order` DISABLE KEYS */;
159INSERT INTO `order` VALUES (1,1,12.1,1,2),(2,1,5.6,2,5),(3,3,7.2,3,1),(4,1,5.6,4,1),(5,3,11.2,5,5),(6,2,8.4,6,8),(7,1,3,7,10),(8,2,6.5,8,3);
160/*!40000 ALTER TABLE `order` ENABLE KEYS */;
161UNLOCK TABLES;
162
163--
164-- Table structure for table `provide`
165--
166
167DROP TABLE IF EXISTS `provide`;
168/*!40101 SET @saved_cs_client     = @@character_set_client */;
169/*!50503 SET character_set_client = utf8mb4 */;
170CREATE TABLE `provide` (
171  `ID_PROVIDER` int(11) DEFAULT NULL,
172  `ID_BEER` int(11) DEFAULT NULL,
173  `COUNT` int(11) DEFAULT NULL,
174  `DATE` date DEFAULT NULL,
175  `ID` int(11) NOT NULL,
176  PRIMARY KEY (`ID`),
177  KEY `PROVIDE_BEER_FK_idx` (`ID_BEER`),
178  CONSTRAINT `PROVIDE_BEER_FK` FOREIGN KEY (`ID_BEER`) REFERENCES `beer` (`ID`)
179) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
180/*!40101 SET character_set_client = @saved_cs_client */;
181
182--
183-- Dumping data for table `provide`
184--
185
186LOCK TABLES `provide` WRITE;
187/*!40000 ALTER TABLE `provide` DISABLE KEYS */;
188INSERT INTO `provide` VALUES (1,1,15,'2024-10-20',1),(1,2,42,'2024-10-20',2),(1,3,5,'2024-10-20',3),(1,4,43,'2024-10-20',4),(2,5,20,'2024-10-20',5),(2,6,10,'2024-10-20',6),(2,7,11,'2024-10-20',7),(3,8,20,'2024-10-20',8),(3,9,35,'2024-10-20',9),(3,10,16,'2024-10-20',10),(3,11,11,'2024-10-20',11);
189/*!40000 ALTER TABLE `provide` ENABLE KEYS */;
190UNLOCK TABLES;
191
192--
193-- Table structure for table `provider`
194--
195
196DROP TABLE IF EXISTS `provider`;
197/*!40101 SET @saved_cs_client     = @@character_set_client */;
198/*!50503 SET character_set_client = utf8mb4 */;
199CREATE TABLE `provider` (
200  `ID` int(11) NOT NULL AUTO_INCREMENT,
201  `ADDRESS` varchar(200) NOT NULL,
202  `TITLE` varchar(45) NOT NULL,
203  PRIMARY KEY (`ID`),
204  UNIQUE KEY `ADDRESS_UNIQUE` (`ADDRESS`)
205) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
206/*!40101 SET character_set_client = @saved_cs_client */;
207
208--
209-- Dumping data for table `provider`
210--
211
212LOCK TABLES `provider` WRITE;
213/*!40000 ALTER TABLE `provider` DISABLE KEYS */;
214INSERT INTO `provider` VALUES (1,'Golodeda st., 42','Brovar'),(2,'Uborevich st., 59','Pan'),(3,'Hikalo st., 1','Kuzmich');
215/*!40000 ALTER TABLE `provider` ENABLE KEYS */;
216UNLOCK TABLES;
217
218--
219-- Table structure for table `restaurant`
220--
221
222DROP TABLE IF EXISTS `restaurant`;
223/*!40101 SET @saved_cs_client     = @@character_set_client */;
224/*!50503 SET character_set_client = utf8mb4 */;
225CREATE TABLE `restaurant` (
226  `ID` int(11) NOT NULL,
227  `WORKING_HOURS` varchar(13) NOT NULL,
228  `PHONE` varchar(17) NOT NULL,
229  `ADDRESS` varchar(60) NOT NULL,
230  PRIMARY KEY (`ID`),
231  UNIQUE KEY `ID_UNIQUE` (`ID`),
232  UNIQUE KEY `PHONE_UNIQUE` (`PHONE`)
233) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
234/*!40101 SET character_set_client = @saved_cs_client */;
235
236--
237-- Dumping data for table `restaurant`
238--
239
240LOCK TABLES `restaurant` WRITE;
241/*!40000 ALTER TABLE `restaurant` DISABLE KEYS */;
242INSERT INTO `restaurant` VALUES (1,'12:00 - 24:00','+375292021875','Golodeda st., 31'),(2,'12:00 - 24:00','+375296578959','Kulman st., 9'),(3,'18:00 - 24:00','+375447578800','Tashkentskaya st., 118');
243/*!40000 ALTER TABLE `restaurant` ENABLE KEYS */;
244UNLOCK TABLES;
245
246--
247-- Table structure for table `waiter`
248--
249
250DROP TABLE IF EXISTS `waiter`;
251/*!40101 SET @saved_cs_client     = @@character_set_client */;
252/*!50503 SET character_set_client = utf8mb4 */;
253CREATE TABLE `waiter` (
254  `ID` int(11) NOT NULL,
255  `NAME` varchar(45) NOT NULL,
256  `SALARY` float NOT NULL,
257  `ID_RESTAURANT` int(11) DEFAULT NULL,
258  PRIMARY KEY (`ID`),
259  UNIQUE KEY `idwaiter_UNIQUE` (`ID`),
260  KEY `WAITER_RETAURANT_FK_idx` (`ID_RESTAURANT`),
261  CONSTRAINT `WAITER_RETAURANT_FK` FOREIGN KEY (`ID_RESTAURANT`) REFERENCES `restaurant` (`ID`)
262) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
263/*!40101 SET character_set_client = @saved_cs_client */;
264
265--
266-- Dumping data for table `waiter`
267--
268
269LOCK TABLES `waiter` WRITE;
270/*!40000 ALTER TABLE `waiter` DISABLE KEYS */;
271INSERT INTO `waiter` VALUES (1,'Ivan Petrov',750,1),(2,'Arseniy Kozko',775,1),(3,'Mikhail Martynov',750,1),(4,'Elena Nikonova',650,2),(5,'Alexey Deusov',700,2),(6,'Mikhail Martynov',825,2),(7,'Stepan Melezh',750,3),(8,'Ihor Losik',900,3);
272/*!40000 ALTER TABLE `waiter` ENABLE KEYS */;
273UNLOCK TABLES;
274/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
275
276/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
277/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
278/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
279/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
280/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
281/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
282/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
283
284-- Dump completed on 2019-10-24 22:45:20