--
-- Base de données: `bibliotheque`
--

create database biblio;
use biblio;
-- --------------------------------------------------------

--
-- Structure de la table `adherent`
--

CREATE TABLE IF NOT EXISTS `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  DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;

--
-- Contenu de la table `adherent`
--

INSERT INTO `adherent` (`CodeAdh`, `NomAdh`, `PrenomAdh`, `AdrRueAdh`, `AdrCPAdh`, `AdrVilleAdh`, `TelAdh`, `MelAdh`) VALUES
(1, 'Deltour', 'Charles', '4 rue du Pont', 95100, 'Argenteuil', '01...', 'cdeltour@hotmail.com'),
(2, 'Fime', 'Nadia', '5 rue du Montparnasse', 75006, 'Paris', '06...', NULL),
(3, 'Ertau', 'Frank', '4 Avenue du président Wilson', 94320, 'Cachan', '01...', 'frank.ertau@laposte.net'),
(4, 'Maneur', 'David', '6 rue Charles Péguy', 94000, 'Créteil', '01...', NULL),
(5, 'Berezovski', 'Sylvie', '18 rue du Château', 91150, 'Etampes', '01...', NULL),
(6, 'Finley', 'Pascale', '25 rue de Tolbiac', 75013, 'Paris', '01...', 'pascfinley@yahoo.fr'),
(7, 'Vofur', 'Hector', '18 rue Deparcieux', 75014, 'Paris', '01...', 'hvofur@free.fr'),
(8, 'Derzou', 'Fred', '230 avenue de la liberté', 93100, 'Montreuil-sous-bois', '01...', 'ouzala@aol.com'),
(9, 'Serty', 'Julie', '23 rue du Calvaire', 92800, 'Suresnes', '01...', NULL),
(10, 'Vofur', 'Victor', '18 rue Deparcieux', 75014, 'Paris', '01...', 'victor.vofur@laposte.net'),
(11, 'Calende', 'Hugo', '22 rue des jardins', 91000, 'Evry', '01...', NULL),
(12, 'Jemba', 'Hubert', '10 rue du 8 mai 1945', 78000, 'Versailles', '01...', 'jaimeba@yahoo.fr'),
(13, 'Morin', 'Séverine', '4 rue du bac', 93000, 'Saint Denis', '01...', 'morinsev@hotmail.com'),
(14, 'Benrech', 'Tarek', '79 rue de Sèvres', 95000, 'Nanterre', '01...', NULL),
(15, 'Nguyen', 'Marc', '53 impasse Tourneur', 91400, 'Orsay', '01...', 'nguyen774@wanadoo.fr'),
(16, 'Louali', 'Karima', '89 avenue Poincaré', 75001, 'Paris', '01...', 'kloua@caramail.fr'),
(17, 'Paolo', 'Marco', '14 rue du Caire', 91300, 'Massy', '01...', NULL),
(18, 'Map', 'Joanna', '120 boulevard Voltaire', 75012, 'Paris', '01...', NULL),
(19, 'Koundé', 'Fatoumata', '4 Place Carrée', 77000, 'Melun', '01...', NULL),
(20, 'Derissam', 'Bachir', '1 rue des Indes', 78550, 'Houdan', '01...', NULL);

-- --------------------------------------------------------

--
-- Structure de la table `auteur`
--

CREATE TABLE IF NOT EXISTS `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  DEFAULT CHARSET=latin1 AUTO_INCREMENT=34 ;

--
-- Contenu de la table `auteur`
--

INSERT INTO `auteur` (`CodeAuteur`, `NomAuteur`, `PrenomAuteur`, `NationaliteAuteur`) VALUES
(1, 'Dostoeïvski', 'Fédor', 'Russe'),
(2, 'Semprun', 'Jorge', 'Espagnole'),
(3, 'Tolstoï', 'Leon', 'Russe'),
(4, 'Steinbeck', 'John', 'Américaine'),
(5, 'Ferro', 'Marc', 'Française'),
(6, 'Stocker', 'Bram', 'Irlandaise'),
(7, 'Shelley', 'Marie', 'Britannique'),
(8, 'King', 'Stephen', 'Américaine'),
(9, 'Grass', 'Gunter', 'Allemande'),
(10, 'Barjavel', 'René', 'Française'),
(11, 'Simmons', 'Dan', 'Américaine'),
(12, 'Herbert', 'Frank', 'Américaine'),
(13, 'Clarke', 'Arthur C.', 'Britannique'),
(14, 'Bradbury', 'Ray', 'Américaine'),
(15, 'Dick', 'Philip K.', 'Américaine'),
(16, 'Orwell', 'Georges', 'Britannique'),
(17, 'Hugo', 'Victor', 'Française'),
(18, 'Zola', 'Emile', 'Française'),
(19, 'Morris', NULL, 'Belge'),
(20, 'Flaubert', 'Gustave', 'Française'),
(21, 'Asimov', 'Isaac', 'Américaine'),
(22, 'Miller', 'Frank', 'Américaine'),
(23, 'Eco', 'Umberto', 'Italienne'),
(24, 'Irving', 'John', 'Américaine'),
(25, 'Braudel', 'Fernand', 'Française'),
(26, 'Camus', 'Albert', 'Française'),
(27, 'Vian', 'Boris', 'Française'),
(28, 'Lehane', 'Dennis', 'Américaine'),
(29, 'Oe', 'Kenzaburo', 'Japonaise'),
(30, 'Kertesz', 'Imre', 'Hongrois'),
(31, 'Garcia Marquez', 'Gabriel', 'Colombien'),
(32, 'Pratt', 'Hugo', 'Italienne'),
(33, 'Cooper', 'Fenimore', 'Américaine');

-- --------------------------------------------------------

--
-- Structure de la table `emprunter`
--

