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

START TRANSACTION;



--
-- Database: `eletsonl_cevc`
--

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

--
-- Table structure for table `avtaar_request`
--

CREATE TABLE `avtaar_request` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `email_id` text NOT NULL,
  `organization` text NOT NULL,
  `designation` text NOT NULL,
  `state_city` text NOT NULL,
  `request_message` text NOT NULL,
  `date_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `daily_user_tracking`
--

CREATE TABLE `daily_user_tracking` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `added_date` date NOT NULL,
  `modified_date` datetime NOT NULL,
  `category` varchar(25) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daily_user_tracking`
--

INSERT INTO `daily_user_tracking` (`id`, `user_id`, `added_date`, `modified_date`, `category`) VALUES
(1, 3, '2021-09-11', '2021-09-11 18:12:15', 'Auditorium'),
(2, 3, '2021-09-11', '2021-09-11 18:27:11', 'Lobby'),
(3, 3, '2021-09-13', '2021-09-13 12:26:04', 'Auditorium'),
(4, 3, '2021-09-13', '2021-09-13 12:26:54', 'Lobby'),
(5, 4, '2021-09-13', '2021-09-13 10:26:31', 'Lobby'),
(6, 7, '2021-09-13', '2021-09-13 15:18:50', 'Auditorium'),
(7, 7, '2021-09-13', '2021-09-13 15:18:56', 'Lobby'),
(8, 10, '2021-09-13', '2021-09-13 12:21:56', 'Auditorium'),
(9, 10, '2021-09-13', '2021-09-13 12:23:49', 'Lobby'),
(10, 9, '2021-09-13', '2021-09-13 13:12:37', 'Lobby'),
(11, 9, '2021-09-13', '2021-09-13 13:13:27', 'Auditorium'),
(12, 10, '2021-09-14', '2021-09-14 13:34:06', 'Lobby'),
(13, 10, '2021-09-14', '2021-09-14 14:58:42', 'Auditorium'),
(14, 7, '2021-09-14', '2021-09-14 13:59:08', 'Lobby'),
(15, 7, '2021-09-14', '2021-09-14 16:32:07', 'Auditorium'),
(16, 3, '2021-09-14', '2021-09-14 14:56:02', 'Lobby'),
(17, 3, '2021-09-14', '2021-09-14 14:56:07', 'Auditorium'),
(18, 4, '2021-09-14', '2021-09-14 14:43:50', 'Auditorium'),
(19, 9, '2021-09-14', '2021-09-14 14:59:52', 'Lobby'),
(20, 4, '2021-09-14', '2021-09-14 12:21:00', 'Lobby'),
(21, 1, '2021-09-14', '2021-09-14 12:51:16', 'Auditorium'),
(22, 9, '2021-09-14', '2021-09-14 14:59:56', 'Auditorium'),
(23, 124, '2021-09-14', '2021-09-14 14:03:29', 'Lobby'),
(24, 71, '2021-09-14', '2021-09-14 14:10:28', 'Lobby'),
(25, 120, '2021-09-14', '2021-09-14 13:50:46', 'Lobby'),
(26, 92, '2021-09-14', '2021-09-14 13:55:58', 'Lobby'),
(27, 103, '2021-09-14', '2021-09-14 15:12:30', 'Lobby'),
(28, 13, '2021-09-14', '2021-09-14 15:04:55', 'Lobby'),
(29, 13, '2021-09-14', '2021-09-14 15:05:02', 'Auditorium'),
(30, 125, '2021-09-14', '2021-09-14 14:11:28', 'Lobby'),
(31, 126, '2021-09-14', '0000-00-00 00:00:00', 'Lobby'),
(32, 120, '2021-09-14', '0000-00-00 00:00:00', 'Auditorium'),
(33, 59, '2021-09-14', '2021-09-14 14:28:33', 'Lobby'),
(34, 127, '2021-09-14', '2021-09-14 14:02:24', 'Lobby'),
(35, 101, '2021-09-14', '2021-09-14 15:48:09', 'Lobby'),
(36, 125, '2021-09-14', '2021-09-14 15:03:52', 'Auditorium'),
(37, 53, '2021-09-14', '0000-00-00 00:00:00', 'Lobby'),
(38, 109, '2021-09-14', '2021-09-14 16:10:17', 'Lobby'),
(39, 110, '2021-09-14', '2021-09-14 14:53:05', 'Lobby'),
(40, 109, '2021-09-14', '2021-09-14 16:29:43', 'Auditorium'),
(41, 128, '2021-09-14', '2021-09-14 14:18:32', 'Lobby'),
(42, 57, '2021-09-14', '2021-09-14 14:17:17', 'Lobby'),
(43, 127, '2021-09-14', '2021-09-14 14:02:26', 'Auditorium'),
(44, 66, '2021-09-14', '2021-09-14 15:52:59', 'Lobby'),
(45, 102, '2021-09-14', '2021-09-14 14:06:04', 'Lobby'),
(46, 53, '2021-09-14', '0000-00-00 00:00:00', 'Auditorium'),
(47, 86, '2021-09-14', '0000-00-00 00:00:00', 'Lobby'),
(48, 129, '2021-09-14', '2021-09-14 17:32:19', 'Lobby'),
(49, 66, '2021-09-14', '2021-09-14 16:11:07', 'Auditorium'),
(50, 86, '2021-09-14', '2021-09-14 13:55:54', 'Auditorium'),
(51, 14, '2021-09-14', '2021-09-14 16:50:41', 'Lobby'),
(52, 102, '2021-09-14', '2021-09-14 14:57:45', 'Auditorium'),
(53, 58, '2021-09-14', '0000-00-00 00:00:00', 'Lobby'),
(54, 128, '2021-09-14', '2021-09-14 14:19:38', 'Auditorium'),
(55, 58, '2021-09-14', '0000-00-00 00:00:00', 'Auditorium'),
(56, 101, '2021-09-14', '2021-09-14 15:48:17', 'Auditorium'),
(57, 70, '2021-09-14', '2021-09-14 14:41:48', 'Lobby'),
(58, 67, '2021-09-14', '0000-00-00 00:00:00', 'Lobby'),
(59, 59, '2021-09-14', '2021-09-14 14:29:02', 'Auditorium'),
(60, 62, '2021-09-14', '2021-09-14 15:10:52', 'Lobby'),
(61, 62, '2021-09-14', '2021-09-14 15:11:18', 'Auditorium'),
(62, 130, '2021-09-14', '2021-09-14 14:00:48', 'Lobby'),
(63, 95, '2021-09-14', '2021-09-14 14:23:56', 'Lobby'),
(64, 124, '2021-09-14', '2021-09-14 17:24:01', 'Auditorium'),
(65, 130, '2021-09-14', '0000-00-00 00:00:00', 'Auditorium'),
(66, 95, '2021-09-14', '2021-09-14 14:17:52', 'Auditorium'),
(67, 131, '2021-09-14', '0000-00-00 00:00:00', 'Lobby'),
(68, 132, '2021-09-14', '2021-09-14 14:04:14', 'Lobby'),
(69, 133, '2021-09-14', '2021-09-14 14:25:00', 'Lobby'),
(70, 134, '2021-09-14', '2021-09-14 14:06:01', 'Lobby'),
(71, 132, '2021-09-14', '2021-09-14 14:04:21', 'Auditorium'),
(72, 135, '2021-09-14', '0000-00-00 00:00:00', 'Lobby'),
(73, 76, '2021-09-14', '2021-09-14 14:04:43', 'Lobby'),
(74, 111, '2021-09-14', '2021-09-14 14:16:20', 'Lobby'),
(75, 136, '2021-09-14', '0000-00-00 00:00:00', 'Lobby'),
(76, 136, '2021-09-14', '0000-00-00 00:00:00', 'Auditorium'),
(77, 133, '2021-09-14', '2021-09-14 14:25:09', 'Auditorium'),
(78, 111, '2021-09-14', '0000-00-00 00:00:00', 'Auditorium'),
(79, 137, '2021-09-14', '2021-09-14 16:30:11', 'Lobby'),
(80, 134, '2021-09-14', '0000-00-00 00:00:00', 'Auditorium'),
(81, 87, '2021-09-14', '0000-00-00 00:00:00', 'Lobby'),
(82, 87, '2021-09-14', '0000-00-00 00:00:00', 'Auditorium'),
(83, 138, '2021-09-14', '2021-09-14 15:06:24', 'Lobby'),
(84, 57, '2021-09-14', '2021-09-14 14:17:45', 'Auditorium'),
(85, 139, '2021-09-14', '2021-09-14 14:12:03', 'Lobby'),
(86, 16, '2021-09-14', '2021-09-14 14:11:51', 'Lobby'),
(87, 140, '2021-09-14', '2021-09-14 14:12:38', 'Lobby'),
(88, 140, '2021-09-14', '2021-09-14 14:12:39', 'Auditorium'),
(89, 138, '2021-09-14', '2021-09-14 15:06:42', 'Auditorium'),
(90, 93, '2021-09-14', '2021-09-14 15:48:52', 'Lobby'),
(91, 141, '2021-09-14', '2021-09-14 14:24:06', 'Lobby'),
(92, 142, '2021-09-14', '0000-00-00 00:00:00', 'Lobby'),
(93, 143, '2021-09-14', '0000-00-00 00:00:00', 'Lobby'),
(94, 64, '2021-09-14', '2021-09-14 14:25:39', 'Lobby'),
(95, 144, '2021-09-14', '2021-09-14 14:24:59', 'Lobby'),
(96, 64, '2021-09-14', '0000-00-00 00:00:00', 'Auditorium'),
(97, 144, '2021-09-14', '2021-09-14 15:34:10', 'Auditorium'),
(98, 85, '2021-09-14', '2021-09-14 14:31:31', 'Lobby'),
(99, 145, '2021-09-14', '0000-00-00 00:00:00', 'Lobby'),
(100, 146, '2021-09-14', '2021-09-14 15:27:46', 'Lobby'),
(101, 85, '2021-09-14', '0000-00-00 00:00:00', 'Auditorium'),
(102, 147, '2021-09-14', '2021-09-14 14:33:56', 'Lobby'),
(103, 148, '2021-09-14', '0000-00-00 00:00:00', 'Lobby'),
(104, 147, '2021-09-14', '2021-09-14 14:34:51', 'Auditorium'),
(105, 149, '2021-09-14', '2021-09-14 14:34:48', 'Lobby'),
(106, 149, '2021-09-14', '0000-00-00 00:00:00', 'Auditorium'),
(107, 14, '2021-09-14', '2021-09-14 19:11:14', 'Auditorium'),
(108, 110, '2021-09-14', '2021-09-14 14:53:12', 'Auditorium'),
(109, 150, '2021-09-14', '0000-00-00 00:00:00', 'Lobby'),
(110, 150, '2021-09-14', '0000-00-00 00:00:00', 'Auditorium'),
(111, 83, '2021-09-14', '2021-09-14 14:46:22', 'Lobby'),
(112, 90, '2021-09-14', '2021-09-14 14:47:27', 'Lobby'),
(113, 151, '2021-09-14', '2021-09-14 14:53:59', 'Lobby'),
(114, 90, '2021-09-14', '0000-00-00 00:00:00', 'Auditorium'),
(115, 115, '2021-09-14', '0000-00-00 00:00:00', 'Lobby'),
(116, 152, '2021-09-14', '2021-09-14 15:51:18', 'Lobby'),
(117, 153, '2021-09-14', '2021-09-14 14:55:36', 'Lobby'),
(118, 153, '2021-09-14', '2021-09-14 14:55:00', 'Auditorium'),
(119, 151, '2021-09-14', '2021-09-14 14:56:10', 'Auditorium'),
(120, 155, '2021-09-14', '2021-09-14 15:03:39', 'Lobby'),
(121, 154, '2021-09-14', '2021-09-14 14:59:40', 'Lobby'),
(122, 154, '2021-09-14', '2021-09-14 14:59:45', 'Auditorium'),
(123, 156, '2021-09-14', '0000-00-00 00:00:00', 'Lobby'),
(124, 157, '2021-09-14', '0000-00-00 00:00:00', 'Lobby'),
(125, 160, '2021-09-14', '2021-09-14 15:06:51', 'Lobby'),
(126, 159, '2021-09-14', '2021-09-14 15:26:40', 'Lobby'),
(127, 161, '2021-09-14', '2021-09-14 15:09:13', 'Lobby'),
(128, 161, '2021-09-14', '0000-00-00 00:00:00', 'Auditorium'),
(129, 159, '2021-09-14', '0000-00-00 00:00:00', 'Auditorium'),
(130, 54, '2021-09-14', '2021-09-14 15:52:35', 'Lobby'),
(131, 54, '2021-09-14', '2021-09-14 16:25:02', 'Auditorium'),
(132, 137, '2021-09-14', '2021-09-14 16:10:20', 'Auditorium'),
(133, 160, '2021-09-14', '0000-00-00 00:00:00', 'Auditorium'),
(134, 162, '2021-09-14', '2021-09-14 17:06:45', 'Lobby'),
(135, 103, '2021-09-14', '2021-09-14 15:46:13', 'Auditorium'),
(136, 163, '2021-09-14', '2021-09-14 15:42:44', 'Lobby'),
(137, 163, '2021-09-14', '2021-09-14 15:19:25', 'Auditorium'),
(138, 152, '2021-09-14', '2021-09-14 16:05:28', 'Auditorium'),
(139, 165, '2021-09-14', '2021-09-14 15:42:41', 'Lobby'),
(140, 167, '2021-09-14', '0000-00-00 00:00:00', 'Lobby'),
(141, 166, '2021-09-14', '2021-09-14 15:23:04', 'Lobby'),
(142, 166, '2021-09-14', '2021-09-14 15:23:11', 'Auditorium'),
(143, 168, '2021-09-14', '0000-00-00 00:00:00', 'Lobby'),
(144, 168, '2021-09-14', '0000-00-00 00:00:00', 'Auditorium'),
(145, 165, '2021-09-14', '2021-09-14 15:43:56', 'Auditorium'),
(146, 170, '2021-09-14', '2021-09-14 16:42:17', 'Lobby'),
(147, 170, '2021-09-14', '2021-09-14 16:42:24', 'Auditorium'),
(148, 171, '2021-09-14', '2021-09-14 16:33:30', 'Lobby'),
(149, 171, '2021-09-14', '2021-09-14 16:32:24', 'Auditorium'),
(150, 172, '2021-09-14', '2021-09-14 16:42:44', 'Lobby'),
(151, 172, '2021-09-14', '2021-09-14 16:45:23', 'Auditorium'),
(152, 173, '2021-09-14', '2021-09-14 17:21:07', 'Lobby'),
(153, 173, '2021-09-14', '2021-09-14 17:21:32', 'Auditorium'),
(154, 68, '2021-09-14', '0000-00-00 00:00:00', 'Lobby'),
(155, 129, '2021-09-14', '2021-09-14 17:30:19', 'Auditorium'),
(156, 174, '2021-09-14', '0000-00-00 00:00:00', 'Lobby'),
(157, 174, '2021-09-14', '0000-00-00 00:00:00', 'Auditorium'),
(158, 175, '2021-09-14', '0000-00-00 00:00:00', 'Lobby'),
(159, 176, '2021-09-14', '2021-09-14 18:06:31', 'Lobby'),
(160, 176, '2021-09-14', '0000-00-00 00:00:00', 'Auditorium'),
(161, 177, '2021-09-14', '2021-09-14 20:24:06', 'Lobby'),
(162, 178, '2021-09-14', '2021-09-14 20:51:53', 'Lobby'),
(163, 178, '2021-09-14', '0000-00-00 00:00:00', 'Auditorium'),
(164, 81, '2021-09-14', '2021-09-14 21:59:19', 'Lobby'),
(165, 81, '2021-09-14', '0000-00-00 00:00:00', 'Auditorium'),
(166, 179, '2021-09-15', '2021-09-15 02:11:14', 'Lobby'),
(167, 117, '2021-09-15', '0000-00-00 00:00:00', 'Lobby'),
(168, 180, '2021-09-15', '2021-09-15 09:54:40', 'Lobby'),
(169, 180, '2021-09-15', '2021-09-15 09:54:18', 'Auditorium'),
(170, 58, '2021-09-15', '0000-00-00 00:00:00', 'Lobby'),
(171, 71, '2021-09-15', '0000-00-00 00:00:00', 'Lobby'),
(172, 181, '2021-09-16', '0000-00-00 00:00:00', 'Lobby'),
(173, 181, '2021-09-16', '0000-00-00 00:00:00', 'Auditorium'),
(174, 182, '2021-09-18', '2021-09-18 10:48:12', 'Lobby'),
(175, 182, '2021-09-18', '0000-00-00 00:00:00', 'Auditorium'),
(176, 16, '2021-09-20', '0000-00-00 00:00:00', 'Lobby'),
(177, 16, '2021-09-21', '0000-00-00 00:00:00', 'Lobby'),
(178, 16, '2021-09-23', '2021-09-23 23:41:25', 'Lobby'),
(179, 7, '2021-09-27', '2021-09-27 13:25:39', 'Lobby');

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

