-- phpMyAdmin SQL Dump
-- version 3.2.0.1
-- http://www.phpmyadmin.net
--
-- Serveur: localhost
-- Gnr le : Jeu 29 Avril 2010  21:50
-- Version du serveur: 5.1.36
-- Version de PHP: 5.3.0

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Base de donnes: `boutique`
--

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

--
-- Structure de la table `adresses_livraison`
--

CREATE TABLE IF NOT EXISTS `adresses_livraison` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `email` varchar(100) NOT NULL,
  `identifiant` varchar(30) NOT NULL,
  `titre1` varchar(50) NOT NULL,
  `nom1` varchar(50) NOT NULL,
  `prenom1` varchar(50) NOT NULL,
  `adresse1` varchar(100) NOT NULL,
  `complement1` varchar(100) NOT NULL,
  `cp1` varchar(20) NOT NULL,
  `ville1` varchar(80) NOT NULL,
  `titre2` varchar(50) NOT NULL,
  `nom2` varchar(50) NOT NULL,
  `prenom2` varchar(50) NOT NULL,
  `adresse2` varchar(100) NOT NULL,
  `complement2` varchar(100) NOT NULL,
  `cp2` varchar(20) NOT NULL,
  `ville2` varchar(80) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

--
-- Contenu de la table `adresses_livraison`
--

INSERT INTO `adresses_livraison` (`id`, `email`, `identifiant`, `titre1`, `nom1`, `prenom1`, `adresse1`, `complement1`, `cp1`, `ville1`, `titre2`, `nom2`, `prenom2`, `adresse2`, `complement2`, `cp2`, `ville2`) VALUES
(13, 'patrice.delpy@sfr.fr', 'usermod45', 'toto', 'ducon', 'luron', 'chateau de versailles', '', '75150', 'paris', 'second', 'jkljkkj', 'kj', 'dgsqgg', '', '81120', 'realmont'),
(14, 'bilou.chien@yahoo.fr', 'tartuffe', 'boulot', 'dick', 'mon copain', '1 rue du stade', '', '81120', '', '', '', '', '', '', '', '');

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

--
-- Structure de la table `app_members`
--

CREATE TABLE IF NOT EXISTS `app_members` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(200) NOT NULL DEFAULT '',
  `password` varchar(200) DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `fname` varchar(200) NOT NULL DEFAULT '',
  `lname` varchar(200) NOT NULL DEFAULT '',
  `gender` int(11) DEFAULT '1',
  `street` varchar(200) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Contenu de la table `app_members`
--

INSERT INTO `app_members` (`id`, `username`, `password`, `email`, `fname`, `lname`, `gender`, `street`, `city`) VALUES
(3, '', NULL, 'patou.delpy@free.com', '', '', 1, NULL, NULL);

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

--
-- Structure de la table `clients`
--

