qmEJ7Dxh

1SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
2SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
3SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';
4
5CREATE SCHEMA IF NOT EXISTS `esfgroup` DEFAULT CHARACTER SET utf8 COLLATE utf8_spanish_ci ;
6USE `esfgroup` ;
7
8-- -----------------------------------------------------
9-- Table `esfgroup`.`alumno`
10-- -----------------------------------------------------
11DROP TABLE IF EXISTS `esfgroup`.`alumno` ;
12
13CREATE  TABLE IF NOT EXISTS `esfgroup`.`alumno` (
14  `idAlumno` INT(11) NOT NULL AUTO_INCREMENT ,
15  `Nombre` VARCHAR(50) CHARACTER SET 'utf8' COLLATE 'utf8_spanish_ci' NOT NULL ,
16  `Apellidos` VARCHAR(100) CHARACTER SET 'utf8' COLLATE 'utf8_spanish_ci' NOT NULL ,
17  `Dni` VARCHAR(14) CHARACTER SET 'utf8' COLLATE 'utf8_spanish_ci' NOT NULL ,
18  PRIMARY KEY (`idAlumno`) )
19ENGINE = InnoDB
20AUTO_INCREMENT = 3
21DEFAULT CHARACTER SET = utf8
22COLLATE = utf8_spanish_ci;
23
24
25-- -----------------------------------------------------
26-- Table `esfgroup`.`poblacion`
27-- -----------------------------------------------------
28DROP TABLE IF EXISTS `esfgroup`.`poblacion` ;
29
30CREATE  TABLE IF NOT EXISTS `esfgroup`.`poblacion` (
31  `IdPoblacion` INT NOT NULL AUTO_INCREMENT ,
32  `Nombre` VARCHAR(50) NOT NULL ,
33  PRIMARY KEY (`IdPoblacion`) )
34ENGINE = InnoDB;
35
36
37
38SET SQL_MODE=@OLD_SQL_MODE;
39SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
40SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
41
42-- -----------------------------------------------------
43-- Data for table `esfgroup`.`poblacion`
44-- -----------------------------------------------------
45START TRANSACTION;
46USE `esfgroup`;
47INSERT INTO `esfgroup`.`poblacion` (`IdPoblacion`, `Nombre`) VALUES (NULL, 'Barcelona');
48INSERT INTO `esfgroup`.`poblacion` (`IdPoblacion`, `Nombre`) VALUES (NULL, 'Madrid');
49
50COMMIT;