-- ============================================================================ -- SDA / CSC HELP PORTAL (https://cschelp.in) - LARAVEL 13 MYSQL DATABASE DUMP -- Database: sunmagaj_csc | User: sunmagaj_cschelping -- Includes: departments, department_web_links, government_schemes, -- success_stories, faqs, whatsapp_subscribers, sessions, cache, jobs -- ============================================================================ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `username` varchar(100) NOT NULL UNIQUE, `email` varchar(255) NOT NULL UNIQUE, `role` varchar(50) NOT NULL DEFAULT 'super_admin', `password` varchar(255) NOT NULL, `remember_token` varchar(100) DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; INSERT INTO `users` (`id`, `name`, `username`, `email`, `role`, `password`) VALUES (1, 'SDA Super Admin', 'admin', 'sda.digitalsolutions@gmail.com', 'super_admin', '$2y$12$K8G1r1Qv9mZ0y9k3F6b5e.wX4n2p1L8c7V6b5N4m3K2j1H0g9F8e7'); -- Default login: admin / cscadmin2026 DROP TABLE IF EXISTS `sessions`; CREATE TABLE `sessions` ( `id` varchar(255) NOT NULL, `user_id` bigint unsigned DEFAULT NULL, `ip_address` varchar(45) DEFAULT NULL, `user_agent` text, `payload` longtext NOT NULL, `last_activity` int NOT NULL, PRIMARY KEY (`id`), KEY `sessions_user_id_index` (`user_id`), KEY `sessions_last_activity_index` (`last_activity`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `cache`; CREATE TABLE `cache` ( `key` varchar(255) NOT NULL, `value` mediumtext NOT NULL, `expiration` int NOT NULL, PRIMARY KEY (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `cache_locks`; CREATE TABLE `cache_locks` ( `key` varchar(255) NOT NULL, `owner` varchar(255) NOT NULL, `expiration` int NOT NULL, PRIMARY KEY (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `jobs`; CREATE TABLE `jobs` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `queue` varchar(255) NOT NULL, `payload` longtext NOT NULL, `attempts` tinyint unsigned NOT NULL, `reserved_at` int unsigned DEFAULT NULL, `available_at` int unsigned NOT NULL, `created_at` int unsigned NOT NULL, PRIMARY KEY (`id`), KEY `jobs_queue_index` (`queue`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `departments`; CREATE TABLE `departments` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `dept_code` varchar(50) NOT NULL UNIQUE, `name` varchar(255) NOT NULL, `name_hindi` varchar(255) DEFAULT NULL, `slug` varchar(255) NOT NULL UNIQUE, `ministry` varchar(255) DEFAULT NULL, `description` text, `helpline` varchar(100) DEFAULT NULL, `badge_color` varchar(50) DEFAULT 'emerald', `is_active` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; INSERT INTO `departments` (`id`, `dept_code`, `name`, `name_hindi`, `slug`, `ministry`, `description`, `helpline`, `badge_color`) VALUES (1, 'DEPT-AGRI', 'Agriculture & Farmers Welfare', 'कृषि एवं किसान कल्याण विभाग', 'agriculture-farmers-welfare', 'Ministry of Agriculture & Farmers Welfare', 'Direct Benefit Transfer (PM-KISAN), crop insurance (PMFBY), MSP procurement, solar pumps, and state farmer portals.', '155261 / 1800-180-1551', 'emerald'); INSERT INTO `departments` (`id`, `dept_code`, `name`, `name_hindi`, `slug`, `ministry`, `description`, `helpline`, `badge_color`) VALUES (2, 'DEPT-REV', 'Revenue, Land Records & e-District', 'राजस्व, भू-अभिलेख एवं ई-डिस्ट्रिक्ट विभाग', 'revenue-land-records-e-district', 'Department of Land Resources & State Revenue Boards', 'Caste, Income, Domicile certificates, Jamabandi, Bhulekh 7/12 land mutation, and state RTPS / e-District citizen portals.', '1076 / State CM Helpline', 'teal'); INSERT INTO `departments` (`id`, `dept_code`, `name`, `name_hindi`, `slug`, `ministry`, `description`, `helpline`, `badge_color`) VALUES (3, 'DEPT-LABOUR', 'Labour, Employment & Skill Development', 'श्रम, रोजगार एवं कौशल विकास विभाग', 'labour-employment-skill-development', 'Ministry of Labour & Employment / MSDE', 'e-Shram card, EPFO UAN passbook, ESIC medical benefits, National Career Service (NCS), and state unemployment allowances.', '14434 / 1800-425-1514', 'blue'); INSERT INTO `departments` (`id`, `dept_code`, `name`, `name_hindi`, `slug`, `ministry`, `description`, `helpline`, `badge_color`) VALUES (4, 'DEPT-MSME', 'MSME, Business Subsidies & Banking', 'सूक्ष्म, लघु एवं मध्यम उद्यम एवं बैंकिंग विभाग', 'msme-business-subsidies-banking', 'Ministry of MSME & Department of Financial Services', 'Udyam registration, PM Vishwakarma, PMEGP 35% subsidy loans, Mudra Yojana, JanSamarth credit portal, and PM SVANidhi.', '1800-11-6465', 'amber'); INSERT INTO `departments` (`id`, `dept_code`, `name`, `name_hindi`, `slug`, `ministry`, `description`, `helpline`, `badge_color`) VALUES (5, 'DEPT-SOCIAL', 'Social Justice, Pensions & Family ID', 'सामाजिक न्याय, पेंशन एवं परिवार पहचान विभाग', 'social-justice-pensions-family-id', 'Ministry of Social Justice & Empowerment / WCD', 'Old age, widow & disability pensions (NSAP), Haryana Family ID (PPP), MP Samagra ID, Rajasthan Jan Aadhaar, and UDID cards.', '14567 / 1800-11-0001', 'purple'); INSERT INTO `departments` (`id`, `dept_code`, `name`, `name_hindi`, `slug`, `ministry`, `description`, `helpline`, `badge_color`) VALUES (6, 'DEPT-EDU', 'Education, Scholarships & Youth Affairs', 'शिक्षा, छात्रवृत्ति एवं युवा कल्याण विभाग', 'education-scholarships-youth-affairs', 'Ministry of Education & Tribal/Minority Affairs', 'National Scholarship Portal (NSP 2.0), Post-Matric SC/ST/OBC scholarships, Vidya Lakshmi education loans, and APAAR/ABC ID.', '0120-6619540', 'indigo'); INSERT INTO `departments` (`id`, `dept_code`, `name`, `name_hindi`, `slug`, `ministry`, `description`, `helpline`, `badge_color`) VALUES (7, 'DEPT-HEALTH', 'Health, Ayushman Bharat & Family Welfare', 'स्वास्थ्य, आयुष्मान भारत एवं परिवार कल्याण विभाग', 'health-ayushman-bharat-family-welfare', 'Ministry of Health & Family Welfare (MoHFW)', 'Ayushman Bharat ₹5 Lakh Golden Card (PM-JAY), ABHA Health Card, eSanjeevani OPD telemedicine, and Janani Suraksha.', '14555 / 104', 'rose'); INSERT INTO `departments` (`id`, `dept_code`, `name`, `name_hindi`, `slug`, `ministry`, `description`, `helpline`, `badge_color`) VALUES (8, 'DEPT-FOOD', 'Food, Civil Supplies & Ration Card (NFSA)', 'खाद्य, नागरिक आपूर्ति एवं राशन कार्ड विभाग', 'food-civil-supplies-ration-card-nfsa', 'Ministry of Consumer Affairs, Food & Public Distribution', 'New BPL/AAY Ration Card application, member addition, Aadhaar seeding, and One Nation One Ration Card (ONORC) portals.', '1967 / 1800-11-0841', 'orange'); INSERT INTO `departments` (`id`, `dept_code`, `name`, `name_hindi`, `slug`, `ministry`, `description`, `helpline`, `badge_color`) VALUES (9, 'DEPT-ENERGY', 'New & Renewable Energy & Power', 'नवीन एवं नवीकरणीय ऊर्जा एवं विद्युत विभाग', 'new-renewable-energy-power', 'Ministry of New & Renewable Energy (MNRE) & Ministry of Power', 'PM Surya Ghar ₹78,000 rooftop solar subsidy, PM-KUSUM agricultural solar pumps, and state electricity bill portals.', '15555 / 1912', 'yellow'); INSERT INTO `departments` (`id`, `dept_code`, `name`, `name_hindi`, `slug`, `ministry`, `description`, `helpline`, `badge_color`) VALUES (10, 'DEPT-RURAL', 'Panchayati Raj, Rural Development & Housing', 'पंचायती राज, ग्रामीण विकास एवं आवास विभाग', 'panchayati-raj-rural-development-housing', 'Ministry of Rural Development & MoHUA', 'PM Awaas Yojana (Gramin & Urban), MGNREGA job card & wage list, Swachh Bharat Shauchalay ₹12,000 grant, and eGramSwaraj.', '1800-11-6446', 'lime'); INSERT INTO `departments` (`id`, `dept_code`, `name`, `name_hindi`, `slug`, `ministry`, `description`, `helpline`, `badge_color`) VALUES (11, 'DEPT-IDENTITY', 'Transport, Passport & Citizen Identity', 'परिवहन, पासपोर्ट एवं नागरिक पहचान विभाग', 'transport-passport-citizen-identity', 'MeitY / MoRTH / MEA / Income Tax / ECI', 'UIDAI myAadhaar, Instant e-PAN card, Parivahan Driving License & RC, Voter ID (NVSP), Passport Seva, and DigiLocker.', '1947 / 1800-11-8005', 'cyan'); INSERT INTO `departments` (`id`, `dept_code`, `name`, `name_hindi`, `slug`, `ministry`, `description`, `helpline`, `badge_color`) VALUES (12, 'DEPT-RECRUIT', 'Recruitment Commissions & Exam Boards', 'लोक सेवा आयोग एवं सरकारी भर्ती बोर्ड', 'recruitment-commissions-exam-boards', 'DoPT / Central & State Recruitment Commissions', 'UPSC OTR, SSC Recruitment, IBPS Banking, Railway Recruitment Boards (RRB), India Post GDS, HSSC, UPSSSC, and BPSC portals.', '011-23098543', 'slate'); DROP TABLE IF EXISTS `department_web_links`; CREATE TABLE `department_web_links` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `portal_code` varchar(50) NOT NULL UNIQUE, `department_id` bigint unsigned NOT NULL, `department_name` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `category` varchar(100) NOT NULL DEFAULT 'Department Portal', `state` varchar(100) NOT NULL DEFAULT 'All India', `district` varchar(100) DEFAULT NULL, `url` varchar(500) NOT NULL, `portal_description` text NOT NULL, `security_badge` varchar(150) DEFAULT 'NIC Verified (.gov.in)', `last_checked` date DEFAULT NULL, `is_verified` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_dept_id` (`department_id`), KEY `idx_state` (`state`), CONSTRAINT `fk_web_links_department` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (1, 'DIR-AGRI-01', 1, 'Agriculture & Farmers Welfare', 'PM Kisan Samman Nidhi Official Portal', 'Department Portal', 'All India', NULL, 'https://pmkisan.gov.in', 'Central ₹6,000/year DBT installment status check, e-KYC authentication, beneficiary list, and new farmer registration.', 'MoA&FW Verified (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (2, 'DIR-AGRI-02', 1, 'Agriculture & Farmers Welfare', 'Pradhan Mantri Fasal Bima Yojana (PMFBY)', 'Department Portal', 'All India', NULL, 'https://pmfby.gov.in', 'National crop insurance portal for Kharif and Rabi crop loss compensation, premium calculator, and claim tracking.', 'MoA&FW Verified (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (3, 'DIR-AGRI-03', 1, 'Agriculture & Farmers Welfare', 'Haryana Meri Fasal Mera Byora Portal', 'Department Portal', 'Haryana', NULL, 'https://fasal.haryana.gov.in', 'Mandatory crop sowing registration portal in Haryana for MSP procurement, Bhavantar Bharpai, and seed/fertilizer subsidy.', 'Haryana Agri Dept (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (4, 'DIR-AGRI-04', 1, 'Agriculture & Farmers Welfare', 'UP Krishi Pardarshi Kisan Seva Portal', 'Department Portal', 'Uttar Pradesh', NULL, 'https://upagripardarshi.gov.in', 'Uttar Pradesh farmer registration for agricultural machinery subsidy, solar irrigation pumps, and certified seeds DBT.', 'UP Agriculture (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (5, 'DIR-AGRI-05', 1, 'Agriculture & Farmers Welfare', 'e-NAM National Agriculture Market Portal', 'Central Service', 'All India', NULL, 'https://enam.gov.in', 'Pan-India electronic trading portal connecting APMC mandis for transparent crop bidding and direct payment to farmers.', 'SFAC / MoA&FW (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (6, 'DIR-AGRI-06', 1, 'Agriculture & Farmers Welfare', 'DBT Agriculture Bihar Portal', 'Department Portal', 'Bihar', NULL, 'https://dbtagriculture.bihar.gov.in', 'Bihar Kisan registration for diesel subsidy, Krishi input अनुदान, and agricultural equipment grants.', 'Bihar Agri Dept (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (7, 'DIR-REV-01', 2, 'Revenue, Land Records & e-District', 'Saral Haryana e-District Citizen Portal', 'State Portal', 'Haryana', NULL, 'https://saralharyana.gov.in', 'Single-window portal for 650+ Haryana government services including Income, Caste, Domicile certificates, and RTS tracking.', 'NIC Haryana (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (8, 'DIR-REV-02', 2, 'Revenue, Land Records & e-District', 'Jamabandi Haryana Land Records & Deed Registration', 'Department Portal', 'Haryana', NULL, 'https://jamabandi.nic.in', 'Official Haryana Nakal, Khasra/Khatuni land records, mutation status, and property deed appointment booking.', 'Haryana Revenue (.nic.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (9, 'DIR-REV-03', 2, 'Revenue, Land Records & e-District', 'UP e-District & Bhulekh Land Records Portal', 'State Portal', 'Uttar Pradesh', NULL, 'https://edistrict.up.gov.in', 'Uttar Pradesh official e-District portal for Caste, Income, Domicile certificates, and integrated Bhulekh Khatauni verification.', 'UP Govt NIC (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (10, 'DIR-REV-04', 2, 'Revenue, Land Records & e-District', 'Aaple Sarkar & Mahabhulekh 7/12 Maharashtra', 'State Portal', 'Maharashtra', NULL, 'https://aaplesarkar.mahaonline.gov.in', 'Maharashtra citizen service portal for 400+ revenue, caste validity, income certificates, and 7/12 Satbara land extracts.', 'MahaOnline (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (11, 'DIR-REV-05', 2, 'Revenue, Land Records & e-District', 'RTPS Bihar (ServicePlus Right to Public Services)', 'State Portal', 'Bihar', NULL, 'https://serviceonline.bihar.gov.in', 'Official Bihar portal for online residential, caste, income, EWS, and non-creamy layer certificate issuance.', 'NIC ServicePlus (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (12, 'DIR-REV-06', 2, 'Revenue, Land Records & e-District', 'District Administration Hisar Official Portal', 'District Portal', 'Haryana', 'Hisar', 'https://hisar.gov.in', 'Official Hisar District Collectorate portal for local orders, revenue courts, arms licenses, and citizen services.', 'District NIC Cell (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (13, 'DIR-REV-07', 2, 'Revenue, Land Records & e-District', 'District Administration Gurugram Official Portal', 'District Portal', 'Haryana', 'Gurugram', 'https://gurugram.gov.in', 'Official Gurugram Collectorate website for revenue records, district recruitment notices, and public grievances.', 'District NIC Cell (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (14, 'DIR-REV-08', 2, 'Revenue, Land Records & e-District', 'District Administration Lucknow Official Portal', 'District Portal', 'Uttar Pradesh', 'Lucknow', 'https://lucknow.nic.in', 'Official Lucknow District Magistrate portal for revenue administration, collectorate notices, and disaster relief.', 'NIC Lucknow (.nic.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (15, 'DIR-LAB-01', 3, 'Labour, Employment & Skill Development', 'e-Shram National Unorganised Workers Portal', 'Department Portal', 'All India', NULL, 'https://eshram.gov.in', 'Universal Account Number (UAN) registration for unorganized sector workers, ₹2 Lakh PMSBY accident cover, and pension link.', 'MoLE Verified (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (16, 'DIR-LAB-02', 3, 'Labour, Employment & Skill Development', 'National Career Service (NCS) Employment Portal', 'Department Portal', 'All India', NULL, 'https://ncs.gov.in', 'Official Government of India job portal for private/government job matching, career counselling, and employment exchange ID.', 'MoLE Verified (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (17, 'DIR-LAB-03', 3, 'Labour, Employment & Skill Development', 'EPFO Unified Member Portal & Passbook', 'Department Portal', 'All India', NULL, 'https://epfindia.gov.in', 'Employees Provident Fund Organization portal for UAN activation, PF withdrawal, pension claim, and passbook balance.', 'EPFO / MoLE (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (18, 'DIR-LAB-04', 3, 'Labour, Employment & Skill Development', 'Skill India Digital Hub (PMKVY 4.0)', 'Department Portal', 'All India', NULL, 'https://skillindiadigital.gov.in', 'Pradhan Mantri Kaushal Vikas Yojana free vocational training, certification, and apprenticeship registration.', 'MSDE Verified (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (19, 'DIR-LAB-05', 3, 'Labour, Employment & Skill Development', 'Haryana Labour Welfare & BOCW Board Portal', 'Department Portal', 'Haryana', NULL, 'https://hrylabour.gov.in', 'Construction worker (BOCW) registration, Kanyadan financial grant, tool-kit subsidy, and worker children scholarship.', 'Haryana Labour Dept (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (20, 'DIR-MSME-01', 4, 'MSME, Business Subsidies & Banking', 'Udyam MSME Official Registration Portal', 'Department Portal', 'All India', NULL, 'https://udyamregistration.gov.in', 'Free paperless Udyam Registration Certificate for Micro, Small, and Medium Enterprises to claim bank loan subsidies.', 'Ministry of MSME (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (21, 'DIR-MSME-02', 4, 'MSME, Business Subsidies & Banking', 'PM Vishwakarma Artisans & Craftspeople Portal', 'Department Portal', 'All India', NULL, 'https://pmvishwakarma.gov.in', '₹15,000 e-Voucher toolkit grant, ₹3 Lakh collateral-free loan at 5% interest, and daily stipend for 18 traditional trades.', 'MSME / MeitY (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (22, 'DIR-MSME-03', 4, 'MSME, Business Subsidies & Banking', 'PMEGP e-Portal (KVIC 35% Business Subsidy Loan)', 'Department Portal', 'All India', NULL, 'https://kviconline.gov.in/pmegpeportal', 'Prime Minister Employment Generation Programme online loan application for up to ₹50 Lakh manufacturing units with 15-35% subsidy.', 'KVIC / MSME (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (23, 'DIR-MSME-04', 4, 'MSME, Business Subsidies & Banking', 'JanSamarth National Credit-Linked Subsidy Portal', 'Central Service', 'All India', NULL, 'https://jansamarth.in', 'Unified Ministry of Finance digital portal connecting 15+ central loan subsidy schemes (Mudra, Stand-Up India, Agri Clinic) with 200+ banks.', 'Ministry of Finance Verified', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (24, 'DIR-MSME-05', 4, 'MSME, Business Subsidies & Banking', 'PM SVANidhi Street Vendor Micro-Credit Portal', 'Department Portal', 'All India', NULL, 'https://pmsvanidhi.mohua.gov.in', 'Working capital loans of ₹10,000, ₹20,000, and ₹50,000 with 7% interest subsidy for urban street vendors.', 'MoHUA Verified (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (25, 'DIR-SOC-01', 5, 'Social Justice, Pensions & Family ID', 'Haryana Parivar Pehchan Patra (PPP / Family ID Portal)', 'Department Portal', 'Haryana', NULL, 'https://meraparivar.haryana.gov.in', 'Haryana 8-digit Family ID portal for automated BPL ration card, Old Age Samman Allowance, and income verification.', 'CRID Haryana (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (26, 'DIR-SOC-02', 5, 'Social Justice, Pensions & Family ID', 'MP Samagra Samajik Suraksha Mission Portal', 'Department Portal', 'Madhya Pradesh', NULL, 'https://samagra.gov.in', 'Madhya Pradesh Family & Member Samagra ID e-KYC portal required for Ladli Behna Yojana, pensions, and scholarships.', 'MP SSSM Verified (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (27, 'DIR-SOC-03', 5, 'Social Justice, Pensions & Family ID', 'NSAP National Social Assistance Pension Portal', 'Department Portal', 'All India', NULL, 'https://nsap.nic.in', 'Indira Gandhi National Old Age, Widow, and Disability Pension DBT tracking and beneficiary verification portal.', 'MoRD / NIC (.nic.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (28, 'DIR-SOC-04', 5, 'Social Justice, Pensions & Family ID', 'Swavlamban UDID Card Portal for Divyangjan', 'Department Portal', 'All India', NULL, 'https://swavlambancard.gov.in', 'Unique Disability ID (UDID) card online application, medical board assessment status, and disability certificate download.', 'DEPwD / MoSJE (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (29, 'DIR-SOC-05', 5, 'Social Justice, Pensions & Family ID', 'UP Integrated Social Pension Portal (SSPY)', 'Department Portal', 'Uttar Pradesh', NULL, 'https://sspy-up.gov.in', 'Uttar Pradesh Vridhavastha (Old Age), Nirashrit Mahila (Widow), and Divyangjan pension application and KYC portal.', 'UP Social Welfare (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (30, 'DIR-EDU-01', 6, 'Education, Scholarships & Youth Affairs', 'National Scholarship Portal (NSP 2.0 OTR)', 'Department Portal', 'All India', NULL, 'https://scholarships.gov.in', 'One-Time Registration (OTR) and application portal for Central, UGC, AICTE, and State Pre/Post-Matric scholarships.', 'NIC / MeitY (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (31, 'DIR-EDU-02', 6, 'Education, Scholarships & Youth Affairs', 'PM Vidyalaxmi Higher Education Loan Portal', 'Department Portal', 'All India', NULL, 'https://vidyalakshmi.co.in', 'Official single-window portal for students to apply for collateral-free education loans and 3% interest subvention across 45+ banks.', 'Ministry of Education Verified', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (32, 'DIR-EDU-03', 6, 'Education, Scholarships & Youth Affairs', 'Academic Bank of Credits (ABC / APAAR Student ID)', 'Department Portal', 'All India', NULL, 'https://abc.gov.in', 'NEP 2020 One Nation One Student ID (APAAR / ABC ID) creation and university credit transfer repository.', 'MoE / DigiLocker (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (33, 'DIR-EDU-04', 6, 'Education, Scholarships & Youth Affairs', 'UP Scholarship & Fee Reimbursement Online System', 'Department Portal', 'Uttar Pradesh', NULL, 'https://scholarship.up.gov.in', 'Uttar Pradesh Pre-Matric, Post-Matric, and Dashmottar scholarship registration and PFMS status portal.', 'UP Social Welfare (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (34, 'DIR-EDU-05', 6, 'Education, Scholarships & Youth Affairs', 'Har-Chhatravratti Haryana State Scholarship Portal', 'Department Portal', 'Haryana', NULL, 'https://harchhatravratti.highereduhry.ac.in', 'Centralized Haryana state scholarship portal for SC/BC/EWS college and university students linked with PPP Family ID.', 'Higher Edu Haryana (.ac.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (35, 'DIR-HLT-01', 7, 'Health, Ayushman Bharat & Family Welfare', 'Ayushman Bharat PM-JAY Beneficiary Portal', 'Department Portal', 'All India', NULL, 'https://beneficiary.nha.gov.in', 'Apply online for ₹5 Lakh free cashless hospitalization Ayushman Card, e-KYC for 70+ senior citizens, and card download.', 'National Health Authority (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (36, 'DIR-HLT-02', 7, 'Health, Ayushman Bharat & Family Welfare', 'ABHA Ayushman Bharat Health Account Portal', 'Department Portal', 'All India', NULL, 'https://abha.abdm.gov.in', '14-digit digital Health ID creation for storing medical prescriptions, lab reports, and fast-track hospital OPD tokens.', 'ABDM / NHA (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (37, 'DIR-HLT-03', 7, 'Health, Ayushman Bharat & Family Welfare', 'eSanjeevani National Telemedicine OPD Service', 'Central Service', 'All India', NULL, 'https://esanjeevani.mohfw.gov.in', 'Free online video consultation with government specialist doctors and digital prescription generation from home.', 'MoHFW / C-DAC (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (38, 'DIR-HLT-04', 7, 'Health, Ayushman Bharat & Family Welfare', 'ORS Patient Portal (AIIMS & Govt Hospital Appointments)', 'Central Service', 'All India', NULL, 'https://ors.gov.in', 'Online Registration System for booking OPD appointments at AIIMS New Delhi, PGI Chandigarh, and 500+ government hospitals.', 'NIC / MeitY (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (39, 'DIR-FOOD-01', 8, 'Food, Civil Supplies & Ration Card (NFSA)', 'NFSA National Food Security Ration Card Portal', 'Department Portal', 'All India', NULL, 'https://nfsa.gov.in', 'All-India state-wise Ration Card search, One Nation One Ration Card (ONORC) portability status, and fair price shop locator.', 'DFPD Verified (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (40, 'DIR-FOOD-02', 8, 'Food, Civil Supplies & Ration Card (NFSA)', 'EPDS Haryana Food, Civil Supplies & BPL Ration Card', 'Department Portal', 'Haryana', NULL, 'https://epos.haryanafood.gov.in', 'Download Haryana SBPL / AAY Ration Card by Family ID (PPP), check monthly wheat/mustard oil entitlement, and grievance filing.', 'Haryana Food Dept (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (41, 'DIR-FOOD-03', 8, 'Food, Civil Supplies & Ration Card (NFSA)', 'FCS Uttar Pradesh Food & Civil Supplies Portal', 'Department Portal', 'Uttar Pradesh', NULL, 'https://fcs.up.gov.in', 'Uttar Pradesh Ration Card eligibility list, e-POS transaction verification, and new family member addition.', 'UP Food Dept (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (42, 'DIR-FOOD-04', 8, 'Food, Civil Supplies & Ration Card (NFSA)', 'EPDS Bihar Ration Card & Jan Vitran Ann Portal', 'Department Portal', 'Bihar', NULL, 'https://epds.bihar.gov.in', 'Bihar RCMS online Ration Card application, RC print, and district-wise PHH/AAY beneficiary register.', 'SFC Bihar (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (43, 'DIR-NRG-01', 9, 'New & Renewable Energy & Power', 'PM Surya Ghar Muft Bijli Yojana (Rooftop Solar Portal)', 'Department Portal', 'All India', NULL, 'https://pmsuryaghar.gov.in', 'Official portal for up to ₹78,000 central subsidy on residential rooftop solar panels and 300 units free monthly electricity.', 'MNRE / REC (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (44, 'DIR-NRG-02', 9, 'New & Renewable Energy & Power', 'PM-KUSUM Solar Agricultural Pump Subsidy Portal', 'Department Portal', 'All India', NULL, 'https://pmkusum.mnre.gov.in', 'Central portal for 60%–75% subsidy on standalone solar agricultural water pumps and grid-connected rural solar plants.', 'MNRE Verified (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (45, 'DIR-NRG-03', 9, 'New & Renewable Energy & Power', 'DHBVN & UHBVN Haryana Electricity Consumer Portal', 'Department Portal', 'Haryana', NULL, 'https://dhbvn.org.in', 'Dakshin Haryana Bijli Vitran Nigam portal for new domestic/tubewell electricity connection, bill payment, and solar net-metering.', 'Haryana Power Utilities', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (46, 'DIR-RUR-01', 10, 'Panchayati Raj, Rural Development & Housing', 'Pradhan Mantri Awaas Yojana - Gramin (PMAY-G)', 'Department Portal', 'All India', NULL, 'https://pmayg.nic.in', 'AwaasSoft portal for ₹1.20 Lakh–₹1.30 Lakh rural housing grant list, FTO installment tracking, and AwaasPlus survey.', 'MoRD / NIC (.nic.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (47, 'DIR-RUR-02', 10, 'Panchayati Raj, Rural Development & Housing', 'Pradhan Mantri Awaas Yojana - Urban 2.0 (PMAY-U)', 'Department Portal', 'All India', NULL, 'https://pmaymis.gov.in', 'Urban housing citizen assessment form, ₹2.50 Lakh beneficiary-led construction subsidy, and home loan interest subsidy.', 'MoHUA Verified (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (48, 'DIR-RUR-03', 10, 'Panchayati Raj, Rural Development & Housing', 'MGNREGA National Job Card & Muster Roll Portal', 'Department Portal', 'All India', NULL, 'https://nrega.nic.in', '100-day rural employment guarantee job card download, gram panchayat work list, and wage payment status.', 'MoRD / NIC (.nic.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (49, 'DIR-RUR-04', 10, 'Panchayati Raj, Rural Development & Housing', 'Swachh Bharat Mission Gramin (₹12,000 Toilet Grant)', 'Department Portal', 'All India', NULL, 'https://sbm.gov.in', 'Online IHHL (Individual Household Latrine) application for ₹12,000 rural sanitation incentive under Jal Shakti Ministry.', 'DDWS / Jal Shakti (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (50, 'DIR-RUR-05', 10, 'Panchayati Raj, Rural Development & Housing', 'eGramSwaraj & Meri Panchayat Portal', 'Department Portal', 'All India', NULL, 'https://egramswaraj.gov.in', 'Gram Panchayat development plan (GPDP), village fund expenditure audit, and Svamitva property card tracking.', 'MoPR / NIC (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (51, 'DIR-ID-01', 11, 'Transport, Passport & Citizen Identity', 'UIDAI myAadhaar Official Citizen Portal', 'Central Service', 'All India', NULL, 'https://myaadhaar.uidai.gov.in', 'Download e-Aadhaar PDF, order PVC Aadhaar card, update document proof online, and check Aadhaar-Bank DBT seeding status.', 'UIDAI / MeitY (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (52, 'DIR-ID-02', 11, 'Transport, Passport & Citizen Identity', 'Income Tax e-Filing & Instant Free e-PAN Portal', 'Central Service', 'All India', NULL, 'https://www.incometax.gov.in', 'Instant 10-minute free e-PAN generation using Aadhaar OTP, PAN-Aadhaar linking, and ITR filing portal.', 'CBDT / FinMin (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (53, 'DIR-ID-03', 11, 'Transport, Passport & Citizen Identity', 'Parivahan Sewa (Sarathi Driving License & Vahan RC)', 'Central Service', 'All India', NULL, 'https://parivahan.gov.in', 'Apply online for Learner/Permanent Driving License, Vehicle RC transfer, HSRP plate, and e-Challan settlement.', 'MoRTH / NIC (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (54, 'DIR-ID-04', 11, 'Transport, Passport & Citizen Identity', 'Election Commission Voters Service Portal (NVSP)', 'Central Service', 'All India', NULL, 'https://voters.eci.gov.in', 'Form 6 new Voter ID registration, Form 8 correction, EPIC download, and electoral roll search.', 'ECI Verified (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (55, 'DIR-ID-05', 11, 'Transport, Passport & Citizen Identity', 'Passport Seva Official Portal (MEA)', 'Central Service', 'All India', NULL, 'https://www.passportindia.gov.in', 'Fresh/Re-issue Indian Passport application, Police Clearance Certificate (PCC), and PSK appointment booking.', 'MEA Verified (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (56, 'DIR-ID-06', 11, 'Transport, Passport & Citizen Identity', 'DigiLocker National Document Wallet', 'Central Service', 'All India', NULL, 'https://www.digilocker.gov.in', 'Legally valid digital document wallet under IT Act 2000 for Aadhaar, PAN, Driving License, Class 10/12 marksheets, and ration cards.', 'NeGD / MeitY (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (57, 'DIR-REC-01', 12, 'Recruitment Commissions & Exam Boards', 'UPSC One-Time Registration (OTR) & Exam Portal', 'Department Portal', 'All India', NULL, 'https://upsconline.nic.in', 'Union Public Service Commission official portal for Civil Services (IAS/IPS), NDA, CDS, CAPF, and EPFO recruitments.', 'UPSC / NIC (.nic.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (58, 'DIR-REC-02', 12, 'Recruitment Commissions & Exam Boards', 'Staff Selection Commission (SSC New Portal)', 'Department Portal', 'All India', NULL, 'https://ssc.gov.in', 'Official SSC portal for CGL, CHSL, MTS, GD Constable, and Junior Engineer notifications, admit cards, and results.', 'SSC / DoPT (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (59, 'DIR-REC-03', 12, 'Recruitment Commissions & Exam Boards', 'Railway Recruitment Boards (RRB Online Portal)', 'Department Portal', 'All India', NULL, 'https://www.rrbapply.gov.in', 'Centralized Indian Railways recruitment portal for NTPC, Group D, ALP, Technician, and RPF Constable vacancies.', 'Ministry of Railways (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (60, 'DIR-REC-04', 12, 'Recruitment Commissions & Exam Boards', 'India Post GDS Online Engagement Portal', 'Department Portal', 'All India', NULL, 'https://indiapostgdsonline.gov.in', 'Department of Posts Gramin Dak Sevak (GDS), Branch Postmaster (BPM), and ABPM merit-based recruitment portal.', 'India Post (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (61, 'DIR-REC-05', 12, 'Recruitment Commissions & Exam Boards', 'Haryana Staff Selection Commission (HSSC)', 'Department Portal', 'Haryana', NULL, 'https://hssc.gov.in', 'Official Haryana CET Group C & D recruitment notifications, admit cards, socio-economic marks verification, and final results.', 'HSSC Haryana (.gov.in)', '2026-11-01'); INSERT INTO `department_web_links` (`id`, `portal_code`, `department_id`, `department_name`, `title`, `category`, `state`, `district`, `url`, `portal_description`, `security_badge`, `last_checked`) VALUES (62, 'DIR-REC-06', 12, 'Recruitment Commissions & Exam Boards', 'UPSSSC Uttar Pradesh Subordinate Services Commission', 'Department Portal', 'Uttar Pradesh', NULL, 'https://upsssc.gov.in', 'Uttar Pradesh PET registration, Lekhpal, Junior Assistant, VDO, and state group C recruitment notifications.', 'UPSSSC NIC (.gov.in)', '2026-11-01'); DROP TABLE IF EXISTS `government_schemes`; CREATE TABLE `government_schemes` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `scheme_code` varchar(50) NOT NULL UNIQUE, `slug` varchar(255) NOT NULL UNIQUE, `title` varchar(255) NOT NULL, `title_hi` varchar(255) DEFAULT NULL, `short_description` text NOT NULL, `short_description_hi` text, `detailed_description` longtext NOT NULL, `category` varchar(100) NOT NULL, `subcategory` varchar(150) DEFAULT NULL, `government_type` varchar(100) NOT NULL, `government_name` varchar(150) NOT NULL, `department_name` varchar(255) NOT NULL, `ministry_name` varchar(255) NOT NULL, `applicable_state` varchar(100) NOT NULL DEFAULT 'All India', `applicable_district` varchar(100) NOT NULL DEFAULT 'All Districts', `eligible_beneficiaries` text NOT NULL, `eligibility_criteria` text NOT NULL, `age_limit` varchar(150) DEFAULT NULL, `educational_qualification` varchar(255) DEFAULT NULL, `income_criteria` varchar(255) DEFAULT NULL, `required_documents` json NOT NULL, `financial_benefits` text NOT NULL, `application_fees` varchar(255) DEFAULT 'Free (₹0)', `registration_process` varchar(100) DEFAULT 'Online & CSC Center', `step_by_step_procedure` json DEFAULT NULL, `application_start_date` date NOT NULL, `application_end_date` date NOT NULL, `auto_delete_after_date` date GENERATED ALWAYS AS (DATE_ADD(`application_end_date`, INTERVAL 30 DAY)) STORED, `official_department_website` varchar(500) NOT NULL, `official_notification_url` varchar(500) DEFAULT NULL, `direct_registration_url` varchar(500) DEFAULT NULL, `helpdesk_details` varchar(255) DEFAULT NULL, `faqs` json DEFAULT NULL, `status` varchar(50) NOT NULL DEFAULT 'Published', `is_featured` tinyint(1) NOT NULL DEFAULT 0, `is_urgent` tinyint(1) NOT NULL DEFAULT 0, `total_vacancies` int DEFAULT NULL, `post_name` varchar(255) DEFAULT NULL, `pay_scale` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_category` (`category`), KEY `idx_state` (`applicable_state`), KEY `idx_end_date` (`application_end_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; INSERT INTO `government_schemes` (`id`, `scheme_code`, `slug`, `title`, `title_hi`, `short_description`, `short_description_hi`, `detailed_description`, `category`, `subcategory`, `government_type`, `government_name`, `department_name`, `ministry_name`, `applicable_state`, `applicable_district`, `eligible_beneficiaries`, `eligibility_criteria`, `age_limit`, `educational_qualification`, `income_criteria`, `required_documents`, `financial_benefits`, `application_fees`, `registration_process`, `step_by_step_procedure`, `application_start_date`, `application_end_date`, `official_department_website`, `official_notification_url`, `direct_registration_url`, `helpdesk_details`, `faqs`, `status`, `is_featured`, `is_urgent`, `total_vacancies`, `post_name`, `pay_scale`) VALUES (1, 'GOV-SCH-001', 'gov-sch-001-pm-surya-ghar-muft-bijli-yojana-rooftop-solar-subsidy-up-to-', 'PM Surya Ghar: Muft Bijli Yojana (Rooftop Solar Subsidy up to ₹78,000)', NULL, 'Get up to ₹78,000 direct subsidy for installing rooftop solar panels with free electricity up to 300 units per month.', NULL, 'The Prime Minister launched PM Surya Ghar Muft Bijli Yojana to provide 1 crore Indian households with 300 units of free power monthly. Beneficiaries receive direct DBT subsidy transferred into their bank accounts within 30 days of rooftop solar installation through national portal registered vendors.', 'Government Schemes', 'Subsidies & Energy Welfare', 'Central Government', 'Government of India', 'Department of New & Renewable Energy', 'Ministry of New & Renewable Energy (MNRE)', 'All India', 'All Districts', 'Indian resident households with suitable rooftop space and active domestic electricity connection.', 'Applicant must be an Indian citizen, own a concrete/suitable roof or terrace, possess an active domestic electricity connection in their name, and not have availed solar subsidy previously for the same DISCOM consumer number.', 'Minimum 18 years', 'No minimum qualification required', 'Open to all income segments; priority subsidy for low and middle-income families.', '["Aadhaar Card of the applicant","Recent Domestic Electricity Bill (Consumer ID)","Roof Ownership Proof / House Tax Receipt","Bank Account Passbook or Cancelled Cheque (DBT Linked)","Passport Size Photograph"]', 'Direct subsidy: ₹33,000 for 1 kW system; ₹66,000 for 2 kW system; ₹78,000 for 3 kW or higher systems. Low-interest collateral-free bank loans available at 7% p.a.', '₹0 (Free government registration)', 'Online', '["Step 1: Visit the official National Solar Portal (pmsuryaghar.gov.in).","Step 2: Register with your State, Electricity Distribution Company (DISCOM), and Consumer Account Number.","Step 3: Enter your mobile number, verify OTP, and submit your application for technical feasibility approval.","Step 4: After DISCOM feasibility approval, select any registered vendor in your district to install the solar plant.","Step 5: Vendor installs plant; DISCOM inspects installation and fixes net-meter.","Step 6: Submit commissioning certificate and bank account details on portal. DBT subsidy is credited within 30 days."]', '2026-01-01', '2026-12-31', 'https://mnre.gov.in', 'https://pmsuryaghar.gov.in', 'https://pmsuryaghar.gov.in/consumerRegistration', 'National Solar Portal Helpdesk, CGO Complex, Lodhi Road, New Delhi - 110003. Email: pmsuryaghar-support@gov.in', '[{"question":"What is the maximum subsidy under this scheme?","answer":"The maximum subsidy is ₹78,000 for residential rooftop solar systems of 3 kW capacity or higher."},{"question":"Do tenants qualify?","answer":"No, only house owners with roof rights and electricity connection in their name are eligible."},{"question":"How is the subsidy paid?","answer":"Subsidy is directly credited via Direct Benefit Transfer (DBT) into your Aadhaar-seeded bank account."}]', 'Published', 1, 1, NULL, NULL, NULL); INSERT INTO `government_schemes` (`id`, `scheme_code`, `slug`, `title`, `title_hi`, `short_description`, `short_description_hi`, `detailed_description`, `category`, `subcategory`, `government_type`, `government_name`, `department_name`, `ministry_name`, `applicable_state`, `applicable_district`, `eligible_beneficiaries`, `eligibility_criteria`, `age_limit`, `educational_qualification`, `income_criteria`, `required_documents`, `financial_benefits`, `application_fees`, `registration_process`, `step_by_step_procedure`, `application_start_date`, `application_end_date`, `official_department_website`, `official_notification_url`, `direct_registration_url`, `helpdesk_details`, `faqs`, `status`, `is_featured`, `is_urgent`, `total_vacancies`, `post_name`, `pay_scale`) VALUES (2, 'GOV-SCH-002', 'gov-sch-002-pm-kisan-samman-nidhi-19th-installment-6-000-year-for-farmer', 'PM-KISAN Samman Nidhi (19th Installment ₹6,000/year for Farmers)', NULL, 'Income support of ₹6,000 per year in three equal 4-monthly installments of ₹2,000 directly to landholding farmers.', NULL, 'Pradhan Mantri Kisan Samman Nidhi (PM-KISAN) is a central sector scheme providing income support to all landholding farmers families in the country to supplement their financial needs for procuring various inputs related to agriculture and domestic requirements.', 'Government Schemes', 'Farmer Welfare & Direct Benefit Transfer', 'Central Government', 'Government of India', 'Department of Agriculture & Farmers Welfare', 'Ministry of Agriculture & Farmers Welfare', 'All India', 'All Districts', 'Small, marginal and landholder farming families across India with cultivable agricultural land.', 'All farmer families holding cultivable land in their names. Excludes institutional landholders, farmer families holding constitutional posts, serving or retired govt employees, and income tax payees.', '18 to 75 years', 'No formal educational requirement', 'Non-income tax payer farmer families.', '["Aadhaar Card (Mandatory biometric/OTP verification)","Land Ownership Record (Khata/Khasra/ROR / Jamabandi)","Aadhaar-Seeded Bank Passbook","Mobile Number linked with Aadhaar"]', '₹6,000 annually paid in 3 equal quarterly installments of ₹2,000 directly into bank accounts via PFMS/DBT.', '₹0 (Free on pmkisan.gov.in, nominal CSC charge of ₹15 for biometric e-KYC)', 'Online & CSC Center', '["Step 1: Visit pmkisan.gov.in and click on Farmers Corner > New Farmer Registration.","Step 2: Enter Aadhaar Number, Select State, enter Captcha and mobile OTP.","Step 3: Enter land details including Khata, Khasra, Survey number and upload land record document.","Step 4: Complete e-KYC through face authentication on PM-KISAN mobile app or fingerprint at nearest CSC.","Step 5: District agriculture officer verifies land record and approves benefits."]', '2026-01-01', '2026-12-31', 'https://agricoop.nic.in', 'https://pmkisan.gov.in', 'https://pmkisan.gov.in/RegistrationFormNew.aspx', 'Agriculture Bhavan, New Delhi. Email: pmkisan-ict@gov.in', '[{"question":"Is e-KYC compulsory for receiving the next installment?","answer":"Yes, OTP-based or Biometric e-KYC is mandatory for all beneficiaries."},{"question":"Can two brothers sharing ancestral land apply separately?","answer":"Yes, if both have their separate land records entered in the state revenue records."}]', 'Published', 1, 0, NULL, NULL, NULL); INSERT INTO `government_schemes` (`id`, `scheme_code`, `slug`, `title`, `title_hi`, `short_description`, `short_description_hi`, `detailed_description`, `category`, `subcategory`, `government_type`, `government_name`, `department_name`, `ministry_name`, `applicable_state`, `applicable_district`, `eligible_beneficiaries`, `eligibility_criteria`, `age_limit`, `educational_qualification`, `income_criteria`, `required_documents`, `financial_benefits`, `application_fees`, `registration_process`, `step_by_step_procedure`, `application_start_date`, `application_end_date`, `official_department_website`, `official_notification_url`, `direct_registration_url`, `helpdesk_details`, `faqs`, `status`, `is_featured`, `is_urgent`, `total_vacancies`, `post_name`, `pay_scale`) VALUES (3, 'GOV-BIZ-001', 'gov-biz-001-pmegp-scheme-up-to-35-government-subsidy-on-business-loans-u', 'PMEGP Scheme: Up to 35% Government Subsidy on Business Loans up to ₹50 Lakh', NULL, 'Credit-linked subsidy programme to generate self-employment ventures in manufacturing (up to ₹50L) and service sectors (up to ₹20L).', NULL, 'Prime Minister Employment Generation Programme (PMEGP) is a flagship credit-linked subsidy programme administered by Khadi and Village Industries Commission (KVIC) under the Ministry of MSME. It assists traditional artisans, rural youth, and new entrepreneurs in setting up micro-enterprises.', 'Business & Entrepreneurship', 'Government Business Loans & Subsidies', 'Central Government', 'Government of India', 'Khadi & Village Industries Commission (KVIC)', 'Ministry of Micro, Small and Medium Enterprises (MSME)', 'All India', 'All Districts', 'Individual entrepreneurs, self-help groups, cooperative societies, and registered charitable trusts.', 'Any individual above 18 years of age. At least 8th standard pass for manufacturing units above ₹10 Lakh and service units above ₹5 Lakh. No income ceiling.', 'Minimum 18 years, no upper age limit', '8th class pass for projects > ₹10 Lakh (Manufacturing) or > ₹5 Lakh (Service)', 'No family income limit', '["Aadhaar Card and PAN Card","Detailed Project Report (DPR) / Business Plan","Educational Qualification Certificate (8th / 10th / Degree)","Special Category Certificate (SC/ST/OBC/Women/Ex-Servicemen/Minority) for higher 35% subsidy","Rural Area Certificate from Gram Panchayat (for rural subsidy rate)","Entrepreneurship Development Programme (EDP) Certificate (or undergo online after approval)"]', 'Subsidy rate: Rural Areas: 35% for Special Categories, 25% for General. Urban Areas: 25% for Special Categories, 15% for General. Maximum project cost: ₹50 Lakh (Manufacturing) and ₹20 Lakh (Service).', '₹0 (Free online portal)', 'Online', '["Step 1: Visit kviconline.gov.in/pmegpeportal and click \\"Application for New Unit\\".","Step 2: Fill in personal details, Aadhaar number, sponsoring agency (KVIC/KVIB/DIC), and bank preference.","Step 3: Prepare and upload Detailed Project Report (DPR) detailing machinery, working capital, and sales projection.","Step 4: Sponsoring agency scrutinizes project and forwards to chosen bank within 30 days.","Step 5: Bank sanctions loan, releases first capital disbursement, and claims subsidy from nodal bank into margin money account.","Step 6: Complete mandatory online EDP training through portal."]', '2026-01-01', '2026-12-31', 'https://msme.gov.in', 'https://kviconline.gov.in/pmegpeportal', 'https://kviconline.gov.in/pmegpeportal/pmegphome/index.jsp', 'KVIC Head Office, Gramodaya, 3, Irla Road, Vile Parle (West), Mumbai - 400056', '[{"question":"What is the maximum project cost allowed?","answer":"₹50 Lakh for manufacturing projects and ₹20 Lakh for service/business projects."},{"question":"What is margin money?","answer":"Margin money is the government subsidy held in a term deposit for 3 years, after which it adjusts against your loan balance."},{"question":"Are women eligible for 35% subsidy?","answer":"Yes, women are classified under the special category and receive 35% subsidy in rural areas and 25% in urban areas."}]', 'Published', 1, 0, NULL, NULL, NULL); INSERT INTO `government_schemes` (`id`, `scheme_code`, `slug`, `title`, `title_hi`, `short_description`, `short_description_hi`, `detailed_description`, `category`, `subcategory`, `government_type`, `government_name`, `department_name`, `ministry_name`, `applicable_state`, `applicable_district`, `eligible_beneficiaries`, `eligibility_criteria`, `age_limit`, `educational_qualification`, `income_criteria`, `required_documents`, `financial_benefits`, `application_fees`, `registration_process`, `step_by_step_procedure`, `application_start_date`, `application_end_date`, `official_department_website`, `official_notification_url`, `direct_registration_url`, `helpdesk_details`, `faqs`, `status`, `is_featured`, `is_urgent`, `total_vacancies`, `post_name`, `pay_scale`) VALUES (4, 'GOV-JOB-001', 'gov-job-001-upsc-civil-services-examination-2026-1-056-vacancies-for-ias', 'UPSC Civil Services Examination 2026: 1,056 Vacancies for IAS, IPS, IFS & Central Group A Services', NULL, 'Union Public Service Commission recruitment notification for Indian Administrative Service, Indian Police Service, and Allied Services.', NULL, 'The Union Public Service Commission (UPSC) conducts the Civil Services Examination (CSE) annually for recruitment to the prestigious Indian Administrative Service (IAS), Indian Foreign Service (IFS), Indian Police Service (IPS), and various Central Group A & B services.', 'Government Recruitment', 'All India Central Services', 'Central Government', 'Union Public Service Commission (UPSC)', 'Department of Personnel and Training (DoPT)', 'Ministry of Personnel, Public Grievances and Pensions', 'All India', 'All Districts', 'Indian citizens holding a bachelor degree from any recognized university.', 'Candidate must hold a Graduate Degree in any discipline from a recognized University. Final year students appearing in qualifying exams are also eligible to apply for Prelims.', '21 to 32 years as on 1st August 2026 (Age relaxation: 3 years for OBC, 5 years for SC/ST, 10 years for PwBD).', 'Graduation Degree in any stream from a recognized university.', 'As per DoPT reservation rules (Non-Creamy Layer for OBC; family income < ₹8 Lakh for EWS).', '["Photo ID Proof (Aadhaar Card / Voter ID / Passport / Driving Licence)","Graduation Degree / Final Year Marksheet","Caste / Community Certificate (OBC-NCL / SC / ST / EWS) if claiming reservation","Scanned Photograph and Signature as per UPSC specs","Disability Certificate (if applicable)"]', 'Level 10 in Pay Matrix (7th CPC): Starting Basic Pay ₹56,100 to ₹1,77,500 + DA, HRA, Transport Allowance, Official Accommodation, and Medical Benefits.', '₹100 (Exempted for Female / SC / ST / PwBD candidates)', 'Online', '["Step 1: Visit upsconline.nic.in and register on One Time Registration (OTR) portal.","Step 2: Log in with OTR ID and mobile OTP; click on \\"Civil Services (Preliminary) Examination\\".","Step 3: Complete Part-I application (personal details, address, educational qualification, service preferences).","Step 4: Pay ₹100 application fee via UPI, Net Banking, or Debit Card (or select fee exemption if eligible).","Step 5: Select Examination Center for Prelims and upload photo and signature.","Step 6: Print application form and note registration number."]', '2026-02-10', '2026-03-05', 'https://upsc.gov.in', 'https://upsconline.nic.in', 'https://upsconline.nic.in/upsc/OTRP/index.php', 'Dholpur House, Shahjahan Road, New Delhi - 110069', '[{"question":"How many attempts are allowed for General category candidates?","answer":"General category candidates are permitted 6 attempts up to age 32."},{"question":"What is the examination pattern?","answer":"Three stages: Preliminary Exam (Objective GS-I & CSAT), Main Exam (Written 9 Papers), and Personality Test (Interview)."}]', 'Published', 1, 0, 1056, 'Indian Administrative Service, Indian Police Service, Central Services Group A', 'Level 10 (₹56,100 - ₹1,77,500) + Central allowances'); INSERT INTO `government_schemes` (`id`, `scheme_code`, `slug`, `title`, `title_hi`, `short_description`, `short_description_hi`, `detailed_description`, `category`, `subcategory`, `government_type`, `government_name`, `department_name`, `ministry_name`, `applicable_state`, `applicable_district`, `eligible_beneficiaries`, `eligibility_criteria`, `age_limit`, `educational_qualification`, `income_criteria`, `required_documents`, `financial_benefits`, `application_fees`, `registration_process`, `step_by_step_procedure`, `application_start_date`, `application_end_date`, `official_department_website`, `official_notification_url`, `direct_registration_url`, `helpdesk_details`, `faqs`, `status`, `is_featured`, `is_urgent`, `total_vacancies`, `post_name`, `pay_scale`) VALUES (5, 'GOV-JOB-002', 'gov-job-002-ssc-cgl-2026-recruitment-14-800-group-b-c-officer-vacancies', 'SSC CGL 2026 Recruitment: 14,800 Group B & C Officer Vacancies', NULL, 'Staff Selection Commission notification for Assistant Section Officer, Income Tax Inspector, GST Inspector, and Auditor posts.', NULL, 'The Staff Selection Commission (SSC) conducts the Combined Graduate Level Examination (CGL) 2026 for filling up approximately 14,800 Group B and C posts across various Ministries, Departments, and Organizations of the Government of India.', 'Government Recruitment', 'Central Staff Recruitment', 'Central Government', 'Staff Selection Commission (SSC)', 'Staff Selection Commission', 'Ministry of Personnel, Public Grievances & Pensions', 'All India', 'All Districts', 'Graduates in any discipline from recognized universities.', 'Bachelor Degree from a recognized University or Institute. Age criteria vary by post (18-27 years for Auditors/Tax Assistants, 18-30 or 20-30 for Inspectors/ASO).', '18 to 32 years (depending on post)', 'Graduation Degree in any stream (Mathematics/Statistics preferred for JSO post).', 'As per central reservation guidelines.', '["Aadhaar Card / Photo ID","Class 10th and 12th Certificates","Graduation Degree or Provisional Certificate","Caste / EWS Certificate (Central Govt format)","Live Web-Camera Photo & Signature as per SSC Portal guidelines"]', 'Pay Level 4 (₹25,500 - ₹81,100) to Pay Level 8 (₹47,600 - ₹1,51,100) + DA, HRA, Transport Allowance, CGHS health benefits.', '₹100 (Exempted for Women, SC, ST, PwBD, Ex-Servicemen)', 'Online', '["Step 1: Visit the new official SSC portal (ssc.gov.in) and complete One-Time Registration (OTR).","Step 2: Log in using OTR Registration Number and Password.","Step 3: Click \\"Apply\\" under Combined Graduate Level Examination 2026.","Step 4: Verify pre-filled educational data and select preferred examination cities (3 centers within same region).","Step 5: Capture live webcam photograph using the SSC mobile app or desktop camera, ensuring plain background.","Step 6: Pay ₹100 application fee online and download submitted form."]', '2026-10-01', '2026-11-25', 'https://ssc.gov.in', 'https://ssc.gov.in/notices', 'https://ssc.gov.in/login', 'Block No-12, CGO Complex, Lodhi Road, New Delhi-110003', '[{"question":"Is live webcam photo capture compulsory on new SSC portal?","answer":"Yes, SSC now requires live facial capture to eliminate impersonation."},{"question":"What is Tier-I examination format?","answer":"Computer Based Test (CBT) with 100 questions (200 marks) in 60 minutes covering Reasoning, GA, Quant, and English."}]', 'Published', 1, 0, 14800, 'Assistant Section Officer, Inspector (Central Excise/IT), Sub-Inspector, Auditor', 'Level 4 to Level 8 (₹25,500 to ₹1,51,100)'); INSERT INTO `government_schemes` (`id`, `scheme_code`, `slug`, `title`, `title_hi`, `short_description`, `short_description_hi`, `detailed_description`, `category`, `subcategory`, `government_type`, `government_name`, `department_name`, `ministry_name`, `applicable_state`, `applicable_district`, `eligible_beneficiaries`, `eligibility_criteria`, `age_limit`, `educational_qualification`, `income_criteria`, `required_documents`, `financial_benefits`, `application_fees`, `registration_process`, `step_by_step_procedure`, `application_start_date`, `application_end_date`, `official_department_website`, `official_notification_url`, `direct_registration_url`, `helpdesk_details`, `faqs`, `status`, `is_featured`, `is_urgent`, `total_vacancies`, `post_name`, `pay_scale`) VALUES (6, 'GOV-JOB-003', 'gov-job-003-rrb-technician-grade-i-iii-recruitment-2026-14-298-railway-v', 'RRB Technician Grade-I & III Recruitment 2026: 14,298 Railway Vacancies', NULL, 'Railway Recruitment Boards centralized notification for Signal Technicians and Mechanical/Electrical Technician posts.', NULL, 'The Railway Recruitment Boards (RRB) Centralized Employment Notice (CEN 02/2026) for recruitment of 14,298 Technicians across Indian Railways. Application window closed on 19 October 2026. This notice is retained in archival grace period for candidate exam schedule and answer key verification. It will automatically self-delete from the portal in 18 days.', 'Government Recruitment', 'Railway Central Recruitment', 'Central Government', 'Ministry of Railways (Railway Board)', 'Railway Recruitment Boards (RRB)', 'Ministry of Railways', 'All India', 'All Railway Zones & Divisions', 'Matriculation with ITI / Act Apprenticeship in relevant trades, or Diploma/B.Sc/B.Tech in relevant engineering discipline.', 'Technician Gr I Signal: Bachelor Degree in Science (Physics/Electronics) or Diploma/Degree in Engineering. Technician Gr III: 10th pass plus ITI in relevant trade.', '18 to 36 years as on 01.07.2026', '10th + ITI / Diploma / Degree in Engineering', 'As per central reservation rules.', '["Aadhaar Card (Mandatory biometric verification)","10th Matriculation Certificate for Date of Birth proof","NCVT / SCVT ITI Trade Certificate","OBC-NCL / SC / ST / EWS Certificate","Recent Passport Photograph with white background"]', 'Level 2 (₹19,900) to Level 5 (₹29,200) + Railway perks, Free Medical in Railway Hospitals, Passes and PTOs.', '₹500 (₹400 refundable after appearing in CBT-1)', 'Online', '["Step 1: Application window is now closed. Visit official RRB regional portals to check application acceptance status.","Step 2: Scrutiny of applications and photograph validation under process.","Step 3: CBT-1 examination city intimation slip will be released 10 days before exam.","Step 4: Download official e-call letter 4 days prior to CBT date."]', '2026-09-10', '2026-10-19', 'https://indianrailways.gov.in', 'https://rrbcdg.gov.in', 'https://www.rrbapply.gov.in', 'Railway Recruitment Board Facilitation Desk, New Delhi', '[{"question":"Is the application window still open?","answer":"No, registration closed on 19 October 2026. This record will auto-delete from the portal in 18 days."},{"question":"When will CBT-1 admit cards be released?","answer":"Admit cards will be available 4 days before the exam in December 2026 on your regional RRB website."}]', 'Published', 0, 0, 14298, 'Technician Grade-I Signal & Technician Grade-III', 'Level 2 & Level 5 (₹19,900 to ₹92,300)'); INSERT INTO `government_schemes` (`id`, `scheme_code`, `slug`, `title`, `title_hi`, `short_description`, `short_description_hi`, `detailed_description`, `category`, `subcategory`, `government_type`, `government_name`, `department_name`, `ministry_name`, `applicable_state`, `applicable_district`, `eligible_beneficiaries`, `eligibility_criteria`, `age_limit`, `educational_qualification`, `income_criteria`, `required_documents`, `financial_benefits`, `application_fees`, `registration_process`, `step_by_step_procedure`, `application_start_date`, `application_end_date`, `official_department_website`, `official_notification_url`, `direct_registration_url`, `helpdesk_details`, `faqs`, `status`, `is_featured`, `is_urgent`, `total_vacancies`, `post_name`, `pay_scale`) VALUES (7, 'GOV-JOB-004', 'gov-job-004-state-van-rakshak-forest-guard-recruitment-2026-2-140-vacanc', 'State Van Rakshak (Forest Guard) Recruitment 2026: 2,140 Vacancies', NULL, 'State Forest & Climate Change Department recruitment for Van Rakshak (Forest Guard) and Field Watcher posts.', NULL, 'Recruitment notice for 2,140 Van Rakshak posts across territorial divisions. Online applications closed on 07 October 2026. In accordance with portal 30-day retention rules, this closed notice will be permanently deleted from the information desk in 6 days.', 'Government Recruitment', 'State Police & Forest Services', 'State Government', 'State Forest Department', 'Department of Forest & Climate Change', 'Ministry of Environment & Forests', 'Rajasthan', 'All Forest Divisions', '10th / 12th pass residents meeting prescribed physical fitness standards.', '10th class pass from recognized board. Physical standards: Male height 163 cm, 25 km walk in 4 hours; Female height 150 cm, 16 km walk in 4 hours.', '18 to 28 years', '10th Class (Matriculation) Pass', 'As per state reservation policy.', '["Aadhaar Card","10th Class Marksheet","Domicile / Bonafide Resident Certificate","Medical Fitness Certificate"]', 'Pay Scale Pay Matrix Level 4 (Starting Basic ₹20,800 + Special Forest Allowance, Uniform Allowance).', '₹450 (General), ₹250 (Reserved)', 'Online', '["Step 1: Registration closed on 07 October 2026.","Step 2: Physical Efficiency Test (PET) schedule announced for late November 2026.","Step 3: Download PET admit card using application number on state portal."]', '2026-09-01', '2026-10-07', 'https://forest.gov.in', 'https://forest.gov.in', 'https://forest.gov.in/recruitment', 'Aranya Bhawan, Central Forest Office', '[{"question":"When will this notice be removed?","answer":"This notice closed on 07 Oct 2026 and will automatically self-delete from the portal in 6 days."},{"question":"What is the physical endurance test?","answer":"Male candidates must walk 25 km within 4 hours carrying 10 kg weight."}]', 'Published', 0, 0, 2140, 'Van Rakshak (Forest Guard)', 'Level 4 (₹20,800 - ₹65,900)'); INSERT INTO `government_schemes` (`id`, `scheme_code`, `slug`, `title`, `title_hi`, `short_description`, `short_description_hi`, `detailed_description`, `category`, `subcategory`, `government_type`, `government_name`, `department_name`, `ministry_name`, `applicable_state`, `applicable_district`, `eligible_beneficiaries`, `eligibility_criteria`, `age_limit`, `educational_qualification`, `income_criteria`, `required_documents`, `financial_benefits`, `application_fees`, `registration_process`, `step_by_step_procedure`, `application_start_date`, `application_end_date`, `official_department_website`, `official_notification_url`, `direct_registration_url`, `helpdesk_details`, `faqs`, `status`, `is_featured`, `is_urgent`, `total_vacancies`, `post_name`, `pay_scale`) VALUES (8, 'GOV-SCH-003', 'gov-sch-003-pmay-urban-2-0-2-50-lakh-government-assistance-for-pucca-hou', 'PMAY-Urban 2.0: ₹2.50 Lakh Government Assistance for Pucca Houses', NULL, 'Financial assistance of ₹2.5 Lakh for Economically Weaker Sections (EWS), Low Income Groups (LIG), and Middle Income Groups (MIG) for constructing or buying a house.', NULL, 'Pradhan Mantri Awas Yojana - Urban 2.0 (PMAY-U 2.0) provides central interest subsidy and direct construction assistance to 1 crore urban poor and middle-class families to ensure every Indian citizen has access to a secure, permanent pucca house with sanitation, water, and electricity.', 'Government Schemes', 'Housing & Urban Development', 'Central Government', 'Government of India', 'Housing for All Mission Directorate', 'Ministry of Housing and Urban Affairs (MoHUA)', 'All India', 'All Urban Local Bodies & Municipalities', 'EWS (Income up to ₹3L), LIG (Income ₹3L to ₹6L), and MIG families living in notified statutory towns.', 'The beneficiary family must not own a pucca house anywhere in India. Female ownership or co-ownership of the house is mandatory for EWS/LIG categories.', 'Minimum 18 years', 'None', 'EWS (Up to ₹3 Lakh p.a.), LIG (₹3 to ₹6 Lakh p.a.), MIG (₹6 to ₹9 Lakh p.a.).', '["Aadhaar Card of all family members","Income Certificate / ITR / Form 16","Bank Account Details (Aadhaar linked)","Land / Plot Ownership document (for Beneficiary-led construction)","Affidavit stating non-ownership of any pucca house in India"]', 'Direct subsidy: ₹2.50 Lakh released in milestone-based tranches (Foundation, Lintel, Roof, Finishing) or Interest Subsidy on home loans up to ₹35 Lakh.', '₹0 (Free on pmaymis.gov.in / ₹25 at CSC Centers)', 'Online & CSC Center', '["Step 1: Go to pmaymis.gov.in or visit your local Municipal Corporation / CSC Center.","Step 2: Enter Aadhaar number and perform biometric or OTP verification.","Step 3: Select vertical: Beneficiary-Led Construction (BLC) or Interest Subsidy Scheme (ISS).","Step 4: Enter household details, present address, income certificate number, and bank account.","Step 5: Municipal engineer conducts Geo-tagging of the plot/house site before tranche disbursement."]', '2026-01-01', '2026-12-31', 'https://mohua.gov.in', 'https://pmaymis.gov.in', 'https://pmaymis.gov.in/Open/Check_Aadhar_Existence.aspx', 'MoHUA, Nirman Bhawan, New Delhi - 110011. Email: pmay-housing@gov.in', '[{"question":"Is female ownership required?","answer":"Yes, the house must be registered in the name of the female head of the family or in joint name with her husband."},{"question":"How is money disbursed?","answer":"Directly into the beneficiary bank account via DBT based on geo-tagged construction stages."}]', 'Published', 1, 0, NULL, NULL, NULL); INSERT INTO `government_schemes` (`id`, `scheme_code`, `slug`, `title`, `title_hi`, `short_description`, `short_description_hi`, `detailed_description`, `category`, `subcategory`, `government_type`, `government_name`, `department_name`, `ministry_name`, `applicable_state`, `applicable_district`, `eligible_beneficiaries`, `eligibility_criteria`, `age_limit`, `educational_qualification`, `income_criteria`, `required_documents`, `financial_benefits`, `application_fees`, `registration_process`, `step_by_step_procedure`, `application_start_date`, `application_end_date`, `official_department_website`, `official_notification_url`, `direct_registration_url`, `helpdesk_details`, `faqs`, `status`, `is_featured`, `is_urgent`, `total_vacancies`, `post_name`, `pay_scale`) VALUES (9, 'GOV-SCH-004', 'gov-sch-004-mukhyamantri-ladli-behna-yojana-1-250-month-direct-financial', 'Mukhyamantri Ladli Behna Yojana: ₹1,250/Month Direct Financial Aid for Women in MP', NULL, 'Madhya Pradesh state welfare scheme providing ₹1,250 every month directly to eligible resident women for nutrition, health, and economic independence.', NULL, 'Government of Madhya Pradesh provides monthly financial assistance of ₹1,250 (expanding towards ₹3,000 in phases) to married women in MP between 21 to 60 years belonging to economically weaker households, transferred directly on the 10th of every month.', 'Government Schemes', 'Women Empowerment & State Welfare', 'State Government', 'Government of Madhya Pradesh', 'Women & Child Development Department', 'Ministry of Women and Child Development, MP', 'Madhya Pradesh', 'All 55 Districts of Madhya Pradesh', 'Married, widowed, divorced, or abandoned women resident of Madhya Pradesh.', 'Resident of Madhya Pradesh, age between 21 and 60 years. Family annual income less than ₹2.5 Lakh. Family must not own more than 5 acres of agricultural land or four-wheeler vehicle.', '21 to 60 years', 'None', 'Annual family income must be less than ₹2.50 Lakh.', '["Samagra Family ID and Individual Member ID","Aadhaar Card","Aadhaar-linked DBT enabled Bank Account","Active Mobile Number"]', '₹1,250 per month credited directly to the woman bank account on the 10th of every month.', '₹0 (Free camp and online registration)', 'Online & CSC Center', '["Step 1: Check your Samagra e-KYC status at samagra.gov.in.","Step 2: Visit Gram Panchayat or Ward Office camp with Samagra ID and Aadhaar.","Step 3: Portal executive fills online form and captures live photo.","Step 4: Receive SMS acknowledgment with application number.","Step 5: Track payment status on cmladlibahna.mp.gov.in on the 10th of each month."]', '2026-01-01', '2026-12-31', 'https://cmladlibahna.mp.gov.in', 'https://cmladlibahna.mp.gov.in', 'https://cmladlibahna.mp.gov.in/ApplicationStatus.aspx', 'Directorate of Women & Child Development, MP, Bhopal - 462003', '[{"question":"What is Samagra e-KYC?","answer":"Matching your Aadhaar biometric details with your MP Samagra Portal family record."},{"question":"On which date is the money transferred?","answer":"The government transfers the amount on the 10th of every calendar month."}]', 'Published', 0, 0, NULL, NULL, NULL); INSERT INTO `government_schemes` (`id`, `scheme_code`, `slug`, `title`, `title_hi`, `short_description`, `short_description_hi`, `detailed_description`, `category`, `subcategory`, `government_type`, `government_name`, `department_name`, `ministry_name`, `applicable_state`, `applicable_district`, `eligible_beneficiaries`, `eligibility_criteria`, `age_limit`, `educational_qualification`, `income_criteria`, `required_documents`, `financial_benefits`, `application_fees`, `registration_process`, `step_by_step_procedure`, `application_start_date`, `application_end_date`, `official_department_website`, `official_notification_url`, `direct_registration_url`, `helpdesk_details`, `faqs`, `status`, `is_featured`, `is_urgent`, `total_vacancies`, `post_name`, `pay_scale`) VALUES (10, 'GOV-BIZ-002', 'gov-biz-002-pm-mudra-yojana-collateral-free-loans-up-to-20-lakh-for-smal', 'PM MUDRA Yojana: Collateral-Free Loans up to ₹20 Lakh for Small Businesses', NULL, 'Collateral-free institutional credit up to ₹20 Lakh under Shishu, Kishor, and Tarun categories for micro and small business units.', NULL, 'Pradhan Mantri MUDRA Yojana (PMMY) provides loans up to ₹20 Lakh to non-corporate, non-farm small/micro enterprises. Extended through Commercial Banks, RRBs, Small Finance Banks, MFIs and NBFCs without requiring any collateral security.', 'Business & Entrepreneurship', 'Business Credit & Financial Inclusion', 'Central Government', 'Government of India', 'Department of Financial Services (DFS)', 'Ministry of Finance', 'All India', 'All Districts', 'Small manufacturers, artisans, shopkeepers, fruit/vegetable vendors, transport operators, and service units.', 'Any Indian citizen who has a business plan for a non-farm sector income-generating activity such as manufacturing, processing, trading, or service sector.', 'Minimum 18 years', 'None', 'No specific income restriction; viable business cashflow required.', '["Identity Proof (Aadhaar / Voter ID / Passport / Driving Licence)","Proof of Residence","Proof of Business Entity (Udyam Registration / GST / Trade License)","Bank Account Statement for last 6 months","Quotation of machinery / items to be purchased"]', 'Three categories: Shishu (up to ₹50,000), Kishor (₹50,001 to ₹5 Lakh), Tarun (₹5 Lakh to ₹20 Lakh). No collateral security required. Covered under CGFMU guarantee.', '₹0 (Nil for loans up to ₹50,000)', 'Online & CSC Center', '["Step 1: Visit udyamimitra.in portal.","Step 2: Click on \\"Apply for MUDRA Loan\\" and select loan category (Shishu, Kishor, Tarun).","Step 3: Enter applicant details, proposed business activity, and machinery cost.","Step 4: Select preferred lending bank or branch.","Step 5: Portal forwards application directly to bank branch manager for appraisal and loan sanction within 7-15 days."]', '2026-01-01', '2026-12-31', 'https://mudra.org.in', 'https://www.udyamimitra.in', 'https://www.udyamimitra.in/Login/Register', 'MUDRA Ltd., MSME Development Centre, C-11, G-Block, BKC, Bandra (E), Mumbai - 400051', '[{"question":"Is collateral or third party guarantee needed?","answer":"No, loans under MUDRA scheme are 100% collateral-free, backed by Credit Guarantee Fund for Micro Units."},{"question":"What is the enhanced Tarun limit in 2026?","answer":"The ceiling for Tarun category loans has been enhanced up to ₹20 Lakh for entrepreneurs who have previously successfully repaid a Tarun loan."}]', 'Published', 1, 0, NULL, NULL, NULL); INSERT INTO `government_schemes` (`id`, `scheme_code`, `slug`, `title`, `title_hi`, `short_description`, `short_description_hi`, `detailed_description`, `category`, `subcategory`, `government_type`, `government_name`, `department_name`, `ministry_name`, `applicable_state`, `applicable_district`, `eligible_beneficiaries`, `eligibility_criteria`, `age_limit`, `educational_qualification`, `income_criteria`, `required_documents`, `financial_benefits`, `application_fees`, `registration_process`, `step_by_step_procedure`, `application_start_date`, `application_end_date`, `official_department_website`, `official_notification_url`, `direct_registration_url`, `helpdesk_details`, `faqs`, `status`, `is_featured`, `is_urgent`, `total_vacancies`, `post_name`, `pay_scale`) VALUES (11, 'GOV-EDU-001', 'gov-edu-001-national-scholarship-portal-2026-27-post-matric-merit-schola', 'National Scholarship Portal 2026-27: Post-Matric & Merit Scholarships for Students', NULL, 'All-in-one central and state scholarship portal offering up to ₹50,000/year for Class 11, 12, ITI, Diploma, College, and University students.', NULL, 'The National Scholarship Portal (NSP) is a one-stop electronic platform offering common electronic application, verification, and Direct Benefit Transfer (DBT) disbursement for over 100 scholarship schemes offered by Central Ministries and State Governments.', 'Scholarships & Education', 'Higher Education & Post-Matric Assistance', 'Central Government', 'Government of India', 'Department of Higher Education', 'Ministry of Education', 'All India', 'All Districts', 'Students enrolled in recognized schools, colleges, ITIs, polytechnics, and universities across India.', 'Enrolled in recognized course, minimum 50% marks in previous examination. Parental annual income limits vary by scheme (₹2.5 Lakh for SC/ST/OBC/Minority; ₹8 Lakh for Central Sector Scheme).', 'Up to 30 years', 'Class 10th Pass, 12th Pass, Diploma, Undergraduate, Postgraduate, or PhD', 'Annual family income less than ₹2.50 Lakh (for pre/post matric) or ₹8.00 Lakh (for merit CSSS).', '["Student Aadhaar Card (Mandatory biometric e-KYC)","Previous Year Marksheet / Scorecard","Fee Receipt of Current Academic Year","Income Certificate issued by Competent Revenue Authority","Caste / Community Certificate (if applying under SC/ST/OBC/EWS/Minority schemes)","Bank Account Passbook (Student own name, Aadhaar linked)"]', 'Covers full tuition fees up to ₹50,000 per year + monthly maintenance allowance of ₹1,000 to ₹3,000 credited directly via PFMS.', '₹0 (Free government portal)', 'Online', '["Step 1: Download OTR app or visit scholarships.gov.in and complete One-Time Registration (OTR) with Face/Aadhaar authentication.","Step 2: Log in with OTR number and fill applicant academic and institution details.","Step 3: Portal automatically suggests all schemes you qualify for (Central Sector, Post-Matric, State Merit).","Step 4: Select scheme, upload required certificates, and submit application.","Step 5: Institute Nodal Officer (INO) and District Nodal Officer (DNO) verify application online.","Step 6: Scholarship funds are disbursed through DBT directly into student bank account."]', '2026-07-01', '2026-11-30', 'https://scholarships.gov.in', 'https://scholarships.gov.in', 'https://scholarships.gov.in/fresh/newstdRegfrmInstruction', 'National Informatics Centre (NIC), CGO Complex, Lodhi Road, New Delhi - 110003. Email: helpdesk@nsp.gov.in', '[{"question":"Can a student apply for multiple scholarships on NSP?","answer":"You can apply for multiple schemes, but under DBT norms, a student can receive only one government scholarship per academic year."},{"question":"Is biometric OTR mandatory?","answer":"Yes, biometric/face authentication OTR has been made mandatory to prevent duplicate scholarship claims."}]', 'Published', 1, 0, NULL, NULL, NULL); INSERT INTO `government_schemes` (`id`, `scheme_code`, `slug`, `title`, `title_hi`, `short_description`, `short_description_hi`, `detailed_description`, `category`, `subcategory`, `government_type`, `government_name`, `department_name`, `ministry_name`, `applicable_state`, `applicable_district`, `eligible_beneficiaries`, `eligibility_criteria`, `age_limit`, `educational_qualification`, `income_criteria`, `required_documents`, `financial_benefits`, `application_fees`, `registration_process`, `step_by_step_procedure`, `application_start_date`, `application_end_date`, `official_department_website`, `official_notification_url`, `direct_registration_url`, `helpdesk_details`, `faqs`, `status`, `is_featured`, `is_urgent`, `total_vacancies`, `post_name`, `pay_scale`) VALUES (12, 'GOV-AI-001', 'gov-ai-001-haryana-kaushal-rozgar-nigam-hkrn-contractual-recruitment-20', 'Haryana Kaushal Rozgar Nigam (HKRN) Contractual Recruitment 2026', NULL, 'AI Discovered: Government of Haryana contractual staff recruitment for data entry operators, road inspectors, and technical assistants.', NULL, 'Haryana Kaushal Rozgar Nigam (HKRN) has published notification for empanelment of contractual staff across state departments. Monthly wages set as per DC rate with ESI and EPF benefits.', 'Government Recruitment', 'State Contractual Recruitment', 'State Government', 'Government of Haryana', 'Skill Development & Industrial Training', 'Government of Haryana', 'Haryana', 'All 22 Districts of Haryana', 'Residents of Haryana registered with Parivar Pehchan Patra (PPP Family ID).', 'Haryana domicile with valid PPP Family ID. Educational qualification: 10th/12th/ITI/Diploma/Degree depending on job role. Minimum age 18 years.', '18 to 42 years', '10th / 12th / ITI / Graduate', 'Weightage points given for family annual income < ₹1.80 Lakh as per PPP.', '["Parivar Pehchan Patra (PPP Family ID)","Haryana Resident Certificate","10th / 12th / ITI Marksheet","Haryana Skill Development Mission (HSDM) certificate (if any)"]', 'Monthly consolidated salary of ₹18,000 to ₹25,500 based on district category and educational level.', '₹236 (including GST)', 'Online', '["Step 1: Visit hkrnl.itiharyana.gov.in and click \\"Candidate Registration\\".","Step 2: Enter 8-digit Parivar Pehchan Patra (Family ID) and verify OTP.","Step 3: Select job role matching qualification and upload certificates.","Step 4: Pay registration fees online and submit."]', '2026-10-25', '2026-11-20', 'https://hkrnl.itiharyana.gov.in', 'https://hkrnl.itiharyana.gov.in', 'https://hkrnl.itiharyana.gov.in', 'HKRNL Office, Sector 3, Panchkula, Haryana', '[{"question":"Is Family ID mandatory?","answer":"Yes, Parivar Pehchan Patra (PPP) is mandatory for applying under HKRN."}]', 'Pending Approval', 0, 0, NULL, NULL, NULL); DROP TABLE IF EXISTS `success_stories`; CREATE TABLE `success_stories` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `beneficiary_name` varchar(150) NOT NULL, `beneficiary_name_hi` varchar(150) DEFAULT NULL, `district_state` varchar(150) NOT NULL, `scheme_title` varchar(255) NOT NULL, `benefit_received` varchar(255) NOT NULL, `testimonial` text NOT NULL, `testimonial_hi` text, `verified_badge` varchar(150) DEFAULT 'DBT Verified Beneficiary', `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; INSERT INTO `success_stories` (`beneficiary_name`, `beneficiary_name_hi`, `district_state`, `scheme_title`, `benefit_received`, `testimonial`, `testimonial_hi`) VALUES ('Rameshwar Dayal', 'रामेश्वर दयाल', 'Hisar, Haryana', 'PM Surya Ghar Muft Bijli Yojana', '₹78,000 Direct Bank Subsidy (3kW Solar)', 'Using CSC HELP required documents checklist, I applied for a 3kW rooftop solar system. Within 25 days of net-metering, ₹78,000 subsidy was credited directly to my PNB account.', 'CSC HELP के दस्तावेज़ चेकलिस्ट की मदद से मैंने 3kW सोलर पैनल के लिए आवेदन किया। 25 दिनों में ₹78,000 की सब्सिडी सीधे मेरे बैंक खाते में आ गई।'), ('Sunita Devi', 'सुनीता देवी', 'Varanasi, Uttar Pradesh', 'PM Vishwakarma Kaushal Samman Yojana', '₹15,000 Toolkit Voucher + ₹1 Lakh Loan', 'As a traditional tailor, I found the exact official portal and document requirements here. I completed biometric verification at CSC and received my ₹15,000 e-voucher.', 'एक पारंपरिक दर्जी के रूप में मुझे यहाँ से सही पोर्टल और आवश्यक दस्तावेज़ों की जानकारी मिली। मुझे ₹15,000 का ई-वाउचर और ₹1 लाख का लोन मिला।'), ('Vikram Singh Poonia', 'विक्रम सिंह पूनिया', 'Rohtak, Haryana', 'PMEGP MSME Manufacturing Subsidy', '35% Margin Money Subsidy (₹8.75 Lakh)', 'I set up an agro-processing unit under PMEGP. The step-by-step procedure and Udyam registration links on CSC HELP saved me months of paperwork.', 'मैंने PMEGP के तहत कृषि प्रसंस्करण इकाई लगाई। इस पोर्टल के माध्यम से उद्यम पंजीकरण और बैंक प्रोजेक्ट रिपोर्ट तैयार करना बहुत आसान रहा।'); DROP TABLE IF EXISTS `faqs`; CREATE TABLE `faqs` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `category` varchar(100) NOT NULL, `question_en` text NOT NULL, `answer_en` text NOT NULL, `question_hi` text, `answer_hi` text, `sort_order` int NOT NULL DEFAULT 1, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; INSERT INTO `faqs` (`category`, `question_en`, `answer_en`, `question_hi`, `answer_hi`, `sort_order`) VALUES ('Eligibility & Documents', 'How do I check which documents are mandatory for a government scheme?', 'Open any scheme or recruitment card on CSC HELP to view the interactive Required Documents Checklist (Aadhaar, PAN, Income Certificate, Family ID/PPP, Bank DBT seeding). You can tick off documents you already have.', 'किसी सरकारी योजना के लिए कौन से दस्तावेज़ अनिवार्य हैं, यह कैसे जांचें?', 'किसी भी योजना कार्ड पर क्लिक करें और आवश्यक दस्तावेज़ चेकलिस्ट (आधार, पैन, आय प्रमाण पत्र, फैमिली आईडी) देखें।', 1), ('Expired Schemes Policy', 'What happens to expired schemes, services, and job notifications?', 'Expired schemes and jobs remain visible in the Information Area with an Expired badge and countdown timer for 30 days so applicants can download admit cards or check results. Exactly 30 days after the expiry date, the system automatically deletes them.', 'समाप्त हो चुकी योजनाओं और नौकरियों के विवरण का क्या होता है?', 'समाप्त हो चुकी योजनाएं और भर्तियां अंतिम तिथि के बाद 30 दिनों तक सूचना क्षेत्र में दिखाई देती हैं और 30 दिन पूरे होने पर स्वतः डिलीट हो जाती हैं।', 2), ('Department Links', 'Are the Department-Wise Web Links official government portals?', 'Yes, all 55+ portals listed under the 12 Government Departments point directly to verified .gov.in and .nic.in domains managed by NIC, Central Ministries, and State Governments.', 'क्या विभागवार वेब लिंक आधिकारिक सरकारी वेबसाइट हैं?', 'हाँ, सभी 12 विभागों के अंतर्गत दिए गए 55+ वेब लिंक सीधे आधिकारिक .gov.in और .nic.in पोर्टल से जुड़े हैं।', 3); DROP TABLE IF EXISTS `whatsapp_subscribers`; CREATE TABLE `whatsapp_subscribers` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `mobile` varchar(20) NOT NULL UNIQUE, `full_name` varchar(150) DEFAULT NULL, `state` varchar(100) NOT NULL DEFAULT 'All India', `preferred_language` varchar(10) NOT NULL DEFAULT 'hi', `age` int DEFAULT NULL, `occupation` varchar(100) DEFAULT NULL, `annual_income` varchar(100) DEFAULT NULL, `subscribed_categories` json DEFAULT NULL, `is_active` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; SET FOREIGN_KEY_CHECKS = 1;