CREATE TABLE IF NOT EXISTS `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 DEFAULT CHARSET=latin1;

--
-- Contenu de la table `emprunter`
--

INSERT INTO `emprunter` (`CodeLivreEmprunte`, `CodeAdherent`, `DateEmprunt`, `DateRetourPrevue`, `DateRetourReelle`) VALUES
(1, 1, '2013-12-31', '2014-01-14', '2014-01-14'),
(1, 2, '2013-11-30', '2013-12-14', '2013-12-10'),
(1, 3, '2013-12-11', '2013-12-25', '2013-12-20'),
(1, 14, '2014-01-16', '2014-01-30', '2014-01-29'),
(2, 5, '2013-12-20', '2014-01-03', '2014-01-02'),
(2, 6, '2014-01-04', '2014-01-18', '2014-01-11'),
(2, 14, '2013-12-02', '2013-12-16', '2013-12-18'),
(3, 6, '2013-12-05', '2013-12-19', '2013-12-16'),
(3, 7, '2013-12-17', '2013-12-31', '2013-12-31'),
(3, 8, '2014-01-01', '2014-01-15', '2014-01-14'),
(4, 9, '2013-12-08', '2013-12-22', '2013-12-17'),
(4, 10, '2013-12-18', '2014-01-01', '2014-01-03'),
(4, 11, '2014-01-04', '2014-01-18', '2014-01-19'),
(5, 4, '2013-12-19', '2014-01-02', '2013-12-30'),
(5, 5, '2013-12-11', '2013-12-25', '2013-12-18'),
(5, 8, '2013-12-31', '2014-01-14', '2014-01-14'),
(5, 14, '2014-01-16', '2014-01-30', '2014-01-27'),
(6, 2, '2014-01-18', '2014-02-01', '2014-02-02'),
(6, 4, '2014-03-15', '2014-03-29', '2014-03-28'),
(6, 6, '2014-02-04', '2014-02-18', '2014-02-15'),
(6, 7, '2013-12-14', '2013-12-28', '2013-12-23'),
(6, 8, '2014-02-16', '2014-03-02', '2014-03-12'),
(6, 9, '2013-12-24', '2014-01-07', '2014-01-09'),
(6, 16, '2014-03-29', '2014-04-12', '2014-04-13'),
(6, 16, '2014-04-14', '2014-04-28', '2014-04-30'),
(7, 3, '2013-12-17', '2013-12-31', '2013-12-24'),
(7, 3, '2014-02-07', '2014-02-21', '2014-02-18'),
(7, 6, '2013-12-25', '2014-01-08', '2014-01-08'),
(7, 7, '2014-02-19', '2014-03-05', '2014-03-07'),
(7, 9, '2014-01-13', '2014-01-27', '2014-01-23'),
(7, 13, '2014-01-28', '2014-02-11', '2014-02-06'),
(8, 4, '2013-12-18', '2014-01-01', '2013-12-29'),
(8, 6, '2014-04-01', '2014-04-15', '2014-04-15'),
(8, 6, '2014-04-18', '2014-05-02', '2014-05-01'),
(8, 7, '2014-01-01', '2014-01-15', '2014-01-25'),
(8, 8, '2014-01-28', '2014-02-11', '2014-02-13'),
(8, 8, '2014-05-03', '2014-05-17', '2014-05-12'),
(8, 10, '2014-03-05', '2014-03-19', '2014-03-12'),
(8, 16, '2014-02-16', '2014-03-02', '2014-03-03'),
(8, 16, '2014-03-14', '2014-03-28', '2014-03-25'),
(9, 7, '2014-03-02', '2014-03-16', '2014-03-11'),
(9, 8, '2014-01-04', '2014-01-18', '2014-01-19'),
(9, 8, '2014-02-01', '2014-02-15', '2014-02-12'),
(9, 10, '2013-12-18', '2014-01-01', '2014-01-03'),
(9, 11, '2014-01-19', '2014-02-02', '2014-01-26'),
(9, 11, '2014-03-31', '2014-04-14', '2014-04-15'),
(9, 12, '2014-03-13', '2014-03-27', '2014-03-29'),
(9, 12, '2014-04-15', '2014-04-29', '2014-04-26'),
(9, 12, '2014-05-01', '2014-05-15', NULL),
(9, 15, '2014-02-13', '2014-02-27', '2014-02-27'),
(10, 1, '2013-11-30', '2013-12-14', '2013-12-03'),
(10, 1, '2013-12-03', '2013-12-17', '2013-12-04'),
(10, 1, '2013-12-04', '2013-12-18', '2013-12-05'),
(10, 1, '2013-12-05', '2013-12-19', '2013-12-06'),
(10, 1, '2013-12-06', '2013-12-20', '2013-12-08'),
(10, 1, '2013-12-08', '2013-12-22', '2013-12-08'),
(10, 2, '2013-12-08', '2013-12-22', '2013-12-09'),
(10, 2, '2013-12-09', '2013-12-23', '2013-12-10'),
(10, 2, '2013-12-10', '2013-12-24', '2013-12-13'),
(10, 2, '2013-12-13', '2013-12-27', '2013-12-16'),
(10, 2, '2013-12-16', '2013-12-30', '2013-12-17'),
(10, 2, '2013-12-17', '2013-12-31', '2013-12-18'),
(10, 2, '2013-12-18', '2014-01-01', '2013-12-19'),
(10, 2, '2013-12-19', '2014-01-02', '2013-12-20'),
(10, 2, '2013-12-20', '2014-01-03', '2013-12-21'),
(10, 2, '2013-12-21', '2014-01-04', '2013-12-22'),
(10, 2, '2013-12-22', '2014-01-05', '2013-12-24'),
(10, 2, '2013-12-24', '2014-01-07', '2013-12-25'),
(10, 2, '2013-12-25', '2014-01-08', '2013-12-28'),
(10, 3, '2013-12-28', '2014-01-11', '2013-12-28'),
(10, 4, '2013-12-28', '2014-01-11', '2013-12-31'),
(10, 4, '2013-12-31', '2014-01-14', '2014-01-02'),
(10, 4, '2014-01-02', '2014-01-16', '2014-01-04'),
(10, 4, '2014-01-04', '2014-01-18', '2014-01-05'),
(10, 4, '2014-01-05', '2014-01-19', '2014-01-06'),
(10, 4, '2014-01-06', '2014-01-20', '2014-01-07'),
(10, 5, '2014-01-07', '2014-01-21', '2014-01-08'),
(10, 5, '2014-01-08', '2014-01-22', '2014-01-09'),
(10, 5, '2014-01-09', '2014-01-23', '2014-01-11'),
(10, 5, '2014-01-11', '2014-01-25', '2014-01-14'),
(10, 6, '2014-01-14', '2014-01-28', '2014-01-15'),
(10, 6, '2014-01-15', '2014-01-29', '2014-01-16'),
(10, 6, '2014-01-16', '2014-01-30', '2014-01-17'),
(10, 6, '2014-01-17', '2014-01-31', '2014-01-18'),
(10, 7, '2014-01-18', '2014-02-01', '2014-01-19'),
(10, 7, '2014-01-19', '2014-02-02', '2014-01-21'),
(10, 7, '2014-01-21', '2014-02-04', '2014-01-24'),
(10, 7, '2014-01-24', '2014-02-07', '2014-01-25'),
(10, 7, '2014-01-25', '2014-02-08', '2014-01-26'),
(10, 7, '2014-01-26', '2014-02-09', '2014-01-27'),
(10, 7, '2014-01-27', '2014-02-10', '2014-01-28'),
(10, 7, '2014-01-28', '2014-02-11', '2014-01-29'),
(10, 7, '2014-01-29', '2014-02-12', '2014-01-31'),
(10, 8, '2014-01-31', '2014-02-14', '2014-02-03'),
(10, 8, '2014-02-03', '2014-02-17', '2014-02-04'),
(10, 8, '2014-02-04', '2014-02-18', '2014-02-05'),
(10, 8, '2014-02-05', '2014-02-19', '2014-02-06'),
(10, 8, '2014-02-06', '2014-02-20', '2014-02-07'),
(10, 8, '2014-02-07', '2014-02-21', '2014-02-08'),
(10, 8, '2014-02-08', '2014-02-22', '2014-02-10'),
(10, 8, '2014-02-10', '2014-02-24', '2014-02-13'),
(10, 8, '2014-02-13', '2014-02-27', '2014-02-14'),
(10, 8, '2014-02-14', '2014-02-28', '2014-02-15'),
(10, 9, '2014-02-15', '2014-03-01', '2014-02-16'),
(10, 9, '2014-02-16', '2014-03-02', '2014-02-17'),
(10, 9, '2014-02-17', '2014-03-03', '2014-02-18'),
(10, 9, '2014-02-18', '2014-03-04', '2014-02-20'),
(10, 9, '2014-02-20', '2014-03-06', '2014-02-23'),
(10, 9, '2014-02-23', '2014-03-09', '2014-02-24'),
(10, 10, '2014-02-24', '2014-03-10', '2014-02-25'),
(10, 10, '2014-02-25', '2014-03-11', '2014-02-26'),
(10, 10, '2014-02-26', '2014-03-12', '2014-02-27'),
(10, 10, '2014-02-27', '2014-03-13', '2014-02-28'),
(10, 10, '2014-02-28', '2014-03-14', '2014-03-02'),
(10, 10, '2014-03-02', '2014-03-16', '2014-03-05'),
(10, 10, '2014-03-05', '2014-03-19', '2014-03-06'),
(10, 11, '2014-03-06', '2014-03-20', '2014-03-07'),
(10, 11, '2014-03-07', '2014-03-21', '2014-03-08'),
(10, 11, '2014-03-08', '2014-03-22', '2014-03-09'),
(10, 11, '2014-03-09', '2014-03-23', '2014-03-10'),
(10, 11, '2014-03-10', '2014-03-24', '2014-03-12'),
(10, 12, '2014-03-12', '2014-03-26', '2014-03-15'),
(10, 12, '2014-03-15', '2014-03-29', '2014-03-16'),
(10, 12, '2014-03-16', '2014-03-30', '2014-03-17'),
(10, 12, '2014-03-17', '2014-03-31', '2014-03-18'),
(10, 12, '2014-03-18', '2014-04-01', '2014-03-19'),
(10, 12, '2014-03-19', '2014-04-02', '2014-03-20'),
(10, 12, '2014-03-20', '2014-04-03', '2014-03-22'),
(10, 13, '2014-03-22', '2014-04-05', '2014-03-25'),
(10, 13, '2014-03-25', '2014-04-08', '2014-03-26'),
(10, 13, '2014-03-26', '2014-04-09', '2014-03-27'),
(10, 13, '2014-03-27', '2014-04-10', '2014-03-28'),
(10, 13, '2014-03-28', '2014-04-11', '2014-03-29'),
(10, 13, '2014-03-29', '2014-04-12', '2014-03-30'),
(10, 14, '2014-03-30', '2014-04-13', '2014-04-01'),
(10, 14, '2014-04-01', '2014-04-15', '2014-04-04'),
(10, 14, '2014-04-04', '2014-04-18', '2014-04-05'),
(10, 14, '2014-04-05', '2014-04-19', '2014-04-06'),
(10, 14, '2014-04-06', '2014-04-20', '2014-04-07'),
(10, 14, '2014-04-07', '2014-04-21', '2014-04-08'),
(10, 14, '2014-04-08', '2014-04-22', '2014-04-09'),
(10, 14, '2014-04-09', '2014-04-23', '2014-04-11'),
(10, 14, '2014-04-11', '2014-04-25', '2014-04-14'),
(10, 14, '2014-04-14', '2014-04-28', '2014-04-15'),
(10, 14, '2014-04-15', '2014-04-29', '2014-04-16'),
(10, 14, '2014-04-16', '2014-04-30', '2014-04-17'),
(10, 15, '2014-04-17', '2014-05-01', '2014-04-18'),
(10, 15, '2014-04-18', '2014-05-02', '2014-04-19'),
(10, 15, '2014-04-19', '2014-05-03', '2014-04-21'),
(10, 15, '2014-04-21', '2014-05-05', '2014-04-24'),
(10, 15, '2014-04-24', '2014-05-08', '2014-04-25'),
(10, 15, '2014-04-25', '2014-05-09', '2014-04-26'),
(10, 15, '2014-04-26', '2014-05-10', '2014-04-27'),
(10, 15, '2014-04-27', '2014-05-11', '2014-04-28'),
(11, 1, '2013-12-08', '2013-12-22', '2013-12-21'),
(11, 4, '2014-02-09', '2014-02-23', '2014-02-18'),
(11, 4, '2014-02-19', '2014-03-05', '2014-03-02'),
(11, 5, '2014-03-05', '2014-03-19', '2014-03-12'),
(11, 9, '2014-04-13', '2014-04-27', '2014-04-29'),
(11, 12, '2014-01-31', '2014-02-14', '2014-02-07'),
(11, 14, '2014-05-03', '2014-05-17', '2014-05-07'),
(12, 3, '2014-01-18', '2014-02-01', '2014-01-27'),
(12, 3, '2014-01-31', '2014-02-14', '2014-02-09'),
(12, 4, '2014-03-12', '2014-03-26', '2014-03-27'),
(12, 6, '2014-01-08', '2014-01-22', '2014-01-17'),
(12, 8, '2013-12-02', '2013-12-16', '2013-12-11'),
(12, 8, '2014-02-21', '2014-03-07', '2014-03-09'),
(12, 8, '2014-03-29', '2014-04-12', '2014-04-05'),
(12, 10, '2013-12-23', '2014-01-06', '2014-01-07'),
(12, 11, '2013-12-12', '2013-12-26', '2013-12-22'),
(12, 11, '2014-04-07', '2014-04-21', '2014-04-18'),
(12, 12, '2014-02-09', '2014-02-23', '2014-02-20'),
(12, 12, '2014-04-20', '2014-05-04', '2014-04-30'),
(12, 12, '2014-05-04', '2014-05-18', NULL),
(13, 5, '2014-01-23', '2014-02-06', '2014-02-06'),
(13, 5, '2014-04-03', '2014-04-17', '2014-04-10'),
(13, 6, '2014-03-29', '2014-04-12', '2014-04-01'),
(13, 7, '2014-02-07', '2014-02-21', '2014-02-22'),
(13, 8, '2013-12-02', '2013-12-16', '2013-12-18'),
(13, 8, '2014-03-05', '2014-03-19', '2014-03-20'),
(13, 8, '2014-03-21', '2014-04-04', '2014-03-28'),
(13, 10, '2014-01-03', '2014-01-17', '2014-01-10'),
(13, 13, '2013-12-19', '2014-01-02', '2014-01-02'),
(13, 13, '2014-01-11', '2014-01-25', '2014-01-22'),
(13, 13, '2014-02-23', '2014-03-09', '2014-03-05'),
(14, 1, '2014-01-11', '2014-01-25', '2014-01-22'),
(14, 3, '2014-02-23', '2014-03-09', '2014-03-05'),
(14, 4, '2014-01-23', '2014-02-06', '2014-02-06'),
(14, 4, '2014-05-04', '2014-05-18', NULL),
(14, 7, '2014-01-03', '2014-01-17', '2014-01-10'),
(14, 8, '2014-03-05', '2014-03-19', '2014-03-20'),
(14, 8, '2014-04-07', '2014-04-21', '2014-04-18'),
(14, 9, '2014-02-07', '2014-02-21', '2014-02-22'),
(14, 13, '2013-12-19', '2014-01-02', '2014-01-02'),
(14, 13, '2014-04-20', '2014-05-04', '2014-04-30'),
(15, 2, '2014-04-07', '2014-04-21', '2014-04-21'),
(15, 3, '2014-04-23', '2014-05-07', '2014-04-30'),
(15, 6, '2013-12-20', '2014-01-03', '2014-01-03'),
(15, 6, '2014-01-15', '2014-01-29', '2014-01-24'),
(15, 8, '2014-01-26', '2014-02-09', '2014-02-10'),
(15, 9, '2014-02-12', '2014-02-26', '2014-02-28'),
(15, 9, '2014-03-24', '2014-04-07', '2014-04-04'),
(15, 10, '2014-05-04', '2014-05-18', NULL),
(15, 13, '2014-01-04', '2014-01-18', '2014-01-11'),
(15, 13, '2014-03-04', '2014-03-18', '2014-03-20'),
(16, 2, '2013-12-05', '2013-12-19', '2013-12-16'),
(16, 5, '2014-01-03', '2014-01-17', '2014-01-10'),
(16, 6, '2014-01-11', '2014-01-25', '2014-01-22'),
(16, 7, '2014-04-07', '2014-04-21', '2014-04-18'),
(16, 8, '2014-02-23', '2014-03-09', '2014-03-05'),
(16, 10, '2014-01-23', '2014-02-06', '2014-02-06'),
(16, 10, '2014-02-07', '2014-02-21', '2014-02-22'),
(16, 14, '2014-03-05', '2014-03-19', '2014-03-20'),
(16, 15, '2014-04-20', '2014-05-04', '2014-04-30'),
(16, 15, '2014-05-04', '2014-05-18', NULL),
(17, 1, '2014-04-07', '2014-04-21', '2014-04-21'),
(17, 7, '2014-05-15', '2014-05-29', NULL),
(17, 9, '2013-12-20', '2014-01-03', '2014-01-03'),
(17, 9, '2014-03-04', '2014-03-18', '2014-03-20'),
(17, 10, '2014-01-15', '2014-01-29', '2014-01-24'),
(17, 10, '2014-01-26', '2014-02-09', '2014-02-10'),
(17, 10, '2014-03-24', '2014-04-07', '2014-04-04'),
(17, 11, '2014-01-04', '2014-01-18', '2014-01-11'),
(17, 11, '2014-04-23', '2014-05-07', '2014-04-30'),
(17, 12, '2014-02-12', '2014-02-26', '2014-02-28'),
(18, 5, '2014-01-10', '2014-01-24', '2014-01-24'),
(18, 6, '2014-04-18', '2014-05-02', '2014-04-28'),
(18, 7, '2014-05-03', '2014-05-17', '2014-05-19'),
(18, 8, '2014-01-01', '2014-01-15', '2014-01-10'),
(18, 8, '2014-03-08', '2014-03-22', '2014-03-15'),
(18, 9, '2014-02-25', '2014-03-11', '2014-03-06'),
(18, 9, '2014-04-01', '2014-04-15', '2014-04-15'),
(18, 10, '2014-02-10', '2014-02-24', '2014-02-24'),
(18, 11, '2013-12-18', '2014-01-01', '2014-01-01'),
(18, 13, '2014-01-25', '2014-02-08', '2014-02-01'),
(18, 15, '2014-02-02', '2014-02-16', '2014-02-09'),
(18, 15, '2014-03-16', '2014-03-30', '2014-03-25'),
(19, 2, '2014-02-12', '2014-02-26', '2014-02-28'),
(19, 3, '2013-12-21', '2014-01-04', '2014-01-06'),
(19, 8, '2014-04-23', '2014-05-07', '2014-04-30'),
(19, 9, '2014-03-04', '2014-03-18', '2014-03-20'),
(19, 9, '2014-03-24', '2014-04-07', '2014-04-04'),
(19, 10, '2013-12-11', '2013-12-25', '2013-12-18'),
(19, 12, '2014-04-07', '2014-04-21', '2014-04-21'),
(19, 16, '2014-01-11', '2014-01-25', '2014-01-22'),
(19, 16, '2014-05-04', '2014-05-18', NULL),
(20, 1, '2014-01-04', '2014-01-18', '2014-01-13'),
(20, 6, '2014-03-04', '2014-03-18', '2014-03-14'),
(20, 7, '2014-03-24', '2014-04-07', '2014-04-08'),
(20, 8, '2014-01-15', '2014-01-29', '2014-01-29'),
(20, 10, '2013-12-20', '2014-01-03', '2013-12-27'),
(20, 10, '2014-02-12', '2014-02-26', '2014-02-27'),
(20, 10, '2014-04-23', '2014-05-07', '2014-05-03'),
(20, 10, '2014-05-04', '2014-05-18', NULL),
(21, 1, '2014-01-18', '2014-02-01', '2014-02-03'),
(21, 2, '2014-02-23', '2014-03-09', '2014-03-06'),
(21, 5, '2014-03-27', '2014-04-10', '2014-04-03'),
(21, 6, '2014-03-09', '2014-03-23', '2014-03-23'),
(21, 11, '2013-12-05', '2013-12-19', '2013-12-14'),
(21, 11, '2014-02-04', '2014-02-18', '2014-02-20'),
(21, 11, '2014-04-07', '2014-04-21', '2014-04-22'),
(21, 12, '2014-01-03', '2014-01-17', '2014-01-17'),
(22, 1, '2013-11-30', '2013-12-14', '2013-12-07'),
(22, 5, '2014-03-08', '2014-03-22', '2014-03-15'),
(22, 7, '2014-04-01', '2014-04-15', '2014-04-15'),
(22, 11, '2013-12-10', '2013-12-24', '2013-12-17'),
(22, 12, '2014-04-18', '2014-05-02', '2014-04-28'),
(22, 16, '2014-03-16', '2014-03-30', '2014-03-25'),
(23, 4, '2014-04-01', '2014-04-15', '2014-04-17'),
(23, 6, '2014-02-25', '2014-03-11', '2014-03-04'),
(23, 6, '2014-03-14', '2014-03-28', '2014-03-28'),
(23, 10, '2014-02-06', '2014-02-20', '2014-02-20'),
(23, 12, '2013-11-30', '2013-12-14', '2013-12-16'),
(23, 12, '2013-12-18', '2014-01-01', '2013-12-25'),
(23, 12, '2014-04-18', '2014-05-02', '2014-04-25'),
(23, 12, '2014-05-03', '2014-05-17', '2014-05-13'),
(23, 15, '2014-01-20', '2014-02-03', '2014-02-04'),
(23, 15, '2014-02-21', '2014-03-07', '2014-02-23'),
(23, 16, '2014-01-01', '2014-01-15', '2014-01-16'),
(24, 3, '2014-05-03', '2014-05-17', '2014-05-18'),
(24, 6, '2013-12-14', '2013-12-28', '2013-12-25'),
(24, 7, '2013-12-26', '2014-01-09', '2014-01-04'),
(24, 8, '2014-01-05', '2014-01-19', '2014-01-20'),
(24, 9, '2014-03-07', '2014-03-21', '2014-03-18'),
(24, 13, '2014-02-04', '2014-02-18', '2014-02-18'),
(24, 13, '2014-03-19', '2014-04-02', '2014-03-26'),
(24, 13, '2014-04-09', '2014-04-23', '2014-05-03'),
(24, 14, '2014-02-19', '2014-03-05', '2014-03-06'),
(24, 15, '2014-03-30', '2014-04-13', '2014-04-06'),
(25, 3, '2014-01-01', '2014-01-15', '2014-01-17'),
(25, 7, '2013-12-15', '2013-12-29', '2013-12-29'),
(25, 7, '2014-01-20', '2014-02-03', '2014-01-27'),
(25, 7, '2014-02-13', '2014-02-27', '2014-02-20'),
(25, 8, '2014-02-24', '2014-03-10', '2014-03-10'),
(25, 8, '2014-04-11', '2014-04-25', '2014-04-25'),
(25, 9, '2014-03-29', '2014-04-12', '2014-04-08'),
(25, 15, '2014-03-12', '2014-03-26', '2014-03-28'),
(26, 2, '2013-12-16', '2013-12-30', '2013-12-31'),
(26, 3, '2014-01-02', '2014-01-16', '2014-01-11'),
(26, 7, '2014-02-14', '2014-02-28', '2014-02-25'),
(26, 9, '2014-01-12', '2014-01-26', '2014-01-23'),
(26, 12, '2014-03-15', '2014-03-29', '2014-04-08'),
(26, 15, '2014-02-27', '2014-03-13', '2014-03-14'),
(27, 1, '2013-12-17', '2013-12-31', '2013-12-24'),
(27, 2, '2013-12-25', '2014-01-08', '2014-01-10'),
(27, 9, '2014-01-12', '2014-01-26', '2014-01-26'),
(28, 1, '2013-12-18', '2014-01-01', '2014-01-02'),
(28, 6, '2014-01-05', '2014-01-19', '2014-01-16'),
(28, 8, '2014-01-18', '2014-02-01', '2014-01-27'),
(29, 3, '2014-01-08', '2014-01-22', '2014-01-24'),
(29, 6, '2013-12-05', '2013-12-19', '2013-12-19'),
(29, 16, '2013-12-19', '2014-01-02', '2013-12-26'),
(30, 2, '2014-02-06', '2014-02-20', '2014-02-21'),
(30, 6, '2013-12-20', '2014-01-03', '2013-12-31'),
(30, 7, '2014-01-10', '2014-01-24', '2014-02-03'),
(31, 1, '2013-12-20', '2014-01-03', '2013-12-27'),
(31, 7, '2014-01-01', '2014-01-15', '2014-01-15'),
(31, 8, '2014-01-17', '2014-01-31', '2014-01-27'),
(31, 9, '2013-12-02', '2013-12-16', '2013-12-18'),
(32, 11, '2013-12-19', '2014-01-02', '2013-12-30'),
(32, 11, '2014-01-20', '2014-02-03', '2014-02-03'),
(32, 11, '2014-03-04', '2014-03-18', '2014-03-15'),
(32, 13, '2014-01-01', '2014-01-15', '2014-01-17'),
(32, 13, '2014-02-05', '2014-02-19', '2014-02-18'),
(32, 15, '2014-02-21', '2014-03-07', '2014-02-28'),
(32, 15, '2014-03-15', '2014-03-29', '2014-03-28'),
(32, 16, '2014-04-01', '2014-04-15', '2014-04-11'),
(33, 12, '2013-12-01', '2013-12-15', '2013-12-11'),
(33, 12, '2014-01-16', '2014-01-30', '2014-01-23'),
(33, 12, '2014-02-03', '2014-02-17', '2014-02-17'),
(33, 14, '2014-01-05', '2014-01-19', '2014-01-14'),
(33, 14, '2014-03-29', '2014-04-12', '2014-04-13'),
(33, 16, '2013-12-13', '2013-12-27', '2013-12-29'),
(33, 16, '2014-02-21', '2014-03-07', '2014-03-04'),
(34, 11, '2013-12-05', '2013-12-19', '2013-12-16'),
(34, 11, '2014-01-20', '2014-02-03', '2014-01-29'),
(34, 13, '2014-01-01', '2014-01-15', '2014-01-10'),
(34, 13, '2014-02-21', '2014-03-07', '2014-03-07'),
(34, 13, '2014-03-09', '2014-03-23', '2014-03-25'),
(34, 15, '2014-02-05', '2014-02-19', '2014-02-21'),
(34, 15, '2014-03-29', '2014-04-12', '2014-04-14'),
(35, 12, '2013-11-30', '2013-12-14', '2013-12-14'),
(35, 12, '2014-03-11', '2014-03-25', '2014-04-04'),
(35, 14, '2013-12-25', '2014-01-08', '2014-01-09'),
(35, 14, '2014-01-25', '2014-02-08', '2014-02-04'),
(35, 14, '2014-02-06', '2014-02-20', '2014-02-21'),
(35, 15, '2014-04-16', '2014-04-30', '2014-05-01'),
(35, 16, '2013-12-17', '2013-12-31', '2013-12-24'),
(35, 16, '2014-01-10', '2014-01-24', '2014-01-25'),
(35, 16, '2014-05-03', '2014-05-17', '2014-05-17'),
(36, 8, '2013-12-11', '2013-12-25', '2013-12-20'),
(36, 13, '2013-12-31', '2014-01-14', '2014-01-14'),
(36, 17, '2013-12-10', '2013-12-24', '2013-12-10'),
(36, 18, '2014-01-16', '2014-01-30', '2014-01-29'),
(37, 10, '2013-12-20', '2014-01-03', '2014-01-02'),
(37, 11, '2014-01-04', '2014-01-18', '2014-01-11'),
(37, 20, '2013-12-08', '2013-12-22', '2013-12-18'),
(38, 11, '2013-12-17', '2013-12-31', '2013-12-31'),
(38, 12, '2013-12-05', '2013-12-19', '2013-12-16'),
(38, 12, '2014-01-01', '2014-01-15', '2014-01-14'),
(39, 11, '2013-12-18', '2014-01-01', '2014-01-03'),
(39, 12, '2014-01-04', '2014-01-18', '2014-01-19'),
(39, 20, '2013-12-08', '2013-12-22', '2013-12-17'),
(40, 13, '2013-12-19', '2014-01-02', '2013-12-30'),
(40, 14, '2013-12-17', '2013-12-31', '2013-12-18'),
(40, 15, '2014-01-16', '2014-01-30', '2014-01-27'),
(40, 17, '2013-12-31', '2014-01-14', '2014-01-14'),
(41, 11, '2014-01-01', '2014-01-15', '2014-01-09'),
(41, 12, '2014-04-09', '2014-04-23', '2014-04-13'),
(41, 13, '2014-04-14', '2014-04-28', '2014-04-30'),
(41, 16, '2014-01-18', '2014-02-01', '2014-02-02'),
(41, 16, '2014-05-01', '2014-05-15', NULL),
(41, 18, '2014-03-15', '2014-03-29', '2014-03-28'),
(41, 19, '2014-03-29', '2014-04-12', '2014-04-08'),
(41, 20, '2014-02-16', '2014-03-02', '2014-03-12'),
(42, 14, '2013-12-17', '2013-12-31', '2013-12-24'),
(42, 15, '2014-03-08', '2014-03-22', '2014-03-11'),
(42, 16, '2014-01-28', '2014-02-11', '2014-02-06'),
(42, 16, '2014-02-19', '2014-03-05', '2014-03-07'),
(42, 17, '2014-02-07', '2014-02-21', '2014-02-18'),
(42, 18, '2014-03-12', '2014-03-26', '2014-03-26'),
(43, 11, '2014-04-18', '2014-05-02', '2014-05-01'),
(43, 12, '2014-05-13', '2014-05-27', '2014-05-14'),
(43, 13, '2014-01-28', '2014-02-11', '2014-02-13'),
(43, 14, '2014-05-03', '2014-05-17', '2014-05-12'),
(43, 15, '2014-03-12', '2014-03-26', '2014-03-14'),
(43, 16, '2014-03-14', '2014-03-28', '2014-03-25'),
(43, 17, '2014-05-14', '2014-05-28', NULL),
(43, 19, '2013-12-18', '2014-01-01', '2013-12-29'),
(43, 20, '2014-04-01', '2014-04-15', '2014-04-15'),
(44, 11, '2014-01-19', '2014-02-02', '2014-01-26'),
(44, 12, '2014-03-31', '2014-04-14', '2014-04-15'),
(44, 13, '2014-04-22', '2014-05-06', '2014-04-27'),
(44, 14, '2014-04-15', '2014-04-29', '2014-04-20'),
(44, 15, '2014-05-08', '2014-05-22', NULL),
(44, 16, '2014-03-12', '2014-03-26', '2014-03-24'),
(44, 17, '2014-04-28', '2014-05-12', '2014-05-08'),
(44, 18, '2014-03-02', '2014-03-16', '2014-03-11'),
(44, 19, '2014-02-01', '2014-02-15', '2014-02-12'),
(44, 20, '2014-02-13', '2014-02-27', '2014-03-01'),
(45, 11, '2013-12-10', '2013-12-24', '2013-12-13'),
(45, 11, '2014-01-09', '2014-01-23', '2014-01-11'),
(45, 11, '2014-04-18', '2014-05-02', '2014-04-19'),
(45, 12, '2013-12-16', '2013-12-30', '2013-12-17'),
(45, 12, '2014-01-14', '2014-01-28', '2014-01-15'),
(45, 12, '2014-04-24', '2014-05-08', '2014-04-25'),
(45, 13, '2013-12-18', '2014-01-01', '2013-12-19'),
(45, 13, '2014-01-17', '2014-01-31', '2014-01-18'),
(45, 14, '2013-12-19', '2014-01-02', '2013-12-20'),
(45, 14, '2014-01-19', '2014-02-02', '2014-01-21'),
(45, 15, '2013-12-22', '2014-01-05', '2013-12-24'),
(45, 15, '2014-02-27', '2014-03-13', '2014-02-28'),
(45, 16, '2013-11-30', '2013-12-14', '2013-12-03'),
(45, 16, '2013-12-05', '2013-12-19', '2013-12-06'),
(45, 16, '2013-12-25', '2014-01-08', '2013-12-28'),
(45, 16, '2014-01-02', '2014-01-16', '2014-01-04'),
(45, 16, '2014-03-05', '2014-03-19', '2014-03-06'),
(45, 16, '2014-03-10', '2014-03-24', '2014-03-12'),
(45, 17, '2013-12-21', '2014-01-04', '2013-12-22'),
(45, 17, '2014-01-24', '2014-02-07', '2014-01-25'),
(45, 18, '2013-12-04', '2013-12-18', '2013-12-05'),
(45, 18, '2013-12-28', '2014-01-11', '2013-12-31'),
(45, 18, '2014-03-07', '2014-03-21', '2014-03-08'),
(45, 19, '2013-12-08', '2013-12-22', '2013-12-08'),
(45, 19, '2014-01-05', '2014-01-19', '2014-01-06'),
(45, 19, '2014-04-14', '2014-04-28', '2014-04-15'),
(45, 20, '2013-12-08', '2013-12-22', '2013-12-09'),
(45, 20, '2014-01-07', '2014-01-21', '2014-01-08'),
(45, 20, '2014-04-16', '2014-04-30', '2014-04-17'),
(46, 13, '2013-12-08', '2013-12-22', '2013-12-21'),
(46, 14, '2014-02-09', '2014-02-23', '2014-02-18'),
(46, 15, '2014-03-05', '2014-03-19', '2014-03-12'),
(46, 16, '2014-04-13', '2014-04-27', '2014-04-29'),
(46, 16, '2014-05-09', '2014-05-23', NULL),
(46, 17, '2014-02-19', '2014-03-05', '2014-03-02'),
(46, 18, '2014-05-01', '2014-05-15', '2014-05-07'),
(47, 11, '2014-03-12', '2014-03-26', '2014-03-27'),
(47, 12, '2014-03-28', '2014-04-11', '2014-03-29'),
(47, 13, '2014-01-28', '2014-02-11', '2014-02-10'),
(47, 14, '2014-02-21', '2014-03-07', '2014-03-09'),
(47, 15, '2014-05-02', '2014-05-16', '2014-05-04'),
(47, 16, '2014-04-19', '2014-05-03', '2014-04-20'),
(47, 16, '2014-04-20', '2014-05-04', '2014-04-24'),
(47, 17, '2014-03-29', '2014-04-12', '2014-04-05'),
(47, 18, '2014-04-07', '2014-04-21', '2014-04-18'),
(47, 19, '2014-01-18', '2014-02-01', '2014-01-27'),
(47, 19, '2014-04-25', '2014-05-09', '2014-04-30'),
(47, 20, '2014-02-10', '2014-02-24', '2014-02-18'),
(47, 20, '2014-05-04', '2014-05-18', NULL),
(48, 17, '2014-05-15', '2014-05-29', NULL);

-- --------------------------------------------------------

--
-- Structure de la table `genre`
--

CREATE TABLE IF NOT EXISTS `genre` (
  `CodeGenre` tinyint(4) NOT NULL AUTO_INCREMENT,
  `NomGenre` varchar(25) NOT NULL DEFAULT '',
  PRIMARY KEY (`CodeGenre`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=30 ;

--
-- Contenu de la table `genre`
--

INSERT INTO `genre` (`CodeGenre`, `NomGenre`) VALUES
(1, 'Littérature'),
(2, 'Terreur'),
(3, 'Science-Fiction'),
(4, 'BD'),
(5, 'Essai'),
(6, 'Policier'),
(7, 'Roman contemporain'),
(25, 'Littérature'),
(26, 'Littérature'),
(28, 'Littérature'),
(29, 'Littérature');

-- --------------------------------------------------------

--
-- Structure de la table `livre`
--

CREATE TABLE IF NOT EXISTS `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  DEFAULT CHARSET=latin1 AUTO_INCREMENT=50 ;

