8PLa1Kas

1-- phpMyAdmin SQL Dump
2-- version 4.7.0
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1
6-- Generation Time: Jan 31, 2018 at 10:24 AM
7-- Server version: 10.1.26-MariaDB
8-- PHP Version: 7.1.8
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Database: `got`
23--
24CREATE DATABASE IF NOT EXISTS `got` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
25USE `got`;
26-- --------------------------------------------------------
27
28--
29-- Table structure for table `casas`
30--
31
32CREATE TABLE `casas` (
33  `id_Casa` int(11) NOT NULL,
34  `NombreCasa` varchar(45) NOT NULL
35) ENGINE=InnoDB DEFAULT CHARSET=latin1;
36
37--
38-- Dumping data for table `casas`
39--
40
41INSERT INTO `casas` (`id_Casa`, `NombreCasa`) VALUES
42(1, 'EYO');
43
44-- --------------------------------------------------------
45
46--
47-- Table structure for table `personajes`
48--
49
50CREATE TABLE `personajes` (
51  `id_personaje` int(11) NOT NULL,
52  `nombre` varchar(45) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
53  `nombre_actor` varchar(45) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
54  `edad` int(11) NOT NULL,
55  `altura` double NOT NULL,
56  `id_Casa` int(11) DEFAULT NULL
57) ENGINE=InnoDB DEFAULT CHARSET=latin1;
58
59--
60-- Dumping data for table `personajes`
61--
62
63INSERT INTO `personajes` (`id_personaje`, `nombre`, `nombre_actor`, `edad`, `altura`, `id_Casa`) VALUES
64(1, 'Daenerys Targaryen', 'Emilia Clarke', 20, 157, 1),
65(2, 'Jon Snow', 'Kit Harington', 30, 173, 1),
66(3, 'Cersei Lannister', 'Lena Headey', 43, 166, 1),
67(4, 'Jaime Lannister', 'Nikolaj Coster-Waldau', 47, 187, 1),
68(5, 'Tyrion Lannister', 'Peter Dinklage', 48, 134, 1),
69(8, 'Zamorano', 'Manuel Blanco', 25, 185, 1),
70(9, 'Jordi Niño', 'Eduardo Lafoz', 19, 187, 1),
71(10, 'Pochinky King', 'Ramses Diez', 27, 174, 1),
72(11, 'Barbas Hipster', 'Sergio Redondo', 24, 180, 1);
73
74--
75-- Indexes for dumped tables
76--
77
78--
79-- Indexes for table `casas`
80--
81ALTER TABLE `casas`
82  ADD PRIMARY KEY (`id_Casa`),
83  ADD KEY `id_Casa` (`id_Casa`);
84
85--
86-- Indexes for table `personajes`
87--
88ALTER TABLE `personajes`
89  ADD PRIMARY KEY (`id_personaje`),
90  ADD UNIQUE KEY `nombre` (`nombre`),
91  ADD KEY `id_Casa` (`id_Casa`);
92
93--
94-- AUTO_INCREMENT for dumped tables
95--
96
97--
98-- AUTO_INCREMENT for table `casas`
99--
100ALTER TABLE `casas`
101  MODIFY `id_Casa` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
102--
103-- AUTO_INCREMENT for table `personajes`
104--
105ALTER TABLE `personajes`
106  MODIFY `id_personaje` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
107--
108-- Constraints for dumped tables
109--
110
111--
112-- Constraints for table `personajes`
113--
114ALTER TABLE `personajes`
115  ADD CONSTRAINT `personajes_ibfk_1` FOREIGN KEY (`id_Casa`) REFERENCES `casas` (`id_Casa`);
116COMMIT;
117
118/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
119/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
120/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;