Chrono-Cross  1.1
BTS SN-IR La Salle Avignon 2018
Base de données MySQL

CREATE DATABASE IF NOT EXISTS `Chrono-cross`;

USE `Chrono-cross`;

CREATE TABLE IF NOT EXISTS `Categorie` ( `idCategorie` int(11) NOT NULL AUTO_INCREMENT, `Nom` varchar(64) NOT NULL, `Sexe` enum('M','F') NOT NULL, PRIMARY KEY (`idCategorie`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `Classe` ( `idClasse` int(11) NOT NULL AUTO_INCREMENT, `Nom` varchar(64) NOT NULL, `Numero` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`idClasse`), CONSTRAINT Unique_Classe UNIQUE (`Nom`,`Numero`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `Coureur` ( `idCoureur` int(11) NOT NULL AUTO_INCREMENT, `idCategorie` int(11) NOT NULL, `idClasse` int(11) NOT NULL, `INE` varchar(11) NOT NULL, `Nom` varchar(64) NOT NULL, `Prenom` varchar(64) NOT NULL, `DateNaissance` date NOT NULL, `Sexe` enum('M','F') NOT NULL, PRIMARY KEY (`idCoureur`), CONSTRAINT Unique_Coureur UNIQUE (`INE`), CONSTRAINT Coureur_fk_1 FOREIGN KEY (`idCategorie`) REFERENCES Categorie(`idCategorie`) ON DELETE CASCADE, CONSTRAINT Coureur_fk_2 FOREIGN KEY (`idClasse`) REFERENCES Classe(`idClasse`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `Manifestation` ( `idManifestation` int(11) NOT NULL AUTO_INCREMENT, `Nom` varchar(255) NOT NULL, `Date` date NOT NULL, PRIMARY KEY (`idManifestation`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `Course` ( `idCourse` int(11) NOT NULL AUTO_INCREMENT, `idManifestation` int(11) NOT NULL, `Nom` varchar(255) NOT NULL, `Distance` int(11) NOT NULL, `HeureDepart` time NOT NULL, PRIMARY KEY (`idCourse`), CONSTRAINT Course_fk_1 FOREIGN KEY (`idManifestation`) REFERENCES Manifestation(`idManifestation`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `Inscrit` ( `idInscrit` int(11) NOT NULL AUTO_INCREMENT, `idCoureur` int(11) NOT NULL, `idCourse` int(11) NOT NULL, `NumeroDossard` varchar(16) NOT NULL, PRIMARY KEY (`idInscrit`), CONSTRAINT Unique_CoureurCourse UNIQUE (`idCoureur`,`idCourse`), CONSTRAINT Inscrit_fk_1 FOREIGN KEY (`idCoureur`) REFERENCES Coureur(`idCoureur`) ON DELETE CASCADE, CONSTRAINT Inscrit_fk_2 FOREIGN KEY (`idCourse`) REFERENCES Course(`idCourse`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `Arrivee` ( `idArrivee` int(11) NOT NULL AUTO_INCREMENT, `idInscrit` int(11) NOT NULL, `Temps` time NOT NULL, PRIMARY KEY (`idArrivee`), CONSTRAINT Arrivee_fk_1 FOREIGN KEY (`idInscrit`) REFERENCES Inscrit(`idInscrit`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

 Tout Classes Fichiers Fonctions Variables Macros