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
| INSERT INTO COMPETITION (CompeteId, CompeteDate, CompeteLieu) VALUES (1, '2011-08-09', 'Papeete') ;
INSERT INTO COMPETITION (CompeteId, CompeteDate, CompeteLieu) VALUES (2, '2012-07-14', 'Lille') ;
INSERT INTO COMPETITION (CompeteId, CompeteDate, CompeteLieu) VALUES (3, '2013-09-12', 'Brest') ;
SELECT '' AS COMPETITION, * FROM COMPETITION ;
INSERT INTO EQUIPE (EquipeId, EquipeNom) VALUES (1, 'Graveson') ;
INSERT INTO EQUIPE (EquipeId, EquipeNom) VALUES (2, 'Plougastel') ;
INSERT INTO EQUIPE (EquipeId, EquipeNom) VALUES (3, 'Colmar') ;
INSERT INTO EQUIPE (EquipeId, EquipeNom) VALUES (4, 'Rennes') ;
INSERT INTO EQUIPE (EquipeId, EquipeNom) VALUES (5, 'Toulouse') ;
SELECT '' AS EQUIPE, * FROM EQUIPE ;
INSERT INTO QUALIFICATION (CompeteId, EquipeId, ScoreQualif) VALUES (1, 1, 50) ;
INSERT INTO QUALIFICATION (CompeteId, EquipeId, ScoreQualif) VALUES (1, 2, 60) ;
INSERT INTO QUALIFICATION (CompeteId, EquipeId, ScoreQualif) VALUES (1, 3, 50) ;
INSERT INTO QUALIFICATION (CompeteId, EquipeId, ScoreQualif) VALUES (1, 4, 70) ;
INSERT INTO QUALIFICATION (CompeteId, EquipeId, ScoreQualif) VALUES (1, 5, 30) ;
INSERT INTO QUALIFICATION (CompeteId, EquipeId, ScoreQualif) VALUES (2, 1, 80) ;
INSERT INTO QUALIFICATION (CompeteId, EquipeId, ScoreQualif) VALUES (2, 2, 80) ;
INSERT INTO QUALIFICATION (CompeteId, EquipeId, ScoreQualif) VALUES (2, 3, 60) ;
INSERT INTO QUALIFICATION (CompeteId, EquipeId, ScoreQualif) VALUES (2, 4, 50) ;
INSERT INTO QUALIFICATION (CompeteId, EquipeId, ScoreQualif) VALUES (2, 5, 40) ;
INSERT INTO QUALIFICATION (CompeteId, EquipeId, ScoreQualif) VALUES (3, 1, 60) ;
INSERT INTO QUALIFICATION (CompeteId, EquipeId, ScoreQualif) VALUES (3, 2, 50) ;
INSERT INTO QUALIFICATION (CompeteId, EquipeId, ScoreQualif) VALUES (3, 3, 60) ;
INSERT INTO QUALIFICATION (CompeteId, EquipeId, ScoreQualif) VALUES (3, 5, 70) ;
SELECT '' AS QUALIFICATION, * FROM QUALIFICATION ;
INSERT INTO MATCH (CompeteId, EquipeVainqueurId, EquipeVaincue, ScoreVainqueur, ScoreVaincu) VALUES (1, 2, 1, 80, 50) ;
INSERT INTO MATCH (CompeteId, EquipeVainqueurId, EquipeVaincue, ScoreVainqueur, ScoreVaincu) VALUES (1, 2, 3, 70, 60) ;
INSERT INTO MATCH (CompeteId, EquipeVainqueurId, EquipeVaincue, ScoreVainqueur, ScoreVaincu) VALUES (1, 3, 1, 60, 50) ;
INSERT INTO MATCH (CompeteId, EquipeVainqueurId, EquipeVaincue, ScoreVainqueur, ScoreVaincu) VALUES (2, 2, 1, 70, 60) ;
INSERT INTO MATCH (CompeteId, EquipeVainqueurId, EquipeVaincue, ScoreVainqueur, ScoreVaincu) VALUES (2, 2, 3, 60, 50) ;
INSERT INTO MATCH (CompeteId, EquipeVainqueurId, EquipeVaincue, ScoreVainqueur, ScoreVaincu) VALUES (2, 3, 2, 50, 40) ; -- viol contraint !!!
SELECT '' AS MATCH, * FROM MATCH ; |
Partager