-- phpMyAdmin SQL Dump
-- version 4.8.2
-- https://www.phpmyadmin.net/
--
-- Hôte : localhost
-- Généré le :  lun. 23 juil. 2018 à 14:12
-- Version du serveur :  5.7.22-0ubuntu0.16.04.1
-- Version de PHP :  7.0.30-0ubuntu0.16.04.1

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
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 :  `Horius`
--

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

--
-- Structure de la table `temp_import_csv`
--

CREATE TABLE `temp_import_csv` (
  `num_ligne_import` int(2) NOT NULL,
  `IdNumClient` int(6) NOT NULL,
  `num_etiq_ligne` int(8) NOT NULL,
  `date_etiq` date NOT NULL,
  `Num_Clt_Base` int(6) NOT NULL,
  `num_client` varchar(6) NOT NULL,
  `num_plu` int(6) NOT NULL,
  `Num_Eleveur_Base` int(6) NOT NULL,
  `num_lot` varchar(20) NOT NULL,
  `num_lot_tace` varchar(10) NOT NULL,
  `puht` double(6,2) NOT NULL,
  `tare` decimal(6,3) NOT NULL,
  `poids` decimal(6,3) NOT NULL,
  `dlc_etiq` date NOT NULL,
  `lot_int_etiq` varchar(20) NOT NULL,
  `ref_ext_etiq` varchar(20) NOT NULL,
  `ref_int_etiq` varchar(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='imports csv';

--
-- Déchargement des données de la table `temp_import_csv`
--

INSERT INTO `temp_import_csv` (`num_ligne_import`, `IdNumClient`, `num_etiq_ligne`, `date_etiq`, `Num_Clt_Base`, `num_client`, `num_plu`, `Num_Eleveur_Base`, `num_lot`, `num_lot_tace`, `puht`, `tare`, `poids`, `dlc_etiq`, `lot_int_etiq`, `ref_ext_etiq`, `ref_int_etiq`) VALUES
(1, 10001, 5495, '2018-07-04', 0, '10 100', 1, 0, 'H24858518', '184D', 2.48, '0.010', '0.125', '2018-07-18', '', '184D', '');

--
-- Index pour les tables déchargées
--

--
-- Index pour la table `temp_import_csv`
--
ALTER TABLE `temp_import_csv`
  ADD PRIMARY KEY (`num_ligne_import`),
  ADD KEY `num_etiq_ligne` (`num_etiq_ligne`);

--
-- AUTO_INCREMENT pour les tables déchargées
--

--
-- AUTO_INCREMENT pour la table `temp_import_csv`
--
ALTER TABLE `temp_import_csv`
  MODIFY `num_ligne_import` int(2) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=66;
COMMIT;

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