eXXbVevw

1--
2-- Structure de la table `athlete`
3--
4
5CREATE TABLE IF NOT EXISTS `athlete` (
6  `nom` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
7  `prenom` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
8  `nation` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
9  `dateNaissance` date NOT NULL,
10  `discipline` varchar(20) COLLATE utf8_unicode_ci NOT NULL
11) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
12
13Insert into `athlete` (`nom`,`prenom`,`nation`,`dateNaissance`,`discipline`) VALUES
14('AGNEL','Yannick','France','1992-06-09','natation'),
15('ALGOTSSON OSTHOLT','Sara','Suede','1974-08-12','equitation'),
16('AUFFARTH','Sandra','Allemagne','1986-12-27','equitation'),
17('BLAKE','Yohan','Jamaique','1989-12-26','athletisme'),
18('BOLT','Usain','Jamaique','1986-08-21','athletisme'),
19('CAMPBELL','Alan','Grande bretagne','1983-05-09','aviron'),
20('DRYSDALE','Mahe','Nouvelle zelande','1978-11-19','aviron'),
21('GATLIN','Justin','USA','1982-02-10','athletisme'),
22('GRUDA','Sandrine','France','1987-06-25','basketball'),
23('JACKSON','Lauren','Australie','1981-05-11',' basketball'),
24('JUNG','Michael','Allemagne','1982-07-31','equitation'),
25('PARK','Taehwan','Koree','1989-09-27','natation'),
26('PARKER','Candace','USA','1986-04-19','basketball'),
27('SUN','Yan','Chine','1991-12-01','natation'),
28('SYNEK','Ondrej','Republique tcheque','1982-10-13','aviron');
29-- --------------------------------------------------------
30
31--
32-- Structure de la table `epreuve`
33--
34
35CREATE TABLE IF NOT EXISTS `epreuve` (
36  `codeEpreuve` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
37  `nom` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
38  `discipline` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
39  `lieu` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
40  `ville` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
41  `dateEpreuve` date NOT NULL,
42  `recordMonde` float NOT NULL,
43  `recordOlympique` float NOT NULL,
44  `type` enum('qualification','1/4','1/2','finale') COLLATE utf8_unicode_ci NOT NULL,
45  PRIMARY KEY (`codeEpreuve`)
46) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
47
48Insert into `epreuve` (`codeEpreuve`,`nom`,`discipline`,`lieu`,`ville`,`dateEpreuve`,`recordMonde`,`recordOlympique`,`type`) VALUES
49('ath100sprh','100m sprint hommes','athletisme','stade olympique','Londres','2012-08-05',9.58,9.63,'finale'),
50('avi001skih','aviron un de couple homme','aviron','eton dorney','Londres','2012-08-03',393.35,402.52,'finale'),
51('bas005equf','basketball equipe femmes','basketball','north greenwich arena','Londres','2012-08-11',0,0,'finale'),
52('equ001ccet','concours complet equitation mixte','equitation','greenwich park','Londres','2012-07-31',0,0,'finale'),
53('nat200libh','200m nage libre homme','natation','centre aquatique','Londres','2012-07-30',102,102.96,'finale');
54-- --------------------------------------------------------
55
56--
57-- Structure de la table `resultat`
58--
59
60CREATE TABLE IF NOT EXISTS `resultat` (
61  `codeEpreuve` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
62  `codeAthleteOr` varchar(4) COLLATE utf8_unicode_ci NOT NULL,
63  `codeAthleteArgent` varchar(4) COLLATE utf8_unicode_ci NOT NULL,
64  `codeAthleteBronze` varchar(4) COLLATE utf8_unicode_ci NOT NULL,
65  PRIMARY KEY (`codeEpreuve`,`codeAthleteOr`,`codeAthleteArgent`,`codeAthleteBronze`)
66) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
67
68Insert into `resultat`(`codeEpreuve`,`codeAthleteOR`,`codeAthleteArgent`,`codeAthleteBronze`) VALUES
69('ath100h','bolu','blay','gatj'),
70('avi001skih','drym','syno','cama'),
71('bas005equf','parc','grus','jacl'),
72('equ001ccet','junm','algs','aufs'),
73('nat200libh','agny','part','suny');