-- Base de données: `bibliotheque` -- CREATE DATABASE bibliotheque; USE bibliotheque; -- -- Structure de la table `adherent` -- CREATE TABLE `adherent` ( `codeAdh` smallint(6) NOT NULL auto_increment, `nomAdh` varchar(25) NOT NULL default '', `prenomAdh` varchar(25) NOT NULL default '', `adrRueAdh` varchar(50) default NULL, `adrCPAdh` mediumint(5) default NULL, `adrVilleAdh` varchar(25) default NULL, `telAdh` varchar(10) default NULL, `melAdh` varchar(25) default NULL, PRIMARY KEY (`codeAdh`) ) ENGINE=InnoDB CHARACTER SET latin1 AUTO_INCREMENT=21 ; -- -- Contenu de la table `adherent` -- INSERT INTO `adherent` VALUES (1, 'Deltour', 'Charles', '4 rue du Pont', 95100, 'Argenteuil', '01...', 'cdeltour@hotmail.com'); INSERT INTO `adherent` VALUES (2, 'Fime', 'Nadia', '5 rue du Montparnasse', 75006, 'Paris', '06...', NULL); INSERT INTO `adherent` VALUES (3, 'Ertau', 'Frank', '4 Avenue du président Wilson', 94320, 'Cachan', '01...', 'frank.ertau@laposte.net'); INSERT INTO `adherent` VALUES (4, 'Maneur', 'David', '6 rue Charles Péguy', 94000, 'Créteil', '01...', NULL); INSERT INTO `adherent` VALUES (5, 'Berezovski', 'Sylvie', '18 rue du Château', 91150, 'Etampes', '01...', NULL); INSERT INTO `adherent` VALUES (6, 'Finley', 'Pascale', '25 rue de Tolbiac', 75013, 'Paris', '01...', 'pascfinley@yahoo.fr'); INSERT INTO `adherent` VALUES (7, 'Vofur', 'Hector', '18 rue Deparcieux', 75014, 'Paris', '01...', 'hvofur@free.fr'); INSERT INTO `adherent` VALUES (8, 'Derzou', 'Fred', '230 avenue de la liberté', 93100, 'Montreuil-sous-bois', '01...', 'ouzala@aol.com'); INSERT INTO `adherent` VALUES (9, 'Serty', 'Julie', '23 rue du Calvaire', 92800, 'Suresnes', '01...', NULL); INSERT INTO `adherent` VALUES (10, 'Vofur', 'Victor', '18 rue Deparcieux', 75014, 'Paris', '01...', 'victor.vofur@laposte.net'); INSERT INTO `adherent` VALUES (11, 'Calende', 'Hugo', '22 rue des jardins', 91000, 'Evry', '01...', NULL); INSERT INTO `adherent` VALUES (12, 'Jemba', 'Hubert', '10 rue du 8 mai 1945', 78000, 'Versailles', '01...', 'jaimeba@yahoo.fr'); INSERT INTO `adherent` VALUES (13, 'Morin', 'Séverine', '4 rue du bac', 93000, 'Saint Denis', '01...', 'morinsev@hotmail.com'); INSERT INTO `adherent` VALUES (14, 'Benrech', 'Tarek', '79 rue de Sèvres', 95000, 'Nanterre', '01...', NULL); INSERT INTO `adherent` VALUES (15, 'Nguyen', 'Marc', '53 impasse Tourneur', 91400, 'Orsay', '01...', 'nguyen774@wanadoo.fr'); INSERT INTO `adherent` VALUES (16, 'Louali', 'Karima', '89 avenue Poincaré', 75001, 'Paris', '01...', 'kloua@caramail.fr'); INSERT INTO `adherent` VALUES (17, 'Paolo', 'Marco', '14 rue du Caire', 91300, 'Massy', '01...', NULL); INSERT INTO `adherent` VALUES (18, 'Map', 'Joanna', '120 boulevard Voltaire', 75012, 'Paris', '01...', NULL); INSERT INTO `adherent` VALUES (19, 'Koundé', 'Fatoumata', '4 Place Carrée', 77000, 'Melun', '01...', NULL); INSERT INTO `adherent` VALUES (20, 'Derissam', 'Bachir', '1 rue des Indes', 78550, 'Houdan', '01...', NULL); -- -------------------------------------------------------- -- -- Structure de la table `auteur` -- CREATE TABLE `auteur` ( `codeAuteur` smallint(6) NOT NULL auto_increment, `nomAuteur` varchar(25) NOT NULL default '', `prenomAuteur` varchar(25) default NULL, `nationaliteAuteur` varchar(15) default NULL, PRIMARY KEY (`codeAuteur`) ) ENGINE=InnoDB CHARACTER SET latin1 AUTO_INCREMENT=34 ; -- -- Contenu de la table `auteur` -- INSERT INTO `auteur` VALUES (1, 'Dostoeïvski', 'Fédor', 'Russe'); INSERT INTO `auteur` VALUES (2, 'Semprun', 'Jorge', 'Espagnole'); INSERT INTO `auteur` VALUES (3, 'Tolstoï', 'Leon', 'Russe'); INSERT INTO `auteur` VALUES (4, 'Steinbeck', 'John', 'Américaine'); INSERT INTO `auteur` VALUES (5, 'Ferro', 'Marc', 'Française'); INSERT INTO `auteur` VALUES (6, 'Stocker', 'Bram', 'Irlandaise'); INSERT INTO `auteur` VALUES (7, 'Shelley', 'Marie', 'Britannique'); INSERT INTO `auteur` VALUES (8, 'King', 'Stephen', 'Américaine'); INSERT INTO `auteur` VALUES (9, 'Grass', 'Gunter', 'Allemande'); INSERT INTO `auteur` VALUES (10, 'Barjavel', 'René', 'Française'); INSERT INTO `auteur` VALUES (11, 'Simmons', 'Dan', 'Américaine'); INSERT INTO `auteur` VALUES (12, 'Herbert', 'Frank', 'Américaine'); INSERT INTO `auteur` VALUES (13, 'Clarke', 'Arthur C.', 'Britannique'); INSERT INTO `auteur` VALUES (14, 'Bradbury', 'Ray', 'Américaine'); INSERT INTO `auteur` VALUES (15, 'Dick', 'Philip K.', 'Américaine'); INSERT INTO `auteur` VALUES (16, 'Orwell', 'Georges', 'Britannique'); INSERT INTO `auteur` VALUES (17, 'Hugo', 'Victor', 'Française'); INSERT INTO `auteur` VALUES (18, 'Zola', 'Emile', 'Française'); INSERT INTO `auteur` VALUES (19, 'Morris', NULL, 'Belge'); INSERT INTO `auteur` VALUES (20, 'Flaubert', 'Gustave', 'Française'); INSERT INTO `auteur` VALUES (21, 'Asimov', 'Isaac', 'Américaine'); INSERT INTO `auteur` VALUES (22, 'Miller', 'Frank', 'Américaine'); INSERT INTO `auteur` VALUES (23, 'Eco', 'Umberto', 'Italienne'); INSERT INTO `auteur` VALUES (24, 'Irving', 'John', 'Américaine'); INSERT INTO `auteur` VALUES (25, 'Braudel', 'Fernand', 'Française'); INSERT INTO `auteur` VALUES (26, 'Camus', 'Albert', 'Française'); INSERT INTO `auteur` VALUES (27, 'Vian', 'Boris', 'Française'); INSERT INTO `auteur` VALUES (28, 'Lehane', 'Dennis', 'Américaine'); INSERT INTO `auteur` VALUES (29, 'Oe', 'Kenzaburo', 'Japonaise'); INSERT INTO `auteur` VALUES (30, 'Kertesz', 'Imre', 'Hongrois'); INSERT INTO `auteur` VALUES (31, 'Garcia Marquez', 'Gabriel', 'Colombien'); INSERT INTO `auteur` VALUES (32, 'Pratt', 'Hugo', 'Italienne'); INSERT INTO `auteur` VALUES (33, 'Cooper', 'Fenimore', 'Américaine'); -- -------------------------------------------------------- -- -- Structure de la table `emprunter` -- CREATE TABLE `emprunter` ( `codeLivreEmprunte` smallint(6) NOT NULL default '0', `codeAdherent` smallint(6) NOT NULL default '0', `dateEmprunt` date NOT NULL default '0000-00-00', `dateRetourPrevue` date NOT NULL default '0000-00-00', `dateRetourReelle` date default NULL, PRIMARY KEY (`codeLivreEmprunte`,`codeAdherent`,`dateEmprunt`), KEY `codeAdherent` (`codeAdherent`), KEY `codeLivreEmprunte` (`codeLivreEmprunte`) ) ENGINE=InnoDB CHARACTER SET latin1; -- -- Contenu de la table `emprunter` -- INSERT INTO `emprunter` VALUES ('1','1','2005-06-02','2005-06-16','2005-06-16'); INSERT INTO `emprunter` VALUES ('1','2','2005-05-02','2005-05-16','2005-05-12'); INSERT INTO `emprunter` VALUES ('1','3','2005-05-13','2005-05-27','2005-05-22'); INSERT INTO `emprunter` VALUES ('1','14','2005-06-18','2005-07-02','2005-07-01'); INSERT INTO `emprunter` VALUES ('2','5','2005-05-22','2005-06-05','2005-06-04'); INSERT INTO `emprunter` VALUES ('2','6','2005-06-06','2005-06-20','2005-06-13'); INSERT INTO `emprunter` VALUES ('2','14','2005-05-04','2005-05-18','2005-05-20'); INSERT INTO `emprunter` VALUES ('3','6','2005-05-07','2005-05-21','2005-05-18'); INSERT INTO `emprunter` VALUES ('3','7','2005-05-19','2005-06-02','2005-06-02'); INSERT INTO `emprunter` VALUES ('3','8','2005-06-03','2005-06-17','2005-06-16'); INSERT INTO `emprunter` VALUES ('4','9','2005-05-10','2005-05-24','2005-05-19'); INSERT INTO `emprunter` VALUES ('4','10','2005-05-20','2005-06-03','2005-06-05'); INSERT INTO `emprunter` VALUES ('4','11','2005-06-06','2005-06-20','2005-06-21'); INSERT INTO `emprunter` VALUES ('5','4','2005-05-21','2005-06-04','2005-06-01'); INSERT INTO `emprunter` VALUES ('5','5','2005-05-13','2005-05-27','2005-05-20'); INSERT INTO `emprunter` VALUES ('5','8','2005-06-02','2005-06-16','2005-06-16'); INSERT INTO `emprunter` VALUES ('5','14','2005-06-18','2005-07-02','2005-06-29'); INSERT INTO `emprunter` VALUES ('6','2','2005-06-20','2005-07-04','2005-07-05'); INSERT INTO `emprunter` VALUES ('6','4','2005-08-15','2005-08-29','2005-08-28'); INSERT INTO `emprunter` VALUES ('6','6','2005-07-07','2005-07-21','2005-07-18'); INSERT INTO `emprunter` VALUES ('6','7','2005-05-16','2005-05-30','2005-05-25'); INSERT INTO `emprunter` VALUES ('6','8','2005-07-19','2005-08-02','2005-08-12'); INSERT INTO `emprunter` VALUES ('6','9','2005-05-26','2005-06-09','2005-06-11'); INSERT INTO `emprunter` VALUES ('6','16','2005-08-29','2005-09-12','2005-09-13'); INSERT INTO `emprunter` VALUES ('6','16','2005-09-14','2005-09-28','2005-09-30'); INSERT INTO `emprunter` VALUES ('7','3','2005-05-19','2005-06-02','2005-05-26'); INSERT INTO `emprunter` VALUES ('7','3','2005-07-10','2005-07-24','2005-07-21'); INSERT INTO `emprunter` VALUES ('7','6','2005-05-27','2005-06-10','2005-06-10'); INSERT INTO `emprunter` VALUES ('7','7','2005-07-22','2005-08-05','2005-08-07'); INSERT INTO `emprunter` VALUES ('7','9','2005-06-15','2005-06-29','2005-06-25'); INSERT INTO `emprunter` VALUES ('7','13','2005-06-30','2005-07-14','2005-07-09'); INSERT INTO `emprunter` VALUES ('8','4','2005-05-20','2005-06-03','2005-05-31'); INSERT INTO `emprunter` VALUES ('8','6','2005-09-01','2005-09-15','2005-09-15'); INSERT INTO `emprunter` VALUES ('8','6','2005-09-18','2005-10-02','2005-10-01'); INSERT INTO `emprunter` VALUES ('8','7','2005-06-03','2005-06-17','2005-06-27'); INSERT INTO `emprunter` VALUES ('8','8','2005-06-30','2005-07-14','2005-07-16'); INSERT INTO `emprunter` VALUES ('8','8','2005-10-03','2005-10-17','2005-10-12'); INSERT INTO `emprunter` VALUES ('8','10','2005-08-05','2005-08-19','2005-08-12'); INSERT INTO `emprunter` VALUES ('8','16','2005-07-19','2005-08-02','2005-08-03'); INSERT INTO `emprunter` VALUES ('8','16','2005-08-14','2005-08-28','2005-08-25'); INSERT INTO `emprunter` VALUES ('9','7','2005-08-02','2005-08-16','2005-08-11'); INSERT INTO `emprunter` VALUES ('9','8','2005-06-06','2005-06-20','2005-06-21'); INSERT INTO `emprunter` VALUES ('9','8','2005-07-04','2005-07-18','2005-07-15'); INSERT INTO `emprunter` VALUES ('9','10','2005-05-20','2005-06-03','2005-06-05'); INSERT INTO `emprunter` VALUES ('9','11','2005-06-21','2005-07-05','2005-06-28'); INSERT INTO `emprunter` VALUES ('9','11','2005-08-31','2005-09-14','2005-09-15'); INSERT INTO `emprunter` VALUES ('9','12','2005-08-13','2005-08-27','2005-08-29'); INSERT INTO `emprunter` VALUES ('9','12','2005-09-15','2005-09-29','2005-09-26'); INSERT INTO `emprunter` VALUES ('9','12','2005-10-01','2005-10-15',NULL); INSERT INTO `emprunter` VALUES ('9','15','2005-07-16','2005-07-30','2005-07-30'); INSERT INTO `emprunter` VALUES ('10','1','2005-05-02','2005-05-16','2005-05-05'); INSERT INTO `emprunter` VALUES ('10','1','2005-05-05','2005-05-19','2005-05-06'); INSERT INTO `emprunter` VALUES ('10','1','2005-05-06','2005-05-20','2005-05-07'); INSERT INTO `emprunter` VALUES ('10','1','2005-05-07','2005-05-21','2005-05-08'); INSERT INTO `emprunter` VALUES ('10','1','2005-05-08','2005-05-22','2005-05-10'); INSERT INTO `emprunter` VALUES ('10','1','2005-05-10','2005-05-24','2005-05-10'); INSERT INTO `emprunter` VALUES ('10','2','2005-05-10','2005-05-24','2005-05-11'); INSERT INTO `emprunter` VALUES ('10','2','2005-05-11','2005-05-25','2005-05-12'); INSERT INTO `emprunter` VALUES ('10','2','2005-05-12','2005-05-26','2005-05-15'); INSERT INTO `emprunter` VALUES ('10','2','2005-05-15','2005-05-29','2005-05-18'); INSERT INTO `emprunter` VALUES ('10','2','2005-05-18','2005-06-01','2005-05-19'); INSERT INTO `emprunter` VALUES ('10','2','2005-05-19','2005-06-02','2005-05-20'); INSERT INTO `emprunter` VALUES ('10','2','2005-05-20','2005-06-03','2005-05-21'); INSERT INTO `emprunter` VALUES ('10','2','2005-05-21','2005-06-04','2005-05-22'); INSERT INTO `emprunter` VALUES ('10','2','2005-05-22','2005-06-05','2005-05-23'); INSERT INTO `emprunter` VALUES ('10','2','2005-05-23','2005-06-06','2005-05-24'); INSERT INTO `emprunter` VALUES ('10','2','2005-05-24','2005-06-07','2005-05-26'); INSERT INTO `emprunter` VALUES ('10','2','2005-05-26','2005-06-09','2005-05-27'); INSERT INTO `emprunter` VALUES ('10','2','2005-05-27','2005-06-10','2005-05-30'); INSERT INTO `emprunter` VALUES ('10','3','2005-05-30','2005-06-13','2005-05-30'); INSERT INTO `emprunter` VALUES ('10','4','2005-05-30','2005-06-13','2005-06-02'); INSERT INTO `emprunter` VALUES ('10','4','2005-06-02','2005-06-16','2005-06-04'); INSERT INTO `emprunter` VALUES ('10','4','2005-06-04','2005-06-18','2005-06-06'); INSERT INTO `emprunter` VALUES ('10','4','2005-06-06','2005-06-20','2005-06-07'); INSERT INTO `emprunter` VALUES ('10','4','2005-06-07','2005-06-21','2005-06-08'); INSERT INTO `emprunter` VALUES ('10','4','2005-06-08','2005-06-22','2005-06-09'); INSERT INTO `emprunter` VALUES ('10','5','2005-06-09','2005-06-23','2005-06-10'); INSERT INTO `emprunter` VALUES ('10','5','2005-06-10','2005-06-24','2005-06-11'); INSERT INTO `emprunter` VALUES ('10','5','2005-06-11','2005-06-25','2005-06-13'); INSERT INTO `emprunter` VALUES ('10','5','2005-06-13','2005-06-27','2005-06-16'); INSERT INTO `emprunter` VALUES ('10','6','2005-06-16','2005-06-30','2005-06-17'); INSERT INTO `emprunter` VALUES ('10','6','2005-06-17','2005-07-01','2005-06-18'); INSERT INTO `emprunter` VALUES ('10','6','2005-06-18','2005-07-02','2005-06-19'); INSERT INTO `emprunter` VALUES ('10','6','2005-06-19','2005-07-03','2005-06-20'); INSERT INTO `emprunter` VALUES ('10','7','2005-06-20','2005-07-04','2005-06-21'); INSERT INTO `emprunter` VALUES ('10','7','2005-06-21','2005-07-05','2005-06-23'); INSERT INTO `emprunter` VALUES ('10','7','2005-06-23','2005-07-07','2005-06-26'); INSERT INTO `emprunter` VALUES ('10','7','2005-06-26','2005-07-10','2005-06-27'); INSERT INTO `emprunter` VALUES ('10','7','2005-06-27','2005-07-11','2005-06-28'); INSERT INTO `emprunter` VALUES ('10','7','2005-06-28','2005-07-12','2005-06-29'); INSERT INTO `emprunter` VALUES ('10','7','2005-06-29','2005-07-13','2005-06-30'); INSERT INTO `emprunter` VALUES ('10','7','2005-06-30','2005-07-14','2005-07-01'); INSERT INTO `emprunter` VALUES ('10','7','2005-07-01','2005-07-15','2005-07-03'); INSERT INTO `emprunter` VALUES ('10','8','2005-07-03','2005-07-17','2005-07-06'); INSERT INTO `emprunter` VALUES ('10','8','2005-07-06','2005-07-20','2005-07-07'); INSERT INTO `emprunter` VALUES ('10','8','2005-07-07','2005-07-21','2005-07-08'); INSERT INTO `emprunter` VALUES ('10','8','2005-07-08','2005-07-22','2005-07-09'); INSERT INTO `emprunter` VALUES ('10','8','2005-07-09','2005-07-23','2005-07-10'); INSERT INTO `emprunter` VALUES ('10','8','2005-07-10','2005-07-24','2005-07-11'); INSERT INTO `emprunter` VALUES ('10','8','2005-07-11','2005-07-25','2005-07-13'); INSERT INTO `emprunter` VALUES ('10','8','2005-07-13','2005-07-27','2005-07-16'); INSERT INTO `emprunter` VALUES ('10','8','2005-07-16','2005-07-30','2005-07-17'); INSERT INTO `emprunter` VALUES ('10','8','2005-07-17','2005-07-31','2005-07-18'); INSERT INTO `emprunter` VALUES ('10','9','2005-07-18','2005-08-01','2005-07-19'); INSERT INTO `emprunter` VALUES ('10','9','2005-07-19','2005-08-02','2005-07-20'); INSERT INTO `emprunter` VALUES ('10','9','2005-07-20','2005-08-03','2005-07-21'); INSERT INTO `emprunter` VALUES ('10','9','2005-07-21','2005-08-04','2005-07-23'); INSERT INTO `emprunter` VALUES ('10','9','2005-07-23','2005-08-06','2005-07-26'); INSERT INTO `emprunter` VALUES ('10','9','2005-07-26','2005-08-09','2005-07-27'); INSERT INTO `emprunter` VALUES ('10','10','2005-07-27','2005-08-10','2005-07-28'); INSERT INTO `emprunter` VALUES ('10','10','2005-07-28','2005-08-11','2005-07-29'); INSERT INTO `emprunter` VALUES ('10','10','2005-07-29','2005-08-12','2005-07-30'); INSERT INTO `emprunter` VALUES ('10','10','2005-07-30','2005-08-13','2005-07-31'); INSERT INTO `emprunter` VALUES ('10','10','2005-07-31','2005-08-14','2005-08-02'); INSERT INTO `emprunter` VALUES ('10','10','2005-08-02','2005-08-16','2005-08-05'); INSERT INTO `emprunter` VALUES ('10','10','2005-08-05','2005-08-19','2005-08-06'); INSERT INTO `emprunter` VALUES ('10','11','2005-08-06','2005-08-20','2005-08-07'); INSERT INTO `emprunter` VALUES ('10','11','2005-08-07','2005-08-21','2005-08-08'); INSERT INTO `emprunter` VALUES ('10','11','2005-08-08','2005-08-22','2005-08-09'); INSERT INTO `emprunter` VALUES ('10','11','2005-08-09','2005-08-23','2005-08-10'); INSERT INTO `emprunter` VALUES ('10','11','2005-08-10','2005-08-24','2005-08-12'); INSERT INTO `emprunter` VALUES ('10','12','2005-08-12','2005-08-26','2005-08-15'); INSERT INTO `emprunter` VALUES ('10','12','2005-08-15','2005-08-29','2005-08-16'); INSERT INTO `emprunter` VALUES ('10','12','2005-08-16','2005-08-30','2005-08-17'); INSERT INTO `emprunter` VALUES ('10','12','2005-08-17','2005-08-31','2005-08-18'); INSERT INTO `emprunter` VALUES ('10','12','2005-08-18','2005-09-01','2005-08-19'); INSERT INTO `emprunter` VALUES ('10','12','2005-08-19','2005-09-02','2005-08-20'); INSERT INTO `emprunter` VALUES ('10','12','2005-08-20','2005-09-03','2005-08-22'); INSERT INTO `emprunter` VALUES ('10','13','2005-08-22','2005-09-05','2005-08-25'); INSERT INTO `emprunter` VALUES ('10','13','2005-08-25','2005-09-08','2005-08-26'); INSERT INTO `emprunter` VALUES ('10','13','2005-08-26','2005-09-09','2005-08-27'); INSERT INTO `emprunter` VALUES ('10','13','2005-08-27','2005-09-10','2005-08-28'); INSERT INTO `emprunter` VALUES ('10','13','2005-08-28','2005-09-11','2005-08-29'); INSERT INTO `emprunter` VALUES ('10','13','2005-08-29','2005-09-12','2005-08-30'); INSERT INTO `emprunter` VALUES ('10','14','2005-08-30','2005-09-13','2005-09-01'); INSERT INTO `emprunter` VALUES ('10','14','2005-09-01','2005-09-15','2005-09-04'); INSERT INTO `emprunter` VALUES ('10','14','2005-09-04','2005-09-18','2005-09-05'); INSERT INTO `emprunter` VALUES ('10','14','2005-09-05','2005-09-19','2005-09-06'); INSERT INTO `emprunter` VALUES ('10','14','2005-09-06','2005-09-20','2005-09-07'); INSERT INTO `emprunter` VALUES ('10','14','2005-09-07','2005-09-21','2005-09-08'); INSERT INTO `emprunter` VALUES ('10','14','2005-09-08','2005-09-22','2005-09-09'); INSERT INTO `emprunter` VALUES ('10','14','2005-09-09','2005-09-23','2005-09-11'); INSERT INTO `emprunter` VALUES ('10','14','2005-09-11','2005-09-25','2005-09-14'); INSERT INTO `emprunter` VALUES ('10','14','2005-09-14','2005-09-28','2005-09-15'); INSERT INTO `emprunter` VALUES ('10','14','2005-09-15','2005-09-29','2005-09-16'); INSERT INTO `emprunter` VALUES ('10','14','2005-09-16','2005-09-30','2005-09-17'); INSERT INTO `emprunter` VALUES ('10','15','2005-09-17','2005-10-01','2005-09-18'); INSERT INTO `emprunter` VALUES ('10','15','2005-09-18','2005-10-02','2005-09-19'); INSERT INTO `emprunter` VALUES ('10','15','2005-09-19','2005-10-03','2005-09-21'); INSERT INTO `emprunter` VALUES ('10','15','2005-09-21','2005-10-05','2005-09-24'); INSERT INTO `emprunter` VALUES ('10','15','2005-09-24','2005-10-08','2005-09-25'); INSERT INTO `emprunter` VALUES ('10','15','2005-09-25','2005-10-09','2005-09-26'); INSERT INTO `emprunter` VALUES ('10','15','2005-09-26','2005-10-10','2005-09-27'); INSERT INTO `emprunter` VALUES ('10','15','2005-09-27','2005-10-11','2005-09-28'); INSERT INTO `emprunter` VALUES ('11','1','2005-05-10','2005-05-24','2005-05-23'); INSERT INTO `emprunter` VALUES ('11','4','2005-07-12','2005-07-26','2005-07-21'); INSERT INTO `emprunter` VALUES ('11','4','2005-07-22','2005-08-05','2005-08-02'); INSERT INTO `emprunter` VALUES ('11','5','2005-08-05','2005-08-19','2005-08-12'); INSERT INTO `emprunter` VALUES ('11','9','2005-09-13','2005-09-27','2005-09-29'); INSERT INTO `emprunter` VALUES ('11','12','2005-07-03','2005-07-17','2005-07-10'); INSERT INTO `emprunter` VALUES ('11','14','2005-10-03','2005-10-17','2005-10-07'); INSERT INTO `emprunter` VALUES ('12','3','2005-06-20','2005-07-04','2005-06-29'); INSERT INTO `emprunter` VALUES ('12','3','2005-07-03','2005-07-17','2005-07-12'); INSERT INTO `emprunter` VALUES ('12','4','2005-08-12','2005-08-26','2005-08-27'); INSERT INTO `emprunter` VALUES ('12','6','2005-06-10','2005-06-24','2005-06-19'); INSERT INTO `emprunter` VALUES ('12','8','2005-05-04','2005-05-18','2005-05-13'); INSERT INTO `emprunter` VALUES ('12','8','2005-07-24','2005-08-07','2005-08-09'); INSERT INTO `emprunter` VALUES ('12','8','2005-08-29','2005-09-12','2005-09-05'); INSERT INTO `emprunter` VALUES ('12','10','2005-05-25','2005-06-08','2005-06-09'); INSERT INTO `emprunter` VALUES ('12','11','2005-05-14','2005-05-28','2005-05-24'); INSERT INTO `emprunter` VALUES ('12','11','2005-09-07','2005-09-21','2005-09-18'); INSERT INTO `emprunter` VALUES ('12','12','2005-07-12','2005-07-26','2005-07-23'); INSERT INTO `emprunter` VALUES ('12','12','2005-09-20','2005-10-04','2005-09-30'); INSERT INTO `emprunter` VALUES ('12','12','2005-10-04','2005-10-18',NULL); INSERT INTO `emprunter` VALUES ('13','5','2005-06-25','2005-07-09','2005-07-09'); INSERT INTO `emprunter` VALUES ('13','5','2005-09-03','2005-09-17','2005-09-10'); INSERT INTO `emprunter` VALUES ('13','6','2005-08-29','2005-09-12','2005-09-01'); INSERT INTO `emprunter` VALUES ('13','7','2005-07-10','2005-07-24','2005-07-25'); INSERT INTO `emprunter` VALUES ('13','8','2005-05-04','2005-05-18','2005-05-20'); INSERT INTO `emprunter` VALUES ('13','8','2005-08-05','2005-08-19','2005-08-20'); INSERT INTO `emprunter` VALUES ('13','8','2005-08-21','2005-09-04','2005-08-28'); INSERT INTO `emprunter` VALUES ('13','10','2005-06-05','2005-06-19','2005-06-12'); INSERT INTO `emprunter` VALUES ('13','13','2005-05-21','2005-06-04','2005-06-04'); INSERT INTO `emprunter` VALUES ('13','13','2005-06-13','2005-06-27','2005-06-24'); INSERT INTO `emprunter` VALUES ('13','13','2005-07-26','2005-08-09','2005-08-05'); INSERT INTO `emprunter` VALUES ('14','1','2005-06-13','2005-06-27','2005-06-24'); INSERT INTO `emprunter` VALUES ('14','3','2005-07-26','2005-08-09','2005-08-05'); INSERT INTO `emprunter` VALUES ('14','4','2005-06-25','2005-07-09','2005-07-09'); INSERT INTO `emprunter` VALUES ('14','4','2005-10-04','2005-10-18',NULL); INSERT INTO `emprunter` VALUES ('14','7','2005-06-05','2005-06-19','2005-06-12'); INSERT INTO `emprunter` VALUES ('14','8','2005-08-05','2005-08-19','2005-08-20'); INSERT INTO `emprunter` VALUES ('14','8','2005-09-07','2005-09-21','2005-09-18'); INSERT INTO `emprunter` VALUES ('14','9','2005-07-10','2005-07-24','2005-07-25'); INSERT INTO `emprunter` VALUES ('14','13','2005-05-21','2005-06-04','2005-06-04'); INSERT INTO `emprunter` VALUES ('14','13','2005-09-20','2005-10-04','2005-09-30'); INSERT INTO `emprunter` VALUES ('15','2','2005-09-07','2005-09-21','2005-09-21'); INSERT INTO `emprunter` VALUES ('15','3','2005-09-23','2005-10-07','2005-09-30'); INSERT INTO `emprunter` VALUES ('15','6','2005-05-22','2005-06-05','2005-06-05'); INSERT INTO `emprunter` VALUES ('15','6','2005-06-17','2005-07-01','2005-06-26'); INSERT INTO `emprunter` VALUES ('15','8','2005-06-28','2005-07-12','2005-07-13'); INSERT INTO `emprunter` VALUES ('15','9','2005-07-15','2005-07-29','2005-07-31'); INSERT INTO `emprunter` VALUES ('15','9','2005-08-24','2005-09-07','2005-09-04'); INSERT INTO `emprunter` VALUES ('15','10','2005-10-04','2005-10-18',NULL); INSERT INTO `emprunter` VALUES ('15','13','2005-06-06','2005-06-20','2005-06-13'); INSERT INTO `emprunter` VALUES ('15','13','2005-08-04','2005-08-18','2005-08-20'); INSERT INTO `emprunter` VALUES ('16','2','2005-05-07','2005-05-21','2005-05-18'); INSERT INTO `emprunter` VALUES ('16','5','2005-06-05','2005-06-19','2005-06-12'); INSERT INTO `emprunter` VALUES ('16','6','2005-06-13','2005-06-27','2005-06-24'); INSERT INTO `emprunter` VALUES ('16','7','2005-09-07','2005-09-21','2005-09-18'); INSERT INTO `emprunter` VALUES ('16','8','2005-07-26','2005-08-09','2005-08-05'); INSERT INTO `emprunter` VALUES ('16','10','2005-06-25','2005-07-09','2005-07-09'); INSERT INTO `emprunter` VALUES ('16','10','2005-07-10','2005-07-24','2005-07-25'); INSERT INTO `emprunter` VALUES ('16','14','2005-08-05','2005-08-19','2005-08-20'); INSERT INTO `emprunter` VALUES ('16','15','2005-09-20','2005-10-04','2005-09-30'); INSERT INTO `emprunter` VALUES ('16','15','2005-10-04','2005-10-18',NULL); INSERT INTO `emprunter` VALUES ('17','1','2005-09-07','2005-09-21','2005-09-21'); INSERT INTO `emprunter` VALUES ('17','7','2005-10-15','2005-10-29',NULL); INSERT INTO `emprunter` VALUES ('17','9','2005-05-22','2005-06-05','2005-06-05'); INSERT INTO `emprunter` VALUES ('17','9','2005-08-04','2005-08-18','2005-08-20'); INSERT INTO `emprunter` VALUES ('17','10','2005-06-17','2005-07-01','2005-06-26'); INSERT INTO `emprunter` VALUES ('17','10','2005-06-28','2005-07-12','2005-07-13'); INSERT INTO `emprunter` VALUES ('17','10','2005-08-24','2005-09-07','2005-09-04'); INSERT INTO `emprunter` VALUES ('17','11','2005-06-06','2005-06-20','2005-06-13'); INSERT INTO `emprunter` VALUES ('17','11','2005-09-23','2005-10-07','2005-09-30'); INSERT INTO `emprunter` VALUES ('17','12','2005-07-15','2005-07-29','2005-07-31'); INSERT INTO `emprunter` VALUES ('18','5','2005-06-12','2005-06-26','2005-06-26'); INSERT INTO `emprunter` VALUES ('18','6','2005-09-18','2005-10-02','2005-09-28'); INSERT INTO `emprunter` VALUES ('18','7','2005-10-03','2005-10-17','2005-10-19'); INSERT INTO `emprunter` VALUES ('18','8','2005-06-03','2005-06-17','2005-06-12'); INSERT INTO `emprunter` VALUES ('18','8','2005-08-08','2005-08-22','2005-08-15'); INSERT INTO `emprunter` VALUES ('18','9','2005-07-28','2005-08-11','2005-08-06'); INSERT INTO `emprunter` VALUES ('18','9','2005-09-01','2005-09-15','2005-09-15'); INSERT INTO `emprunter` VALUES ('18','10','2005-07-13','2005-07-27','2005-07-27'); INSERT INTO `emprunter` VALUES ('18','11','2005-05-20','2005-06-03','2005-06-03'); INSERT INTO `emprunter` VALUES ('18','13','2005-06-27','2005-07-11','2005-07-04'); INSERT INTO `emprunter` VALUES ('18','15','2005-07-05','2005-07-19','2005-07-12'); INSERT INTO `emprunter` VALUES ('18','15','2005-08-16','2005-08-30','2005-08-25'); INSERT INTO `emprunter` VALUES ('19','2','2005-07-15','2005-07-29','2005-07-31'); INSERT INTO `emprunter` VALUES ('19','3','2005-05-23','2005-06-06','2005-06-08'); INSERT INTO `emprunter` VALUES ('19','8','2005-09-23','2005-10-07','2005-09-30'); INSERT INTO `emprunter` VALUES ('19','9','2005-08-04','2005-08-18','2005-08-20'); INSERT INTO `emprunter` VALUES ('19','9','2005-08-24','2005-09-07','2005-09-04'); INSERT INTO `emprunter` VALUES ('19','10','2005-05-13','2005-05-27','2005-05-20'); INSERT INTO `emprunter` VALUES ('19','12','2005-09-07','2005-09-21','2005-09-21'); INSERT INTO `emprunter` VALUES ('19','16','2005-06-13','2005-06-27','2005-06-24'); INSERT INTO `emprunter` VALUES ('19','16','2005-10-04','2005-10-18',NULL); INSERT INTO `emprunter` VALUES ('20','1','2005-06-06','2005-06-20','2005-06-15'); INSERT INTO `emprunter` VALUES ('20','6','2005-08-04','2005-08-18','2005-08-14'); INSERT INTO `emprunter` VALUES ('20','7','2005-08-24','2005-09-07','2005-09-08'); INSERT INTO `emprunter` VALUES ('20','8','2005-06-17','2005-07-01','2005-07-01'); INSERT INTO `emprunter` VALUES ('20','10','2005-05-22','2005-06-05','2005-05-29'); INSERT INTO `emprunter` VALUES ('20','10','2005-07-15','2005-07-29','2005-07-30'); INSERT INTO `emprunter` VALUES ('20','10','2005-09-23','2005-10-07','2005-10-03'); INSERT INTO `emprunter` VALUES ('20','10','2005-10-04','2005-10-18',NULL); INSERT INTO `emprunter` VALUES ('21','1','2005-06-20','2005-07-04','2005-07-06'); INSERT INTO `emprunter` VALUES ('21','2','2005-07-26','2005-08-09','2005-08-06'); INSERT INTO `emprunter` VALUES ('21','5','2005-08-27','2005-09-10','2005-09-03'); INSERT INTO `emprunter` VALUES ('21','6','2005-08-09','2005-08-23','2005-08-23'); INSERT INTO `emprunter` VALUES ('21','11','2005-05-07','2005-05-21','2005-05-16'); INSERT INTO `emprunter` VALUES ('21','11','2005-07-07','2005-07-21','2005-07-23'); INSERT INTO `emprunter` VALUES ('21','11','2005-09-07','2005-09-21','2005-09-22'); INSERT INTO `emprunter` VALUES ('21','12','2005-06-05','2005-06-19','2005-06-19'); INSERT INTO `emprunter` VALUES ('22','1','2005-05-02','2005-05-16','2005-05-09'); INSERT INTO `emprunter` VALUES ('22','5','2005-08-08','2005-08-22','2005-08-15'); INSERT INTO `emprunter` VALUES ('22','7','2005-09-01','2005-09-15','2005-09-15'); INSERT INTO `emprunter` VALUES ('22','11','2005-05-12','2005-05-26','2005-05-19'); INSERT INTO `emprunter` VALUES ('22','12','2005-09-18','2005-10-02','2005-09-28'); INSERT INTO `emprunter` VALUES ('22','16','2005-08-16','2005-08-30','2005-08-25'); INSERT INTO `emprunter` VALUES ('23','4','2005-09-01','2005-09-15','2005-09-17'); INSERT INTO `emprunter` VALUES ('23','6','2005-07-28','2005-08-11','2005-08-04'); INSERT INTO `emprunter` VALUES ('23','6','2005-08-14','2005-08-28','2005-08-28'); INSERT INTO `emprunter` VALUES ('23','10','2005-07-09','2005-07-23','2005-07-23'); INSERT INTO `emprunter` VALUES ('23','12','2005-05-02','2005-05-16','2005-05-18'); INSERT INTO `emprunter` VALUES ('23','12','2005-05-20','2005-06-03','2005-05-27'); INSERT INTO `emprunter` VALUES ('23','12','2005-09-18','2005-10-02','2005-09-25'); INSERT INTO `emprunter` VALUES ('23','12','2005-10-03','2005-10-17','2005-10-13'); INSERT INTO `emprunter` VALUES ('23','15','2005-06-22','2005-07-06','2005-07-07'); INSERT INTO `emprunter` VALUES ('23','15','2005-07-24','2005-08-07','2005-07-26'); INSERT INTO `emprunter` VALUES ('23','16','2005-06-03','2005-06-17','2005-06-18'); INSERT INTO `emprunter` VALUES ('24','3','2005-10-03','2005-10-17','2005-10-18'); INSERT INTO `emprunter` VALUES ('24','6','2005-05-16','2005-05-30','2005-05-27'); INSERT INTO `emprunter` VALUES ('24','7','2005-05-28','2005-06-11','2005-06-06'); INSERT INTO `emprunter` VALUES ('24','8','2005-06-07','2005-06-21','2005-06-22'); INSERT INTO `emprunter` VALUES ('24','9','2005-08-07','2005-08-21','2005-08-18'); INSERT INTO `emprunter` VALUES ('24','13','2005-07-07','2005-07-21','2005-07-21'); INSERT INTO `emprunter` VALUES ('24','13','2005-08-19','2005-09-02','2005-08-26'); INSERT INTO `emprunter` VALUES ('24','13','2005-09-09','2005-09-23','2005-10-03'); INSERT INTO `emprunter` VALUES ('24','14','2005-07-22','2005-08-05','2005-08-06'); INSERT INTO `emprunter` VALUES ('24','15','2005-08-30','2005-09-13','2005-09-06'); INSERT INTO `emprunter` VALUES ('25','3','2005-06-03','2005-06-17','2005-06-19'); INSERT INTO `emprunter` VALUES ('25','7','2005-05-17','2005-05-31','2005-05-31'); INSERT INTO `emprunter` VALUES ('25','7','2005-06-22','2005-07-06','2005-06-29'); INSERT INTO `emprunter` VALUES ('25','7','2005-07-16','2005-07-30','2005-07-23'); INSERT INTO `emprunter` VALUES ('25','8','2005-07-27','2005-08-10','2005-08-10'); INSERT INTO `emprunter` VALUES ('25','8','2005-09-11','2005-09-25','2005-09-25'); INSERT INTO `emprunter` VALUES ('25','9','2005-08-29','2005-09-12','2005-09-08'); INSERT INTO `emprunter` VALUES ('25','15','2005-08-12','2005-08-26','2005-08-28'); INSERT INTO `emprunter` VALUES ('26','2','2005-05-18','2005-06-01','2005-06-02'); INSERT INTO `emprunter` VALUES ('26','3','2005-06-04','2005-06-18','2005-06-13'); INSERT INTO `emprunter` VALUES ('26','7','2005-07-17','2005-07-31','2005-07-28'); INSERT INTO `emprunter` VALUES ('26','9','2005-06-14','2005-06-28','2005-06-25'); INSERT INTO `emprunter` VALUES ('26','12','2005-08-15','2005-08-29','2005-09-08'); INSERT INTO `emprunter` VALUES ('26','15','2005-07-30','2005-08-13','2005-08-14'); INSERT INTO `emprunter` VALUES ('27','1','2005-05-19','2005-06-02','2005-05-26'); INSERT INTO `emprunter` VALUES ('27','2','2005-05-27','2005-06-10','2005-06-12'); INSERT INTO `emprunter` VALUES ('27','9','2005-06-14','2005-06-28','2005-06-28'); INSERT INTO `emprunter` VALUES ('28','1','2005-05-20','2005-06-03','2005-06-04'); INSERT INTO `emprunter` VALUES ('28','6','2005-06-07','2005-06-21','2005-06-18'); INSERT INTO `emprunter` VALUES ('28','8','2005-06-20','2005-07-04','2005-06-29'); INSERT INTO `emprunter` VALUES ('29','3','2005-06-10','2005-06-24','2005-06-26'); INSERT INTO `emprunter` VALUES ('29','6','2005-05-07','2005-05-21','2005-05-21'); INSERT INTO `emprunter` VALUES ('29','16','2005-05-21','2005-06-04','2005-05-28'); INSERT INTO `emprunter` VALUES ('30','2','2005-07-09','2005-07-23','2005-07-24'); INSERT INTO `emprunter` VALUES ('30','6','2005-05-22',05-06-02'); INSERT INTO `emprunter` VALUES ('30','7','2005-06-12','2005-06-26','2005-07-06'); INSERT INTO `emprunter` VALUES ('31','1','2005-05-22','2005-06-05','2005-05-29'); INSERT INTO `emprunter` VALUES ('31','7','2005-06-03','2005-06-17','2005-06-17'); INSERT INTO `emprunter` VALUES ('31','8','2005-06-19','2005-07-03','2005-06-29'); INSERT INTO `emprunter` VALUES ('31','9','2005-05-04','2005-05-18','2005-05-20'); INSERT INTO `emprunter` VALUES ('32','11','2005-05-21','2005-06-04','2005-06-01'); INSERT INTO `emprunter` VALUES ('32','11','2005-06-22','2005-07-06','2005-07-06'); INSERT INTO `emprunter` VALUES ('32','11','2005-08-04','2005-08-18','2005-08-15'); INSERT INTO `emprunter` VALUES ('32','13','2005-06-03','2005-06-17','2005-06-19'); INSERT INTO `emprunter` VALUES ('32','13','2005-07-08','2005-07-22','2005-07-21'); INSERT INTO `emprunter` VALUES ('32','15','2005-07-24','2005-08-07','2005-07-31'); INSERT INTO `emprunter` VALUES ('32','15','2005-08-15','2005-08-29','2005-08-28'); INSERT INTO `emprunter` VALUES ('32','16','2005-09-01','2005-09-15','2005-09-11'); INSERT INTO `emprunter` VALUES ('33','12','2005-05-03','2005-05-17','2005-05-13'); INSERT INTO `emprunter` VALUES ('33','12','2005-06-18','2005-07-02','2005-06-25'); INSERT INTO `emprunter` VALUES ('33','12','2005-07-06','2005-07-20','2005-07-20'); INSERT INTO `emprunter` VALUES ('33','14','2005-06-07','2005-06-21','2005-06-16'); INSERT INTO `emprunter` VALUES ('33','14','2005-08-29','2005-09-12','2005-09-13'); INSERT INTO `emprunter` VALUES ('33','16','2005-05-15','2005-05-29','2005-05-31'); INSERT INTO `emprunter` VALUES ('33','16','2005-07-24','2005-08-07','2005-08-04'); INSERT INTO `emprunter` VALUES ('34','11','2005-05-07','2005-05-21','2005-05-18'); INSERT INTO `emprunter` VALUES ('34','11','2005-06-22','2005-07-06','2005-07-01'); INSERT INTO `emprunter` VALUES ('34','13','2005-06-03','2005-06-17','2005-06-12'); INSERT INTO `emprunter` VALUES ('34','13','2005-07-24','2005-08-07','2005-08-07'); INSERT INTO `emprunter` VALUES ('34','13','2005-08-09','2005-08-23','2005-08-25'); INSERT INTO `emprunter` VALUES ('34','15','2005-07-08','2005-07-22','2005-07-24'); INSERT INTO `emprunter` VALUES ('34','15','2005-08-29','2005-09-12','2005-09-14'); INSERT INTO `emprunter` VALUES ('35','12','2005-05-02','2005-05-16','2005-05-16'); INSERT INTO `emprunter` VALUES ('35','12','2005-08-11','2005-08-25','2005-09-04'); INSERT INTO `emprunter` VALUES ('35','14','2005-05-27','2005-06-10','2005-06-11'); INSERT INTO `emprunter` VALUES ('35','14','2005-06-27','2005-07-11','2005-07-07'); INSERT INTO `emprunter` VALUES ('35','14','2005-07-09','2005-07-23','2005-07-24'); INSERT INTO `emprunter` VALUES ('35','15','2005-09-16','2005-09-30','2005-10-01'); INSERT INTO `emprunter` VALUES ('35','16','2005-05-19','2005-06-02','2005-05-26'); INSERT INTO `emprunter` VALUES ('35','16','2005-06-12','2005-06-26','2005-06-27'); INSERT INTO `emprunter` VALUES ('35','16','2005-10-03','2005-10-17','2005-10-17'); INSERT INTO `emprunter` VALUES ('36','8','2005-05-13','2005-05-27','2005-05-22'); INSERT INTO `emprunter` VALUES ('36','13','2005-06-02','2005-06-16','2005-06-16'); INSERT INTO `emprunter` VALUES ('36','17','2005-05-12','2005-05-26','2005-05-12'); INSERT INTO `emprunter` VALUES ('36','18','2005-06-18','2005-07-02','2005-07-01'); INSERT INTO `emprunter` VALUES ('37','10','2005-05-22','2005-06-05','2005-06-04'); INSERT INTO `emprunter` VALUES ('37','11','2005-06-06','2005-06-20','2005-06-13'); INSERT INTO `emprunter` VALUES ('37','20','2005-05-10','2005-05-24','2005-05-20'); INSERT INTO `emprunter` VALUES ('38','11','2005-05-19','2005-06-02','2005-06-02'); INSERT INTO `emprunter` VALUES ('38','12','2005-05-07','2005-05-21','2005-05-18'); INSERT INTO `emprunter` VALUES ('38','12','2005-06-03','2005-06-17','2005-06-16'); INSERT INTO `emprunter` VALUES ('39','11','2005-05-20','2005-06-03','2005-06-05'); INSERT INTO `emprunter` VALUES ('39','12','2005-06-06','2005-06-20','2005-06-21'); INSERT INTO `emprunter` VALUES ('39','20','2005-05-10','2005-05-24','2005-05-19'); INSERT INTO `emprunter` VALUES ('40','13','2005-05-21','2005-06-04','2005-06-01'); INSERT INTO `emprunter` VALUES ('40','14','2005-05-19','2005-06-02','2005-05-20'); INSERT INTO `emprunter` VALUES ('40','15','2005-06-18','2005-07-02','2005-06-29'); INSERT INTO `emprunter` VALUES ('40','17','2005-06-02','2005-06-16','2005-06-16'); INSERT INTO `emprunter` VALUES ('41','11','2005-06-03','2005-06-17','2005-06-11'); INSERT INTO `emprunter` VALUES ('41','12','2005-09-09','2005-09-23','2005-09-13'); INSERT INTO `emprunter` VALUES ('41','13','2005-09-14','2005-09-28','2005-09-30'); INSERT INTO `emprunter` VALUES ('41','16','2005-06-20','2005-07-04','2005-07-05'); INSERT INTO `emprunter` VALUES ('41','16','2005-10-01','2005-10-15',NULL); INSERT INTO `emprunter` VALUES ('41','18','2005-08-15','2005-08-29','2005-08-28'); INSERT INTO `emprunter` VALUES ('41','19','2005-08-29','2005-09-12','2005-09-08'); INSERT INTO `emprunter` VALUES ('41','20','2005-07-19','2005-08-02','2005-08-12'); INSERT INTO `emprunter` VALUES ('42','14','2005-05-19','2005-06-02','2005-05-26'); INSERT INTO `emprunter` VALUES ('42','15','2005-08-08','2005-08-22','2005-08-11'); INSERT INTO `emprunter` VALUES ('42','16','2005-06-30','2005-07-14','2005-07-09'); INSERT INTO `emprunter` VALUES ('42','16','2005-07-22','2005-08-05','2005-08-07'); INSERT INTO `emprunter` VALUES ('42','17','2005-07-10','2005-07-24','2005-07-21'); INSERT INTO `emprunter` VALUES ('42','18','2005-08-12','2005-08-26','2005-08-26'); INSERT INTO `emprunter` VALUES ('43','11','2005-09-18','2005-10-02','2005-10-01'); INSERT INTO `emprunter` VALUES ('43','12','2005-10-13','2005-10-27','2005-10-14'); INSERT INTO `emprunter` VALUES ('43','13','2005-06-30','2005-07-14','2005-07-16'); INSERT INTO `emprunter` VALUES ('43','14','2005-10-03','2005-10-17','2005-10-12'); INSERT INTO `emprunter` VALUES ('43','15','2005-08-12','2005-08-26','2005-08-14'); INSERT INTO `emprunter` VALUES ('43','16','2005-08-14','2005-08-28','2005-08-25'); INSERT INTO `emprunter` VALUES ('43','17','2005-10-14','2005-10-28',NULL); INSERT INTO `emprunter` VALUES ('43','19','2005-05-20','2005-06-03','2005-05-31'); INSERT INTO `emprunter` VALUES ('43','20','2005-09-01','2005-09-15','2005-09-15'); INSERT INTO `emprunter` VALUES ('44','11','2005-06-21','2005-07-05','2005-06-28'); INSERT INTO `emprunter` VALUES ('44','12','2005-08-31','2005-09-14','2005-09-15'); INSERT INTO `emprunter` VALUES ('44','13','2005-09-22','2005-10-06','2005-09-27'); INSERT INTO `emprunter` VALUES ('44','14','2005-09-15','2005-09-29','2005-09-20'); INSERT INTO `emprunter` VALUES ('44','15','2005-10-08','2005-10-22',NULL); INSERT INTO `emprunter` VALUES ('44','16','2005-08-12','2005-08-26','2005-08-24'); INSERT INTO `emprunter` VALUES ('44','17','2005-09-28','2005-10-12','2005-10-08'); INSERT INTO `emprunter` VALUES ('44','18','2005-08-02','2005-08-16','2005-08-11'); INSERT INTO `emprunter` VALUES ('44','19','2005-07-04','2005-07-18','2005-07-15'); INSERT INTO `emprunter` VALUES ('44','20','2005-07-16','2005-07-30','2005-08-01'); INSERT INTO `emprunter` VALUES ('45','11','2005-05-12','2005-05-26','2005-05-15'); INSERT INTO `emprunter` VALUES ('45','11','2005-06-11','2005-06-25','2005-06-13'); INSERT INTO `emprunter` VALUES ('45','11','2005-09-18','2005-10-02','2005-09-19'); INSERT INTO `emprunter` VALUES ('45','12','2005-05-18','2005-06-01','2005-05-19'); INSERT INTO `emprunter` VALUES ('45','12','2005-06-16','2005-06-30','2005-06-17'); INSERT INTO `emprunter` VALUES ('45','12','2005-09-24','2005-10-08','2005-09-25'); INSERT INTO `emprunter` VALUES ('45','13','2005-05-20','2005-06-03','2005-05-21'); INSERT INTO `emprunter` VALUES ('45','13','2005-06-19','2005-07-03','2005-06-20'); INSERT INTO `emprunter` VALUES ('45','14','2005-05-21','2005-06-04','2005-05-22'); INSERT INTO `emprunter` VALUES ('45','14','2005-06-21','2005-07-05','2005-06-23'); INSERT INTO `emprunter` VALUES ('45','15','2005-05-24','2005-06-07','2005-05-26'); INSERT INTO `emprunter` VALUES ('45','15','2005-07-30','2005-08-13','2005-07-31'); INSERT INTO `emprunter` VALUES ('45','16','2005-05-02','2005-05-16','2005-05-05'); INSERT INTO `emprunter` VALUES ('45','16','2005-05-07','2005-05-21','2005-05-08'); INSERT INTO `emprunter` VALUES ('45','16','2005-05-27','2005-06-10','2005-05-30'); INSERT INTO `emprunter` VALUES ('45','16','2005-06-04','2005-06-18','2005-06-06'); INSERT INTO `emprunter` VALUES ('45','16','2005-08-05','2005-08-19','2005-08-06'); INSERT INTO `emprunter` VALUES ('45','16','2005-08-10','2005-08-24','2005-08-12'); INSERT INTO `emprunter` VALUES ('45','17','2005-05-23','2005-06-06','2005-05-24'); INSERT INTO `emprunter` VALUES ('45','17','2005-06-26','2005-07-10','2005-06-27'); INSERT INTO `emprunter` VALUES ('45','18','2005-05-06','2005-05-20','2005-05-07'); INSERT INTO `emprunter` VALUES ('45','18','2005-05-30','2005-06-13','2005-06-02'); INSERT INTO `emprunter` VALUES ('45','18','2005-08-07','2005-08-21','2005-08-08'); INSERT INTO `emprunter` VALUES ('45','19','2005-05-10','2005-05-24','2005-05-10'); INSERT INTO `emprunter` VALUES ('45','19','2005-06-07','2005-06-21','2005-06-08'); INSERT INTO `emprunter` VALUES ('45','19','2005-09-14','2005-09-28','2005-09-15'); INSERT INTO `emprunter` VALUES ('45','20','2005-05-10','2005-05-24','2005-05-11'); INSERT INTO `emprunter` VALUES ('45','20','2005-06-09','2005-06-23','2005-06-10'); INSERT INTO `emprunter` VALUES ('45','20','2005-09-16','2005-09-30','2005-09-17'); INSERT INTO `emprunter` VALUES ('46','13','2005-05-10','2005-05-24','2005-05-23'); INSERT INTO `emprunter` VALUES ('46','14','2005-07-12','2005-07-26','2005-07-21'); INSERT INTO `emprunter` VALUES ('46','15','2005-08-05','2005-08-19','2005-08-12'); INSERT INTO `emprunter` VALUES ('46','16','2005-09-13','2005-09-27','2005-09-29'); INSERT INTO `emprunter` VALUES ('46','16','2005-10-09','2005-10-23',NULL); INSERT INTO `emprunter` VALUES ('46','17','2005-07-22','2005-08-05','2005-08-02'); INSERT INTO `emprunter` VALUES ('46','18','2005-10-01','2005-10-15','2005-10-07'); INSERT INTO `emprunter` VALUES ('47','11','2005-08-12','2005-08-26','2005-08-27'); INSERT INTO `emprunter` VALUES ('47','12','2005-08-28','2005-09-11','2005-08-29'); INSERT INTO `emprunter` VALUES ('47','13','2005-06-30','2005-07-14','2005-07-13'); INSERT INTO `emprunter` VALUES ('47','14','2005-07-24','2005-08-07','2005-08-09'); INSERT INTO `emprunter` VALUES ('47','15','2005-10-02','2005-10-16','2005-10-04'); INSERT INTO `emprunter` VALUES ('47','16','2005-09-19','2005-10-03','2005-09-20'); INSERT INTO `emprunter` VALUES ('47','16','2005-09-20','2005-10-04','2005-09-24'); INSERT INTO `emprunter` VALUES ('47','17','2005-08-29','2005-09-12','2005-09-05'); INSERT INTO `emprunter` VALUES ('47','18','2005-09-07','2005-09-21','2005-09-18'); INSERT INTO `emprunter` VALUES ('47','19','2005-06-20','2005-07-04','2005-06-29'); INSERT INTO `emprunter` VALUES ('47','19','2005-09-25','2005-10-09','2005-09-30'); INSERT INTO `emprunter` VALUES ('47','20','2005-07-13','2005-07-27','2005-07-21'); INSERT INTO `emprunter` VALUES ('47','20','2005-10-04','2005-10-18',NULL); INSERT INTO `emprunter` VALUES ('48','17','2005-10-15','2005-10-29',NULL); -- -------------------------------------------------------- -- -- Structure de la table `genre` -- CREATE TABLE `genre` ( `codeGenre` tinyint(4) NOT NULL auto_increment, `nomGenre` varchar(25) NOT NULL default '', PRIMARY KEY (`codeGenre`) ) ENGINE=InnoDB CHARACTER SET latin1 AUTO_INCREMENT=8 ; -- -- Contenu de la table `genre` -- INSERT INTO `genre` VALUES (1, 'Littérature'); INSERT INTO `genre` VALUES (2, 'Terreur'); INSERT INTO `genre` VALUES (3, 'Science-Fiction'); INSERT INTO `genre` VALUES (4, 'BD'); INSERT INTO `genre` VALUES (5, 'Essai'); INSERT INTO `genre` VALUES (6, 'Policier'); INSERT INTO `genre` VALUES (7, 'Roman contemporain'); -- -------------------------------------------------------- -- -- Structure de la table `livre` -- CREATE TABLE `livre` ( `codeLivre` smallint(6) NOT NULL auto_increment, `ISBNLivre` varchar(13) NOT NULL, `titreLivre` varchar(50) NOT NULL default '', `prixLivre` float default NULL, `editeurLivre` varchar(25) default NULL, `anneeLivre` smallint(4) default NULL, `langueLivre` varchar(25) default NULL, `codeAuteurLivre` smallint(6) default NULL, `codeGenreLivre` tinyint(4) default NULL, PRIMARY KEY (`codeLivre`), KEY `codeAuteurLivre` (`codeAuteurLivre`), KEY `codeGenreLivre` (`codeGenreLivre`) ) ENGINE=InnoDB CHARACTER SET latin1 AUTO_INCREMENT=50 ; -- -- Contenu de la table `livre` -- INSERT INTO `livre` VALUES (1,'2-07-038692-6', 'Les fréres Karamazov', 7, 'Folio', 1880, 'Russe', 1, 1); INSERT INTO `livre` VALUES (2,'2-07-036893-9', 'Le Joueur', 5, 'Folio', 1866, 'Russe', 1, 1); INSERT INTO `livre` VALUES (3,'2-07-074049-8', 'L''écriture ou la vie', 15, 'Gallimard', 1994, 'Français', 2, 1); INSERT INTO `livre` VALUES (4,'2-07-036287-6', 'Guerre et Paix', 8, 'Folio', 1869, 'Russe', 3, 1); INSERT INTO `livre` VALUES (5,'2-07-036083-0', 'Les raisins de la colère', 6, 'Folio', 1947, 'Américain', 4, 1); INSERT INTO `livre` VALUES (6,'2-02-018381-1', 'Histoire des colonisations', 20, 'Seuil', 1994, 'Français', 5, 5); INSERT INTO `livre` VALUES (7,'2-266-05366-3', 'Dracula', 6, 'Pocket', 1897, 'Anglais', 6, 2); INSERT INTO `livre` VALUES (8,'2-501-00279-2', 'Frankenstein', 6, 'Marabout', 1818, 'Anglais', 7, 2); INSERT INTO `livre` VALUES (9,'2-277-21197-4', 'Shining', 6, 'J''ai Lu', 1977, 'Américain', 8, 2); INSERT INTO `livre` VALUES (10,'2-8001-1455-X', 'L''évasion des Dalton', 9, 'Dupuis', 1960, 'Français', 19, 4); INSERT INTO `livre` VALUES (11,'2-258-00139-0', 'La Nuit des temps', 6, 'Pocket', 1968, 'Français', 10, 3); INSERT INTO `livre` VALUES (12,'2-253-13862-2', 'Nuit d''été', 6, 'Albin Michel', 1991, 'Français', 11, 2); INSERT INTO `livre` VALUES (13,'2-266-02665-8', 'Dune', 6, 'Pocket', 1965, 'Américain', 12, 3); INSERT INTO `livre` VALUES (14,'2-290-00349-2', '2001 L''odyssée de l''espace', 5, 'J''ai Lu', 1968, 'Anglais', 13, 3); INSERT INTO `livre` VALUES (15,'2-207-30008-0', 'Fahrenheit 451', 5, 'Denoël', 1953, 'Américain', 14, 3); INSERT INTO `livre` VALUES (16,'2-277-21768-9', 'Blade Runner', 5, 'J''ai Lu', 1968, 'Américain', 15, 3); INSERT INTO `livre` VALUES (17,'2-8001-1452-5', 'Les cousins Dalton', 7, 'Dupuis', 1958, 'Français', 19, 4); INSERT INTO `livre` VALUES (18,'2-07-036822-X', '1984', 7, 'Folio', 1948, 'Anglais', 16, 1); INSERT INTO `livre` VALUES (19,'2-07-037093-3', 'Quatrevingt-treize', 6, 'Folio', 1874, 'Français', 17, 1); INSERT INTO `livre` VALUES (20,'2-266-08308-2', 'Les Misérables', 12, 'Folio', 1862, 'Français', 17, 1); INSERT INTO `livre` VALUES (21,'2-07-037001-1', 'Germinal', 7, 'Folio', 1885, 'Français', 18, 1); INSERT INTO `livre` VALUES (22,'2-07-037051-8', 'L''assommoir', 7, 'Folio', 1877, 'Français', 18, 1); INSERT INTO `livre` VALUES (23,'2-8001-1441-X', 'La mine d''or de Dick Digger', 9, 'Dargaud', 1949, 'Français', 19, 4); INSERT INTO `livre` VALUES (24,'2-234-04964-4', 'Lourdes', 15, 'Stock', 1894, 'Français', 18, 1); INSERT INTO `livre` VALUES (25,'2-234-04963-6', 'Paris', 15, 'Stock', 1898, 'Français', 18, 1); INSERT INTO `livre` VALUES (26,'2-8001-1457-6', 'Sur la piste des Dalton', 9, 'Dupuis', 1962, 'Français', 19, 4); INSERT INTO `livre` VALUES (27,'2-8001-1462-2', 'Les Dalton dans le blizzard', 9, 'Dupuis', 1963, 'Français', 19, 4); INSERT INTO `livre` VALUES (28,'2-205-00585-5', 'Ma Dalton', 9, 'Dargaud', 1971, 'Français', 19, 4); INSERT INTO `livre` VALUES (29,'2-234-049652', 'Rome', 15, 'Stock', 1896, 'Français', 18, 1); INSERT INTO `livre` VALUES (30,'2-02-031430-4', 'Le Tambour', 9, 'Seuil', 1959, 'Allemand', 9, 1); INSERT INTO `livre` VALUES (31,'2-8001-1471-1', 'Tortillas pour les Dalton', 9, 'Dupuis', 1967, 'Français', 19, 4); INSERT INTO `livre` VALUES (32,'2-070-30878-2', 'Salammbô', 8, 'Folio', 1862, 'Français', 20, 1); INSERT INTO `livre` VALUES (33,'2-207-30089-7', 'Fondation', 7, 'Denoël', 1951, 'Américain', 21, 3); INSERT INTO `livre` VALUES (34,'2-070-41311-X', 'Madame Bovary', 8, 'Folio', 1857, 'Français', 20, 1); INSERT INTO `livre` VALUES (35,'2-277-12453-2', 'Les robots', 5, 'J''ai Lu', 1950, 'Américain', 21, 3); INSERT INTO `livre` VALUES (36,'2-070-74277-6', 'Notes de Hiroshima', 11, 'Marabout', 1965, 'Japonais', 29, 5); INSERT INTO `livre` VALUES (37,'2-7427-1542-8', 'Etre sans destin', 9, 'Actes Sud', 1975, 'Hongrois', 30, 1); INSERT INTO `livre` VALUES (38,'2-020-23811-X', 'Cent ans de solitude', 6, 'Actes Sud', 1967, 'Espagnol', 31, 1); INSERT INTO `livre` VALUES (39,'2-253-00597-5', 'A l''Est d''Eden', 7, 'Le Livre de Poche', 1952, 'Américain', 4, 1); INSERT INTO `livre` VALUES (40,'2-02-036376-3', 'Le Monde selon Garp', 8, 'Seuil', 1976, 'Américain', 24, 7); INSERT INTO `livre` VALUES (41,'2-253-003313-8', 'Le Nom de la Rose', 6, 'Le Livre de Poche', 1980, 'Italien', 23, 1); INSERT INTO `livre` VALUES (42,'2-7436-1281-9', 'Mystic River', 9, 'Rivages', 2001, 'Américain', 28, 6); INSERT INTO `livre` VALUES (43,'2-070-36042-3', 'La Peste', 5, 'Folio', 1947, 'Français', 26, 1); INSERT INTO `livre` VALUES (44,'2-2531-4087-2', 'L''Ecume des Jours', 8, 'Folio', 1947, 'Français', 27, 7); INSERT INTO `livre` VALUES (45,'2-87827-038-X', 'Sin City', 11, 'Rackham', 1994, 'Américain', 22, 4); INSERT INTO `livre` VALUES (46,'2-203-34411-3', 'La Ballade de la Mer Salée', 14, 'Casterman', 1967, 'Italien', 32, 4); INSERT INTO `livre` VALUES (47,'2-253-06168-9', 'La Méditerranée', 8, 'Le Livre de Poche', 1949, 'Français', 25, 5); INSERT INTO `livre` VALUES (48,'2-08-070611-X', 'Le Dernier des Mohicans', 7, 'Marabout', 1826, 'Américain', 33, 1); INSERT INTO `livre` VALUES (49,'2-277-11830-3', 'Avant l''Eden', 6, 'J''ai Lu', 1974, 'Anglais', 13, 3); -- -- Contraintes pour les tables exportées -- -- -- Contraintes pour la table `emprunter` -- ALTER TABLE `emprunter` ADD CONSTRAINT `emprunter_ibfk_1` FOREIGN KEY (`codeLivreEmprunte`) REFERENCES `livre` (`codeLivre`), ADD CONSTRAINT `emprunter_ibfk_2` FOREIGN KEY (`codeAdherent`) REFERENCES `adherent` (`codeAdh`); -- -- Contraintes pour la table `livre` -- ALTER TABLE `livre` ADD CONSTRAINT `livre_ibfk_2` FOREIGN KEY (`codeGenreLivre`) REFERENCES `genre` (`codeGenre`), ADD CONSTRAINT `livre_ibfk_1` FOREIGN KEY (`codeAuteurLivre`) REFERENCES `auteur` (`codeAuteur`); '15','2005-09-19','2005-10-03','2005-09-21');