-- phpMyAdmin SQL Dump
-- version 3.2.0.1
-- http://www.phpmyadmin.net
--
-- Serveur: localhost
-- G้n้r้ le : Mer 20 Juillet 2011 เ 18:01
-- Version du serveur: 5.1.36
-- Version de PHP: 5.3.0

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Base de donn้es: `cablerie`
--

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

--
-- Structure de la table `code`
--

CREATE TABLE IF NOT EXISTS `code` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(12) NOT NULL,
  `passe` varchar(12) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Contenu de la table `code`
--

INSERT INTO `code` (`id`, `nom`, `passe`) VALUES
(1, 'yamane', 'yassine');

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

--
-- Structure de la table `contact1`
--

CREATE TABLE IF NOT EXISTS `contact1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nam` text NOT NULL,
  `email` text NOT NULL,
  `message` text NOT NULL,
  `etat` varchar(3) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=164 ;

--
-- Contenu de la table `contact1`
--

INSERT INTO `contact1` (`id`, `nam`, `email`, `message`, `etat`) VALUES
(134, '', '', '', '2'),
(135, '', '', '', '0'),
(127, 'yamane', 'enissay_sat@hotmail.com', 'DDDDDDDDDD', '1'),
(163, 'yamane', 'yamane010@gmail.com', 'dsfsdwv', '2'),
(143, 'yamane', 'yamane010@gmail.com', 'dddddddd', '1'),
(144, 'yamane', 'yamane010@gmail.com', 'dddddddd', '0'),
(145, 'yamane', 'yamane010@gmail.com', 'dddddddd', '0'),
(146, 'yamane', 'yamane010@gmail.com', 'dddddddd', '0'),
(147, 'yamane', 'yamane010@gmail.com', 'scsdsd sdc sd c ', '0'),
(148, 'yamane', 'yamane010@gmail.com', 'scsdsd sdc sd c ', '0'),
(149, 'yamane', 'yamane010@gmail.com', 'sssssssssssss', '0'),
(150, 'yamane', 'yamane010@gmail.com', 'sssssssssssss', '0'),
(151, 'yamane', 'yamane010@gmail.com', '', '0'),
(152, 'yamane', 'yamane010@gmail.com', '', '0'),
(153, 'yamane', 'yamane010@gmail.com', '', '0'),
(154, 'yamane', 'yamane010@gmail.com', '', '0'),
(155, 'yamane', 'yamane010@gmail.com', '', '0'),
(156, 'yamane', 'yamane010@gmail.com', '', '0'),
(157, 'yamane', 'yamane010@gmail.com', 'ssss he', '0'),
(158, 'yamaneรจรจรจรจรจรจรจรจ', 'yamane010@gmail.com', 'zzzzzzzzzzz', '0'),
(159, 'yamaneรจรจรจรจรจรจรจรจ', 'yamane010@gmail.com', 'zzzzzzzzzzz', '0'),
(160, 'yamaneรจรจรจรจรจรจรจรจ', 'yamane010@gmail.com', 'zzzzzzzzzzz', '0'),
(161, 'yamaneรจรจรจรจรจรจรจรจ', 'yamane010@gmail.com', 'zzzzzzzzzzz', '0');

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

--
-- Structure de la table `devisemail`
--

CREATE TABLE IF NOT EXISTS `devisemail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=204 ;

--
-- Contenu de la table `devisemail`
--

INSERT INTO `devisemail` (`id`, `email`) VALUES
(202, 'kkkkkshd@gmail.com'),
(198, 'yamane010@gmail.com'),
(203, 'yamane010@gmail.com'),
(201, 'yamane010@gmail.com');

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

--
-- Structure de la table `login`
--

CREATE TABLE IF NOT EXISTS `login` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` varchar(20) NOT NULL,
  `passe` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;

--
-- Contenu de la table `login`
--

INSERT INTO `login` (`id`, `login`, `passe`) VALUES
(1, 'ana', '12345'),
(2, 'ana', '123'),
(18, 'JJDJD', ''),
(17, 'JJDJD', 'DD');