-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `ems_2023`
--

-- --------------------------------------------------------

--
-- Table structure for table `emails`
--

CREATE TABLE `emails` (
  `id` int NOT NULL,
  `to_email` varchar(255) DEFAULT NULL,
  `user_id` varchar(255) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `cc` varchar(255) DEFAULT NULL,
  `bcc` varchar(255) DEFAULT NULL,
  `attachment` varchar(255) DEFAULT NULL,
  `is_read` varchar(255) DEFAULT NULL,
  `reply_by` varchar(255) DEFAULT NULL,
  `sender_email_id` varchar(255) DEFAULT NULL,
  `content` varchar(255) DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `emails`
--

INSERT INTO `emails` (`id`, `to_email`, `user_id`, `subject`, `cc`, `bcc`, `attachment`, `is_read`, `reply_by`, `sender_email_id`, `content`, `created_by`, `updated_by`, `createdAt`, `updatedAt`) VALUES
(2, 'erdevkumar7@gmail.com', '5', 'subcription details', '', '', NULL, NULL, NULL, 'user@gmail.com', 'mecsdfds gfdgfd grfdg', NULL, NULL, '2023-11-07 18:41:35', '2023-11-07 18:41:35'),
(10, 'erdevkumar7@gmail.com', '5', 'new mee', NULL, NULL, NULL, NULL, NULL, 'user@gmail.com', 'datafgfbg', NULL, NULL, '2023-11-09 17:28:58', '2023-11-09 17:28:58'),
(11, 'erdevkumar7@gmail.com', '5', 'email test', NULL, NULL, NULL, NULL, NULL, 'user@gmail.com', 'java test', NULL, NULL, '2023-11-09 18:31:24', '2023-11-09 18:31:24'),
(12, 'erdevkumar7@gmail.com', '5', 'paper test', NULL, NULL, NULL, NULL, NULL, 'user@gmail.com', 'maths paper is greate', NULL, NULL, '2023-11-09 18:56:30', '2023-11-09 18:56:30'),
(13, 'user@gmail.com', '9', 'dfds', NULL, NULL, NULL, NULL, NULL, 'erdevkumar7@gmail.com', 'dfd asdjkljasd', NULL, NULL, '2023-11-09 18:59:28', '2023-11-09 18:59:28'),
(17, 'barodiyadevendra7@gmail.com', '18', 'Wecome', NULL, NULL, NULL, NULL, NULL, 'admin@emailmanagement.com', 'Thanks for registration', NULL, NULL, '2023-11-09 19:28:58', '2023-11-09 19:28:58'),
(18, 'tttt@co.in', '19', 'Wecome', NULL, NULL, NULL, NULL, NULL, 'admin@emailmanagement.com', 'Thanks for registration', NULL, NULL, '2023-11-09 19:36:39', '2023-11-09 19:36:39'),
(19, 'jarvish@gmail.com', '20', 'Wecome', NULL, NULL, NULL, NULL, NULL, 'admin@emailmanagement.com', 'Thanks for registration', NULL, NULL, '2024-03-29 15:02:45', '2024-03-29 15:02:45');

-- --------------------------------------------------------

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

CREATE TABLE `users` (
  `id` int NOT NULL,
  `first_name` varchar(255) DEFAULT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone_number` varchar(255) DEFAULT NULL,
  `profile_pic` varchar(255) DEFAULT NULL,
  `date_of_birth` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `loggedin_by` varchar(255) DEFAULT '',
  `loggedin_time` datetime DEFAULT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `users` (`id`, `first_name`, `last_name`, `email`, `phone_number`, `profile_pic`, `date_of_birth`, `password`, `created_by`, `updated_by`, `loggedin_by`, `loggedin_time`, `createdAt`, `updatedAt`) VALUES
(5, 'devendra', 'kumar', 'erdevkumar7@gmail.com', '4664645654756', '/uploads/profile1.jpeg', '10/12/2000', '$2b$10$QjTCPigxe3LS2W/sAV/06eAqH60pTIsMJQTIekrJgyJTaJCA9bebW', NULL, NULL, '', '2023-11-07 17:13:02', '2023-11-07 17:13:02', '2023-11-07 17:13:02'),
(9, 'myUser', 'Test', 'user@gmail.com', '6868686868', NULL, '686889689', '$2b$10$qw.A1gCkMYT1cJ4qnjL64.p13VQ9/ePuEDldeUeqJHuz3Y5COWhgq', NULL, NULL, '', '2023-11-09 17:09:39', '2023-11-09 17:09:39', '2023-11-09 17:09:39'),
(10, 'userN', 'lnam', 'user2@gmail.com', '35435475676', NULL, '6565654', '$2b$10$/4I2xzwLMWSd28YuGCx6DOO7uWnvDjsahORStg1B6CCkJV0/oYLkC', NULL, NULL, '', '2023-11-09 17:11:17', '2023-11-09 17:11:17', '2023-11-09 17:11:17'),
(18, 'Devendra Kumar', 'Barodiya', 'barodiyadevendra7@gmail.com', NULL, 'https://lh3.googleusercontent.com/a/ACg8ocK9zwMtw5aRogntNeUnlvHpXHd3DrYDOiLRb38A0u-IAPA=s96-c', NULL, '$2b$10$dpsl5C1glzjTTUMTY8/8x.BKGBtKdWbi.NeoqR44kDTkXyiIBWYze', NULL, NULL, 'google', '2023-11-09 19:28:55', '2023-11-09 19:28:55', '2023-11-09 19:41:15'),
(20, 'jarvish', 'que', 'jarvish@gmail.com', '9899898980', NULL, '05/02/1990', '$2b$10$CWuNwfQbGWmnUNSD7TOnzuH10lyn6SxNybdo9wg1SQGZa2CmpqnM.', NULL, NULL, '', '2024-03-29 15:02:40', '2024-03-29 15:02:40', '2024-03-29 15:02:40');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `emails`
--
ALTER TABLE `emails`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id` (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `emails`
--
ALTER TABLE `emails`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;
COMMIT;

