-- phpMyAdmin SQL Dump
-- version 3.2.0.1
-- http://www.phpmyadmin.net
--
-- Serveur: localhost
-- Gnr le : Sam 29 Mai 2010  22:18
-- Version du serveur: 5.1.36
-- Version de PHP: 5.2.9-2

-- 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=4 ;

--
-- 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
(1, 'patrice.delpy@sfr.fr', 'ffxmph', 'un', 'charier', 'laurence', '231 boulevard de metz', '', '81340', 'gaillac', 'deux', 'un', 'un', 'un', '', '11111', 'un'),
(2, 'essai.rien@free.fr', 'pipo1234', 'maison', 'martin', 'axel', '40 rue cuvier', '', '75000', 'paris', '', '', '', '', '', '', ''),
(3, 'patrice.delpy@onsemi.com', 'personnel', 'un', 'aaa', 'bbb', 'ccc', 'ddd', 'eee', 'fff', 'deux', 'riri', 'lulu', 'bibi', 'coco', 'fafa', 'pipo');

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

--
-- 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=71 ;

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

INSERT INTO `app_members` (`id`, `username`, `password`, `email`, `fname`, `lname`, `gender`, `street`, `city`) VALUES
(3, 'fourbe', 'rainbow', 'patrice.delpy@neuf.fr', 'patrice', 'delpy', 1, '1 rue du stade', 'Toulouse'),
(66, '654', '', 'patrice.delpy@neuf.fr', '', '', 1, NULL, NULL),
(65, '654', '', 'patrice.delpy@neuf.fr', '', '', 1, NULL, NULL),
(64, '654', '', 'patrice.delpy@neuf.fr', '', '', 1, NULL, NULL),
(63, '654', '', 'patrice.delpy@neuf.fr', '', '', 1, NULL, NULL),
(62, '654', '', 'patrice.delpy@neuf.fr', '', '', 1, NULL, NULL),
(61, '654', '', 'patrice.delpy@neuf.fr', '', '', 1, NULL, NULL),
(23, 'vincent', 'rainbow', 'patrice.del@tutu.fr', '', '', 1, NULL, NULL),
(60, '654', '', 'patrice.delpy@neuf.fr', '', '', 1, NULL, NULL),
(59, '654', '', 'patrice.delpy@neuf.fr', '', '', 1, NULL, NULL),
(58, '654', '', 'patrice.delpy@neuf.fr', '', '', 1, NULL, NULL),
(57, '654', '', 'patrice.delpy@neuf.fr', '', '', 1, NULL, NULL),
(18, 'moimeme', 'rainbow', 'patrice.delpy@free.com', '', '', 1, NULL, NULL),
(56, '654', '', 'patrice.delpy@free.fr', '', '', 1, NULL, NULL),
(55, '654', '', 'patrice.delpy@free.fr', '', '', 1, NULL, NULL),
(54, '654', '', 'patrice.delpy@free.fr', '', '', 1, NULL, NULL),
(53, '654', '', 'patrice.delpy@free.fr', '', '', 1, NULL, NULL),
(52, '654', '', 'patrice.delpy@free.fr', '', '', 1, NULL, NULL),
(51, '654', '', 'patrice.delpy@free.fr', '', '', 1, NULL, NULL),
(49, 'pinguin', 'rainbow', 'patrice.delpy@cegetel.net', '', '', 1, NULL, NULL),
(50, 'bilonsed', 'rainbow', 'patrice.delpy@toto.fr', '', '', 1, NULL, NULL),
(67, '654', '', 'patrice.delpy@neuf.fr', '', '', 1, NULL, NULL),
(68, '654', '', 'patrice.delpy@neuf.fr', '', '', 1, NULL, NULL),
(69, '654', '', 'patrice.delpy@neuf.fr', '', '', 1, NULL, NULL),
(70, 'ffxmphjj', 'rainbow', 'patrice.delpy@neuf.fra', '', '', 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,
  `adresse` varchar(100) NOT NULL,
  `complement` 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` (`adresse`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

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

INSERT INTO `clients` (`id`, `email`, `login`, `password`, `age`, `telephone`, `nom`, `prenom`, `adresse`, `complement`, `cp`, `ville`, `date_inscription`, `username`, `identifiant`, `civilite`, `heure`) VALUES
(1, 'patrice.delpy@yahoo.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', 'ffxmpa', 'azerty', '', '0545513232', 'bond', 'james', '132, Becker Street', '', '78150', 'Versailles', '03-04-2010', NULL, 'ffxmph', 'M', '23:08'),
(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, 'patrice.delpy@onsemi.com', '', 'rainbow', '', '0102030405', 'blase', 'prenom', 'rien', '', '11111', 'tarbesaa', '27-03-2010', NULL, 'personnel', 'M', '21:35'),
(12, '0000patrice.delpy@sfr.fr', '', 'aqwzsx', '', '0545513232', 'durand', 'vincent', '14 rue des flts', 'APPT N47', '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 '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

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

INSERT INTO `commandes` (`id`, `email`, `commande`, `heure`, `date`, `total_ttc`, `total_ht`, `livraison`, `reglement`) VALUES
(10, 'patrice.delpy@sfr.fr', 'Carte mre, 7, 102.8, 125.42,Boitier Antec, 1, 64.55, 83.7', '20:00', '22-04-2010', '209.12', '167.35', 'TAT', 'carte visa'),
(1, 'patrice.delpy@sfr.fr', 'Camescope, 1, 619.5, 799', '19:57', '22-04-2010', '799', '619.5', 'Express', 'Chque'),
(2, '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', 'carte bleue'),
(3, 'patrice.delpy@sfr.fr', 'DVD, 5, 6231, 6564', '20:28', '22-04-2010', '32820', '31155', 'Chrono', 'carte visa');

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

--
-- Structure de la table `joueurs`
--

CREATE TABLE IF NOT EXISTS `joueurs` (
  `ID` smallint(6) NOT NULL AUTO_INCREMENT,
  `nom` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `prenom` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Contenu de la table `joueurs`
--

INSERT INTO `joueurs` (`ID`, `nom`, `prenom`) VALUES
(1, 'Defrance', 'Jean-Marie'),
(2, 'Dupond', 'Alain');

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

--
-- 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(7,2) NOT NULL,
  `prix_ht` decimal(7,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- 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', '614.10', '581.78'),
(4, 'Aeg', 'ref400', 'bilou', 'VV3474', 'Hublot', '6', '1200', 'A+', '48H', '551.50', '399.10'),
(8, 'Bosch', 'ref500', 'ZNI', 'P-221', 'Frontal', '8', '1600', 'A++', '24H', '714.20', '677.45'),
(9, 'Whirlpool', 'ref600', 'Bardou', 'AAN18-B4F', 'Frontal', '6_5', '900', 'A', '24H', '610.94', '581.78');

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

--
-- Structure de la table `panier`
--

CREATE TABLE IF NOT EXISTS `panier` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(100) NOT NULL,
  `panier` varchar(10000) NOT NULL,
  `heure` varchar(50) NOT NULL,
  `date` varchar(50) NOT NULL,
  `titre` varchar(30) NOT NULL,
  `total_ttc` decimal(7,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=33 ;

--
-- Contenu de la table `panier`
--

INSERT INTO `panier` (`id`, `email`, `panier`, `heure`, `date`, `titre`, `total_ttc`) VALUES
(32, 'patrice.delpy@sfr.fr', 'P-221,lave_linge , 1, 714.2, VV3474,lave_linge , 1, 551.5', '17:53', '09-05-2010', 'tartuffe', '1265.70'),
(31, 'patrice.delpy@sfr.fr', 'VXF33F,lave_linge, 1,479.5,AMV4,lave_linge ,3,2164.5', '23:02', '08-05-2010', 'autre', '2644.00'),
(30, 'patrice.delpy@sfr.fr', 'NTH82K,lave_linge ,3,1438.5,X28Z-22,lave_linge ,3,2164.5', '22:38', '08-05-2010', 'laurence', '3603.00');

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

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

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL DEFAULT '',
  `password` varchar(150) NOT NULL DEFAULT '',
  `password_hint` varchar(255) NOT NULL DEFAULT '',
  `lastname` varchar(50) NOT NULL DEFAULT '',
  `firstname` varchar(50) NOT NULL DEFAULT '',
  `email` varchar(100) NOT NULL DEFAULT '',
  `phone` varchar(50) NOT NULL DEFAULT '',
  `address1` varchar(100) NOT NULL DEFAULT '',
  `address2` varchar(100) NOT NULL DEFAULT '',
  `city` varchar(80) NOT NULL DEFAULT '',
  `state` varchar(20) NOT NULL DEFAULT '',
  `zip` varchar(20) NOT NULL DEFAULT '',
  `country` varchar(50) NOT NULL DEFAULT '',
  `url` varchar(125) NOT NULL DEFAULT '',
  `permissions` varchar(20) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

