Jeux-Olympique.sql

--
-- Structure de la table `athlete`
--

CREATE TABLE IF NOT EXISTS `athlete` (
  `nom` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `prenom` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `nation` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `dateNaissance` date NOT NULL,
  `discipline` varchar(20) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

Insert into `athlete` (`nom`,`prenom`,`nation`,`dateNaissance`,`discipline`) VALUES
('AGNEL','Yannick','France','1992-06-09','natation'),
('ALGOTSSON OSTHOLT','Sara','Suede','1974-08-12','equitation'),
('AUFFARTH','Sandra','Allemagne','1986-12-27','equitation'),
('BLAKE','Yohan','Jamaique','1989-12-26','athletisme'),
('BOLT','Usain','Jamaique','1986-08-21','athletisme'),
('CAMPBELL','Alan','Grande bretagne','1983-05-09','aviron'),
('DRYSDALE','Mahe','Nouvelle zelande','1978-11-19','aviron'),
('GATLIN','Justin','USA','1982-02-10','athletisme'),
('GRUDA','Sandrine','France','1987-06-25','basketball'),
('JACKSON','Lauren','Australie','1981-05-11',' basketball'),
('JUNG','Michael','Allemagne','1982-07-31','equitation'),
('PARK','Taehwan','Koree','1989-09-27','natation'),
('PARKER','Candace','USA','1986-04-19','basketball'),
('SUN','Yan','Chine','1991-12-01','natation'),
('SYNEK','Ondrej','Republique tcheque','1982-10-13','aviron');
-- --------------------------------------------------------

--
-- Structure de la table `epreuve`
--

CREATE TABLE IF NOT EXISTS `epreuve` (
  `codeEpreuve` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `nom` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `discipline` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `lieu` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `ville` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `dateEpreuve` date NOT NULL,
  `recordMonde` float NOT NULL,
  `recordOlympique` float NOT NULL,
  `type` enum('qualification','1/4','1/2','finale') COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`codeEpreuve`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

Insert into `epreuve` (`codeEpreuve`,`nom`,`discipline`,`lieu`,`ville`,`dateEpreuve`,`recordMonde`,`recordOlympique`,`type`) VALUES
('ath100sprh','100m sprint hommes','athletisme','stade olympique','Londres','2012-08-05',9.58,9.63,'finale'),
('avi001skih','aviron un de couple homme','aviron','eton dorney','Londres','2012-08-03',393.35,402.52,'finale'),
('bas005equf','basketball equipe femmes','basketball','north greenwich arena','Londres','2012-08-11',0,0,'finale'),
('equ001ccet','concours complet equitation mixte','equitation','greenwich park','Londres','2012-07-31',0,0,'finale'),
('nat200libh','200m nage libre homme','natation','centre aquatique','Londres','2012-07-30',102,102.96,'finale');
-- --------------------------------------------------------

--
-- Structure de la table `resultat`
--

CREATE TABLE IF NOT EXISTS `resultat` (
  `codeEpreuve` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `codeAthleteOr` varchar(4) COLLATE utf8_unicode_ci NOT NULL,
  `codeAthleteArgent` varchar(4) COLLATE utf8_unicode_ci NOT NULL,
  `codeAthleteBronze` varchar(4) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`codeEpreuve`,`codeAthleteOr`,`codeAthleteArgent`,`codeAthleteBronze`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

Insert into `resultat`(`codeEpreuve`,`codeAthleteOR`,`codeAthleteArgent`,`codeAthleteBronze`) VALUES
('ath100h','bolu','blay','gatj'),
('avi001skih','drym','syno','cama'),
('bas005equf','parc','grus','jacl'),
('equ001ccet','junm','algs','aufs'),
('nat200libh','agny','part','suny');