1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62
| INSERT INTO CLUB VALUES (1,'Les Boxeurs Isère','10 rue des grands lacs','38000','Grenoble');
INSERT INTO CLUB VALUES (2,'Les boxeurs Ain' ,' 35 impasse des tilleule', '01000' ,'Bourg-En-Bresse');
INSERT INTO CLUB VALUES (3, 'Le savate club du 9ième', '17 allée espagne', '69009','Lyon');
INSERT INTO NIVEAU_TIREUR VALUES (1,'Débutant');
INSERT INTO NIVEAU_TIREUR VALUES (2,'Confirmé');
INSERT INTO NIVEAU_TIREUR VALUES (3,'Compétiteur');
INSERT INTO TIREUR VALUES (1,'CARTIER','Jean-Baptiste','1981-03-25',125847,'M',68,2,1);
INSERT INTO TIREUR VALUES (2,'ISSARTEL','Simon','2014-04-15',124587,'M',28,3,1);
INSERT INTO TIREUR VALUES (3,'CABRIER','Laurent','1978-09-12',548745,'M',72,1,1);
INSERT INTO TIREUR VALUES (4,'SEGUIN','Corentin','1985-05-05',548745,'M',75,2,1);
INSERT INTO TIREUR VALUES (5,'MARCEL','Jean','19616-02-05',125852,'M',88,3,2);
INSERT INTO TIREUR VALUES (6,'SARTEL','Cédric','2012-09-15',124588,'M',27,3,2);
INSERT INTO TIREUR VALUES (7,'MARTIN','Laure','1988-09-30',548746,'F',52,1,2);
INSERT INTO TIREUR VALUES (8,'CABRIRON','Marc','1965-10-15',548749,'M',77,2,2);
INSERT INTO TIREUR VALUES (9,'DIMEGLIO','Jacques','1971-03-01',145847,'M',78,2,3);
INSERT INTO TIREUR VALUES (10,'COHEN','Simon','2009-04-15',124687,'F',34,3,3);
INSERT INTO TIREUR VALUES (11,'DIMEGLIO','Marine','2013-09-12',549745,'F',22,1,3);
INSERT INTO TIREUR VALUES (12,'MARTEL','Joachim','1985-05-05',548845,'M',95,2,3);
INSERT INTO TIREUR VALUES (13,'SINGIER','Fanny','2008-06-25',123847,'F',38,1,1);
INSERT INTO TIREUR VALUES (14,'SAEBA','Ryo','1982-04-15',129587,'M',57,3,1);
INSERT INTO TIREUR VALUES (15,'SINGIER','Juline','2008-03-25',544545,'F',32,1,1);
INSERT INTO TIREUR VALUES (16,'POTTER','Harry','1985-05-05',576745,'F',78,2,1);
INSERT INTO COMPETITION VALUES (1,'2018-02-01','2018-02-02',1);
INSERT INTO COMPETITION VALUES (2,'2018-06-02-','2018-02-07',1);
INSERT INTO COMPETITION VALUES (3,'2018-02-15','2018-02-16',2);
INSERT INTO COMPETITION VALUES (4,'2018-02-01','2018-03-02',2);
INSERT INTO COMPETITION VALUES (5,'2018-03-22','2018-03-23',2);
INSERT INTO COMPETITION VALUES (6,'2018-03-30','2018-03-31',3);
INSERT INTO COMPETITION VALUES (7,'2018-04-02','2018-04-03',3);
INSERT INTO COMPETITION VALUES (8,'2018-04-10','2018-04-12',3);
INSERT INTO COMPETITION VALUES (9,'2018-05-06','2018-05-07',3);
INSERT INTO COMPETITION VALUES (10,'2018-06-01','2018-06-02',1);
INSERT INTO COMPETITION VALUES (11,'2018-03-13','2018-03-14',1);
INSERT INTO RENCONTRE VALUES (1,'2018-02-01 10:00:00','2018-02-01 10:20:00',1);
INSERT INTO RENCONTRE VALUES (2,'2018-02-01 10:40:00','2018-02-01 11:00:00',1);
INSERT INTO RENCONTRE VALUES (3,'2018-02-01 10:00:00','2018-02-01 10:18:00',1);
INSERT INTO RENCONTRE VALUES (4,'2018-02-01 10:30:00','2018-02-01 10:40:00',1);
INSERT INTO RENCONTRE VALUES (5,'2018-02-01 15:00:00','2018-02-01 15:20:00',1);
INSERT INTO RENCONTRE VALUES (6,'2018-02-02 15:00:00','2018-02-02 15:15:00',1);
INSERT INTO RENCONTRE VALUES (7,'2018-02-02 18:00:00','2018-02-02 18:20:00',1);
INSERT INTO PARTICIPER VALUES (1,1,'BLEU',7);
INSERT INTO PARTICIPER VALUES (7,1,'ROUGE',7);
INSERT INTO PARTICIPER VALUES (3,2,'BLEU',3);
INSERT INTO PARTICIPER VALUES (4,2,'ROUGE',3);
INSERT INTO PARTICIPER VALUES (14,3,'BLEU',14);
INSERT INTO PARTICIPER VALUES (16,3,'ROUGE',14);
INSERT INTO PARTICIPER VALUES (9,4,'BLEU',9);
INSERT INTO PARTICIPER VALUES (12,4,'ROUGE',9);
INSERT INTO PARTICIPER VALUES (7,5,'BLEU',7);
INSERT INTO PARTICIPER VALUES (3,5,'ROUGE',7);
INSERT INTO PARTICIPER VALUES (14,6,'BLEU',9);
INSERT INTO PARTICIPER VALUES (9,6,'ROUGE',9);
INSERT INTO PARTICIPER VALUES (7,7,'BLEU',9);
INSERT INTO PARTICIPER VALUES (9,7,'ROUGE',9); |
Partager