-- 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');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

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

