--
-- Host: localhost    Database: qaio
-- ------------------------------------------------------


--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id` int NOT NULL AUTO_INCREMENT,
  `email` varchar(180) COLLATE utf8mb4_unicode_ci NOT NULL,
  `roles` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nom` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `prenom` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `telephone` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_8D93D649E7927C74` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user`
--

INSERT INTO `user` VALUES (1,'ferhati.azdine@qassil.com','a:1:{i:0;s:10:\"ROLE_ADMIN\";}','$2y$13$kAEOpVIA6KaUkRExSjeCGedcu3G0sW0bSMD.AZU9MP.YqJbYlpuy2','ferhati','azdine','9I0kX0YYWiElFVU6T4xBCMHASjizC1xzirj0yqznY1E','32456346634'),(2,'oum@gmail.com','a:1:{i:0;s:10:\"ROLE_ADMIN\";}','$2y$13$edZJNP2uH82X7JeGYnU2Au.9lidP34m849EDVOE0rdp7z5R1Afel2','sadeddine','Oumayma','OLan1s-gTZeg-0x5fFIR9ABk9TUrjAG69Sg3RGF4yi0','235353'),(3,'nahida@gmail.com','a:1:{i:0;s:9:\"ROLE_USER\";}','$2y$13$DwMOkCrlJgVKrmD7VG6E9.BhAqTTiEbLucCZVViUxeFBAdXBUuQO2','hamhami','nahida','mnULcQvYYijZ2lClYuaJ7BbPVsHLW94Qt-o5sEuFr1w','2351');


