-- phpMyAdmin SQL Dump
-- version 3.4.9
-- http://www.phpmyadmin.net
--
-- Client: localhost
-- Généré le : Mer 23 Mai 2012 à 15:01
-- Version du serveur: 5.5.20
-- Version de PHP: 5.3.9

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: `grip`
--

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

--
-- Structure de la table `conteneur`
--

CREATE TABLE IF NOT EXISTS `conteneur` (
  `cdec` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cdet` varchar(10) NOT NULL,
  `cdc` varchar(5) NOT NULL,
  `datedec` date NOT NULL,
  `m` mediumint(8) unsigned NOT NULL,
  `f` mediumint(8) unsigned NOT NULL,
  `m1` mediumint(8) unsigned NOT NULL,
  `f1` mediumint(8) unsigned NOT NULL,
  `m2` mediumint(8) unsigned NOT NULL,
  `f2` mediumint(8) unsigned NOT NULL,
  `m3` mediumint(8) unsigned NOT NULL,
  `f3` mediumint(8) unsigned NOT NULL,
  `m4` mediumint(8) unsigned NOT NULL,
  `f4` mediumint(8) unsigned NOT NULL,
  `m5` mediumint(8) unsigned NOT NULL,
  `f5` mediumint(8) unsigned NOT NULL,
  `m6` mediumint(8) unsigned NOT NULL,
  `f6` mediumint(8) unsigned NOT NULL,
  `m7` mediumint(8) unsigned NOT NULL,
  `f7` mediumint(8) unsigned NOT NULL,
  `m8` mediumint(8) unsigned NOT NULL,
  `f8` mediumint(8) unsigned NOT NULL,
  PRIMARY KEY (`cdec`),
  KEY `cdet` (`cdet`,`cdc`,`datedec`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=23 ;

--
-- Contenu de la table `conteneur`
--

INSERT INTO `conteneur` (`cdec`, `cdet`, `cdc`, `datedec`, `m`, `f`, `m1`, `f1`, `m2`, `f2`, `m3`, `f3`, `m4`, `f4`, `m5`, `f5`, `m6`, `f6`, `m7`, `f7`, `m8`, `f8`) VALUES
(1, '0403178000', '03115', '2011-01-09', 6, 5, 22, 15, 9, 12, 18, 9, 6, 6, 7, 11, 10, 6, 4, 5, 12, 6),
(2, '0403178000', '03109', '2011-01-09', 5, 3, 14, 12, 19, 13, 26, 11, 5, 5, 3, 11, 5, 11, 1, 4, 5, 4),
(3, '0403178000', '03115', '2011-01-23', 6, 3, 22, 7, 15, 18, 10, 13, 13, 23, 9, 16, 5, 8, 3, 11, 14, 3),
(4, '0403178000', '03109', '2011-01-23', 7, 2, 20, 8, 14, 13, 13, 13, 16, 13, 6, 21, 14, 13, 8, 11, 11, 16),
(5, '0403178000', '03115', '2011-02-05', 10, 4, 11, 13, 15, 11, 19, 13, 9, 11, 10, 11, 6, 13, 8, 8, 10, 9),
(6, '0403178000', '03115', '2011-02-13', 8, 5, 12, 13, 15, 8, 17, 11, 17, 22, 12, 25, 12, 18, 4, 6, 10, 15),
(7, '0403178000', '03115', '2011-02-20', 12, 14, 10, 5, 10, 13, 8, 10, 9, 16, 5, 11, 6, 7, 2, 6, 8, 5),
(8, '0403178000', '03109', '2011-02-20', 3, 2, 12, 8, 8, 8, 2, 10, 3, 9, 2, 1, 3, 3, 1, 5, 4, 4),
(9, '0403178000', '03115', '2011-02-27', 2, 2, 4, 6, 4, 3, 14, 13, 10, 13, 8, 13, 9, 14, 3, 3, 4, 9),
(10, '0403178000', '03109', '2011-02-27', 2, 1, 2, 2, 4, 2, 1, 1, 0, 1, 3, 4, 2, 2, 2, 2, 2, 4),
(11, '0403178000', '03115', '2011-03-06', 5, 7, 6, 7, 5, 4, 8, 9, 6, 7, 4, 2, 5, 7, 5, 9, 7, 4),
(12, '0403178000', '03109', '2011-03-06', 3, 3, 9, 7, 5, 7, 11, 6, 1, 6, 2, 8, 3, 4, 1, 1, 4, 4),
(13, '0403178000', '03109', '2011-03-10', 1, 2, 4, 5, 1, 3, 5, 0, 0, 1, 1, 4, 1, 2, 0, 2, 4, 1),
(14, '0403178000', '03115', '2011-03-10', 5, 1, 9, 6, 4, 6, 6, 6, 3, 5, 2, 6, 2, 2, 4, 2, 2, 7),
(15, '0403178000', '03109', '2011-03-13', 4, 1, 9, 5, 5, 2, 3, 2, 1, 0, 1, 1, 1, 1, 1, 1, 2, 2),
(16, '0403178000', '03115', '2011-03-13', 8, 9, 14, 12, 10, 7, 12, 9, 6, 7, 5, 17, 5, 3, 1, 6, 5, 7),
(17, '0403178000', '03109', '2011-03-20', 3, 1, 5, 6, 7, 2, 2, 2, 2, 4, 2, 5, 3, 4, 0, 4, 3, 0),
(18, '0403178000', '03116', '2011-03-20', 0, 0, 0, 1, 0, 2, 0, 0, 2, 0, 0, 1, 3, 10, 0, 0, 1, 5),
(19, '0403178000', '03110', '2011-03-20', 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0),
(20, '0403178000', '03115', '2011-03-20', 5, 9, 10, 13, 10, 6, 7, 5, 4, 9, 6, 12, 5, 7, 2, 8, 9, 6),
(21, '0403178000', '03109', '2012-01-01', 8, 8, 15, 13, 1, 9, 6, 6, 3, 15, 2, 8, 0, 8, 0, 8, 10, 7),
(22, '0213101010', '03102', '2009-12-12', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

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