Pasted

-- MySQL Script generated by MySQL Workbench
-- 03/20/16 16:23:45
-- Model: New Model    Version: 1.0
-- MySQL Workbench Forward Engineering
 
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,ALLOW_INVALID_DATES';
 
-- -----------------------------------------------------
-- Schema mydb
-- -----------------------------------------------------
 
-- -----------------------------------------------------
-- Schema mydb
-- -----------------------------------------------------
CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
USE `mydb` ;
 
-- -----------------------------------------------------
-- Table `mydb`.`Client`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Client` (
  `IdClient` INT NOT NULL AUTO_INCREMENT,
  `Nom` VARCHAR(32) NOT NULL,
  `Prenom` VARCHAR(32) NOT NULL,
  `Sexe` TINYINT(1) NOT NULL,
  `DDN` DATE NOT NULL,
  `Pcode` INT NOT NULL,
  `Score` INT NOT NULL,
  PRIMARY KEY (`IdClient`))
ENGINE = InnoDB;
 
 
-- -----------------------------------------------------
-- Table `mydb`.`Sport`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Sport` (
  `IdSport` INT NOT NULL,
  `Nom` VARCHAR(128) NOT NULL,
  `NbMin` INT NOT NULL,
  `NbMax` INT NOT NULL,
  PRIMARY KEY (`IdSport`))
ENGINE = InnoDB;
 
 
-- -----------------------------------------------------
-- Table `mydb`.`Lieu`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Lieu` (
  `IdLieu` INT NOT NULL,
  `Intitule` VARCHAR(256) NOT NULL,
  `PCode` INT NOT NULL,
  `Capacite` INT NOT NULL,
  `Sport_IdSport` INT NOT NULL,
  PRIMARY KEY (`IdLieu`, `Sport_IdSport`),
  INDEX `fk_Lieu_Sport1_idx` (`Sport_IdSport` ASC),
  CONSTRAINT `fk_Lieu_Sport1`
    FOREIGN KEY (`Sport_IdSport`)
    REFERENCES `mydb`.`Sport` (`IdSport`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;
 
 
-- -----------------------------------------------------
-- Table `mydb`.`Evenement`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Evenement` (
  `IdEv` INT NOT NULL AUTO_INCREMENT,
  `Niveau` INT NOT NULL,
  `Date` DATE NOT NULL,
  `Client_idClient` INT NOT NULL,
  `Lieu_IdLieu` INT NOT NULL,
  PRIMARY KEY (`IdEv`, `Client_idClient`, `Lieu_IdLieu`),
  INDEX `fk_Evenement_Client1_idx` (`Client_idClient` ASC),
  INDEX `fk_Evenement_Lieu1_idx` (`Lieu_IdLieu` ASC),
  CONSTRAINT `fk_Evenement_Client1`
    FOREIGN KEY (`Client_idClient`)
    REFERENCES `mydb`.`Client` (`IdClient`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_Evenement_Lieu1`
    FOREIGN KEY (`Lieu_IdLieu`)
    REFERENCES `mydb`.`Lieu` (`IdLieu`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;
 
 
-- -----------------------------------------------------
-- Table `mydb`.`participe`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`participe` (
  `Client_idClient` INT NOT NULL,
  `Evenement_idEv` INT NOT NULL,
  PRIMARY KEY (`Client_idClient`, `Evenement_idEv`),
  INDEX `fk_Client_has_Evenement_Evenement1_idx` (`Evenement_idEv` ASC),
  INDEX `fk_Client_has_Evenement_Client_idx` (`Client_idClient` ASC),
  CONSTRAINT `fk_Client_has_Evenement_Client`
    FOREIGN KEY (`Client_idClient`)
    REFERENCES `mydb`.`Client` (`IdClient`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_Client_has_Evenement_Evenement1`
    FOREIGN KEY (`Evenement_idEv`)
    REFERENCES `mydb`.`Evenement` (`IdEv`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;
 
 
-- -----------------------------------------------------
-- Table `mydb`.`Terrain`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Terrain` (
  `Surface` INT NOT NULL,
  `Type` VARCHAR(45) NOT NULL,
  `IdTer` INT NOT NULL,
  `Lieu_IdLieu` INT NOT NULL,
  PRIMARY KEY (`IdTer`, `Lieu_IdLieu`),
  INDEX `fk_Terrain_Lieu1_idx` (`Lieu_IdLieu` ASC),
  CONSTRAINT `fk_Terrain_Lieu1`
    FOREIGN KEY (`Lieu_IdLieu`)
    REFERENCES `mydb`.`Lieu` (`IdLieu`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;
 
 
SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;