-- Structure de la table `commandes`
--

CREATE TABLE IF NOT EXISTS `commandes` (
  `id_commande` int(11) NOT NULL AUTO_INCREMENT,
  `time` date NOT NULL,
  `actif` int(11) NOT NULL,
  `id_membre` int(11) NOT NULL,
  `montant` int(11) NOT NULL,
  `ncommande` varchar(255) NOT NULL,
  PRIMARY KEY (`id_commande`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

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

INSERT INTO `commandes` (`id_commande`, `time`, `actif`, `id_membre`, `montant`, `ncommande`) VALUES
(1, '2013-06-11', 1, 36, 60, '11062013-135238-M1'),
(2, '2013-06-12', 1, 36, 80, '12062013-171630-H2');

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

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

CREATE TABLE IF NOT EXISTS `panier` (
  `id_client` int(11) NOT NULL,
  `panier_nom` varchar(255) NOT NULL,
  `panier_quantite` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `panier` (`id_client`, `panier_nom`, `panier_quantite`) VALUES
(36, 'batman arkham city ', 1),
(36, 'final fantasy 13 ', 2),
(36, 'batman arkham city ', 4);