· 4 years ago · May 03, 2021, 06:48 AM
1-- MySQL dump 10.13 Distrib 8.0.23, for Win64 (x86_64)
2--
3-- Host: localhost Database: a0221_animales
4-- ------------------------------------------------------
5-- Server version 8.0.23
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 `animales`
20--
21
22DROP TABLE IF EXISTS `animales`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!50503 SET character_set_client = utf8mb4 */;
25CREATE TABLE `animales` (
26 `id` int NOT NULL AUTO_INCREMENT,
27 `nombre` varchar(45) NOT NULL DEFAULT '-vacio-',
28 `FK_dieta` int NOT NULL,
29 `FK_tamanyo` int NOT NULL,
30 PRIMARY KEY (`id`),
31 KEY `FK_dieta_idx` (`FK_dieta`),
32 KEY `FK_tamanyo_idx` (`FK_tamanyo`),
33 CONSTRAINT `FK_dieta` FOREIGN KEY (`FK_dieta`) REFERENCES `dietas` (`id`),
34 CONSTRAINT `FK_tamanyo` FOREIGN KEY (`FK_tamanyo`) REFERENCES `tamanyos` (`id`)
35) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
36/*!40101 SET character_set_client = @saved_cs_client */;
37
38--
39-- Dumping data for table `animales`
40--
41
42LOCK TABLES `animales` WRITE;
43/*!40000 ALTER TABLE `animales` DISABLE KEYS */;
44/*!40000 ALTER TABLE `animales` ENABLE KEYS */;
45UNLOCK TABLES;
46
47--
48-- Temporary view structure for view `animalescarnivoros`
49--
50
51DROP TABLE IF EXISTS `animalescarnivoros`;
52/*!50001 DROP VIEW IF EXISTS `animalescarnivoros`*/;
53SET @saved_cs_client = @@character_set_client;
54/*!50503 SET character_set_client = utf8mb4 */;
55/*!50001 CREATE VIEW `animalescarnivoros` AS SELECT
56 1 AS `id`,
57 1 AS `nombre`,
58 1 AS `FK_dieta`,
59 1 AS `FK_tamanyo`*/;
60SET character_set_client = @saved_cs_client;
61
62--
63-- Temporary view structure for view `animalesgrandes`
64--
65
66DROP TABLE IF EXISTS `animalesgrandes`;
67/*!50001 DROP VIEW IF EXISTS `animalesgrandes`*/;
68SET @saved_cs_client = @@character_set_client;
69/*!50503 SET character_set_client = utf8mb4 */;
70/*!50001 CREATE VIEW `animalesgrandes` AS SELECT
71 1 AS `id`,
72 1 AS `nombre`,
73 1 AS `FK_dieta`,
74 1 AS `FK_tamanyo`*/;
75SET character_set_client = @saved_cs_client;
76
77--
78-- Temporary view structure for view `animalesherbivoros`
79--
80
81DROP TABLE IF EXISTS `animalesherbivoros`;
82/*!50001 DROP VIEW IF EXISTS `animalesherbivoros`*/;
83SET @saved_cs_client = @@character_set_client;
84/*!50503 SET character_set_client = utf8mb4 */;
85/*!50001 CREATE VIEW `animalesherbivoros` AS SELECT
86 1 AS `id`,
87 1 AS `nombre`,
88 1 AS `FK_dieta`,
89 1 AS `FK_tamanyo`*/;
90SET character_set_client = @saved_cs_client;
91
92--
93-- Temporary view structure for view `animalesmedianos`
94--
95
96DROP TABLE IF EXISTS `animalesmedianos`;
97/*!50001 DROP VIEW IF EXISTS `animalesmedianos`*/;
98SET @saved_cs_client = @@character_set_client;
99/*!50503 SET character_set_client = utf8mb4 */;
100/*!50001 CREATE VIEW `animalesmedianos` AS SELECT
101 1 AS `id`,
102 1 AS `nombre`,
103 1 AS `FK_dieta`,
104 1 AS `FK_tamanyo`*/;
105SET character_set_client = @saved_cs_client;
106
107--
108-- Temporary view structure for view `animalesomnivoros`
109--
110
111DROP TABLE IF EXISTS `animalesomnivoros`;
112/*!50001 DROP VIEW IF EXISTS `animalesomnivoros`*/;
113SET @saved_cs_client = @@character_set_client;
114/*!50503 SET character_set_client = utf8mb4 */;
115/*!50001 CREATE VIEW `animalesomnivoros` AS SELECT
116 1 AS `id`,
117 1 AS `nombre`,
118 1 AS `FK_dieta`,
119 1 AS `FK_tamanyo`*/;
120SET character_set_client = @saved_cs_client;
121
122--
123-- Temporary view structure for view `animalespequenyos`
124--
125
126DROP TABLE IF EXISTS `animalespequenyos`;
127/*!50001 DROP VIEW IF EXISTS `animalespequenyos`*/;
128SET @saved_cs_client = @@character_set_client;
129/*!50503 SET character_set_client = utf8mb4 */;
130/*!50001 CREATE VIEW `animalespequenyos` AS SELECT
131 1 AS `id`,
132 1 AS `nombre`,
133 1 AS `FK_dieta`,
134 1 AS `FK_tamanyo`*/;
135SET character_set_client = @saved_cs_client;
136
137--
138-- Table structure for table `dietas`
139--
140
141DROP TABLE IF EXISTS `dietas`;
142/*!40101 SET @saved_cs_client = @@character_set_client */;
143/*!50503 SET character_set_client = utf8mb4 */;
144CREATE TABLE `dietas` (
145 `id` int NOT NULL AUTO_INCREMENT,
146 `nombre` varchar(45) NOT NULL DEFAULT '-vacio-',
147 PRIMARY KEY (`id`)
148) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
149/*!40101 SET character_set_client = @saved_cs_client */;
150
151--
152-- Dumping data for table `dietas`
153--
154
155LOCK TABLES `dietas` WRITE;
156/*!40000 ALTER TABLE `dietas` DISABLE KEYS */;
157INSERT INTO `dietas` VALUES (1,'Carnivoro'),(2,'Herbivoro'),(3,'Omnivoro');
158/*!40000 ALTER TABLE `dietas` ENABLE KEYS */;
159UNLOCK TABLES;
160
161--
162-- Table structure for table `tamanyos`
163--
164
165DROP TABLE IF EXISTS `tamanyos`;
166/*!40101 SET @saved_cs_client = @@character_set_client */;
167/*!50503 SET character_set_client = utf8mb4 */;
168CREATE TABLE `tamanyos` (
169 `id` int NOT NULL AUTO_INCREMENT,
170 `nombre` varchar(45) NOT NULL DEFAULT '-vacio-',
171 PRIMARY KEY (`id`)
172) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
173/*!40101 SET character_set_client = @saved_cs_client */;
174
175--
176-- Dumping data for table `tamanyos`
177--
178
179LOCK TABLES `tamanyos` WRITE;
180/*!40000 ALTER TABLE `tamanyos` DISABLE KEYS */;
181INSERT INTO `tamanyos` VALUES (1,'Grande'),(2,'Mediano'),(3,'Pequeño');
182/*!40000 ALTER TABLE `tamanyos` ENABLE KEYS */;
183UNLOCK TABLES;
184
185--
186-- Final view structure for view `animalescarnivoros`
187--
188
189/*!50001 DROP VIEW IF EXISTS `animalescarnivoros`*/;
190/*!50001 SET @saved_cs_client = @@character_set_client */;
191/*!50001 SET @saved_cs_results = @@character_set_results */;
192/*!50001 SET @saved_col_connection = @@collation_connection */;
193/*!50001 SET character_set_client = utf8mb4 */;
194/*!50001 SET character_set_results = utf8mb4 */;
195/*!50001 SET collation_connection = utf8mb4_0900_ai_ci */;
196/*!50001 CREATE ALGORITHM=UNDEFINED */
197/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
198/*!50001 VIEW `animalescarnivoros` AS select `animales`.`id` AS `id`,`animales`.`nombre` AS `nombre`,`animales`.`FK_dieta` AS `FK_dieta`,`animales`.`FK_tamanyo` AS `FK_tamanyo` from `animales` where (`animales`.`FK_dieta` like 1) */;
199/*!50001 SET character_set_client = @saved_cs_client */;
200/*!50001 SET character_set_results = @saved_cs_results */;
201/*!50001 SET collation_connection = @saved_col_connection */;
202
203--
204-- Final view structure for view `animalesgrandes`
205--
206
207/*!50001 DROP VIEW IF EXISTS `animalesgrandes`*/;
208/*!50001 SET @saved_cs_client = @@character_set_client */;
209/*!50001 SET @saved_cs_results = @@character_set_results */;
210/*!50001 SET @saved_col_connection = @@collation_connection */;
211/*!50001 SET character_set_client = utf8mb4 */;
212/*!50001 SET character_set_results = utf8mb4 */;
213/*!50001 SET collation_connection = utf8mb4_0900_ai_ci */;
214/*!50001 CREATE ALGORITHM=UNDEFINED */
215/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
216/*!50001 VIEW `animalesgrandes` AS select `animales`.`id` AS `id`,`animales`.`nombre` AS `nombre`,`animales`.`FK_dieta` AS `FK_dieta`,`animales`.`FK_tamanyo` AS `FK_tamanyo` from `animales` where (`animales`.`FK_tamanyo` like 1) */;
217/*!50001 SET character_set_client = @saved_cs_client */;
218/*!50001 SET character_set_results = @saved_cs_results */;
219/*!50001 SET collation_connection = @saved_col_connection */;
220
221--
222-- Final view structure for view `animalesherbivoros`
223--
224
225/*!50001 DROP VIEW IF EXISTS `animalesherbivoros`*/;
226/*!50001 SET @saved_cs_client = @@character_set_client */;
227/*!50001 SET @saved_cs_results = @@character_set_results */;
228/*!50001 SET @saved_col_connection = @@collation_connection */;
229/*!50001 SET character_set_client = utf8mb4 */;
230/*!50001 SET character_set_results = utf8mb4 */;
231/*!50001 SET collation_connection = utf8mb4_0900_ai_ci */;
232/*!50001 CREATE ALGORITHM=UNDEFINED */
233/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
234/*!50001 VIEW `animalesherbivoros` AS select `animales`.`id` AS `id`,`animales`.`nombre` AS `nombre`,`animales`.`FK_dieta` AS `FK_dieta`,`animales`.`FK_tamanyo` AS `FK_tamanyo` from `animales` where (`animales`.`FK_dieta` like 2) */;
235/*!50001 SET character_set_client = @saved_cs_client */;
236/*!50001 SET character_set_results = @saved_cs_results */;
237/*!50001 SET collation_connection = @saved_col_connection */;
238
239--
240-- Final view structure for view `animalesmedianos`
241--
242
243/*!50001 DROP VIEW IF EXISTS `animalesmedianos`*/;
244/*!50001 SET @saved_cs_client = @@character_set_client */;
245/*!50001 SET @saved_cs_results = @@character_set_results */;
246/*!50001 SET @saved_col_connection = @@collation_connection */;
247/*!50001 SET character_set_client = utf8mb4 */;
248/*!50001 SET character_set_results = utf8mb4 */;
249/*!50001 SET collation_connection = utf8mb4_0900_ai_ci */;
250/*!50001 CREATE ALGORITHM=UNDEFINED */
251/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
252/*!50001 VIEW `animalesmedianos` AS select `animales`.`id` AS `id`,`animales`.`nombre` AS `nombre`,`animales`.`FK_dieta` AS `FK_dieta`,`animales`.`FK_tamanyo` AS `FK_tamanyo` from `animales` where (`animales`.`FK_tamanyo` like 2) */;
253/*!50001 SET character_set_client = @saved_cs_client */;
254/*!50001 SET character_set_results = @saved_cs_results */;
255/*!50001 SET collation_connection = @saved_col_connection */;
256
257--
258-- Final view structure for view `animalesomnivoros`
259--
260
261/*!50001 DROP VIEW IF EXISTS `animalesomnivoros`*/;
262/*!50001 SET @saved_cs_client = @@character_set_client */;
263/*!50001 SET @saved_cs_results = @@character_set_results */;
264/*!50001 SET @saved_col_connection = @@collation_connection */;
265/*!50001 SET character_set_client = utf8mb4 */;
266/*!50001 SET character_set_results = utf8mb4 */;
267/*!50001 SET collation_connection = utf8mb4_0900_ai_ci */;
268/*!50001 CREATE ALGORITHM=UNDEFINED */
269/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
270/*!50001 VIEW `animalesomnivoros` AS select `animales`.`id` AS `id`,`animales`.`nombre` AS `nombre`,`animales`.`FK_dieta` AS `FK_dieta`,`animales`.`FK_tamanyo` AS `FK_tamanyo` from `animales` where (`animales`.`FK_dieta` like 3) */;
271/*!50001 SET character_set_client = @saved_cs_client */;
272/*!50001 SET character_set_results = @saved_cs_results */;
273/*!50001 SET collation_connection = @saved_col_connection */;
274
275--
276-- Final view structure for view `animalespequenyos`
277--
278
279/*!50001 DROP VIEW IF EXISTS `animalespequenyos`*/;
280/*!50001 SET @saved_cs_client = @@character_set_client */;
281/*!50001 SET @saved_cs_results = @@character_set_results */;
282/*!50001 SET @saved_col_connection = @@collation_connection */;
283/*!50001 SET character_set_client = utf8mb4 */;
284/*!50001 SET character_set_results = utf8mb4 */;
285/*!50001 SET collation_connection = utf8mb4_0900_ai_ci */;
286/*!50001 CREATE ALGORITHM=UNDEFINED */
287/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
288/*!50001 VIEW `animalespequenyos` AS select `animales`.`id` AS `id`,`animales`.`nombre` AS `nombre`,`animales`.`FK_dieta` AS `FK_dieta`,`animales`.`FK_tamanyo` AS `FK_tamanyo` from `animales` where (`animales`.`FK_tamanyo` like 3) */;
289/*!50001 SET character_set_client = @saved_cs_client */;
290/*!50001 SET character_set_results = @saved_cs_results */;
291/*!50001 SET collation_connection = @saved_col_connection */;
292/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
293
294/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
295/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
296/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
297/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
298/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
299/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
300/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
301
302-- Dump completed on 2021-05-03 8:39:39
303