text: -- phpMyAdmin SQL Dump
  -- version 4.1.14
  -- http://www.phpmyadmin.net
  --
  -- Client :  127.0.0.1
  -- Généré le :  Mar 23 Janvier 2018 à 10:25
  -- Version du serveur :  5.6.17
  -- Version de PHP :  5.5.12
  
  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 :  `idp-framework`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Structure de la table `internaute`
  --
  
  CREATE TABLE IF NOT EXISTS `internaute` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `nom` varchar(255) NOT NULL,
    `prenom` varchar(255) NOT NULL,
    `email` varchar(255) NOT NULL,
    `pass` varchar(255) NOT NULL,
    `actif` tinyint(1) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  
  -- --------------------------------------------------------
  
  --
  -- Structure de la table `log_manager`
  --
  
  CREATE TABLE IF NOT EXISTS `log_manager` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `date` int(11) NOT NULL,
    `qui` varchar(255) NOT NULL,
    `action` text NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  
  -- --------------------------------------------------------
  
  --
  -- Structure de la table `manager`
  --
  
  CREATE TABLE IF NOT EXISTS `manager` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `nom` varchar(2555) NOT NULL,
    `prenom` varchar(255) NOT NULL,
    `email` varchar(255) NOT NULL,
    `pass` varchar(255) NOT NULL,
    `statut` tinyint(1) NOT NULL,
    `telephone` varchar(20) DEFAULT NULL,
    `portable` varchar(20) DEFAULT NULL,
    `description` text,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
  
  --
  -- Contenu de la table `manager`
  --
  
  INSERT INTO `manager` (`id`, `nom`, `prenom`, `email`, `pass`, `statut`, `telephone`, `portable`, `description`) VALUES
  (1, 'Durbecq', 'Andy', 'demo@id-parallele.com', '9d882372625ab5ab2d42ddb3eca1cb25', 1, '0326354874', '', '');
  
  -- --------------------------------------------------------
  
  --
  -- Structure de la table `post`
  --
  
  CREATE TABLE IF NOT EXISTS `post` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `titre` varchar(255) NOT NULL,
    `sous_titre` varchar(255) DEFAULT NULL,
    `date` int(11) NOT NULL,
    `ordre` int(11) NOT NULL,
    `actif` tinyint(1) NOT NULL,
    `texte` longtext NOT NULL,
    `langue` varchar(10) NOT NULL,
    `type` varchar(255) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  
  -- --------------------------------------------------------
  
  --
  -- Structure de la table `post_document`
  --
  
  CREATE TABLE IF NOT EXISTS `post_document` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `id_post` int(255) NOT NULL,
    `fichier` varchar(255) NOT NULL,
    `legende` varchar(255) NOT NULL,
    `ordre` int(11) NOT NULL,
    PRIMARY KEY (`id`),
    KEY `ID_POST` (`id_post`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  
  -- --------------------------------------------------------
  
  --
  -- Structure de la table `post_image`
  --
  
  CREATE TABLE IF NOT EXISTS `post_image` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `id_post` int(11) NOT NULL,
    `fichier` varchar(255) NOT NULL,
    `legende` varchar(255) NOT NULL,
    `ordre` int(11) NOT NULL,
    PRIMARY KEY (`id`),
    KEY `ID_POST` (`id_post`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  
  -- --------------------------------------------------------
  
  --
  -- Structure de la table `post_option`
  --
  
  CREATE TABLE IF NOT EXISTS `post_option` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `id_post` int(11) NOT NULL,
    `libelle` varchar(255) NOT NULL,
    `valeur` text NOT NULL,
    PRIMARY KEY (`id`),
    KEY `ID_POST` (`id_post`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  
  -- --------------------------------------------------------
  
  --
  -- Structure de la table `ticket`
  --
  
  CREATE TABLE IF NOT EXISTS `ticket` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `nom` varchar(255) NOT NULL,
    `prenom` varchar(255) NOT NULL,
    `telephone` varchar(255) NOT NULL,
    `email` varchar(255) NOT NULL,
    `demande` text NOT NULL,
    `date` float NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  
  --
  -- Contraintes pour les tables exportées
  --
  
  --
  -- Contraintes pour la table `post_document`
  --
  ALTER TABLE `post_document`
    ADD CONSTRAINT `POST_DOCUMENT` FOREIGN KEY (`id_post`) REFERENCES `post` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
  
  --
  -- Contraintes pour la table `post_image`
  --
  ALTER TABLE `post_image`
    ADD CONSTRAINT `POST_IMAGE` FOREIGN KEY (`id_post`) REFERENCES `post` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
  
  --
  -- Contraintes pour la table `post_option`
  --
  ALTER TABLE `post_option`
    ADD CONSTRAINT `POST_OPTION` FOREIGN KEY (`id_post`) REFERENCES `post` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
  
  /*!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 */;
  