--
-- Host: localhost    Database: medvista
-- ------------------------------------------------------


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

CREATE TABLE `users` (
  `id` int NOT NULL AUTO_INCREMENT,
  `email` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `password` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `firstname` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `lastname` varchar(25) COLLATE utf8mb4_general_ci NOT NULL,
  `role` int NOT NULL COMMENT '1: admin, 2: doctor, 3: compounder, 4: patient ',
  `phone` bigint DEFAULT NULL,
  `status` int NOT NULL DEFAULT '1',
  `createdatetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modifieddatetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `filename` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `users` VALUES (2,'pratushraj1@gmail.com','$2b$12$q945w8XKLdW7sMbfK3Doa.93qZdCBRj1IZOZzXyR.01q3tWedxPSe','Pratush','Raj',2,NULL,0,'2024-07-04 09:08:15','2024-07-04 09:08:15','Screenshot (4908).png'),(8,'testuser@example.com','$2b$12$JR1nKcW4B2oVobH9m48rxuJbd1nIMxLJ5SfVH5w7JCrgjA/retCLO','Jane','Doe',2,NULL,0,'2024-08-23 11:23:19','2024-08-23 11:23:19','Screenshot (4909).png');


