Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- 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;
Advertisement