--
-- Table structure for table `eventcategory`
--

CREATE TABLE `eventcategory` (
  `id` int(11) NOT NULL,
  `category_name` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `added_date` datetime NOT NULL,
  `modified_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `eventcategory`
--

INSERT INTO `eventcategory` (`id`, `category_name`, `added_date`, `modified_date`) VALUES
(1, 'Lobby', '2020-10-03 10:29:11', '2020-10-03 10:29:11'),
(2, 'Auditorium', '2020-10-03 10:31:05', '2020-10-03 10:31:05'),
(3, 'Higher Education', '2020-10-03 10:48:15', '2020-10-03 10:48:15'),
(6, 'Sponsor', '2020-10-08 09:58:35', '2020-10-08 09:58:35'),
(9, 'EletsTechnomedia', '2020-10-11 12:26:23', '2020-10-11 12:26:23');

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

--
-- Table structure for table `eventdell_feedback`
--

CREATE TABLE `eventdell_feedback` (
  `id` int(10) NOT NULL,
  `user_id` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `dell_question1` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `dell_question2` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `dell_question3` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `dell_question4` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `dell_question5` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `dell_question6` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `dell_question7` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `dell_question8` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_on` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `eventvideos`
--

CREATE TABLE `eventvideos` (
  `id` int(11) NOT NULL,
  `video_title` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `video_embedded` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `category_id` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `video_type` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `video_open_status` int(11) NOT NULL DEFAULT '0',
  `added_date` datetime NOT NULL,
  `modified_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `eventvideos`
--

INSERT INTO `eventvideos` (`id`, `video_title`, `video_embedded`, `category_id`, `video_type`, `video_open_status`, `added_date`, `modified_date`) VALUES
(1, 'Elets', '483728957', '1', 'vimeo', 1, '2021-06-22 15:01:46', '2021-06-22 15:01:46'),
(2, 'Auditorium', '1282718', '2', 'live streaming', 1, '2021-09-14 04:33:47', '2021-09-14 04:33:47'),
(3, 'EletsTechnomedia', 'YyXYtrecUTU', '9', 'youtube', 1, '2020-10-11 12:37:18', '2020-10-11 12:37:18');

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

--
-- Table structure for table `event_feedback`
--

CREATE TABLE `event_feedback` (
  `id` int(10) NOT NULL,
  `user_id` int(11) NOT NULL,
  `u_ans_one` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `u_ans_two` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `u_ans_three` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `u_ans_four` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `boothname` text COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `event_notification`
--

CREATE TABLE `event_notification` (
  `id` int(11) NOT NULL,
  `notification` text NOT NULL,
  `date_on` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `event_notification`
--

INSERT INTO `event_notification` (`id`, `notification`, `date_on`) VALUES
(1, 'Welcome To Chhattisgarh Electric Vehicle Conclave 2021', '2021-09-08 05:09:42');

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

--
-- Table structure for table `event_usertacking`
--

CREATE TABLE `event_usertacking` (
  `id` int(11) NOT NULL,
  `event_section` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `timing` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `point` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_on` text COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `event_usertacking`
--

INSERT INTO `event_usertacking` (`id`, `event_section`, `user_id`, `timing`, `point`, `date_on`) VALUES
(1, 'Auditorium', '3', '39', '3900', '2021-09-14 14:56:08'),
(2, 'Lobby', '3', '86', '8600', '2021-09-14 14:56:04'),
(3, 'Sponsor', '3', '1', '100', '2021-09-11 18:26:03'),
(5, 'Auditorium', '7', '26', '2600', '2021-09-14 16:32:08'),
(6, 'Lobby', '7', '56', '5600', '2021-09-27 13:25:41'),
(7, 'Auditorium', '10', '25', '2500', '2021-09-14 14:58:45'),
(8, 'Lobby', '10', '49', '4900', '2021-09-14 13:34:07'),
(9, 'Lobby', '9', '12', '1200', '2021-09-14 14:59:54'),
(10, 'Auditorium', '9', '11', '1100', '2021-09-14 14:59:56'),
(11, 'Auditorium', '4', '6', '600', '2021-09-14 14:43:52'),
(12, 'Lobby', '4', '16', '1600', '2021-09-14 12:21:00'),
(13, 'Auditorium', '1', '2', '200', '2021-09-14 12:51:17'),
(14, 'Lobby', '124', '7', '700', '2021-09-14 14:03:30'),
(15, 'Lobby', '71', '8', '800', '2021-09-15 17:18:19'),
(16, 'Lobby', '120', '2', '200', '2021-09-14 13:50:47'),
(17, 'Lobby', '92', '3', '300', '2021-09-14 13:55:59'),
(18, 'Lobby', '103', '9', '900', '2021-09-14 15:12:31'),
(19, 'Lobby', '13', '6', '600', '2021-09-14 15:04:55'),
(20, 'Auditorium', '13', '6', '600', '2021-09-14 15:05:02'),
(21, 'Lobby', '125', '2', '200', '2021-09-14 14:11:33'),
(22, 'Lobby', '126', '1', '100', '2021-09-14 13:51:19'),
(23, 'Auditorium', '120', '1', '100', '2021-09-14 13:51:46'),
(24, 'Lobby', '127', '5', '500', '2021-09-14 14:02:25'),
(25, 'Lobby', '59', '3', '300', '2021-09-14 14:28:34'),
(26, 'Lobby', '101', '8', '800', '2021-09-14 15:48:12'),
(27, 'Auditorium', '125', '5', '500', '2021-09-14 15:03:52'),
(28, 'Lobby', '53', '1', '100', '2021-09-14 13:53:21'),
(29, 'Lobby', '109', '2', '200', '2021-09-14 16:10:17'),
(30, 'Lobby', '110', '5', '500', '2021-09-14 14:53:06'),
(31, 'Auditorium', '109', '6', '600', '2021-09-14 16:29:44'),
(32, 'Lobby', '128', '3', '300', '2021-09-14 14:18:33'),
(33, 'Lobby', '57', '3', '300', '2021-09-14 14:17:18'),
(34, 'Auditorium', '127', '4', '400', '2021-09-14 14:02:27'),
(35, 'Lobby', '66', '2', '200', '2021-09-14 15:53:00'),
(36, 'Auditorium', '53', '1', '100', '2021-09-14 13:54:41'),
(37, 'Lobby', '102', '9', '900', '2021-09-14 14:06:05'),
(38, 'Lobby', '86', '1', '100', '2021-09-14 13:55:12'),
(39, 'Lobby', '129', '8', '800', '2021-09-14 17:32:20'),
(40, 'Auditorium', '66', '6', '600', '2021-09-14 16:11:08'),
(41, 'Auditorium', '86', '2', '200', '2021-09-14 13:55:55'),
(42, 'Lobby', '14', '8', '800', '2021-09-14 15:20:46'),
(43, 'Auditorium', '102', '7', '700', '2021-09-14 14:57:49'),
(44, 'Lobby', '58', '1', '100', '2021-09-14 13:56:19'),
(45, 'Auditorium', '128', '4', '400', '2021-09-14 14:19:39'),
(46, 'Auditorium', '58', '1', '100', '2021-09-14 13:56:40'),
(47, 'Auditorium', '101', '10', '1000', '2021-09-14 15:48:20'),
(48, 'Lobby', '70', '5', '500', '2021-09-14 14:41:48'),
(49, 'Lobby', '67', '1', '100', '2021-09-14 13:56:58'),
(50, 'Auditorium', '59', '2', '200', '2021-09-14 14:29:02'),
(51, 'Lobby', '62', '7', '700', '2021-09-14 15:10:52'),
(52, 'Auditorium', '62', '7', '700', '2021-09-14 15:11:19'),
(53, 'Lobby', '130', '2', '200', '2021-09-14 14:00:49'),
(54, 'Lobby', '95', '2', '200', '2021-09-14 14:23:57'),
(55, 'Auditorium', '124', '5', '500', '2021-09-14 17:24:03'),
(56, 'Auditorium', '130', '1', '100', '2021-09-14 14:00:53'),
(57, 'Auditorium', '95', '3', '300', '2021-09-14 14:17:54'),
(58, 'Lobby', '131', '1', '100', '2021-09-14 14:01:14'),
(59, 'Lobby', '132', '3', '300', '2021-09-14 14:04:14'),
(60, 'Lobby', '133', '4', '400', '2021-09-14 14:25:00'),
(61, 'Lobby', '134', '2', '200', '2021-09-14 14:06:03'),
(62, 'Auditorium', '132', '2', '200', '2021-09-14 14:04:22'),
(63, 'Lobby', '135', '1', '100', '2021-09-14 14:04:16'),
(64, 'Lobby', '76', '2', '200', '2021-09-14 14:04:43'),
(65, 'Lobby', '111', '7', '700', '2021-09-14 14:16:21'),
(66, 'Lobby', '136', '1', '100', '2021-09-14 14:04:50'),
(67, 'Auditorium', '136', '1', '100', '2021-09-14 14:04:55'),
(68, 'Auditorium', '133', '2', '200', '2021-09-14 14:25:09'),
(69, 'Auditorium', '111', '1', '100', '2021-09-14 14:05:10'),
(70, 'Lobby', '137', '5', '500', '2021-09-14 16:30:11'),
(71, 'Auditorium', '134', '1', '100', '2021-09-14 14:07:05'),
(72, 'Lobby', '87', '1', '100', '2021-09-14 14:07:12'),
(73, 'Auditorium', '87', '1', '100', '2021-09-14 14:08:20'),
(74, 'Lobby', '138', '4', '400', '2021-09-14 15:06:24'),
(75, 'Auditorium', '57', '2', '200', '2021-09-14 14:17:46'),
(76, 'Lobby', '139', '2', '200', '2021-09-14 14:12:07'),
(77, 'Lobby', '16', '4', '400', '2021-09-21 00:12:53'),
(78, 'Lobby', '140', '1', '100', '2021-09-14 14:11:16'),
(79, 'Auditorium', '140', '1', '100', '2021-09-14 14:12:42'),
(80, 'Auditorium', '138', '3', '300', '2021-09-14 15:06:42'),
(81, 'Lobby', '93', '2', '200', '2021-09-14 15:48:53'),
(82, 'Lobby', '141', '4', '400', '2021-09-14 14:24:06'),
(83, 'Lobby', '142', '1', '100', '2021-09-14 14:18:22'),
(84, 'Lobby', '143', '1', '100', '2021-09-14 14:20:30'),
(85, 'Lobby', '64', '5', '500', '2021-09-14 14:25:39'),
(86, 'Lobby', '144', '3', '300', '2021-09-14 14:25:00'),
(87, 'Auditorium', '64', '1', '100', '2021-09-14 14:24:08'),
(88, 'Auditorium', '144', '2', '200', '2021-09-14 15:34:11'),
(89, 'Lobby', '85', '2', '200', '2021-09-14 14:31:31'),
(90, 'Lobby', '145', '1', '100', '2021-09-14 14:27:54'),
(91, 'Lobby', '146', '3', '300', '2021-09-14 15:27:47'),
(92, 'Auditorium', '85', '1', '100', '2021-09-14 14:29:37'),
(93, 'Lobby', '147', '4', '400', '2021-09-14 14:33:56'),
(94, 'Lobby', '148', '1', '100', '2021-09-14 14:30:34'),
(95, 'Auditorium', '147', '4', '400', '2021-09-14 14:34:52'),
(96, 'Lobby', '149', '2', '200', '2021-09-14 14:34:48'),
(97, 'Auditorium', '149', '1', '100', '2021-09-14 14:34:53'),
(98, 'Auditorium', '14', '7', '700', '2021-09-14 19:11:18'),
(99, 'Auditorium', '110', '3', '300', '2021-09-14 14:53:14'),
(100, 'Lobby', '150', '1', '100', '2021-09-14 14:41:18'),
(101, 'Auditorium', '150', '1', '100', '2021-09-14 14:44:07'),
(102, 'Lobby', '83', '2', '200', '2021-09-14 14:46:23'),
(103, 'Lobby', '90', '4', '400', '2021-09-14 14:47:27'),
(104, 'Auditorium', '90', '1', '100', '2021-09-14 14:47:22'),
(105, 'Lobby', '151', '3', '300', '2021-09-14 14:54:00'),
(106, 'Lobby', '115', '1', '100', '2021-09-14 14:47:36'),
(107, 'Lobby', '152', '9', '900', '2021-09-14 15:51:19'),
(108, 'Lobby', '153', '5', '500', '2021-09-14 14:55:36'),
(109, 'Auditorium', '153', '2', '200', '2021-09-14 14:55:01'),
(110, 'Auditorium', '151', '3', '300', '2021-09-14 14:56:15'),
(111, 'Lobby', '155', '3', '300', '2021-09-14 15:03:40'),
(112, 'Lobby', '154', '3', '300', '2021-09-14 14:59:40'),
(113, 'Auditorium', '154', '6', '600', '2021-09-14 14:59:45'),
(114, 'Lobby', '156', '1', '100', '2021-09-14 14:59:37'),
(115, 'Lobby', '157', '1', '100', '2021-09-14 15:03:39'),
(116, 'Lobby', '160', '2', '200', '2021-09-14 15:06:51'),
(117, 'Lobby', '159', '6', '600', '2021-09-14 15:26:40'),
(118, 'Lobby', '161', '2', '200', '2021-09-14 15:09:13'),
(119, 'Auditorium', '161', '1', '100', '2021-09-14 15:09:24'),
(120, 'Auditorium', '159', '1', '100', '2021-09-14 15:09:34'),
(121, 'Lobby', '54', '2', '200', '2021-09-14 15:52:36'),
(122, 'Auditorium', '54', '18', '1800', '2021-09-14 16:25:02'),
(123, 'Auditorium', '137', '3', '300', '2021-09-14 16:10:21'),
(124, 'Auditorium', '160', '1', '100', '2021-09-14 15:11:46'),
(125, 'Lobby', '162', '3', '300', '2021-09-14 17:06:45'),
(126, 'Auditorium', '103', '5', '500', '2021-09-14 15:46:13'),
(127, 'Lobby', '163', '7', '700', '2021-09-14 15:42:46'),
(128, 'Auditorium', '163', '4', '400', '2021-09-14 15:19:25'),
(129, 'Auditorium', '152', '10', '1000', '2021-09-14 16:05:28'),
(130, 'Lobby', '165', '2', '200', '2021-09-14 15:42:42'),
(131, 'Lobby', '167', '1', '100', '2021-09-14 15:20:47'),
(132, 'Lobby', '166', '3', '300', '2021-09-14 15:23:05'),
(133, 'Auditorium', '166', '2', '200', '2021-09-14 15:23:12'),
(134, 'Lobby', '168', '1', '100', '2021-09-14 15:22:07'),
(135, 'Auditorium', '168', '1', '100', '2021-09-14 15:22:45'),
(136, 'Auditorium', '165', '3', '300', '2021-09-14 15:43:57'),
(137, 'Lobby', '170', '3', '300', '2021-09-14 16:42:18'),
(138, 'Auditorium', '170', '3', '300', '2021-09-14 16:42:24'),
(139, 'Lobby', '171', '2', '200', '2021-09-14 16:33:31'),
(140, 'Auditorium', '171', '1', '100', '2021-09-14 16:32:25'),
(141, 'Lobby', '172', '2', '200', '2021-09-14 16:42:44'),
(142, 'Auditorium', '172', '3', '300', '2021-09-14 16:45:23'),
(143, 'Lobby', '173', '6', '600', '2021-09-14 17:21:08'),
(144, 'Auditorium', '173', '1', '100', '2021-09-14 17:21:33'),
(145, 'Auditorium', '129', '2', '200', '2021-09-14 17:30:19'),
(146, 'Lobby', '174', '1', '100', '2021-09-14 17:38:45'),
(147, 'Auditorium', '174', '1', '100', '2021-09-14 17:41:33'),
(148, 'Lobby', '175', '1', '100', '2021-09-14 18:03:34'),
(149, 'Lobby', '176', '4', '400', '2021-09-14 18:06:31'),
(150, 'Auditorium', '176', '1', '100', '2021-09-14 18:06:04'),
(151, 'Lobby', '177', '2', '200', '2021-09-14 20:24:08'),
(152, 'Lobby', '178', '2', '200', '2021-09-14 20:51:54'),
(153, 'Auditorium', '178', '1', '100', '2021-09-14 20:51:25'),
(154, 'Lobby', '81', '6', '600', '2021-09-14 21:59:19'),
(155, 'Auditorium', '81', '1', '100', '2021-09-14 21:58:09'),
(156, 'Lobby', '179', '2', '200', '2021-09-15 02:11:14'),
(157, 'Lobby', '117', '1', '100', '2021-09-15 08:16:23'),
(158, 'Lobby', '180', '4', '400', '2021-09-15 09:54:41'),
(159, 'Auditorium', '180', '2', '200', '2021-09-15 09:54:20'),
(160, 'Lobby', '181', '1', '100', '2021-09-16 09:08:35'),
(161, 'Auditorium', '181', '1', '100', '2021-09-16 09:10:47'),
(162, 'Lobby', '182', '2', '200', '2021-09-18 10:48:13'),
(163, 'Auditorium', '182', '1', '100', '2021-09-18 09:52:46');

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

--
-- Table structure for table `partners`
--

CREATE TABLE `partners` (
  `id` int(11) NOT NULL,
  `partner_image` text NOT NULL,
  `date_added` datetime NOT NULL,
  `date_modified` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `partners`
--

INSERT INTO `partners` (`id`, `partner_image`, `date_added`, `date_modified`) VALUES
(4, '14-21-09_09:40:55_partner.pdf', '2021-09-14 09:40:55', '2021-09-14 09:40:55');

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

--
-- Table structure for table `pastsessioneventvideos`
--

CREATE TABLE `pastsessioneventvideos` (
  `id` int(11) NOT NULL,
  `video_title` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `video_embedded` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `category_id` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `video_type` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `added_date` datetime NOT NULL,
  `modified_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `qa_questions`
--

CREATE TABLE `qa_questions` (
  `id` int(11) NOT NULL,
  `user_id` text NOT NULL,
  `questions` text NOT NULL,
  `added_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `qa_questions`
--

INSERT INTO `qa_questions` (`id`, `user_id`, `questions`, `added_date`) VALUES
(1, '110', 'have few points to discuss with authorities regarding e3ws', '2021-09-14 14:51:41'),
(2, '9', 'Hi Mr Vivek You can drop our question here', '2021-09-14 15:46:39'),
(4, '110', 'Govt can take initiatives through introduction of L5 and L3 Carts for Municipal Waste Collection', '2021-09-14 15:57:29'),
(6, '110', 'old ICE vehicles await renewal should be encouraged for EV adoption thru scrap incentive etc plus local incentive in addition to FAME II incentives', '2021-09-14 16:03:56'),
(7, '110', 'it would be an encouragement', '2021-09-14 16:07:14'),
(8, '110', 'Financing is something which should be taken up important ', '2021-09-14 16:08:53'),
(9, '110', 'Hi Vipin ', '2021-09-14 16:09:29'),
(10, '110', 'is it recorded and not open for participation', '2021-09-14 16:09:49'),
(11, '110', 'did not see interactive session', '2021-09-14 16:11:11'),
(12, '109', 'sir lot of people are converting their present vehicles into EVs', '2021-09-14 16:27:28'),
(13, '109', 'is there an poilic or act about them and their regulations', '2021-09-14 16:27:55');

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

--
-- Table structure for table `sponsors`
--

CREATE TABLE `sponsors` (
  `id` int(11) NOT NULL,
  `sponsor_name` text NOT NULL,
  `rank` int(11) NOT NULL,
  `sponsor_upload_file` text NOT NULL,
  `pdf_title` varchar(200) NOT NULL,
  `added_date` datetime NOT NULL,
  `modified_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `sponsors_video`
--

CREATE TABLE `sponsors_video` (
  `id` int(11) NOT NULL,
  `sponsor_name` varchar(50) NOT NULL,
  `sponsor_video` varchar(50) NOT NULL,
  `video_title` tinytext NOT NULL,
  `video_type` varchar(20) NOT NULL,
  `rank` int(11) NOT NULL,
  `added_date` datetime NOT NULL,
  `modified_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `sponsors_visits_user`
--

CREATE TABLE `sponsors_visits_user` (
  `id` int(11) NOT NULL,
  `user_id` text NOT NULL,
  `sponsor_id` text NOT NULL,
  `views_page` text NOT NULL,
  `download_document` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `sponsor_chatting`
--

CREATE TABLE `sponsor_chatting` (
  `id` int(11) NOT NULL,
  `user_id` text NOT NULL,
  `sponsor_id` text NOT NULL,
  `chatting` text NOT NULL,
  `added_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `sponsor_rep_info`
--

CREATE TABLE `sponsor_rep_info` (
  `id` int(11) NOT NULL,
  `sponsor_name` varchar(50) NOT NULL,
  `rep_info` text NOT NULL,
  `added_date` datetime NOT NULL,
  `modified_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Stand-in structure for view `view_daily_user_tracking`
-- (See below for the actual view)
--
CREATE TABLE `view_daily_user_tracking` (
`id` int(11)
,`user_id` int(11)
,`added_date` date
,`modified_date` datetime
,`category` varchar(25)
);

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

--
-- Stand-in structure for view `view_event_notification`
-- (See below for the actual view)
--
CREATE TABLE `view_event_notification` (
`id` int(11)
,`notification` text
);

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

--
-- Stand-in structure for view `view_qa_questions`
-- (See below for the actual view)
--
CREATE TABLE `view_qa_questions` (
`user_id` text
,`questions` text
,`u_name` varchar(250)
,`u_organisation` varchar(250)
);

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

--
-- Stand-in structure for view `view_virtualevent`
-- (See below for the actual view)
--
CREATE TABLE `view_virtualevent` (
`id` int(11)
,`u_name` varchar(250)
,`u_email` varchar(250)
,`u_phone` varchar(250)
,`u_organisation` varchar(250)
,`u_designation` text
,`login_status` int(11)
);

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

--
-- Table structure for table `virtualevent`
--

CREATE TABLE `virtualevent` (
  `id` int(11) NOT NULL,
  `u_name` varchar(250) NOT NULL,
  `u_email` varchar(250) NOT NULL,
  `u_phone` varchar(250) NOT NULL,
  `u_organisation` varchar(250) NOT NULL,
  `u_designation` text NOT NULL,
  `u_department` text NOT NULL,
  `u_city` text NOT NULL,
  `u_state` text NOT NULL,
  `u_country` text NOT NULL,
  `u_emailverification` int(11) NOT NULL DEFAULT '0',
  `role_type` int(11) NOT NULL DEFAULT '0' COMMENT '0-:Attendee, 1-: Panelist, 2-: Sponsor',
  `login_status` int(11) NOT NULL DEFAULT '0',
  `download_certificate_status` int(10) NOT NULL DEFAULT '0',
  `date_on` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `virtualevent`
--

INSERT INTO `virtualevent` (`id`, `u_name`, `u_email`, `u_phone`, `u_organisation`, `u_designation`, `u_department`, `u_city`, `u_state`, `u_country`, `u_emailverification`, `role_type`, `login_status`, `download_certificate_status`, `date_on`) VALUES
(3, 'sonali', 'sonali@digitallearning.in', '9011421334', 'Elets Tecnomedia Pvt Ltd', 'Developer', 'web', 'pune', 'maharashtra', 'India', 0, 0, 1, 0, '2021-09-11 07:39:00'),
(6, 'Harshal Desai', 'harshal@elets.in', '09930903115', 'Elets', 'Editor', '', '', '', '', 0, 0, 0, 0, '2021-09-11 11:47:38'),
(7, 'vipin kumar verma', 'vipinverma1112@gmail.com', '07531881322', 'org', 'developer', '', '', '', '', 0, 0, 1, 0, '2021-09-13 04:04:43'),
(9, 'vipin', 'vipin@digitallearning.in', '9267904519', 'elets', 'developer', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-13 04:58:00'),
(10, 'Siddhartha Kulshrestha', 'siddhartha2488@gmail.com', '9453255175', 'Elets Tecnomedia Pvt Ltd', 'Php & Backend Developer', 'NA', 'NA', 'NA', 'India', 1, 0, 0, 0, '2021-09-13 04:59:23'),
(11, 'Harshal', 'harshal24desai@gmail.com', '9930903115', 'Elets', 'Editor', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-13 04:59:36'),
(12, 'sonali', 'sonalikudaale607@gmail.com', '9011421334', 'Elets', 'developer', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-13 05:12:50'),
(13, 'Nihar Ranjan Sahu', 'creda.nihar@gmail.com', '9039464896', 'Chhattisgarh State Renewable Energy Development Agency', 'Project Coordinator', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-13 07:57:32'),
(14, 'Noorul', 'info@numbooltechnology.com', '7906998687', 'CeRTOS', 'Founder', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-13 18:10:38'),
(15, 'Ashok Internet', 'World360News.com@Gmail.Com', '916264686230', 'World360News.com', 'Pageant Journalist', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 02:21:20'),
(16, 'Mukul Mathur', 'mathur.mukul@mahindraelectric.com', '9312118442', 'Mahindra Electric Mobility Limited ', 'DGM Corporate Affairs', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 03:55:46'),
(18, 'Ramakrishna, S', 'ciodeity@gmail.com', '9849817545', 'Deity', 'CIO', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 03:55:46'),
(19, 'lakshya, Joshi', '2000lakshya@gmail.com', '9953286606', 'DIODE', 'Director', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 03:55:46'),
(20, 'Sheebu, Nair', 'nair.sheebu@gmail.com', '9890128464', 'eMultiversity', 'Postdoctoral Researcher', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 03:55:46'),
(21, 'sivadasan, kesavan', 'sivadasan.k@gmail.com', '9446659577', 'KSEBL', 'Deputy Chief Engineer', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 03:55:46'),
(22, 'Pradip, Patra', 'pkpatra1960@gmail.com', '7021339643', 'TUV India Ltd', 'IMS Lead Auditor', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 03:55:46'),
(23, 'Jayesh, Shah', 'jvshahroadsafety@gmail.com', '9427224182', 'Retired ceo road safety authority', 'Retired ceo road safety authority Gujarat', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 03:55:46'),
(25, 'aakhil, ahmed', 'acc.bsp2015@gmail.com', '9406320786', 'star autotech', 'partner', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 03:55:46'),
(26, 'lovleen, vyas', 'vyas.6@iitj.ac.in', '6350154267', 'IIT Jodhpur', 'student', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 03:55:46'),
(28, 'Devfendra Kumar, Joshi', 'dkjoshi.upcl@gmail.com', '9012355170', 'UPCL', 'S.E.', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 03:55:46'),
(29, 'ARUN KUMAR, NIGAM', 'aknigam612008@gmail.com', '9.19712E+11', 'NTPC LIMITED', 'Ex General Manager (Project Construction)', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 03:55:46'),
(31, 'Devendra Kumar, Joshi', 'dkjoshi.upcl@gamail.com', '9012355170', 'UPCL', 'S.E.', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 03:55:46'),
(33, 'SANJEEV, JAIN', 'sjain218@gmail.com', '9826137734', 'CREDA', 'Chief Engineer', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 03:55:46'),
(34, 'Arundhati, Mukherjee', 'arundhatim083@gmail.com', '8016784293', 'Damodar Valley Corporation', 'Deputy Chief Engineer ,Secretariat dept', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 03:55:46'),
(37, 'MR. AMUJURI BISWANATH, ,', 'amujuribiswanathuniversal@gmail.com', '7893704927', 'GREEN CARE SOCIETY INDIA', 'DIRECTOR & COO', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 03:55:46'),
(38, 'Amit, Ved', 'amit.ved@marwadieducation.edu.in', '9925148051', 'Marwadi University', 'Associate Professor', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 03:55:46'),
(39, 'S K Patnaik, Surendra', 'SKPATNAIK5@GMAIL.COM', '9650994678', 'NPEPS', 'Associate', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 03:55:46'),
(40, 'Bibek, Sandhu', 'bibek.sandhu@gmail.com', '8283808414', 'EY', 'Sr Consultant', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 03:55:46'),
(41, 'Sekh Sariful, Ali', 'sekh.ali@rpsg.in', '976652', 'RPSG Ventures Limited', 'Asst.Manager', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 03:55:46'),
(42, 'Ashishh, Chitlangya', 'ashish@clusterinfotech.com', '9849857890', 'Cluster Infotech Pvt Ltd', 'Business Manager', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 03:55:46'),
(43, 'RAVI KIRAN, SRIRAMOJU', 'sriramoju.ravikiran@gmail.com', '7032652822', 'IRCON', 'JGM', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 03:55:46'),
(45, 'Atul, Shewale', 'amshewale@kkwagh.edu.in', '9420900326', 'K. K. Wagh Institute of Engineering Education and Research, Nashik', 'Assistant Professor', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 03:55:46'),
(46, 'sanjeev, kapoor', 'skapoor492@gmail.com', '8076829854', 'SportsGrail pvt ltd', 'Chairman', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 03:55:46'),
(47, 'Dr Hemalatha s Murthy, Dr Hemalatha', 'hemalathasmurthy23@gmail.com', '9986919951', 'WPS group', 'Director principal', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 03:55:46'),
(48, 'Rita, Raj', 'rajritams@gmail.com', '9717630979', 'CRIS', 'GM/ CRIS', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 03:55:46'),
(49, 'DAYALU RAM, NIRMALKAR', 'nirmalkar.gautam@gmail.com', '9685535156', 'BHAGAT TOUR AND TRAVELS', 'Owner', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 03:55:46'),
(50, 'DAYALU RAM, NIRMALKAR', 'nirmalkar.dayalu@gmail.com', '9685535156', 'BHAGAT TOUR AND TRAVELS', 'Owner', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 03:55:46'),
(51, 'TEN SINGH, SAHU', 'vanshcomputer031016@gmail.com', '8770851638', 'VANSH COMPUTER', 'ONLINE CENTER', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 03:55:46'),
(52, 'Ratnesh, Sharma', 'hariom.ratneshsharma@gmail.com', '9174756546', 'Yamah', 'Sport', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 03:55:46'),
(53, 'Himanshu, Kesharwani', 'himanshugold143@gmail.com', '9827166143', 'Modern Electric Rides', 'Propriter', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 03:55:46'),
(54, 'Abhishek Gupta', 'agupta4@eesl.co.in', '9717066607', 'EESL', 'Cluster Head', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 05:02:13'),
(55, 'Prashant Kesharwani', 'kesharwanijonty1999@gmail.com', '07489035668', 'Modern Electric Rides', 'E Bike Sub dealer', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 05:03:09'),
(56, 'ANKIT SAHU', 'ankkitsahu007.as@gmail.com', '9522289890', 'SELF', 'ENGINEER', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 06:04:51'),
(57, 'Vinod Pillai ', 'Vinod.pillai@hiragroup.com', '8085600000', 'Hira Group', 'Director', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 07:06:11'),
(58, 'Yash saigal', 'yash.saigal@tatamotors.com', '09971013759', 'Tata motors ', 'Senior manager ', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 07:07:00'),
(59, 'hyder Ali. khan', 'hyder.khan@eblu.in', '09867930005', 'Godwari emobility Pvt ltd', 'ceo', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 07:08:07'),
(60, 'Sandeep  Mittal', 'sandeep.mittal@jindalsteel.com', '8236836186', 'Jindal Steel &  Power Ltd', 'DGM', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 07:13:34'),
(61, 'PRABHAKAR KOHALE ', 'prabhu.kohale@gmail.com', '09503655600', 'BELAZ ENRIKA MINING EQUIPMENT ', 'HEAD TECHNICAL SUPPORT ', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 07:16:08'),
(62, 'Dheeraj Daharji', 'dheeraj.daharji111@gmail.com', '9074165913', 'CG Transport Department', 'Programmer', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 07:22:09'),
(63, 'Vikas Sharma', 'vikas.sharma1225@gmail.com', '08319964752', 'Smmcpl', 'Director', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 07:26:00'),
(64, 'Manoj ', 'manzithakur@yahoo.co.in', '9826655536', 'NewsNeta', 'News reporter ', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 07:26:16'),
(65, 'JITENDRA JAISWAL', 'u_jjaiswal@eesl.co.in', '9039232923', 'EESL', 'Engineer', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 07:35:30'),
(66, 'Anunay Kumar Jain', 'u_ajain@eesl.co.in', '9827874275', 'Energy Efficiency Services Limited', 'Sr Engineer', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 07:40:11'),
(67, 'Sharan Singh', 'sharan.singh@tatamotors.com', '09899959991', 'Tata Motors', 'State Head-Delhi Government Affairs ', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 07:40:35'),
(68, 'Rishi agrawal ', 'rishiagrawal74@gmail.com', '9755098000', 'Aarogya Hospital Raipur', 'Director', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 07:41:55'),
(69, 'Yugeshwari verma', 'yugeshwariverma.sscet@gmail.com', '9893220634', 'Transport department', 'Arto', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 07:42:24'),
(70, 'Vivek Sinha ', 'sinhavivek2790@gmail.com', '7974375945', 'Rto', 'Arto ', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 07:43:55'),
(71, 'AMIT BAHADUR ', 'kakku_bhilai@yahoo.com', '78989 02151 ', 'KAKKU E & P CONTROL PVT.LTD', 'DIRECTOR', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 07:44:27'),
(72, 'Anubhav', 'ansraipur@gmail.com', '09174794040', 'Transport', 'Rto', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 07:44:46'),
(73, 'Bal Krishna Kumar', 'u_bkumar1@eesl.co.in', '7979715076', 'Energy efficiency services Limited', 'Engineer', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 07:45:32'),
(74, 'Mitesh', 'miteshagrawal22483@yahoo.com', '8889075700 ', 'Shri shyam honda', 'Owner', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 07:46:18'),
(75, 'Amit Kumar jain', 'scooter.house@rediffmail.com', '9827196521', 'Scooter House', 'Propiter', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 07:48:01'),
(76, 'Shubham Gajwani', 'sgajwani01@gmail.com', '7354088000', 'Vanshika Automobiles LLP', 'MD', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 07:48:33'),
(77, 'Hemant Sharma ', 'hemantsharma1001996@gmail.com', '9340765384', 'Yes ', 'Asst g 3', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 07:49:15'),
(78, 'Akhilesh kumar das', 'acb.rto2021@gmail.com', '8817836384', 'Auto centre Bilaspur ', 'RTO Executive ', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 07:49:38'),
(79, 'Vijay mishra', 'vjmishra78@gmail.com', '9827106526', 'Varun honda  RAGISTRETION DIPPORT', 'Team leader', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 07:49:50'),
(80, 'Kishanmahor', 'kishanmahor1969@gmai.com', '8719007716', 'Transport dipartment', 'Arto', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 07:50:21'),
(81, 'Vijay', 'Anandhonda@yahoo.in', '9993967999 ', 'Anand honda ', 'Proprietor ', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 07:51:02'),
(82, 'Gautam', 'gautam.kumar.10011@gmail.com', '09471869823', 'Nic', 'Programmer', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 07:51:38'),
(83, 'Kishanmahor ', 'kishanmahor1969@gmail.com', '8719007716', 'Transport dipartment', 'Arto', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 07:52:16'),
(84, 'Rakesh Rawani', 'rawanirakesh2@gmail.com', '8982077082', 'Satya auto pvt ltd', 'Computer operator', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 07:53:18'),
(85, 'Omprakash Agrawal', 'op@autocentre.co.in', '9425532722', 'Auto Centre', 'CEO', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 07:53:42'),
(86, 'Amarpreet singh bhasin ', 'amarpreetbhasin@bhasingroup.co.in', '9200002600', 'Bhasin ventures private limited ', 'Director', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 07:55:12'),
(87, 'Ravi singh', 'ravisinghrpt1@gmail.com', '9806552976', 'Transport', 'Assistant programmer', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 07:55:45'),
(88, 'Mayank Goswami ', 'mayank1386@gmail.com', '9179995522', 'Shri ram automobile', 'Dealer principal', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 07:56:28'),
(89, 'AKHIL DWARKANI ', 'sriram.automobiles@gmail.com', '8120088888', 'Sriram automobiles ', 'Propitor', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 07:56:29'),
(90, 'Anish agrawal', 'Anish11prince@gmail.com', '07000103415', 'Bansal auto', 'Managing director', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 07:56:33'),
(91, 'Hosla agrawal', 'alliedkorba@gmail.com', '9827492482', 'Allied auto', 'Proprietor', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 07:57:57'),
(92, 'bhavin jain', 'ubcopvtltd@gmail.com', '9827978577', 'UB Co.', 'prop', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 07:59:54'),
(93, 'Sanat', 'sanatk83@gmail.com', '9300180001', 'Transport department', 'MVI', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 08:00:18'),
(94, 'Gaurav Modi', 'gauravmodi56316@gmail.com', '9826156316', 'Krishna Auto Riders Pvt Lts', 'Director', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 08:00:22'),
(95, 'Anil agrawal', 'anil.agrawal@skyautomobiles.in', '9893150000', 'Sky automobiles', 'Partner', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 08:01:20'),
(96, 'Kamaljitsingh ahuja ', 'Bunty8278@gmail.com', '9425596290', 'Gurunanak auto ', 'Propritoe', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 08:01:21'),
(97, 'Nitin Khandelwal ', 'deepakescorts@gmail.com', '9425204645', 'Deepak Tractors and agriculture ', 'Propriter', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 08:01:30'),
(98, 'Shubham Agrawal', 'ankitauto2@gmail.com', '9827178077', 'Ankit Auto', 'Owner', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 08:01:58'),
(99, 'Ravi Kumar Yadav ', 'yadavravi.dmt@gmail.com', '9977293361', 'heromotocorp', 'Manager', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 08:02:20'),
(100, 'vivek sharma', 'royalautobsp@gmail.com', '9893041472', 'Royal auto', 'Manegar', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 08:02:44'),
(101, 'Nirbhay Agrawal', 'nirbhay.a@ralas.in', '9171759000', 'Ralas Autocorp Pvt Ltd', 'CEO', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 08:03:11'),
(102, 'T.Thawait', 'smpl.rto@shivammotors.co.in', '8120351300', 'Shivam motors Pvt Ltd', 'Sales officer', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 08:03:56'),
(103, 'Rishi Tandon ', 'rishi.tandon@tatamotors.com', '9819903102', 'Tata Motors Ltd', 'Head Govt sales', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 08:03:58'),
(104, 'Ashish mishra', 'ashishmishra8029@gmail.com', '6264487063', 'Transport department ', 'Ast programmer', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 08:04:05'),
(105, 'Jitenndra Tiwari', 'infojtiwari@gmail.com', '8770785575', 'Transport Department', 'Programmer', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 08:04:16'),
(106, 'Durga Rao Koppishetti', 'koppishetti.durgarao@tatapower.com', '9246419559', 'Tata Power Co Ltd', 'Regional Head ', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 08:04:54'),
(107, 'hyder Ali. khan', 'hakhan803@gmail.com', '9867930005', 'Godwari emobility Pvt ltd', 'ceo', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 08:05:29'),
(108, 'Jayesh Pithalia', 'jpithalia@yahoo.co.in', '9425502414', 'Raipur Motor Engineering Works', 'Partner', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 08:07:11'),
(109, 'Som Yadav', 'somgomugomu@gmail.com', '8251061515', 'RKC', 'Student', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 08:07:32'),
(110, ' Vivek Srivastava', 'headinstl.grick@shigan.net', '8448299251', 'Shigan eVoltz Ltd', 'Head Institutional Sales', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 08:07:57'),
(111, 'Ayush Garg', 'ayush1427@gmail.com', '9826281566', 'Ambika Transport', 'Owner', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 08:08:16'),
(112, 'Shubham', 'shubham12002@gmail.com', '9827012002', 'Bhatapara', 'Patenr', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 08:08:32'),
(113, 'Harsh Nahata', 'harshnahata0121@gmail.com', '8109502100', 'Harsh Auto', 'Owner', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 08:09:05'),
(114, 'Manish dewangan', 'manish81dewangan@gmail.com', '7828734189', 'E rickshaw', 'Durg', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 08:10:44'),
(115, 'G k jaiswal', 'dreamhonda2@gmail.com', '9926909995', 'Kk dream auto corp sol pvt ltd', 'Director', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 08:13:42'),
(116, 'AKSHAY SHRIVASTAVA', 'pradeep39281@gmail.com', '09826039281', 'IBA Group', 'Entrepreneur', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 08:14:11'),
(117, 'Kailash tiwari', 'chandramotors.bsp@gmail.com', '9826167202', 'Chandra Motors', 'Properitor', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 08:14:31'),
(118, 'Jaideep', 'jaideepkhanujaa@gmail.com', '9039042080', 'Mlc automotives raipur', 'Director', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 08:15:15'),
(119, 'Nalin lunia', 'nalin2000@yahoo.com', '+919827191100', 'Chhattisgarh college', 'Director', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 08:15:23'),
(120, 'Aditya Jaiswal', 'adi.aditya064@gmail.com', '8817304442', 'Transport Department Chhattisgarh', 'Asst Programmer', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 08:15:37'),
(121, 'Rohini Matiyara ', 'rohinimatiyara1996@gmail.com', '8269562474 ', 'Shivnath honda ', 'Rto/ins', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 08:16:02'),
(122, 'Kabeer khan', 'amjatmobile@gmail.com', '7697211115', 'KABEER TROLLY', 'KABEER TROLLY', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 08:16:45'),
(123, 'Prashant', 'd10194@baldealer.com', '9826171872', 'Automobiles ', 'Owner', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 08:17:44'),
(124, 'RAM DWARKANI', 'ramdwarkani@gmail.com', '8889355553', 'Sriram Fin Lease', 'Head operations', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 08:18:37'),
(125, 'Krishna Khakharia', 'shreekripamarketing@gmail.com', '9575729000', 'Shree Kripa marketing', 'Proprietor', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 08:18:39'),
(126, 'Kushal Tiwari', 'creda.kushal@gmail.com', '9179512223', 'CREDA', 'Project Coordinator', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 08:20:59'),
(127, 'Sohail Memon', 'aaliyaservicesgandai@gmail.com', '6263497358', 'Aaliya Services Gandai(Hero Motocorp)', 'Co-Owner', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 08:21:53'),
(128, 'Navneet Bansal', 'bansalautogroup@gmail.com', '9977178078', 'Bansal Auto', 'Bcom', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 08:23:43'),
(129, 'Manish Rao Tamdi', 'manishtamdi0405@gmail.com', '9479020405', 'Smart Chip Ltd Bijapur ', 'Computer Operator ', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 08:25:13'),
(130, 'rohit yadav', 'bilaspur.rto@mgdealer.co.in', '9179861188', '', 'rto incharge', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 08:29:10'),
(131, 'Tikendra Chandrakar ', 'dubeyherockn@gmail.com', '9691066054', 'M/s Dubey Auto', 'Sales Manager ', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 08:30:46'),
(132, 'PARMANAND DHURI', 'msquare.bsp.edp@gmail.com', '6262622547', 'Msquare Motors(Mahavir Motocorp Pvt Ltd)', 'Computer operator RTO Incharge', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 08:30:55'),
(133, 'Rajan Moses ', 'gmsales@skyautomobiles.in', '7566673073', 'SKY AUTOMOBILES ', 'GM Sales ', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 08:31:40'),
(134, 'Yogesh Beriwal', 'yogeshberiwal@pasahouse.com', '9893626700', 'Pasa Associates Pvt Ltd', 'Director', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 08:32:06'),
(135, 'Yogesh Beriwal ', 'pasaraipur@pasahouse.com', '9893626700', 'Pasa Associate Pvt.Ltd.', 'Dirctor ', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 08:32:21'),
(136, 'Krishna Mishra', 'krishnamishra@elets.in', '+919811822697', 'elets', 'pm', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 08:34:23'),
(137, 'Sant Lal Gupta ', 'sant.gupta@tatamotors.com', '08795819977', 'TATA Motors Ltd', 'ZONAL Lead East', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 08:36:36'),
(138, 'Bhuwan Silhare', 'bhuwansilhare@tatamotors.com', '9594997432', 'GPA', 'Sr manager', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 08:38:40'),
(139, 'HARISH Nair', 'harishkumar.nair@gamltrucks.com', '9575280633', 'Gulf Ashley Motor Ltd', 'Sales admin exe', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 08:40:03'),
(140, 'Mohan sahu', 'mohansahu591@gmail.com', '09893274883', 'Transport', 'Dto kabirdham', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 08:40:38'),
(141, 'Chetan Verma', 'laxmienterprises8587@gmail.com', '9039108407', 'M/s Laxmi Enterprises', 'MD', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 08:45:49'),
(142, 'Sumit sajnani', 'sajnanisumit@gmail.com', '9229100000', 'Sai motors', 'Part er', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 08:48:04'),
(143, 'Omprakash Markam', 'omprakashmarkam@gmail.com', '9752256916', 'Sahil auto sales', 'Self-employed', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 08:50:20'),
(144, 'Vikas mathanj', 'saitvsraipur@gmail.com', '9926286800', 'Sai motors', 'Partner', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 08:53:45'),
(145, 'Divya vastrakar', 'vastrakardivya@gmail.com', '9893986951', 'Transport', 'Programmer', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 08:57:46'),
(146, 'Utkarsh kumar ', 'ukumar@eesl.co.in', '8969224516 ', 'EESL', 'Engineer ', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 08:59:13'),
(147, 'Dipanshu ', 'dipskabs@gmail.com', '9425215076', 'Transport department ', 'Atc', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 08:59:46'),
(148, 'Vinod kumar yadav ', 'vinodkumaryadav999@gmail.com', '9205290766', 'Transport ', 'Deputy commissioner ', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 09:00:10'),
(149, 'Srikant S', 'srikant.s@atherenergy.com', '9766585758', 'Ather Energy Pvt Ltd', 'Lead - Network & Business Development', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 09:04:18'),
(150, 'Sopan Mishra', 'sopan26@gmail.com', '9827171074', 'Public service', 'Buisness', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 09:11:02'),
(151, 'Rajesh Yadav', 'shrisaimotor@yahoo.co.in', '9993007500', 'Shri Sai Hero', 'Dealer Principle ', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 09:16:36'),
(152, 'Vijay Goyal', 'vkgryp@gmail.com', '9301704200', 'indian Steel & Infrastructure pvt Ltd', 'CEO', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 09:17:54'),
(153, 'Rahul Jain', 'rahuljain1000@yahoo.com', '9300283929', 'Rahul Jain', 'Self Employed', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 09:23:12'),
(154, 'Sanjay Agrawal ', 'sanjayack@gmail.com', '9826145117', 'Auto centre', 'Dealer principal ', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 09:24:21'),
(155, 'Jitendra', 'jitendrajotwani84@gmail.com', '9425230052', '', 'Business', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 09:25:19'),
(156, 'Pawan Agrawal ', 'pawan@autocentre.co.in', '9425532897', 'Auto centre', 'Partner', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 09:29:03'),
(157, 'Kapil ', 'khuranakapil86@gmail.com', '09630069111', 'Vizaypal automobiles', 'Partners ', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 09:33:26'),
(158, 'Gaurav sahu', 'grvsahu99@gmail.con', '9770138394', 'Govt of Chhattisgarh ', 'ARTO', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 09:34:00'),
(159, 'Ujjawal tiwari', 'tiwariujjawal1@gmail.com', '7471164296', 'Sales ', 'Sales manager ', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 09:35:31'),
(160, 'JASPAL SINGH CHAWLA ', '490023.pre.her@gmail.com', '9584487559', 'Preet Hero Electric', 'OWNER', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 09:35:43'),
(161, 'Harish Nair', 'admin.jdp@skyautomobiles.in', '9111107448', 'Sky Automobiles', 'General Manager ', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 09:37:04'),
(162, 'Nagesh sahu', 'rto.jagdalpur@gmail.com', '7470778067', 'Skyautomobile ', 'Rto Exutive ', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 09:42:01'),
(163, 'Jyoti mahanti', 'jyotimahanti0909@gmail.com', '7587171100', 'Mahavir automobiles jagadalpur', 'Rto  registration operter', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 09:43:15'),
(164, 'Dhananjay kumar swain', 'sales.jagdalpur@skyautomobiles.in', '9584433110', 'Sky automobiles', 'Sales manager', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 09:44:28'),
(165, 'Dhananjay kumar swain', 'sales.jdp@skyautomobiles.in', '9584433110', 'Sky automobiles', 'Sales manager', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 09:47:39'),
(166, 'Devesh', 'devesh1.kumar@in.ey.com', '9798144740', 'devesh1.kumar@in.ey.com', 'Consultant', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 09:48:56'),
(167, 'tilak', 'scl.tilaksahu@gmail.com', '9752707070', 'raipur', 'programmer', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 09:50:40'),
(168, 'Rahul Goyal', 'rahul.goyal2@in.ey.com', '9540495844', 'EY', 'Consultant', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 09:51:51'),
(169, 'Omkar Shaligram', 'omkar.shaligram@tatamotors.com', '9028039863', 'Tata Motors', 'DGM charging solutions', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 09:55:05'),
(170, 'Vipul Deshpande', 'vipul@cirtindia.com', '9834240513', 'CIRT', 'Jr. Scientist', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 10:56:54'),
(171, 'Rishi', 'budy007@gmail.com', '9424136272', 'Bsijns', 'Xyzzz', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 11:01:35'),
(172, 'Sarang Pahade', 'shreeramautorjn@gmail.com', '8223004001', 'Shree Ram Auto', 'Manager', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 11:11:38'),
(173, 'Kaushik', 'rtobsp@gmail.com', '09827875546', 'Renault', 'Rto', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 11:48:47'),
(174, 'AKHILESH KUMAR', 'akhileshyadaw78@gmail.com', '7024524436', 'MAHADEWA CARS ', 'EDP EXECUTIVE ', 'NA', 'NA', 'NA', 'India', 0, 0, 0, 0, '2021-09-14 12:08:28'),
(175, 'Vidit', 'kesharwanitractors.57@gmail.com', '7587475157', 'Kesharwani Tractors', 'Dealer', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 12:33:25'),
(176, 'Kunal bhansali', 'kunalbhansali1603@gmail.com', '9826306322', 'Sharda shri auto', 'Owner', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 12:35:11'),
(177, 'Manish boudh ', 'nishantpipes@rediffmail.com', '9827110897', 'Nishant Pipes And Fittings', 'Director', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 14:46:46'),
(178, 'test', 'test@gmail.com', '9999999991', 'tester', 'teester', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 15:20:49'),
(179, 'Rahul verma', 'patelauto05@gmail.com', '8770038235', 'Automobile', 'M,d,', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-14 20:40:32'),
(180, 'Arpit Chauhan', 'ceo_arpit@erkeymotors.com', '8073435017', 'Erkey Motors India Pvt. Ltd.', 'Director & CEO', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-15 04:22:12'),
(181, 'Anup Mathur', 'anoop@goelectri.com', '7500167555', 'GOELECTRI ENERGY & RESOURCES PRIVATE LIMITED', 'Co Founder Director', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-16 03:37:46'),
(182, 'Vivek jaiswal', 'vivektraders2008@rediffmail.com', '9993235836', 'Vivek traders', 'Oaner', 'NA', 'NA', 'NA', 'India', 0, 0, 1, 0, '2021-09-18 04:19:24');

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

--
-- Structure for view `view_daily_user_tracking`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `view_daily_user_tracking`  AS SELECT `daily_user_tracking`.`id` AS `id`, `daily_user_tracking`.`user_id` AS `user_id`, `daily_user_tracking`.`added_date` AS `added_date`, `daily_user_tracking`.`modified_date` AS `modified_date`, `daily_user_tracking`.`category` AS `category` FROM `daily_user_tracking` ;

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

--
-- Structure for view `view_event_notification`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `view_event_notification`  AS SELECT `event_notification`.`id` AS `id`, `event_notification`.`notification` AS `notification` FROM `event_notification` ;

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

--
-- Structure for view `view_qa_questions`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `view_qa_questions`  AS SELECT `qa`.`user_id` AS `user_id`, `qa`.`questions` AS `questions`, `u`.`u_name` AS `u_name`, `u`.`u_organisation` AS `u_organisation` FROM (`virtualevent` `u` join `qa_questions` `qa` on((`u`.`id` = `qa`.`user_id`))) ;

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

--
-- Structure for view `view_virtualevent`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `view_virtualevent`  AS SELECT `virtualevent`.`id` AS `id`, `virtualevent`.`u_name` AS `u_name`, `virtualevent`.`u_email` AS `u_email`, `virtualevent`.`u_phone` AS `u_phone`, `virtualevent`.`u_organisation` AS `u_organisation`, `virtualevent`.`u_designation` AS `u_designation`, `virtualevent`.`login_status` AS `login_status` FROM `virtualevent` ;

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `avtaar_request`
--
ALTER TABLE `avtaar_request`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `daily_user_tracking`
--
ALTER TABLE `daily_user_tracking`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=180;

--
-- AUTO_INCREMENT for table `eventcategory`
--
ALTER TABLE `eventcategory`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `eventdell_feedback`
--
ALTER TABLE `eventdell_feedback`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `eventvideos`
--
ALTER TABLE `eventvideos`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `event_feedback`
--
ALTER TABLE `event_feedback`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `event_notification`
--
ALTER TABLE `event_notification`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `event_usertacking`
--
ALTER TABLE `event_usertacking`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=164;

--
-- AUTO_INCREMENT for table `partners`
--
ALTER TABLE `partners`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `pastsessioneventvideos`
--
ALTER TABLE `pastsessioneventvideos`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `qa_questions`
--
ALTER TABLE `qa_questions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `sponsors`
--
ALTER TABLE `sponsors`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sponsors_video`
--
ALTER TABLE `sponsors_video`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sponsors_visits_user`
--
ALTER TABLE `sponsors_visits_user`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sponsor_chatting`
--
ALTER TABLE `sponsor_chatting`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sponsor_rep_info`
--
ALTER TABLE `sponsor_rep_info`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `virtualevent`
--
ALTER TABLE `virtualevent`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=183;
COMMIT;

