--
-- Host: localhost    Database: desr4
-- ------------------------------------------------------


--
-- Table structure for table `Contacts`
--

CREATE TABLE `Contacts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(30) NOT NULL,
  `prenom` varchar(30) NOT NULL,
  `adresse` varchar(60) NOT NULL,
  `codePostal` int(5) NOT NULL,
  `ville` varchar(50) NOT NULL,
  `telephone` int(10) NOT NULL,
  `mail` varchar(30) NOT NULL,
  `anneeNaissance` int(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Contacts`
--

INSERT INTO `Contacts` VALUES (1,'NEVEAU','THOM','Université La Rochelle',17000,'La Rochelle',8236,'tneveau@univ-lr.fr',1977),(2,'JEAN','Bob','rue de l\'étang',17000,'La Rochelle',17000,'bjean@univ-lr.fr',1982),(3,'MAURICE','julie','rue du duc',33000,'bordeaux',5010,'jmaurice@univ-lr.fr',1930),(4,'LUMET','Edouard','avenue du lazaret',17000,'La Rochelle',8076,'elumet@univ-lr.fr',1997),(5,'Titi','Toto','rue des tutus',12345,'Tataville',123456789,'titi.toto@tetelecom.com',1970),(6,'Titi','Toto','rue des tutus',12345,'Tataville',123456789,'titi.toto@tetelecom.com',1970),(7,'Titi','Toto','rue des tutus',12345,'Tataville',123456789,'titi.toto@tetelecom.com',1970),(8,'Titi','Toto','rue des tutus',12345,'Tataville',123456789,'titi.toto@tetelecom.com',1970);

--
-- Table structure for table `article`
--

