-- phpMyAdmin SQL Dump
-- version 4.6.6
-- https://www.phpmyadmin.net/
--
-- Client :  localhost
-- Généré le :  Ven 05 Mai 2017 à 10:13
-- Version du serveur :  5.7.17-0ubuntu0.16.04.1
-- Version de PHP :  7.0.15-0ubuntu0.16.04.4

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 utf8mb4 */;

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

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

--
-- Structure de la table `abattoir`
--

CREATE TABLE `abattoir` (
  `id_abat` int(3) NOT NULL,
  `Num_Abattoir` varchar(13) COLLATE utf8_bin NOT NULL,
  `Nom_abattoir` varchar(25) COLLATE utf8_bin NOT NULL,
  `Ville_Abat` varchar(25) COLLATE utf8_bin NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `abattoir`
--

INSERT INTO `abattoir` (`id_abat`, `Num_Abattoir`, `Nom_abattoir`, `Ville_Abat`) VALUES
(1, 'FR46251001CE', 'St Cere', 'St Cere'),
(2, 'FR15094001CE ', 'Laroquebrou', 'Laroquebrou'),
(3, 'FR8212106CE ', 'Montauban', 'Montauban'),
(4, 'FR24336004CE', 'CAT LAVERGNE', 'PRATS-DE-CARLUX');

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

--
-- Structure de la table `categorieplu`
--

CREATE TABLE `categorieplu` (
  `Num_CatPlu` int(3) NOT NULL,
  `CategoriePlu` varchar(25) COLLATE utf8_bin NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `categorieplu`
--

INSERT INTO `categorieplu` (`Num_CatPlu`, `CategoriePlu`) VALUES
(1, 'Boeuf'),
(2, 'Veau'),
(3, 'Jeune Bovin'),
(4, 'Agneau'),
(5, 'chevre'),
(6, 'Porc'),
(7, 'facturation'),
(8, 'Cheval'),
(9, 'Fabrications'),
(10, 'Canard'),
(11, 'Oie');

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

--
-- Structure de la table `categorie_dechets`
--

CREATE TABLE `categorie_dechets` (
  `num_cate_dechets` int(11) NOT NULL,
  `categorie_dechets` varchar(2) COLLATE utf8_bin NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `categorie_dechets`
--

INSERT INTO `categorie_dechets` (`num_cate_dechets`, `categorie_dechets`) VALUES
(1, 'C1'),
(2, 'C2'),
(3, 'C3');

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

--
-- Structure de la table `categorie_decoupe`
--

CREATE TABLE `categorie_decoupe` (
  `num_cate_decoupe` int(11) NOT NULL,
  `cate_decoupe` varchar(25) COLLATE utf8_bin NOT NULL,
  `lettre_trace` varchar(2) COLLATE utf8_bin NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `categorie_decoupe`
--

INSERT INTO `categorie_decoupe` (`num_cate_decoupe`, `cate_decoupe`, `lettre_trace`) VALUES
(1, 'Casse', 'ca'),
(2, 'Decoupe', 'd'),
(3, 'Transformation', 't'),
(4, 'Entre', ''),
(5, 'Congelation', 'co');

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

--
-- Structure de la table `categorie_fabrications`
--

CREATE TABLE `categorie_fabrications` (
  `num_cate_fabric` int(4) NOT NULL,
  `categorie_fabrication` varchar(25) COLLATE utf8_bin NOT NULL,
  `Let_cate_fabric` varchar(2) COLLATE utf8_bin NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `categorie_fabrications`
--

INSERT INTO `categorie_fabrications` (`num_cate_fabric`, `categorie_fabrication`, `Let_cate_fabric`) VALUES
(1, 'Frais', 'Fr'),
(2, 'Sous vide', 'Sv'),
(3, 'Plats Cuisine', 'Pc'),
(4, 'Conserve', 'Ce');

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

--
-- Structure de la table `categorie_fournisseurs`
--

CREATE TABLE `categorie_fournisseurs` (
  `num_cate_four` int(3) NOT NULL,
  `categorie_four` varchar(25) COLLATE utf8_bin NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `categorie_fournisseurs`
--

INSERT INTO `categorie_fournisseurs` (`num_cate_four`, `categorie_four`) VALUES
(1, 'Equarissage'),
(2, 'Emballage'),
(3, 'Produits entretien'),
(4, 'Boyaux'),
(5, 'Prestations service'),
(6, 'Epicerie'),
(7, 'Divers'),
(8, 'legumes'),
(9, 'Intrants');

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

--
-- Structure de la table `categorie_intrant`
--

CREATE TABLE `categorie_intrant` (
  `num_cate_plu_intran` int(4) NOT NULL,
  `categorie_plu_intran` varchar(25) COLLATE utf8_bin NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `categorie_intrant`
--

INSERT INTO `categorie_intrant` (`num_cate_plu_intran`, `categorie_plu_intran`) VALUES
(1, 'viande de vache'),
(2, 'viande de veau'),
(3, 'viande de porc'),
(4, 'legumes'),
(5, 'epices'),
(6, 'emballages'),
(7, 'produits entretient'),
(8, 'Epicerie'),
(9, 'Cremerie'),
(10, 'Boyauderie'),
(11, 'Matiere Premiere');

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

--
-- Structure de la table `clients`
--

CREATE TABLE `clients` (
  `Num_Client` int(3) NOT NULL DEFAULT '0',
  `Let_Client` varchar(3) COLLATE utf8_bin NOT NULL,
  `Nom_Client` varchar(19) COLLATE utf8_bin DEFAULT NULL,
  `adresse_1` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `Adresse_2` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `Adresse_3` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `Telephone` varchar(24) COLLATE utf8_bin DEFAULT NULL,
  `Portable` varchar(10) COLLATE utf8_bin DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `clients`
--

INSERT INTO `clients` (`Num_Client`, `Let_Client`, `Nom_Client`, `adresse_1`, `Adresse_2`, `Adresse_3`, `Telephone`, `Portable`) VALUES
(1, 'A', 'BALDY Didier', 'GAEC de la Mouline', '46150 St DENIS CATUS', '', '0565200033', ''),
(2, 'B', 'HELIN Sophie', 'EARL La Ferme de C', '46150 LHERM', '', '', ''),
(4, 'F', 'VERGNES M.', 'GAEC de Peyrebrune', '46300 ST PROJET', '', '', ''),
(6, 'E', 'REY P. &amp; LAUR J', 'GAEC DE SAILLAC', '46310 PEYRILLES', '', '0565310528', ''),
(7, 'G', 'GAEC LES VIGNALS', 'Dussol Pascal &amp; Da', '46340 SALVIAC', '', '0565415956', ''),
(8, 'H', 'BELIVENT J.C.', 'GAEC le FOURNEL', '46310 PEYRILLES', '', '0565310495', ''),
(9, 'I', 'AULIE S &amp; ALADE', 'GAEC Combes de CAIX', '46310 PEYRILLES', '', '0565310190', ''),
(10, 'J', 'BOSTEEN P.', 'F_32600 ECOCERT', '46310 St Germain du Bel Air', '', '', ''),
(11, 'K', 'GAEC CALMON &amp; F', 'Mas de Simon', '46150 MECHMONT', '', '0565368764', ''),
(12, 'L', 'DULAC A.', 'EARL de moules', '46310 UZECH', '', '', '0684506797'),
(13, 'M', 'PAGES C.', 'GAEC de P', '46310 PEYRILLES', '', '', ''),
(14, 'N', 'ARTUS-GARRIC', 'GAEC de Labaille', '46310 CONCORES', '', '', ''),
(15, 'CO', 'FERME PAYS BOURIAN', 'La Marzelle', '46310 ST GERMAIN', '', '0565353691', ''),
(16, 'P', 'COSTES L.', 'GAEC de Cayret', '46310 PEYRILLES', '', '', ''),
(19, '', 'FERME DU CAMP DE', 'RAS      J B MOULY', '46140 BELAYE', '', '0565531067', ''),
(20, 'AF', 'Gaec la Borie du', 'Moulin ', '46 100 Lalbenque', '', '', '0685093946'),
(21, 'C', 'CAVARROC PATRICE', 'CAMPANOLE', '46 350 PAYRAC', '', '0565376282', ''),
(22, '', 'FRAYSSINET', 'BOULEGAN', '46340 SALVIAC', '', '0565415062', ''),
(23, '', 'DELPECH', 'EARL DE LA CHAMP', '', '', '0553297414', ''),
(24, '', 'MALBEC YVES PIERRE', 'Ferme de Nouelle', '46230 Escamps', 'AGRICULTURE BIO', '', ''),
(26, 'Q', 'GAEC LA BORIE~VAL', 'ROQUEDEVAL', '46300 PAYRIGNAC', '', '0565372381', ''),
(29, '', 'M. JAUVION ERIC', '46300 GOURDON', 'EMB 46 297 A', '', '', ''),
(30, 'S', 'BONNAUD P L', 'SAGNET', 'PERN', '', '', ''),
(31, 'T', 'CALMON DIDIER', 'LES TUILERIES', '46300 ROUFFILHAC', '', '0565411127', '0682597001'),
(32, '', 'PS LAGARRIGUE', 'Les Aliez', '46200 LACAVE', '', '', ''),
(33, 'V', 'BEBENGUT ALAIN', 'FREJAVILLE', '46340 SALVIAC', '', '', '0672057321'),
(34, '', 'ANTHEAUME MARC', 'LES BOUSCARELS', '46150 THEDIRAC', '', '0565212543', ''),
(35, 'AG', 'LA FERME DE PEGOUY', '24590 ARCHIGNAC', 'www.fermedepegouy.fr', '', '', ''),
(36, 'AH', 'ARZAC MANUELLA', 'DURBANS 46320', '', '', '0565405294', ''),
(40, 'AE', 'SERGE DULAC', '', '46310 STCHAMARAND', '', '', ''),
(41, '', 'EARL LA MOUSSAGUEZE', 'DIDIER BALAGAYRIE', '46150 THEDIRAC', '', '', '0671994806'),
(42, 'SA', 'LE MEILLEUR', 'DE NOS FERMES', 'ROUTE DE FIGEAC', '46090 LAMAGDELAINE', '', ''),
(43, '', 'PRADIE SYLVAIN', 'GAEC LES OULES', '4631O UZECH LES OULES', '', '', ''),
(44, 'U', 'EARL Des crouzets', 'BECK J.', 'Le vert 46150 MECHMONT', '', 'justine.damien@orange.fr', ''),
(46, '', 'PS CADOUX', 'CARRIERES', '46500 MIERS', '', '0565331974', ''),
(47, '', 'EARL L\'AUROCHS', '46090 FRANCOULES', 'Conversion BIO, Certif ECOCERT', '', '', ''),
(48, '', 'M. MAYNO GERARD', 'LES VEYSSIERES', '24200 VITRAC', '', '0553316938', ''),
(49, '', 'ROXANE & CYRANO', '24220 CASTELS', 'EMB 46 297 A', '', '0565368211', ''),
(50, 'S', 'EARL DE SAGNET', 'AGRICULTURE BIO', 'F_32600 CERTIFIE ECOCERT', '', '', ''),
(51, '', 'PS : GAEC DOMAINE', 'DE MORDESSON', 'M. ALIBERT MICHEL', '46500 RIGNAC', '', ''),
(52, '', 'TERRE GOURMANDE', '764 CTE DES ORMEAUX', '46000 CAHORS', '', '0565202375', ''),
(53, 'AG', 'LA VIANDE DE PEGOUY', '24590  ARCHIGNAC', 'www.laviandedepegouy.fr', '', '', ''),
(54, 'AG', 'LA VIANDE DE PEGOUY', '24590  ARCHIGNAC', 'www.laviandedepegouy.fr', '', '', ''),
(55, 'FM', 'Ferme du Moulin', 'Relier Jean Loup', '46240 Francoules', '', '', '0661334946');

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

--
-- Structure de la table `clients_base`
--

CREATE TABLE `clients_base` (
  `Num_Client_Base` int(11) NOT NULL,
  `Num_Client` varchar(6) COLLATE utf8_bin NOT NULL DEFAULT '0',
  `Nom_Client` varchar(19) COLLATE utf8_bin DEFAULT NULL,
  `Adresse_1` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `Adresse_2` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `Adresse_3` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `Code_Postal` int(5) DEFAULT NULL,
  `Ville` varchar(25) COLLATE utf8_bin DEFAULT NULL,
  `Telephone` varchar(24) COLLATE utf8_bin DEFAULT NULL,
  `Portable` varchar(10) COLLATE utf8_bin DEFAULT NULL,
  `Email` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `Code_tarif` int(3) DEFAULT NULL,
  `observations` varchar(250) COLLATE utf8_bin NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `clients_base`
--

INSERT INTO `clients_base` (`Num_Client_Base`, `Num_Client`, `Nom_Client`, `Adresse_1`, `Adresse_2`, `Adresse_3`, `Code_Postal`, `Ville`, `Telephone`, `Portable`, `Email`, `Code_tarif`, `observations`) VALUES
(1, '10100', 'Terre Gourmande', 'Mr Bournazel', NULL, NULL, 46000, 'Cahors', NULL, NULL, 'terre.gourmande@gmail.com', 2, 'Livraison le mardi matin et le vendredi martin'),
(2, '10200', 'Vival St Pataleon', 'Mr Martin', 'Zone industrielle ', NULL, 19150, 'Saint Patalon de L\'arche', '0554565474', NULL, 'vivalstpataleon@wanadoo.fr', 3, '');

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

--
-- Structure de la table `decoupe`
--

CREATE TABLE `decoupe` (
  `num_decoupe` int(11) NOT NULL,
  `date_decoupe` date NOT NULL,
  `semaine_decoupe` tinyint(2) NOT NULL,
  `num_client` int(3) NOT NULL,
  `num_lot_decoupe` varchar(10) CHARACTER SET latin1 NOT NULL,
  `tracabilite_decoupe` varchar(20) NOT NULL,
  `categorie_decoupe` int(2) NOT NULL,
  `categorie_plu` int(2) NOT NULL,
  `poid_decoupe` decimal(6,2) NOT NULL,
  `cloture` tinyint(1) NOT NULL,
  `observations` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Contenu de la table `decoupe`
--

INSERT INTO `decoupe` (`num_decoupe`, `date_decoupe`, `semaine_decoupe`, `num_client`, `num_lot_decoupe`, `tracabilite_decoupe`, `categorie_decoupe`, `categorie_plu`, `poid_decoupe`, `cloture`, `observations`) VALUES
(1, '2015-10-04', 40, 44, 'U40AGNX15', '275D', 2, 4, '154.00', 1, 'x10'),
(2, '2015-12-10', 50, 7, 'G41PORC15', '343D', 2, 6, '47.00', 0, 'total'),
(3, '2015-12-10', 50, 7, 'G41PORC15', '343D', 2, 6, '41.50', 0, 'Tout'),
(6, '2015-12-10', 50, 7, 'G41PORC15', '343D', 2, 6, '15.00', 0, '???'),
(7, '2015-12-10', 50, 7, 'G41PORC15', '343d', 2, 6, '15.00', 0, 'Porcelet'),
(8, '2015-12-10', 50, 44, 'U41AGNX15', '343d', 2, 4, '35.00', 1, ''),
(9, '2015-12-10', 50, 8, 'H41147815', '343CA', 1, 1, '55.00', 0, ''),
(10, '2015-12-10', 50, 8, 'H41147815', '343CA', 1, 1, '55.00', 0, ''),
(11, '2015-12-10', 50, 8, 'H41147815', '343CA', 1, 1, '55.00', 0, ''),
(12, '2015-12-10', 50, 44, 'U41AGNX15', '343D', 2, 4, '35.00', 1, ''),
(13, '2015-11-20', 47, 10, 'J41PORC15', '323CA', 1, 6, '357.00', 1, 'x3'),
(14, '2015-12-15', 51, 8, 'H41147815', '348CA', 1, 1, '55.00', 1, '1/2'),
(15, '2015-12-13', 50, 8, 'H41147815', '346D', 2, 1, '110.00', 1, ''),
(16, '2015-12-18', 51, 8, 'H41147815', '343CA351D', 2, 1, '110.00', 1, ''),
(17, '2015-12-30', 53, 8, 'H41147815', '343CA363D', 2, 1, '220.00', 1, ''),
(25, '2016-02-01', 5, 36, 'AH04132616', '31CA31D', 2, 1, '100.00', 1, ''),
(24, '2016-02-01', 5, 36, 'AH04132616', '31CA31T', 3, 1, '50.00', 1, 'Hache'),
(23, '2016-02-01', 5, 36, 'AH04132616', '31CA31D', 2, 1, '125.00', 1, ''),
(22, '2016-02-01', 5, 36, 'AH04132616', '31CA', 1, 1, '275.00', 1, ''),
(26, '2016-02-03', 5, 36, 'AH04132616', '33D', 2, 1, '200.00', 1, 'decooupe Marche magasins'),
(27, '2016-02-03', 5, 36, 'AH04132616', '33T', 3, 1, '75.00', 1, 'hache'),
(29, '2016-03-03', 9, 4, 'F05454516', '62T', 3, 2, '35.00', 0, 'Blanquette'),
(33, '2017-02-27', 9, 55, 'FM07CAN17', '42D', 2, 10, '495.54', 0, 'x50'),
(34, '2017-04-27', 17, 11, 'K17051317', '116CA', 1, 1, '250.00', 1, '1/2'),
(35, '2017-05-02', 18, 11, 'K17051317', '116CA121D', 2, 1, '200.00', 1, '116CA'),
(36, '2017-05-02', 18, 11, 'K17051317', '116CA121T', 3, 1, '50.00', 1, 'Hache');

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

--
-- Structure de la table `entreabat`
--

CREATE TABLE `entreabat` (
  `Num_entre` int(6) NOT NULL,
  `Num_Abattoir` int(8) NOT NULL,
  `Date_Entre` date NOT NULL,
  `DataAbat` date NOT NULL,
  `DateDecoupe` date NOT NULL,
  `NumTicket` text COLLATE utf8_bin NOT NULL,
  `SemaineAbat` varchar(2) COLLATE utf8_bin NOT NULL,
  `NumIdentAn` varchar(12) COLLATE utf8_bin NOT NULL,
  `Num_Abatage` int(5) NOT NULL,
  `Poid` decimal(6,2) NOT NULL,
  `Poid_Chaud` decimal(6,2) NOT NULL,
  `Num_categoriePlu` int(3) NOT NULL,
  `Observations` varchar(25) COLLATE utf8_bin NOT NULL,
  `Num_Client` int(3) NOT NULL,
  `Num_Plu` int(3) NOT NULL,
  `Num_Lot` varchar(10) COLLATE utf8_bin NOT NULL,
  `Poid_saisie` decimal(6,2) NOT NULL,
  `Poid_entre` decimal(6,2) NOT NULL,
  `mrs` int(1) NOT NULL,
  `qtv` int(1) NOT NULL,
  `decoupe` tinyint(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `entreabat`
--

INSERT INTO `entreabat` (`Num_entre`, `Num_Abattoir`, `Date_Entre`, `DataAbat`, `DateDecoupe`, `NumTicket`, `SemaineAbat`, `NumIdentAn`, `Num_Abatage`, `Poid`, `Poid_Chaud`, `Num_categoriePlu`, `Observations`, `Num_Client`, `Num_Plu`, `Num_Lot`, `Poid_saisie`, `Poid_entre`, `mrs`, `qtv`, `decoupe`) VALUES
(37, 1, '2015-10-07', '2015-10-05', '2015-10-12', '1147-857', '41', 'FR4755841030', 1744141, '101.00', '105.00', 3, '', 10, 950, 'J41103015', '25.00', '76.00', 1, 0, 0),
(24, 1, '2015-10-09', '2015-10-09', '2015-10-09', '2525', '41', 'FR4625328547', 1144, '411.00', '419.00', 1, '', 21, 950, 'C41854715', '0.00', '411.00', 1, 0, 0),
(34, 1, '2015-10-10', '2015-10-10', '2015-10-10', '1185-9685', '41', 'AGNX', 114477, '35.00', '36.00', 4, 'x2', 44, 950, 'U41AGNX15', '0.00', '35.00', 0, 0, 0),
(29, 1, '2015-10-08', '2015-10-05', '2015-10-15', '1185-2541', '41', 'FR4685321478', 1144, '440.00', '445.00', 1, '', 8, 950, 'H41147815', '0.00', '440.00', 1, 0, 0),
(28, 1, '2015-10-09', '2015-10-09', '2015-10-09', '1181-25', '41', 'FR4546851111', 11574, '397.00', '401.00', 1, '', 1, 950, 'A41111115', '32.00', '365.00', 1, 0, 0),
(32, 2, '2015-10-09', '2015-10-09', '2015-10-09', '3252-4747', '41', 'PORC', 74747, '97.00', '101.00', 6, '', 7, 950, 'G41PORC15', '0.00', '97.00', 0, 0, 0),
(35, 1, '2015-10-03', '2015-10-02', '2015-10-04', '11504-30', '40', 'AGNX', 41547, '154.00', '159.00', 4, 'x10', 44, 950, 'U40AGNX15', '0.00', '154.00', 0, 0, 0),
(38, 2, '2015-10-09', '2015-10-09', '2015-10-09', '2535', '41', 'PORC', 1418, '357.00', '361.00', 6, 'x2', 10, 950, 'J41PORC15', '0.00', '357.00', 0, 0, 0),
(42, 1, '2016-01-29', '2016-01-28', '2016-02-01', '101-7447', '04', 'FR4625101326', 5441, '550.00', '580.00', 1, 'Limousine', 36, 950, 'AH04132616', '0.00', '550.00', 1, 0, 0),
(41, 1, '2015-11-23', '2015-11-20', '2015-11-24', '11784-11', '47', 'FR4625174751', 74, '460.00', '465.00', 1, 'Ras', 8, 950, 'H48475115', '0.00', '460.00', 1, 0, 0),
(43, 1, '2016-02-03', '2016-02-01', '2016-02-04', '7454-75844', '05', 'FR4625474545', 15, '101.00', '103.00', 2, '', 4, 950, 'F05454516', '0.00', '101.00', 0, 0, 0),
(44, 4, '2017-02-14', '2017-02-13', '2017-02-14', 'FR36541', '07', 'CANA', 1477, '508.50', '512.60', 10, 'x50', 55, 950, 'FM07CAN17', '0.00', '508.50', 0, 1, 0),
(46, 1, '2017-04-27', '2017-04-26', '2017-04-27', '1645-1574', '17', 'FR4625100513', 1516, '573.00', '574.51', 1, 'Sallers', 11, 950, 'K17051317', '0.00', '573.00', 1, 0, 0),
(45, 1, '2017-02-13', '2017-02-13', '2017-02-14', '4117-145', '07', 'FR4612345678', 1484, '500.50', '504.50', 1, 'Sans abbat', 1, 950, 'A07567817', '45.35', '455.15', 1, 0, 0);

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

--
-- Structure de la table `fabrications_detail`
--

CREATE TABLE `fabrications_detail` (
  `Num_Fabric_Haut` int(6) NOT NULL,
  `Num_Fabric` int(4) NOT NULL,
  `Type_Fabric` int(2) NOT NULL,
  `Cate_Intrant` int(4) NOT NULL,
  `Num_plu_Intrant` int(4) NOT NULL,
  `DLC_Intrant` date NOT NULL,
  `Num_Lot_Intrant` text COLLATE utf8_bin NOT NULL,
  `Traca_Intrant` text COLLATE utf8_bin NOT NULL,
  `untie_intrant` decimal(4,2) NOT NULL,
  `Poid_Intrant` double(4,2) NOT NULL,
  `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `fabrications_detail`
--

INSERT INTO `fabrications_detail` (`Num_Fabric_Haut`, `Num_Fabric`, `Type_Fabric`, `Cate_Intrant`, `Num_plu_Intrant`, `DLC_Intrant`, `Num_Lot_Intrant`, `Traca_Intrant`, `untie_intrant`, `Poid_Intrant`, `Timestamp`) VALUES
(1, 2, 1, 11, 10002, '2016-03-03', 'F05454516', '62T', '1.00', 20.00, '2016-03-05 19:14:50'),
(2, 2, 1, 11, 10002, '2016-03-03', 'F05454516', '62T', '1.00', 15.00, '2016-03-05 19:14:59');

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

--
-- Structure de la table `fabrications_haut`
--

CREATE TABLE `fabrications_haut` (
  `Num_Fabric` int(6) NOT NULL,
  `Num_plu_Fabric` int(4) NOT NULL,
  `Cate_Fabric` int(4) NOT NULL,
  `Client_Fabric` int(3) NOT NULL,
  `Semaine_Fabric` int(2) NOT NULL,
  `Date_Fabric` date NOT NULL,
  `DLC_Fabric` date NOT NULL,
  `Num_Lot_Fabric` text COLLATE utf8_bin NOT NULL,
  `Traca_Fabric` text COLLATE utf8_bin NOT NULL,
  `Poid_Fabric` double(4,2) NOT NULL,
  `Unite_Fabric` int(2) NOT NULL,
  `Observation` text COLLATE utf8_bin NOT NULL,
  `Etat` int(1) NOT NULL,
  `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `fabrications_haut`
--

INSERT INTO `fabrications_haut` (`Num_Fabric`, `Num_plu_Fabric`, `Cate_Fabric`, `Client_Fabric`, `Semaine_Fabric`, `Date_Fabric`, `DLC_Fabric`, `Num_Lot_Fabric`, `Traca_Fabric`, `Poid_Fabric`, `Unite_Fabric`, `Observation`, `Etat`, `Timestamp`) VALUES
(1, 829, 3, 8, 5, '2016-02-01', '2016-04-01', 'H05BLVE16', '031S378PA', 15.50, 1, '31 barquettes', 0, '2016-03-02 13:58:23'),
(2, 390, 3, 8, 9, '2016-03-01', '2016-05-01', 'H09TRIP16', '60', 90.00, 1, 'x25 x60', 0, '0000-00-00 00:00:00');

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

--
-- Structure de la table `fournisseurs`
--

CREATE TABLE `fournisseurs` (
  `Num_fournisseur` int(6) NOT NULL,
  `Ident_four` varchar(10) COLLATE utf8_bin NOT NULL,
  `Nom_Fournisseur` varchar(20) COLLATE utf8_bin DEFAULT NULL,
  `adresse_1` varchar(30) COLLATE utf8_bin DEFAULT NULL,
  `Adresse_2` varchar(30) COLLATE utf8_bin DEFAULT NULL,
  `Adresse_3` varchar(30) COLLATE utf8_bin DEFAULT NULL,
  `Code_Postal` varchar(5) COLLATE utf8_bin DEFAULT NULL,
  `Ville` varchar(25) COLLATE utf8_bin DEFAULT NULL,
  `Telephone` varchar(10) COLLATE utf8_bin DEFAULT NULL,
  `Portable` varchar(10) COLLATE utf8_bin DEFAULT NULL,
  `Note` text COLLATE utf8_bin NOT NULL,
  `num_cate_four` int(3) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `fournisseurs`
--

INSERT INTO `fournisseurs` (`Num_fournisseur`, `Ident_four`, `Nom_Fournisseur`, `adresse_1`, `Adresse_2`, `Adresse_3`, `Code_Postal`, `Ville`, `Telephone`, `Portable`, `Note`, `num_cate_four`) VALUES
(1, 'ATEMAX', 'Atemax Sud Ouest', 'Groupe  AKIOLIS', 'Monbusc', '', '47520', 'Le Passage', '0826300600', '', 'Equarissage \r\nPassage le Mercredi 6h', 1),
(2, 'C2A', 'C2A Emballage', 'Parc d Entreprises Brive Ouest', 'r Jean Allary ', '', '19104', 'BRIVE LA GAILLARDE CEDEX', '0579990445', '', '', 2),
(3, 'LAFAGE', 'Lafage entretient', 'Parc activite Cahors Sud', 'Enteste 2', '', '46230', 'FONTANES', '0565353135', '', 'contact@lafage.net', 3),
(7, 'LABOVIDA', 'Labovida', '', '', '', '', '', '', '', '', 6),
(8, 'PEULE', 'Peule sarl', '', '', '', '', '', '', '', '', 8),
(9, 'SOUSSANA', 'soussana', '', '', '', '', '', '', '', '', 7),
(10, 'MIRO', 'Miro en Quercy ', 'Decodesos', '', '', '46300', 'LE VIGAN', '', '', '', 9);

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

--
-- Structure de la table `intrants`
--

CREATE TABLE `intrants` (
  `Num_entre_intrant` int(6) NOT NULL,
  `Num_Fournisseur` int(8) NOT NULL,
  `Date_Entre` date NOT NULL,
  `Date_DLC` date NOT NULL,
  `Num_Bl` text COLLATE utf8_bin NOT NULL,
  `Poids` decimal(6,2) NOT NULL,
  `num_unite` int(3) NOT NULL,
  `Num_Cate_Intrants` int(3) NOT NULL,
  `Observations` varchar(25) COLLATE utf8_bin NOT NULL,
  `Num_Plu` int(3) NOT NULL,
  `Num_Lot` varchar(10) COLLATE utf8_bin NOT NULL,
  `semaine_intrant` varchar(2) COLLATE utf8_bin NOT NULL,
  `etat` int(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `intrants`
--

INSERT INTO `intrants` (`Num_entre_intrant`, `Num_Fournisseur`, `Date_Entre`, `Date_DLC`, `Num_Bl`, `Poids`, `num_unite`, `Num_Cate_Intrants`, `Observations`, `Num_Plu`, `Num_Lot`, `semaine_intrant`, `etat`) VALUES
(1, 8, '2016-02-01', '2016-02-04', '6566', '4.00', 1, 4, 'Blanquette', 3, '16/0001', '05', 0),
(2, 8, '2016-02-01', '2016-02-04', '6566', '4.00', 1, 4, 'Blanquette', 4, '16/0002', '05', 0),
(3, 8, '2016-02-01', '2016-02-04', '6566', '4.00', 1, 4, 'Blanquette', 9, '16/0003', '05', 0),
(4, 8, '2016-02-10', '2016-02-13', '1474/774', '10.00', 1, 4, 'Trippes', 4, '16/0004', '06', 0),
(5, 8, '2016-02-10', '2016-02-13', '1474/774', '10.00', 1, 4, 'Trippes', 9, '16/0005', '06', 0),
(6, 9, '2016-02-01', '2017-01-01', '15474741', '50.00', 1, 5, '2x25kg', 1, '16/0006', '05', 0),
(7, 9, '2016-02-01', '2017-02-01', '15474741', '10.00', 1, 5, '2x5Kg', 16, '16/0007', '05', 0),
(8, 7, '2016-02-10', '2016-04-10', '1602745', '10.00', 1, 10, '1 sceau', 23, '16/0008', '06', 0),
(9, 8, '2017-05-03', '2017-05-06', '180517-122', '8.50', 1, 4, 'Blanquette', 4, '17/0009', '18', 1);

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

--
-- Structure de la table `lot`
--

CREATE TABLE `lot` (
  `num_ligne_lot` int(10) NOT NULL,
  `date_lot_decoupe` date NOT NULL,
  `num_lot_decoupe` varchar(10) COLLATE utf8_bin NOT NULL,
  `num_lot_tace_decoupe` varchar(15) COLLATE utf8_bin NOT NULL,
  `num_cate_decoupe` varchar(1) COLLATE utf8_bin NOT NULL,
  `poid_decoupe` double(6,2) NOT NULL,
  `etat_decoupe` int(1) NOT NULL,
  `solde_decoupe` tinyint(1) NOT NULL,
  `num_ligne_detail` int(6) NOT NULL,
  `observations` varchar(50) COLLATE utf8_bin NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `lot`
--

INSERT INTO `lot` (`num_ligne_lot`, `date_lot_decoupe`, `num_lot_decoupe`, `num_lot_tace_decoupe`, `num_cate_decoupe`, `poid_decoupe`, `etat_decoupe`, `solde_decoupe`, `num_ligne_detail`, `observations`) VALUES
(10, '2015-10-04', 'U40AGNX15', '275D', '2', 154.00, 0, 1, 1, ''),
(14, '2015-12-10', 'H41147815', '343CA', '1', 55.00, 0, 0, 9, ''),
(16, '2015-12-10', 'H41147815', '343CA', '1', 55.00, 0, 0, 10, ''),
(18, '2015-12-10', 'H41147815', '343CA', '1', 55.00, 0, 0, 11, ''),
(20, '2015-12-10', 'U41AGNX15', '343D', '2', 35.00, 1, 1, 12, ''),
(51, '2017-05-02', 'K17051317', '116CA121T', '3', 50.00, 0, 1, 36, 'Hache'),
(22, '2015-11-20', 'J41PORC15', '323CA', '1', 357.00, 1, 1, 13, ''),
(23, '2015-11-20', 'J41PORC15', '323CA', '1', 357.00, 0, 0, 38, ''),
(24, '2015-12-15', 'H41147815', '348CA', '1', 55.00, 0, 1, 14, ''),
(25, '2015-12-15', 'H41147815', '348CA', '1', 110.00, 0, 0, 42, ''),
(26, '2015-12-13', 'H41147815', '346D', '2', 110.00, 0, 1, 15, ''),
(27, '2015-12-13', 'H41147815', '346D', '2', 110.00, 0, 0, 42, ''),
(28, '2015-12-18', 'H41147815', '343CA351D', '2', 110.00, 0, 1, 16, ''),
(29, '2015-12-18', 'H41147815', '343CA351D', '2', 110.00, 0, 0, 42, ''),
(30, '2015-12-30', 'H41147815', '343CA363D', '2', 220.00, 1, 1, 17, ''),
(31, '2015-12-30', 'H41147815', '343CA363D', '2', 220.00, 0, 0, 42, ''),
(46, '2016-02-01', 'AH04132616', '31CA31T', '3', 50.00, 0, 0, 49, ''),
(45, '2016-02-01', 'AH04132616', '31CA31T', '3', 50.00, 1, 1, 22, ''),
(43, '2016-02-01', 'AH04132616', '31CA31D', '2', 125.00, 1, 1, 22, ''),
(42, '2016-02-01', 'AH04132616', '31CA', '1', 275.00, 0, 0, 45, ''),
(38, '2016-02-01', 'H41147815', '29CA31D', '2', 125.00, 0, 1, 21, ''),
(41, '2016-02-01', 'AH04132616', '31CA', '1', 275.00, 1, 1, 22, ''),
(40, '2016-01-29', 'AH04132616', '', '4', 580.00, 0, 0, 42, ''),
(48, '2017-04-27', 'K17051317', '116CA', '1', 250.00, 0, 1, 34, '1/2'),
(49, '2017-04-27', 'K17051317', '', '4', 573.00, 0, 0, 46, 'Sallers'),
(50, '2017-05-02', 'K17051317', '116CA121D', '2', 200.00, 0, 1, 35, '116CA');

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

--
-- Structure de la table `lot_dispo`
--

CREATE TABLE `lot_dispo` (
  `num_ligne_lot_dispo` int(6) NOT NULL,
  `num_lot_dispo` varchar(15) COLLATE utf8_bin NOT NULL,
  `num_lot_dispo_trac` varchar(15) COLLATE utf8_bin NOT NULL,
  `solde` tinyint(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `lot_dispo`
--

INSERT INTO `lot_dispo` (`num_ligne_lot_dispo`, `num_lot_dispo`, `num_lot_dispo_trac`, `solde`) VALUES
(37, 'J41103015', '44D', 1),
(24, 'C41854715', '', 1),
(34, 'U41AGNX15', '', 1),
(29, 'H41147815', '', 1),
(28, 'A41111115', '', 1),
(32, 'G41PORC15', '31CA31D', 1),
(35, 'U40AGNX15', '', 1),
(38, 'J41PORC15', '', 1),
(41, 'H48475115', '114D', 1),
(42, 'H41147815', '343CA', 1),
(43, 'J41PORC15', '323CA', 1),
(44, 'H41147815', '348CA', 1),
(45, 'AH04132616', '', 1),
(51, 'AH04132616', '33T', 1),
(50, 'AH04132616', '31CA31T', 1),
(49, 'AH04132616', '31CA', 1),
(52, 'F05454516', '', 0),
(53, 'F05454516', '62T', 0),
(54, 'FM07CAN17', '42D', 0),
(55, 'A07567817', '', 0),
(60, 'K17051317', '116CA121D', 1),
(62, 'K17051317', '116CA121T', 1),
(61, 'K17051317', '', 0);

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

--
-- Structure de la table `plu`
--

CREATE TABLE `plu` (
  `Num_PLU` int(3) NOT NULL,
  `PLU` varchar(33) COLLATE utf8_bin DEFAULT NULL,
  `Num_CatPlu` int(1) DEFAULT NULL,
  `Num_TypePlu` int(1) DEFAULT NULL,
  `attribu_plu` varchar(4) COLLATE utf8_bin NOT NULL,
  `Prix_kg` decimal(4,2) DEFAULT NULL,
  `dlc_plu` varchar(4) COLLATE utf8_bin NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `plu`
--

INSERT INTO `plu` (`Num_PLU`, `PLU`, `Num_CatPlu`, `Num_TypePlu`, `attribu_plu`, `Prix_kg`, `dlc_plu`) VALUES
(1, 'RUMSTECK', 1, 1, '', '0.00', '15'),
(2, 'BAVETTE', 1, 1, '', '0.00', '15'),
(3, 'BASSE COTE', 1, 1, '', '0.00', '15'),
(4, 'COTE A L\'OS', 1, 1, '', '0.00', '15'),
(5, 'PALERON', 1, 1, '', '0.00', '15'),
(6, 'FAUX FILET', 1, 1, '', '0.00', '15'),
(7, 'STECK EPAULE', 1, 1, '', '0.00', '15'),
(8, 'ROND DE GITE', 1, 1, '', '0.00', '15'),
(9, 'TENDE DE TRANCHE', 1, 1, '', '0.00', '15'),
(10, 'GITE A LA NOIX', 1, 1, '', '0.00', '15'),
(11, 'ONGLET', 1, 1, '', '0.00', '15'),
(12, 'PLAT DE COTE', 1, 1, '', '0.00', '15'),
(13, 'JARRET', 1, 1, '', '0.00', '15'),
(14, 'ROTI FILET', 1, 1, '', '0.00', '15'),
(15, 'ROTI', 1, 1, '', '0.00', '15'),
(16, 'ENTRECOTE', 1, 1, '', '0.00', '15'),
(17, 'STEACK', 1, 1, '', '0.00', '15'),
(19, 'BOURGUIGNON', 1, 1, '', '0.00', '15'),
(20, 'BROCHETTES', 1, 1, '', '0.00', '15'),
(21, 'VIANDE  POUR FONDU', 1, 1, '', '0.00', '10'),
(525, 'BACON', 9, 2, 'BACO', '0.00', '30'),
(23, 'GRILLADES', 1, 1, '', '0.00', '15'),
(24, 'COLLIER', 1, 1, '', '0.00', '15'),
(25, 'FILET', 1, 1, '', '0.00', '15'),
(26, 'QUEUE', 1, 1, '', '0.00', '15'),
(27, 'POIRE', 1, 1, '', '0.00', '15'),
(28, 'ARAIGNEE', 1, 1, '', '0.00', '15'),
(29, 'HAMPE', 1, 1, '', '0.00', '15'),
(30, 'JUMEAU', 1, 1, '', '0.00', '15'),
(31, 'MACREUSE', 1, 1, '', '0.00', '15'),
(32, 'PIECE NOIRE', 1, 1, '', '0.00', '15'),
(33, 'FOIE', 1, 1, '', '0.00', '5'),
(34, 'COEUR', 1, 1, '', '0.00', '5'),
(35, 'LANGUE', 1, 1, '', '0.00', '5'),
(36, 'ROGNONS', 1, 1, '', '0.00', '5'),
(37, 'JOUE', 1, 1, '', '0.00', '10'),
(38, 'STEACK LEVURE', 1, 1, '', '0.00', '15'),
(315, 'BOUDIN', 6, 2, 'BOUD', '0.00', '10'),
(40, 'MERLIN', 1, 1, '', '0.00', '15'),
(42, 'TOURNEDOS', 1, 1, '', '0.00', '15'),
(429, 'BOURGUIGNON', 1, 2, 'BOUR', '0.00', ''),
(45, 'PAVE', 1, 1, '', '0.00', '15'),
(46, 'MARINADE', 1, 1, '', '0.00', '15'),
(50, 'STEACK 1ere CATAGORIE', 1, 1, '', '0.00', '15'),
(175, 'BROCHETTE DE JEUNE BOVIN', 3, 2, '', '0.00', ''),
(53, 'PAVE RUMSTECK', 1, 1, '', '0.00', '15'),
(54, 'PAVE TENDE DE TRANCHE', 1, 1, '', '0.00', '15'),
(56, 'GRILLADE   CHURASCO', 1, 1, '', '0.00', ''),
(125, 'BROCHETTE DE VEAU', 2, 1, '', '0.00', '10'),
(60, 'CARPACCIO', 1, 1, '', '0.00', '60'),
(349, 'CHAIR A PATE DE PORC PUR', 6, 2, 'CPPP', '1.00', ''),
(101, 'COTE DE VEAU', 2, 1, '', '0.00', '15'),
(102, 'COTE DECOUVERTE DE VEAU', 2, 1, '', '0.00', '15'),
(103, 'SOUS NOIX DE VEAU', 2, 1, '', '0.00', '15'),
(104, 'QUASI DE VEAU', 2, 1, '', '0.00', '15'),
(105, 'NOIX DE VEAU', 2, 1, '', '0.00', '15'),
(106, 'TENDRON DE VEAU', 2, 1, '', '0.00', '15'),
(107, 'CAPELINE DE VEAU', 2, 1, '', '0.00', '10'),
(108, 'JARRET DE VEAU', 2, 1, '', '0.00', '15'),
(109, 'ROTI EPAULE DE VEAU', 2, 1, '', '0.00', '15'),
(110, 'ROTI FILET DE VEAU', 2, 1, '', '0.00', '15'),
(111, 'NOIX PATISSIERE DE VEAU', 2, 1, '', '0.00', '15'),
(112, 'BLANQUETTE DE VEAU', 2, 1, '', '0.00', '15'),
(114, 'ROTI DE VEAU', 2, 1, '', '0.00', '15'),
(115, 'COTE A L\'OS DE VEAU', 2, 1, '', '0.00', '15'),
(116, 'COLLIER DE VEAU', 2, 1, '', '0.00', '15'),
(117, 'COTE FILET DE VEAU', 2, 1, '', '0.00', '15'),
(118, 'ONGLET DE VEAU', 2, 1, '', '0.00', '15'),
(119, 'FOIE DE VEAU', 2, 1, '', '0.00', '5'),
(120, 'COEUR DE VEAU', 2, 1, '', '0.00', '5'),
(121, 'ESCALOPE DE VEAU', 2, 1, '', '0.00', '15'),
(122, 'ROGNON DE VEAU', 2, 1, '', '0.00', '5'),
(123, 'CERVELLE DE VEAU', 2, 1, '', '0.00', '5'),
(124, 'RIS DE VEAU', 2, 1, '', '0.00', '5'),
(545, 'CHAIR A SAUCISSE', 6, 2, 'CSSE', '1.00', ''),
(126, 'LANGUE DE VEAU', 2, 1, '', '0.00', '10'),
(127, 'PIED DE VEAU', 2, 1, '', '0.00', '10'),
(128, 'OSSO BUCCO (veau)', 2, 1, '', '0.00', '15'),
(139, 'CHIPO DE VEAU\\PORC', 2, 2, 'CHVP', '0.00', '18'),
(359, 'CHIPOLATAS AUX HERBES', 6, 2, 'CHPH', '0.00', '10'),
(131, 'GRENADIN DE VEAU', 2, 1, '', '0.00', '15'),
(132, 'QUEUE DE VEAU', 2, 1, '', '0.00', '15'),
(135, 'SAUTE DE VEAU', 2, 1, '', '0.00', '15'),
(225, 'CHIPOLATAS DE MOUTON', 4, 2, 'CHMO', '0.00', '12'),
(140, 'PAVE DE VEAU', 2, 1, '', '0.00', '15'),
(307, 'CHIPOLATAS DE PORC', 6, 2, 'CHIP', '0.00', '18'),
(138, 'CHIPOLATAS DE VEAU', 2, 2, 'CHVE', '0.00', '18'),
(355, 'CHIPOLATAS HERBES CEVIN', 6, 2, '', '1.00', ''),
(151, 'COTE DE JEUNE BOVIN', 3, 1, '', '0.00', ''),
(152, 'COTE DECOUVERTE DE JEUNE BOVIN', 3, 1, '', '0.00', ''),
(153, 'SOUS NOIX DE JEUNE BOVIN', 3, 1, '', '0.00', ''),
(154, 'QUASI DE JEUNE BOVIN', 3, 1, '', '0.00', ''),
(155, 'NOIX DE JEUNE BOVIN', 3, 1, '', '0.00', ''),
(156, 'TENDRON DE JEUNE BOVIN', 3, 1, '', '0.00', ''),
(157, 'CAPELINE DE JEUNE BOVIN', 3, 1, '', '0.00', ''),
(158, 'JARRET DE JEUNE BOVIN', 3, 1, '', '0.00', ''),
(159, 'ROTI EPAULE DE JEUNE BOVIN', 3, 1, '', '0.00', ''),
(160, 'ROTI FILET DE JEUNE BOVIN', 3, 1, '', '0.00', ''),
(161, 'NOIX PATISSIERE DE JEUNE BOVIN', 3, 1, '', '0.00', ''),
(162, 'BLANQUETTE DE JEUNE BOVIN', 3, 1, '', '0.00', ''),
(164, 'ROTI DE JEUNE BOVIN', 3, 1, '', '0.00', ''),
(165, 'COTE A L\'OS DE JEUNE BOVIN', 3, 1, '', '0.00', ''),
(166, 'COLLIER DE JEUNE BOVIN', 3, 1, '', '0.00', ''),
(167, 'COTE FILET DE JEUNE BOVIN', 3, 1, '', '0.00', ''),
(168, 'ONGLET DE JEUNE BOVIN', 3, 1, '', '0.00', ''),
(169, 'FOIE DE JEUNE BOVIN', 3, 1, '', '0.00', ''),
(170, 'COEUR DE JEUNE BOVIN', 3, 1, '', '0.00', ''),
(171, 'ESCALOPE DE JEUNE BOVIN', 3, 1, '', '0.00', ''),
(172, 'ROGNON DE JEUNE BOVIN', 3, 1, '', '0.00', ''),
(173, 'CERVELLE DE JEUNE BOVIN', 3, 1, '', '0.00', ''),
(174, 'RIS DE JEUNE BOVIN', 3, 1, '', '0.00', ''),
(41, 'CHORIZO BOEUF', 1, 2, 'CHZB', '0.00', '10'),
(176, 'LANGUE DE JEUNE BOVIN', 3, 1, '', '0.00', ''),
(178, 'PIED DE JEUNE BOVIN', 3, 1, '', '0.00', ''),
(179, 'OSSO BUCCO (JEUNE BOVIN)', 3, 1, '', '0.00', ''),
(180, 'POITRINE DE JEUNE BOVIN', 3, 1, '', '0.00', ''),
(358, 'CHORIZO A CUIRE', 6, 2, 'CZPO', '0.00', '18'),
(510, 'COPPA', 9, 2, 'COPA', '0.00', '90'),
(183, 'GRENADIN DE JEUNE BOVIN', 3, 1, '', '0.00', ''),
(184, 'QUEUE DE JEUNE BOVIN', 3, 1, '', '0.00', ''),
(185, 'SAUTE DE JEUNE BOVIN', 3, 1, '', '0.00', ''),
(562, 'FILET PORC SECHE', 9, 2, 'FIPS', '0.00', '90'),
(405, 'FOIE PORC', 6, 1, '', '0.00', ''),
(320, 'FRITONS DE PORC', 6, 2, 'FRPO', '0.00', '15'),
(201, 'GIGOT D\'AGNEAU', 4, 1, '', '0.00', '12'),
(202, 'EPAULE D\'AGNEAU', 4, 1, '', '0.00', '12'),
(203, 'COLLIER D\'AGNEAU', 4, 1, '', '0.00', '12'),
(204, 'RAGOUT D\'AGNEAU', 4, 1, '', '0.00', '12'),
(205, 'COTELLETTES D\'AGNEAU', 4, 1, '', '0.00', '12'),
(206, 'SCELLE D\'AGNEAU', 4, 1, '', '0.00', '12'),
(207, 'CARRE DECOUVERT D\'AGNEAU', 4, 1, '', '0.00', '12'),
(208, 'FOIE D\'AGNEAU', 4, 1, '', '0.00', '5'),
(209, 'COEUR D\'AGNEAU', 4, 1, '', '0.00', '5'),
(210, 'ROGNON D\'AGNEAU', 4, 1, '', '0.00', '5'),
(211, 'COTELETTE FILET D\'AGNEAU', 4, 1, '', '0.00', '12'),
(212, 'GIGOT DE CHEVREAU', 5, 1, '', '0.00', '10'),
(213, 'EPAULE DE CHEVREAU', 5, 1, '', '0.00', '10'),
(214, 'CARRE COLLIER DE CHEVREAU', 5, 1, '', '0.00', '10'),
(216, 'GIGOT DE CHEVRE', 5, 1, '', '0.00', '10'),
(217, 'EPAULE DE CHEVRE', 5, 1, '', '0.00', '10'),
(218, 'CARRE DE CHEVRE', 5, 1, '', '0.00', '10'),
(219, 'COEUR&FOIE DE CHEVRE', 5, 1, '', '0.00', '5'),
(220, 'GRILLADE AGNEAU', 4, 1, '', '0.00', '12'),
(221, 'CARRE AVEC L\'OS D\'AGNEAU', 4, 1, '', '0.00', '12'),
(223, 'Epaule Facon Gigot', 4, 1, '', '0.00', '12'),
(224, 'POITRINE D\'AGNEAU', 4, 1, '', '0.00', '12'),
(187, 'HACHEE DE JEUNE BOVIN', 3, 2, 'HAJB', '1.00', ''),
(227, 'BROCHETTES ABATS', 4, 1, '', '0.00', '5'),
(228, 'EPAULE D\'AGNEAU ROULEE', 4, 1, '', '0.00', '12'),
(229, 'GIGOT D\'AGNEAU TRANCHE', 4, 1, '', '0.00', '12'),
(230, 'COTELETTE DECOUVERTE AGNEAU', 4, 1, '', '0.00', '12'),
(231, 'COTELETTE 1ere AGNEAU', 4, 1, '', '0.00', '12'),
(232, 'EPAULE D\'AGNEAU TRANCHEE', 4, 1, '', '0.00', '12'),
(233, 'CARRE D\'AGNEAU', 4, 1, '', '0.00', '12'),
(301, 'FILET MIGNON DE PORC', 6, 1, '', '0.00', '10'),
(302, 'ROTI FILET DE PORC', 6, 1, '', '0.00', '10'),
(303, 'ROTI ECHINE DE PORC', 6, 1, '', '0.00', '10'),
(304, 'COTELLETTE ECHINE PORC', 6, 1, '', '0.00', '10'),
(305, 'COTELETTE FILET DE PORC', 6, 1, '', '0.00', '10'),
(137, 'HACHEE DE VEAU', 2, 2, 'HAVE', '0.00', '10'),
(560, 'JAMBON CUIT', 9, 2, 'JACU', '0.00', '40'),
(377, 'JAMBON CUIT SUPERIEUR', 6, 2, 'JABO', '0.00', '14'),
(311, 'PORCELET', 6, 1, '', '0.00', '10'),
(313, 'JAMBON FRAIS', 6, 1, '', '0.00', '10'),
(314, 'PETIT SALE DE PORC', 6, 1, '', '0.00', '10'),
(519, 'JAMBON SEC', 9, 2, 'JSEC', '0.00', '90'),
(316, 'VENTRECHE PORC TRANCHEE', 6, 1, '', '0.00', '10'),
(520, 'JAMBON SEC TRANCHE', 9, 2, 'JSEC', '0.00', '90'),
(412, 'LONGE ECHINE', 6, 2, '', '0.00', ''),
(413, 'LONGE FILET', 6, 2, '', '0.00', ''),
(321, 'PIEDS DE PORC', 6, 1, '', '0.00', '10'),
(322, 'JARRET DE PORC', 6, 1, '', '0.00', '10'),
(323, 'FOIE DE PORC', 6, 1, '', '0.00', '5'),
(324, 'COEUR DE PORC', 6, 1, '', '0.00', '5'),
(325, 'ROGNON DE PORC', 6, 1, '', '0.00', '5'),
(326, 'LANGUE DE PORC', 6, 1, '', '0.00', '5'),
(327, 'SAUTE DE PORC', 6, 1, '', '0.00', '10'),
(22, 'MERGUEZ', 1, 1, '', '0.00', '10'),
(329, 'CARBONADE DE PORC', 6, 2, 'CAPO', '0.00', '10'),
(330, 'PLAT DE COTE', 6, 1, '', '0.00', ''),
(331, 'COUENNE DE PORC', 6, 1, '', '0.00', '10'),
(332, 'EPAULE DE PORC', 6, 1, '', '0.00', '10'),
(333, 'ROTI DE PORC', 6, 1, '', '0.00', '10'),
(335, 'PAVE DE PORC', 6, 1, '', '0.00', '10'),
(336, 'GRILLADE DE PORC', 6, 1, '', '0.00', '10'),
(337, 'ROUELLE PORC', 6, 1, '', '0.00', '10'),
(338, 'GORGE DE PORC', 6, 1, '', '0.00', '10'),
(339, 'TOILE DE PORC', 6, 1, '', '0.00', '5'),
(340, 'TETE DE PORC', 6, 1, '', '0.00', '5'),
(341, 'BROCHETTE D\'ABAT DE PORC', 6, 1, '', '0.00', ''),
(343, 'LONGE DE PORC', 6, 1, '', '0.00', '10'),
(226, 'MERGUEZ DE BREBIS', 4, 2, '', '1.00', ''),
(345, 'ROTI FILET A L\'OS DE PORC', 6, 1, '', '0.00', '10'),
(346, 'ROTI ECHINE A L\'OS DE PORC', 6, 1, '', '0.00', '10'),
(348, 'COUSTELLOUS DE PORC', 6, 1, '', '0.00', '10'),
(387, 'POITRINE DE PORC', 6, 1, '', '0.00', '10'),
(350, 'P?TE CREPINETTE DE PORC', 6, 1, '', '0.00', ''),
(351, 'GRAS DE PORC', 6, 1, '', '0.00', '10'),
(352, 'CARRE VENTRECHE  DE PORC', 6, 1, '', '0.00', '10'),
(353, 'CARRE VENTRECHE DECOUENNE DE PORC', 6, 1, '', '0.00', '10'),
(371, 'PATE DE CAMPAGNE', 6, 2, 'PACA', '0.00', '30'),
(318, 'PATE DE CAMPAGNE AU FOUR', 6, 2, 'PACF', '0.00', ''),
(370, 'PATE DE TETE', 6, 2, 'PATE', '0.00', '15'),
(319, 'PATE DE TETE DE PORC', 6, 2, 'PAPO', '0.00', '15'),
(388, 'PAUPIETTE DU FOURNEL', 9, 2, 'PAFO', '0.00', '60'),
(361, 'PAUPIETTE DE PORC', 6, 2, 'PPOR', '0.00', '14'),
(181, 'PAUPILLETTE DE JEUNE BOVIN', 3, 2, '', '0.00', ''),
(363, 'CARBONADE DE PORC', 6, 1, '', '0.00', ''),
(129, 'PAUPILLETTE DE VEAU', 2, 1, '', '0.00', '10'),
(367, 'OREILLES DE PORC', 6, 1, '', '0.00', '10'),
(368, 'QUEUE DE PORC', 6, 1, '', '0.00', '10'),
(369, 'LARD DE PORC', 6, 1, '', '0.00', '10'),
(142, 'Poitrine de Veau de 7hrs', 2, 2, 'PV7H', '0.00', '15'),
(403, 'POITRINE PORC', 6, 2, '', '0.00', ''),
(373, 'CHORIZO SEC DE PORC', 6, 2, 'CZSP', '0.00', '90'),
(374, 'TRAVERS DE PORC', 6, 1, '', '0.00', '10'),
(375, 'LARDON NATURE PORC', 6, 1, '', '0.00', '10'),
(317, 'POITRINE PORC TRANCHEE', 6, 1, '', '0.00', '10'),
(385, 'MERGUEZ AGNEAU PORC', 9, 2, 'MZAP', '0.00', '18'),
(378, 'TALON JAMBON SEC', 6, 1, '', '0.00', ''),
(380, 'ESCALOPE DE PORC', 6, 1, '', '0.00', ''),
(188, 'POT AU FEU JEUNE BOVIN', 3, 2, 'PFJB', '0.00', ''),
(141, 'POT AU FEU VEAU', 2, 1, '', '0.00', '15'),
(44, 'POT AUX FEU', 1, 1, '', '0.00', '15'),
(347, 'VENTRECHE DE PORC', 6, 1, '', '0.00', '10'),
(419, 'PREP HACHEE DE BOEUF', 1, 2, '', '1.00', ''),
(18, 'PREPARATION HACHEE', 1, 2, 'HACH', '17.90', '15'),
(407, 'ROGNON PORC', 6, 2, '', '0.00', ''),
(404, 'JARRET PORC', 6, 1, '', '0.00', ''),
(52, 'ROND DE BOEUF SECHE', 1, 1, '', '0.00', '90'),
(512, 'ROTI DE PORC CUIT', 6, 2, '', '0.00', ''),
(409, 'TETE PORC', 6, 1, '', '0.00', ''),
(39, 'SAUCISSE BOEUF', 1, 1, '', '0.00', '21'),
(414, 'COUENNE DE PORC', 6, 1, '', '0.00', ''),
(357, 'SAUCISSE A CUIRE CEVIN', 6, 2, '', '1.00', ''),
(417, 'MAIGRE DE PORC', 6, 1, '', '0.00', ''),
(344, 'SAUCISSE DE COUENNES DE PORC', 6, 2, '', '1.00', ''),
(186, 'SAUCISSE DE JEUNE BOVIN', 3, 2, 'SSJB', '1.00', ''),
(182, 'SAUCISSE DE JEUNE BOVIN SAUGE', 3, 2, '', '1.00', ''),
(306, 'SAUCISSE DE PORC', 6, 2, 'SSPO', '0.00', '18'),
(136, 'SAUCISSE DE VEAU', 2, 2, 'SSVE', '17.50', '15'),
(130, 'SAUCISSE DE VEAU SAUGE', 2, 2, 'SSVS', '17.50', '15'),
(381, 'SAUCISSE SECHE BOEUF', 1, 2, '', '1.00', ''),
(508, 'SAUCISSE SECHE DE BREBIS', 4, 2, '', '1.00', ''),
(309, 'SAUCISSE SECHE DE PORC', 6, 2, 'SSSP', '0.00', '90'),
(143, 'SAUCISSE VEAU TRUFFEE', 2, 2, 'SSVT', '0.00', '8'),
(501, 'Saucisson Sec B?uf', 1, 2, '', '1.00', ''),
(507, 'Saucisson Sec Jeune Bovin', 2, 2, '', '1.00', ''),
(500, 'Saucisson Sec Porc', 6, 2, '', '1.00', ''),
(502, 'Saucisson Sec Veau', 2, 2, '', '1.00', ''),
(189, 'SAUTE DE JEUNE BOVIN', 3, 2, '', '0.00', ''),
(526, 'JARRET JAMBON SEC', 6, 1, '', '0.00', ''),
(442, 'SAUTE DE VEAU', 3, 2, '', '0.00', ''),
(51, 'TISON DE PEGOUY', 1, 1, '', '0.00', '90'),
(390, 'TRIPES DU FOURNEL', 6, 2, 'TRIP', '0.00', '60'),
(561, 'FILET MIGNON SECHE', 9, 2, 'FMSE', '0.00', '90'),
(527, 'VENTRECHE PORC SECHEE', 6, 2, '', '0.00', ''),
(563, 'Entre carcasse', 1, 4, '', '2.06', '30'),
(564, 'Entre carcasse', 2, 4, '', '2.06', '30'),
(565, 'Entre carcasse', 3, 4, '', '2.06', '30'),
(566, 'Entre carcasse', 4, 4, '', '2.06', '30'),
(567, 'Entre carcasse', 5, 4, '', '2.06', '30'),
(47, 'SAUCISSE SECHE BOEUF', 1, 2, 'SSBO', '0.00', '180'),
(48, 'SAUCISSE BOEUF', 1, 2, 'SSCB', '0.00', '15'),
(90, 'VIANDE POUR ANIMAUX', 1, 1, '', '0.00', '15'),
(91, 'Tibonne', 1, 1, '', '0.00', '15'),
(113, 'SAUSSICE DE VEAU', 2, 1, '', '0.00', '10'),
(133, 'GRENADIN', 2, 1, '', '0.00', '15'),
(134, 'QUEUE', 2, 1, '', '0.00', '15'),
(144, 'TETE DE VEAU', 2, 1, '', '0.00', '10'),
(145, 'SAUCISSE DE VEAU POCHEE', 2, 2, 'SSVP', '0.00', '10'),
(146, 'SAUCISSE DE VEAU', 2, 2, 'SSVE', '0.00', '10'),
(215, 'RAGOUT CHEVREAU', 5, 1, '', '0.00', '10'),
(222, 'Cote Bordelaise', 4, 1, '', '0.00', '12'),
(234, 'RIS D\'AGNEAU', 4, 1, '', '0.00', '5'),
(235, 'SAUCISSE CHEVRE/PORC', 4, 2, 'SSCP', '0.00', '90'),
(236, 'SELLE D\'AGNEAU', 4, 1, '', '0.00', '12'),
(237, 'SOURIS D\'AGNEAU', 4, 1, '', '0.00', '12'),
(238, 'COTELETTE CHEVREAU', 4, 1, '', '0.00', '10'),
(239, 'POITRINE ROULEE', 4, 1, '', '0.00', '12'),
(240, 'FOIE DE CHEVREAU', 5, 1, '', '0.00', '10'),
(241, 'EPAULE DESOSSEE', 4, 1, '', '0.00', '12'),
(308, 'CHAIR A SAUCISSE DE PORC', 6, 2, 'CHSS', '0.00', '18'),
(310, 'SAUCISSON SEC DE PORC', 6, 2, 'SCOP', '0.00', '90'),
(312, 'VIANDE PORC', 6, 1, '', '0.00', '10'),
(334, 'CHAIR A PATE DE PORC', 6, 2, 'CHPA', '0.00', '10'),
(386, 'ROTI AUX PRUNEAUX', 6, 2, 'RPPR', '0.00', '10'),
(389, 'BLANQUETTE DU FOURNEL', 9, 2, 'BLAV', '0.00', '60'),
(391, 'CARBONNADE FACON FLAMENDE', 6, 2, 'CARF', '0.00', '60'),
(392, 'ROGNONS VEAU AU PORTO', 9, 2, 'RVPO', '0.00', '60'),
(393, 'SAUCISSE PORC/BOEUF', 6, 2, 'SSPB', '0.00', '21'),
(394, 'SAUTE DE BOEUF', 6, 1, '', '0.00', '60'),
(395, 'JAMBON CUIT A BRAISER', 6, 1, '', '0.00', '14'),
(396, 'BOLOGNAISE', 9, 2, 'BOLO', '0.00', '60'),
(397, 'SAUCISSE TRUFFEE', 6, 2, 'SSPT', '0.00', '15'),
(398, 'NOIX JAMBON PORC', 6, 1, '', '0.00', '10'),
(513, 'TRIPOUX BOURIAN', 9, 2, 'TRBO', '0.00', '21'),
(518, 'JAMBON COUPE BAYONNE', 9, 2, 'JSEC', '0.00', '90'),
(521, 'SAUCISSON SEC DES BOURRIAN', 9, 2, 'SCBO', '0.00', '90'),
(547, 'PATE DE TETE DE PORC', 9, 2, 'PTPO', '0.00', '21'),
(548, 'SAUCISSE AGNEAU', 9, 2, 'SSAG', '0.00', '15'),
(550, 'CHIPO 5BAIES', 9, 2, 'CHI5', '0.00', '15'),
(551, 'SAUCISSON VEAU\\FOIE', 9, 2, 'SCVF', '0.00', '90'),
(552, 'SAUCISSON VEAU', 9, 2, 'SCVE', '0.00', '90'),
(553, 'SAUCISSON PORC\\VEAU', 9, 2, 'SCVP', '0.00', '90'),
(568, 'Chevreau fa?n Tagine', 9, 2, 'CHFT', '0.00', '60'),
(569, 'MERGUEZ PUR BOEUF', 9, 2, 'MGZB', '0.00', '10'),
(570, 'POITRINE DE VEAU FARCIE', 9, 2, 'PVFE', '0.00', '60'),
(571, 'SAUCISSE PUR BOEUF', 9, 2, 'SSBO', '0.00', '10'),
(573, 'JOUE DE BOEUF BRAISEE', 9, 2, 'JBBR', '0.00', '60'),
(574, 'CHAIRE A FARCIR', 9, 2, 'CHFA', '0.00', '15'),
(575, 'BOEUF BOURGUIGNON', 9, 2, 'BOBO', '0.00', '60'),
(576, 'CREPINETTE', 9, 2, 'CREP', '0.00', '8'),
(577, 'Crepinette foie gras', 9, 2, 'CRFG', '0.00', '10'),
(578, 'ROTI au FOIE GRAS', 9, 2, 'ROFG', '0.00', '10'),
(579, 'ROTI au PRUNEAU', 9, 2, 'ROPR', '0.00', '10'),
(580, 'SAUCISSON', 9, 2, 'SSCO', '0.00', '90'),
(583, 'SAUCISSE SECHE PORC', 9, 2, 'SSPS', '0.00', '90'),
(584, 'ROTI ORLOFF', 9, 2, 'ROOR', '0.00', '10'),
(590, 'PRESSE DE TETE', 9, 2, 'TEPR', '0.00', '21'),
(591, 'SAUCISSON A L AIL', 9, 2, 'SSCA', '0.00', '30'),
(592, 'Farce a la Pistache', 9, 2, 'FAPI', '0.00', '8'),
(593, 'Farce F.gras Pain epice', 9, 2, 'FAFG', '0.00', '8'),
(599, 'SAUCISSE SECHE', 9, 2, 'SSES', '0.00', '90'),
(600, 'BOEUF AU CAROTTES', 9, 2, 'BOCA', '0.00', '15'),
(601, 'COTE', 3, 1, '', '0.00', '15'),
(602, 'COTE DECOUVERTE', 3, 1, '', '0.00', '15'),
(603, 'SOUS NOIX', 3, 1, '', '0.00', '15'),
(604, 'QUASI', 3, 1, '', '0.00', '15'),
(605, 'NOIX', 3, 1, '', '0.00', '15'),
(606, 'TENDRON', 3, 1, '', '0.00', '15'),
(607, 'CAPELINE', 3, 1, '', '0.00', '15'),
(608, 'JARRET', 3, 1, '', '0.00', '15'),
(609, 'ROTI EPAULE', 3, 1, '', '0.00', '15'),
(610, 'ROTI FILET', 3, 1, '', '0.00', '15'),
(611, 'NOIX PATISSIERE', 3, 1, '', '0.00', '15'),
(612, 'BLANQUETTE', 3, 1, '', '0.00', '15'),
(613, 'SAUCISSE', 3, 2, 'SSJB', '0.00', '15'),
(614, 'ROTI', 3, 1, '', '0.00', '15'),
(615, 'COTE A L\'OS', 3, 1, '', '0.00', '15'),
(616, 'COLLIER', 3, 1, '', '0.00', '15'),
(617, 'COTE FILET', 3, 1, '', '0.00', '15'),
(618, 'ONGLET', 3, 1, '', '0.00', '15'),
(619, 'FOIE', 3, 1, '', '0.00', '5'),
(620, 'COEUR', 3, 1, '', '0.00', '5'),
(621, 'ESCALOPE', 3, 1, '', '0.00', '15'),
(622, 'ROGNON', 3, 1, '', '0.00', '5'),
(623, 'CERVELLE', 3, 1, '', '0.00', '5'),
(624, 'RIS', 3, 1, '', '0.00', '5'),
(625, 'BROCHETTE', 3, 1, '', '0.00', '10'),
(626, 'LANGUE', 3, 1, '', '0.00', '10'),
(627, 'PIED', 3, 1, '', '0.00', '10'),
(628, 'OSSO BUCCO', 3, 1, '', '0.00', '15'),
(629, 'PAUPIETTE', 3, 2, 'PAJB', '0.00', '15'),
(630, 'SAUCISSE J.B. SAUGE', 3, 2, 'SJBS', '0.00', '10'),
(631, 'GRENADIN', 3, 1, '', '0.00', '15'),
(632, 'QUEUE', 3, 1, '', '0.00', '15'),
(633, 'TOURNEDOS', 3, 1, '', '0.00', '15'),
(634, 'PAVE', 3, 1, '', '0.00', '15'),
(650, 'CHIPO DE VEAU', 3, 2, 'CHJB', '0.00', '15'),
(660, 'Saucisse au foie gras', 3, 2, 'SJBF', '0.00', '10'),
(700, 'CHEVAL', 8, 1, '', '0.00', '15'),
(701, 'STEACK DE CHEVAL', 8, 1, '', '0.00', '15'),
(702, 'ROTI DE CHEVAL', 8, 1, '', '0.00', '15'),
(703, 'FILET DE CHEVAL', 8, 1, '', '0.00', '15'),
(704, 'PREP.HACHE DE CHEVAL', 8, 1, '', '0.00', '15'),
(705, 'LANGUE DE CHEVAL', 8, 1, '', '0.00', '15'),
(706, 'COEUR DE CHEVAL', 8, 1, '', '0.00', '15'),
(707, 'JOUE DE CHEVAL', 8, 1, '', '0.00', '15'),
(708, 'FAUX FILET DE CHEVAL', 8, 1, '', '0.00', '15'),
(709, 'DAUBE DE CHEVAL', 8, 1, '', '0.00', '15'),
(710, 'ENTRECOTE DE CHEVAL', 8, 1, '', '0.00', '15'),
(711, 'HAMPE DE CHEVAL', 8, 1, '', '0.00', '15'),
(712, 'BASSE COTE CHEVAL', 8, 1, '', '0.00', '15'),
(713, 'COTE OS CHEVAL', 8, 1, '', '0.00', '15'),
(714, 'RUMSTEACK CHEVAL', 8, 1, '', '0.00', '15'),
(715, 'ONGLET CHEVAL', 8, 1, '', '0.00', '15'),
(716, 'LEVURE DE CHEVAL', 8, 1, '', '0.00', '15'),
(717, 'BAVETTE DE CHEVAL', 8, 1, '', '0.00', '15'),
(718, 'TOURNEDOS CHEVAL', 8, 1, '', '0.00', '15'),
(719, 'ROTI FILET CHEVAL', 8, 1, '', '0.00', '15'),
(720, 'SAUCISSE CHEVAL', 8, 2, 'SSCH', '0.00', '15'),
(721, 'SAUCISSE CHEVAL EPICEE', 8, 2, 'SCHE', '0.00', '15'),
(750, 'SAUCISSON DE CHEVAL', 8, 2, 'SOCH', '0.00', '90'),
(751, 'SAUCISSE SECHE CHEVAL', 8, 2, 'SCHS', '0.00', '90'),
(752, 'Rond de cheval seche', 8, 2, 'RCHS', '0.00', '90'),
(753, 'VIANDE SECHEE CHEVAL', 8, 2, 'VCHS', '0.00', '90'),
(800, 'Veau Marengo', 9, 2, 'VEMA', '0.00', '60'),
(801, 'Polenta a la noix', 9, 2, 'PONO', '0.00', '30'),
(802, 'Puree de celeri', 9, 2, 'PUCE', '0.00', '60'),
(803, 'Carbonnade porc carottes', 9, 2, 'CAPC', '0.00', '60'),
(804, 'Parmentier de Boeuf', 9, 2, 'PABO', '0.00', '60'),
(805, 'RISOTTO', 9, 2, 'RISO', '0.00', '60'),
(806, 'Navarin agneau', 9, 2, 'NAAG', '0.00', '60'),
(807, 'Tripes sauce epicee', 9, 2, 'TRSE', '0.00', '60'),
(808, 'Langue porc picante', 9, 2, 'LPSP', '0.00', '30'),
(809, 'Langue Sauce picante', 9, 2, 'LBSP', '0.00', '60'),
(810, 'Paleron bourgeoise', 9, 2, 'PABO', '0.00', '60'),
(811, 'Tete veau pt legumes', 9, 2, 'TVPL', '0.00', '60'),
(812, 'Pot au feu printanier', 9, 2, 'PFPR', '0.00', '60'),
(813, 'Roti de porc Espagnol', 9, 2, 'RPES', '0.00', '30'),
(814, 'Choux farci', 9, 2, 'CHFR', '0.00', '30'),
(816, 'Cotes de porc farcies', 9, 2, 'CPFA', '0.00', '30'),
(817, 'P de terre robe des champs', 9, 2, 'PDTC', '0.00', '30'),
(818, 'POITRINE DE VEAU FARCIE', 9, 2, 'PVFA', '0.00', '21'),
(819, 'Saucisses confites', 9, 2, 'SSCO', '0.00', '90'),
(820, 'POITRINE AGNEAU FARCIE', 9, 2, 'POAF', '0.00', '21'),
(821, 'TAJINE VEAU FRUITS SEC', 9, 2, 'TVFS', '0.00', '21'),
(822, 'EPAULE AGNEAU FARCIE', 9, 2, 'EAFE', '0.00', '21'),
(823, 'Bourguignon aux Legumes', 9, 2, 'BOLE', '0.00', '60'),
(824, 'Cassoulet des Fermes', 9, 2, 'CASS', '0.00', '60'),
(825, 'Sauccisses aux Lentilles', 9, 2, 'SSLE', '0.00', '60'),
(826, 'ENCHAUD des fermes', 9, 2, 'ENCH', '0.00', '60'),
(827, 'Poirtine veau aux cepes', 9, 2, 'POVC', '0.00', '60'),
(828, 'SAUCISSES CONFIES', 9, 2, 'SSCO', '0.00', '90'),
(829, 'Blanquette de veau', 9, 2, 'BLVE', '0.00', '90'),
(830, 'Lasagne', 9, 2, 'LASA', '0.00', '90'),
(831, 'Blanquette aux legumes', 9, 2, 'BLAL', '0.00', '90'),
(832, 'Porc saute au Caramel', 9, 2, 'PSCA', '0.00', '90'),
(833, 'Rotis de Porc Caramel', 9, 2, 'ROPC', '0.00', '90'),
(834, 'Hachis Parmenier', 9, 2, 'HAPA', '0.00', '90'),
(835, 'Paupiettes de veau curry', 9, 2, 'PAVC', '0.00', '90'),
(836, 'Paupiettes de veau cepes', 9, 2, 'PAVE', '0.00', '90'),
(837, 'ROTI DE PORC AU FOUR', 9, 2, 'RPAF', '0.00', '90'),
(838, 'Epaule agneau aux cepes', 9, 2, 'EAAC', '0.00', '90'),
(839, 'MOUSSE FOIE DE PORC', 9, 2, 'MOFP', '0.00', '40'),
(840, 'RILLETTES PUR PORC', 9, 2, 'RIPP', '0.00', '28'),
(841, 'PATE DE TETE PUR PORC', 9, 2, 'PAPP', '0.00', '28'),
(842, 'TETE DE VEAU EN GELEE', 9, 2, 'TVEG', '0.00', '28'),
(843, 'Cuisine de Coeur', 9, 2, 'CUCO', '0.00', '60'),
(844, 'Boudin blanc', 9, 2, 'BOBL', '0.00', '60'),
(10001, 'Viande de Vache', 1, 1, '', NULL, '8'),
(10002, 'Viande de Veau', 2, 1, '', NULL, '8'),
(10003, 'Viande de Jeune Bovin', 3, 1, '', NULL, '8'),
(10004, 'Viande d\'agneau', 4, 1, '', NULL, '8'),
(10006, 'Viande de Porc', 6, 1, '', NULL, '8'),
(10008, 'Viande de cheval', 8, 1, '', NULL, '8'),
(900, 'Magret de Canard', 10, 1, '', NULL, '21'),
(901, 'Cuisses de Canard', 10, 1, '', NULL, '21'),
(902, 'Manchons de Canard', 10, 1, '', NULL, '21'),
(903, 'Aiguillettes', 10, 1, '', NULL, '21'),
(905, 'Foie gras de Canard', 10, 1, '', NULL, '21'),
(906, 'Coeur de Canard', 10, 1, '', NULL, '21'),
(904, 'Cou de Canard', 10, 1, '', NULL, '21'),
(907, 'Filet de Canard', 10, 1, '', NULL, '21'),
(908, 'Parrure', 10, 1, '', NULL, '21'),
(909, 'Cotes de Canard', 10, 1, '', NULL, '21');

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

--
-- Structure de la table `plu_intrant`
--

CREATE TABLE `plu_intrant` (
  `num_plu_intrant` int(4) NOT NULL,
  `nom_plu_intrant` varchar(33) COLLATE utf8_bin DEFAULT NULL,
  `num_cate_intrant` int(4) DEFAULT NULL,
  `num_unite` int(1) DEFAULT NULL,
  `dlc_plu_intrant` int(3) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `plu_intrant`
--

INSERT INTO `plu_intrant` (`num_plu_intrant`, `nom_plu_intrant`, `num_cate_intrant`, `num_unite`, `dlc_plu_intrant`) VALUES
(1, 'Sel fin', 5, 2, 360),
(2, 'Poivre noir Grain', 5, 2, 360),
(3, 'Carottes', 4, 1, 3),
(4, 'Poireaux', 4, 1, 3),
(5, 'Gras de proc', 3, 1, 15),
(6, 'Poitrine de veau', 2, 1, 15),
(9, 'Oignons', 4, 1, 3),
(10, 'D.Concentre de tomate', 8, 1, 180),
(11, 'Vin Blanc', 8, 3, 360),
(12, 'Vin Rouge', 8, 3, 360),
(13, 'Tomate concassees ', 8, 1, 180),
(14, 'Poivre Blanc grain', 5, 2, 360),
(15, 'Poivre Blanc Poudre', 5, 2, 360),
(16, 'Poivre noir poudre', 5, 2, 360),
(17, 'Gros Sel de Guerande', 5, 2, 360),
(18, 'Gros Sel', 5, 2, 360),
(19, 'Laurier Poudre', 5, 2, 360),
(20, 'Laurie feuille', 5, 2, 360),
(21, 'Thym', 5, 2, 360),
(22, 'Thym poudre', 5, 2, 360),
(23, 'Boyaux Porc 30/32', 10, 1, 60),
(24, 'Boyaux Mouton 22/26', 10, 1, 60),
(25, 'Chaudin 50/55', 10, 1, 60);

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

--
-- Structure de la table `production`
--

CREATE TABLE `production` (
  `Num_ligne` int(6) NOT NULL,
  `Num_Client` int(3) NOT NULL,
  `Num_plu` int(3) NOT NULL,
  `Date_ligne` date NOT NULL,
  `Qte_produite` decimal(4,2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Structure de la table `quantitative_detail`
--

CREATE TABLE `quantitative_detail` (
  `Num_ligne_qtv_det` int(11) NOT NULL,
  `Num_ligne_qtv` int(11) NOT NULL,
  `plu` int(3) NOT NULL,
  `poids_qtv` decimal(6,2) NOT NULL,
  `qte_qtv` int(6) NOT NULL,
  `decl` int(1) NOT NULL,
  `cloture` tinyint(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Contenu de la table `quantitative_detail`
--

INSERT INTO `quantitative_detail` (`Num_ligne_qtv_det`, `Num_ligne_qtv`, `plu`, `poids_qtv`, `qte_qtv`, `decl`, `cloture`) VALUES
(1, 1, 905, '24.75', 50, 0, 1),
(10, 1, 901, '0.68', 6, 1, 1),
(3, 1, 901, '12.47', 94, 0, 1),
(4, 1, 903, '4.87', 100, 0, 1),
(5, 1, 902, '12.85', 95, 0, 1),
(6, 1, 900, '2.85', 5, 1, 1),
(7, 1, 906, '2.50', 50, 0, 1),
(8, 1, 900, '46.25', 97, 0, 1),
(9, 1, 902, '0.55', 5, 1, 1);

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

--
-- Structure de la table `quantitative_haut`
--

CREATE TABLE `quantitative_haut` (
  `Num_ligne_qtv` int(11) NOT NULL,
  `date_decoupe` date NOT NULL,
  `semaine_decoupe` tinyint(2) NOT NULL,
  `num_client` int(3) NOT NULL,
  `num_lot` varchar(10) NOT NULL,
  `tracabilite` varchar(20) NOT NULL,
  `poid_decoupe` decimal(6,0) NOT NULL,
  `cloture` tinyint(1) NOT NULL,
  `observations` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Contenu de la table `quantitative_haut`
--

INSERT INTO `quantitative_haut` (`Num_ligne_qtv`, `date_decoupe`, `semaine_decoupe`, `num_client`, `num_lot`, `tracabilite`, `poid_decoupe`, `cloture`, `observations`) VALUES
(1, '2017-02-14', 7, 55, 'FM07CAN17', '', '509', 0, 'x50');

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

--
-- Structure de la table `saisies_abat`
--

CREATE TABLE `saisies_abat` (
  `num_ligne` int(6) NOT NULL,
  `num_certificat` varchar(11) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `date_saisie` date NOT NULL,
  `num_abat` int(5) NOT NULL,
  `poid_saisie` decimal(6,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Contenu de la table `saisies_abat`
--

INSERT INTO `saisies_abat` (`num_ligne`, `num_certificat`, `date_saisie`, `num_abat`, `poid_saisie`) VALUES
(1, '574454', '2015-10-07', 1744141, '25.00'),
(2, '14183940', '2017-02-13', 417174, '78.45'),
(3, '1418947', '2017-02-13', 1477, '3.60'),
(4, 'DSV1478', '2017-02-14', 1484, '45.35');

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

--
-- Structure de la table `table_dechets`
--

CREATE TABLE `table_dechets` (
  `num_ligne_dechets` int(1) NOT NULL,
  `Num_bon_dechets` varchar(12) COLLATE utf8_bin NOT NULL,
  `Num_prestataire` int(1) NOT NULL,
  `num_cate_dechets` int(1) NOT NULL,
  `mrs` int(1) NOT NULL,
  `poids_dechets` decimal(6,2) NOT NULL,
  `sem_dechets` varchar(2) COLLATE utf8_bin NOT NULL,
  `date_enleve_dechets` date NOT NULL,
  `observations` text COLLATE utf8_bin NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `table_dechets`
--

INSERT INTO `table_dechets` (`num_ligne_dechets`, `Num_bon_dechets`, `Num_prestataire`, `num_cate_dechets`, `mrs`, `poids_dechets`, `sem_dechets`, `date_enleve_dechets`, `observations`) VALUES
(1, '954750', 1, 3, 0, '550.00', '40', '2015-09-30', ''),
(2, '954774', 1, 1, 1, '45.00', '41', '2015-10-07', ''),
(3, '15-954774', 1, 1, 1, '50.00', '40', '2015-09-29', ''),
(8, '7474-20', 1, 1, 1, '40.00', '41', '2015-10-05', 'none'),
(5, '8574-14', 1, 3, 0, '150.00', '40', '2015-10-01', 'none'),
(6, '0985-11', 1, 3, 0, '850.00', '40', '2015-09-30', ''),
(9, '7474-15', 1, 3, 0, '740.00', '40', '2015-10-03', 'none 1'),
(12, '9945', 1, 1, 1, '99.00', '47', '2015-11-19', '');

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

--
-- Structure de la table `table_mrs`
--

CREATE TABLE `table_mrs` (
  `Num_ligne_mrs` int(6) NOT NULL,
  `Num_ident_animal` varchar(12) COLLATE utf8_bin NOT NULL,
  `Num_Clients` int(3) NOT NULL,
  `Date_Entre` date NOT NULL,
  `Date_Decoupe` date NOT NULL,
  `Poids_carcasse` decimal(6,2) NOT NULL,
  `Num_Bon_Mrs` int(11) DEFAULT NULL,
  `Date_Bon_Mrs` date DEFAULT NULL,
  `Poids_Mrs` decimal(6,2) DEFAULT NULL,
  `Prestataire` int(2) DEFAULT NULL,
  `Date_enlev_mrs` date DEFAULT NULL,
  `Enlevement_mrs` int(1) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `table_mrs`
--

INSERT INTO `table_mrs` (`Num_ligne_mrs`, `Num_ident_animal`, `Num_Clients`, `Date_Entre`, `Date_Decoupe`, `Poids_carcasse`, `Num_Bon_Mrs`, `Date_Bon_Mrs`, `Poids_Mrs`, `Prestataire`, `Date_enlev_mrs`, `Enlevement_mrs`) VALUES
(7, 'FR4625328547', 21, '2015-10-09', '2015-10-09', '411.00', 9945, '2015-11-19', '33.00', 1, '2015-11-19', 1),
(11, 'FR4546851111', 1, '2015-10-09', '2015-10-09', '397.00', 9945, '2015-11-19', '18.00', 1, '2015-11-19', 1),
(15, 'FR4755841030', 10, '2015-10-07', '2015-10-12', '101.00', 9945, '2015-11-19', '33.00', 1, '2015-11-19', 1),
(13, 'FR4685321478', 8, '2015-10-08', '2015-10-15', '440.00', 9945, '2015-11-19', '15.00', 1, '2015-11-19', 1),
(20, 'FR4625174851', 8, '2015-11-23', '2015-11-23', '450.00', 0, '0000-00-00', '0.00', 0, '0000-00-00', 0),
(23, 'FR4625101326', 36, '2016-01-29', '2016-02-01', '550.00', 0, '0000-00-00', '0.00', 0, '0000-00-00', 0),
(22, 'FR4625174751', 8, '2015-11-23', '2015-11-24', '460.00', 0, '0000-00-00', '0.00', 0, '0000-00-00', 0),
(24, 'FR4625101326', 36, '2016-01-29', '2016-02-01', '550.00', 0, '0000-00-00', '0.00', 0, '0000-00-00', 0),
(25, 'FR4625101326', 36, '2016-01-29', '2016-02-01', '550.00', 0, '0000-00-00', '0.00', 0, '0000-00-00', 0),
(26, 'FR4625101326', 36, '2016-01-29', '2016-02-01', '550.00', 0, '0000-00-00', '0.00', 0, '0000-00-00', 0),
(27, 'FR4625101326', 36, '2016-01-29', '2016-02-01', '550.00', 0, '0000-00-00', '0.00', 0, '0000-00-00', 0),
(28, 'FR4625101326', 36, '2016-01-29', '2016-02-01', '550.00', 0, '0000-00-00', '0.00', 0, '0000-00-00', 0),
(30, 'FR4612345678', 1, '2017-02-13', '2017-02-13', '500.50', NULL, NULL, NULL, NULL, NULL, 0),
(29, 'FR4625100133', 8, '2017-02-13', '2017-02-13', '515.45', NULL, NULL, NULL, NULL, NULL, 0),
(31, 'FR4625100513', 11, '2017-04-28', '2017-04-27', '570.00', NULL, NULL, NULL, NULL, NULL, 0),
(32, 'FR4625110513', 11, '2017-04-27', '2017-04-27', '573.00', NULL, NULL, NULL, NULL, NULL, 0),
(33, 'FR4625100513', 11, '2017-04-27', '2017-04-26', '573.00', NULL, NULL, NULL, NULL, NULL, 0);

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

--
-- Structure de la table `type_plu`
--

CREATE TABLE `type_plu` (
  `Num_TypePlu` int(1) NOT NULL,
  `TypePlu` varchar(25) COLLATE utf8_bin NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `type_plu`
--

INSERT INTO `type_plu` (`Num_TypePlu`, `TypePlu`) VALUES
(1, 'Viande'),
(2, 'Transformations'),
(3, 'carcasses'),
(4, 'facturation');

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

--
-- Structure de la table `unitee`
--

CREATE TABLE `unitee` (
  `num_unite` int(3) NOT NULL,
  `nom_unite_long` varchar(25) NOT NULL,
  `nom_unite_ini` varchar(4) NOT NULL,
  `conversion` decimal(10,4) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `unitee`
--

INSERT INTO `unitee` (`num_unite`, `nom_unite_long`, `nom_unite_ini`, `conversion`) VALUES
(1, 'Kilogramme', 'Kg', '0.0010'),
(2, 'Grammes', 'g', '1.0000'),
(3, 'Litre', 'L', '1.0000'),
(4, 'Centilitre', 'Cl', '0.0100'),
(5, 'Mililitre', 'Ml', '0.0010');

--
-- Index pour les tables exportées
--

--
-- Index pour la table `abattoir`
--
ALTER TABLE `abattoir`
  ADD PRIMARY KEY (`id_abat`);

--
-- Index pour la table `categorieplu`
--
ALTER TABLE `categorieplu`
  ADD PRIMARY KEY (`Num_CatPlu`);

--
-- Index pour la table `categorie_dechets`
--
ALTER TABLE `categorie_dechets`
  ADD PRIMARY KEY (`num_cate_dechets`);

--
-- Index pour la table `categorie_decoupe`
--
ALTER TABLE `categorie_decoupe`
  ADD PRIMARY KEY (`num_cate_decoupe`);

--
-- Index pour la table `categorie_fabrications`
--
ALTER TABLE `categorie_fabrications`
  ADD PRIMARY KEY (`num_cate_fabric`);

--
-- Index pour la table `categorie_fournisseurs`
--
ALTER TABLE `categorie_fournisseurs`
  ADD PRIMARY KEY (`num_cate_four`);

--
-- Index pour la table `categorie_intrant`
--
ALTER TABLE `categorie_intrant`
  ADD PRIMARY KEY (`num_cate_plu_intran`);

--
-- Index pour la table `clients`
--
ALTER TABLE `clients`
  ADD PRIMARY KEY (`Num_Client`),
  ADD KEY `Let_Client` (`Let_Client`);

--
-- Index pour la table `clients_base`
--
ALTER TABLE `clients_base`
  ADD PRIMARY KEY (`Num_Client`),
  ADD KEY `Num_Client` (`Num_Client`);

--
-- Index pour la table `decoupe`
--
ALTER TABLE `decoupe`
  ADD PRIMARY KEY (`num_decoupe`);

--
-- Index pour la table `entreabat`
--
ALTER TABLE `entreabat`
  ADD PRIMARY KEY (`Num_entre`);

--
-- Index pour la table `fabrications_detail`
--
ALTER TABLE `fabrications_detail`
  ADD PRIMARY KEY (`Num_Fabric_Haut`),
  ADD UNIQUE KEY `Num_fabric` (`Num_Fabric_Haut`);

--
-- Index pour la table `fabrications_haut`
--
ALTER TABLE `fabrications_haut`
  ADD PRIMARY KEY (`Num_Fabric`),
  ADD UNIQUE KEY `Num_fabric` (`Num_Fabric`);

--
-- Index pour la table `fournisseurs`
--
ALTER TABLE `fournisseurs`
  ADD PRIMARY KEY (`Num_fournisseur`),
  ADD UNIQUE KEY `Num_fournisseur` (`Num_fournisseur`),
  ADD KEY `Let_Client` (`Ident_four`),
  ADD KEY `Num_fournisseur_2` (`Num_fournisseur`);

--
-- Index pour la table `intrants`
--
ALTER TABLE `intrants`
  ADD PRIMARY KEY (`Num_entre_intrant`);

--
-- Index pour la table `lot`
--
ALTER TABLE `lot`
  ADD PRIMARY KEY (`num_ligne_lot`),
  ADD UNIQUE KEY `num_ligne_lot` (`num_ligne_lot`),
  ADD KEY `num_ligne_lot_2` (`num_ligne_lot`);

--
-- Index pour la table `lot_dispo`
--
ALTER TABLE `lot_dispo`
  ADD PRIMARY KEY (`num_ligne_lot_dispo`);

--
-- Index pour la table `plu`
--
ALTER TABLE `plu`
  ADD PRIMARY KEY (`Num_PLU`),
  ADD UNIQUE KEY `Num_PLU_2` (`Num_PLU`),
  ADD KEY `Num_PLU` (`Num_PLU`);

--
-- Index pour la table `plu_intrant`
--
ALTER TABLE `plu_intrant`
  ADD PRIMARY KEY (`num_plu_intrant`);

--
-- Index pour la table `production`
--
ALTER TABLE `production`
  ADD PRIMARY KEY (`Num_ligne`);

--
-- Index pour la table `quantitative_detail`
--
ALTER TABLE `quantitative_detail`
  ADD PRIMARY KEY (`Num_ligne_qtv_det`);

--
-- Index pour la table `quantitative_haut`
--
ALTER TABLE `quantitative_haut`
  ADD PRIMARY KEY (`Num_ligne_qtv`),
  ADD KEY `Num_ligne_qtv` (`Num_ligne_qtv`);

--
-- Index pour la table `saisies_abat`
--
ALTER TABLE `saisies_abat`
  ADD PRIMARY KEY (`num_ligne`);

--
-- Index pour la table `table_dechets`
--
ALTER TABLE `table_dechets`
  ADD PRIMARY KEY (`num_ligne_dechets`);

--
-- Index pour la table `table_mrs`
--
ALTER TABLE `table_mrs`
  ADD PRIMARY KEY (`Num_ligne_mrs`);

--
-- Index pour la table `type_plu`
--
ALTER TABLE `type_plu`
  ADD PRIMARY KEY (`Num_TypePlu`);

--
-- Index pour la table `unitee`
--
ALTER TABLE `unitee`
  ADD PRIMARY KEY (`num_unite`),
  ADD UNIQUE KEY `num_unite` (`num_unite`);

--
-- AUTO_INCREMENT pour les tables exportées
--

--
-- AUTO_INCREMENT pour la table `categorieplu`
--
ALTER TABLE `categorieplu`
  MODIFY `Num_CatPlu` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT pour la table `categorie_dechets`
--
ALTER TABLE `categorie_dechets`
  MODIFY `num_cate_dechets` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT pour la table `categorie_decoupe`
--
ALTER TABLE `categorie_decoupe`
  MODIFY `num_cate_decoupe` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT pour la table `categorie_fabrications`
--
ALTER TABLE `categorie_fabrications`
  MODIFY `num_cate_fabric` int(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT pour la table `categorie_fournisseurs`
--
ALTER TABLE `categorie_fournisseurs`
  MODIFY `num_cate_four` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT pour la table `categorie_intrant`
--
ALTER TABLE `categorie_intrant`
  MODIFY `num_cate_plu_intran` int(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT pour la table `decoupe`
--
ALTER TABLE `decoupe`
  MODIFY `num_decoupe` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;
--
-- AUTO_INCREMENT pour la table `entreabat`
--
ALTER TABLE `entreabat`
  MODIFY `Num_entre` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=58;
--
-- AUTO_INCREMENT pour la table `fabrications_detail`
--
ALTER TABLE `fabrications_detail`
  MODIFY `Num_Fabric_Haut` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT pour la table `fabrications_haut`
--
ALTER TABLE `fabrications_haut`
  MODIFY `Num_Fabric` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT pour la table `fournisseurs`
--
ALTER TABLE `fournisseurs`
  MODIFY `Num_fournisseur` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT pour la table `intrants`
--
ALTER TABLE `intrants`
  MODIFY `Num_entre_intrant` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT pour la table `lot`
--
ALTER TABLE `lot`
  MODIFY `num_ligne_lot` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=74;
--
-- AUTO_INCREMENT pour la table `lot_dispo`
--
ALTER TABLE `lot_dispo`
  MODIFY `num_ligne_lot_dispo` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=64;
--
-- AUTO_INCREMENT pour la table `plu_intrant`
--
ALTER TABLE `plu_intrant`
  MODIFY `num_plu_intrant` int(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;
--
-- AUTO_INCREMENT pour la table `quantitative_detail`
--
ALTER TABLE `quantitative_detail`
  MODIFY `Num_ligne_qtv_det` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT pour la table `quantitative_haut`
--
ALTER TABLE `quantitative_haut`
  MODIFY `Num_ligne_qtv` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT pour la table `table_dechets`
--
ALTER TABLE `table_dechets`
  MODIFY `num_ligne_dechets` int(1) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
--
-- AUTO_INCREMENT pour la table `table_mrs`
--
ALTER TABLE `table_mrs`
  MODIFY `Num_ligne_mrs` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;
--
-- AUTO_INCREMENT pour la table `unitee`
--
ALTER TABLE `unitee`
  MODIFY `num_unite` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
/*!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 */;
