SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";
--
-- Base de datos: `ejerhibernate`
--
CREATE TABLE `departamento` (
`idDepartamento` int(11) NOT NULL,
`nombre` varchar(255) COLLATE utf8_spanish_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
CREATE TABLE `empleado` (
`idEmpleado` int(11) NOT NULL,
`nombre` varchar(255) COLLATE utf8_spanish_ci NOT NULL,
`apellidos` varchar(255) COLLATE utf8_spanish_ci NOT NULL,
`idDepartamento` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
ALTER TABLE `departamento`
ADD PRIMARY KEY (`idDepartamento`);
ALTER TABLE `empleado`
ADD PRIMARY KEY (`idEmpleado`),
ADD KEY `idDepartamento` (`idDepartamento`);
ALTER TABLE `departamento`
MODIFY `idDepartamento` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
ALTER TABLE `empleado`
MODIFY `idEmpleado` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
ALTER TABLE `empleado`
ADD CONSTRAINT `empleado_ibfk_1` FOREIGN KEY (`idDepartamento`) REFERENCES `departamento` (`idDepartamento`);
COMMIT;