1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| CREATE TABLE `usr` (
`NOM` varchar(50) NOT NULL,
`PRENOM` varchar(50) NOT NULL,
`LOGIN` varchar(50) NOT NULL,
`PASSW` varchar(100) NOT NULL,
`MAIL` varchar(50) NOT NULL,
`DROITS` varchar(1) NOT NULL,
`ETAT` varchar(1) NOT NULL,
`COMPTE` varchar(1) NOT NULL,
PRIMARY KEY (`LOGIN`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Contenu de la table `usr`
--
INSERT INTO `usr` (`NOM`, `PRENOM`, `LOGIN`, `PASSW`, `MAIL`, `DROITS`, `ETAT`, `COMPTE`) VALUES
('leclerc', 'antoine', 'admin', '63a9f0ea7bb98050796b649e85481845', 'admin@root.com', 'S', 'P', 'P'),
('Bioret', 'Amelie', 'amelie', '5b4ac833a90cb6fe84ca5672deb5fb0e', 'amelie@com', 'U', 'P', 'B'),
('Crochet', 'Capitaine', 'capcro', '87cf962b35146c21d0dd7f84594662b6', 'cap@cro.com', 'U', 'P', 'B'),
('Duck', 'Donald', 'disney', '87cf962b35146c21d0dd7f84594662b6', 'donald@duck.com', 'U', 'P', 'B'); |
Partager