-- phpMyAdmin SQL Dump
-- version 4.1.4
-- http://www.phpmyadmin.net
--
-- Client :  127.0.0.1
-- Généré le :  Lun 11 Janvier 2016 à 18:38
-- Version du serveur :  5.6.15-log
-- Version de PHP :  5.5.8

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

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

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

--
-- Structure de la table `distributions`
--

CREATE TABLE IF NOT EXISTS `distributions` (
  `idfilm` int(11) NOT NULL,
  `idacteur` int(11) NOT NULL,
  `rang` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `producteurs`
--

CREATE TABLE IF NOT EXISTS `producteurs` (
  `num` int(11) NOT NULL DEFAULT '0',
  `nom` char(40) DEFAULT NULL,
  `prenom` char(40) DEFAULT NULL,
  `region` char(40) DEFAULT NULL,
  PRIMARY KEY (`num`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `producteurs`
--

INSERT INTO `producteurs` (`num`, `nom`, `prenom`, `region`) VALUES
(1, 'Bohn', 'Rene', 'Alsace'),
(2, 'Boxler', 'Albert', 'Alsace'),
(3, 'Six', 'Paul', 'Alsace'),
(4, 'Stentz', 'Fernand', 'Alsace'),
(5, 'Joudeat', 'Lucien', 'Bourgogne'),
(6, 'Marmagne', 'Bernard', 'Bourgogne'),
(7, 'Lasnier', 'Pierre', 'Bourgogne'),
(8, 'Lioger d Harduy', 'Gabriel', 'Bourgogne'),
(9, 'Moniot', 'Gilbert', 'Bourgogne'),
(10, 'Fournier', 'Jean Claude', 'Bourgogne'),
(11, 'Clerget', 'Anne', 'Bourgogne'),
(12, 'Tortochot', 'Gabriel', 'Bourgogne'),
(13, 'Grivot', 'Jean', 'Bourgogne'),
(14, 'Jayer', 'Henri', 'Bourgogne'),
(15, 'Drouhin', 'Joseph', 'Bourgogne'),
(16, 'Barbin', 'Bernard', 'Bourgogne'),
(17, 'Faiveley', 'Guy', 'Bourgogne'),
(18, 'Tramier', 'Jean', 'Bourgogne'),
(19, 'Dupaquier', 'Roger', 'Bourgogne'),
(20, 'Lamy', 'Jean', 'Bourgogne'),
(21, 'Cornu', 'Edmond', 'Bourgogne'),
(22, 'Dubreuil Fontaine', 'Pierre', 'Bourgogne'),
(23, 'Laleure', '', 'Bourgogne'),
(24, 'Guillemot', 'Pierre', 'Bourgogne'),
(25, 'Valentin Bouchotte', 'Roger', 'Bourgogne'),
(26, 'Violot', 'Gilbert', 'Bourgogne'),
(27, 'Glantenay', 'Louis', 'Bourgogne'),
(28, 'Monnier', 'Rene', 'Bourgogne'),
(29, 'De Suremain', 'Robert', 'Bourgogne'),
(30, 'Desbois', 'Maurice', 'Bourgogne'),
(31, 'Prudhon', 'Henri', 'Bourgogne'),
(32, 'Mestre', 'Philippe', 'Bourgogne'),
(33, 'Prieur', 'Guy', 'Bourgogne'),
(34, 'Monnier', 'Rene', 'Bourgogne'),
(35, 'Roulot', 'Guy', 'Bourgogne'),
(36, 'Sauzet', 'Etienne', 'Bourgogne'),
(37, 'Delagrange Bachelet', '', 'Bourgogne'),
(38, 'De Launay', 'Paul', 'Bourgogne'),
(39, 'De Suremin', 'Hugues', 'Bourgogne'),
(40, 'Genelot', 'Maurice', 'Bourgogne'),
(41, 'Juillot', 'Michel', 'Bourgogne'),
(42, 'Juillot', 'Maurice', 'Bourgogne'),
(43, 'Menand', 'Jean Claude', 'Bourgogne'),
(44, 'Feyveley', '', 'Bourgogne'),
(45, 'Jeannin', 'Andre', 'Bourgogne'),
(46, 'Monassier', 'Armand', 'Bourgogne'),
(47, 'Thenard', '', 'Bourgogne'),
(48, 'Flamand', '', 'Bourgogne'),
(49, 'Guillot', 'Pierre', 'Bourgogne'),
(50, 'Chagny', 'Georges', 'Bourgogne'),
(51, 'Simonet', 'Leon', 'Bourgogne'),
(52, 'Lapierre', 'Jean', 'Bourgogne'),
(53, 'Cooperative', '', 'Bourgogne'),
(54, 'Cooperative', '', 'Bourgogne'),
(55, 'Michon', 'Philippe', 'Bourgogne'),
(56, 'Coutelle', 'Jean', 'Beaujolais'),
(57, 'Desmules', 'Pierre', 'Beaujolais'),
(58, 'Joubert', 'Claude', 'Beaujolais'),
(59, 'La Thuilliere', 'Jean', 'Beaujolais'),
(60, 'Vernus', 'Georges', 'Beaujolais'),
(61, 'Champier', 'Charles', 'Beaujolais'),
(62, 'Champagnon', 'Louis', 'Beaujolais'),
(63, 'Cooperative', '', 'Beaujolais'),
(64, 'Marius Bel Air', 'Morin', 'Beaujolais'),
(65, 'Appert', 'Michel', 'Beaujolais'),
(66, 'Cooperative', '', 'Beaujolais'),
(67, 'Descombes', 'Jean Ernest', 'Beaujolais'),
(68, 'Savoye', 'Louis', 'Beaujolais'),
(69, 'Janin', 'Marcel', 'Beaujolais'),
(70, 'Trichard', 'Benoit', 'Beaujolais'),
(71, 'Chalandard', 'Daniel', 'Jura'),
(72, 'Reverchon', 'Joseph', 'Jura'),
(73, 'Bourguignon', 'Emile', 'Jura'),
(74, 'Grand', 'Rene', 'Jura'),
(75, 'Loye', 'Camille', 'Jura'),
(76, 'Maire', 'Henri', 'Jura'),
(77, 'Tissot', 'Andre', 'Jura'),
(78, 'Michlel', 'Pierre Emile', 'Jura'),
(79, 'Petit', 'Gerard', 'Jura'),
(80, 'Devaux', 'Jean Paul', 'Jura'),
(81, 'Peltier', 'Pierre', 'Jura'),
(82, 'Mollex', 'Georges', 'Savoie'),
(83, 'Goy', '', 'Jura'),
(84, 'Metral', 'Jean', 'Jura'),
(85, 'Champet', 'Emile', 'Rhone'),
(86, 'Dumazet', 'Marc', 'Rhone'),
(87, 'Neyret Gachet', '', 'Rhone'),
(88, 'Begot', 'Albert', 'Rhone'),
(89, 'Michelas', 'Robert', 'Rhone'),
(90, 'Roure', 'Raymond', 'Rhone'),
(91, 'Chave', 'Gerard', 'Rhone'),
(92, 'De Boissieu', '', 'Rhone'),
(93, 'Marsanne', 'Jean', 'Rhone'),
(94, 'Grippat', 'Jean Louis', 'Rhone'),
(95, 'Verset', 'Louis', 'Rhone'),
(96, 'Boisson', 'Jean Pierre', 'Rhone'),
(97, 'Quiot', 'Pierre', 'Rhone'),
(98, 'Berard', '', 'Rhone'),
(99, 'Cooperative', '', 'Rhone'),
(100, 'Bernard', 'Georges', 'Rhone'),
(101, 'Verdan', 'Antoine', 'Rhone'),
(102, 'Cooperative', '', 'Rhone'),
(103, 'Coulouvrat', 'Michel', 'Rhone'),
(104, 'Rabasse Chavarin', 'Abel', 'Rhone'),
(105, 'Roux', 'Charles', 'Rhone'),
(106, 'Alary', '', 'Rhone'),
(107, 'Meunier', 'Laurent', 'Rhone'),
(108, 'Archimbaud', 'Jean', 'Rhone'),
(109, 'Rey', 'Marcel', 'Rhone'),
(110, 'Cooperative', '', 'Rhone'),
(111, 'Zafiropulo', 'Costa', 'Provence'),
(112, 'Prebost', 'Gaston', 'Provence'),
(113, 'Gomez', 'Rene', 'Provence'),
(114, 'Brunet', 'Georges', 'Provence'),
(115, 'Bordonado', 'Raymond', 'Provence'),
(116, 'Imbert', 'Christian', 'Corse'),
(117, 'Cooperative', '', 'Languedoc'),
(118, 'Cooperative', '', 'Languedoc'),
(119, 'Cooperative', '', 'Pyrenees'),
(120, 'Campigna Janvier', '', 'Pyrenees'),
(121, 'Cooperative', '', 'Pyrenees'),
(122, 'Dupuy', 'Charles', 'Pyrenees'),
(123, 'Laurent', 'Pierre', 'Pyrenees'),
(124, 'Daurat Fort', 'Robert', 'Pyrenees'),
(125, 'Baldes', 'Jean', 'Sud Ouest'),
(126, 'Jouffreau', 'Jean', 'Sud Ouest'),
(127, 'Brumont', 'Alban', 'Sud Ouest'),
(129, 'Barrere', 'Alfred', 'Sud Ouest');

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

--
-- Structure de la table `recoltes`
--

CREATE TABLE IF NOT EXISTS `recoltes` (
  `nprod` int(11) NOT NULL DEFAULT '0',
  `nvin` int(11) NOT NULL DEFAULT '0',
  `quantite` int(11) DEFAULT NULL,
  PRIMARY KEY (`nprod`,`nvin`),
  KEY `refVIN` (`nvin`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `recoltes`
--

INSERT INTO `recoltes` (`nprod`, `nvin`, `quantite`) VALUES
(1, 1, 300),
(73, 1, 1),
(5, 2, 100),
(1, 3, 400),
(10, 4, 35),
(30, 5, 46),
(42, 6, 300),
(98, 7, 68),
(90, 8, 123),
(8, 9, 10),
(98, 10, 100),
(5, 11, 200),
(7, 12, 31),
(43, 12, 200),
(89, 12, 310),
(13, 13, 13),
(86, 14, 180),
(80, 15, 290),
(38, 16, 100),
(95, 17, 50),
(40, 18, 120),
(7, 19, 986),
(50, 20, 100),
(5, 21, 150),
(86, 22, 50),
(86, 23, 15),
(36, 24, 859),
(95, 25, 40),
(43, 26, 70),
(99, 27, 60),
(50, 28, 100),
(50, 29, 50),
(22, 30, 350),
(50, 31, 320),
(72, 32, 890),
(90, 32, 500),
(60, 33, 70),
(4, 34, 500),
(10, 35, 900),
(23, 35, 350),
(93, 36, 50),
(54, 37, 830),
(52, 38, 125),
(52, 39, 80),
(65, 40, 90),
(76, 41, 25),
(82, 42, 80),
(13, 43, 500),
(72, 43, 900),
(85, 43, 983),
(93, 44, 40),
(2, 45, 90),
(67, 45, 912),
(71, 45, 98),
(78, 45, 540),
(86, 45, 450),
(64, 46, 760),
(52, 47, 75),
(93, 48, 70),
(2, 49, 150),
(2, 50, 100),
(15, 51, 36),
(40, 52, 500),
(40, 53, 800),
(1, 54, 500),
(2, 54, 900),
(14, 54, 500),
(63, 54, 210),
(14, 55, 450),
(24, 56, 790),
(40, 57, 940),
(45, 58, 70),
(45, 59, 160),
(50, 60, 300),
(60, 60, 60),
(90, 61, 120),
(60, 62, 900),
(65, 63, 136),
(72, 64, 870),
(85, 64, 980),
(12, 65, 10),
(25, 65, 560),
(65, 66, 124),
(5, 67, 125),
(10, 67, 890),
(82, 67, 760),
(12, 68, 60),
(9, 69, 96),
(12, 69, 320),
(69, 69, 690),
(38, 70, 120),
(38, 71, 132),
(52, 72, 34),
(38, 73, 45),
(70, 74, 650),
(72, 74, 850),
(84, 74, 675),
(38, 75, 69),
(46, 76, 100),
(85, 76, 900),
(85, 77, 100),
(4, 78, 300),
(27, 78, 360),
(30, 78, 900),
(68, 78, 980),
(80, 78, 970),
(74, 79, 100),
(79, 79, 79),
(81, 79, 800),
(90, 80, 79),
(90, 81, 24),
(43, 82, 100),
(79, 82, 546),
(80, 82, 800),
(95, 83, 423),
(95, 84, 146),
(55, 85, 46),
(93, 86, 500),
(38, 87, 630),
(45, 87, 680),
(72, 87, 900),
(55, 88, 129),
(15, 89, 150),
(42, 89, 980),
(55, 89, 723),
(65, 89, 980),
(89, 89, 100),
(56, 90, 900),
(95, 90, 400),
(79, 91, 24),
(11, 92, 900),
(79, 93, 110),
(11, 94, 500),
(27, 94, 180),
(95, 95, 900),
(59, 96, 370),
(70, 97, 1000),
(24, 98, 986),
(35, 98, 400),
(75, 98, 150),
(76, 98, 890),
(88, 98, 340),
(5, 99, 100),
(99, 99, 199),
(25, 100, 100);

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

--
-- Structure de la table `vins`
--

CREATE TABLE IF NOT EXISTS `vins` (
  `num` int(11) NOT NULL,
  `cru` char(40) NOT NULL,
  `annee` int(11) DEFAULT NULL,
  `degre` decimal(4,2) DEFAULT NULL,
  PRIMARY KEY (`num`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `vins`
--

INSERT INTO `vins` (`num`, `cru`, `annee`, `degre`) VALUES
(1, 'Mercurey', 2000, '11.50'),
(2, 'Julienas', 1994, '11.30'),
(3, 'Savigny les Beaunes', 1998, '12.10'),
(4, 'Mercurey', 2000, '10.90'),
(5, 'Pommard', 1996, '11.70'),
(6, 'Mercurey', 2001, '11.20'),
(7, 'Grands Echezeaux', 1998, '11.70'),
(8, 'Cotes de Beaune Villages', 1995, '12.30'),
(9, 'Chapelle Chambertin', 1993, '11.90'),
(10, 'Beaujolais Villages', 1999, '11.80'),
(11, 'Sylvaner', 2002, '11.20'),
(12, 'Gentil', 1995, '10.70'),
(13, 'Cotes du Rhone', 1988, '12.30'),
(14, 'Chateau Chalon', 1998, '10.90'),
(15, 'Cote de Brouilly', 1993, '11.90'),
(16, 'Meursault', 2000, '12.10'),
(17, 'Meursault', 1995, '11.40'),
(18, 'Chambolle Musigny', 1988, '12.30'),
(19, 'Clos du roi', 1992, '11.20'),
(20, 'Cote de Brouilly', 2000, '12.10'),
(21, 'Cotes de Nuits', 1998, '12.00'),
(22, 'Savigny les Beaunes', 1994, '12.00'),
(23, 'Pommard', 1992, '12.00'),
(24, 'Cotes de Beaune Villages', 1991, '12.10'),
(25, 'Chapelle Chambertin', 1988, '10.50'),
(26, 'Chateau Corton Grancey', 2000, '12.00'),
(27, 'Puligny Montrachet', 1994, '11.00'),
(28, 'Volnay', 2000, '11.00'),
(29, 'Corton', 1992, '11.60'),
(30, 'Bourgogne Passe Tout Grains', 1999, '12.00'),
(31, 'Monthelie', 1988, '11.40'),
(32, 'Pouilly Vinzelles', 1988, '12.30'),
(33, 'Santenay', 1992, '12.00'),
(34, 'Montagny', 1998, '11.20'),
(35, 'Auxey Duresses', 1994, '11.30'),
(36, 'Chorey les Beaunes', 1995, '11.00'),
(37, 'Savigny les Beaunes', 1998, '10.00'),
(38, 'Savigny les Beaunes', 1997, '11.00'),
(39, 'Savigny les Beaunes', 1993, '12.00'),
(40, 'Richebourg', 1993, '12.00'),
(41, 'Clairette de Die', 1996, '12.00'),
(42, 'Beaujolais Primeur', 2003, '12.00'),
(43, 'Fleurie', 2000, '11.40'),
(44, 'Moulin a vent', 2003, '11.20'),
(45, 'Chiroubles', 2003, '10.90'),
(46, 'Chiroubles', 2003, '11.00'),
(47, 'Chiroubles', 1998, '11.00'),
(48, 'Cote de Brouilly', 1999, '12.00'),
(49, 'Morgon', 2004, '12.00'),
(50, 'Chenas', 2004, '12.00'),
(51, 'Chenas', 1995, '10.00'),
(52, 'Brouilly', 1995, '11.50'),
(53, 'Beaujolais Villages', 1995, '10.30'),
(54, 'Beaujolais Villages', 1996, '10.50'),
(55, 'Beaujolais Villages', 1998, '12.10'),
(56, 'Saint Amour', 1994, '12.60'),
(57, 'Crozes Hermitage', 1994, '12.10'),
(58, 'Crozes Hermitage', 1995, '12.50'),
(59, 'Crozes Hermitage', 1992, '12.30'),
(60, 'Crozes Hermitage', 2003, '11.00'),
(61, 'Crozes Hermitage', 1999, '12.00'),
(62, 'Gigondas', 1998, '11.00'),
(63, 'Coteaux du Tricastin', 1998, '10.00'),
(64, 'Coteaux du Tricastin', 1994, '11.00'),
(65, 'Rochegrande', 1988, '10.80'),
(66, 'Tavel', 1988, '11.00'),
(67, 'Gewurztraminer', 1988, '12.50'),
(68, 'Riesling', 1982, '11.40'),
(69, 'Tokay d Alsace', 2002, '11.00'),
(70, 'Sylvaner', 2002, '11.00'),
(71, 'Palette', 2001, '11.00'),
(72, 'Cassis', 1998, '10.00'),
(73, 'Bellet', 1996, '11.00'),
(74, 'Arbois', 2000, '12.00'),
(75, 'Arbois', 1996, '11.00'),
(76, 'Chateau Chalon', 1996, '12.00'),
(77, 'Etoile', 1999, '11.00'),
(78, 'Etoile', 2000, '12.00'),
(79, 'Seyssel', 2000, '11.00'),
(80, 'Seyssel', 2000, '11.00'),
(81, 'Cornas', 2000, '11.00'),
(82, 'Cornas', 2000, '11.00'),
(83, 'Saint Amour', 2000, '10.00'),
(84, 'Rasteau', 2000, '10.00'),
(85, 'Tavel', 2000, '11.00'),
(86, 'Tavel', 2000, '11.00'),
(87, 'Cotes de Provence', 2000, '12.00'),
(88, 'Cotes de Provence', 1996, '10.00'),
(89, 'Cotes de Provence', 1989, '11.00'),
(90, 'Palette', 1999, '11.00'),
(91, 'Cassis', 1999, '11.00'),
(92, 'Coteaux de Pierevert', 1997, '10.30'),
(93, 'Blanquette de Limoux', 1998, '10.90'),
(94, 'Cotes du Roussillon', 1998, '11.50'),
(95, 'Cotes du Roussillon', 1998, '12.00'),
(96, 'Saint Chinian', 1996, '11.00'),
(97, 'Saint Chinian', 1996, '11.00'),
(98, 'Corbieres', 1998, '10.00'),
(99, 'Vin de Savoie Ayze', 1996, '12.00'),
(100, 'Seyssel', 1994, '11.00'),
(101, 'Saint Veran', 1993, '12.50');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
