TT22

Untitled

Mar 20th, 2016
5,069
0
Never
1
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -- MySQL Script generated by MySQL Workbench
  2. -- 03/20/16 16:23:45
  3. -- Model: New Model    Version: 1.0
  4. -- MySQL Workbench Forward Engineering
  5.  
  6. SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
  7. SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
  8. SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
  9.  
  10. -- -----------------------------------------------------
  11. -- Schema mydb
  12. -- -----------------------------------------------------
  13.  
  14. -- -----------------------------------------------------
  15. -- Schema mydb
  16. -- -----------------------------------------------------
  17. CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
  18. USE `mydb` ;
  19.  
  20. -- -----------------------------------------------------
  21. -- Table `mydb`.`Client`
  22. -- -----------------------------------------------------
  23. CREATE TABLE IF NOT EXISTS `mydb`.`Client` (
  24.   `IdClient` INT NOT NULL AUTO_INCREMENT,
  25.   `Nom` VARCHAR(32) NOT NULL,
  26.   `Prenom` VARCHAR(32) NOT NULL,
  27.   `Sexe` TINYINT(1) NOT NULL,
  28.   `DDN` DATE NOT NULL,
  29.   `Pcode` INT NOT NULL,
  30.   `Score` INT NOT NULL,
  31.   PRIMARY KEY (`IdClient`))
  32. ENGINE = InnoDB;
  33.  
  34.  
  35. -- -----------------------------------------------------
  36. -- Table `mydb`.`Sport`
  37. -- -----------------------------------------------------
  38. CREATE TABLE IF NOT EXISTS `mydb`.`Sport` (
  39.   `IdSport` INT NOT NULL,
  40.   `Nom` VARCHAR(128) NOT NULL,
  41.   `NbMin` INT NOT NULL,
  42.   `NbMax` INT NOT NULL,
  43.   PRIMARY KEY (`IdSport`))
  44. ENGINE = InnoDB;
  45.  
  46.  
  47. -- -----------------------------------------------------
  48. -- Table `mydb`.`Lieu`
  49. -- -----------------------------------------------------
  50. CREATE TABLE IF NOT EXISTS `mydb`.`Lieu` (
  51.   `IdLieu` INT NOT NULL,
  52.   `Intitule` VARCHAR(256) NOT NULL,
  53.   `PCode` INT NOT NULL,
  54.   `Capacite` INT NOT NULL,
  55.   `Sport_IdSport` INT NOT NULL,
  56.   PRIMARY KEY (`IdLieu`, `Sport_IdSport`),
  57.   INDEX `fk_Lieu_Sport1_idx` (`Sport_IdSport` ASC),
  58.   CONSTRAINT `fk_Lieu_Sport1`
  59.     FOREIGN KEY (`Sport_IdSport`)
  60.     REFERENCES `mydb`.`Sport` (`IdSport`)
  61.     ON DELETE NO ACTION
  62.     ON UPDATE NO ACTION)
  63. ENGINE = InnoDB;
  64.  
  65.  
  66. -- -----------------------------------------------------
  67. -- Table `mydb`.`Evenement`
  68. -- -----------------------------------------------------
  69. CREATE TABLE IF NOT EXISTS `mydb`.`Evenement` (
  70.   `IdEv` INT NOT NULL AUTO_INCREMENT,
  71.   `Niveau` INT NOT NULL,
  72.   `Date` DATE NOT NULL,
  73.   `Client_idClient` INT NOT NULL,
  74.   `Lieu_IdLieu` INT NOT NULL,
  75.   PRIMARY KEY (`IdEv`, `Client_idClient`, `Lieu_IdLieu`),
  76.   INDEX `fk_Evenement_Client1_idx` (`Client_idClient` ASC),
  77.   INDEX `fk_Evenement_Lieu1_idx` (`Lieu_IdLieu` ASC),
  78.   CONSTRAINT `fk_Evenement_Client1`
  79.     FOREIGN KEY (`Client_idClient`)
  80.     REFERENCES `mydb`.`Client` (`IdClient`)
  81.     ON DELETE NO ACTION
  82.     ON UPDATE NO ACTION,
  83.   CONSTRAINT `fk_Evenement_Lieu1`
  84.     FOREIGN KEY (`Lieu_IdLieu`)
  85.     REFERENCES `mydb`.`Lieu` (`IdLieu`)
  86.     ON DELETE NO ACTION
  87.     ON UPDATE NO ACTION)
  88. ENGINE = InnoDB;
  89.  
  90.  
  91. -- -----------------------------------------------------
  92. -- Table `mydb`.`participe`
  93. -- -----------------------------------------------------
  94. CREATE TABLE IF NOT EXISTS `mydb`.`participe` (
  95.   `Client_idClient` INT NOT NULL,
  96.   `Evenement_idEv` INT NOT NULL,
  97.   PRIMARY KEY (`Client_idClient`, `Evenement_idEv`),
  98.   INDEX `fk_Client_has_Evenement_Evenement1_idx` (`Evenement_idEv` ASC),
  99.   INDEX `fk_Client_has_Evenement_Client_idx` (`Client_idClient` ASC),
  100.   CONSTRAINT `fk_Client_has_Evenement_Client`
  101.     FOREIGN KEY (`Client_idClient`)
  102.     REFERENCES `mydb`.`Client` (`IdClient`)
  103.     ON DELETE NO ACTION
  104.     ON UPDATE NO ACTION,
  105.   CONSTRAINT `fk_Client_has_Evenement_Evenement1`
  106.     FOREIGN KEY (`Evenement_idEv`)
  107.     REFERENCES `mydb`.`Evenement` (`IdEv`)
  108.     ON DELETE NO ACTION
  109.     ON UPDATE NO ACTION)
  110. ENGINE = InnoDB;
  111.  
  112.  
  113. -- -----------------------------------------------------
  114. -- Table `mydb`.`Terrain`
  115. -- -----------------------------------------------------
  116. CREATE TABLE IF NOT EXISTS `mydb`.`Terrain` (
  117.   `Surface` INT NOT NULL,
  118.   `Type` VARCHAR(45) NOT NULL,
  119.   `IdTer` INT NOT NULL,
  120.   `Lieu_IdLieu` INT NOT NULL,
  121.   PRIMARY KEY (`IdTer`, `Lieu_IdLieu`),
  122.   INDEX `fk_Terrain_Lieu1_idx` (`Lieu_IdLieu` ASC),
  123.   CONSTRAINT `fk_Terrain_Lieu1`
  124.     FOREIGN KEY (`Lieu_IdLieu`)
  125.     REFERENCES `mydb`.`Lieu` (`IdLieu`)
  126.     ON DELETE NO ACTION
  127.     ON UPDATE NO ACTION)
  128. ENGINE = InnoDB;
  129.  
  130.  
  131. SET SQL_MODE=@OLD_SQL_MODE;
  132. SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
  133. SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
Advertisement
Comments
  • User was banned
Add Comment
Please, Sign In to add comment