--
-- Contenu de la table `livre`
--

INSERT INTO `livre` (`CodeLivre`, `ISBNLivre`, `TitreLivre`, `PrixLivre`, `EditeurLivre`, `AnneeLivre`, `LangueLivre`, `CodeAuteurLivre`, `CodeGenreLivre`) VALUES
(1, '2-07-038692-6', 'Les fréres Karamazov', 7, 'Folio', 1880, 'Russe', 1, 1),
(2, '2-07-036893-9', 'Le Joueur', 5, 'Folio', 1866, 'Russe', 1, 1),
(3, '2-07-074049-8', 'L''écriture ou la vie', 15, 'Gallimard', 1994, 'Français', 2, 1),
(4, '2-07-036287-6', 'Guerre et Paix', 8, 'Folio', 1869, 'Russe', 3, 1),
(5, '2-07-036083-0', 'Les raisins de la colère', 6, 'Folio', 1947, 'Américain', 4, 1),
(6, '2-02-018381-1', 'Histoire des colonisations', 20, 'Seuil', 1994, 'Français', 5, 5),
(7, '2-266-05366-3', 'Dracula', 6, 'Pocket', 1897, 'Anglais', 6, 2),
(8, '2-501-00279-2', 'Frankenstein', 6, 'Marabout', 1818, 'Anglais', 7, 2),
(9, '2-277-21197-4', 'Shining', 6, 'J''ai Lu', 1977, 'Américain', 8, 2),
(10, '2-8001-1455-X', 'L''évasion des Dalton', 9, 'Dupuis', 1960, 'Français', 19, 4),
(11, '2-258-00139-0', 'La Nuit des temps', 6, 'Pocket', 1968, 'Français', 10, 3),
(12, '2-253-13862-2', 'Nuit d''été', 6, 'Albin Michel', 1991, 'Français', 11, 2),
(13, '2-266-02665-8', 'Dune', 6, 'Pocket', 1965, 'Américain', 12, 3),
(14, '2-290-00349-2', '2001 L''odyssée de l''espace', 5, 'J''ai Lu', 1968, 'Anglais', 13, 3),
(15, '2-207-30008-0', 'Fahrenheit 451', 5, 'Denoël', 1953, 'Américain', 14, 3),
(16, '2-277-21768-9', 'Blade Runner', 5, 'J''ai Lu', 1968, 'Américain', 15, 3),
(17, '2-8001-1452-5', 'Les cousins Dalton', 7, 'Dupuis', 1958, 'Français', 19, 4),
(18, '2-07-036822-X', '1984', 7, 'Folio', 1948, 'Anglais', 16, 1),
(19, '2-07-037093-3', 'Quatrevingt-treize', 6, 'Folio', 1874, 'Français', 17, 1),
(20, '2-266-08308-2', 'Les Misérables', 12, 'Folio', 1862, 'Français', 17, 1),
(21, '2-07-037001-1', 'Germinal', 7, 'Folio', 1885, 'Français', 18, 1),
(22, '2-07-037051-8', 'L''assommoir', 7, 'Folio', 1877, 'Français', 18, 1),
(23, '2-8001-1441-X', 'La mine d''or de Dick Digger', 9, 'Dargaud', 1949, 'Français', 19, 4),
(24, '2-234-04964-4', 'Lourdes', 15, 'Stock', 1894, 'Français', 18, 1),
(25, '2-234-04963-6', 'Paris', 15, 'Stock', 1898, 'Français', 18, 1),
(26, '2-8001-1457-6', 'Sur la piste des Dalton', 9, 'Dupuis', 1962, 'Français', 19, 4),
(27, '2-8001-1462-2', 'Les Dalton dans le blizzard', 9, 'Dupuis', 1963, 'Français', 19, 4),
(28, '2-205-00585-5', 'Ma Dalton', 9, 'Dargaud', 1971, 'Français', 19, 4),
(29, '2-234-049652', 'Rome', 15, 'Stock', 1896, 'Français', 18, 1),
(30, '2-02-031430-4', 'Le Tambour', 9, 'Seuil', 1959, 'Allemand', 9, 1),
(31, '2-8001-1471-1', 'Tortillas pour les Dalton', 9, 'Dupuis', 1967, 'Français', 19, 4),
(32, '2-070-30878-2', 'Salammbô', 8, 'Folio', 1862, 'Français', 20, 1),
(33, '2-207-30089-7', 'Fondation', 7, 'Denoël', 1951, 'Américain', 21, 3),
(34, '2-070-41311-X', 'Madame Bovary', 8, 'Folio', 1857, 'Français', 20, 1),
(35, '2-277-12453-2', 'Les robots', 5, 'J''ai Lu', 1950, 'Américain', 21, 3),
(36, '2-070-74277-6', 'Notes de Hiroshima', 11, 'Marabout', 1965, 'Japonais', 29, 5),
(37, '2-7427-1542-8', 'Etre sans destin', 9, 'Actes Sud', 1975, 'Hongrois', 30, 1),
(38, '2-020-23811-X', 'Cent ans de solitude', 6, 'Actes Sud', 1967, 'Espagnol', 31, 1),
(39, '2-253-00597-5', 'A l''Est d''Eden', 7, 'Le Livre de Poche', 1952, 'Américain', 4, 1),
(40, '2-02-036376-3', 'Le Monde selon Garp', 8, 'Seuil', 1976, 'Américain', 24, 7),
(41, '2-253-003313-', 'Le Nom de la Rose', 6, 'Le Livre de Poche', 1980, 'Italien', 23, 1),
(42, '2-7436-1281-9', 'Mystic River', 9, 'Rivages', 2001, 'Américain', 28, 6),
(43, '2-070-36042-3', 'La Peste', 5, 'Folio', 1947, 'Français', 26, 1),
(44, '2-2531-4087-2', 'L''Ecume des Jours', 8, 'Folio', 1947, 'Français', 27, 7),
(45, '2-87827-038-X', 'Sin City', 11, 'Rackham', 1994, 'Américain', 22, 4),
(46, '2-203-34411-3', 'La Ballade de la Mer Salée', 14, 'Casterman', 1967, 'Italien', 32, 4),
(47, '2-253-06168-9', 'La Méditerranée', 8, 'Le Livre de Poche', 1949, 'Français', 25, 5),
(48, '2-08-070611-X', 'Le Dernier des Mohicans', 7, 'Marabout', 1826, 'Américain', 33, 1),
(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_1` FOREIGN KEY (`CodeAuteurLivre`) REFERENCES `auteur` (`CodeAuteur`),
  ADD CONSTRAINT `livre_ibfk_2` FOREIGN KEY (`CodeGenreLivre`) REFERENCES `genre` (`CodeGenre`);