Guest User

Untitled

a guest
Dec 12th, 2019
103
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.  
  2. DROP SCHEMA IF EXISTS Labo2;
  3. CREATE SCHEMA Labo2 DEFAULT CHARSET = utf8mb4;
  4. USE Labo2;
  5.  
  6.  
  7.  
  8.  
  9. CREATE TABLE Discipline (
  10.     code CHAR(3),
  11.     nom VARCHAR(20),
  12.     CONSTRAINT PK_Discipline PRIMARY KEY (code)
  13. ) ENGINE = InnoDB;
  14.  
  15.  
  16. CREATE 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.  
  24. CREATE 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.  
  38. CREATE 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.  
  53. CREATE 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.  
  65. CREATE 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.  
  82. CREATE 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.  
  104. CREATE 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.  
  121. CREATE 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.  
  143. INSERT INTO Discipline (code, nom) VALUES ('GFA', 'Gymnastics For All');
  144. INSERT INTO Discipline (code, nom) VALUES ('RGI', 'Rhythmic Individual');
  145. INSERT INTO Discipline (code, nom) VALUES ('AER', 'Aerobic Gymnastics');
  146. INSERT INTO Discipline (code, nom) VALUES ('TRA', 'Trampoline');
  147.  
  148.  
  149. INSERT INTO Pays (nom) VALUES ('Switzerland');
  150. INSERT INTO Pays (nom) VALUES ('Great Britain');
  151. INSERT INTO Pays (nom) VALUES ('Spain');
  152. INSERT INTO Pays (nom) VALUES ('Canada');
  153. INSERT INTO Pays (nom) VALUES ('Burkina Faso');
  154.  
  155.  
  156. INSERT INTO Federation (nom, idPays) VALUES ('FEDERATION SUISSE DE GYMNASTIQUE', (SELECT id FROM Pays WHERE nom = 'Switzerland'));
  157. INSERT INTO Federation (nom, idPays) VALUES ('BRITISH GYMNASTICS', (SELECT id FROM Pays WHERE nom = 'Great Britain'));
  158. INSERT INTO Federation (nom, idPays) VALUES ('REAL FEDERACION ESPANOLA DE GIMNASIA', (SELECT id FROM Pays WHERE nom = 'Spain'));
  159. INSERT INTO Federation (nom, idPays) VALUES ('CANADIAN GYMNASTICS FEDERATION', (SELECT id FROM Pays WHERE nom = 'Canada'));
  160.  
  161.  
  162.  
  163. INSERT 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'));
  164. INSERT INTO Evenement_Discipline (idEvenement, codeDiscipline) VALUES ((SELECT MAX(id) FROM Evenement), 'RGI');
  165.  
  166. INSERT 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'));
  167. INSERT INTO Evenement_Discipline (idEvenement, codeDiscipline) VALUES ((SELECT MAX(id) FROM Evenement), 'GFA');
  168. INSERT INTO Evenement_Discipline (idEvenement, codeDiscipline) VALUES ((SELECT MAX(id) FROM Evenement), 'TRA');
  169.  
  170. INSERT 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'));
  171. INSERT INTO Evenement_Discipline (idEvenement, codeDiscipline) VALUES ((SELECT MAX(id) FROM Evenement), 'RGI');
  172.  
  173. INSERT 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'));
  174. INSERT INTO Evenement_Discipline (idEvenement, codeDiscipline) VALUES ((SELECT MAX(id) FROM Evenement), 'AER');
  175.  
  176. INSERT 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'));
  177. INSERT INTO Evenement_Discipline (idEvenement, codeDiscipline) VALUES ((SELECT MAX(id) FROM Evenement), 'TRA');
  178. INSERT INTO Evenement_Discipline (idEvenement, codeDiscipline) VALUES ((SELECT MAX(id) FROM Evenement), 'GFA');
  179. INSERT INTO Evenement_Discipline (idEvenement, codeDiscipline) VALUES ((SELECT MAX(id) FROM Evenement), 'RGI');
  180. INSERT INTO Evenement_Discipline (idEvenement, codeDiscipline) VALUES ((SELECT MAX(id) FROM Evenement), 'AER');
  181.  
  182. INSERT 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.  
  184. INSERT 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.  
  186. INSERT 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'));
  187. INSERT INTO Evenement_Discipline (idEvenement, codeDiscipline) VALUES ((SELECT MAX(id) FROM Evenement), 'RGI');
  188.  
  189. INSERT 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'));
  190. INSERT INTO Evenement_Discipline (idEvenement, codeDiscipline) VALUES ((SELECT MAX(id) FROM Evenement), 'TRA');
  191. INSERT INTO Evenement_Discipline (idEvenement, codeDiscipline) VALUES ((SELECT MAX(id) FROM Evenement), 'RGI');
  192.  
  193.  
  194.  
  195. INSERT INTO Gymnaste(nom, prenom, dateNaissance, idFederation) VALUES ('Plaisance', 'Isabella', '2000-11-08', (SELECT id FROM Federation WHERE nom = 'REAL FEDERACION ESPANOLA DE GIMNASIA'));
  196. INSERT INTO MembreHOF(idGymnaste, depuis) VALUES ((SELECT MAX(id) FROM Gymnaste), '2015-10-10');
  197. INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'RGI');
  198. INSERT INTO Gymnaste(nom, prenom, dateNaissance, idFederation) VALUES ('Aguas', 'Shaunta', '2001-11-08', (SELECT id FROM Federation WHERE nom = 'REAL FEDERACION ESPANOLA DE GIMNASIA'));
  199. INSERT INTO MembreHOF(idGymnaste, depuis) VALUES ((SELECT MAX(id) FROM Gymnaste), '2018-03-10');
  200. INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'RGI');
  201. INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'AER');
  202. INSERT INTO Gymnaste(nom, prenom, dateNaissance, idFederation) VALUES ('Lubinsky', 'Al', '2002-11-08', (SELECT id FROM Federation WHERE nom = 'CANADIAN GYMNASTICS FEDERATION'));
  203. INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'GFA');
  204. INSERT INTO Gymnaste(nom, prenom, dateNaissance, idFederation) VALUES ('Pierpont', 'Hsiu', '2003-11-08', (SELECT id FROM Federation WHERE nom = 'CANADIAN GYMNASTICS FEDERATION'));
  205. INSERT INTO MembreHOF(idGymnaste, depuis) VALUES ((SELECT MAX(id) FROM Gymnaste), '2018-04-10');
  206. INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'GFA');
  207. INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'TRA');
  208. INSERT INTO Gymnaste(nom, prenom, dateNaissance, idFederation) VALUES ('Deeann', 'Hibbert', '2000-11-07', (SELECT id FROM Federation WHERE nom = 'CANADIAN GYMNASTICS FEDERATION'));
  209. INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'RGI');
  210. INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'TRA');
  211. INSERT INTO Gymnaste(nom, prenom, dateNaissance, idFederation) VALUES ('Defazio', 'Annice', '2000-12-08', (SELECT id FROM Federation WHERE nom = 'FEDERATION SUISSE DE GYMNASTIQUE'));
  212. INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'AER');
  213. INSERT INTO Gymnaste(nom, prenom, dateNaissance, idFederation) VALUES ('Burgdorf', 'Providencia', '2000-11-08', (SELECT id FROM Federation WHERE nom = 'FEDERATION SUISSE DE GYMNASTIQUE'));
  214. INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'TRA');
  215. INSERT INTO Gymnaste(nom, prenom, dateNaissance, idFederation) VALUES ('Weinberger', 'Ozie', '2000-06-08', (SELECT id FROM Federation WHERE nom = 'FEDERATION SUISSE DE GYMNASTIQUE'));
  216. INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'GFA');
  217. INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'RGI');
  218. INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'AER');
  219. INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'TRA');
  220. INSERT INTO Gymnaste(nom, prenom, dateNaissance, idFederation) VALUES ('Nygaard', 'Preston', '1998-10-08', (SELECT id FROM Federation WHERE nom = 'BRITISH GYMNASTICS'));
  221. INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'AER');
  222. INSERT INTO Gymnaste(nom, prenom, dateNaissance, idFederation) VALUES ('Harvell', 'Harold', '1999-11-08', (SELECT id FROM Federation WHERE nom = 'BRITISH GYMNASTICS'));
  223. INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'GFA');
  224. INSERT INTO Gymnaste(nom, prenom, dateNaissance, idFederation) VALUES ('Hutson', 'Dwight', '1977-03-04', (SELECT id FROM Federation WHERE nom = 'BRITISH GYMNASTICS'));
  225. INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'AER');
  226. INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'RGI');
  227. INSERT INTO Gymnaste(nom, prenom, dateNaissance, idFederation) VALUES ('Lovelace', 'Gena', '2002-11-14', (SELECT id FROM Federation WHERE nom = 'BRITISH GYMNASTICS'));
  228. INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'AER');
  229. INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'RGI');
  230. INSERT INTO Gymnaste(nom, prenom, dateNaissance, idFederation) VALUES ('Halls', 'Krysta', '1993-03-03', (SELECT id FROM Federation WHERE nom = 'BRITISH GYMNASTICS'));
  231. INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'AER');
  232. INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'RGI');
  233. INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'TRA');
  234. INSERT INTO Gymnaste(nom, prenom, dateNaissance, idFederation) VALUES ('Hinrichs', 'Shiela', '2001-05-30', (SELECT id FROM Federation WHERE nom = 'BRITISH GYMNASTICS'));
  235. INSERT INTO MembreHOF(idGymnaste, depuis) VALUES ((SELECT MAX(id) FROM Gymnaste), '2010-08-18');
  236. INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'GFA');
  237. INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'RGI');
  238. INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'TRA');
  239. INSERT INTO Gymnaste(nom, prenom, dateNaissance, idFederation) VALUES ('Bender', 'Leeann', '1994-12-28', (SELECT id FROM Federation WHERE nom = 'BRITISH GYMNASTICS'));
  240. INSERT INTO MembreHOF(idGymnaste, depuis) VALUES ((SELECT MAX(id) FROM Gymnaste), '2012-09-01');
  241. INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'AER');
  242. INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'RGI');
  243. INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'TRA');
  244. INSERT INTO Gymnaste_Discipline (idGymnaste, codeDiscipline) VALUES ((SELECT MAX(id) FROM Gymnaste), 'GFA');
  245.  
  246.  
  247. INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (1, 1, '2019-10-24');
  248.  
  249. INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (3, 2, '2017-10-24');
  250. INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (13, 2, '2018-01-24');
  251. INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (15, 2, '2018-03-22');
  252.  
  253. INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (2, 4, '2018-12-24');
  254.  
  255. INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (2, 5, '2018-05-11');
  256. INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (3, 5, '2018-05-12');
  257. INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (4, 5, '2018-05-13');
  258. INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (5, 5, '2018-05-14');
  259. INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (6, 5, '2018-05-15');
  260. INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (7, 5, '2018-05-16');
  261. INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (8, 5, '2018-05-17');
  262. INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (9, 5, '2018-05-18');
  263. INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (10, 5, '2018-05-19');
  264. INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (11, 5, '2018-05-20');
  265. INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (13, 5, '2018-05-22');
  266. INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (14, 5, '2018-05-23');
  267. INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (15, 5, '2018-05-24');
  268.  
  269. INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (15, 7, '2017-03-10');
  270.  
  271. INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (1, 8, '2019-10-21');
  272. INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (5, 8, '2019-10-24');
  273. INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (8, 8, '2019-11-01');
  274. INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (14, 8, '2019-11-11');
  275.  
  276. INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (7, 9, '2018-03-14');
  277. INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (8, 9, '2018-03-12');
  278. INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (1, 9, '2017-10-24');
  279. INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (2, 9, '2017-12-01');
  280. INSERT INTO Inscription (idGymnaste, idEvenement, date) VALUES (4, 9, '2017-05-22');
RAW Paste Data