-- MySQL dump 10.13  Distrib 5.6.30, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: desr4
-- ------------------------------------------------------
-- Server version	5.6.30-0ubuntu0.15.10.1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

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

DROP TABLE IF EXISTS `article`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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=23 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `article` WRITE;
/*!40000 ALTER TABLE `article` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `article` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2016-06-06 18:21:26
