INSERT INTO Club VALUES ('1', 'Manin', '56 rue Jean Jaures' , 'Paris', '1978');
INSERT INTO Club VALUES ('2', 'BC Sports', '82 rue du jour' , 'Bois colombes', '1987');
INSERT INTO Club VALUES ('3', 'Paris 5', '24 rue du parc' , 'Paris', '1996');
INSERT INTO Club VALUES ('4', 'Evry', '12 rue du port' , 'Evry', '1979');

INSERT INTO Equipe VALUES ('1', '2', 'EISTI', 'cerceau', 'federale');
INSERT INTO Equipe VALUES ('2', '4', 'EBI', 'ruban', 'criterium');
INSERT INTO Equipe VALUES ('3', '3', 'EPMI', 'corde', 'nationale');
INSERT INTO Equipe VALUES ('4', '1', 'ESCOM', 'ballon', 'prefederale');

INSERT INTO Competition VALUES ('1', '18 rue Charles de gaulle', 'Paris', to_date('2008/04/23', 'yyyy/mm/dd'), 'département');
INSERT INTO Competition VALUES ('2', '21 allée du bois', 'Cergy', to_date('2008/06/12', 'yyyy/mm/dd'), 'region');
INSERT INTO Competition VALUES ('3', '45 rue du marché', 'Asnieres', to_date('2008/07/30', 'yyyy/mm/dd'), 'france');
INSERT INTO Competition VALUES ('4', '22 avenue barillet', 'Levallois', to_date('2008/02/16', 'yyyy/mm/dd'), 'zone');
INSERT INTO Competition VALUES ('5', '45 rue jules vernes', 'Clichy', to_date('2008/04/07', 'yyyy/mm/dd'), 'zone');
INSERT INTO Competition VALUES ('6', '23 rue Kennedy', 'Nanterre', to_date('2008/05/09', 'yyyy/mm/dd'), 'region');

INSERT INTO Gymnaste VALUES ('1456789', '1', 'Le Loc', 'Martin', '1988');
INSERT INTO Gymnaste VALUES ('1987665', '2', 'Frey', 'Jacky', '1987');
INSERT INTO Gymnaste VALUES ('3497651', '3', 'Dupont', 'Emilie', '1987');
INSERT INTO Gymnaste VALUES ('1769485', '4', 'Fontaine', 'Jeanne', '1986'');
INSERT INTO Gymnaste VALUES ('1254275', '3', 'Chibron', 'Martin', '1986');
INSERT INTO Gymnaste VALUES ('6547889', '2', 'Fontaine', 'JeJe', '1986');
INSERT INTO Gymnaste VALUES ('8762552', '1', 'Nbooba', 'Michel', '1988');
INSERT INTO Gymnaste VALUES ('9876254', '4', 'Urbain', 'Aurélie', '1986');


INSERT INTO Club_has_competition VALUES ('1', '2');
INSERT INTO Club_has_competition VALUES ('1', '3');
INSERT INTO Club_has_competition VALUES ('1', '4');
INSERT INTO Club_has_competition VALUES ('1', '6');
INSERT INTO Club_has_competition VALUES ('2', '5');
INSERT INTO Club_has_competition VALUES ('2', '1');
INSERT INTO Club_has_competition VALUES ('3', '2');
INSERT INTO Club_has_competition VALUES ('4', '6');
INSERT INTO Club_has_competition VALUES ('2', '3');