CREATE TABLE IF NOT EXISTS `clients` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `email` varchar(100) NOT NULL,
  `login` varchar(50) NOT NULL,
  `password` varchar(150) NOT NULL,
  `age` varchar(150) NOT NULL,
  `telephone` varchar(50) NOT NULL,
  `nom` varchar(50) NOT NULL,
  `prenom` varchar(50) NOT NULL,
  `adresse1` varchar(100) NOT NULL,
  `adresse2` varchar(100) NOT NULL,
  `cp` varchar(20) NOT NULL,
  `ville` varchar(80) NOT NULL,
  `date_inscription` varchar(50) NOT NULL,
  `username` varchar(200) DEFAULT NULL,
  `identifiant` varchar(30) NOT NULL,
  `civilite` varchar(10) NOT NULL,
  `heure` varchar(30) NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `prenom` (`prenom`),
  FULLTEXT KEY `prenom_2` (`prenom`),
  FULLTEXT KEY `addresse1` (`adresse1`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

--
-- Contenu de la table `clients`
--

INSERT INTO `clients` (`id`, `email`, `login`, `password`, `age`, `telephone`, `nom`, `prenom`, `adresse1`, `adresse2`, `cp`, `ville`, `date_inscription`, `username`, `identifiant`, `civilite`, `heure`) VALUES
(1, 'patrice.delpy@neuf.fr', 'rainbow', 'tarte', '38', '0561409327', 'delpy de montcuq', 'patrice', '40 rue cuvier', 'Appt 16', '31100', 'toulouse', '06 fvrier 2010', 'laurent', '', '', ''),
(2, 'lui', 'ffxmph', '', '', '', '', '', '', '', '', '', '', NULL, '', '', ''),
(3, 'patrice.delpy@toto.fr', '', 'rainbow', '', '0545513232', 'puce', 'bob', 'kljklj', '', '78150', 'paris', '', NULL, '', '', ''),
(4, 'rien.tutu@orange.fr', 'moimeme', 'rainbow', '', '0545513232', 'durand', 'jacques', 'jkhkj', 'jkh', '31458', 'lyon', '', NULL, '', '', ''),
(5, 'patrice.delpy@sfr.fr', 'ffxmph', 'azerty', '', '5551110123', 'bilou', 'modifprenom', 'adresse modif encore', 'gggekfjgskfj', '07123', 'zoltar', '01-04-2010', NULL, 'ffxmph', 'M', '19:13'),
(6, 'patrice.delpy@neuf.com', '', 'rainbow', '', '', 'martin', 'patrice', '40 rue cuvier', 'kljkljkljk hlkh', '31454', 'toukouse-er', '', 'laurence', '', '', ''),
(7, 'pat.delu@free.fr', '', 'rainbow', '', '', '', '', '', '', '', '', '', NULL, 'patrice', '', ''),
(8, 'patrice.del@tutu.fr', '', 'rainbow', '', '0561409454', 'tartuffe', 'laurence', '1 rue du stade', '', '81120', 'paris', '', NULL, 'moimeme', '3', ''),
(9, 'patrice.del@tutu.fr', '', 'rainbow', '', '0561409454', 'tartuffe', 'laurence', '1 rue du stade', '', '81120', 'paris', '', NULL, 'moimeme', 'Mlle', ''),
(10, 'marc.martin@sfr.fr', 'patrice', 'rainbow', '', '0102010203', 'blase', 'marc', '', '', '69000', 'lyon', '27-03-2010', NULL, 'aqwzsxedc', 'M', '21:35'),
(12, 'patrice.delpy@nada.com', '', 'aqwzsx', '', '0545513232', 'durand', 'vincent', 'kjgjkg', '', '45120', 'aix', '27-03-2010', NULL, 'turlututu', 'M', '23:26');

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

--
-- Structure de la table `commandes`
--

CREATE TABLE IF NOT EXISTS `commandes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(100) NOT NULL,
  `commande` varchar(10000) NOT NULL DEFAULT '',
  `heure` varchar(50) NOT NULL,
  `date` varchar(50) NOT NULL,
  `total_ttc` varchar(20) NOT NULL DEFAULT '',
  `total_ht` varchar(20) NOT NULL DEFAULT '',
  `livraison` varchar(100) NOT NULL,
  `reglement` varchar(20) NOT NULL DEFAULT '',
  `frais_livraison` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

--
-- Contenu de la table `commandes`
--

INSERT INTO `commandes` (`id`, `email`, `commande`, `heure`, `date`, `total_ttc`, `total_ht`, `livraison`, `reglement`, `frais_livraison`) VALUES
(8, 'patrice.delpy@sfr.fr', 'Carte mre, 1, 102.8, 125.42, Boitier Antec, 1, 64.55, 83.7', '20:00', '22-04-2010', '209.12', '167.35', 'TAT', 'carte bleue', '22.18'),
(7, 'patrice.delpy@sfr.fr', 'Camescope, 1, 619.5, 799', '19:57', '22-04-2010', '799', '619.5', 'Express', 'chque', '9.80'),
(6, 'patrice.delpy@sfr.fr', 'Lave vaisselle, 5, 419.5, 499, Plasma, 2, 928.89, 1125, Laptop Sony, 2, 401.1, 449', '19:18', '22-04-2010', '5643', '4757.48', 'TNT', 'mastercard', '12.55'),
(9, 'patrice.delpy@sfr.fr', 'DVD, 5, 6231, 6564', '20:28', '22-04-2010', '32820', '31155', 'Chrono', 'carte visa', '31.10'),
(10, 'patrice.delpy@sfr.fr', 'NTH82K, 14, 399.10, 479.50', '20:34', '28-04-2010', '6713', '5587.4', 'point_relai', 'carte_bancaire', '10'),
(11, 'patrice.delpy@sfr.fr', 'NTH82K, 14, 399.10, 479.50', '20:34', '28-04-2010', '6713', '5587.4', 'point_relai', 'carte_bancaire', '10');

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

--
-- Structure de la table `lave_linge`
--

CREATE TABLE IF NOT EXISTS `lave_linge` (
  `id` tinyint(4) unsigned NOT NULL AUTO_INCREMENT,
  `marque` varchar(20) NOT NULL,
  `id_catalogue` varchar(20) NOT NULL,
  `fournisseur` varchar(20) NOT NULL,
  `modele` varchar(20) NOT NULL,
  `chargement` varchar(20) NOT NULL,
  `capacite` varchar(10) NOT NULL,
  `essorage` varchar(10) NOT NULL,
  `classe` varchar(5) NOT NULL,
  `stocke` varchar(20) NOT NULL,
  `prix_ttc` decimal(5,2) NOT NULL,
  `prix_ht` decimal(5,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Contenu de la table `lave_linge`
--

INSERT INTO `lave_linge` (`id`, `marque`, `id_catalogue`, `fournisseur`, `modele`, `chargement`, `capacite`, `essorage`, `classe`, `stocke`, `prix_ttc`, `prix_ht`) VALUES
(1, 'Aeg', 'ref100', 'bilou', 'NTH82K', 'Hublot', '6', '1200', 'A+', '48H', '479.50', '399.10'),
(2, 'Bosch', 'ref200', 'ZNI', 'X28Z-22', 'Frontal', '8', '1600', 'A++', '24H', '721.50', '677.45'),
(3, 'Whirlpool', 'ref300', 'Bardou', 'KU78-8', 'Frontal', '6_5', '900', 'A', '24H', '624.20', '581.78');

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

--
-- Structure de la table `memb`
--

CREATE TABLE IF NOT EXISTS `memb` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(20) NOT NULL,
  `password_hash` varchar(40) NOT NULL,
  `password_salt` varchar(8) NOT NULL,
  `created` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Contenu de la table `memb`
--

INSERT INTO `memb` (`id`, `username`, `password_hash`, `password_salt`, `created`) VALUES
(1, 'tutu1234', '', '', NULL);

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

--
-- Structure de la table `members`
--

CREATE TABLE IF NOT EXISTS `members` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(30) NOT NULL DEFAULT '',
  `password` varchar(255) NOT NULL DEFAULT '',
  `email` varchar(55) NOT NULL DEFAULT '',
  `location` varchar(40) NOT NULL DEFAULT 'N/A',
  `userlevel` int(3) NOT NULL DEFAULT '1',
  `age` int(3) NOT NULL,
  `sex` varchar(40) NOT NULL DEFAULT 'N/A',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Contenu de la table `members`
--


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

--
-- Structure de la table `membres`
--

CREATE TABLE IF NOT EXISTS `membres` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `session` text NOT NULL,
  `login` text NOT NULL,
  `passe` text NOT NULL,
  `email` text NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Contenu de la table `membres`
--

INSERT INTO `membres` (`id`, `session`, `login`, `passe`, `email`) VALUES
(1, '', 'lulu', 'pass1234', 'patrice.delpy@neuf.fr');

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

--
-- Structure de la table `membres_clients`
--

CREATE TABLE IF NOT EXISTS `membres_clients` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(200) DEFAULT NULL,
  `password` varchar(200) DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `fname` varchar(200) DEFAULT NULL,
  `lname` varchar(200) DEFAULT NULL,
  `gender` int(11) DEFAULT '1',
  `street` varchar(200) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Contenu de la table `membres_clients`
--

INSERT INTO `membres_clients` (`id`, `username`, `password`, `email`, `fname`, `lname`, `gender`, `street`, `city`) VALUES
(1, 'patrice', 'pass1234', 'patrice.delpy@free.fr', NULL, NULL, 1, NULL, NULL);

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

--
-- Structure de la table `tz_members`
--

CREATE TABLE IF NOT EXISTS `tz_members` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usr` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pass` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `regIP` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `dt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `usr` (`usr`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Contenu de la table `tz_members`
--


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

--
-- Structure de la table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Username` text NOT NULL,
  `Password` varchar(32) NOT NULL DEFAULT '',
  `Name` text NOT NULL,
  `Email` text NOT NULL,
  `Date` text NOT NULL,
  `IP` text NOT NULL,
  `Actkey` varchar(40) NOT NULL DEFAULT '',
  `Activated` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Contenu de la table `users`
--


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

--
-- Structure de la table `verification`
--

CREATE TABLE IF NOT EXISTS `verification` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(30) NOT NULL DEFAULT '',
  `code` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Contenu de la table `verification`
--

