-- phpMyAdmin SQL Dump
-- version 4.1.12
-- http://www.phpmyadmin.net
--
-- Host: localhost:8889
-- Generation Time: Aug 27, 2014 at 09:08 AM
-- Server version: 5.5.34
-- PHP Version: 5.5.10

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

--
-- Database: `plateforme_esco`
--

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

--
-- Table structure for table `esco_business`
--

CREATE TABLE `esco_business` (
  `business_id` int(11) NOT NULL AUTO_INCREMENT,
  `business_name` varchar(128) NOT NULL,
  `business_email` text NOT NULL,
  `business_type` tinyint(4) NOT NULL,
  `business_preparation_done` tinyint(4) DEFAULT '0',
  `business_visite_done` tinyint(4) DEFAULT '0',
  `business_is_closed` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`business_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `esco_log`
--

CREATE TABLE `esco_log` (
  `log_id` int(11) NOT NULL AUTO_INCREMENT,
  `log_date` date NOT NULL,
  `user_id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `ssee_id` int(11) NOT NULL,
  `log_text` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `esco_preparation_visite_energie`
--

CREATE TABLE `esco_preparation_visite_energie` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entreprise` text NOT NULL,
  `question1` text NOT NULL,
  `question2` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `esco_suivi_client`
--

CREATE TABLE `esco_suivi_client` (
  `suivi_client_id` int(11) NOT NULL AUTO_INCREMENT,
  `suivi_client_date` date NOT NULL,
  `suivi_client_ssee` text CHARACTER SET utf8 NOT NULL,
  `suivi_client_entreprise` text CHARACTER SET utf8 NOT NULL,
  `suivi_client_statut` text CHARACTER SET utf8 NOT NULL,
  `suivi_client_facture_elec` int(11) NOT NULL,
  `suivi_client_facture_gaz` int(11) NOT NULL,
  `suivi_client_surface_total` int(11) NOT NULL,
  `suivi_client_chiffre_affaire` int(11) NOT NULL,
  `suivi_client_potentiel_energetique` int(11) NOT NULL,
  `suivi_client_element` text CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`suivi_client_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `esco_user`
--

CREATE TABLE `esco_user` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_login` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `user_password` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `user_firstname` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `user_lastname` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `user_email` text COLLATE utf8_unicode_ci NOT NULL,
  `business_id` int(11) NOT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;