CREATE TABLE `article` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_categorie` int(11) NOT NULL,
  `designation` varchar(128) NOT NULL,
  `prix` decimal(6,2) NOT NULL,
  `tva` decimal(5,1) NOT NULL DEFAULT '20.0',
  `description` text NOT NULL,
  `img_article` varchar(64) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `article`
--

INSERT INTO `article` VALUES (1,4,'ADVANCED CHARACTER ANIMATION WITH HALF-LIFE 2 DVD',49.95,19.6,'Teaches how to \"Evolve Your Character \" by focusing on bringing your character to life by animating or applying motion capture data to your own custom design characters within Half-Life','./images/magasin/NoesisCharAnim.jpg'),(2,4,'Real-time Character Animation',39.95,19.6,'his DVD teaches you how to \"activate your Character\" by demonstrating techniques used by professional animators.\r\n\r\nDVD topics covered include: animation clips & sequences, animation blending, custom parameters, custom parameters, linked parameters, animating poses, device capture techniques, and real-time shadows.','./images/magasin/NoesisRTCharacterAnimation.jpg'),(3,4,'Intro to Source Vehicle Programming',49.95,19.6,'Part of the Noesis Interactive MOD Your World training series, introduces you to the basic functions and methodologies of programming in the Source Engine.\r\n\r\nDVD topics covered include: Setting up your development environment. Installing a Version Control System. Overview of Source programming conventions. Creating new classes. Interfacing with GUI elements. Creating thrusters and adding enhancements. Integrating models & animations.','./images/magasin/NoesisIntroSrcVehicleProgramming.jpg'),(4,4,'Source Machinima Choreography',49.95,19.6,'Direct a full range of digital characters and creatures using Valve\'s Source','./images/magasin/NoesisSrcMachinimaChoreography.jpg'),(5,3,'DAY OF DEFEAT POSTER',6.95,19.6,'Folded, four-color glossy, 18\" x 24\"','./images/magasin/DoDPoster.jpg'),(6,3,'HALF-LIFE 2: EPISODE ONE POSTER',9.95,19.6,'Rolled, four-color glossy, 18\" x 24\"','./images/magasin/HL2EP1Poster.jpg'),(7,3,'HALF-LIFE 2: EPISODE TWO POSTER',9.95,19.6,'Four-color glossy, 18\" x 24\".','./images/magasin/HL2EP202poster.jpg'),(8,2,'Half-Life 2 D0G Mousepad',12.95,19.6,'Precision surface with fine micro grid for perfect mouse operations.','./images/magasin/HL2DOGMousepad.jpg'),(9,3,'Left 4 Dead Hand Poster',9.95,19.6,'Left 4 Dead Hand, 18\" x 24\" rolled poster.','./images/magasin/L4DPoster.jpg'),(10,2,'Left 4 Dead Mousepad',12.95,19.6,'Precision surface with fine micro grid for perfect mouse operations.','./images/magasin/L4DMousepad.jpg'),(11,1,'HALF-LIFE 2 SHIRT',19.99,19.6,'Hanes','./images/magasin/HL2Shirt.jpg'),(12,2,'Counter-Strike: Source Mousepad (Yellow)',12.95,19.6,'Precision surface with fine micro grid for perfect mouse operations.','./images/magasin/CSSMousepad-YELLOW.jpg'),(13,2,'Team Fortress 2 Red Team Mousepad',12.95,19.6,'Precision surface with fine micro grid for perfect mouse operations.','./images/magasin/TF2RedTeamMousepad.jpg'),(14,1,'COUNTER-STRIKE SHIRT',18.95,19.6,'Navy. 100% Cotton tee with embroidered Counter-Strike logo in white and yellow.','./images/magasin/CSShirt.jpg'),(15,1,'HALF-LIFE 2 GOOD D0G SHIRT',19.99,19.6,'Black Hanes','./images/magasin/GoodD0gShirt.jpg'),(16,1,'LEFT 4 DEAD DISTRESS-STYLED CAP',14.95,19.6,'100% cotton unstructured 6-panel construction. Enzyme-washed for a worn, apocalyptically-distressed look. One size fits all with metal d-ring slider buckle with hide-away strap closure.','./images/magasin/L4DHat.jpg'),(17,1,'PORTAL SHIRT',19.99,19.6,'Black American Apparel','./images/magasin/PortalShirt.jpg'),(18,1,'HALF-LIFE 2 DEATHMATCH LONG-SLEEVE SHIRT',24.95,19.6,'Long-Sleeve Gildan','./images/magasin/HL2DMLSShirt.jpg'),(19,1,'TEAM FORTRESS 2 HAT',14.95,19.6,'100% cotton twill with 6-panel construction. Low profile. Goldenrod Team Fortress 2 embroidery . One size fits all with Velcro enclosure.','./images/magasin/TF2Hat.jpg'),(20,1,'HALF-LIFE 2 HAT',14.95,19.6,'100% Black brushed cotton twill with reflective details on bill and the back strap. Low profile with the Half-Life','./images/magasin/HL2Hat.jpg'),(21,1,'LEFT 4 DEAD LONG-SLEEVE TEE',24.95,19.6,'Jet-black 4.3-ounce, 100% ring-spun combed cotton District Threads\"! t-shirt with Left 4 Dead logotype screen printed on upper left chest. Features a 40-singles fine knit perfect-weight cotton that\'s not too sheer, with a relaxed drape and a comfortable stretch. Lightweight and layerable.','./images/magasin/L4DShirt.jpg'),(22,4,'3D CONTENT / CREATION WITH XSI DVD',39.95,5.5,'Part one of the MOD Your World training series from Noesis Interactive, focuses on teaching how to \"Build Your Character\". Learn the nuts and bolts of the SOFTIMAGE|XSI interface, polygon modeling, texture application, generate props from scratch, and follow step-by-step instructions for creating biped characters. The DVD covers the basics of SOFTIMAGE|XSI 3D software including 3D layout, modeling, texturing, prop and character modeling and provides you with all the short cuts and tips.','./images/magasin/Noesis01.jpg');

--
-- Table structure for table `categorie`
--

CREATE TABLE `categorie` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(128) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `categorie`
--

INSERT INTO `categorie` VALUES (1,'Vetements'),(2,'Accessoires'),(3,'Posters'),(4,'DVD');

--
-- Table structure for table `marques`
--

CREATE TABLE `marques` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `marques`
--

INSERT INTO `marques` VALUES (2,'WooBox'),(4,'StappleInk'),(5,'TotalGeek'),(11,'test');

--
-- Table structure for table `produits`
--

CREATE TABLE `produits` (
  `id` int(11) NOT NULL,
  `nom` text NOT NULL,
  `prixUnitaire` double DEFAULT NULL,
  `stock` int(11) NOT NULL,
  `marque` tinyint(4) NOT NULL,
  `description` varchar(500) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Les produits vendus dans le magasin';

--
-- Dumping data for table `produits`
--

INSERT INTO `produits` VALUES (1234,'Casque audio A4G',39.99,35,2,'Type de casque circum-aural, Transducteur dynamique, semi-ouvert, Longueur du câble 3 m, Blanc'),(21334,'Enceinte Mobile Wireless',48,12,5,'Compatible Bluetooth, cette enceinte se connecte en sans-fil à vos smartphones, lecteurs MP3 ou encore tablettes compatibles, pour une liberté sans entrave ! Vous pouvez bien sûr également vous servir du câble audio de 30 cm inclus pour le connecter en filaire à votre appareil... '),(3245,'Caméra Sport HERO3+',439,9,2,'Wi-Fi 4 fois plus rapide : La caméra HERO3+ dans sa version Black améliore les performances du Wi-Fi qui devient 4x plus rapide, vous pouvez ainsi profiter de tous les équipements sans fil et contrôler la caméra à partir de l’application smartphone. Profitez également d\'une connectivité améliorée à la Wi-Fi Remote incluse, qui permet de contrôler jusqu\'à 50 caméras à une portée de 180 m. Contrôlez, visualisez en temps réel et partagez 4 fois plus vite !'),(5432,'Harnais Chest Mount Harness	',44.9,3,2,'Ce harnais offre de nouvelles possibilités à votre caméra !!  Il est destiné aux sportifs souhaitant fixer une caméra sur leur torse. '),(63453,'Brassard LifeProof',49.9,7,5,'Léger et très résistant, ce brassard ravira tout amateur de musique qui souhaite courir tout en écoutant ses morceaux favoris.'),(3354,'Mini Sentry sonore USB - Portal 2',39.99,3,5,'Du haut de ces 19 cm cette tourelle automatisée fera régner la terreur sur tous vos autres gadgets USB. Cette mignonne machine de guerre destinée à \"motiver\" les sujets de tests dans la résolution des énigmes possèdent les attributs classiques d\'une Sentry d\'Aperture Science. '),(887656,'G27 Racing Wheel PC/PS3',279.9,5,4,'Si le G25 a fait faire un bond en avant aux simulateurs de course, le volant G27 s\'impose dans sa droite lignée comme le maitre incontesté de l\'asphalte. Et il fait désormais office de référence dans son domaine !'),(77654,'Wothings Tensiomètre',79.99,8,2,'Véritable avancée technologique, le Tensiomètre créé par Wothings effectue des mesures instantanées, d’un seul geste.');


