FwKHum6f

1CREATE TABLE IF NOT EXISTS `employe` (
2  `id` int(5) NOT NULL AUTO_INCREMENT,
3  `nom` varchar(50) NOT NULL,
4  `prenom` varchar(50) NOT NULL,
5  `login` varchar(20) NOT NULL,
6  `password` varchar(20) NOT NULL,
7  PRIMARY KEY (`id`)
8) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
9
10--
11-- Contenu de la table `employe`
12--
13
14INSERT INTO `employe` (`id`, `nom`, `prenom`, `login`, `password`) VALUES
15(1, 'Martin', 'Luc', 'user1', 'pass1'),
16(2, 'Dupont', 'Jean', 'user2', 'pass2');