insert into PARTICIPANT values ('Allemagne', 3, 3, 1, 0, 2);
insert into PARTICIPANT values ('Australie',1, 1, 0, 1, 0);
insert into PARTICIPANT values ('Canada',1, 1, 1, 0, 0);
insert into PARTICIPANT values ('France', 4, 5, 3, 0, 2);
insert into PARTICIPANT values ('Grande-Bretagne', 1, 1, 0, 1, 0);
insert into PARTICIPANT values ('Jamaique', 2, 3, 1, 2, 0);
insert into PARTICIPANT values ('Namibie', 1, 2, 0, 2, 0);
insert into PARTICIPANT values ('Nigeria', 2, 2, 0, 0, 2);
insert into PARTICIPANT values ('Ouganda', 1, 1, 0, 0, 1);
insert into PARTICIPANT values ('Russie', 1, 1, 0, 1, 0);
insert into PARTICIPANT values ('Slovanie', 1, 1, 0, 1, 0);
insert into PARTICIPANT values ('Suede', 1, 1, 1, 0, 0);
insert into PARTICIPANT values ('Trinidad', 1, 0, 0, 0, 0);
insert into PARTICIPANT values ('USA', 9, 10, 5, 2, 3);
insert into PARTICIPANT values ('Zambie', 1, 1, 0, 1, 0);
insert into PARTICIPANT values ('Suisse',1, 1, 0, 1, 0);
insert into SPORTIF values (1,'Johnson','Michael',25,'masculin','USA');
insert into SPORTIF values (2,'Fredericks','Franckie',30,'masculin','Namibie');
insert into SPORTIF values (3,'Boldon','Ato',20,'masculin','Trinidad');
insert into SPORTIF values (4,'Bailey','D.',25,'masculin','Canada');
insert into SPORTIF values (5,'Black','J.',30,'masculin','Grande-Bretagne');
insert into SPORTIF values (6,'Kamoga','J.',20,'masculin','Ouganda');
insert into SPORTIF values (7,'Johnson','J.',24,'masculin','USA');
insert into SPORTIF values (8,'Crear','M.',24,'masculin','USA');
insert into SPORTIF values (9,'Schwartoff','M.',24,'masculin','Allemagne');
insert into SPORTIF values (10,'Adkins','M.',24,'masculin','USA');
insert into SPORTIF values (11,'Matete','M.',30,'masculin','Zambie');
insert into SPORTIF values (12,'Davis','M.',28,'masculin','USA');
insert into SPORTIF values (13,'Galfione','Jean',24,'masculin','France');
insert into SPORTIF values (14,'Trandenkov','B.',30,'masculin','Russie');
insert into SPORTIF values (15,'Tivontchik','M.',22,'masculin','Allemagne');
insert into SPORTIF values (16,'Devers','Gail',27,'feminin','USA');
insert into SPORTIF values (17,'Ottey','Merlene',33,'feminin','Jamaique');
insert into SPORTIF values (18,'Torrence','Gwen',27,'feminin','USA');
insert into SPORTIF values (19,'Perec','Majo',27,'feminin','France');
insert into SPORTIF values (20,'Onyali','Mary',24,'feminin','Nigeria');
insert into SPORTIF values (21,'Freeman','M.',28,'feminin','Australie');
insert into SPORTIF values (22,'Ogunkoya','P.',21,'feminin','Nigeria');
insert into SPORTIF values (23,'Engquist','P.',31,'feminin','Suede');
insert into SPORTIF values (24,'Bukovec','P.',31,'feminin','Slovanie');
insert into SPORTIF values (25,'Girard','Patricia',27,'feminin','France');
insert into SPORTIF values (26,'Hemmings','T.',27,'feminin','Jamaique');
insert into SPORTIF values (27,'Batten','D.',27,'feminin','USA');
insert into SPORTIF values (28,'Buford','B.',27,'feminin','USA');
insert into SPORTIF values (29,'Kirchhoff','A.',24,'masculin','Allemagne');
insert into SPORTIF values (30,'Melliger','S.',24,'masculin','Suisse');
insert into SPORTIF values (31,'Ledermann','Alexandra',25,'feminin','France');
insert into DISCIPLINE values (11, '100m', 'athletisme');
insert into DISCIPLINE values (12, '200m', 'athletisme');
insert into DISCIPLINE values (13, '400m', 'athletisme');
insert into DISCIPLINE values (14, '110m Haies', 'athletisme');
insert into DISCIPLINE values (15, '400m Haies', 'athletisme');
insert into DISCIPLINE values (16, 'perche', 'athletisme');
insert into DISCIPLINE values (17, '100m Haies', 'athletisme');
insert into DISCIPLINE values (20, 'Saut Obstacles Ind.','Equitation');
insert into TYPE_DIS values (11,'masculin');
insert into TYPE_DIS values (12,'masculin');
insert into TYPE_DIS values (13,'masculin');
insert into TYPE_DIS values (14,'masculin');
insert into TYPE_DIS values (15,'masculin');
insert into TYPE_DIS values (16,'masculin');
insert into TYPE_DIS values (11,'feminin');
insert into TYPE_DIS values (12,'feminin');
insert into TYPE_DIS values (13,'feminin');
insert into TYPE_DIS values (17,'feminin');
insert into TYPE_DIS values (15,'feminin');
insert into TYPE_DIS values (20,'mixte');
INSERT INTO SPOR_DIS values(2,11);
INSERT INTO SPOR_DIS values(2,12);
INSERT INTO SPOR_DIS values(3,11);
INSERT INTO SPOR_DIS values(3,12);
INSERT INTO SPOR_DIS values(4,11);
INSERT INTO SPOR_DIS values(4,12);
INSERT INTO SPOR_DIS values(5,12);
INSERT INTO SPOR_DIS values(5,13);
INSERT INTO SPOR_DIS values(6,13);
INSERT INTO SPOR_DIS values(7,14);
INSERT INTO SPOR_DIS values(8,14);
INSERT INTO SPOR_DIS values(9,14);
INSERT INTO SPOR_DIS values(10,15);
INSERT INTO SPOR_DIS values(11,15);
INSERT INTO SPOR_DIS values(12,15);
INSERT INTO SPOR_DIS values(13,16);
INSERT INTO SPOR_DIS values(14,16);
INSERT INTO SPOR_DIS values(15,16);
INSERT INTO SPOR_DIS values(1,12);
INSERT INTO SPOR_DIS values(1,13);
INSERT INTO SPOR_DIS values(16,11);
INSERT INTO SPOR_DIS values(16,17);
INSERT INTO SPOR_DIS values(17,11);
INSERT INTO SPOR_DIS values(17,12);
INSERT INTO SPOR_DIS values(18,11);
INSERT INTO SPOR_DIS values(18,12);
INSERT INTO SPOR_DIS values(19,12);
INSERT INTO SPOR_DIS values(19,13);
INSERT INTO SPOR_DIS values(20,11);
INSERT INTO SPOR_DIS values(20,12);
INSERT INTO SPOR_DIS values(21,13);
INSERT INTO SPOR_DIS values(22,13);
INSERT INTO SPOR_DIS values(23,17);
INSERT INTO SPOR_DIS values(24,17);
INSERT INTO SPOR_DIS values(25,11);
INSERT INTO SPOR_DIS values(25,17);
INSERT INTO SPOR_DIS values(26,15);
INSERT INTO SPOR_DIS values(27,15);
INSERT INTO SPOR_DIS values(28,15);
INSERT INTO SPOR_DIS values(29,20);
INSERT INTO SPOR_DIS values(30,20);
INSERT INTO SPOR_DIS values(31,20);
INSERT INTO RES_OR values(11,'masculin',4);
INSERT INTO RES_OR values(11,'feminin',16);
INSERT INTO RES_OR values(12,'masculin',1);
INSERT INTO RES_OR values(12,'feminin',19);
INSERT INTO RES_OR values(13,'masculin',1);
INSERT INTO RES_OR values(13,'feminin',19);
INSERT INTO RES_OR values(14,'masculin',7);
INSERT INTO RES_OR values(15,'masculin',10);
INSERT INTO RES_OR values(15,'feminin',26);
INSERT INTO RES_OR values(16,'masculin',13);
INSERT INTO RES_OR values(17,'feminin',23);
INSERT INTO RES_OR values(20,'mixte',29);
INSERT INTO RES_AR values(11,'masculin',2);
INSERT INTO RES_AR values(11,'feminin',17);
INSERT INTO RES_AR values(12,'masculin',2);
INSERT INTO RES_AR values(12,'feminin',17);
INSERT INTO RES_AR values(13,'masculin',5);
INSERT INTO RES_AR values(13,'feminin',21);
INSERT INTO RES_AR values(14,'masculin',8);
INSERT INTO RES_AR values(15,'masculin',11);
INSERT INTO RES_AR values(15,'feminin',27);

