· 5 years ago · Nov 26, 2020, 09:08 AM
1-- MySQL dump 10.13 Distrib 8.0.22, for Win64 (x86_64)
2--
3-- Host: 127.0.0.1 Database: bd_recetas
4-- ------------------------------------------------------
5-- Server version 8.0.22
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!50503 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `consejos`
20--
21
22DROP TABLE IF EXISTS `consejos`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!50503 SET character_set_client = utf8mb4 */;
25CREATE TABLE `consejos` (
26 `id` int NOT NULL AUTO_INCREMENT,
27 `consejo` varchar(45) COLLATE utf8_spanish2_ci NOT NULL,
28 `FK_receta` int DEFAULT NULL,
29 PRIMARY KEY (`id`),
30 KEY `FK_receta_idx` (`FK_receta`),
31 FULLTEXT KEY `consejo` (`consejo`),
32 CONSTRAINT `FK_receta` FOREIGN KEY (`FK_receta`) REFERENCES `recetas` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
33) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;
34/*!40101 SET character_set_client = @saved_cs_client */;
35
36--
37-- Dumping data for table `consejos`
38--
39
40LOCK TABLES `consejos` WRITE;
41/*!40000 ALTER TABLE `consejos` DISABLE KEYS */;
42INSERT INTO `consejos` VALUES (1,'poner alubias a remojo el dia antes',1),(2,'con puerro mucho mejor',1);
43/*!40000 ALTER TABLE `consejos` ENABLE KEYS */;
44UNLOCK TABLES;
45
46--
47-- Table structure for table `dificultad`
48--
49
50DROP TABLE IF EXISTS `dificultad`;
51/*!40101 SET @saved_cs_client = @@character_set_client */;
52/*!50503 SET character_set_client = utf8mb4 */;
53CREATE TABLE `dificultad` (
54 `id` int NOT NULL AUTO_INCREMENT,
55 `dificultad` varchar(45) COLLATE utf8_spanish2_ci NOT NULL,
56 PRIMARY KEY (`id`)
57) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;
58/*!40101 SET character_set_client = @saved_cs_client */;
59
60--
61-- Dumping data for table `dificultad`
62--
63
64LOCK TABLES `dificultad` WRITE;
65/*!40000 ALTER TABLE `dificultad` DISABLE KEYS */;
66INSERT INTO `dificultad` VALUES (1,'facil'),(2,'medio'),(3,'dificil');
67/*!40000 ALTER TABLE `dificultad` ENABLE KEYS */;
68UNLOCK TABLES;
69
70--
71-- Table structure for table `ingredientes`
72--
73
74DROP TABLE IF EXISTS `ingredientes`;
75/*!40101 SET @saved_cs_client = @@character_set_client */;
76/*!50503 SET character_set_client = utf8mb4 */;
77CREATE TABLE `ingredientes` (
78 `id` int NOT NULL AUTO_INCREMENT,
79 `ingrediente` varchar(45) COLLATE utf8_spanish2_ci NOT NULL,
80 PRIMARY KEY (`id`)
81) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;
82/*!40101 SET character_set_client = @saved_cs_client */;
83
84--
85-- Dumping data for table `ingredientes`
86--
87
88LOCK TABLES `ingredientes` WRITE;
89/*!40000 ALTER TABLE `ingredientes` DISABLE KEYS */;
90INSERT INTO `ingredientes` VALUES (1,'tomate'),(2,'bacon'),(3,'queso'),(4,'salchicha'),(5,'chorizo'),(6,'judia'),(7,'lechuga'),(8,'harina'),(9,'leche'),(10,'agua'),(11,'sal'),(12,'calabacin'),(13,'berenjena'),(14,'cebolla'),(15,'ajo'),(16,'aceite'),(17,'patata'),(18,'atun'),(19,'azucar'),(20,'levadura');
91/*!40000 ALTER TABLE `ingredientes` ENABLE KEYS */;
92UNLOCK TABLES;
93
94--
95-- Table structure for table `ingredientes_recetas`
96--
97
98DROP TABLE IF EXISTS `ingredientes_recetas`;
99/*!40101 SET @saved_cs_client = @@character_set_client */;
100/*!50503 SET character_set_client = utf8mb4 */;
101CREATE TABLE `ingredientes_recetas` (
102 `id` int NOT NULL AUTO_INCREMENT,
103 `FK_recetas` int DEFAULT NULL,
104 `FK_ingredientes` int DEFAULT NULL,
105 PRIMARY KEY (`id`),
106 KEY `FK_receta_idx` (`FK_recetas`),
107 KEY `FK_ingrediente_idx` (`FK_ingredientes`),
108 KEY `FK_recetas_idx` (`FK_recetas`),
109 KEY `FK_ingredientes_idx` (`FK_ingredientes`),
110 CONSTRAINT `FK_ingredientes` FOREIGN KEY (`FK_ingredientes`) REFERENCES `ingredientes` (`id`),
111 CONSTRAINT `FK_recetas` FOREIGN KEY (`FK_recetas`) REFERENCES `recetas` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
112) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;
113/*!40101 SET character_set_client = @saved_cs_client */;
114
115--
116-- Dumping data for table `ingredientes_recetas`
117--
118
119LOCK TABLES `ingredientes_recetas` WRITE;
120/*!40000 ALTER TABLE `ingredientes_recetas` DISABLE KEYS */;
121INSERT INTO `ingredientes_recetas` VALUES (1,4,12),(2,4,13),(3,4,14),(4,4,15),(5,4,16),(6,4,11),(7,4,1),(8,1,1),(9,1,6),(10,1,11),(11,1,14),(12,1,15),(13,2,7),(14,2,17),(15,2,18),(16,2,1),(17,3,4),(18,3,14),(19,3,15),(20,3,1),(21,3,11),(22,5,10),(23,5,8),(24,5,19),(25,5,20);
122/*!40000 ALTER TABLE `ingredientes_recetas` ENABLE KEYS */;
123UNLOCK TABLES;
124
125--
126-- Table structure for table `pais`
127--
128
129DROP TABLE IF EXISTS `pais`;
130/*!40101 SET @saved_cs_client = @@character_set_client */;
131/*!50503 SET character_set_client = utf8mb4 */;
132CREATE TABLE `pais` (
133 `id` int NOT NULL AUTO_INCREMENT,
134 `pais` varchar(45) COLLATE utf8_spanish2_ci NOT NULL,
135 PRIMARY KEY (`id`)
136) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;
137/*!40101 SET character_set_client = @saved_cs_client */;
138
139--
140-- Dumping data for table `pais`
141--
142
143LOCK TABLES `pais` WRITE;
144/*!40000 ALTER TABLE `pais` DISABLE KEYS */;
145INSERT INTO `pais` VALUES (1,'España'),(2,'Inglaterra'),(3,'Francia'),(4,'Alemania');
146/*!40000 ALTER TABLE `pais` ENABLE KEYS */;
147UNLOCK TABLES;
148
149--
150-- Table structure for table `recetas`
151--
152
153DROP TABLE IF EXISTS `recetas`;
154/*!40101 SET @saved_cs_client = @@character_set_client */;
155/*!50503 SET character_set_client = utf8mb4 */;
156CREATE TABLE `recetas` (
157 `id` int NOT NULL AUTO_INCREMENT,
158 `nombre` varchar(45) COLLATE utf8_spanish2_ci DEFAULT NULL,
159 `descripcion` varchar(100) COLLATE utf8_spanish2_ci DEFAULT NULL,
160 `FK_pais` int DEFAULT NULL,
161 `FK_dificultad` int DEFAULT NULL,
162 PRIMARY KEY (`id`),
163 KEY `FK_pais_idx` (`FK_pais`),
164 KEY `FK_dificultad_idx` (`FK_dificultad`),
165 FULLTEXT KEY `nombre` (`nombre`,`descripcion`),
166 CONSTRAINT `FK_dificultad` FOREIGN KEY (`FK_dificultad`) REFERENCES `dificultad` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
167 CONSTRAINT `FK_pais` FOREIGN KEY (`FK_pais`) REFERENCES `pais` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
168) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;
169/*!40101 SET character_set_client = @saved_cs_client */;
170
171--
172-- Dumping data for table `recetas`
173--
174
175LOCK TABLES `recetas` WRITE;
176/*!40000 ALTER TABLE `recetas` DISABLE KEYS */;
177INSERT INTO `recetas` VALUES (1,'alubias a la vasca','alubias con sacramentos',1,2),(2,'ensalada mixta','ensalada con patata, esparrago y atun',1,1),(3,'currywurst','salchicha acompañada de patatas fritas o panecillo, y con su típica salsa de tomate y curry',4,2),(4,'ratatouille','base de verduras y pertenece a los platos de la cocina Tradicional',3,3),(5,'muffin','postre clasico ingles',2,1);
178/*!40000 ALTER TABLE `recetas` ENABLE KEYS */;
179UNLOCK TABLES;
180
181--
182-- Dumping routines for database 'bd_recetas'
183--
184/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
185
186/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
187/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
188/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
189/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
190/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
191/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
192/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
193
194-- Dump completed on 2020-11-26 10:00:44
195