1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
|
CREATE TABLE IF NOT EXISTS `utilisateurs` (
`id` int(12) NOT NULL auto_increment,
`Nom` varchar(20) default '',
`Prenom` varchar(20) default '',
`Login` varchar(20) default '',
`Pass` varchar(30) default '',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`),
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
INSERT INTO `utilisateurs` (`id`, `Nom`, `Prenom`, `Login`, `Pass`) VALUES
(1, 'admin', 'admine', 'admin', '123456'),
(2, 'utiser1', 'users1', 'user1', 'mdp12345'),
(3, 'utiser2', 'users2', 'user2', 'mp123'),
(4, 'utiser3', 'users3', 'user3', 'mdp5432'); |
Partager