SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';
-- -----------------------------------------------------
-- Table `pays`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `pays` ;
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `pays` (
`idpays` INT NOT NULL AUTO_INCREMENT ,
`paysfr` VARCHAR(100) NOT NULL ,
`paysen` VARCHAR(100) NOT NULL ,
`paysit` VARCHAR(100) NOT NULL ,
`paysde` VARCHAR(100) NOT NULL ,
`paysnl` VARCHAR(100) NOT NULL ,
`payses` VARCHAR(100) NOT NULL ,
`payspt` VARCHAR(100) NOT NULL ,
PRIMARY KEY (`idpays`) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;
SHOW WARNINGS;
-- -----------------------------------------------------
-- Table `ville`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `ville` ;
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `ville` (
`idville` INT NOT NULL AUTO_INCREMENT ,
`villefr` VARCHAR(150) NOT NULL ,
`paysfr` VARCHAR(100) NOT NULL ,
`villeen` VARCHAR(150) NOT NULL ,
`paysen` VARCHAR(100) NOT NULL ,
`villeit` VARCHAR(150) NOT NULL ,
`paysit` VARCHAR(100) NOT NULL ,
`villede` VARCHAR(150) NOT NULL ,
`paysde` VARCHAR(100) NOT NULL ,
`villenl` VARCHAR(150) NOT NULL ,
`paysnl` VARCHAR(100) NOT NULL ,
`villees` VARCHAR(150) NOT NULL ,
`payses` VARCHAR(100) NOT NULL ,
`villept` VARCHAR(150) NOT NULL ,
`payspt` VARCHAR(100) NOT NULL ,
PRIMARY KEY (`idville`) ,
CONSTRAINT `paysfr`
FOREIGN KEY (`paysfr` )
REFERENCES `mydb`.`pays` (`paysfr` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `paysen`
FOREIGN KEY (`paysen` )
REFERENCES `mydb`.`pays` (`paysen` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `paysit`
FOREIGN KEY (`paysit` )
REFERENCES `mydb`.`pays` (`paysit` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `paysde`
FOREIGN KEY (`paysde` )
REFERENCES `mydb`.`pays` (`paysde` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `paysnl`
FOREIGN KEY (`paysnl` )
REFERENCES `mydb`.`pays` (`paysnl` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `payses`
FOREIGN KEY (`payses` )
REFERENCES `mydb`.`pays` (`payses` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `payspt`
FOREIGN KEY (`payspt` )
REFERENCES `mydb`.`pays` (`payspt` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;
SHOW WARNINGS;
CREATE INDEX `paysfr` ON `ville` (`paysfr` ASC) ;
SHOW WARNINGS;
CREATE INDEX `paysen` ON `ville` (`paysen` ASC) ;
SHOW WARNINGS;
CREATE INDEX `paysit` ON `ville` (`paysit` ASC) ;
SHOW WARNINGS;
CREATE INDEX `paysde` ON `ville` (`paysde` ASC) ;
SHOW WARNINGS;
CREATE INDEX `paysnl` ON `ville` (`paysnl` ASC) ;
SHOW WARNINGS;
CREATE INDEX `payses` ON `ville` (`payses` ASC) ;
SHOW WARNINGS;
CREATE INDEX `payspt` ON `ville` (`payspt` ASC) ;
SHOW WARNINGS;
-- -----------------------------------------------------
-- Table `cpostaux`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `cpostaux` ;
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `cpostaux` (
`idcpostaux` INT NOT NULL AUTO_INCREMENT ,
`cp` VARCHAR(15) NOT NULL ,
`villefr` VARCHAR(150) NOT NULL ,
`villeen` VARCHAR(150) NOT NULL ,
`villeit` VARCHAR(150) NOT NULL ,
`villede` VARCHAR(150) NOT NULL ,
`villenl` VARCHAR(150) NOT NULL ,
`villees` VARCHAR(150) NOT NULL ,
`villept` VARCHAR(150) NOT NULL ,
PRIMARY KEY (`idcpostaux`) ,
CONSTRAINT `villefr`
FOREIGN KEY (`villefr` )
REFERENCES `mydb`.`ville` (`villefr` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `villeen`
FOREIGN KEY (`villeen` )
REFERENCES `mydb`.`ville` (`villeen` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `villeit`
FOREIGN KEY (`villeit` )
REFERENCES `mydb`.`ville` (`villeit` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `villede`
FOREIGN KEY (`villede` )
REFERENCES `mydb`.`ville` (`villede` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `villenl`
FOREIGN KEY (`villenl` )
REFERENCES `mydb`.`ville` (`villenl` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `villees`
FOREIGN KEY (`villees` )
REFERENCES `mydb`.`ville` (`villees` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `villept`
FOREIGN KEY (`villept` )
REFERENCES `mydb`.`ville` (`villefr` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;
SHOW WARNINGS;
CREATE INDEX `villefr` ON `cpostaux` (`villefr` ASC) ;
SHOW WARNINGS;
CREATE INDEX `villeen` ON `cpostaux` (`villeen` ASC) ;
SHOW WARNINGS;
CREATE INDEX `villeit` ON `cpostaux` (`villeit` ASC) ;
SHOW WARNINGS;
CREATE INDEX `villede` ON `cpostaux` (`villede` ASC) ;
SHOW WARNINGS;
CREATE INDEX `villenl` ON `cpostaux` (`villenl` ASC) ;
SHOW WARNINGS;
CREATE INDEX `villees` ON `cpostaux` (`villees` ASC) ;
SHOW WARNINGS;
CREATE INDEX `villept` ON `cpostaux` (`villept` ASC) ;
SHOW WARNINGS;
SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
Partager