-- --------------------------------------------------------
-- Server OS:                    Win64
-- HeidiSQL Version:             12.10.0.7000
-- --------------------------------------------------------


-- Dumping structure for table congobetcd.users
CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nume` varchar(50) NOT NULL,
  `prenume` varchar(50) NOT NULL,
  `email` varchar(30) NOT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `country` varchar(20) DEFAULT NULL,
  `city` varchar(20) DEFAULT NULL,
  `data_added` datetime DEFAULT NULL,
  `pass` varchar(300) NOT NULL,
  `valid` int(1) NOT NULL DEFAULT 1,
  `review` int(1) NOT NULL DEFAULT 0,
  `token_email_verification` varchar(300) DEFAULT NULL,
  `date_verification` datetime DEFAULT NULL,
  `token_recover_pass` varchar(200) DEFAULT NULL,
  `date_recover` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table congobetcd.users: ~5 rows (approximately)
DELETE FROM `users`;
INSERT INTO `users` (`id`, `nume`, `prenume`, `email`, `phone`, `country`, `city`, `data_added`, `pass`, `valid`, `review`, `token_email_verification`, `date_verification`, `token_recover_pass`, `date_recover`) VALUES
	(1, 'CARP', 'Silviu', 'contact@carpsilviuionut.ro', '', NULL, NULL, '2023-07-26 12:31:26', '7fc8ffbd25af01027de4ac6419aba6fd09ea5336', 1, 1, NULL, '2023-07-26 12:33:57', '636f6e74616374406361727073696c766975696f6e75742e726f2a31363930333836363335', '2023-07-26 16:48:29'),
	(2, 'Tsanad', 'Maxence ', 'berosland@gmail.com', '00242056206919', NULL, NULL, '2023-08-10 16:13:21', '$2a$08$eU2NOCan4m6j/H/91DqeVu.NHsuODNfH.3ddvDRIBL8dCU..yMkce', 1, 0, '6265726f736c616e6440676d61696c2e636f6d2a313639313638303430312a4465636f7576657274', NULL, NULL, NULL),
	(3, 'cim', 'Marc', 'appocima2017@gmail.com', '0893956048', NULL, NULL, '2023-08-30 21:52:03', '$2a$08$.6tF7JKwRC82BxV4qi94T.YuoXNZg4OgDb1zPLdRE6m8unZjJr062', 1, 0, '6170706f63696d613230313740676d61696c2e636f6d2a313639333432383732332a6d756b616c613233', NULL, NULL, NULL),
	(4, 'BITSOUMANI', 'Mickeliane ', 'yannaubitsoumani5@outlook.com', '+242066290869', NULL, NULL, '2023-09-05 02:47:16', '$2a$08$xIx/AXpMYK29FB7vILinxOkUBP/TZ8oH1euATGBDiLzd6PRffbYXW', 1, 0, '79616e6e6175626974736f756d616e6935406f75746c6f6f6b2e636f6d2a313639333837383433362a303636323930383639', NULL, NULL, NULL),
	(5, 'kalombo', 'Chabani', 'chabanikalombo34@gmail.com', '0851402566', NULL, NULL, '2023-09-08 09:54:28', '$2a$08$MXoWOewjdphLdqLsUyoTOu8Kof/lE3BJHAbRsMkL9DV4wHs39V7cC', 1, 0, '63686162616e696b616c6f6d626f333440676d61696c2e636f6d2a313639343136333236382a313137313834', NULL, NULL, NULL);