INSERT INTO RES_AR values(16,'masculin',14);
INSERT INTO RES_AR values(17,'feminin',24);
INSERT INTO RES_AR values(20,'mixte',30);
INSERT INTO RES_BR values(11,'masculin',3);
INSERT INTO RES_BR values(11,'feminin',18);
INSERT INTO RES_BR values(12,'masculin',3);
INSERT INTO RES_BR values(13,'masculin',6);
INSERT INTO RES_BR values(14,'masculin',9);
INSERT INTO RES_BR values(15,'masculin',12);
INSERT INTO RES_BR values(16,'masculin',15);
INSERT INTO RES_BR values(20,'mixte',31);

insert into PARTICIPANT values ('Allemagne', 3, 0, 0, 0, 0);
insert into PARTICIPANT values ('Allemagne', 4, 2, 3, 0, 0);
insert into SPORTIF values (1,'Johnson','Michael',25,'masculin','USA');
insert into SPORTIF values (1,'Fourel','Franck',25,'masculin','France');
insert into DISCIPLINE values (11, '100m', 'athletisme');
insert into DISCIPLINE values (11, '200m', 'natation');
insert into TYPE_DIS values (11,'masculin');
insert into TYPE_DIS values (11,'masculin');
INSERT INTO SPOR_DIS values(2,11);
INSERT INTO SPOR_DIS values(2,11);
INSERT INTO RES_OR values(11,'masculin',4);
INSERT INTO RES_OR values(11,'masculin',4);
INSERT INTO RES_AR values(11,'masculin',2);
INSERT INTO RES_AR values(11,'masculin',2);
INSERT INTO RES_BR values(11,'masculin',3);
INSERT INTO RES_BR values(11,'masculin',3);
insert into TYPE_DIS values (30,'masculin');
INSERT INTO SPOR_DIS values(2,30);
INSERT INTO SPOR_DIS values(50,11);
INSERT INTO RES_OR values(14,'feminin',4);
INSERT INTO RES_AR values(14,'feminin',4);
INSERT INTO RES_BR values(14,'feminin',4);
INSERT INTO RES_OR values(11,'masculin',50);
INSERT INTO RES_AR values(11,'masculin',50);
INSERT INTO RES_BR values(11,'masculin',50);
INSERT INTO SPOR_DIS values(25,14);
INSERT INTO SPOR_DIS values(2,17);
update PARTICIPANT set NBMED=0 WHERE PAYS='USA';
update PARTICIPANT set NBMEDOR=0 WHERE PAYS='USA';
update PARTICIPANT set NBMEDAR=0 WHERE PAYS='USA';
update PARTICIPANT set NBMEDBR=0 WHERE PAYS='USA';

INSERT INTO RES_AR values(11,'masculin',4);
INSERT INTO RES_OR values(12,'masculin',3);
INSERT INTO RES_BR values(15,'masculin',11);
insert into TYPE_DIS values (11,'mixte');
delete from RES_OR where ND=16;
delete from RES_AR where ND=14;
insert into PARTICIPANT values ('titi', 3, -3, -40, -9, -4);
insert into SPORTIF values (51,'Eon','Chevallier',-25,'ange','France');
insert into TYPE_DIS values (21,'ange');

