--remplissage de la table dragons
insert into dragons values ('Smeagol','M',152,1857,'O','macho');
insert into dragons values ('Birdurh','M',258,4787,'N','timide');
insert into dragons values ('Negueth','F',128,1582,'O','sincere');
insert into dragons values ('MissToc','F',183,2781,'N','volage');
insert into dragons values ('Bolong','M',213,2754,'O','macho');
insert into dragons values ('Miloch','M',83,718,'O','timide');
insert into dragons values ('Nessie','M',168,1721,'N','macho');
insert into dragons values ('Tarak','F',123,851,'O','timide');
insert into dragons values ('Solong','M',173,1481,'O','timide');

--remplissage de la table amours
insert into amours values('Smeagol','Tarak','passionnement');
insert into amours values('Birdurh','Negueth','beaucoup');
insert into amours values('Negueth','Miloch','a la folie');
insert into amours values('Miloch','Negueth','a la folie');
insert into amours values('Tarak','Bolong','un peu');
insert into amours values('Bolong','Tarak','beaucoup');
insert into amours values('Nessie','Tarak','un peu');

--remplissage de la table nourritures
insert into nourritures values('pomme',7);
insert into nourritures values('cacahuete',10);
insert into nourritures values('orange',25);
insert into nourritures values('oeuf',15);
insert into nourritures values('ver',3);
insert into nourritures values('poisson',35);

--remplissage de la table repas
insert into repas values('Smeagol','cacahuete',1000);
insert into repas values('Smeagol','pomme',16);
insert into repas values('Bolong','oeuf',4);
insert into repas values('Negueth','orange',6);
insert into repas values('Negueth','oeuf',1);
insert into repas values('Miloch','cacahuete',100);
insert into repas values('Tarak','pomme',10);
insert into repas values('Tarak','orange',10);
insert into repas values('Solong','oeuf',6);
insert into repas values('Solong','orange',2);
insert into repas values('Miloch','ver',53);
insert into repas values('Nessie','poisson',20);
insert into repas values('Solong','poisson',1);
