21sTrgPy

1CREATE DATABASE  IF NOT EXISTS `bd_comics1` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
2USE `bd_comics`;
3-- MySQL dump 10.13  Distrib 8.0.22, for Win64 (x86_64)
4--
5-- Host: 127.0.0.1    Database: bd_comics
6-- ------------------------------------------------------
7-- Server version	8.0.22
8
9--
10-- Table structure for table `comics`
11--
12
13DROP TABLE IF EXISTS `comics`;
14
15CREATE TABLE comics` (
16  `id` int NOT NULL AUTO_INCREMENT,
17  `titulo` varchar(100) NOT NULL,
18  `numero` varchar(45) NOT NULL,
19  `FK_serie` int DEFAULT '0',
20  `FK_editor` int DEFAULT '0',
21  PRIMARY KEY (`id`),
22  KEY `comics_ibfk_1` (`FK_serie`),
23  KEY `comics_ibfk_2` (`FK_editor`),
24  CONSTRAINT `comics_ibfk_1` FOREIGN KEY (`FK_serie`) REFERENCES `series` (`id`),
25  CONSTRAINT `comics_ibfk_2` FOREIGN KEY (`FK_editor`) REFERENCES `editores` (`id`) ON UPDATE RESTRICT
26) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
27
28
29--
30-- Dumping data for table `comics`
31--
32
33LOCK TABLES `comics` WRITE;
34INSERT INTO `comics` VALUES 
35(1,'Homecoming, Part one','21',3,1),
36(2,'Homecoming, Part Two','22',3,1),
37(3,'Homecoming, Part Three','23',3,1),
38(4,'Homecoming, Conclusion: The Battle of Central Park','24',3,1),
39(5,'Deadpool & Cable: Two Mutants & a Baby','25A',3,1);
40UNLOCK TABLES;
41
42--
43-- Table structure for table `editores`
44--
45
46DROP TABLE IF EXISTS `editores`;
47
48CREATE TABLE `editores` (
49  `id` int NOT NULL AUTO_INCREMENT,
50  `nombre` varchar(45) NOT NULL,
51  PRIMARY KEY (`id`)
52) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
53
54
55--
56-- Dumping data for table `editores`
57--
58
59LOCK TABLES `editores` WRITE;
60INSERT INTO `editores` VALUES 
61(1,'Marvel Comics'),
62(2,'DC Comics'),
63(3,'Dark Horse Comics'),
64(4,'Zenscope Ent'),
65(5,'Dynamite Entertainment');
66UNLOCK TABLES;
67
68--
69-- Table structure for table `series`
70--
71
72DROP TABLE IF EXISTS `series`;
73CREATE TABLE `series` (
74  `id` int NOT NULL AUTO_INCREMENT,
75  `nombre` varchar(45) NOT NULL,
76  PRIMARY KEY (`id`)
77) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
78
79
80--
81-- Dumping data for table `series`
82--
83
84LOCK TABLES `series` WRITE;
85/*!40000 ALTER TABLE `series` DISABLE KEYS */;
86INSERT INTO `series` VALUES 
87(1,'Batman'),
88(2,'The Boys'),
89(3,'Cable, Vol. 2'),
90(4,'Grimm Fairy Tales: April Fools'),
91(5,'Red Sonja: She-Devil With A Sword');
92UNLOCK TABLES;
93
94--
95-- Dumping routines for database 'bd_comics'
96--
97DELIMITER ;;
98CREATE DEFINER=`root`@`localhost` PROCEDURE `borrar_datos`()
99BEGIN
100SET FOREIGN_KEY_CHECKS = 0;
101truncate table comics;
102truncate table editores;
103truncate table series;
104SET FOREIGN_KEY_CHECKS = 1;
105END ;;
106DELIMITER ;
107DELIMITER ;;
108CREATE DEFINER=`root`@`localhost` PROCEDURE `cargar_datos`()
109BEGIN
110
111insert into series values(1,"Batman");
112insert into series values(2,"The Boys");
113insert into series values(3,"Cable, Vol. 2");
114insert into series values(4,"Grimm Fairy Tales: April Fools");
115insert into series values(5,"Red Sonja: She-Devil With A Sword");
116
117INSERT INTO editores VALUES (1,'Marvel Comics');
118INSERT INTO editores VALUES (2,'DC Comics');
119INSERT INTO editores VALUES (3,'Dark Horse Comics');
120INSERT INTO editores VALUES (4,'Zenscope Ent');
121INSERT INTO editores VALUES (5,'Dynamite Entertainment');
122
123INSERT INTO comics(id,FK_serie,numero, titulo,FK_editor) VALUES (null,3,"21","Homecoming, Part one",1);
124INSERT INTO comics(id,FK_serie,numero, titulo,FK_editor)  VALUES (null,3,"22","Homecoming, Part Two",1);
125INSERT INTO comics(id,FK_serie,numero, titulo,FK_editor)  VALUES (null,3,"23","Homecoming, Part Three",1);
126INSERT INTO comics(id,FK_serie,numero, titulo,FK_editor)  VALUES (null,3,"24","Homecoming, Conclusion: The Battle of Central Park",1);
127INSERT INTO comics(id,FK_serie,numero, titulo,FK_editor)  VALUES (null,3,"25A","Deadpool & Cable: Two Mutants & a Baby",1);
128
129
130
131
132END ;;
133DELIMITER ;;
134CREATE DEFINER=`root`@`localhost` PROCEDURE `new_procedure`()
135BEGIN
136insert into series values(1,"Batman");
137insert into series values(2,"The Boys");
138insert into series values(3,"Cable, Vol. 2");
139insert into series values(4,"Grimm Fairy Tales: April Fools");
140insert into series values(5,"Red Sonja: She-Devil With A Sword");
141
142INSERT INTO editores VALUES (1,'Marvel Comics');
143INSERT INTO editores VALUES (2,'DC Comics');
144INSERT INTO editores VALUES (3,'Dark Horse Comics');
145INSERT INTO editores VALUES (4,'Zenscope Ent');
146INSERT INTO editores VALUES (5,'Dynamite Entertainment');
147
148END ;;
149DELIMITER ;