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

START TRANSACTION;



--
-- Database: `vansun_lms_import`
--

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

--
-- Table structure for table `comments`
--

CREATE TABLE `comments` (
  `id` int NOT NULL,
  `lead_id` int DEFAULT NULL,
  `comment` longtext,
  `timestamp` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `comments`
--

INSERT INTO `comments` (`id`, `lead_id`, `comment`, `timestamp`) VALUES
(57, 1260, 'TEST MDL performs laboratory testing for all patients and does not discriminate based on race, color, natio TEST', '2021-12-02 18:23:12'),
(58, 1260, 'Next Test also done ....', '2021-12-02 18:34:31'),
(59, 1260, 'Health Insurance Company  test', '2021-12-02 18:58:07'),
(60, 1295, 'Email sent', '2021-12-03 10:58:18'),
(61, 1295, 'check this', '2021-12-03 10:59:58'),
(62, 1295, '', '2021-12-03 11:20:15'),
(63, 1294, 'test', '2021-12-03 11:24:10'),
(64, 1281, '', '2021-12-03 11:57:27'),
(65, 1294, '', '2021-12-03 12:19:26'),
(66, 1287, 'test', '2021-12-03 12:36:07'),
(68, 1298, 'test', '2021-12-03 13:39:43'),
(69, 669, 'ok', '2021-12-03 18:41:40'),
(70, 669, 'test', '2021-12-03 18:42:49'),
(71, 1294, 'test\r\n', '2021-12-06 14:19:15'),
(72, NULL, NULL, '2021-12-06 14:19:18'),
(73, 1058, 'Its agency, he has multiple clients.', '2021-12-06 15:17:15'),
(74, NULL, NULL, '2021-12-06 15:17:21'),
(75, 697, 'The client is working on a product uploading task and asked us to contact him again in the beginning of Jan 2022.\r\n', '2021-12-07 05:06:35'),
(76, NULL, NULL, '2021-12-07 05:06:49'),
(77, 1331, 'hello', '2021-12-07 08:36:16'),
(78, 1281, 'test\r\n', '2021-12-07 08:59:09'),
(79, NULL, NULL, '2021-12-07 08:59:19'),
(80, 1281, 'test\r\n', '2021-12-07 09:01:41'),
(81, NULL, NULL, '2021-12-07 09:01:48'),
(82, NULL, NULL, '2021-12-07 09:04:27'),
(83, 1281, 'test input', '2021-12-07 09:04:39'),
(84, NULL, NULL, '2021-12-07 09:04:51'),
(85, NULL, NULL, '2021-12-07 09:07:35'),
(86, NULL, NULL, '2021-12-07 09:15:16'),
(87, NULL, NULL, '2021-12-07 09:27:00'),
(88, NULL, NULL, '2021-12-07 09:29:45'),
(89, NULL, NULL, '2021-12-07 09:31:40'),
(90, NULL, NULL, '2021-12-07 09:35:19'),
(91, NULL, NULL, '2021-12-07 09:36:52'),
(92, NULL, NULL, '2021-12-07 09:37:37'),
(93, NULL, NULL, '2021-12-07 09:38:37'),
(94, NULL, NULL, '2021-12-07 09:39:37'),
(95, NULL, NULL, '2021-12-07 09:40:12'),
(96, 1281, 'testtttt', '2021-12-07 09:44:18'),
(97, NULL, NULL, '2021-12-07 09:44:25'),
(98, NULL, NULL, '2021-12-07 09:51:23'),
(99, NULL, NULL, '2021-12-07 09:52:22'),
(100, NULL, NULL, '2021-12-07 09:52:33'),
(101, NULL, NULL, '2021-12-07 09:52:53'),
(102, NULL, NULL, '2021-12-07 09:53:29'),
(103, NULL, NULL, '2021-12-07 09:54:17'),
(104, NULL, NULL, '2021-12-07 09:55:09'),
(105, NULL, NULL, '2021-12-07 09:56:41'),
(106, 1247, 'test', '2021-12-07 10:29:39'),
(107, NULL, NULL, '2021-12-07 10:29:46'),
(108, 1247, 'test\r\n', '2021-12-07 10:45:40'),
(109, NULL, NULL, '2021-12-07 10:49:34'),
(110, 1294, 'test', '2021-12-07 11:24:09'),
(111, NULL, NULL, '2021-12-07 11:24:14'),
(112, NULL, NULL, '2021-12-07 11:30:51'),
(113, NULL, NULL, '2021-12-07 11:31:18'),
(114, NULL, NULL, '2021-12-07 11:31:51'),
(115, NULL, NULL, '2021-12-07 11:32:29'),
(116, 1294, 'hello2', '2021-12-07 11:40:56'),
(117, 1294, 'deve', '2021-12-07 17:19:48'),
(118, 1231, 'Call client  Dec 8, 2021.', '2021-12-07 21:58:24'),
(119, 1294, 'test', '2021-12-08 10:53:19'),
(120, 1294, 'ddddd', '2021-12-08 10:53:30'),
(123, 1222, 'We have shared the plan, audit report and client has implemented those points on the website. But this lead is from India.', '2021-12-08 11:49:45'),
(125, 1251, 'it was not like that, but he said, he is driving. and call later', '2021-12-08 12:06:23'),
(126, 1294, 'test', '2021-12-08 12:35:42'),
(127, 1120, 'Call scheduled Dec 14, 2021 on 6:00PM', '2021-12-08 12:37:03'),
(138, 993, 'Earlier, he was driving. Now he is taking dinner, Need to call in Half an hour', '2021-12-08 12:48:41'),
(140, 1281, 'tsetse', '2021-12-08 12:49:32'),
(141, 1281, 'w', '2021-12-08 12:49:40'),
(142, 1281, 'w', '2021-12-08 12:49:46'),
(143, 1114, 'Called, but not picking. ', '2021-12-08 12:57:51'),
(144, 1214, 'Contacted on WhatsApp.', '2021-12-08 13:01:17'),
(145, 1281, 'we', '2021-12-08 13:06:18'),
(146, 1281, 'aw', '2021-12-08 13:06:44'),
(147, 1294, 'tseting', '2021-12-08 13:08:29'),
(148, 1294, 'testtet', '2021-12-08 13:08:35'),
(149, 1294, 'testing', '2021-12-08 13:11:27'),
(150, 1294, 'tsetet', '2021-12-08 13:11:58'),
(151, 1294, 'tseting', '2021-12-08 13:12:06'),
(152, 1294, 'tseting ', '2021-12-08 13:13:03'),
(153, 1294, 'tset', '2021-12-08 13:13:04'),
(154, 1294, 'set', '2021-12-08 13:13:05'),
(155, 1294, 'tset', '2021-12-08 13:30:33'),
(156, 1294, 'awdawd', '2021-12-08 13:32:55'),
(157, 1294, 'awdawd', '2021-12-08 13:32:57'),
(158, 1294, 'awdawd', '2021-12-08 13:32:58'),
(159, 1294, 'awdawd', '2021-12-08 13:32:59'),
(160, 1294, 'awdawdawd', '2021-12-08 13:33:00'),
(161, 1345, 'client response: Hi sorry we have found an Indian company who are willing to fulfil our requirements at much affordable price less than 40 dollars per month.', '2021-12-08 15:22:59'),
(162, 1354, 'test comment', '2021-12-09 15:09:09'),
(163, 1360, 'client replied on audit report:', '2021-12-10 10:22:10'),
(164, 1360, 'client replied on audit report:', '2021-12-10 10:22:10'),
(165, 1360, 'client replied on audit report: Thanks for the update. Once we complete what we are working on, I will consider what you offer.', '2021-12-10 10:26:37'),
(166, 993, 'Proposal sent on 8th december', '2021-12-10 13:20:50'),
(167, 1397, 'Client hired someone else:\r\nHi Bobby,\r\nthank you for your answer. I took a look to the websites that you have designed and some are interestin,g but I search for a different type of design, as I am not a product provider.\r\nI am actually in contact with a web designer from my own native country and I have decided to work with ihm next year to do the website.\r\n\r\nthanks for your offering,\r\nIrina', '2021-12-13 22:20:49'),
(168, 993, 'Ranged him up 2wice. Didn\'t picked the call', '2021-12-14 12:55:46'),
(169, 1485, '$6500 to $7000 cost given for indepth system. ', '2021-12-20 12:20:21'),
(170, 1384, 'we gave $799, and client says, out of budget', '2021-12-20 21:55:24'),
(171, 1504, 'Client:  I am not looking for SEO support, I am looking for someone to redesign my website.\r\nCodeflies: Shared portfolio.\r\nClient: Looks good. Hope you don’t mind if I get back to you in a few days with more information of what I am looking for. \r\nAlso added on Whatsapp.\r\n', '2021-12-21 10:02:32'),
(172, 1412, 'Client: I am going to discuss all marketing matters with my colleagues as soon as we\'re able, we are all busy at the moment!\r\n\r\n', '2021-12-21 12:28:40'),
(173, 1428, 'Codeflies: We have shared plan, pricing and also briefed him about our working process.\r\nClient: Thank you for your detailed, honest description, I have shared the email with my superiors, once decision taken I will contact you as soon as possible.\r\n ', '2021-12-21 12:34:08'),
(174, 1329, 'proposal sent, followup tomorrow.', '2021-12-22 00:19:02'),
(175, 1539, 'client may be interested, but not at the moment.', '2021-12-22 23:57:10'),
(176, 1095, 'Client: Please contact after new year\r\n', '2021-12-23 14:38:07'),
(177, 548, 'he said, he doesn\'t have any such requirements.', '2021-12-23 15:02:28'),
(178, 1258, 'he is not picking', '2021-12-23 15:05:23'),
(179, 1360, 'Client: we are still awaiting approvals for our pilots. Once that is done, we can consider  your proposal.\r\n', '2021-12-24 10:04:20'),
(180, 1626, 'South Africa', '2021-12-28 16:12:11'),
(181, 1559, 'Client need SEO and PPC services.', '2021-12-28 16:31:12'),
(182, 1621, 'He didn\'t pick the call', '2021-12-29 00:14:21'),
(183, 1598, '29-12-2021: follow up done\r\n', '2021-12-29 09:53:10'),
(184, 1599, '29-12-2021: follow yup done', '2021-12-29 09:53:32'),
(185, 1601, '29-12-2021: follow up done', '2021-12-29 10:14:42'),
(186, 1602, '29-12-2021: follow up done', '2021-12-29 10:16:27'),
(187, 1603, '29-12-2021: follow up done.', '2021-12-29 10:20:19'),
(188, 1605, '29-12-2021: follow up done.', '2021-12-29 10:21:59'),
(189, 1630, '29-12-2021: follow up done', '2021-12-29 10:24:20'),
(190, 1609, '29-12-2021: follow up done', '2021-12-29 10:37:26'),
(191, 1613, '29-12-2021: follow up done', '2021-12-29 10:38:54'),
(192, 1629, '29-12-2021: follow up done', '2021-12-29 10:41:16'),
(193, 1592, '29-12-2021: follow up done', '2021-12-29 10:50:57'),
(194, 1588, '29-12-2021: follow up done', '2021-12-29 10:58:52'),
(195, 1639, '31-12: follow up done', '2021-12-31 09:59:51'),
(196, 1642, '31-12: follow up done', '2021-12-31 11:53:23'),
(197, 1643, '31-12: follow up done.', '2021-12-31 11:54:19'),
(198, 1644, '31-12: follow up done', '2021-12-31 11:55:06'),
(199, 1651, '31-12: follow up done', '2021-12-31 11:57:20'),
(200, 1633, '31-12: follow up done', '2021-12-31 12:41:10'),
(201, 1635, '31-12: follow up done', '2021-12-31 12:46:15'),
(202, 1637, '31-12: follow up done', '2021-12-31 12:48:28'),
(203, 1648, '31-12: follow up done\r\n', '2021-12-31 12:48:49'),
(204, 1665, '31-12: follow up done', '2021-12-31 13:07:41'),
(205, 1675, 'Client: Budget is higher, looking for cheaper like 40-50 USD', '2022-01-03 11:36:04'),
(206, 1632, 'client: looking for Cheaper and local company\r\n', '2022-01-03 11:38:27'),
(207, 1687, 'Client: not interested, he is from Bangladesh and looking for someone local.\r\n', '2022-01-03 17:47:16'),
(208, 1638, '04-01-2022', '2022-01-04 12:03:39'),
(209, 1640, '04-01-2022', '2022-01-04 12:06:57'),
(213, 2086, 'client se call par baat ho gyi hai ', '2022-02-17 18:36:59'),
(214, 2089, 'dddsaa', '2022-02-17 18:37:15');

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

--
-- Stand-in structure for view `data`
-- (See below for the actual view)
--
CREATE TABLE `data` (
`added_by` varchar(255)
,`application_website` varchar(255)
,`class_color` varchar(50)
,`comments` longtext
,`contacton` varchar(50)
,`country` varchar(255)
,`created` timestamp
,`email` varchar(255)
,`inbox` varchar(255)
,`lead_email` varchar(255)
,`lead_id` int
,`lead_status` varchar(255)
,`leadgoal` int
,`name` varchar(255)
,`phonenumber` varchar(255)
,`replied` varchar(255)
,`role` varchar(255)
,`star` varchar(255)
,`status` varchar(255)
,`technology` varchar(255)
,`title` varchar(255)
,`username` varchar(255)
);

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

--
-- Table structure for table `eme_emails`
--

CREATE TABLE `eme_emails` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `email` varchar(100) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `leads`
--

CREATE TABLE `leads` (
  `lead_id` int NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phonenumber` varchar(255) DEFAULT NULL,
  `replied` varchar(255) DEFAULT NULL,
  `contacton` varchar(50) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `email_received_on` varchar(255) DEFAULT NULL,
  `lead_value` varchar(255) DEFAULT NULL,
  `added_by` varchar(255) DEFAULT NULL,
  `added_by_id` int DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `application_website` varchar(255) DEFAULT NULL,
  `technology` varchar(255) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `comments` longtext,
  `class_color` varchar(50) DEFAULT NULL,
  `is_active` int NOT NULL DEFAULT '1',
  `not_qualified` tinyint(1) NOT NULL DEFAULT '0',
  `is_prospect` tinyint(1) NOT NULL DEFAULT '0',
  `star` varchar(255) DEFAULT NULL,
  `added_email` varchar(100) DEFAULT NULL,
  `contact_date` date DEFAULT NULL,
  `communication_mode` varchar(200) DEFAULT 'email' COMMENT 'whatsapp, call, email',
  `assignee_id` int DEFAULT NULL COMMENT 'user id, whom to assigned',
  `n_destt` varchar(225) NOT NULL,
  `action_plan` text NOT NULL,
  `hotness` varchar(255) NOT NULL,
  `no_cows` varchar(255) NOT NULL,
  `price_milk` varchar(255) NOT NULL,
  `lead_owner` varchar(255) NOT NULL,
  `comp_key` varchar(225) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `leads`
--

INSERT INTO `leads` (`lead_id`, `name`, `email`, `phonenumber`, `replied`, `contacton`, `title`, `email_received_on`, `lead_value`, `added_by`, `added_by_id`, `status`, `country`, `application_website`, `technology`, `created`, `comments`, `class_color`, `is_active`, `not_qualified`, `is_prospect`, `star`, `added_email`, `contact_date`, `communication_mode`, `assignee_id`, `n_destt`, `action_plan`, `hotness`, `no_cows`, `price_milk`, `lead_owner`, `comp_key`) VALUES
(2062, 'Fahim Vohra', 'fahimvohra77@gmail.com', '832-853-0124', NULL, NULL, 'Re Website Redesign ....', 'harvendar.nic78@aol.com', '', 'zeeshan', 0, 'Prospecting', 'USA', 'Website', '', '2022-01-20 05:21:56', '\r\n-----Original Message-----\r\nFrom Fahim Vohra <fahimvohra77@gmail.com>\r\nTo Harvendar Singh <harvendar.nic78@aol.com>\r\nSent Thu, Jan 20, 2022 1209 am\r\nSubject Re Website Redesign ....\r\n\r\n832-853-0124\r\n\r\nOn Wed, Jan 19, 2022 at 1012 AM Harvendar Singh <harvendar.nic78@aol.com> wrote\r\n\r\nHi,\r\n\r\nThanks for your reply,\r\n\r\nI would be happy to send details information and cost for same. Please share your website contact number and Skype ID. so that we will review and move forward.\r\n\r\nThanks You \\\r\n\r\n\r\n-----Original Message-----\r\nFrom Fahim Vohra <fahimvohra77@gmail.com>\r\nTo Harvendar Singh <harvendar.nic78@aol.com>\r\nSent Tue, Jan 18, 2022 1154 pm\r\nSubject Re Website Redesign ....\r\n\r\nOkay.\r\n\r\nOn Tue, Jan 18, 2022 at 1153 AM Harvendar Singh <harvendar.nic78@aol.com> wrote\r\nHello,\r\n\r\nHope you are doing well.\r\n\r\nDid you get a chance to see my previous email?\r\n\r\nLooking for the positive response\r\n\r\nThank You\r\n\r\n\r\n-----Original Message-----\r\nFrom Harvendar Singh <harvendar.nic78@aol.com>\r\nSent Tue, Oct 26, 2021 952 pm\r\nSubject Re Website Redesign ....\r\n\r\nHi,\r\n\r\n\r\nI am , Ecommerce Website Consultant.Harvendar Singh\r\n\r\n \r\nWe deliver best websites for small to large business. Our Company offers these services\r\n\r\n\r\nWebsite Redesign/Re-Development of your website\r\n\r\n \r\nIf you are interested please send me requirement of you website design.\r\n\r\n\r\nThanks & Regards\r\n\r\nHarvendar Singh\r\n\r\n', NULL, 1, 0, 0, NULL, 'bobby2', NULL, 'email', NULL, '', '', '', '', '', '', NULL),
(2063, 'Normam Eisenberg', 'norman@sgmscorp.com', '305-936-9018', NULL, NULL, '[ Create A Website ]', 'seoomahametrolim@aol.com', '', 'Imran', 0, 'Prospecting', 'USA', 'Website', '', '2022-01-20 06:02:11', '-----Original Message-----\r\nFrom Normam Eisenberg <norman@sgmscorp.com>\r\nTo IT Ssrvice <seoomahametrolim@aol.com>\r\nSent Wed, Jan 19, 2022 729 pm\r\nSubject RE [ Create A Website ]\r\n\r\nIt would be nice to know who you are (name) and what you charge,  I normally don’t respond to no named people  but maybe you are good who knows and maybe your fees aren’t that high . are they?\r\n\r\n \r\n\r\nFrom IT Ssrvice <seoomahametrolim@aol.com>\r\nSent Wednesday, January 19, 2022 516 AM\r\nSubject Re [ Create A Website ]\r\n\r\n \r\n\r\nHi,                            \r\n\r\n \r\n\r\nI apologize for Email again  \r\n\r\n           \r\n\r\nI was wondering if you got a chance to review my previous email. Please suggest if there is any update for us.            \r\n\r\n             \r\n\r\nI would highly appreciate your acknowledgement and valuable comments on my last mail.                           \r\n\r\nI’m looking forward to your reply.              \r\n\r\n             \r\n\r\nThanks !!\r\n\r\n\r\n-----Original Message-----\r\nFrom IT Ssrvice <seoomahametrolim@aol.com>\r\nSent Tue, Jan 4, 2022 1117 am\r\nSubject [ Create A Website ]\r\n\r\nHi,\r\n\r\n \r\n\r\nI’m just checking with you to see if you’re interested in redesigning or upgrading your site, or if you’re interested in building a whole new site completely.\r\n\r\n \r\n\r\nIf so, I’d love to tell you a little bit more about my abilities and show you some of my work.\r\n\r\n \r\n\r\nI am a very skilled web designer with various abilities and can develop anything.\r\n\r\n \r\n\r\nLet me know what you think.\r\n\r\n \r\n\r\nPlease share your Skype ID / WhatsApp Number.\r\n\r\n \r\n\r\nThanks & Regards', NULL, 1, 0, 0, NULL, 'bobby1', NULL, 'email', NULL, '', '', '', '', '', '', NULL),
(2064, 'Red Carpet Trash Valet', 'redcarpettrashvalet@gmail.com', '615-258-3445', NULL, NULL, 'React Native App', 'melanieknox226@gmail.com', '', 'Parvesh', 0, 'Open', 'USA', 'Application', '', '2022-01-20 06:13:37', 'From Red Carpet Trash Valet [mailtoredcarpettrashvalet@gmail.com]\r\n\r\nSent Monday, January 17, 2022 721 PM\r\nTo Melanie Knox\r\nSubject Re React Native App\r\n\r\n \r\n\r\nHello,\r\n\r\n \r\n\r\nI would love to see some of your work and prices please. I am interested in something like this.  Thank you\r\n\r\n \r\n\r\nBreanna Dockins\r\n\r\n615-258-3445\r\n\r\n \r\n\r\n \r\n\r\nOn Mon, Jan 17, 2022, 748 AM Melanie Knox <melanieknox226@gmail.com> wrote\r\n\r\nHi redcarpettrashvalet@gmail.com,\r\n\r\n \r\n\r\nI am Melanie Knox, APPs Development Manager and I work with 120+experienced IT professionals who are into\r\n\r\n \r\n\r\nWeb Development, Mobile App (Real Estate Apps, Shopping App, Store App, Custom App, React Native App, Android App, IPhone App, Hybrid App, iPad App)\r\n\r\n \r\n\r\nIf you are looking for creating an app for your business, then please share your requirement. I will also be happy to share samples & price list of our work.\r\n\r\n \r\n\r\nThanks You!!', NULL, 1, 0, 0, NULL, 'bobby4 ', NULL, 'email', NULL, '', '', '', '', '', '', NULL),
(2065, 'Bless Menla Ackah', 'bless.ackah95@gmail.com', '', NULL, NULL, 'Create an App', 'anitabrown198967@gmail.com', '', 'Parvesh', 0, 'Open', 'USA', 'Application', '', '2022-01-20 06:20:22', '\r\nFrom Bless Menla Ackah [mailtobless.ackah95@gmail.com]\r\nSent Tuesday, January 18, 2022 702 PM\r\nTo Anita Brown\r\nSubject Re Create an App\r\n\r\n \r\n\r\nOk I will like to crate an app \r\n\r\nCan you share with me your sample and price \r\n\r\n \r\n\r\nGet Outlook for iOS\r\n\r\nFrom Anita Brown <anitabrown198967@gmail.com>\r\nSent Tuesday, January 18, 2022 12428 PM\r\nTo bless.ackah95@gmail.com <bless.ackah95@gmail.com>\r\nSubject Create an App\r\n\r\n \r\n\r\nHi bless.ackah95@gmail.com,\r\n\r\n \r\n\r\nI am Anita Brown, APPs Development Manager and I work with 120+experienced IT professionals who are into\r\n\r\n \r\n\r\nWeb Development, Mobile App (Finances Apps, Health Insurance App, Custom App, React Native App, Android App, IPhone App, Hybrid App, iPad App)\r\n\r\n \r\n\r\nIf you are looking for creating an app for your business, then please share your requirement. I will also be happy to share samples & price list of our work.\r\n\r\n \r\n\r\nThanks You!!', NULL, 1, 0, 0, NULL, 'bobby4 ', NULL, 'email', NULL, '', '', '', '', '', '', NULL),
(2066, ' Lorena Alves', 'ontheloswimwear@gmail.com', '707 498 1832', NULL, NULL, 'Re Plan?', 'husaxdavid1462@gmail.com', '', 'zeeshan', 0, 'Open', 'USA', 'SEO', '', '2022-01-20 06:25:40', '---------- Forwarded message ---------\r\nFrom Lorena Alves <ontheloswimwear@gmail.com>\r\nDate Thu, 20 Jan 2022 at 0816\r\nSubject Re Plan?\r\nTo David <husaxdavid1462@gmail.com>\r\n\r\n\r\nHi David,\r\n\r\nWhat do these services cost? Can you please let me know more information? Thank you!\r\nLorena\r\n\r\nOn Wed, Jan 19, 2022 at 304 AM David <husaxdavid1462@gmail.com> wrote\r\nGood Morning, \r\n\r\nI was going through your website & I personally see a lot of potential in your website & business.\r\n\r\nAs per my analysis of your website, I can say that, you may not get traffic and orders.\r\n\r\nBecause there are lots of aspects in the website. Which are not optimized well and not working properly.\r\n\r\nNeed to get optimize entire website well to improve ranking, traffic and order.\r\n\r\nWe can place your website on Googles 1st page Yahoo, etc!\r\n\r\nMay I send you quote and portfolio? If you are interested!\r\n\r\nThanks & Regards,\r\n\r\nDavid\r\n\r\nMarketing Manager\r\n\r\n \r\n\r\n \r\n\r\n\r\n\r\n--\r\n\r\nLorena Alves \r\nDesigner/CEO @ On The Lo Swimwear\r\n707 498 1832\r\nIG @ontheloswimwear\r\nOntheloswimwear.com\r\n', NULL, 1, 0, 0, NULL, 'dm@codefliestechnologies.com ', NULL, 'email', 50, '', '', '', '', '', '', NULL),
(2067, 'CocoHigh Admin', 'info.cocohigh@gmail.com', '+91 9998566661', NULL, NULL, ' Awaiting Your response !', 'alianarou4@gmail.com', '', 'Tariq', 0, 'Open', 'India', 'Application', '', '2022-01-20 06:56:51', '\r\n\r\nOn Thu, Jan 20, 2022 at 1052 AM CocoHigh Admin <info.cocohigh@gmail.com> wrote\r\nThankyou for your mail. Kindly update me on the business app details.\r\n\r\nRegards\r\nTeam Admin - CocoHigh\r\n\r\nYoutube | Visit CocoHigh | Visit Insta  | Visit FB  | +91 9998566661\r\n\r\n\r\nOn Wed, Jan 19, 2022 at 429 PM alianarou <alianarou4@gmail.com> wrote\r\nHello,\r\n\r\n \r\n\r\nWe are a Mobile app development company. Would you be interested to develop an App?\r\n\r\n \r\n\r\nWe can make any kind of app like\r\n\r\n \r\n\r\n·         Taxi App\r\n\r\n·         Food App\r\n\r\n·         Fitness App\r\n\r\n·         Dating App\r\n\r\n·         Music App\r\n\r\n·         Travel App\r\n\r\n·         Games App\r\n\r\n·         Business App\r\n\r\n·         Educational App\r\n\r\n·         Web App\r\n\r\n·         Hybrid App\r\n\r\n \r\n\r\nPS If you are interested, then I can send you our past work details, company information and an affordable quotation with the best offer.\r\n\r\n \r\n\r\nThanks& Regards\r\n\r\n \r\n\r\nAlianarou\r\n\r\n ', NULL, 1, 1, 0, NULL, 'bobby4', NULL, 'email', NULL, '', '', '', '', '', '', NULL),
(2068, ' SuitlandCivic', 'suitlandcivic@gmail.com', '240-441-6367', NULL, NULL, 'Re Plan?', 'kionabthomas8237@gmail.com', '', 'zeeshan', 0, 'Open', 'USA', 'SEO', '', '2022-01-20 07:02:19', '---------- Forwarded message ---------\r\nFrom SuitlandCivic Association <suitlandcivic@gmail.com>\r\nDate Thu, 20 Jan 2022 at 0323\r\nSubject Re Plan?\r\nTo Michael <kionabthomas8237@gmail.com>\r\n\r\n\r\nHi Michael, \r\n\r\nThank you for your interest with helping us with our website.  Yes, please provide a quote and someone will respond back to you as soon as we can.  Thanks \r\n\r\nOn Wed, Jan 19, 2022 at 605 AM Michael <kionabthomas8237@gmail.com> wrote\r\nGood Morning, \r\n\r\nI was going through your website & I personally see a lot of potential in your website & business.\r\n\r\nAs per my analysis of your website, I can say that, you may not get traffic and orders.\r\n\r\nBecause there are lots of aspects in the website. Which are not optimized well and not working properly.\r\n\r\nNeed to get optimize entire website well to improve ranking, traffic and order.\r\n\r\nWe can place your website on Googles 1st page Yahoo, etc!\r\n\r\nMay I send you quote and portfolio? If you are interested!\r\n\r\nThanks & Regards,\r\n\r\nMichael\r\n\r\nMarketing Manager', NULL, 1, 0, 0, NULL, 'dm@codefliestechnologies.com ', NULL, 'email', 50, '', '', '', '', '', '', NULL),
(2069, 'tigerbay', 'tigerbay@cox.net', ' 7577187839', NULL, NULL, 'Re Build a Business Website !!', 'phonemobileappservice155@yahoo.com', '', 'Uvais', 0, 'Open', 'USA', 'Website', '', '2022-01-20 07:49:23', '\r\n\r\n----- Forwarded message -----\r\nFrom tigerbay@cox.net <tigerbay@cox.net>\r\nTo Renuka Shahane <iphonemobileappservice155@yahoo.com>\r\nSent Friday, 14 January, 2022, 100232 pm IST\r\nSubject Re Build a Business Website !!\r\n\r\nTHANK YOU FOR YOURN EMAIL ELLIOTT\r\nSO GIVE US A CALL 7577187839\r\n\r\nOn January 14, 2022 at 1219 AM Renuka Shahane <iphonemobileappservice155@yahoo.com> wrote\r\n\r\nHi,\r\n\r\n \r\n\r\nGreetings for the day!\r\n\r\n \r\n\r\nHave a business and looking to go online? Would like a new website? Or would like to re-design your old website to make it modern?\r\n\r\n \r\n\r\nLet us help you develop a website that speaks volume about your products and services.\r\n\r\nNot just web pages, we design experiences that always include the WOW factor.\r\n\r\n \r\n\r\n We specialize in\r\n\r\n \r\n\r\n- Website Design with Responsive Layout\r\n\r\n- Open Source Customization\r\n\r\n- Website development using Wordpress, Joomla, Drupal\r\n\r\n- PHP & MySQL Development\r\n\r\n- B2B & B2C Website and Portal Development\r\n\r\n- E-Commerce/Online Store Solutions - Ecommerce, Magento, Woo Commerce\r\n\r\n \r\n\r\nYour business deserves an attractive user interface!\r\n\r\nLets work together to build an amazing website. If you have any questions or queries regarding our services, please feel free to drop us email.\r\n\r\n \r\n\r\nThanks...!!!\r\n\r\n\r\n\r\n ', NULL, 1, 0, 0, NULL, 'bobby1', NULL, 'email', NULL, '', '', '', '', '', '', NULL),
(2070, ' LuvLior Hair', 'admin@luvliorhair.com', '', NULL, NULL, 'Re Cost ?', 'thomas77202g@gmail.com', '', 'zeeshan', 0, 'Open', 'USA', 'SEO', '', '2022-01-20 08:00:35', '---------- Forwarded message ---------\r\nFrom LuvLior Hair & Wigs <admin@luvliorhair.com>\r\nDate Wed, Jan 19, 2022 at 1127 PM\r\nSubject Re Cost ?\r\nTo Thomas <thomas77202g@gmail.com>\r\n\r\n\r\nYes, you can send me a quote and with the specifics what your plans are. \r\n\r\nOn Wed, Jan 19, 2022 at 504 AM Thomas <thomas77202g@gmail.com> wrote\r\nHi,     “admin@luvliorhair.com”\r\n\r\nI was going through your website & I personally see a lot of potential in your website & business.\r\n\r\nWith your permission I would like to send you our portfolio with prices showing you a few things to greatly improve these search results for you.\r\n\r\nThese things are not difficult, and my report will be very specific. It will show you exactly what needs to be done to move you up in the rankings dramatically.\r\n\r\nWe can place your website on Googles 1st page (Yahoo, etc.).\r\n\r\nMay I send you a quote? If you are interested!\r\n\r\nThank Advance\r\n\r\nThomas\r\n\r\nMarketing Specialist\r\n\r\n \r\n\r\n--\r\n\r\nQuality isnt defined by the cost of a product, but the value', NULL, 1, 0, 0, NULL, 'dm@codefliestechnologies.com ', NULL, 'email', 50, '', '', '', '', '', '', NULL),
(2071, 'healthandwellbeingclub', 'healthandwellbeingclub@gmail.com', '+44 7958 488541', NULL, NULL, ' Re Apps Maintenance?', 'amhraaaabouraaqua@gmail.com', '', 'Sumit', 0, 'Open', 'UK', 'Application', '', '2022-01-20 08:53:35', '\r\n\r\n---------- Forwarded message ---------\r\nFrom Support <healthandwellbeingclub@gmail.com>\r\nDate Thu, Jan 20, 2022 at 201 PM\r\nSubject Re Apps Maintenance?\r\nTo Rajesh Singh <amhraaaabouraaqua@gmail.com>\r\n\r\n\r\nHi Rajesh,\r\n\r\nHow much would a health and coaching app cost roughly? \r\n\r\nThanks \r\n\r\nOn Thu, 20 Jan 2022 at 0452, Rajesh Singh <amhraaaabouraaqua@gmail.com> wrote\r\nHi,\r\n\r\n \r\n\r\nGood Morning,\r\n\r\n \r\n\r\nAre you looking for Mobile App Development Services (Android, iPhone/ iOS, and iPad?)\r\n\r\n \r\n\r\nWe build all kinds of Apps for verticals like\r\n\r\n \r\n\r\n• Education Apps             • Events Apps\r\n\r\n• Food Delivery Apps      • Health Fitness Apps\r\n\r\n• Logistics Apps                • M-Commerce Apps\r\n\r\n• Real Estate Apps           • Taxi Apps / Travel Apps, etc.\r\n\r\n \r\n\r\nI can build the Apps to your exact requirement in your budget and as per your timeline.\r\n\r\n \r\n\r\nLooking forward to hearing from you.\r\n\r\n \r\n\r\nBest Regards,\r\n\r\nRajesh Singh', NULL, 1, 0, 0, NULL, 'bobby4 ', NULL, 'email', NULL, '', '', '', '', '', '', NULL),
(2072, 'Supergym', 'info@supergym.com.au', '+61 458 001 957', NULL, NULL, 'Re: IOS Apps', 'daniel.smith657@yahoo.com', '', 'Sumit', 0, 'Open', 'Australia', 'Application', '', '2022-01-20 08:55:58', '\r\n\r\n----- Forwarded message -----\r\nFrom Supergym <info@supergym.com.au>\r\nTo Daniel Smith <daniel.smith657@yahoo.com>\r\nSent Thursday, 20 January, 2022, 122001 pm IST\r\nSubject Re IOS Apps\r\n\r\nHi\r\n\r\nWhat about media apps.\r\nHow much will that cost?\r\n\r\nGet Outlook for iOS\r\n \r\nFrom Daniel Smith <daniel.smith657@yahoo.com>\r\nSent Thursday, January 20, 2022 522 pm\r\nSubject IOS Apps\r\n \r\nHello,\r\n\r\nAre you looking for Mobile App Development Services (Android, iPhone/ iOS and iPad?) at an affordable cost?\r\n\r\nWe build all kinds of Apps as per your requirement. Some App verticals are as follows\r\n\r\nEducation Apps\r\nEvents Apps\r\nFinance Apps\r\nFood Delivery Apps\r\nHealth & Fitness Apps\r\nLogistics Apps\r\nE-Commerce Apps\r\nMedia & News Magazine Apps\r\nReal Estate Apps\r\nTaxi Apps\r\nTravel Apps, Etc.\r\n\r\nWe will build the APPS for you as per your exact requirement within your budget and timeline. Please share your exact app requirements with us.\r\n\r\nSincerely,\r\nDaniel Smith', NULL, 1, 0, 0, NULL, 'bobby4 ', NULL, 'email', NULL, '', '', '', '', '', '', NULL),
(2073, 'Melissa Chan', 'support@asiatranslationservices.com', '03-40233321', NULL, NULL, 'SEO 1st page top ranking on all search engines', 'rathore.divya@aol.com', '', 'ghanshyam', 0, 'Open', 'Malaysia', 'SEO', '', '2022-01-20 08:59:53', '\r\n\r\n\r\n-----Original Message-----\r\nFrom support@asiatranslationservices.com\r\nTo rathore.divya@aol.com; Safina Irdis <info@asiatranslationservices.com>\r\nSent Thu, Jan 20, 2022 204 pm\r\nSubject SEO 1st page top ranking on all search engines\r\n\r\nHi,\r\n\r\nThank you for your email, we would like to work to get our site www.asiatranslationservices.com at first page in Major search engines. Could let us know the details / proposal to take it forward.\r\n\r\nAwaiting your speedy reply.\r\n\r\n---\r\nRegards,\r\n\r\nMelissa Chan\r\n\r\nAsia Translation Services\r\n\r\n\r\n\r\n\r\n\r\nFrom divya rathore <rathore.divya@aol.com>\r\nDate 4 January 2022 at 12739 PM MYT\r\nSubject SEO 1st page top ranking on all search engines\r\nReply-To divya rathore <rathore.divya@aol.com>\r\n\r\nHi,\r\n \r\nWe are a reputed SEO and Web Development company based in India that has helped many businesses rank on the 1st Page Ranking of Google for even the most competitive Industries\r\n \r\nWe offer the following Services at an Affordable Cost\r\n \r\n·         SEO (with plan & activity)\r\n \r\n·         SMO (LinkedIn, Facebook, etc.)\r\n \r\n·         ORM (Online Reputation Management Service)\r\n \r\n·         Google Maps Optimization\r\n \r\n·         Google Ad words\r\n \r\n·         Content Writing\r\n \r\n·         Local Google SEO\r\n \r\nWe provide all services at a much affordable cost than what it might be in the house.\r\n \r\nWe are proud to inform you that our team handled 400+ SEO projects and obtained 150000+ manually built links in the past 1 year.\r\n \r\nId be happy to send you our package and pricing if youd like to assess our work.\r\n \r\nLook forward to hearing from you.\r\nKinds Regards\r\n ', NULL, 1, 1, 0, NULL, 'dm@codefliestechnologies.com ', NULL, 'email', 50, '', '', '', '', '', '', NULL),
(2074, 'Petros Mihakos', 'petros@systemsb2b.com', '+30 693 685 7761', NULL, NULL, 'Web Design Offer', 'anjali.sharma61@yahoo.com', '', 'Guddu', 56, 'Open', 'Cyprus', 'Website', '', '2022-01-20 09:09:30', '----- Forwarded message -----\r\nFrom Petros Mihakos <petros@systemsb2b.com>\r\nTo Anjali Sharma <anjali.sharma61@yahoo.com>\r\nSent Thursday, 20 January, 2022, 023050 pm IST\r\nSubject RE Web Design Offer\r\n\r\nHi,\r\n\r\n \r\n\r\nCheck this website and send me your proposal.\r\n\r\n \r\n\r\nwww.hexanom.com\r\n\r\n \r\n\r\nThis is another company that we have and I want to renew the site.\r\n\r\n \r\n\r\nAwaiting your reply.\r\n\r\n \r\n\r\nThank you.\r\n\r\n \r\n\r\n \r\n\r\nKind Regards,\r\n\r\n \r\n\r\n \r\n\r\nPetros Mihakos\r\n\r\nManagement & Development\r\n\r\n \r\n\r\n \r\n\r\nBIIB SYSTEMS & SERVICES LIMITED\r\n\r\nEmmanuel Roide, Kirzis Center, Block D, Office D25,\r\n\r\nP.O. Box. 56908, 3031 Limassol, Cyprus\r\n\r\nMob +30 6936 85 77 61 (Greece)\r\n\r\nMob +974 6614 8372 (Qatar)\r\n\r\npetros@systemsb2b.com\r\n\r\nwww.systemsb2b.com\r\n\r\n\r\n\r\nconsider\r\n\r\n\r\nDISCLAIMER\r\nThis email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to which they are addressed. If you are not the intended recipient, you should not copy it, re-transmit it, use it or disclose its contents, you should notify the sender of receiving the email in error, and immediately delete the copy from your system. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of BIIB SYSTEMS & SERVICES. Finally, the recipient should check this email and any attachments for the presence of viruses. BIIB SYSTEMS & SERVICES accepts no liability for any damage caused by any virus transmitted by this email.\r\n\r\n \r\n\r\n \r\n\r\n \r\n\r\nFrom Anjali Sharma <anjali.sharma61@yahoo.com>\r\nSent Thursday, January 20, 2022 1053 AM\r\nSubject Web Design Offer\r\n\r\n \r\n\r\nHi,\r\n \r\nWe are website designer team, and have developed more than 2100 creative web sites.\r\n \r\nI can design a unique website for your organization as well for very low cost onetime fee.\r\n \r\nThank You,\r\n \r\nSales Team\r\n\r\n \r\nIf you are interested, please share your Project requirements OR maybe a reference website.', NULL, 1, 0, 0, NULL, 'bobby4', NULL, 'email', NULL, '', '', '', '', '', '', NULL),
(2075, 'Marc Greenaway', 'marc.greenaway@glendale-services.co.uk', '01257 460 461', NULL, NULL, 'Proposal...', 'kavitakatiyar000@hotmail.com', '', 'Prince', 56, 'Open', 'UK', 'SEO', '', '2022-01-20 09:13:12', '\r\n--------------------------------------------------------------------------------\r\n\r\nFrom Marc Greenaway [mailtomarc.greenaway@glendale-services.co.uk] \r\nSent 20 January 2022 1216\r\nTo kavita katiyar\r\nSubject Re [Civictrees Info] Proposal...\r\n\r\n \r\n\r\nHi Kavita,\r\n\r\n \r\n\r\nCould you send us a monthly price and an information pack ?\r\n\r\n \r\n\r\nRegards\r\n\r\nMarc\r\n\r\n \r\n\r\nOn Thu, Jan 20, 2022, 0500 kavita katiyar <kavitakatiyar000@hotmail.com> wrote\r\n\r\nHi,  \r\n\r\n \r\n\r\nGreeting of the day!  \r\n\r\n \r\n\r\nWe can promote your website that will give you first ranking on Google when a person enter a keyword.  \r\n\r\n \r\n\r\nLet me know if you are interested and I will send you best Monthly package for your website.  \r\n\r\n \r\n\r\nThanks & Regards,  \r\n\r\n \r\n\r\nKavita Katiyar \r\n\r\n', NULL, 1, 0, 0, NULL, 'dm@codefliestechnologies.com ', NULL, 'email', 50, '', '', '', '', '', '', NULL),
(2076, 'Salim', 'info@majesticfitness.co.uk', '07463730360', NULL, NULL, 'Proposal...', 'somyaali786@outlook.com', '', 'Prince', 56, 'Open', 'UK', 'SEO', '', '2022-01-20 09:16:29', 'From info@majesticfitness.co.uk [mailtoinfo@majesticfitness.co.uk] \r\nSent 20 January 2022 1155\r\nTo Somya Ali\r\nSubject RE Proposal...\r\n\r\n \r\n\r\nHi Somya,\r\n\r\nGood morning,\r\n\r\nHope you are well,\r\n\r\nCan you please send me more details about your plan?\r\n\r\nAlso price packaege?\r\n\r\n \r\n\r\nKind Regards,\r\n\r\n \r\n\r\nSalim\r\n\r\n \r\n\r\nMajestic Fitness\r\n\r\n1-4 Dairy Court, Orchard Road, Richmond TW9 4FG\r\n\r\n0208 876 8634\r\n\r\n \r\n\r\ninfo@majesticfitness.co.uk\r\n\r\n \r\n\r\nwww.majesticfitness.co.uk \r\n\r\n \r\n\r\nhttps//www.instagram.com/majesticfitnesslondon/?hl=en\r\n\r\n \r\n\r\n \r\n\r\n \r\n\r\n\r\n\r\n \r\n\r\nFrom Somya Ali <somyaali786@outlook.com> \r\nSent 20 January 2022 0542\r\nSubject Proposal...\r\n\r\n \r\n\r\nHi,  \r\n\r\n \r\n\r\nGreeting of the day!  \r\n\r\n \r\n\r\nWe can promote your website that will give you first ranking on Google when a person enter a keyword.  \r\n\r\n \r\n\r\nLet me know if you are interested and I will send you best Monthly package for your website.  \r\n\r\n \r\n\r\nThanks & Regards,  \r\n\r\n \r\n\r\nSomya Ali \r\n\r\n', NULL, 1, 0, 0, NULL, 'dm@codefliestechnologies.com ', NULL, 'email', 50, '', '', '', '', '', '', NULL),
(2077, 'Abbey ', 'info@propaving-landscaping.co.uk', '07747 193 288', NULL, NULL, '#Ranking Proposal !!!', 'rahulthakur324@hotmail.com', '', 'Prince', 55, 'Open', 'UK', 'SEO', '', '2022-01-20 09:19:36', 'From info [mailtoinfo@propaving-landscaping.co.uk] \r\nSent 20 January 2022 1402\r\nTo Rahul Thakur\r\nSubject RE #Ranking Proposal !!!\r\n\r\n \r\n\r\nHi,\r\n\r\n \r\n\r\nCan you send me pricing and more information on what you can guarantee.\r\n\r\n \r\n\r\n \r\n\r\n \r\n\r\nKind Regards \r\n\r\n \r\n\r\nAbbey \r\n\r\n \r\n\r\n \r\n\r\nPro Paving & Landscaping Ltd \r\n\r\n \r\n\r\n \r\n\r\n-------- Original message --------\r\n\r\nFrom Rahul Thakur <rahulthakur324@hotmail.com> \r\n\r\nDate 20/01/2022 0621 (GMT+0000) \r\n\r\nTo \r\n\r\nSubject #Ranking Proposal !!! \r\n\r\n \r\n\r\nHi,  \r\n\r\n \r\n\r\nGreeting of the day!  \r\n\r\n \r\n\r\nWe can promote your website that will give you first ranking on Google when a person enter a keyword.  \r\n\r\n \r\n\r\nLet me know if you are interested and I will send you best Monthly package for your website.  \r\n\r\n \r\n\r\nThanks & Regards,  \r\n\r\n \r\n\r\nRahul Thakur \r\n\r\n', NULL, 1, 0, 0, NULL, 'dm@codefliestechnologies.com ', NULL, 'email', 50, '', '', '', '', '', '', NULL),
(2078, 'Martin Delaney', 'orcharddrivesandpatios@yahoo.com', '07568 503739', NULL, NULL, '#Ranking Proposal !!!', 'innayatjoshi@hotmail.com', '', 'Prince', 0, 'Open', 'UK', 'SEO', '', '2022-01-20 09:22:29', 'www.orcharddrivesandpatios.co.uk\r\n\r\n\r\n--------------------------------------------------------------------------------\r\n\r\nFrom Martin Delaney [mailtoorcharddrivesandpatios@yahoo.com] \r\nSent 20 January 2022 1322\r\nTo Innayat Joshi\r\nSubject Re #Ranking Proposal !!!\r\n\r\n \r\n\r\nYes I am interested but I get a lot of people asking the same thing and some of them are cons are you able to help me if you are I need proof thank you\r\n\r\nBest Regards, Orchard Drives & Patios \r\n\r\n \r\n\r\n\r\n\r\n\r\n\r\nOn 20 Jan 2022, at 0609, Innayat Joshi <innayatjoshi@hotmail.com> wrote\r\n\r\nday!  \r\n\r\n \r\n\r\nWe can promote your website that will give you first ranking on Google when a person enter a keyword.  \r\n\r\n \r\n\r\nLet me know if you are interested and I will send you best Monthly package for your website.  \r\n\r\n \r\n\r\nThanks & Regards,  \r\n\r\n \r\n\r\nInnayat Joshi \r\n', NULL, 1, 0, 0, NULL, 'dm@codefliestechnologies.com ', NULL, 'email', 50, '', '', '', '', '', '', NULL),
(2085, 'clie', 'testtttt@gmail.com', '1231231232', NULL, NULL, 'tesing data aaa', 'anamika@gmail.com', '12', 'qqe', NULL, 'Open', 'india', 'website', 'tech', '2022-02-04 08:02:57', 'Testing data For \'sd ', NULL, 1, 0, 0, NULL, 'bobby@codeflies.com', NULL, 'email', NULL, '', '', '', '', '', '', NULL),
(2086, 'clie', 'testtttt@gmail.com', '1231231232', NULL, '', 'tesing data aaa', 'anamika@gmail.com', NULL, 'qqe', 23, 'Open', NULL, NULL, NULL, '2022-02-04 11:02:34', 'Testing data For \'sd ', NULL, 1, 0, 0, NULL, 'bobby@codeflies.com', '1970-01-01', 'email', 0, '', '', '', '', '', '', NULL),
(2087, 'clie', 'testtttt@gmail.com', '1231231232', NULL, NULL, 'tesing data aaa', 'anamika@gmail.com', '12', 'qqe', 28, 'Open', 'india', 'website', 'tech', '2022-02-04 11:02:39', 'Testing data For \'sd ', NULL, 1, 0, 0, NULL, 'bobby@codeflies.com', NULL, 'email', NULL, '', '', '', '', '', '', NULL),
(2088, 'nnn', 'testtttt@gmail.com', '1231231232', NULL, NULL, 'tesing data aaa', 'anamika@gmail.com', '12', 'qqe', 23, 'Open', 'india', 'website', 'tech', '2022-02-07 09:02:56', 'Testing data For \'sd ', NULL, 1, 0, 0, NULL, 'bobby@codeflies.com', NULL, 'email', NULL, '', '', '', '', '', '', NULL),
(2089, 'aacascac', 'ascca@sdsdv', 'sdfsdfs', NULL, NULL, 'sdfsf', 'vidya.web4589@yahoo.com', '23423432', 'ascaca', 23, 'Open', 'Barbados', 'PPC', '', '2022-02-07 10:02:04', 'sdscsdvs', NULL, 1, 0, 0, NULL, '51', NULL, 'email', NULL, '', '', '', '', '', '', NULL),
(2090, 'asdasd', 'asdas@asfas', '3242423423423', NULL, NULL, 'sdfsdf', 'vidya.web4589@yahoo.com', '23423423', 'Salman', 23, 'Open', 'Belarus', 'PPC', '', '2022-02-07 11:02:40', 'sdfsdfsfsdf', NULL, 1, 0, 0, NULL, 'ben.bd@codefliestechnologies.com', NULL, 'email', NULL, '', '', '', '', '', '', NULL),
(2142, 'First Customer11', '', '123456789', NULL, 'Test1', 'Milk', NULL, '10', 'vansunmilking', NULL, 'Open', 'Uttar Pradesh', NULL, NULL, '2023-03-01 18:30:00', NULL, NULL, 1, 0, 0, NULL, NULL, NULL, 'email', NULL, 'Noida', 'Selling', '50%', '100', '40', 'Leader1', NULL),
(2143, 'First Customer22', '', '123456789', NULL, 'Test2', 'Milk', NULL, '10', 'vansunmilking', NULL, 'Open', 'Uttar Pradesh', NULL, NULL, '2023-03-04 18:30:00', NULL, NULL, 1, 0, 0, NULL, NULL, NULL, 'email', NULL, 'Noida', 'Selling', '50%', '100', '40', 'Leader2', NULL),
(2144, 'First Customer33', '', '123456789', NULL, 'Test3', 'Milk', NULL, '10', 'vansunmilking', NULL, 'Open', 'Uttar Pradesh', NULL, NULL, '2023-02-01 18:30:00', NULL, NULL, 1, 0, 0, NULL, NULL, NULL, 'email', NULL, 'Noida', 'Selling', '50%', '100', '40', 'Leader3', NULL),
(2145, 'First Customer44', '', '123456789', NULL, 'Test4', 'Milk', NULL, '10', 'vansunmilking', NULL, 'Open', 'Uttar Pradesh', NULL, NULL, '2023-01-01 18:30:00', NULL, NULL, 1, 0, 0, NULL, NULL, NULL, 'email', NULL, 'Noida', 'Selling', '50%', '100', '40', 'Leader4', NULL),
(2146, 'First Customer11', '', '123456789', NULL, 'Test1', 'Milk', NULL, '10', 'vansunmilking', NULL, 'Open', 'Uttar Pradesh', NULL, NULL, '2023-03-01 18:30:00', NULL, NULL, 1, 0, 0, NULL, NULL, NULL, 'email', NULL, 'Noida', 'Selling', '50%', '100', '40', 'Leader123', NULL),
(2147, 'First Customer11', '', '123456789', NULL, 'Test12332', 'Milk', NULL, '10', 'vansunmilking', NULL, 'Open', 'Uttar Pradesh', NULL, NULL, '2023-03-01 18:30:00', NULL, NULL, 1, 0, 0, NULL, NULL, NULL, 'email', NULL, 'Noida', 'Selling', '50%', '100', '40', 'Leader123', NULL),
(2148, 'First Customer11', '', '123456789', NULL, 'Test12332', 'Milk', NULL, '10', 'vansunmilking', NULL, 'Open', 'Uttar Pradesh', NULL, NULL, '2023-03-02 00:00:00', NULL, NULL, 1, 0, 0, NULL, NULL, NULL, 'email', NULL, 'Noida', 'Selling', '50%', '100', '40', 'Leader123', NULL),
(2149, 'First Customer22', '', '123456789', NULL, 'Test2', 'Milk', NULL, '10', 'vansunmilking', NULL, 'Open', 'Uttar Pradesh', NULL, NULL, '2023-03-05 00:00:00', NULL, NULL, 1, 0, 0, NULL, NULL, NULL, 'email', NULL, 'Noida', 'Selling', '50%', '100', '40', 'Leader2', NULL),
(2150, 'First Customer33', '', '123456789', NULL, 'Test3', 'Milk', NULL, '10', 'vansunmilking', NULL, 'Open', 'Uttar Pradesh', NULL, NULL, '2023-02-02 00:00:00', NULL, NULL, 1, 0, 0, NULL, NULL, NULL, 'email', NULL, 'Noida', 'Selling', '50%', '100', '40', 'Leader3', NULL),
(2151, 'First Customer44', '', '123456789', NULL, 'Test4', 'Milk', NULL, '10', 'vansunmilking', NULL, 'Open', 'Uttar Pradesh', NULL, NULL, '2023-01-02 00:00:00', NULL, NULL, 1, 0, 0, NULL, NULL, NULL, 'email', NULL, 'Noida', 'Selling', '50%', '100', '40', 'Leader4', NULL);

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

--
-- Table structure for table `responce`
--

CREATE TABLE `responce` (
  `id` int NOT NULL,
  `resdata` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `responce`
--

INSERT INTO `responce` (`id`, `resdata`) VALUES
(11, '1234567890'),
(12, ''),
(13, ''),
(14, '');

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

--
-- Table structure for table `tbl_country`
--

CREATE TABLE `tbl_country` (
  `id` int NOT NULL,
  `country` varchar(255) NOT NULL,
  `status` tinyint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_country`
--

INSERT INTO `tbl_country` (`id`, `country`, `status`) VALUES
(3, 'Albania', 0),
(4, 'Algeria', 0),
(6, 'Andorra', 0),
(7, 'Angola', 0),
(9, 'Antigua and Barbuda', 0),
(10, 'Argentina', 0),
(11, 'Armenia', 0),
(13, 'Austria', 0),
(14, 'Azerbaijan', 0),
(15, 'Bahamas', 0),
(16, 'Bangladesh', 0),
(17, 'Barbados', 0),
(18, 'Belarus', 0),
(19, 'Belgium', 0),
(20, 'Belize', 0),
(21, 'Benin', 0),
(23, 'Bhutan', 0),
(24, 'Bolivia', 0),
(25, 'Bosnia and Herzegovina', 0),
(26, 'Botswana', 0),
(27, 'Brazil', 0),
(29, 'Brunei', 0),
(30, 'Bulgaria', 0),
(31, 'Burkina Faso', 0),
(32, 'Burma', 0),
(33, 'Burundi', 0),
(34, 'Cambodia', 0),
(35, 'Cameroon', 0),
(36, 'Cape Verde', 0),
(37, 'Central African Republic', 0),
(38, 'Chad', 0),
(39, 'Chile', 0),
(40, 'China', 0),
(41, 'Colombia', 0),
(42, 'Comoros', 0),
(43, 'Cook Islands', 0),
(44, 'Costa Rica', 0),
(45, 'Country', 0),
(46, 'Croatia', 0),
(47, 'Cuba', 0),
(48, 'Czech Republic', 0),
(49, 'Democratic Republic of the Congo', 0),
(50, 'Denmark', 0),
(51, 'Djibouti', 0),
(52, 'Dominica', 0),
(53, 'Dominican Republic', 0),
(54, 'Ecuador', 0),
(55, 'Egypt', 0),
(56, 'El Salvador', 0),
(57, 'Equatorial Guinea', 0),
(58, 'Eritrea', 0),
(59, 'Estonia', 0),
(60, 'Ethiopia', 0),
(61, 'Faroe Islands', 0),
(62, 'Federated States of Micronesia', 0),
(63, 'Fiji', 0),
(64, 'Finland', 0),
(65, 'Gabon', 0),
(66, 'Gambia', 0),
(67, 'Georgia', 0),
(68, 'Ghana', 0),
(69, 'Greenland', 0),
(70, 'Grenada', 0),
(71, 'Guatemala', 0),
(72, 'Guinea', 0),
(73, 'Guinea-Bissau', 0),
(74, 'Guyana', 0),
(75, 'Haiti', 0),
(76, 'Honduras', 0),
(77, 'Hong Kong', 0),
(78, 'Hungary', 0),
(79, 'Iceland', 0),
(80, 'India', 0),
(81, 'Indonesia', 0),
(82, 'Iran', 0),
(83, 'Iraq', 0),
(84, 'Israel', 0),
(85, 'Ivory Coast', 0),
(86, 'Jamaica', 0),
(87, 'Japan', 0),
(88, 'Kazakhstan', 0),
(89, 'Kenya', 0),
(90, 'Kiribati', 0),
(91, 'Kosovo', 0),
(92, 'Kyrgyzstan', 0),
(93, 'Laos', 0),
(94, 'Latvia', 0),
(95, 'Lebanon', 0),
(96, 'Lesotho', 0),
(97, 'Liberia', 0),
(98, 'Libya', 0),
(99, 'Liechtenstein', 0),
(100, 'Lithuania', 0),
(101, 'Luxembourg', 0),
(102, 'Macau', 0),
(103, 'Macedonia', 0),
(104, 'Madagascar', 0),
(105, 'Malawi', 0),
(106, 'Malaysia', 0),
(107, 'Maldives', 0),
(108, 'Mali', 0),
(109, 'Malta', 0),
(110, 'Marshall Islands', 0),
(111, 'Mauritania', 0),
(112, 'Mauritius', 0),
(113, 'Mexico', 0),
(114, 'Moldov', 0),
(115, 'Mongolia', 0),
(116, 'Montenegro', 0),
(117, 'Morocco', 0),
(118, 'Mozambique', 0),
(119, 'Namibia', 0),
(120, 'Nauru', 0),
(121, 'Nepal', 0),
(122, 'Nicaragua', 0),
(123, 'Niger', 0),
(124, 'Nigeria', 0),
(125, 'Niue (NZ)', 0),
(126, 'North Korea', 0),
(127, 'Norway', 0),
(128, 'Pakistan', 0),
(129, 'Palau', 0),
(130, 'Palestine', 0),
(131, 'Papua New Guinea', 0),
(132, 'Paraguay', 0),
(133, 'Peru', 0),
(134, 'Philippines', 0),
(135, 'Poland', 0),
(136, 'Portugal', 0),
(137, 'Puerto Rico', 0),
(138, 'Qatar', 0),
(139, 'Republic of the Congo', 0),
(140, 'Romania', 0),
(141, 'Russia', 0),
(142, 'Rwanda', 0),
(143, 'Saint Kitts and Nevis', 0),
(144, 'Saint Lucia', 0),
(145, 'Saint Vincent and the Grenadines', 0),
(146, 'Samoa', 0),
(147, 'San Marino', 0),
(148, 'Sao Tom and Principe', 0),
(149, 'Saudi Arabia', 0),
(150, 'Senegal', 0),
(151, 'Serbia', 0),
(152, 'Seychelles', 0),
(153, 'Sierra Leone', 0),
(154, 'Slovakia', 0),
(155, 'Slovenia', 0),
(156, 'Solomon Islands', 0),
(157, 'Somalia', 0),
(158, 'South Africa', 0),
(159, 'South Korea', 0),
(160, 'South Sudan', 0),
(161, 'Sri Lanka', 0),
(162, 'Sudan', 0),
(163, 'Suriname', 0),
(164, 'Svalbard and Jan Mayen', 0),
(165, 'Swaziland', 0),
(166, 'Sweden', 0),
(167, 'Syria', 0),
(168, 'Taiwan', 0),
(169, 'Tajikistan', 0),
(170, 'Tanzania', 0),
(171, 'Thailand', 0),
(172, 'Timor-Leste', 0),
(173, 'Togo', 0),
(174, 'Tokelau', 0),
(175, 'Tonga', 0),
(176, 'Trinidad and Tobago', 0),
(177, 'Tunisia', 0),
(178, 'Turkey', 0),
(179, 'Turkmenistan', 0),
(180, 'Tuvalu', 0),
(181, 'Uganda', 0),
(182, 'Ukraine', 0),
(183, 'United Arab Emirates', 0),
(184, 'Uruguay', 0),
(185, 'Uzbekistan', 0),
(186, 'Vanuatu', 0),
(187, 'Vatican City', 0),
(188, 'Venezuela', 0),
(189, 'Vietnam', 0),
(190, 'Western Sahara', 0),
(192, 'Yemen', 0),
(193, 'Zambia', 0),
(194, 'Zimbabwe', 0),
(216, 'Monaco', 1),
(217, 'UK', 1),
(218, 'USA', 1),
(219, 'Switzerland', 1),
(220, 'Spain', 1),
(221, 'Singapore', 1),
(222, 'Cyprus', 1),
(223, 'Oman', 1),
(224, 'New Zealand', 1),
(225, 'Netherland', 1),
(226, 'Kuwait', 1),
(227, 'Panama', 1),
(228, 'Jordan', 1),
(229, 'Italy', 1),
(230, 'Ireland', 1),
(231, 'Greece', 1),
(232, 'Germany', 1),
(233, 'France', 1),
(234, 'Canada', 1),
(235, 'Bahrain', 1),
(236, 'Australia', 1);

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

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id` int NOT NULL,
  `username` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `inbox` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `role` varchar(255) NOT NULL,
  `last_login` varchar(255) NOT NULL,
  `leadgoal` int NOT NULL,
  `leaddone` int NOT NULL,
  `status` varchar(255) NOT NULL,
  `target_given` varchar(255) NOT NULL,
  `target_achive` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`id`, `username`, `email`, `inbox`, `password`, `role`, `last_login`, `leadgoal`, `leaddone`, `status`, `target_given`, `target_achive`, `token`) VALUES
(21, 'Bhupinderjit Singh', 'info@codeflies.com', 'bobby', '2ab686fba2d0b2b73d0200322c9251a5', 'super_admin', '', 0, 0, 'active', '', '', 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJlbWFpbCI6ImluZm9AY29kZWZsaWVzLmNvbSIsImlkIjoiMjEiLCJyb2xlIjoic3VwZXJfYWRtaW4ifQ.MyU65szZII1ZqDPn23h_RkJN0aORg8Uf9noPQ6NMgQQ'),
(22, 'ghanshyam', 'ghanshyam@codeflies.email', 'bobby1', '8ad55faa8b77e158226b7c7844dceb42', 'eme', '', 60, 0, 'active', '', '', ''),
(23, 'Salman', 'salman@codeflies.email', 'bobby1', '81dc9bdb52d04dc20036dbd8313ed055', 'eme', '', 60, 0, 'active', '', '', 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJlbWFpbCI6InNhbG1hbkBjb2RlZmxpZXMuZW1haWwiLCJpZCI6IjIzIiwicm9sZSI6ImVtZSIsImV4cCI6MTY0NDMyMzMxMH0.BiWHHMm4Dr68bTRBvzOwHyiptxISCuFsfsvydNcbh0E'),
(24, 'Shazia', 'shazia@codeflies.email', 'bobby', 'c7d9b925d30ab470f07ea409fc1b34f5', 'eme', '', 60, 0, 'active', '', '', ''),
(25, 'zeeshan', 'zeeshan@codeflies.email', 'bobby2', '0512199bd27a3c34ecec7c50ca244aa7', 'eme', '', 60, 0, 'active', '', '', ''),
(26, 'Lubna', 'lubna@codeflies.email', 'bobby', 'b0317193de366e8e3b745bc2b495ee70', 'eme', '', 60, 0, 'active', '', '', ''),
(27, 'Imran', 'imran@codeflies.email', 'bobby1', '3c47c85151aa75a578fe36cf75bdb6d4', 'eme', '', 60, 0, 'active', '', '', ''),
(28, 'amit', 'amitkumar@codeflies.email', 'bobby', '827ccb0eea8a706c4c34a16891f84e7b', 'eme', '', 60, 0, 'active', '', '', 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJlbWFpbCI6ImFtaXRrdW1hckBjb2RlZmxpZXMuZW1haWwiLCJpZCI6IjI4Iiwicm9sZSI6ImVtZSIsImV4cCI6MTY0NDMyMDExMX0.-iT3PEm7pt7x2yT-GzWYu2GRm0VOqIXkMSHjzMPbQ-s'),
(29, 'pankaj', 'pankaj@codeflies.email', 'bobby', '09535b2e0d55df8448b7546fd9dd6744', 'eme', '', 60, 0, 'active', '', '', ''),
(30, 'saad', 'saad@codeflies.email', 'bobby', '287062658b71ecd39ac649185ecdcfcc', 'eme', '', 60, 0, 'active', '', '', ''),
(31, 'Uvais', 'uvais@codeflies.email', 'bobby1', 'c839776133d482ee44b3b955cdc2651e', 'eme', '', 60, 0, 'active', '', '', ''),
(35, 'shailesh', 'shailesh@codeflies.email', 'bobby2', 'f63fb4138c58184e1f40819811e85186', 'eme', '', 60, 0, 'active', '', '', ''),
(36, 'ashish', 'ashishrai@codeflies.email', 'bobby', '8442e3143e38e2b32270a640e405ab3d', 'eme', '', 60, 0, 'active', '', '', ''),
(37, 'shakti', 'shakti@codeflies.com', 'bobby3', 'be4a93de30cb2c716b9fa59ad0984355', 'eme', '', 60, 0, 'active', '', '', ''),
(38, 'kanchan', 'kanchan@codeflies.com', 'bobby3', '14c9ecb811e5ed3ed3118a4e3a4bdc33', 'eme', '', 60, 0, 'active', '', '', ''),
(39, 'shehzad', 'shehzad@codeflies.com', 'bobby2', '42bf46ae09b86ab54e562f539ddafb45', 'eme', '', 60, 0, 'active', '', '', ''),
(40, 'Umesh', 'umesh@codeflies.com', 'bobby3', '7d9db04b04d46dccf028edff3385496d', 'eme', '', 60, 0, 'active', '', '', ''),
(41, 'Abhishek Garg', 'abhishekgarg@codeflies.com', 'bobby3', '032ac3d1920283a005078cd36d3868e7', 'eme', '', 60, 0, 'active', '', '', ''),
(42, 'Prince', 'prince@codeflies.com', 'bobby4', 'dfdc6c4fe9044eac56f4857023e6c74a', 'eme', '', 60, 0, 'active', '', '', ''),
(43, 'Rohit', 'rohit@codeflies.com', 'bobby2', 'b0317193de366e8e3b745bc2b495ee70', 'eme', '', 50, 0, 'active', '', '', ''),
(44, 'Sachin', 'sachin@codeflies.com', 'bobby4', '2a5deffae2c196bdf7e1a66e50bc09a5', 'eme', '', 60, 0, 'active', '', '', ''),
(45, 'Pooja', 'pooja@codeflies.com', 'bobby4', '4d0027e4ded32b7d14a1628ff56374a4', 'eme', '', 60, 0, 'active', '', '', ''),
(46, 'Guddu', 'guddu@codeflies.com', 'bobby4', 'd7eb145d603addd7f70b411acb0f50ff', 'eme', '', 60, 0, 'active', '', '', ''),
(47, 'Tariq', 'tariq@codeflies.com', 'bobby4', 'd3295fa73bf815330511bfd3e307b066', 'eme', '', 60, 0, 'active', '', '', ''),
(49, 'Vivek Bora', 'vivekbora@codeflies.com', 'w', '2adb1dd6f4fccd74d57188d39a0d81e4', 'super_admin', '', 0, 0, 'active', '', '', ''),
(50, 'Ankit', 'ankit@codeflies.com', 'ben.bd@codefliestechnologies.com', '827ccb0eea8a706c4c34a16891f84e7b', 'admin', '', 0, 0, 'active', '', '', 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJlbWFpbCI6ImFua2l0QGNvZGVmbGllcy5jb20iLCJpZCI6IjUwIiwicm9sZSI6ImFkbWluIiwiZXhwIjoxNjQ0MDM2MzEwfQ.lAiGIjW6fKfnXokBEp5mptA0t4flLS5M3x8M76ZFLNA'),
(51, 'Bobby', 'bobby@codeflies.com', 'bobby@codeflies.com', 'b0317193de366e8e3b745bc2b495ee70', 'admin', '', 0, 0, 'active', '', '', ''),
(52, 'Parvesh', 'parvesh@codeflies.com', 'dm@codefliestechnologies.com', '89330d32349d425cdd6c316805b4718c', 'eme', '', 60, 0, 'active', '', '', ''),
(53, 'Sumit', 'sumit@codeflies.com', 'dm@codefliestechnologies.com', '249254f45bb936578250090b3267b227', 'eme', '', 60, 0, 'active', '', '', ''),
(54, 'Chayanika Agrahari', 'chayanika@codeflies.com', 'w', 'b0317193de366e8e3b745bc2b495ee70', 'super_admin', '', 0, 0, 'active', '', '', ''),
(55, 'Nasim', 'nasim@codeflies.com', 'w', '4c9e649c0fb120d2b6d911ae6a4a18ab', 'eme', '', 60, 0, 'active', '', '', ''),
(56, 'test', 'test@codeflies.com', 'bobby', 'f925916e2754e5e03f75dd58a5733251', 'super_admin', '', 0, 0, 'active', '', '', 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJlbWFpbCI6InRlc3RAY29kZWZsaWVzLmNvbSIsImlkIjoiNTYiLCJyb2xlIjoic3VwZXJfYWRtaW4iLCJleHAiOjE2NDQzODA3Mjl9.A4cRW7kH8zed55WmoQX5V-SKUSpjclTkAKhnhBShJ5Y'),
(57, 'test2', 'test2@codeflies.com', 'bobby', 'f925916e2754e5e03f75dd58a5733251', 'admin', '', 0, 0, 'active', '', '', 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJlbWFpbCI6InRlc3QyQGNvZGVmbGllcy5jb20iLCJpZCI6IjU3Iiwicm9sZSI6ImFkbWluIiwiZXhwIjoxNjQzOTU5MzY3fQ.cf7y71thcYliOG2etNblakxx4wNvLyIPeRer2dS6flw'),
(58, 'newUserTest', 'email@gmail.com', '', '81dc9bdb52d04dc20036dbd8313ed055', 'super_admin', '', 22, 0, 'active', '40000', '0', ''),
(59, 'newUserTest', 'email@gmail.com', 'inbox@mail', '81dc9bdb52d04dc20036dbd8313ed055', 'super_admin', '', 22, 0, 'active', '40000', '0', ''),
(60, 'vansunmilking', 'info@vansunmilking.com', 'info@vansunmilking.com', 'e10adc3949ba59abbe56e057f20f883e', 'super_admin', '', 0, 0, 'active', '', '', '');

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

--
-- Structure for view `data`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `data`  AS SELECT `leads`.`lead_id` AS `lead_id`, `leads`.`name` AS `name`, `leads`.`title` AS `title`, `leads`.`phonenumber` AS `phonenumber`, `leads`.`replied` AS `replied`, `leads`.`contacton` AS `contacton`, `leads`.`added_by` AS `added_by`, `leads`.`status` AS `lead_status`, `leads`.`country` AS `country`, `leads`.`application_website` AS `application_website`, `leads`.`technology` AS `technology`, `leads`.`created` AS `created`, `leads`.`comments` AS `comments`, `leads`.`class_color` AS `class_color`, `leads`.`star` AS `star`, `leads`.`email` AS `lead_email`, `user`.`username` AS `username`, `user`.`email` AS `email`, `user`.`inbox` AS `inbox`, `user`.`role` AS `role`, `user`.`status` AS `status`, `user`.`leadgoal` AS `leadgoal` FROM (`leads` join `user` on((`leads`.`added_by` = `user`.`username`))) ;

--
-- Indexes for dumped tables
--

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

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

--
-- Indexes for table `leads`
--
ALTER TABLE `leads`
  ADD PRIMARY KEY (`lead_id`),
  ADD UNIQUE KEY `comp_key` (`comp_key`);

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `comments`
--
ALTER TABLE `comments`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=215;

--
-- AUTO_INCREMENT for table `eme_emails`
--
ALTER TABLE `eme_emails`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `leads`
--
ALTER TABLE `leads`
  MODIFY `lead_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2152;

--
-- AUTO_INCREMENT for table `responce`
--
ALTER TABLE `responce`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `tbl_country`
--
ALTER TABLE `tbl_country`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=237;

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

