-- Table structure for table `contact_queries`
--

CREATE TABLE `contact_queries` (
  `id` int(11) NOT NULL,
  `ticket_number` varchar(50) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `mobile` varchar(20) NOT NULL,
  `message` text NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `status` enum('open','in-progress','resolved','closed') DEFAULT 'open'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `contact_queries`
--

INSERT INTO `contact_queries` (`id`, `ticket_number`, `name`, `email`, `mobile`, `message`, `created_at`, `status`) VALUES
(1, 'TKT20251008072125342', 'Anurag Rathore', 'akshitbabu30@gmail.com', '9368657586', 'Maine is pr id bnaya aur payment bhi kr diya jiska utr no 328709089434 hai pr ye otr section mai submit Kiya to nhi ho rha jabki payment kat chuka hai aur mera I\'d login nhi ho rha pls help', '2025-10-08 03:51:25', 'open'),
(2, 'TKT20251010003222345', 'Nikita ', 'nikita.roketdigitech@gmail.com', '7532833829', 'Hi http://phpii.info,\r\n\r\nI noticed that your website has great potential but is not currently ranking in the top search results on Google.\r\n\r\nI specialize in SEO and can help your business rank in the Top 3 positions, get more visibility, and ultimately increase your customer base – guaranteed!\r\n\r\nWould you like me to send a quick SEO proposal with pricing and strategies?\r\n\r\nBest regards,\r\nNikita', '2025-10-09 21:02:22', 'open'),
(3, 'TKT20251016160945472', 'Niketa ', 'guenther.rickey@outlook.com', '7532833829', 'Hi http://phpii.info,\r\n\r\nYour website is not ranking well on Google.\r\n\r\nI can help you in putting your website on the Google\'s top-3 Rank and getting more customers Guaranteed.\r\n\r\nWould you like to me seo proposal your business site\r\n\r\nIf you’re interested, then I will send you SEO Packages and strategies.\r\n\r\nWarm regards,\r\nNiketa', '2025-10-16 12:39:45', 'open'),
(4, 'TKT20251024095216445', 'Sonam Prajapati', 'sonam.dgtlsolution@gmail.com', '9266141479', 'Hi,\r\n\r\n\r\nDo you have a great website but not getting enough leads? \r\nMany businesses miss potential customers because they don���t appear in top search results.SEO can fix that.\r\n\r\n\r\nHow we can help:\r\n\r\n1. Audit your site for errors and improvements\r\n\r\n2. Focus on high-impact keywords\r\n\r\n3. Optimize content for user experience\r\n\r\n4. Track rankings and traffic growth\r\n\r\n\r\nTo create a custom proposal, could you share your website, target keywords, and locations?\r\n\r\n\r\nBest regards,\r\n\r\nSonam', '2025-10-24 06:22:16', 'open'),
(5, 'TKT20251024140919699', 'Penni Buntine', 'mckeeknight85065@gmail.com', '9225193592', 'Hello,\r\n\r\nWant more visitors and clients for your phpii.info?\r\n\r\nAs a bonus, we can offer you a free SEO Audit and a free SEO Backlinks service.\r\n\r\nWe help websites get real visitors and real clients through proven online marketing methods.\r\n\r\nWould you like a quick free analysis of your site’s potential?\r\n\r\nBest regards,\r\nPenni from Digital Marketing Team\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nGermany, BY, Guttenberg, 95358, Ellmenreichstrasse 86\r\n\r\nTo stop any further communication through your website form, Please reply with subject:  Unsubscribe !phpii.info', '2025-10-24 10:39:19', 'open'),
(6, 'TKT20251027213301328', 'Fallon Bent', 'mckeeknight85065@gmail.com', '3462711945', 'Hello,\r\n\r\nYour website has some issues, take a look: https://www.seoptimer.com/phpii.info\r\n\r\nWe can help fix these issues and improve your backlink profile.\r\n\r\nClaim your first SEO Backlink service for free, so you can see results before committing.\r\n\r\nAre you interested?\r\n\r\nBest regards,\r\nFallon from Digital Marketing Team\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nSweden, NA, Vessigebro, 310 58, Loberod 22\r\nTo stop any further communication through your website form, Please reply with subject:  Unsubscribe !phpii.info', '2025-10-27 17:03:01', 'open'),
(7, 'TKT20251105161026890', 'Robby Byrnes', 'turnerfisher.348382+robby.byrnes@gmail.com', '92280451', 'We can create a free professional video for phpii.info to help attract more customers and make your site stand out,  want to see it?', '2025-11-05 11:40:26', 'open'),
(8, 'TKT20251107121230433', 'SK Verma', 'skmafia8586@gmail.com', '8953268129', 'आपका यह साईट कà¥यों चल नहीं रहा है कà¥छ दिनों से कब तक सही होगा\r\nhttps://dc.crsorgi.gov.in.web.index.auth.dc-verifycertificate.info/web/index.php/auth/login.php', '2025-11-07 07:42:30', 'open');

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

--
-- Table structure for table `contact_replies`
--

CREATE TABLE `contact_replies` (
  `id` int(11) NOT NULL,
  `contact_id` int(11) NOT NULL,
  `reply_message` text NOT NULL,
  `replied_by` varchar(255) NOT NULL,
  `replied_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `dbt_farmer_br_pdf`
--

CREATE TABLE `dbt_farmer_br_pdf` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `aadhar` varchar(255) DEFAULT NULL,
  `pdf` longtext DEFAULT NULL,
  `date` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `dl_pdf`
--

CREATE TABLE `dl_pdf` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `aadhar` varchar(255) DEFAULT NULL,
  `pdf` longtext DEFAULT NULL,
  `date` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `dl_pdf`
--

INSERT INTO `dl_pdf` (`id`, `name`, `username`, `aadhar`, `pdf`, `date`) VALUES
(1, 'MANOJ KUMAR  KUSHWAHA', '9889149562', 'UP7020150033630', 'data:application/pdf;base64,[BLOB]', '2025-10-06 17:49:44');
INSERT INTO `dl_pdf` (`id`, `name`, `username`, `aadhar`, `pdf`, `date`) VALUES
(2, 'SANTOSH KUMAR SAHU', '8249622067', 'OD3220170006701', 'data:application/pdf;base64,[BLOB]', '2025-10-27 12:14:07');
INSERT INTO `dl_pdf` (`id`, `name`, `username`, `aadhar`, `pdf`, `date`) VALUES
(3, 'RAJAN KUMAR MANDAL', '9519778486', 'JH1020210008242', 'data:application/pdf;base64,[BLOB]