INSERT INTO Club VALUES ('1', 'Back To School 2k7', '2007/10/04 22:00:00' , 'Grisy Apple', '8');
INSERT INTO Club VALUES ('2', 'Luna Rossa', '2007/11/04 22:00:00' , 'Grisy Apple', '12');
INSERT INTO Club VALUES ('3', 'Christmas', '2007/12/20 22:00:00' , 'Grisy Apple', '10');
INSERT INTO Club VALUES ('4', 'Parrainage', '2007/10/22 22:00:00' , 'Bikini', '4');

INSERT INTO Ecole VALUES ('1', 'EISTI', 'Avenue du Parc');
INSERT INTO Ecole VALUES ('2', 'EBI', 'Boulevard du Port');
INSERT INTO Ecole VALUES ('3', 'EPMI', 'Les Montallants');
INSERT INTO Ecole VALUES ('4', 'ESCOM', 'Les Montallants');

INSERT INTO Etudiant VALUES ('1', '1', 'Le Loc', 'Martin', 'M', '1988');
INSERT INTO Etudiant VALUES ('2', '2', 'Frey', 'Jacky', 'M', '1987');
INSERT INTO Etudiant VALUES ('3', '3', 'Dupont', 'Emilie', 'F', '1987');
INSERT INTO Etudiant VALUES ('4', '4', 'Nbooba', 'Michel', 'M', '1988');
INSERT INTO Etudiant VALUES ('5', '1', 'Fontaine', 'Jeanne', 'F', '1986');
INSERT INTO Etudiant VALUES ('6', '1', 'Fontaine', 'JeJe', 'M', '1986');
INSERT INTO Etudiant VALUES ('7', '1', 'Chibron', 'Martin', 'M', '1986');

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

INSERT INTO Sponsor VALUES ('1', 'Marc Dorcel', 'Marco');
INSERT INTO Sponsor VALUES ('2', 'Burn', 'Mr Coca');
INSERT INTO Sponsor VALUES ('3', 'Danone', 'Mr Yahourt');
INSERT INTO Sponsor VALUES ('4', 'LCL', 'Mr le banquier');
INSERT INTO Sponsor VALUES ('5', 'Media Campus', 'Mme Stud');

INSERT INTO Sponsor_par_soiree VALUES ('1', '2', '2500');
INSERT INTO Sponsor_par_soiree VALUES ('1', '3', '300');
INSERT INTO Sponsor_par_soiree VALUES ('1', '4', '1500');
INSERT INTO Sponsor_par_soiree VALUES ('1', '5', '300');
INSERT INTO Sponsor_par_soiree VALUES ('2', '5', '500');
INSERT INTO Sponsor_par_soiree VALUES ('2', '1', '120');
INSERT INTO Sponsor_par_soiree VALUES ('3', '2', '400');
INSERT INTO Sponsor_par_soiree VALUES ('4', '2', '23500');
INSERT INTO Sponsor_par_soiree VALUES ('2', '3', '200');