API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 12th, 2019
138
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 16.92 KB | None | 0 0
raw download clone embed print report
  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');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!