eligibilite/MN.sql

-- phpMyAdmin SQL Dump
-- version 4.4.14.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 02, 2015 at 05:14 AM
-- Server version: 5.5.44-MariaDB
-- PHP Version: 5.4.16

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

--
-- Database: `eligibilite`
--

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

--
-- Table structure for table `demandes`
--

CREATE TABLE IF NOT EXISTS `demandes` (
  `id` int(15) NOT NULL,
  `date` datetime NOT NULL,
  `nom` varchar(50) NOT NULL,
  `prenom` varchar(50) NOT NULL,
  `email` varchar(100) NOT NULL,
  `telephone_fixe` varchar(10) NOT NULL,
  `telephone_portable` varchar(10) NOT NULL,
  `numero_voie` varchar(10) NOT NULL,
  `type_voie` varchar(40) NOT NULL,
  `nom_voie` varchar(120) NOT NULL,
  `complement_addresse` varchar(250) NOT NULL,
  `batiment` varchar(30) NOT NULL,
  `cage_escalier` varchar(10) NOT NULL,
  `etage` varchar(10) NOT NULL,
  `numero_appartement` varchar(10) NOT NULL,
  `code_postal` int(5) NOT NULL,
  `ville` varchar(250) NOT NULL,
  `geo_code` varchar(250) NOT NULL,
  `vous_etes` varchar(250) NOT NULL,
  `ce_logement_est` varchar(250) NOT NULL,
  `accord` varchar(30) NOT NULL,
  `info_et_libertes` tinyint(1) NOT NULL,
  `id_zapm_partielle` varchar(25) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=74 DEFAULT CHARSET=utf8;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `demandes`
--
ALTER TABLE `demandes`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `demandes`
--
ALTER TABLE `demandes`
  MODIFY `id` int(15) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=74;
/*!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 */;