-- phpMyAdmin SQL Dump
-- version 3.2.0.1
-- http://www.phpmyadmin.net
--
-- Serveur: localhost
-- Généré le : Mar 13 Novembre 2012 à 14:22
-- Version du serveur: 5.1.36
-- Version de PHP: 5.3.0

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Base de données: `commande`
--

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

--
-- Structure de la table `article`
--

CREATE TABLE IF NOT EXISTS `article` (
  `reference` varchar(100) NOT NULL,
  `nom` varchar(100) NOT NULL,
  `prix` double NOT NULL,
  `stock` int(10) NOT NULL,
  `publier` tinyint(1) DEFAULT '1',
  `inTheWeb` tinyint(1) DEFAULT '1',
  `idGamme` int(10) NOT NULL,
  PRIMARY KEY (`reference`),
  KEY `idGamme` (`idGamme`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Contenu de la table `article`
--

INSERT INTO `article` (`reference`, `nom`, `prix`, `stock`, `publier`, `inTheWeb`, `idGamme`) VALUES
('115-BG-BROWNSM', 'Mini Bikini', 63.94, 9, 1, 1, 14),
('115-BG-LPNKML', 'Mini Bikini', 63.94, 7, 1, 1, 14),
('115-BG-LPNKSM', 'Mini Bikini', 63.94, 8, 1, 1, 14),
('2974', 'Burlesque String Franges', 40.87, 100, 1, 1, 15),
('2974BLKL', 'Burlesque String Franges', 40.87, 17, 1, 1, 15),
('2974BLKM', 'Burlesque String Franges', 40.87, 12, 1, 1, 15),
('2974BLKS', 'Burlesque String Franges', 40.87, 23, 1, 1, 15),
('2974REDL', 'Burlesque String Franges', 40.87, 22, 1, 1, 15),
('2974REDM', 'Burlesque String Franges', 40.87, 9, 1, 1, 15),
('2974REDS', 'Burlesque String Franges', 40.87, 11, 1, 1, 15),
('2985', 'Boxer Tanga Ondulations Divines', 29.36, 100, 1, 1, 15),
('2987', 'Mini Boxer Booty', 24.02, 100, 1, 1, 15),
('5001-PRINCESS', 'Chaussures Talons Princess', 86.48, 100, 1, 0, 13),
('5002-RUBY', 'Chaussures Talons Ruby', 86.48, 100, 1, 0, 13),
('5002-RUBY-RED8', 'Chaussures Talons Ruby', 86.48, 10, 0, 0, 13),
('5004-BABYDOLL', 'Chaussures Talons Babydoll', 81.7, 100, 0, 1, 13),
('5004-BABYDOLL-BLK7', 'Chaussures Talons Babydoll', 81.7, 9, 1, 1, 13),
('5004-BABYDOLL-BLK8', 'Chaussures Talons Babydoll', 81.7, 8, 1, 1, 13),
('5004-BABYDOLL-RED6', 'Chaussures Talons Babydoll', 81.7, 10, 1, 0, 13),
('5004-BABYDOLL-RED7', 'Chaussures Talons Babydoll', 81.7, 7, 1, 1, 13),
('5004-BABYDOLL-RED8', 'Chaussures Talons Babydoll', 81.7, 11, 1, 1, 13),
('5004-BABYDOLL-RED9', 'Chaussures Talons Babydoll', 81.7, 7, 0, 1, 13),
('5004-BABYDOLL-WHI6', 'Chaussures Talons Babydoll', 81.7, 17, 1, 1, 13),
('5004-BABYDOLL-WHI7', 'Chaussures Talons Babydoll', 81.7, 9, 1, 1, 13),
('5004-BABYDOLL-WHI8', 'Chaussures Talons Babydoll', 81.7, 14, 1, 0, 13),
('5004-BABYDOLL-WHI9', 'Chaussures Talons Babydoll', 81.7, 8, 1, 1, 13),
('5006-MATEY', 'Chaussures Talons Matey', 86.48, 100, 1, 1, 13),
('5006-MATEY-BLU10', 'Chaussures Talons Matey', 86.48, 8, 1, 1, 13),
('5006-MATEY-BLU8', 'Chaussures Talons Matey', 86.48, 7, 1, 1, 13),
('5009-FRENCHIE', 'Chaussures Talons Frenchie', 96.11, 100, 1, 1, 13),
('5010-MAFIA', 'Chaussures Talons Mafia', 120.1, 100, 1, 1, 13),
('5010-Mafia-BLKWHI6', 'Chaussures Talons Mafia', 120.1, 9, 1, 1, 13),
('5011-ELLA', 'Chaussures Talons Ella', 100.9, 100, 1, 1, 13),
('5011-ELLA-FUC10', 'Chaussures Talons Ella', 100.9, 9, 1, 1, 13),
('5011-ELLA-FUC6', 'Chaussures Talons Ella', 100.9, 11, 1, 1, 13),
('5011-ELLA-FUC9', 'Chaussures Talons Ella', 100.9, 16, 1, 1, 13),
('5011-ELLA-GLD10', 'Chaussures Talons Ella', 100.9, 9, 1, 1, 13),
('5011-ELLA-GLD7', 'Chaussures Talons Ella', 100.9, 7, 1, 1, 13),
('5011-ELLA-GLD8', 'Chaussures Talons Ella', 100.9, 7, 1, 1, 13),
('5011-ELLA-GLD9', 'Chaussures Talons Ella', 100.9, 10, 1, 1, 13),
('5011-ELLA-SIL10', 'Chaussures Talons Ella', 100.9, 11, 1, 1, 13),
('5011-ELLA-SIL7', 'Chaussures Talons Ella', 100.9, 8, 1, 1, 13),
('5011-ELLA-SIL8', 'Chaussures Talons Ella', 100.9, 8, 1, 1, 13),
('5011-ELLA-SIL9', 'Chaussures Talons Ella', 100.9, 8, 1, 1, 13),
('5012-COP', 'Chaussures Talons Cop', 96.11, 100, 1, 1, 13),
('5012-COP-BLK10', 'Chaussures Talons Cop', 96.11, 9, 1, 1, 13),
('5012-COP-BLK8', 'Chaussures Talons Cop', 96.11, 7, 1, 1, 13),
('5012-COP-BLK9', 'Chaussures Talons Cop', 96.11, 8, 1, 1, 13),
('5020-CHEYENNE', 'Bottes Talons Cheyenne', 134.5, 100, 1, 1, 13),
('5020-CHEYENNE-7', 'Bottes Talons Cheyenne', 134.5, 8, 1, 1, 13),
('5021-ROMA', 'Bottes Talons Roma', 110.5, 100, 1, 1, 13),
('5021-Roma-TAN7', 'Bottes Talons Roma', 110.5, 8, 1, 1, 13),
('5022-BUTTONS', 'Bottes Talons Buttons', 124.9, 100, 1, 1, 13),
('5025-SERGEANT', 'Bottes Talons Sergeant', 134.5, 100, 1, 1, 13),
('5025-SERGEANT-10', 'Bottes Talons Sergeant', 134.5, 10, 1, 1, 13),
('5025-SERGEANT-6', 'Bottes Talons Sergeant', 134.5, 7, 1, 1, 13),
('5025-SERGEANT-8', 'Bottes Talons Sergeant', 134.5, 7, 1, 1, 13),
('5027-BANDIT', 'Bottes Talons Bandit', 163.3, 100, 1, 1, 13),
('5027-BANDIT-BLK6', 'Bottes Talons Bandit', 163.3, 10, 1, 1, 13),
('5027-BANDIT-BLK7', 'Bottes Talons Bandit', 163.3, 9, 1, 1, 13),
('5027-BANDIT-BLK8', 'Bottes Talons Bandit', 163.3, 9, 1, 1, 13),
('5027-BANDIT-BLK9', 'Bottes Talons Bandit', 163.3, 9, 1, 1, 13),
('5028-ANNA', 'Bottes Talons Anna', 182.5, 100, 1, 1, 13),
('5028-ANNA-BLKGLD8', 'Bottes Talons Anna', 182.5, 12, 1, 1, 13),
('5028-ANNA-BLKGLD9', 'Bottes Talons Anna', 182.5, 12, 1, 1, 13),
('5033-UPTOWN', 'Bottes Talons Uptown', 187.4, 100, 1, 1, 21),
('5033-UPTOWN-BGLD6', 'Bottes Talons Uptown', 187.4, 10, 1, 1, 13),
('5033-UPTOWN-BGLD9', 'Bottes Talons Uptown', 187.4, 8, 1, 1, 13),
('5033-UPTOWN-BGOLD8', 'Bottes Talons Uptown', 187.4, 8, 1, 1, 13),
('5033-UPTOWN-BLG10', 'Bottes Talons Uptown', 187.4, 9, 1, 1, 13),
('5034-COSMIC', 'Bottes Talons Cosmic', 153.7, 100, 1, 1, 21),
('5034-COSMIC-SIL10', 'Bottes Talons Cosmic', 153.7, 9, 1, 1, 13),
('5034-COSMIC-SIL7', 'Bottes Talons Cosmic', 153.7, 10, 1, 1, 13),
('5034-COSMIC-SIL8', 'Bottes Talons Cosmic', 153.7, 10, 1, 1, 13),
('8049', 'Robe courte légère', 32.03, 100, 1, 1, 16),
('81082', 'Guêpière Merrywidow', 91.29, 100, 1, 1, 15),
('8278', 'Top manches longues Maille', 20.43, 100, 1, 1, 16),
('8316', 'Robe Ajourée Flashy', 29.33, 100, 1, 1, 16),
('83611', 'Corset Satin', 96.11, 100, 1, 1, 15),
('83611REDL', 'Corset Satin', 96.11, 9, 1, 1, 15),
('86366', 'Robe Asymétrique Recto-Verso', 83.05, 100, 1, 1, 16),
('86366L', 'Robe Asymétrique Recto-Verso', 83.05, 14, 1, 1, 16),
('86366M', 'Robe Asymétrique Recto-Verso', 83.05, 13, 1, 1, 16),
('86366S', 'Robe Asymétrique Recto-Verso', 83.05, 15, 1, 1, 16),
('8888', 'Porte-Jarretelles Dentelle', 23.07, 100, 1, 1, 15),
('A1705', 'Tutu Organza', 45.38, 100, 1, 1, 16),
('B-BLACKBLACK-10', 'Escarpins Nanna BOMB GIRL Noir-Noir 40', 74.16, 25, 1, 1, 21),
('B-BLACKBLACK-6', 'Escarpins Nanna BOMB GIRL Noir-Noir 36', 74.16, 19, 1, 1, 21),
('B-BLACKBLACK-7', 'Escarpins Nanna BOMB GIRL Noir-Noir 37', 74.16, 36, 1, 1, 21),
('B-BLACKBLACK-8', 'Escarpins Nanna BOMB GIRL Noir-Noir 38', 74.16, 35, 1, 1, 21),
('B-BLACKBLACK-9', 'Escarpins Nanna BOMB GIRL Noir-Noir 39', 74.16, 39, 1, 1, 21),
('B-CLEARBLACK-10', 'Escarpins Nanna BOMB GIRL Transparent-Noir 40', 74.16, 35, 1, 1, 21),
('B-CLEARBLACK-6', 'Escarpins Nanna BOMB GIRL Transparent-Noir 36', 74.16, 34, 1, 1, 21),
('B-CLEARBLACK-7', 'Escarpins Nanna BOMB GIRL Transparent-Noir 37', 74.16, 55, 1, 1, 21),
('B-CLEARBLACK-8', 'Escarpins Nanna BOMB GIRL Transparent-Noir 38', 74.16, 56, 1, 1, 21),
('B-CLEARBLACK-9', 'Escarpins Nanna BOMB GIRL Transparent-Noir 39', 74.16, 58, 1, 1, 21),
('B-CLEARCLEAR-10', 'Escarpins Nanna BOMB GIRL Transparent-Transparent 40', 74.16, 32, 1, 1, 21),
('B-CLEARCLEAR-6', 'Escarpins Nanna BOMB GIRL Transparent-Transparent 36', 74.16, 28, 1, 1, 21),
('B-CLEARCLEAR-7', 'Escarpins Nanna BOMB GIRL Transparent-Transparent 37', 74.16, 50, 1, 1, 21),
('B-CLEARCLEAR-8', 'Escarpins Nanna BOMB GIRL Transparent-Transparent 38', 74.16, 48, 1, 1, 21),
('B-CLEARCLEAR-9', 'Escarpins Nanna BOMB GIRL Transparent-Transparent 39', 74.16, 51, 1, 1, 21),
('BK100514', '"Bikini ""Mon Jardin de Roses"""', 98.88, 100, 1, 1, 14),
('BK100514FUSM', '"Bikini ""Mon Jardin de Roses"""', 98.88, 11, 1, 1, 14),
('BK100514FUSS', '"Bikini ""Mon Jardin de Roses"""', 98.88, 11, 1, 1, 14),
('BK100516', '"Bikini ""Papillon de nuit"""', 98.88, 100, 1, 1, 14),
('BK100516ELBLUM', '"Bikini ""Papillon de nuit"""', 98.88, 11, 1, 1, 14),
('BK100516ELBLUS', '"Bikini ""Papillon de nuit"""', 98.88, 11, 1, 1, 14),
('BK110504', '"Bikini ""Moi la Star"""', 112, 100, 1, 1, 14),
('BK110504BWPNKM', '"Bikini ""Moi la Star"""', 112, 11, 1, 1, 14),
('BK110504BWPNKS', '"Bikini ""Moi la Star"""', 112, 11, 1, 1, 14),
('BK110930', '"Bikini "" L''Anse du Paradis"""', 98.88, 100, 1, 1, 14),
('BK110930MULTM', '"Bikini "" L''Anse du Paradis"""', 98.88, 11, 1, 1, 14),
('BK110930MULTS', '"Bikini "" L''Anse du Paradis"""', 98.88, 11, 1, 1, 14),
('BK110936-23', '"Bikini ""Explosion florale"""', 98.88, 100, 1, 1, 14),
('BK110936-23MULTM', '"Bikini ""Explosion florale"""', 98.88, 11, 1, 1, 14),
('BK110936-23MULTS', '"Bikini ""Explosion florale"""', 98.88, 11, 1, 1, 14),
('BK110936-3', '"Bikini ""Croque-moi"""', 98.88, 100, 1, 1, 14),
('BK110936-3MULTM', '"Bikini ""Croque-moi"""', 98.88, 11, 1, 1, 14),
('BK110936-3MULTS', '"Bikini ""Croque-moi"""', 98.88, 11, 1, 1, 14),
('BKDS11006-3', '"Bikini ""Mon Tatoo"" avec strass"', 98.88, 100, 1, 1, 14),
('BKDS11006-3MULTM', '"Bikini ""Mon Tatoo"" avec strass"', 98.88, 11, 1, 1, 14),
('BKDS11006-3MULTS', '"Bikini ""Mon Tatoo"" avec strass"', 98.88, 11, 1, 1, 14),
('BKDS21147-1', '"Bikini ""Entre mes Griffes"""', 98.88, 100, 1, 1, 14),
('BKDS21147-1BRWLEOM', '"Bikini ""Entre mes Griffes"""', 98.88, 11, 1, 1, 14),
('BKDS21147-1BRWLEOS', '"Bikini ""Entre mes Griffes"""', 98.88, 11, 1, 1, 14),
('BKDS21248-1', '"Bikini ""Glace à la Rose"""', 98.88, 100, 1, 1, 14),
('BKDS21248-1PNKM', '"Bikini ""Glace à la Rose"""', 98.88, 11, 1, 1, 14),
('BKDS21248-1PNKS', '"Bikini ""Glace à la Rose"""', 98.88, 11, 1, 1, 14),
('BKDS21251-17', '"Bikini ""Jeu de Coeurs"""', 98.88, 100, 1, 1, 14),
('BKDS21251-17BURDWM', '"Bikini ""Jeu de Coeurs"""', 98.88, 11, 1, 1, 14),
('BKDS21251-17BURDWS', '"Bikini ""Jeu de Coeurs"""', 98.88, 11, 1, 1, 14),
('BKDS21265-10', '"Bikini "" Je Magnétise"""', 98.88, 100, 1, 1, 14),
('BKDS21265-10MULTM', '"Bikini "" Je Magnétise"""', 98.88, 11, 1, 1, 14),
('BKDS21265-10MULTS', '"Bikini "" Je Magnétise"""', 98.88, 11, 1, 1, 14),
('BKDS31123-6', '"Bikini ""Perle des Sables"""', 98.88, 100, 1, 1, 14),
('BKDS31123-6GREM', '"Bikini ""Perle des Sables"""', 98.88, 11, 1, 1, 14),
('BKDS31123-6GRES', '"Bikini ""Perle des Sables"""', 98.88, 11, 1, 1, 14),
('BKDS33001', '"Bikini ""My St-Tropez"""', 98.88, 100, 1, 1, 14),
('BKDS33001COFM', '"Bikini ""My St-Tropez"""', 98.88, 11, 1, 1, 14),
('BKDS33001COFS', '"Bikini ""My St-Tropez"""', 98.88, 11, 1, 1, 14),
('BKDS33066', '"Bikini ""P''ptit bout de St-Barth''"', 112, 100, 1, 1, 14),
('BKDS33066BLKM', '"Bikini ""P''ptit bout de St-Barth''"', 112, 11, 1, 1, 14),
('BKDS33066BLKS', '"Bikini ""P''ptit bout de St-Barth''"', 112, 11, 1, 1, 14),
('BKDS9036-1', '"Bikini ""Miami Girl"""', 112, 100, 1, 1, 14),
('BKDS9036-1MULTM', '"Bikini ""Miami Girl"""', 112, 11, 1, 1, 14),
('BKDS9036-1MULTS', '"Bikini ""Miami Girl"""', 112, 11, 1, 1, 14),
('BKDS969-27', '"Bikini ""Cocktail chic"""', 98.88, 100, 1, 1, 14),
('BKDS969-27WBLKM', '"Bikini ""Cocktail chic"""', 98.88, 11, 1, 1, 14),
('BKDS969-27WBLKS', '"Bikini ""Cocktail chic"""', 98.88, 11, 1, 1, 14),
('BKDY31036-11', '"Bikini ""Moi Féline"""', 98.88, 100, 1, 1, 14),
('BKDY31036-11LEOM', '"Bikini ""Moi Féline"""', 98.88, 11, 1, 1, 14),
('BKDY31036-11LEOS', '"Bikini ""Moi Féline"""', 98.88, 11, 1, 1, 14),
('BKDY31036-16', '"Bikini ""Me Amore"""', 98.88, 100, 1, 1, 14),
('BKDY31036-16MULTM', '"Bikini ""Me Amore"""', 98.88, 11, 1, 1, 14),
('BKDY31036-16MULTS', '"Bikini ""Me Amore"""', 98.88, 11, 1, 1, 14),
('BKHS0832-2', '"Bikini "" Lagon sur ma Peau"""', 112, 100, 1, 1, 14),
('BKHS0832-2NAVYM', '"Bikini "" Lagon sur ma Peau"""', 112, 11, 1, 1, 14),
('BKHS0832-2NAVYS', '"Bikini "" Lagon sur ma Peau"""', 112, 11, 1, 1, 14),
('BKHSI0507', '"Bikini "" Sous mon Arc-en -Ciel"""', 98.88, 100, 1, 1, 14),
('BKHSI0507MULTM', '"Bikini "" Sous mon Arc-en -Ciel"""', 98.88, 11, 1, 1, 14),
('BKHSI0507MULTS', '"Bikini "" Sous mon Arc-en -Ciel"""', 98.88, 11, 1, 1, 14),
('BKST10012', '"Bikini ""Toi, Moi et mon Maillot"""', 98.88, 100, 1, 1, 14),
('BKST10012MULTM', '"Bikini ""Toi, Moi et mon Maillot"""', 98.88, 11, 1, 1, 14),
('BKST10012MULTS', '"Bikini ""Toi, Moi et mon Maillot"""', 98.88, 11, 1, 1, 14),
('BL200-115-BG', 'Mini Bikini', 63.94, 100, 1, 1, 14),
('BL4710-B', 'Bikini Laçages et Diamants', 117.6, 100, 1, 1, 14),
('BL4710-B-BLKML', 'Bikini Laçages et Diamants', 117.6, 7, 1, 1, 14),
('BL4710-B-BLKSM', 'Bikini Laçages et Diamants', 117.6, 7, 1, 1, 14),
('BL4710-B-REDML', 'Bikini Laçages et Diamants', 117.6, 9, 1, 1, 14),
('BL4710-B-REDSM', 'Bikini Laçages et Diamants', 117.6, 9, 1, 1, 14),
('BL4711-B', 'Bikini Strass', 117.6, 100, 1, 1, 14),
('BL4711-B-BLUEML', 'Bikini Strass', 117.6, 9, 1, 1, 14),
('BL4711-B-BLUESM', 'Bikini Strass', 117.6, 9, 1, 1, 14),
('BL4711-B-REDSM', 'Bikini Strass', 117.6, 8, 1, 1, 14),
('BOMB-7700', 'Escarpins Nyx BOMB GIRL', 74.16, 100, 1, 1, 13),
('BOMB-7700-CLEAR-10', 'Escarpins Nyx BOMB GIRL', 74.16, 25, 1, 1, 13),
('BOMB-7700-CLEAR-6', 'Escarpins Nyx BOMB GIRL', 74.16, 14, 1, 1, 13),
('BOMB-7700-CLEAR-7', 'Escarpins Nyx BOMB GIRL', 74.16, 36, 1, 1, 13),
('BOMB-7700-CLEAR-8', 'Escarpins Nyx BOMB GIRL', 74.16, 31, 1, 1, 13),
('BOMB-7700-CLEAR-9', 'Escarpins Nyx BOMB GIRL', 74.16, 45, 1, 1, 13),
('BOMB-7800', 'Escarpins Iduna BOMB GIRL', 74.16, 100, 1, 1, 13),
('BOMB-7800-CLEAR-10', 'Escarpins Iduna BOMB GIRL', 74.16, 16, 1, 1, 13),
('BOMB-7800-CLEAR-6', 'Escarpins Iduna BOMB GIRL', 74.16, 13, 1, 1, 13),
('BOMB-7800-CLEAR-7', 'Escarpins Iduna BOMB GIRL', 74.16, 30, 1, 1, 13),
('BOMB-7800-CLEAR-8', 'Escarpins Iduna BOMB GIRL', 74.16, 29, 1, 1, 13),
('BOMB-7800-CLEAR-9', 'Escarpins Iduna BOMB GIRL', 74.16, 35, 1, 1, 13),
('BOMB-7900', 'Escarpins Nanna BOMB GIRL', 74.16, 100, 1, 1, 21),
('BOMB-8100', 'Escarpins Lucina BOMB GIRL', 79.1, 100, 1, 1, 21),
('BOMB-8100-CLEAR-10', 'Escarpins Lucina BOMB GIRL', 79.1, 14, 1, 1, 13),
('BOMB-8100-CLEAR-6', 'Escarpins Lucina BOMB GIRL', 79.1, 9, 1, 1, 13),
('BOMB-8100-CLEAR-7', 'Escarpins Lucina BOMB GIRL', 79.1, 22, 1, 1, 13),
('BOMB-8100-CLEAR-8', 'Escarpins Lucina BOMB GIRL', 79.1, 19, 1, 1, 13),
('BOMB-8100-CLEAR-9', 'Escarpins Lucina BOMB GIRL', 79.1, 29, 1, 1, 13),
('BOMB-8200', 'Escarpins Cybèle BOMB GIRL', 74.16, 100, 1, 1, 13),
('BOMB-8200-BLACK-10', 'Escarpins Cybèle BOMB GIRL', 74.16, 21, 1, 1, 13),
('BOMB-8200-BLACK-6', 'Escarpins Cybèle BOMB GIRL', 74.16, 12, 1, 1, 13),
('BOMB-8200-BLACK-7', 'Escarpins Cybèle BOMB GIRL', 74.16, 35, 1, 1, 13),
('BOMB-8200-BLACK-8', 'Escarpins Cybèle BOMB GIRL', 74.16, 29, 1, 1, 13),
('BOMB-8200-BLACK-9', 'Escarpins Cybèle BOMB GIRL', 74.16, 33, 1, 1, 13),
('BOMB-8600', 'Escarpins Vesta BOMB GIRL', 77.45, 100, 1, 1, 13),
('BOMB-8600-BLK-10', 'Escarpins Vesta BOMB GIRL', 77.45, 42, 1, 1, 13),
('BOMB-8600-BLK-6', 'Escarpins Vesta BOMB GIRL', 77.45, 25, 1, 1, 13),
('BOMB-8600-BLK-7', 'Escarpins Vesta BOMB GIRL', 77.45, 57, 1, 1, 13),
('BOMB-8600-BLK-8', 'Escarpins Vesta BOMB GIRL', 77.45, 59, 1, 1, 13),
('BOMB-8600-BLK-9', 'Escarpins Vesta BOMB GIRL', 77.45, 60, 1, 1, 13),
('BOMB-8700-BLK-10', 'Escarpins Rhéa BOMB GIRL', 151.2, 38, 1, 1, 13),
('BOMB-8700-BLK-6', 'Escarpins Rhéa BOMB GIRL', 151.2, 24, 1, 1, 13),
('BOMB-8700-BLK-7', 'Escarpins Rhéa BOMB GIRL', 151.2, 49, 1, 1, 13),
('BOMB-8700-BLK-8', 'Escarpins Rhéa BOMB GIRL', 151.2, 46, 1, 1, 13),
('BOMB-8700-BLK-9', 'Escarpins Rhéa BOMB GIRL', 151.2, 53, 1, 1, 13),
('BOMB-8800-BRED-10', 'Escarpins Kali BOMB GIRL Noir-Rouge 40', 82.79, 39, 1, 1, 13),
('BOMB-8800-BRED-6', 'Escarpins Kali BOMB GIRL Noir-Rouge 36', 82.79, 28, 1, 1, 13),
('BOMB-8800-BRED-7', 'Escarpins Kali BOMB GIRL Noir-Rouge 37', 82.79, 55, 1, 1, 13),
('BOMB-8800-BRED-8', 'Escarpins Kali BOMB GIRL Noir-Rouge 38', 82.79, 54, 1, 1, 13),
('BOMB-8800-BRED-9', 'Escarpins Kali BOMB GIRL Noir-Rouge 39', 82.79, 58, 1, 1, 13),
('BOMB-8900-SIL-10', 'Escarpins Cliona BOMB GIRL', 91.69, 39, 1, 1, 13),
('BOMB-8900-SIL-6', 'Escarpins Cliona BOMB GIRL', 91.69, 23, 1, 1, 13),
('BOMB-8900-SIL-7', 'Escarpins Cliona BOMB GIRL', 91.69, 59, 1, 1, 13),
('BOMB-8900-SIL-8', 'Escarpins Cliona BOMB GIRL', 91.69, 60, 1, 1, 13),
('BOMB-8900-SIL-9', 'Escarpins Cliona BOMB GIRL', 91.69, 61, 1, 1, 13),
('BOMB-9001-BLK-10', 'Escarpins Freya BOMB GIRL Noir 40', 91.69, 34, 1, 1, 13),
('BOMB-9001-BLK-6', 'Escarpins Freya BOMB GIRL Noir 36', 91.69, 18, 1, 1, 13),
('BOMB-9001-BLK-7', 'Escarpins Freya BOMB GIRL Noir 37', 91.69, 55, 1, 1, 13),
('BOMB-9001-BLK-8', 'Escarpins Freya BOMB GIRL Noir 38', 91.69, 55, 1, 1, 13),
('BOMB-9001-BLK-9', 'Escarpins Freya BOMB GIRL Noir 39', 91.69, 59, 1, 1, 13),
('BOMB-9002-BLK-10', 'Escarpins Sulla BOMB GIRL', 76.13, 15, 1, 1, 13),
('BOMB-9002-BLK-7', 'Escarpins Sulla BOMB GIRL', 76.13, 22, 1, 1, 13),
('BOMB-9002-BLK-8', 'Escarpins Sulla BOMB GIRL', 76.13, 19, 1, 1, 13),
('BOMB-9002-BLK-9', 'Escarpins Sulla BOMB GIRL', 76.13, 26, 1, 1, 13),
('BOMB-9003-BLK-10', 'Escarpins Héra BOMB GIRL', 97.89, 33, 1, 1, 13),
('BOMB-9003-BLK-6', 'Escarpins Héra BOMB GIRL', 97.89, 15, 1, 1, 13),
('BOMB-9003-BLK-7', 'Escarpins Héra BOMB GIRL', 97.89, 42, 1, 1, 13),
('BOMB-9003-BLK-8', 'Escarpins Héra BOMB GIRL', 97.89, 42, 1, 1, 13),
('BOMB-9003-BLK-9', 'Escarpins Héra BOMB GIRL', 97.89, 54, 1, 1, 13),
('BOMB-9004-SIL-10', 'Escarpins Luna BOMB GIRL', 100.5, 42, 1, 1, 13),
('BOMB-9004-SIL-6', 'Escarpins Luna BOMB GIRL', 100.5, 24, 1, 1, 13),
('BOMB-9004-SIL-7', 'Escarpins Luna BOMB GIRL', 100.5, 58, 1, 1, 13),
('BOMB-9004-SIL-8', 'Escarpins Luna BOMB GIRL', 100.5, 61, 1, 1, 13),
('BOMB-9004-SIL-9', 'Escarpins Luna BOMB GIRL', 100.5, 63, 1, 1, 13),
('BOMB-9005-BLK-10', 'Escarpins Suadela BOMB GIRL', 91.36, 32, 1, 1, 13),
('BOMB-9005-BLK-6', 'Escarpins Suadela BOMB GIRL', 91.36, 20, 1, 1, 13),
('BOMB-9005-BLK-7', 'Escarpins Suadela BOMB GIRL', 91.36, 50, 1, 1, 13),
('BOMB-9005-BLK-8', 'Escarpins Suadela BOMB GIRL', 91.36, 39, 1, 1, 13),
('BOMB-9005-BLK-9', 'Escarpins Suadela BOMB GIRL', 91.36, 46, 1, 1, 13),
('BOMB-9006-SICLR-10', 'Escarpins Vénus BOMB GIRL', 126.8, 37, 1, 1, 13),
('BOMB-9006-SICLR-6', 'Escarpins Vénus BOMB GIRL', 126.8, 17, 1, 1, 13),
('BOMB-9006-SICLR-7', 'Escarpins Vénus BOMB GIRL', 126.8, 41, 1, 1, 13),
('BOMB-9006-SICLR-8', 'Escarpins Vénus BOMB GIRL', 126.8, 47, 1, 1, 13),
('BOMB-9006-SICLR-9', 'Escarpins Vénus BOMB GIRL', 126.8, 49, 1, 1, 13),
('BOMB-9007-BLK-10', 'Escarpins Anahita BOMB GIRL', 91.23, 36, 1, 1, 13),
('BOMB-9007-BLK-6', 'Escarpins Anahita BOMB GIRL', 91.23, 21, 1, 1, 13),
('BOMB-9007-BLK-7', 'Escarpins Anahita BOMB GIRL', 91.23, 55, 1, 1, 13),
('BOMB-9007-BLK-8', 'Escarpins Anahita BOMB GIRL', 91.23, 52, 1, 1, 13),
('BOMB-9007-BLK-9', 'Escarpins Anahita BOMB GIRL', 91.23, 57, 1, 1, 13),
('BUTTONS-BLK6', 'Bottes Talons Buttons', 124.9, 8, 1, 1, 13),
('BUTTONS-BLK7', 'Bottes Talons Buttons', 124.9, 15, 1, 1, 13),
('BUTTONS-BLK8', 'Bottes Talons Buttons', 124.9, 13, 1, 1, 13),
('BUTTONS-BWHI10', 'Bottes Talons Buttons', 124.9, 7, 1, 1, 13),
('BUTTONS-BWHI6', 'Bottes Talons Buttons', 124.9, 7, 1, 1, 13),
('DF1510', 'Bague Jaguar Strass', 30.32, 100, 1, 1, 17),
('DF15101', 'Bague Jaguar Strass', 45.32, 8, 1, 1, 17),
('DF213', 'Bracelet Zig Zag Strass 3 rangs', 30.32, 100, 1, 1, 17),
('DF2131', 'Bracelet Zig Zag Strass 3 rangs', 30.32, 8, 1, 1, 17),
('DF2505', 'Bracelet Strass Maxi', 68.88, 100, 1, 1, 17),
('DF25051', 'Bracelet Strass Maxi', 68.88, 11, 1, 1, 17),
('DF4403', 'Bracelet Jaguar Strass', 39.88, 100, 1, 1, 17),
('DF44031', 'Bracelet Jaguar Strass', 39.88, 12, 1, 1, 17),
('DF5017', 'Bracelet Strass 5 rangs', 35.76, 100, 1, 1, 21),
('DF50171', 'Bracelet Strass 5 rangs', 35.76, 8, 1, 1, 17),
('DF7060', 'Bracelet Tête de Mort', 39.88, 100, 1, 1, 17),
('DF70601', 'Bracelet Tête de Mort', 39.88, 15, 1, 1, 17),
('DF8113', 'Bracelet Chaine Petite Tête de Mort', 20.6, 100, 1, 1, 17),
('DF81131', 'Bracelet Chaine Petite Tête de Mort', 20.6, 10, 1, 1, 17),
('ESP1001', 'String Imprimé Fantaisie', 12.36, 100, 1, 1, 15),
('ESP1002', 'String Douceur de Lycra', 12.36, 100, 1, 1, 15),
('ESP1003', 'String Ficelle Jolis Motifs', 12.36, 100, 1, 1, 15),
('ESP1005', 'Culotte Brésilienne Imprimés Mode', 17.46, 100, 1, 1, 15),
('ESP1008', 'String Ficelle Couleur Lumineuse', 12.36, 100, 1, 1, 15),
('ESP1009', 'Culotte Brésilienne Reflets Satinés', 17.46, 100, 1, 1, 15),
('ESP3001', 'Culotte Echancrée Motif Fantaisie', 19.44, 100, 1, 1, 15),
('ESP3002', 'Culotte Brésilienne', 19.44, 100, 1, 1, 15),
('ESP3003', 'Boxer Fantaisie de Femme', 19.44, 100, 1, 1, 15),
('ESP3004', 'Boxer Echancré Classique', 19.44, 100, 1, 1, 15),
('ESP3005', 'Boxer Féminin Imprimés Coquins', 19.44, 100, 1, 1, 15),
('ESP3006', 'Panties Séduction', 19.44, 100, 1, 1, 15),
('ESP3007', 'Culotte Brésilienne Eclat Satiné', 19.44, 100, 1, 1, 15),
('ESP3008', 'Panties Jeu de Lumière', 19.44, 100, 1, 1, 15),
('ESP3009', 'Boxer Douceur & Brillance', 19.44, 100, 1, 1, 15),
('ESP4093', 'Robe Brillance de Satin', 78.44, 100, 1, 1, 16),
('ESP4121', 'Robe Festival Glamour', 77.45, 100, 1, 1, 16),
('FPDRS40', 'Robe aux 4 styles différents', 87.17, 100, 1, 1, 16),
('FRENCHIE-BWHI7', 'Chaussures Talons Frenchie', 96.11, 8, 1, 1, 13),
('FRENCHIE-N', 'Chaussures Talons Frenchie', 96.11, 0, 1, 1, 13),
('HU22113', 'Soutien gorge décolleté captivant', 19.44, 100, 1, 1, 15),
('HU22115', 'Folie Push-up', 22.87, 100, 1, 1, 15),
('HU6', 'Soutien-gorge satiné sensuel', 21.02, 100, 1, 1, 15),
('HU7', '"Soutien-gorge ""good girl"""', 20.5, 100, 1, 1, 15),
('LC19051', 'Odeleya maillot de bain', 38.85, 100, 1, 1, 14),
('LC19051BPNKL', 'Odeleya maillot de bain', 38.85, 22, 1, 1, 14),
('LC19051BPNKM', 'Odeleya maillot de bain', 38.85, 34, 1, 1, 14),
('LC19051BPNKS', 'Odeleya maillot de bain', 38.85, 26, 1, 1, 14),
('LC19051BPNKXL', 'Odeleya maillot de bain', 38.85, 14, 1, 1, 14),
('LC9731', 'Amphitrite maillot de bain', 25.31, 100, 1, 1, 14),
('LC9731BLKL', 'Amphitrite maillot de bain', 25.31, 24, 1, 1, 14),
('LC9731BLKM', 'Amphitrite maillot de bain', 25.31, 38, 1, 1, 14),
('LC9731BLKS', 'Amphitrite maillot de bain', 25.31, 27, 1, 1, 14),
('LC9731BLKXL', 'Amphitrite maillot de bain', 25.31, 16, 1, 1, 14),
('LC9731REDL', 'Amphitrite maillot de bain', 25.31, 26, 1, 1, 14),
('LC9731REDM', 'Amphitrite maillot de bain', 25.31, 35, 1, 1, 14),
('LC9731REDS', 'Amphitrite maillot de bain', 25.31, 26, 1, 1, 14),
('LC9731REDXL', 'Amphitrite maillot de bain', 25.31, 16, 1, 1, 14),
('LC9731WHIL', 'Amphitrite maillot de bain', 25.31, 28, 1, 1, 14),
('LC9731WHIM', 'Amphitrite maillot de bain', 25.31, 33, 1, 1, 14),
('LC9731WHIS', 'Amphitrite maillot de bain', 25.31, 26, 1, 1, 14),
('LC9731WHIXL', 'Amphitrite maillot de bain', 25.31, 18, 1, 1, 14),
('MPAQU', 'Paréo Long BOMB GIRL Menthe Bleue', 51.08, 100, 1, 1, 14),
('MPAQUOS', 'Paréo Long BOMB GIRL Menthe Bleue', 51.08, 7, 1, 1, 14),
('MPBBG', 'Paréo Long BOMB GIRL Bubble Gum', 51.08, 100, 1, 1, 14),
('MPBBGOS', 'Paréo Long BOMB GIRL Bubble Gum', 51.08, 12, 1, 1, 14),
('MPTBBG', 'Pantalon Paréo BOMB GIRL Bubble Gum', 55.04, 100, 1, 1, 14),
('MPTBBGOS', 'Pantalon Paréo BOMB GIRL Bubble Gum', 55.04, 16, 1, 1, 14),
('MPTNLI', 'Pantalon Paréo BOMB GIRL Citron Vert', 55.04, 100, 1, 1, 14),
('MPTNLIOS', 'Pantalon Paréo BOMB GIRL Citron Vert', 55.04, 9, 1, 1, 14),
('MPTORG', 'Pantalon Paréo BOMB GIRL Orange', 55.04, 100, 1, 1, 14),
('MPTORGOS', 'Pantalon Paréo BOMB GIRL Orange', 55.04, 7, 1, 1, 14),
('MPTWTR', 'Pantalon Paréo BOMB GIRL Melon', 55.04, 100, 1, 1, 14),
('MPTWTROS', 'Pantalon Paréo BOMB GIRL Melon', 55.04, 8, 1, 1, 14),
('MPWHT', 'Paréo Long BOMB GIRL Noix de Coco', 51.08, 100, 1, 1, 14),
('MPWHTOS', 'Paréo Long BOMB GIRL Noix de Coco', 51.08, 11, 1, 1, 14),
('MRPBBG', 'Paréo Court BOMB GIRL Bubble Gum', 29.99, 100, 1, 1, 14),
('MRPBBGOS', 'Paréo Court BOMB GIRL Bubble Gum', 29.99, 7, 1, 1, 14),
('OB1022', 'Armena', 18.68, 100, 1, 1, 15),
('OB1040', 'Bloom chemise', 38.95, 100, 1, 1, 15),
('OB1067', 'Brillant jennifer', 57.94, 100, 1, 1, 15),
('OB1116', 'Curacao chemise', 50.65, 100, 1, 1, 15),
('OB1131', 'Electra', 48.02, 100, 1, 1, 15),
('OB1168', 'Joanna', 44.13, 100, 1, 1, 15),
('OB1223', 'Luiza nuisette', 44.13, 100, 1, 1, 15),
('OB1376', 'Litchi Maillot de Bain', 49.27, 100, 1, 1, 14),
('OB1376PNKL', 'Litchi Maillot de Bain', 49.27, 13, 1, 1, 14),
('OB1376PNKM', 'Litchi Maillot de Bain', 49.27, 23, 1, 1, 14),
('OB1376PNKS', 'Litchi Maillot de Bain', 49.27, 70, 1, 1, 14),
('OB1377', 'Blackpearl Monokini Maillot de Bain', 49.27, 100, 1, 1, 14),
('OB1377BLKLXL', 'Blackpearl Monokini Maillot de Bain', 49.27, 23, 1, 1, 14),
('OB1379', 'Silverglow Maillot de bain', 49.27, 100, 1, 1, 14),
('OB1379SILLXL', 'Silverglow Maillot de bain', 49.27, 32, 1, 1, 14),
('PC8001', 'Body Manches Longues Seconde Peau', 26.69, 100, 1, 1, 15),
('PRINCESS-BLK-7', 'Chaussures Talons Princess', 86.48, 12, 1, 1, 13),
('PRINCESS-BLK-8', 'Chaussures Talons Princess', 86.48, 12, 1, 1, 13),
('PRINCESS-BLU-6', 'Chaussures Talons Princess', 86.48, 8, 1, 1, 13),
('PRINCESS-PNK-6', 'Chaussures Talons Princess', 86.48, 7, 1, 1, 13),
('PRINCESS-PNK-8', 'Chaussures Talons Princess', 86.48, 8, 1, 1, 13),
('PRINCESS-PNK-9', 'Chaussures Talons Princess', 86.48, 7, 1, 1, 13),
('PRINCESS-PUR-10', 'Chaussures Talons Princess', 86.48, 8, 1, 1, 13),
('PRINCESS-PUR-6', 'Chaussures Talons Princess', 86.48, 9, 1, 1, 13),
('PRINCESS-RED-10', 'Chaussures Talons Princess', 86.48, 9, 1, 1, 13),
('PRINCESS-RED-7', 'Chaussures Talons Princess', 86.48, 10, 1, 1, 13),
('PRINCESS-RED-9', 'Chaussures Talons Princess', 86.48, 10, 1, 1, 13),
('SKBBG', 'Jupette BOMB GIRL Bubble Gum', 35.92, 100, 1, 1, 21),
('SKBBGOS', 'Jupette BOMB GIRL Bubble Gum', 35.92, 7, 1, 1, 14),
('SKORG', 'Jupette BOMB GIRL Orange', 35.92, 100, 1, 1, 14),
('SKORGOS', 'Jupette BOMB GIRL Orange', 35.92, 13, 1, 1, 14),
('SKWHT', 'Jupette BOMB GIRL Noix de Coco', 35.92, 100, 1, 1, 21),
('SKWHTOS', 'Jupette BOMB GIRL Noix de Coco', 35.92, 11, 1, 1, 14),
('Z2396', 'Soutien-gorge Bikini', 13.34, 100, 1, 1, 14),
('Z2396BLK', 'Soutien-gorge Bikini', 13.34, 27, 1, 1, 14),
('Z2398', 'Haut Bikini Lycra', 13.34, 100, 1, 1, 14),
('Z2398WHI', 'Haut Bikini Lycra', 13.34, 19, 1, 1, 14);

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

--
-- Structure de la table `gamme`
--

CREATE TABLE IF NOT EXISTS `gamme` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `nom` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;

--
-- Contenu de la table `gamme`
--

INSERT INTO `gamme` (`id`, `nom`) VALUES
(10, ' Coups de cœur'),
(11, ' Meilleures ventes'),
(12, ' Nouveautés'),
(13, 'Chaussures'),
(14, 'Maillot de bain'),
(15, 'Lingerie'),
(16, 'Tenue sexy'),
(17, 'Accessoires'),
(18, 'EXTE'),
(19, 'BENETTON'),
(20, 'SINOBI'),
(21, 'Moins50Euros');

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

--
-- Structure de la table `trace`
--

CREATE TABLE IF NOT EXISTS `trace` (
  `idTrace` int(11) NOT NULL AUTO_INCREMENT,
  `User` varchar(30) NOT NULL,
  `dateTrace` datetime NOT NULL,
  `email` varchar(20) NOT NULL,
  `lienComAct` text NOT NULL,
  `NomFicPdf` varchar(20) NOT NULL,
  PRIMARY KEY (`idTrace`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;

--
-- Contenu de la table `trace`
--


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

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

CREATE TABLE IF NOT EXISTS `users` (
  `idUser` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(20) DEFAULT NULL,
  `prenom` varchar(20) DEFAULT NULL,
  `email` varchar(30) DEFAULT NULL,
  `profile` varchar(20) DEFAULT NULL,
  `password` varchar(20) NOT NULL,
  PRIMARY KEY (`idUser`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

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

INSERT INTO `users` (`idUser`, `nom`, `prenom`, `email`, `profile`, `password`) VALUES
(1, 'moukit', 'zakaria', 'zmoukit233@gmail.com', 'admin', 'moukit'),
(2, 'moumen', 'abd al aziz', 'amoumen@powerboutique.com', 'admin', '123456');