 
 CREATE TABLE IF NOT EXISTS `stock` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
-  `prod` int(11) NOT NULL,
-  `qte` int(11) NOT NULL,
-  PRIMARY KEY (`id`)
-) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;
-
---
--- Contenu de la table `stock`
---
-
-INSERT INTO `stock` (`id`, `prod`, `qte`) VALUES
-(13, 39, 4),
-(14, 40, 4),
-(15, 41, 4);
+  `qte` int(11) DEFAULT NULL,
+  `prod` int(11) DEFAULT NULL,
+  PRIMARY KEY (`id`),
+  KEY `FK_3wmkcdc4uc27yycyxy49ouuqf` (`prod`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Contenu de la table `produit`
+--
+
+INSERT INTO `stock` (`id`, `qte`, `prod`) VALUES
+(1, 50, 1),
+(2, 25, 2),
+(3, 10, 3),
+(4, 17, 4),
+(5, 22, 5),
+(6, 15, 6),
+(7, 45, 7),
+(8, 17, 8),
+(9, 22, 9),
+(10, 35, 10),
+(11, 12, 11),
+(12, 14, 12),
+(13, 68, 13),
+(14, 16, 14),
+(15, 28, 15);
 
 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;


CREATE TABLE IF NOT EXISTS `produit` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(55) NOT NULL,
  `caracteritique` text NOT NULL,
  `categorie` varchar(55) NOT NULL,
  `image` varchar(55) NOT NULL,
  `prix` float NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=42 ;

--
-- Contenu de la table `produit`
--

INSERT INTO `produit` (`id`, `libelle`, `caracteritique`, `categorie`, `image`, `prix`) VALUES
(39, 'Velo', 'Il roule', 'Vehicule', 'url/image', 4),
(40, 'Velo', 'Il roule', 'Vehicule', 'url/image', 4),
(41, 'Velo', 'Il roule', 'Vehicule', 'url/image', 4);

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


-- phpMyAdmin SQL Dump
-- version 4.1.4
-- http://www.phpmyadmin.net
--
-- Client :  127.0.0.1
-- Généré le :  Mar 11 Août 2015 à 09:21
-- Version du serveur :  5.6.15-log
-- Version de PHP :  5.4.24

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
