insert into theme values(1,'litterature francaise');
insert into theme values(2,'politique');
insert into theme values(3,'litterature etrangere');


insert into auteur values(1,'Vargas','Fred','Marseille');
insert into auteur values(2,'Coe','Jonathan','Londres');
insert into auteur values(3,'Mahfouz','Nagib','Le Caire');
insert into auteur values(4,'Boyden','Joseph','Toronto');
insert into auteur values(5,'Gaude','Laurent','Paris');
insert into auteur values(6,'Quint','Michel','Lille');


insert into editeur values(1,'folio','Paris');
insert into editeur values(2,'gorgone','Lille');
insert into editeur values(3,'babel','Arles');
insert into editeur values(4,'fayard','Arles');
insert into editeur values(5,'seuil','Paris');	
insert into editeur values(6,'10-18','Paris');


insert into oeuvre values(1,1,'Le soleil des Scorta',3);
insert into oeuvre values(2,3,'Le chemin des âmes',5);
insert into oeuvre values(3,3,'Bienvenue au club',1);
insert into oeuvre values(4,2,'Le cercle fermé',6);
insert into oeuvre values(5,1,'Et mon mal est délicieux',2);
insert into oeuvre values(6,1,'Sous les vents de Neptune',1);
insert into oeuvre values(7,1,'Dans les bois éternels',2);
insert into oeuvre values(8,1,'Effroyables jardins',2);


insert into oeuvreauteur values(1,5);
insert into oeuvreauteur values(2,4);
insert into oeuvreauteur values(3,2);
insert into oeuvreauteur values(4,2);
insert into oeuvreauteur values(5,6);
insert into oeuvreauteur values(6,1);
insert into oeuvreauteur values(7,1);
insert into oeuvreauteur values(8,6);


insert into adherent values(1,'Patamob','Adhémar',0);
insert into adherent values(2,'Zeublouse','Agathe',0);
insert into adherent values(3,'Rivenbusse','Elsa',0);
insert into adherent values(4,'Comindieu','Thibaud',0);
insert into adherent values(5,'Ardelpic','Helmut',0);
insert into adherent values(6,'Peulafenetre','Firmin',20);
insert into adherent values(7,'Locale','Anasthasie',0);
insert into adherent values(8,'Bierrekeuchprefere','Michel',0);


insert into livre values(1,1,'2006-01-08',0,'f');
insert into livre values(2,1,'2007-01-08',0,'f');
insert into livre values(3,1,'2008-01-08',0,'f');
insert into livre values(4,2,'2006-01-08',0,'f');
insert into livre values(5,3,'2008-01-08',0,'f');
insert into livre values(6,2,'1970-01-08',0,'f');
insert into livre values(7,4,'2001-01-08',0,'f');
insert into livre values(8,5,'2001-01-08',0,'f');
insert into livre values(9,6,'2003-11-03',0,'f');
insert into livre values(10,7,'2003-11-03',0,'f');
insert into livre values(11,7,'2003-11-03',0,'f');


insert into emprunt values(1,8,9,'2003-11-03');
insert into emprunt values(2,3,10,'2003-11-03');
insert into emprunt values(3,4,11,'2003-11-03');


insert into histoemprunt values(1,1,1,'1966-08-01','1966-08-12');
insert into histoemprunt values(2,1,2,'1967-08-01','1967-08-26');
insert into histoemprunt values(3,2,3,'1968-08-01','1968-08-12');
insert into histoemprunt values(4,2,4,'1966-08-01','1966-08-14');
insert into histoemprunt values(5,5,5,'1968-08-01','1968-08-20');
insert into histoemprunt values(6,4,6,'1970-08-01','1970-09-05');
insert into histoemprunt values(7,3,7,'2001-08-01','2001-08-26');
insert into histoemprunt values(8,8,8,'2001-08-01','2001-08-26');