kMnTSyuq

1
2DROP SCHEMA IF EXISTS Labo2;
3CREATE SCHEMA Labo2 DEFAULT CHARSET = utf8mb4;
4USE Labo2;
5
6
7
8
9CREATE TABLE Discipline (
10	code CHAR(3),
11	nom VARCHAR(20),
12	CONSTRAINT PK_Discipline PRIMARY KEY (code)
13) ENGINE = InnoDB;
14
15
16CREATE TABLE Pays (
17	id INTEGER UNSIGNED AUTO_INCREMENT,
18	nom VARCHAR(20) NOT NULL,
19	CONSTRAINT PK_Pays PRIMARY KEY (id),
20	CONSTRAINT UC_Pays_nom UNIQUE (nom)
21) ENGINE = InnoDB;
22
23
24CREATE TABLE Federation (
25	id INTEGER UNSIGNED AUTO_INCREMENT,
26	idPays INTEGER UNSIGNED NOT NULL,
27	nom VARCHAR(50) NOT NULL,
28	CONSTRAINT PK_Federation PRIMARY KEY (id),
29	CONSTRAINT UC_Federation_nom UNIQUE (nom),
30	CONSTRAINT FK_Federation_idPays
31		FOREIGN KEY (idPays)
32		REFERENCES Pays (id)
33		ON DELETE RESTRICT
34		ON UPDATE RESTRICT
35) ENGINE = InnoDB;
36
37
38CREATE TABLE Gymnaste (
39	id INTEGER UNSIGNED AUTO_INCREMENT,
40	idFederation INTEGER UNSIGNED NOT NULL,
41	nom VARCHAR(50) NOT NULL,
42	prenom VARCHAR(50) NOT NULL,
43	dateNaissance TIMESTAMP NOT NULL,
44	CONSTRAINT PK_Gymnaste PRIMARY KEY (id),
45	CONSTRAINT FK_Gymnaste_idFederation
46		FOREIGN KEY (idFederation)
47		REFERENCES Federation (id)
48		ON DELETE RESTRICT
49		ON UPDATE RESTRICT
50) ENGINE = InnoDB;
51
52
53CREATE TABLE MembreHOF (
54	idGymnaste INTEGER UNSIGNED NOT NULL,
55	depuis TIMESTAMP NOT NULL,
56	CONSTRAINT PK_MembreHOF PRIMARY KEY (idGymnaste),
57	CONSTRAINT FK_MembreHOF_idGymnaste
58		FOREIGN KEY (idGymnaste)
59		REFERENCES Gymnaste (id)
60		ON DELETE CASCADE
61		ON UPDATE CASCADE
62) ENGINE = InnoDB;
63
64
65CREATE TABLE Gymnaste_Discipline (
66	idGymnaste INTEGER UNSIGNED,
67	codeDiscipline CHAR(3),
68	CONSTRAINT PK_Gymnaste_Discipline PRIMARY KEY (idGymnaste, codeDiscipline),
69	CONSTRAINT FK_Gymnaste_Discipline_idGymnaste
70		FOREIGN KEY (idGymnaste)
71		REFERENCES Gymnaste (id)
72		ON DELETE RESTRICT
73		ON UPDATE RESTRICT,
74	CONSTRAINT FK_Gymnaste_Discipline_codeDiscipline
75		FOREIGN KEY (codeDiscipline)
76		REFERENCES Discipline (code)
77		ON DELETE RESTRICT
78		ON UPDATE RESTRICT
79) ENGINE = InnoDB;
80
81
82CREATE TABLE Evenement (
83	id INTEGER UNSIGNED AUTO_INCREMENT,
84	idPays INTEGER UNSIGNED NOT NULL,
85	idFederation INTEGER UNSIGNED NOT NULL,
86	nom VARCHAR(50) NOT NULL,
87	dateOuverture TIMESTAMP NOT NULL,
88	fraisInscription INTEGER NOT NULL,
89	CONSTRAINT PK_Evenement PRIMARY KEY (id),
90	CONSTRAINT UC_Evenement_nom UNIQUE (nom),
91	CONSTRAINT FK_Evenement_idPays
92		FOREIGN KEY (idPays)
93		REFERENCES Pays (id)
94		ON DELETE RESTRICT
95		ON UPDATE RESTRICT,
96	CONSTRAINT FK_Evenement_idFederation
97		FOREIGN KEY (idFederation)
98		REFERENCES Federation (id)
99		ON DELETE RESTRICT
100		ON UPDATE RESTRICT
101) ENGINE = InnoDB;
102
103
104CREATE TABLE Evenement_Discipline (
105	idEvenement INTEGER UNSIGNED,
106	codeDiscipline CHAR(3),
107	CONSTRAINT PK_Evenement_Discipline PRIMARY KEY (idEvenement, codeDiscipline),
108	CONSTRAINT FK_Evenement_Discipline_idEvenement
109		FOREIGN KEY (idEvenement)
110		REFERENCES Evenement (id)
111		ON DELETE RESTRICT
112		ON UPDATE RESTRICT,
113	CONSTRAINT FK_Evenement_Discipline_codeDiscipline
114		FOREIGN KEY (codeDiscipline)
115		REFERENCES Discipline (code)
116		ON DELETE RESTRICT
117		ON UPDATE RESTRICT
118) ENGINE = InnoDB;
119
120
121CREATE TABLE Inscription (
122	idGymnaste INTEGER UNSIGNED,
123	idEvenement INTEGER UNSIGNED,
124	date TIMESTAMP NOT NULL,
125	CONSTRAINT PK_Evenement PRIMARY KEY (idGymnaste, idEvenement),
126	CONSTRAINT FK_Inscription_idGymnaste
127		FOREIGN KEY (idGymnaste)
128		REFERENCES Gymnaste (id)
129		ON DELETE RESTRICT
130		ON UPDATE RESTRICT,
131	CONSTRAINT FK_Inscription_idEvenement
132		FOREIGN KEY (idEvenement)
133		REFERENCES Evenement (id)
134		ON DELETE RESTRICT
135		ON UPDATE RESTRICT
136) ENGINE = InnoDB;
137
138
139
140
141
142
143INSERT INTO Discipline (code, nom) VALUES ('GFA', 'Gymnastics For All');
144INSERT INTO Discipline (code, nom) VALUES ('RGI', 'Rhythmic Individual');
145INSERT INTO Discipline (code, nom) VALUES ('AER', 'Aerobic Gymnastics');
146INSERT INTO Discipline (code, nom) VALUES ('TRA', 'Trampoline');
147
148
149INSERT INTO Pays (nom) VALUES ('Switzerland');
150INSERT INTO Pays (nom) VALUES ('Great Britain');
151INSERT INTO Pays (nom) VALUES ('Spain');
152INSERT INTO Pays (nom) VALUES ('Canada');
153INSERT INTO Pays (nom) VALUES ('Burkina Faso');
154
155
156INSERT INTO Federation (nom, idPays) VALUES ('FEDERATION SUISSE DE GYMNASTIQUE', (SELECT id FROM Pays WHERE nom = 'Switzerland'));
157INSERT INTO Federation (nom, idPays) VALUES ('BRITISH GYMNASTICS', (SELECT id FROM Pays WHERE nom = 'Great Britain'));
158INSERT INTO Federation (nom, idPays) VALUES ('REAL FEDERACION ESPANOLA DE GIMNASIA', (SELECT id FROM Pays WHERE nom = 'Spain'));
159INSERT INTO Federation (nom, idPays) VALUES ('CANADIAN GYMNASTICS FEDERATION', (SELECT id FROM Pays WHERE nom = 'Canada'));
160
161
162
163INSERT INTO Evenement (nom, dateOuverture, fraisInscription, idPays, idFederation) VALUES ('VII Copa Interacional Catalunya', '2020-11-23', 50, (SELECT id FROM Pays WHERE nom = 'Spain'), (SELECT id FROM Federation WHERE nom = 'REAL FEDERACION ESPANOLA DE GIMNASIA'));
164INSERT INTO Evenement_Discipline (idEvenement, codeDiscipline) VALUES ((SELECT MAX(id) FROM Evenement), 'RGI');
165
166INSERT INTO Evenement (nom, dateOuverture, fraisInscription, idPays, idFederation) VALUES ('FIG World Cup 2019 - GFA - TRA', '2019-09-14', 20, (SELECT id FROM Pays WHERE nom = 'Switzerland'), (SELECT id FROM Federation WHERE nom = 'FEDERATION SUISSE DE GYMNASTIQUE'));
167INSERT INTO Evenement_Discipline (idEvenement, codeDiscipline) VALUES ((SELECT MAX(id) FROM Evenement), 'GFA');
168INSERT INTO Evenement_Discipline (idEvenement, codeDiscipline) VALUES ((SELECT MAX(id) FROM Evenement), 'TRA');
169
170INSERT INTO Evenement (nom, dateOuverture, fraisInscription, idPays, idFederation) VALUES ('FIG World Cup 2019 - RGI', '2019-09-14', 10, (SELECT id FROM Pays WHERE nom = 'Great Britain'), (SELECT id FROM Federation WHERE nom = 'BRITISH GYMNASTICS'));
171INSERT INTO Evenement_Discipline (idEvenement, codeDiscipline) VALUES ((SELECT MAX(id) FROM Evenement), 'RGI');
172
173INSERT INTO Evenement (nom, dateOuverture, fraisInscription, idPays, idFederation) VALUES ('FIG World Cup 2019 - AER', '2019-09-14', 8, (SELECT id FROM Pays WHERE nom = 'Spain'), (SELECT id FROM Federation WHERE nom = 'REAL FEDERACION ESPANOLA DE GIMNASIA'));
174INSERT INTO Evenement_Discipline (idEvenement, codeDiscipline) VALUES ((SELECT MAX(id) FROM Evenement), 'AER');
175
176INSERT INTO Evenement (nom, dateOuverture, fraisInscription, idPays, idFederation) VALUES ('FIG World Cup 2018', '2018-07-14', 40, (SELECT id FROM Pays WHERE nom = 'Switzerland'), (SELECT id FROM Federation WHERE nom = 'FEDERATION SUISSE DE GYMNASTIQUE'));
177INSERT INTO Evenement_Discipline (idEvenement, codeDiscipline) VALUES ((SELECT MAX(id) FROM Evenement), 'TRA');
178INSERT INTO Evenement_Discipline (idEvenement, codeDiscipline) VALUES ((SELECT MAX(id) FROM Evenement), 'GFA');
179INSERT INTO Evenement_Discipline (idEvenement, codeDiscipline) VALUES ((SELECT MAX(id) FROM Evenement), 'RGI');
180INSERT INTO Evenement_Discipline (idEvenement, codeDiscipline) VALUES ((SELECT MAX(id) FROM Evenement), 'AER');
181
182INSERT INTO Evenement (nom, dateOuverture, fraisInscription, idPays, idFederation) VALUES ('Match Junior SUI-FRA-GER 2018', '2018-03-09', 500, (SELECT id FROM Pays WHERE nom = 'Switzerland'), (SELECT id FROM Federation WHERE nom = 'FEDERATION SUISSE DE GYMNASTIQUE'));
183
184INSERT INTO Evenement (nom, dateOuverture, fraisInscription, idPays, idFederation) VALUES ('FIG World Cup 2017', '2017-03-09', 500, (SELECT id FROM Pays WHERE nom = 'Great Britain'), (SELECT id FROM Federation WHERE nom = 'FEDERATION SUISSE DE GYMNASTIQUE'));
185
186INSERT INTO Evenement (nom, dateOuverture, fraisInscription, idPays, idFederation) VALUES ('VIII Copa Interacional Catalunya', '2025-11-23', 50, (SELECT id FROM Pays WHERE nom = 'Spain'), (SELECT id FROM Federation WHERE nom = 'REAL FEDERACION ESPANOLA DE GIMNASIA'));
187INSERT INTO Evenement_Discipline (idEvenement, codeDiscipline) VALUES ((SELECT MAX(id) FROM Evenement), 'RGI');
188
189INSERT INTO Evenement (nom, dateOuverture, fraisInscription, idPays, idFederation) VALUES ('TRA RGI World Cup 2018', '2018-03-12', 80, (SELECT id FROM Pays WHERE nom = 'Switzerland'), (SELECT id FROM Federation WHERE nom = 'FEDERATION SUISSE DE GYMNASTIQUE'));
190INSERT INTO Evenement_Discipline (idEvenement, codeDiscipline) VALUES ((SELECT MAX(id) FROM Evenement), 'TRA');
191INSERT INTO Evenement_Discipline (idEvenement, codeDiscipline) VALUES ((SELECT MAX(id) FROM Evenement), 'RGI');
192
193
194
195INSERT INTO Gymnaste(nom, prenom, dateNaissance, idFederation) VALUES ('Plaisance', 'Isabella', '2000-11-08', (SELECT id FROM Federation WHERE nom = 'REAL FEDERACION ESPANOLA DE GIMNASIA'));
196INSERT INTO MembreHOF(idGymnaste, depuis) VALUES ((SELECT MAX(id) FROM Gymnaste), '2015-10-10');
197INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'RGI');
198INSERT INTO Gymnaste(nom, prenom, dateNaissance, idFederation) VALUES ('Aguas', 'Shaunta', '2001-11-08', (SELECT id FROM Federation WHERE nom = 'REAL FEDERACION ESPANOLA DE GIMNASIA'));
199INSERT INTO MembreHOF(idGymnaste, depuis) VALUES ((SELECT MAX(id) FROM Gymnaste), '2018-03-10');
200INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'RGI');
201INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'AER');
202INSERT INTO Gymnaste(nom, prenom, dateNaissance, idFederation) VALUES ('Lubinsky', 'Al', '2002-11-08', (SELECT id FROM Federation WHERE nom = 'CANADIAN GYMNASTICS FEDERATION'));
203INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'GFA');
204INSERT INTO Gymnaste(nom, prenom, dateNaissance, idFederation) VALUES ('Pierpont', 'Hsiu', '2003-11-08', (SELECT id FROM Federation WHERE nom = 'CANADIAN GYMNASTICS FEDERATION'));
205INSERT INTO MembreHOF(idGymnaste, depuis) VALUES ((SELECT MAX(id) FROM Gymnaste), '2018-04-10');
206INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'GFA');
207INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'TRA');
208INSERT INTO Gymnaste(nom, prenom, dateNaissance, idFederation) VALUES ('Deeann', 'Hibbert', '2000-11-07', (SELECT id FROM Federation WHERE nom = 'CANADIAN GYMNASTICS FEDERATION'));
209INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'RGI');
210INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'TRA');
211INSERT INTO Gymnaste(nom, prenom, dateNaissance, idFederation) VALUES ('Defazio', 'Annice', '2000-12-08', (SELECT id FROM Federation WHERE nom = 'FEDERATION SUISSE DE GYMNASTIQUE'));
212INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'AER');
213INSERT INTO Gymnaste(nom, prenom, dateNaissance, idFederation) VALUES ('Burgdorf', 'Providencia', '2000-11-08', (SELECT id FROM Federation WHERE nom = 'FEDERATION SUISSE DE GYMNASTIQUE'));
214INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'TRA');
215INSERT INTO Gymnaste(nom, prenom, dateNaissance, idFederation) VALUES ('Weinberger', 'Ozie', '2000-06-08', (SELECT id FROM Federation WHERE nom = 'FEDERATION SUISSE DE GYMNASTIQUE'));
216INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'GFA');
217INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'RGI');
218INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'AER');
219INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'TRA');
220INSERT INTO Gymnaste(nom, prenom, dateNaissance, idFederation) VALUES ('Nygaard', 'Preston', '1998-10-08', (SELECT id FROM Federation WHERE nom = 'BRITISH GYMNASTICS'));
221INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'AER');
222INSERT INTO Gymnaste(nom, prenom, dateNaissance, idFederation) VALUES ('Harvell', 'Harold', '1999-11-08', (SELECT id FROM Federation WHERE nom = 'BRITISH GYMNASTICS'));
223INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'GFA');
224INSERT INTO Gymnaste(nom, prenom, dateNaissance, idFederation) VALUES ('Hutson', 'Dwight', '1977-03-04', (SELECT id FROM Federation WHERE nom = 'BRITISH GYMNASTICS'));
225INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'AER');
226INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'RGI');
227INSERT INTO Gymnaste(nom, prenom, dateNaissance, idFederation) VALUES ('Lovelace', 'Gena', '2002-11-14', (SELECT id FROM Federation WHERE nom = 'BRITISH GYMNASTICS'));
228INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'AER');
229INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'RGI');
230INSERT INTO Gymnaste(nom, prenom, dateNaissance, idFederation) VALUES ('Halls', 'Krysta', '1993-03-03', (SELECT id FROM Federation WHERE nom = 'BRITISH GYMNASTICS'));
231INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'AER');
232INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'RGI');
233INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'TRA');
234INSERT INTO Gymnaste(nom, prenom, dateNaissance, idFederation) VALUES ('Hinrichs', 'Shiela', '2001-05-30', (SELECT id FROM Federation WHERE nom = 'BRITISH GYMNASTICS'));
235INSERT INTO MembreHOF(idGymnaste, depuis) VALUES ((SELECT MAX(id) FROM Gymnaste), '2010-08-18');
236INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'GFA');
237INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'RGI');
238INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'TRA');
239INSERT INTO Gymnaste(nom, prenom, dateNaissance, idFederation) VALUES ('Bender', 'Leeann', '1994-12-28', (SELECT id FROM Federation WHERE nom = 'BRITISH GYMNASTICS'));
240INSERT INTO MembreHOF(idGymnaste, depuis) VALUES ((SELECT MAX(id) FROM Gymnaste), '2012-09-01');
241INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'AER');
242INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'RGI');
243INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'TRA');
244INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'GFA');
245
246
247INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (1, 1, '2019-10-24');
248
249INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (3, 2, '2017-10-24');
250INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (13, 2, '2018-01-24');
251INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (15, 2, '2018-03-22');
252
253INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (2, 4, '2018-12-24');
254
255INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (2, 5, '2018-05-11');
256INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (3, 5, '2018-05-12');
257INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (4, 5, '2018-05-13');
258INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (5, 5, '2018-05-14');
259INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (6, 5, '2018-05-15');
260INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (7, 5, '2018-05-16');
261INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (8, 5, '2018-05-17');
262INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (9, 5, '2018-05-18');
263INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (10, 5, '2018-05-19');
264INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (11, 5, '2018-05-20');
265INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (13, 5, '2018-05-22');
266INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (14, 5, '2018-05-23');
267INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (15, 5, '2018-05-24');
268
269INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (15, 7, '2017-03-10');
270
271INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (1, 8, '2019-10-21');
272INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (5, 8, '2019-10-24');
273INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (8, 8, '2019-11-01');
274INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (14, 8, '2019-11-11');
275
276INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (7, 9, '2018-03-14');
277INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (8, 9, '2018-03-12');
278INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (1, 9, '2017-10-24');
279INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (2, 9, '2017-12-01');
280INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (4, 9, '2017-05-22');