--
-- Host: 127.0.0.1    Database: task
-- ------------------------------------------------------


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

CREATE TABLE `users` (
  `id` int NOT NULL AUTO_INCREMENT,
  `role` enum('admin','client','Attorney') NOT NULL DEFAULT 'client',
  `firstName` varchar(255) NOT NULL,
  `lastName` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `mobile` varchar(255) DEFAULT NULL,
  `street` varchar(255) DEFAULT NULL,
  `aptBlock` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `zipCode` varchar(255) DEFAULT NULL,
  `countryCode` varchar(255) DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `profileImage` varchar(255) DEFAULT NULL,
  `kycIdentity` varchar(255) DEFAULT NULL,
  `kycAddress` varchar(255) DEFAULT NULL,
  `termsAccepted` tinyint(1) DEFAULT '0',
  `createdAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `resetOtp` varchar(255) DEFAULT NULL,
  `resetOtpExpire` bigint DEFAULT NULL,
  `resetOtpVerified` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `users` VALUES (1,'client','Rituraj','Gour','rituraj@example.com','$2b$10$b5sC2wNKvtyKbL95u54v7eWRwbxHw4458A7J0QMh7Ubv8NlFpSyO6',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2025-12-11 22:29:05','2025-12-11 22:29:05',NULL,NULL,0),(2,'client','Rituraj','Gour','riturajsinghgour900@gmail.com','$2b$10$BgpYLEIhi5rHYrr2avEkBeul/3n1HP8rnDy6Aoc6Lgw4FJ2CiwgzO',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2025-12-11 23:46:09','2025-12-13 00:47:22',NULL,NULL,0),(3,'client','Rituraj','Gour','rituraj900@gmail.com','$2b$10$5sha5QYvWhJllM8YJRSKleU/undoXk36BQ1maRawHxAYAmJEsA0FC','9876543210','MG Road','B-12','Indore','Madhya Pradesh','India','452001','+91','2001-05-15',NULL,NULL,NULL,1,'2025-12-12 23:34:29','2025-12-13 00:07:13',NULL,NULL,0);


