FgQhL4pY

1-- phpMyAdmin SQL Dump
2-- version 4.0.10deb1
3-- http://www.phpmyadmin.net
4--
5-- Servidor: localhost
6-- Tiempo de generación: 01-02-2017 a las 13:46:13
7-- Versión del servidor: 5.5.54-0ubuntu0.14.04.1
8-- Versión de PHP: 5.5.9-1ubuntu4.20
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Base de datos: `examen`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Estructura de tabla para la tabla `invento`
27--
28
29CREATE TABLE IF NOT EXISTS `invento` (
30  `id` int(11) NOT NULL AUTO_INCREMENT,
31  `name` varchar(50) COLLATE utf8_bin NOT NULL,
32  `inventor` int(11) NOT NULL,
33  PRIMARY KEY (`id`,`inventor`),
34  KEY `inventor` (`inventor`)
35) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=13 ;
36
37--
38-- Volcado de datos para la tabla `invento`
39--
40
41INSERT INTO `invento` (`id`, `name`, `inventor`) VALUES
42(10, 'a', 13),
43(11, 'f', 14),
44(12, 'b', 13);
45
46-- --------------------------------------------------------
47
48--
49-- Estructura de tabla para la tabla `inventor`
50--
51
52CREATE TABLE IF NOT EXISTS `inventor` (
53  `id` int(11) NOT NULL AUTO_INCREMENT,
54  `name` varchar(50) COLLATE utf8_bin NOT NULL,
55  PRIMARY KEY (`id`)
56) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=15 ;
57
58--
59-- Volcado de datos para la tabla `inventor`
60--
61
62INSERT INTO `inventor` (`id`, `name`) VALUES
63(1, 'Jhon Harrington'),
64(2, 'Johann Gutenberg'),
65(3, 'Benjamin Franklin'),
66(4, 'Samuel Colt'),
67(5, 'Alexander Fleming'),
68(13, 'a'),
69(14, 'f');
70
71--
72-- Restricciones para tablas volcadas
73--
74
75--
76-- Filtros para la tabla `invento`
77--
78ALTER TABLE `invento`
79  ADD CONSTRAINT `invento_ibfk_1` FOREIGN KEY (`inventor`) REFERENCES `inventor` (`id`);
80
81/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
82/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
83/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;