--
-- Host: 127.0.0.1    Database: db_access_02709
-- ------------------------------------------------------


--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `pseudo` varchar(255) NOT NULL,
  `firstname` varchar(255) NOT NULL,
  `lastname` varchar(255) NOT NULL,
  `postname` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) DEFAULT NULL,
  `picture` varchar(255) DEFAULT NULL,
  `role_user_id` bigint unsigned NOT NULL,
  `is_admin` tinyint NOT NULL DEFAULT '0',
  `id_app` int NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `user_crea` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_pseudo_unique` (`pseudo`),
  UNIQUE KEY `users_email_unique` (`email`),
  KEY `users_role_user_id_foreign` (`role_user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb3 COMMENT='table des users';

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (1,'admin','chris','nyang\'s','kbg','0895139394','chrisnyangsss@gmail.com','$2y$10$vHbPD.aNIo4QKiBNMxIePuFbmMpeE38YnQsNpV1KR20cKnvUebR4K',NULL,1,1,0,1,'SYSADMIN','2023-10-02 10:29:43','2023-10-04 12:48:15'),(2,'dan','dave','nsangu',NULL,'+243815663001','chrisnyangsgg@gmail.com','$2y$10$vHbPD.aNIo4QKiBNMxIePuFbmMpeE38YnQsNpV1KR20cKnvUebR4K',NULL,1,1,4,1,'SYSADMIN','2023-12-11 00:38:36',NULL),(3,'pathy','pathy','Mbengi','','0895139394','pathymbengi@gmail.com','$2y$10$vHbPD.aNIo4QKiBNMxIePuFbmMpeE38YnQsNpV1KR20cKnvUebR4K',NULL,1,1,5,1,'SYSADMIN','2023-10-02 10:29:43','2023-10-04 12:48:15'),(4,'mbo','grace','Mbombo','Nyang\'s','0895139394','grambo@gmail.com','$2y$10$vHbPD.aNIo4QKiBNMxIePuFbmMpeE38YnQsNpV1KR20cKnvUebR4K',NULL,1,1,6,1,'SYSADMIN','2023-10-02 10:29:43','2023-10-04 12:48:15'),(5,'trika','trikepa','madi','kabo',NULL,'trika@gmail.com','$2y$10$vHbPD.aNIo4QKiBNMxIePuFbmMpeE38YnQsNpV1KR20cKnvUebR4K',NULL,1,1,7,1,'admin','2024-06-14 16:14:18','2024-06-14 16:14:18'),(10,'john','john','sapidi','kayembe','+243812289225','chrisnyangs@gmail.com','$2y$10$vHbPD.aNIo4QKiBNMxIePuFbmMpeE38YnQsNpV1KR20cKnvUebR4K',NULL,1,1,13,1,'admin','2024-08-09 12:39:54','2024-08-09 13:35:51'),(11,'pypy','chris','christo','nyano',NULL,'cnyango27@gmail.com','$2y$10$6xxGI./GXjJ0DQ2E9yaeVerzowBeVK2hZUBBAl0/t5iETwXkiU7ii',NULL,1,1,14,1,'admin','2025-03-18 18:40:25','2025-03-18 18:40:25'),(12,'PPPP','coti','chriisisi','nyango','+256333','christtty@gmail.com','$2y$10$icvRaN5a7/VlR6kXaUww3.hkz6HQ/BkV8AQOggI2S4m.FXHLAv/Wa',NULL,1,1,15,1,'admin','2025-03-18 18:45:13','2025-03-18 18:45:13'),(14,'ch','chirsto','chrmod','moda',NULL,'cnyang@gmail.com','$2y$10$EYUpThK2h4WU/J74beqRqOQ7hPyb9j8VkuWyZTqoR9xK1gdfI.Txu',NULL,1,1,17,1,'admin','2025-03-19 14:47:02','2025-03-19 14:47:02'),(15,'oliver','tshis','oliver',NULL,NULL,'oliver@gmail.com','$2y$10$SzY5kx9FQPJANMAEDShcLetuP2N9unjytITnkbBIwDyymdE88/XfK',NULL,1,0,18,1,'admin','2025-04-06 08:18:43','2025-04-06 08:18:43'),(16,'po','pa','po',NULL,NULL,'po@gmail.com','$2y$10$XVnH.UR/EO58l4UUkJTUTO3zlLkrAE7wjHg6mgoLmGzZsfQeq2c5a',NULL,1,0,19,1,'admin','2025-04-06 09:59:18','2025-04-06 09:59:18'),(17,'grace','de','grace',NULL,NULL,'grace@glm.dr','$2y$10$Ihysf785bV3hA2hPqL/iluIEjCErQBDQk.B7tnqVmEkbdZjx6/8G.',NULL,1,1,20,1,'admin','2025-04-06 10:03:43','2025-04-06 10:03:43'),(18,'tigo','chris','Nyangoty','Kbg',NULL,'christy@yahoo.fr','$2y$10$rzEK0l8WktRI25C76iCrvuZ2T5YELDaVke8hWw9fxTBADjAU1hxCC',NULL,1,1,21,1,'admin','2025-05-05 17:04:10','2025-05-05 17:04:10');


