 
 CREATE TABLE IF NOT EXISTS `facture` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
-  `date` date NOT NULL,
-  `modepaiement` varchar(55) NOT NULL,
-  `adresselivraison` int(11) NOT NULL,
-  `adressefacturation` int(11) NOT NULL,
-  `commande` int(11) NOT NULL,
+  `date` datetime DEFAULT NULL,
+  `modepaiement` varchar(255) DEFAULT NULL,
+  `adressefacturation` int(11) DEFAULT NULL,
+  `adresselivraison` int(11) DEFAULT NULL,
+  `commande_client` int(11) DEFAULT NULL,
+  PRIMARY KEY (`id`),
+  KEY `FK_ilt50sov3o16ehpn4ckgt08do` (`adressefacturation`),
+  KEY `FK_bt86xk42muci5i072vesiyxjh` (`adresselivraison`),
+  KEY `FK_fd9xc33bdvb29v6kssset4cup` (`commande_client`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Contenu de la table `facture`
+--
+
+INSERT INTO `facture` (`id`, `date`, `modepaiement`, `adresselivraison`, `adressefacturation`, `commande_client`) VALUES
+(1, '1970-01-01', 'Par CB', 1, 1, 1),
+(2, '1971-01-01', 'Par CB', 2, 2, 2),
+(3, '1972-01-01', 'Par CB', 3, 3, 3),
+(4, '1973-01-01', 'Par CB', 4, 4, 4),
+(5, '1974-01-01', 'Par CB', 5, 5, 5),
+(6, '1975-01-01', 'Par CB', 6, 6, 6),
+(7, '2000-01-01', 'Par CB', 7, 7, 7),
+(8, '2001-01-01', 'Par CB', 8, 8, 8),
+(9, '2002-01-01', 'Par CB', 9, 15, 9),
+(10, '2003-01-01', 'Par CB', 10, 16, 10),
+(11, '2004-01-01', 'Par CB', 11, 17, 11),
+(12, '2005-01-01', 'Par CB', 12, 12, 12),
+(13, '2006-01-01', 'Par CB', 13, 18, 13),
+(14, '2007-01-01', 'Par CB', 14, 19, 14),
+(15, '2008-01-01', 'Par CB', 15, 20, 15);
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `hibernate_sequence`
+--
+
+CREATE TABLE IF NOT EXISTS `hibernate_sequence` (
+  `next_val` bigint(20) DEFAULT NULL
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+--
+-- Contenu de la table `hibernate_sequence`
+--
+
+INSERT INTO `hibernate_sequence` (`next_val`) VALUES
+(1);
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `personne`
+--
+
+CREATE TABLE IF NOT EXISTS `personne` (
+  `type_personne` varchar(31) NOT NULL,
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `login` varchar(255) DEFAULT NULL,
+  `nom` varchar(255) DEFAULT NULL,
+  `password` varchar(255) DEFAULT NULL,
+  `prenom` varchar(255) DEFAULT NULL,
   PRIMARY KEY (`id`)
-) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ;
-
---
--- Contenu de la table `facture`
---
-
-INSERT INTO `facture` (`id`, `date`, `modepaiement`, `adresselivraison`, `adressefacturation`, `commande`) VALUES
-(22, '1970-01-01', 'Par CB', 87, 88, 36),
-(23, '1970-01-01', 'Par CB', 89, 90, 37),
-(24, '1970-01-01', 'Par CB', 91, 92, 38);
-
--- --------------------------------------------------------
-
---
--- Structure de la table `personne`
---
-
-CREATE TABLE IF NOT EXISTS `personne` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `nom` varchar(55) NOT NULL,
-  `prenom` varchar(55) NOT NULL,
-  `login` varchar(55) NOT NULL,
-  `password` varchar(55) NOT NULL,
-  `TYPE_PERSONNE` varchar(31) NOT NULL,
-  PRIMARY KEY (`id`)
-) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=101 ;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
 
 --
 -- Contenu de la table `personne`
 --
 
 INSERT INTO `personne` (`id`, `nom`, `prenom`, `login`, `password`, `TYPE_PERSONNE`) VALUES
-(87, 'modif', 'test', 'truc', 'machin', 'U'),
-(88, 'GUILLOTEAU', 'Nathan', 'login', 'login', 'U'),
-(89, 'GUILLOTEAU', 'Nathan', 'login', 'login', 'U'),
-(90, 'GUILLOTEAU', 'Nathan', 'login', 'login', 'U'),
-(93, 'Admin test', 'Test', 'loginAdmin', 'PwdAdmin', 'A'),
-(94, 'Admin test', 'Test', 'loginAdmin', 'PwdAdmin', 'A'),
-(95, 'Admin test', 'Test', 'loginAdmin', 'PwdAdmin', 'A'),
-(96, 'Admin test', 'Test', 'loginAdmin', 'PwdAdmin', 'A'),
-(97, 'Sans sss test modif', 'Test', 'loginAdmin', 'PwdAdmin', 'A');
+(1, 'OFFREDO', 'Simon', 'login', 'pwd', 'U'),
+(2, 'GUILLOTEAU', 'Nathan', 'loginDeNathan', 'pwdDeNathan', 'U'),
+(3, 'LEBON', 'Jonathan', 'loginDeJo', 'pwdDeJo', 'U'),
+(4, 'MACHAUX', 'Frederic', 'loginDeFred', 'pwdDeFred', 'U'),
+(5, 'STRATEUR', 'Admini', 'loginAdmin', 'pwdAdmin', 'A'),
+(6, 'ADMINISTRATEUR', 'Un-Autre', 'loginAutreAdmin', 'pwdAutreAdmin', 'A'),
+(7, 'FARAU', 'Romain', 'loginRomain', 'pwdRomain', 'U'),
+(8, 'KLEIN', 'Pauline', 'loginPauline', 'pwdPauline', 'U'),
+(9, 'USER1', 'User1', 'loginUser1', 'pwdUser1', 'U'),
+(10, 'USER2', 'User2', 'loginUser2', 'pwdUser2', 'U'),
+(11, 'USER3', 'User3', 'loginUser3', 'pwdUser3', 'U'),
+(12, 'USER4', 'User4', 'loginUser4', 'pwdUser4', 'U'),
+(13, 'USER5', 'User5', 'loginUser5', 'pwdUser5', 'U'),
+(14, 'USER6', 'User6', 'loginUser6', 'pwdUser6', 'U'),
+(15, 'USER7', 'User7', 'loginUser7', 'pwdUser7', 'U'),
+(16, 'USER8', 'User8', 'loginUser8', 'pwdUser8', 'U'),
+(17, 'USER9', 'User9', 'loginUser9', 'pwdUser9', 'U'),
+(18, 'USER10', 'User10', 'loginUser10', 'pwdUser10', 'U'),
+(19, 'USER11', 'User11', 'loginUser11', 'pwdUser11', 'U'),
+(20, 'USER12', 'User12', 'loginUser12', 'pwdUser12', 'U');
 
 -- --------------------------------------------------------
 


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);

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



CREATE TABLE IF NOT EXISTS `stock` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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 */;
