-- ============================================================
-- The Hindu News Database
-- Import with: mysql -u root -p hindu_news < hindu_news.sql
-- ============================================================

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+05:30";
SET NAMES utf8mb4;

-- ── Categories ──────────────────────────────────────────────
CREATE TABLE IF NOT EXISTS `tbl_category` (
  `category_id` int(11) NOT NULL AUTO_INCREMENT,
  `category_name` varchar(150) NOT NULL,
  `slug` varchar(150) DEFAULT NULL,
  `category_banner` varchar(255) DEFAULT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_keyword` mediumtext DEFAULT NULL,
  `meta_description` mediumtext DEFAULT NULL,
  `display_order` int(11) NOT NULL DEFAULT 0,
  `type` varchar(50) NOT NULL DEFAULT 'general',
  PRIMARY KEY (`category_id`),
  UNIQUE KEY `slug` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `tbl_category` VALUES
(1,  'India',         'india',         NULL, 'India News',         'india, national news, indian politics', 'Latest news from India — politics, economy, society and more.',            1, 'general'),
(2,  'World',         'world',         NULL, 'World News',         'world, global news, international',     'International headlines covering diplomacy, conflicts and global affairs.',2, 'general'),
(3,  'Politics',      'politics',      NULL, 'Politics News',      'politics, elections, government',       'Political updates, elections and policy news from India and abroad.',      3, 'general'),
(4,  'Business',      'business',      NULL, 'Business & Economy', 'business, economy, markets, finance',   'Business news, stock markets, corporate updates and economic analysis.',   4, 'business'),
(5,  'Sport',         'sport',         NULL, 'Sports News',        'sports, cricket, football, tennis',     'Cricket, football, tennis, IPL and all major sports coverage.',           5, 'sports'),
(6,  'Science',       'science',       NULL, 'Science & Tech',     'science, technology, space, ISRO',      'Science discoveries, space missions, ISRO and emerging technologies.',    6, 'general'),
(7,  'Entertainment', 'entertainment', NULL, 'Entertainment',      'entertainment, movies, music, OTT',     'Bollywood, Hollywood, OTT, music and celebrity news.',                    7, 'general'),
(8,  'Health',        'health',        NULL, 'Health & Wellness',  'health, medicine, wellness, fitness',   'Health news, medical research, wellness tips and public health updates.', 8, 'general'),
(9,  'Environment',   'environment',   NULL, 'Environment',        'environment, climate, nature, ecology', 'Climate change, conservation, sustainability and environmental policy.',  9, 'general'),
(10, 'Education',     'education',     NULL, 'Education',          'education, schools, universities, NEP', 'Education policy, school news, university updates and NEP coverage.',     10, 'general');

-- ── Authors ─────────────────────────────────────────────────
CREATE TABLE IF NOT EXISTS `tbl_authors` (
  `author_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `slug` varchar(150) NOT NULL,
  `name` varchar(150) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `designation` varchar(150) DEFAULT NULL,
  `bio` text DEFAULT NULL,
  `joined_year` year(4) DEFAULT NULL,
  `location` varchar(150) DEFAULT NULL,
  `social` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`author_id`),
  UNIQUE KEY `slug` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `tbl_authors` VALUES
(1, 'the-hindu-bureau', 'THE HINDU BUREAU', NULL, 'News Desk', 'Our bureau correspondents covering breaking news across India and the world.', '1878', 'Chennai, India', '{"twitter":"https://twitter.com/thehindu","facebook":"https://facebook.com/thehindu","linkedin":"https://linkedin.com/company/the-hindu"}', NOW(), NOW()),
(2, 'priya-nair', 'Priya Nair', NULL, 'Senior Political Correspondent', 'Priya Nair covers national politics, Parliament and elections with over 15 years of reporting experience.', '2009', 'New Delhi, India', '{"twitter":"https://twitter.com/priyanair","facebook":"","linkedin":""}', NOW(), NOW()),
(3, 'arjun-sharma', 'Arjun Sharma', NULL, 'Business Editor', 'Arjun Sharma tracks Indian and global markets, corporate affairs and economic policy from Mumbai.', '2012', 'Mumbai, India', '{"twitter":"https://twitter.com/arjunsharma","facebook":"","linkedin":""}', NOW(), NOW()),
(4, 'meera-krishnan', 'Meera Krishnan', NULL, 'Science & Environment Reporter', 'Meera covers ISRO missions, climate science, biodiversity and India\'s environmental challenges.', '2015', 'Chennai, India', '{"twitter":"https://twitter.com/meera_k","facebook":"","linkedin":""}', NOW(), NOW()),
(5, 'rahul-menon', 'Rahul Menon', NULL, 'Sports Correspondent', 'Rahul reports on cricket, football and the Indian sports ecosystem from his base in Mumbai.', '2014', 'Mumbai, India', '{"twitter":"https://twitter.com/rahulmenon","facebook":"","linkedin":""}', NOW(), NOW()),
(6, 'sunita-rao', 'Sunita Rao', NULL, 'Health & Society Reporter', 'Sunita covers public health, medical research and social affairs for The Hindu.', '2017', 'Bengaluru, India', '{"twitter":"https://twitter.com/sunitarao","facebook":"","linkedin":""}', NOW(), NOW()),
(7, 'vikram-iyer', 'Vikram Iyer', NULL, 'World Affairs Correspondent', 'Vikram is The Hindu\'s correspondent covering South Asia, Southeast Asia and global geopolitics.', '2011', 'New Delhi, India', '{"twitter":"https://twitter.com/vikramiyer","facebook":"","linkedin":""}', NOW(), NOW()),
(8, 'deepa-thomas', 'Deepa Thomas', NULL, 'Entertainment & Culture Reporter', 'Deepa covers Indian cinema, OTT, literature and the arts for The Hindu\'s culture desk.', '2018', 'Mumbai, India', '{"twitter":"https://twitter.com/deepathomas","facebook":"","linkedin":""}', NOW(), NOW());

-- ── News ─────────────────────────────────────────────────────
CREATE TABLE IF NOT EXISTS `tbl_news` (
  `news_id` int(11) NOT NULL AUTO_INCREMENT,
  `news_title` varchar(255) NOT NULL,
  `news_content` mediumtext NOT NULL,
  `news_content_short` mediumtext NOT NULL,
  `photo` varchar(255) NOT NULL DEFAULT 'news1.jpg',
  `published_at` datetime DEFAULT NULL,
  `category_id` int(11) NOT NULL,
  `author_id` int(10) UNSIGNED DEFAULT NULL,
  `encode_title` varchar(255) NOT NULL,
  `img_alt` varchar(255) DEFAULT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_keyword` mediumtext DEFAULT NULL,
  `meta_description` mediumtext DEFAULT NULL,
  `type` varchar(50) NOT NULL DEFAULT 'general',
  `views` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  PRIMARY KEY (`news_id`),
  KEY `idx_published` (`published_at`),
  KEY `idx_category` (`category_id`),
  KEY `idx_author` (`author_id`),
  KEY `idx_encode` (`encode_title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `tbl_news` (`news_id`,`news_title`,`news_content`,`news_content_short`,`photo`,`published_at`,`category_id`,`author_id`,`encode_title`,`img_alt`,`meta_title`,`meta_keyword`,`meta_description`,`type`,`views`) VALUES

(1,'Parliament Budget Session Enters Final Week as Opposition Demands Debate on Inflation',
'<p><strong>New Delhi:</strong> The Budget Session of Parliament entered its final week on Monday with the Opposition demanding an urgent debate on rising inflation and unemployment. The government, meanwhile, urged lawmakers to focus on passing pending legislation including the amendments to the Land Acquisition Act.</p><p>Lok Sabha Speaker Om Birla held an all-party meeting on Sunday evening to discuss the session agenda. Senior leaders from the BJP, Congress, TMC and other parties attended the meeting, with most agreeing that the remaining days should be used productively.</p><h2>Inflation Debate</h2><p>Congress leader Rahul Gandhi raised the issue of food inflation on the floor of the House, pointing to data showing vegetable prices have risen 18 per cent over the previous quarter. The Finance Minister responded that the government is actively monitoring supply chains and has released buffer stocks of key commodities.</p><p>The session is expected to conclude by the end of this week after sitting through four weeks of heated exchanges on the Union Budget, tax reforms and infrastructure spending.</p>',
'Parliament budget session enters final week with Opposition demanding a debate on inflation and unemployment as the government pushes to pass pending legislation.','editors.jpg','2026-04-09 10:00:00',3,1,'parliament-budget-session-final-week-inflation-debate','Parliament session India budget debate','Parliament Budget Session: Opposition Demands Inflation Debate in Final Week','parliament, budget session, inflation, india parliament, lok sabha','The Budget Session of Parliament enters its final week as the Opposition demands a debate on rising inflation.','general',0),

(2,'S-400 Missile Defence System Fully Operational: Defence Ministry',
'<p><strong>New Delhi:</strong> India\'s S-400 Triumf air defence missile system has achieved full operational readiness, the Defence Ministry announced on Tuesday, marking a significant milestone in the country\'s strategic deterrence capability.</p><p>The advanced system, procured from Russia under a $5 billion deal signed in 2018, can engage aircraft, ballistic missiles and drones at multiple ranges simultaneously. All five squadrons of the system are now deployed at strategic locations across the country.</p><h2>Strategic Significance</h2><p>The system provides India with a layered air defence network covering its northern and western borders. Defence analysts said the operational readiness of S-400 significantly strengthens India\'s deterrence posture given current regional security dynamics.</p><p>The Defence Ministry also announced that Indian engineers have achieved a technology transfer agreement that will allow domestic maintenance of key components going forward.</p>',
'India\'s S-400 Triumf air defence missile system has achieved full operational readiness, the Defence Ministry announced, strengthening the country\'s strategic deterrence.','assembly.jpg','2026-04-09 08:30:00',1,2,'s400-missile-defence-fully-operational-india-defence-ministry','S-400 India defence system','S-400 Air Defence System Fully Operational, Says Indian Defence Ministry','S-400, India defence, missile system, Russia India, air defence India','India\'s S-400 missile defence system is fully operational, the Defence Ministry said, marking a major milestone in the country\'s strategic capability.','general',0),

(3,'Census Activities in Advanced Stage; First Phase to Begin Next Month',
'<p><strong>New Delhi:</strong> The Registrar General of India (RGI) said on Monday that census activities are at an advanced stage of preparation and the first phase of the population enumeration is expected to begin next month.</p><p>"We are fully prepared. The digital enumeration platform has been tested extensively, and over 3 million enumerators have been trained," RGI Sanjay Kumar told reporters at a press conference in New Delhi.</p><h2>Digital Census</h2><p>This will be India\'s first fully digital census, with enumerators using smartphones and a specially developed application to record demographic data. The self-enumeration portal will allow urban residents to fill in their details without waiting for an enumerator\'s visit.</p><p>The census will cover all 640 districts across 28 states and 8 Union Territories. The first phase will focus on the house listing and housing census operations.</p>',
'The Registrar General of India says census activities are at an advanced stage with the first phase of population enumeration set to begin next month.','court.jpg','2026-04-08 14:00:00',1,1,'india-census-first-phase-next-month-rgi','India census 2026 RGI','India Census First Phase to Begin Next Month, Says RGI','india census, population count, digital census, RGI India','India\'s census activities are nearly ready with digital enumeration beginning next month, the Registrar General announced.','general',0),

(4,'India GDP Growth Projected at 6.8% for FY 2026-27: IMF',
'<p><strong>Washington / New Delhi:</strong> The International Monetary Fund projected India\'s GDP growth at 6.8 per cent for the financial year 2026-27, reaffirming the country\'s position as the world\'s fastest-growing major economy.</p><p>The projection, released in the IMF\'s World Economic Outlook, slightly raised the earlier forecast of 6.5 per cent, citing stronger-than-expected domestic consumption and robust services exports.</p><h2>Key Drivers</h2><p>The report highlighted infrastructure spending, digital economy growth and remittance inflows as key drivers. It also noted that India\'s inflation remains within the RBI\'s target range and that the current account deficit has narrowed.</p><p>Chief Economic Adviser V. Anantha Nageswaran called the projection "validation of India\'s strong macroeconomic fundamentals" and said the government remains committed to fiscal consolidation.</p>',
'The IMF has projected India\'s GDP growth at 6.8% for FY 2026-27, affirming its status as the world\'s fastest-growing major economy.','img-2.webp','2026-04-08 09:00:00',4,3,'india-gdp-growth-6point8-percent-imf-projection-fy2027','India GDP growth IMF projection','IMF Projects India GDP Growth at 6.8% for FY 2026-27','India GDP, IMF projection, economic growth, India economy 2026','The IMF projected India\'s GDP growth at 6.8% for FY 2026-27, citing strong consumption and services exports.','business',0),

(5,'Kerala Assembly Elections 2026: UDF Leads in Initial Surveys',
'<p><strong>Thiruvananthapuram:</strong> The United Democratic Front led by the Congress is ahead in most pre-election surveys for the Kerala Assembly Elections 2026, according to data compiled by multiple polling agencies released on Tuesday.</p><p>The surveys indicate that the UDF alliance could win between 75 and 90 seats in the 140-seat Assembly, with the ruling Left Democratic Front expected to secure between 45 and 60 seats. The BJP-led NDA is projected to improve its tally to 10-15 seats.</p><h2>Key Battles</h2><p>The elections are scheduled for May and counting is expected in June. Key constituencies include Thrissur, Thiruvananthapuram, and Malappuram, where tight contests are anticipated.</p><p>Kerala Chief Minister Pinarayi Vijayan has defended the LDF\'s five-year record and promised additional welfare schemes in the run-up to the election.</p>',
'Initial surveys show the UDF Congress alliance ahead for Kerala Assembly Elections 2026 with 75 to 90 seats projected in the 140-seat Assembly.','kerala.jpg','2026-04-08 07:00:00',3,2,'kerala-assembly-elections-2026-udf-leads-surveys','Kerala elections 2026 surveys UDF','Kerala 2026 Elections: UDF Leads in Initial Survey Projections','Kerala elections, UDF, LDF, assembly polls 2026, Kerala politics','Pre-election surveys for Kerala Assembly 2026 show the UDF leading with 75-90 projected seats.','general',0),

(6,'India Beats England 4-1 in Test Series; Rohit Sharma Hails Team\'s Dominance',
'<p><strong>Dharamsala:</strong> India completed a comprehensive 4-1 series victory over England in the five-Test series, winning the fifth and final Test by an innings and 34 runs on Tuesday. Captain Rohit Sharma said the performance reflected the team\'s depth and adaptability.</p><p>Jasprit Bumrah was the standout performer of the series, taking 28 wickets across five Tests at an average of 14.2. Virat Kohli contributed 520 runs with two centuries.</p><h2>Bumrah\'s Brilliance</h2><p>"This win is very special. England are a fantastic side and to beat them 4-1 at home shows how good this Indian team is," Rohit said at the post-match presentation.</p><p>India will next play a three-match ODI series against England before both sides travel for the ICC Champions Trophy later this month.</p>',
'India sealed a dominant 4-1 Test series victory over England with Jasprit Bumrah claiming 28 wickets and Rohit Sharma praising the team\'s depth and adaptability.','sport2.webp','2026-04-07 18:00:00',5,5,'india-beat-england-4-1-test-series-rohit-sharma','India cricket England test series','India Beat England 4-1 in Test Series; Rohit Hails Team Dominance','India cricket, England cricket, test series, Rohit Sharma, Bumrah','India won the five-Test series against England 4-1 with Jasprit Bumrah taking 28 wickets.','sports',0),

(7,'ISRO Launches Gaganyaan Crew Module Test Successfully',
'<p><strong>Sriharikota:</strong> The Indian Space Research Organisation successfully launched the Gaganyaan crew module qualification test on Wednesday, clearing a critical milestone on India\'s path to sending astronauts to space by the end of this year.</p><p>The test flight, launched from the Satish Dhawan Space Centre, carried the crew module to an altitude of 17 km and then deployed parachutes to demonstrate safe recovery over the Bay of Bengal.</p><h2>Path to Human Spaceflight</h2><p>ISRO Chairman S. Somanath called the test "a textbook mission" and said it brings India closer to the crewed Gaganyaan mission scheduled for the final quarter of 2026.</p><p>"Every system performed exactly as designed. Our astronauts can now be confident in the safety of their crew module," Somanath said.</p><p>Four Indian Air Force pilots are currently in advanced training for the crewed mission at the Bengaluru facility.</p>',
'ISRO successfully completed the Gaganyaan crew module qualification test, clearing a critical milestone on the path to India\'s first human spaceflight.','img-det.webp','2026-04-07 11:00:00',6,4,'isro-gaganyaan-crew-module-test-launch-success','ISRO Gaganyaan crew module test','ISRO Successfully Tests Gaganyaan Crew Module Ahead of Human Spaceflight Mission','ISRO, Gaganyaan, human spaceflight, India space mission, crew module','ISRO successfully tested the Gaganyaan crew module, clearing a major milestone ahead of India\'s first crewed space mission.','general',0),

(8,'COVID Variant XEC Detected in India; Health Ministry Issues Advisory',
'<p><strong>New Delhi:</strong> The Union Health Ministry on Monday issued an advisory to states after the XEC variant of COVID-19 was detected in cluster cases across Delhi, Mumbai and Bengaluru.</p><p>While the variant has shown higher transmissibility than previous strains, early data from global health agencies suggests it does not cause more severe illness in vaccinated individuals.</p><h2>Government Response</h2><p>The ministry said it has directed states to increase genomic surveillance and ensure that healthcare facilities are adequately staffed. The National Centre for Disease Control (NCDC) has been put on high alert.</p><p>"There is no cause for alarm but citizens should maintain basic precautions and get booster doses if they have not already done so," Health Minister Mansukh Mandaviya said.</p>',
'The Health Ministry issued an advisory after the XEC COVID variant was detected in Delhi, Mumbai and Bengaluru, urging surveillance and booster vaccination.','det.jpg','2026-04-06 16:00:00',8,6,'covid-xec-variant-india-health-ministry-advisory','COVID XEC variant India health advisory','COVID XEC Variant Detected in India; Health Ministry Issues Advisory','COVID variant, XEC variant India, health advisory, coronavirus India 2026','India\'s Health Ministry issued an advisory after XEC COVID variant cases were detected in three cities.','general',0),

(9,'Union Budget 2026: Key Highlights and What They Mean for You',
'<p><strong>New Delhi:</strong> Finance Minister Nirmala Sitharaman presented the Union Budget 2026 to Parliament on February 1, introducing a series of measures aimed at boosting consumption, supporting the middle class and driving infrastructure investment.</p><h2>Income Tax Relief</h2><p>The biggest announcement was the raising of the income tax exemption limit to Rs 12 lakh under the new tax regime. This is expected to benefit approximately 2.8 crore taxpayers.</p><h2>Infrastructure Push</h2><p>The capital expenditure outlay has been raised by 12 per cent to Rs 11.5 lakh crore, with the majority allocated to roads, railways and urban infrastructure.</p><h2>Agriculture</h2><p>A new PM Kisan Samman Nidhi tranche has been announced along with a Rs 1 lakh crore agricultural modernisation fund to support farm mechanisation and irrigation.</p>',
'Finance Minister Nirmala Sitharaman raised the income tax exemption limit to Rs 12 lakh and increased capital expenditure by 12% in the Union Budget 2026.','news9.png','2026-04-06 08:00:00',4,3,'union-budget-2026-key-highlights-income-tax-infrastructure','Union Budget 2026 highlights income tax','Union Budget 2026: Key Highlights — Income Tax Relief, Infrastructure Push and Farm Scheme','union budget 2026, income tax relief, budget highlights, capital expenditure India','The Union Budget 2026 raised income tax limits to Rs 12 lakh and hiked capital expenditure by 12% to Rs 11.5 lakh crore.','business',0),

(10,'Artemis III Mission: ISRO Astronaut to Join NASA Moon Landing Crew',
'<p><strong>Houston / New Delhi:</strong> NASA and ISRO jointly announced on Thursday that an Indian astronaut will join the crew of the Artemis III mission, marking a landmark moment in the India-US space partnership.</p><p>Group Captain Prashanth Nair, who is currently in advanced astronaut training at NASA\'s Johnson Space Center, has been named as a mission specialist for the historic lunar landing mission scheduled for late 2026.</p><h2>Historic Partnership</h2><p>"This is a momentous step in our two countries\' growing strategic partnership in space," said NASA Administrator Bill Nelson. "Having an Indian astronaut on the Artemis III crew reflects India\'s growing stature as a spacefaring nation."</p><p>ISRO Chairman S. Somanath called it "a proud moment for India" and said the mission would inspire a generation of young scientists.</p>',
'An ISRO astronaut has been named to the Artemis III Moon landing crew in a landmark announcement reflecting India\'s growing space partnership with NASA.','img-tamp.webp','2026-04-05 12:00:00',6,4,'isro-astronaut-artemis-iii-nasa-moon-landing','ISRO NASA Artemis III Indian astronaut','ISRO Astronaut Named for Artemis III Moon Landing Mission with NASA','ISRO, NASA, Artemis III, Indian astronaut moon, India US space partnership','An ISRO astronaut will join the Artemis III lunar landing crew, NASA and ISRO announced jointly.','general',0),

(11,'IPL 2026: Mumbai Indians Beat Chennai Super Kings in Opening Match',
'<p><strong>Mumbai:</strong> Mumbai Indians defeated Chennai Super Kings by 7 wickets in a thrilling IPL 2026 opener at the Wankhede Stadium on Saturday evening, with Rohit Sharma leading from the front with a blistering 68 off 42 balls.</p><p>CSK posted 178 for 6 after being put in, with Ruturaj Gaikwad (54) and Shivam Dube (49) leading the charge. MI chased down the target with two overs to spare.</p><h2>Rohit\'s Return</h2><p>Captain Rohit Sharma opened the batting and played with trademark authority. "Great start to the tournament. The pitch was good for batting and we took our chances," Rohit said at the post-match presentation.</p>',
'Mumbai Indians beat Chennai Super Kings by 7 wickets in the IPL 2026 opener at Wankhede Stadium, with Rohit Sharma scoring 68 off 42 balls.','sports1.jpg','2026-04-05 22:00:00',5,5,'ipl-2026-mumbai-indians-beat-csk-opening-match','IPL 2026 MI vs CSK Mumbai Indians','IPL 2026: Mumbai Indians Beat Chennai Super Kings in Thrilling Opener','IPL 2026, Mumbai Indians, Chennai Super Kings, IPL cricket, Rohit Sharma','Mumbai Indians defeated CSK by 7 wickets in the IPL 2026 season opener.','sports',0),

(12,'Cyclone Biparjoy 2.0 Likely to Form in Arabian Sea: IMD',
'<p><strong>New Delhi:</strong> The India Meteorological Department (IMD) on Tuesday issued an alert saying a low-pressure system in the Arabian Sea is likely to intensify into a cyclonic storm over the next 72 hours, posing a threat to the Gujarat and Maharashtra coastlines.</p><p>The system, tentatively named Biparjoy-2, is tracking north-northeast and is expected to make landfall between Surat and Veraval if it sustains its intensity.</p><h2>Preparedness</h2><p>The National Disaster Response Force (NDRF) has pre-positioned 15 teams across coastal districts of Gujarat and Maharashtra. Fishermen have been asked not to venture into the sea.</p>',
'IMD has issued an alert about a cyclonic storm likely to form in the Arabian Sea, potentially threatening the Gujarat and Maharashtra coasts.','news12.jpg','2026-04-04 15:00:00',1,1,'cyclone-biparjoy-arabian-sea-imd-alert-gujarat-maharashtra','Cyclone India IMD alert 2026','Cyclone Likely to Form in Arabian Sea; IMD Issues Alert for Gujarat, Maharashtra','cyclone India, IMD alert, Arabian Sea storm, Gujarat cyclone warning','The IMD has warned of a likely cyclone in the Arabian Sea that could hit Gujarat and Maharashtra coastlines.','general',0),

(13,'Virat Kohli Announces Test Retirement After England Series',
'<p><strong>Mumbai:</strong> Virat Kohli stunned Indian cricket on Thursday evening by announcing his retirement from Test cricket, ending a 15-year career in the format in which he scored 9,165 runs including 32 centuries.</p><p>The 37-year-old made the announcement through a heartfelt post on social media: "Test cricket gave me everything. The whites, the red ball, the swinging pitches — nothing compares. But I feel this is the right time."</p><h2>Legacy</h2><p>Kohli finishes as India\'s second-highest Test run-scorer after Sachin Tendulkar. He captained India in 68 Tests, winning 40 of them. Former cricketers and fans across the world paid tribute to his impact on the game.</p>',
'Virat Kohli has announced his retirement from Test cricket after a 15-year career in which he scored 9,165 runs and 32 centuries for India.','news13.jpg','2026-04-03 19:00:00',5,5,'virat-kohli-test-retirement-announcement','Virat Kohli Test retirement India cricket','Virat Kohli Announces Test Retirement After England Series','Virat Kohli retirement, India cricket, test cricket, Kohli centuries','Virat Kohli has announced retirement from Test cricket, ending his 15-year career with 9,165 runs.','sports',0),

(14,'India to Launch 5G Satellite Internet Service by December 2026',
'<p><strong>New Delhi:</strong> The government announced on Wednesday that India will launch a 5G satellite-based internet service by December 2026, which will provide broadband connectivity to remote areas including tribal hamlets in the Northeast and high-altitude border villages.</p><p>The Department of Telecommunications said it has cleared licences for two operators — a BSNL-ISRO joint venture and a private consortium — to offer the service using Low Earth Orbit (LEO) satellites.</p><h2>Digital Inclusion</h2><p>The service will initially cover 50,000 villages that do not have 4G connectivity. Devices will be available to BPL families at subsidised rates under the Digital India programme.</p>',
'India plans to launch 5G satellite internet by December 2026 to connect remote areas, with BSNL-ISRO and a private consortium cleared to operate LEO satellite broadband.','det2.jpg','2026-04-03 10:00:00',6,4,'india-5g-satellite-internet-service-launch-december-2026','India 5G satellite internet service','India to Launch 5G Satellite Internet Service by December 2026 for Remote Areas','India 5G, satellite internet, LEO satellite India, digital inclusion, BSNL ISRO','India plans a satellite-based 5G internet rollout by December 2026 for remote villages.','general',0),

(15,'Bengaluru Metro Phase 3 Inauguration on Track for June',
'<p><strong>Bengaluru:</strong> Bengaluru Metro Rail Corporation (BMRCL) has confirmed that Phase 3 of the Namma Metro, extending the network to Kempegowda International Airport and Sarjapur, is on schedule for inauguration in June 2026.</p><p>The extension will add 56 km of new metro line and 32 new stations to the existing network, reducing travel time to the airport from the city centre to under 40 minutes.</p><h2>Urban Mobility Boost</h2><p>Urban development experts said the extension will significantly ease traffic congestion on the Outer Ring Road, one of Bengaluru\'s most congested corridors. An integrated transit hub connecting metro, bus and suburban rail services is planned at Hebbal station.</p>',
'Bengaluru\'s Namma Metro Phase 3 extension to the airport and Sarjapur is on schedule for June inauguration, adding 56 km and 32 stations to the network.','city1.jpg','2026-04-02 09:00:00',1,6,'bengaluru-metro-phase-3-inauguration-june-2026','Bengaluru metro phase 3 inauguration','Bengaluru Metro Phase 3 to Airport on Track for June Inauguration','Bengaluru metro, namma metro phase 3, Bengaluru airport metro, urban transport','Bengaluru\'s Metro Phase 3 connecting the airport is scheduled for June 2026 inauguration.','general',0),

(16,'India-China Disengagement Complete at All LAC Friction Points: Army',
'<p><strong>New Delhi:</strong> The Indian Army on Monday confirmed that disengagement between Indian and Chinese troops is complete at all friction points along the Line of Actual Control (LAC) in eastern Ladakh, ending a nearly six-year standoff.</p><p>Army Chief General Upendra Dwivedi said both sides have returned to their respective pre-April 2020 positions and that normal patrolling has resumed in all sectors including Depsang Plains and Demchok.</p><h2>Diplomatic Significance</h2><p>The development follows a series of high-level diplomatic engagements including meetings between the National Security Advisers of both countries. External Affairs Minister S. Jaishankar called it "a positive and significant development for bilateral relations."</p>',
'The Indian Army confirmed complete disengagement of Indian and Chinese troops at all LAC friction points in Ladakh, ending a six-year standoff.','state1.jpeg','2026-04-01 16:00:00',1,2,'india-china-disengagement-lac-friction-points-army-confirms','India China LAC disengagement Ladakh','India-China Disengagement Complete at All LAC Friction Points: Army Chief','India China LAC, Ladakh standoff, India China relations, Line of Actual Control','India and China have completed disengagement at all LAC friction points, ending the six-year Ladakh standoff.','general',0),

(17,'Solar Energy Capacity Crosses 150 GW; India Ahead of 2030 Target',
'<p><strong>New Delhi:</strong> India\'s cumulative solar power capacity crossed 150 gigawatts (GW) on Friday, putting the country firmly on track to exceed its target of 500 GW of renewable energy by 2030, the Ministry of New and Renewable Energy announced.</p><p>The milestone was achieved with the commissioning of a 1,200 MW solar park in Rajasthan and several rooftop solar installations under the PM Surya Ghar scheme.</p><h2>Green Energy Leader</h2><p>India is now the third-largest solar power producer in the world behind China and the United States. The domestic solar equipment manufacturing sector has also grown significantly, with module production capacity reaching 80 GW annually.</p>',
'India\'s solar power capacity crossed 150 GW, putting the country ahead of schedule to meet its 500 GW renewable energy target by 2030.','det3.jpg','2026-03-31 12:00:00',9,4,'india-solar-energy-150gw-renewable-energy-target-2030','India solar energy 150 GW milestone','India Solar Capacity Crosses 150 GW; Ahead of 2030 Renewable Target','India solar energy, renewable energy India, solar power 150GW, PM Surya Ghar','India crossed 150 GW solar capacity, putting the country ahead of its 2030 renewable energy target.','general',0),

(18,'Supreme Court Upholds Validity of Electoral Bond Scheme Amendments',
'<p><strong>New Delhi:</strong> The Supreme Court of India on Thursday upheld the validity of the government\'s amended Electoral Bond Scheme, ruling 3-2 that the modifications addressed concerns raised in earlier judgments while maintaining the principle of transparent political funding.</p><p>The amended scheme requires disclosure of bond purchasers above Rs 1 crore to the Election Commission of India, which will maintain a sealed record accessible under RTI after elections.</p><h2>Dissent</h2><p>The two dissenting judges argued that the amendments did not go far enough in ensuring complete transparency and that anonymous political funding remained a concern. The Chief Justice wrote the majority opinion calling the amendments "a reasonable middle path."</p>',
'The Supreme Court upheld amendments to the Electoral Bond Scheme in a 3-2 ruling, finding the changes addressed transparency concerns while preserving political funding mechanisms.','court.jpg','2026-03-30 17:00:00',3,2,'supreme-court-electoral-bond-scheme-upheld-amendments','Supreme Court electoral bond India','Supreme Court Upholds Electoral Bond Scheme Amendments in 3-2 Ruling','Supreme Court, electoral bond, political funding India, election commission','The Supreme Court upheld the amended Electoral Bond Scheme 3-2, requiring disclosure of large bond purchasers to the EC.','general',0),

(19,'Zomato Rebrands to Eternal; Plans Rs 2,500 Crore Quick Commerce Expansion',
'<p><strong>Mumbai:</strong> Foodtech giant Zomato officially rebranded itself as Eternal Limited on Monday, reflecting its broader ambitions beyond food delivery. The company also announced a Rs 2,500 crore investment in its Blinkit quick-commerce platform over the next 18 months.</p><p>The company said it will expand Blinkit\'s dark store network from the current 1,200 to 3,500 stores across 100 cities, targeting 10-minute delivery for groceries, electronics and pharmaceuticals.</p><h2>New Identity</h2><p>Founder and CEO Deepinder Goyal said the Eternal brand represents "our commitment to building enduring businesses across food, commerce and logistics."</p>',
'Zomato rebranded as Eternal Limited and announced Rs 2,500 crore for Blinkit expansion to 3,500 dark stores across 100 cities for 10-minute delivery.','det4.jpg','2026-03-29 10:00:00',4,3,'zomato-rebrands-eternal-blinkit-quick-commerce-expansion','Zomato Eternal rebrand Blinkit expansion','Zomato Rebrands to Eternal; Plans Rs 2,500 Crore Blinkit Expansion','Zomato, Eternal, Blinkit, quick commerce India, dark stores','Zomato rebranded as Eternal and announced a Rs 2,500 crore Blinkit expansion to 3,500 stores across 100 cities.','business',0),

(20,'Dengue Cases Rise 40% in South India; Tamil Nadu Issues Alert',
'<p><strong>Chennai:</strong> Tamil Nadu has issued a public health alert after dengue fever cases rose by 40 per cent compared to the same period last year, with over 8,000 confirmed cases reported across the state in the first quarter of 2026.</p><p>The State Health Department has directed all district hospitals to keep stocks of platelets and dengue rapid test kits. Mobile fogging teams have been deployed in high-risk areas in Chennai, Coimbatore and Madurai.</p><h2>Hotspots</h2><p>Health officials said waterlogged areas following unseasonal rains have created breeding grounds for Aedes mosquitoes. Citizens have been advised to drain stagnant water around homes and use mosquito repellents.</p>',
'Dengue cases have risen 40% in Tamil Nadu, prompting a public health alert. Mobile fogging units have been deployed in Chennai, Coimbatore and Madurai.','det5.jpg','2026-03-28 14:00:00',8,6,'dengue-cases-rise-40-percent-tamil-nadu-south-india-alert','Dengue cases Tamil Nadu 2026','Dengue Cases Rise 40% in South India; Tamil Nadu Issues Health Alert','dengue fever India, dengue Tamil Nadu, South India health alert, dengue 2026','Tamil Nadu has issued a dengue health alert after cases rose 40% with over 8,000 confirmed infections.','general',0),

(21,'Nita Ambani\'s Cultural Centre Wins UNESCO Award for Cultural Preservation',
'<p><strong>Paris / Mumbai:</strong> The Nita Mukesh Ambani Cultural Centre in Mumbai has been awarded the UNESCO Prix Versailles Cultural Heritage Award for its role in promoting Indian classical arts and providing a platform for traditional performers.</p><p>The award, announced at UNESCO\'s headquarters in Paris, recognises institutions that blend cultural heritage with contemporary design and public accessibility.</p><h2>Arts Hub</h2><p>The centre, which opened in 2023, has hosted over 500 performances including Bharatanatyam, Hindustani classical music, Kathakali and puppet theatre since its inception. It has also launched a scholarship programme for young classical artists.</p>',
'The Nita Mukesh Ambani Cultural Centre in Mumbai has won the UNESCO Prix Versailles Cultural Heritage Award for promoting Indian classical arts.','det6.jpg','2026-03-27 11:00:00',7,8,'nita-ambani-cultural-centre-mumbai-wins-unesco-award','Nita Ambani Cultural Centre UNESCO award','Nita Ambani Cultural Centre Wins UNESCO Cultural Heritage Award','NMACC, UNESCO award India, Mumbai cultural centre, Indian classical arts','Mumbai\'s Nita Mukesh Ambani Cultural Centre won the UNESCO Prix Versailles Cultural Heritage Award.','general',0),

(22,'India Achieves 100% Open Defecation Free Status; PM Declares New Sanitation Milestone',
'<p><strong>New Delhi:</strong> Prime Minister Narendra Modi on Wednesday declared India a 100 per cent Open Defecation Free (ODF) nation, citing verification data collected by an independent survey agency that assessed over 90,000 villages.</p><p>The achievement, under the Swachh Bharat Mission 2.0, comes after the construction of over 12 crore toilets since the programme began in 2014 and the development of functional sanitation infrastructure in all districts.</p><h2>Impact</h2><p>Health surveys show a 60 per cent reduction in diarrhoeal diseases in rural areas since 2014. The PM said the next phase will focus on solid and liquid waste management in rural areas.</p>',
'India achieved 100% Open Defecation Free status under Swachh Bharat Mission 2.0, with over 12 crore toilets built since 2014.','det7.jpg','2026-03-26 10:00:00',1,1,'india-100-percent-odf-swachh-bharat-mission-milestone','India ODF Swachh Bharat mission','India Achieves 100% ODF Status; PM Declares Swachh Bharat Milestone','India ODF, Swachh Bharat Mission, open defecation free, sanitation India','India declared 100% ODF under Swachh Bharat Mission 2.0 after constructing 12 crore toilets since 2014.','general',0),

(23,'Western Ghats Biodiversity Hot Spot Faces New Threat from Mining Expansion',
'<p><strong>Chennai / Bengaluru:</strong> Environmental researchers from the Indian Institute of Science (IISc) have warned that proposed mining lease expansions in Karnataka and Tamil Nadu could threaten critically endangered habitats in the Western Ghats Biodiversity Hotspot.</p><p>The study, published in the journal Current Science, identified 24 proposed mining sites within 10 km of Protected Area boundaries, including Bandipur National Park and the Agasthyamala Biosphere Reserve.</p><h2>Call to Action</h2><p>The researchers called on the Ministry of Environment, Forest and Climate Change to conduct comprehensive environmental impact assessments before clearing any new mining leases in the region. Environmental groups have begun a public petition.</p>',
'Researchers warn that proposed mining expansions near protected areas in Karnataka and Tamil Nadu threaten critically endangered Western Ghats habitats.','det8.jpg','2026-03-25 09:00:00',9,4,'western-ghats-biodiversity-mining-threat-iisc-study','Western Ghats biodiversity mining threat','Western Ghats Biodiversity at Risk from Mining Expansion, Warns IISc Study','Western Ghats, biodiversity mining threat, Karnataka Tamil Nadu environment, IISc study','IISc researchers warned that 24 proposed mining sites near protected areas threaten Western Ghats biodiversity.','general',0),

(24,'NEP 2020 Implementation: 85% of Central Universities Shift to Four-Year Degree',
'<p><strong>New Delhi:</strong> The University Grants Commission (UGC) on Tuesday reported that 85 per cent of central universities and 70 per cent of state universities have successfully transitioned to the four-year undergraduate degree structure mandated by the National Education Policy 2020.</p><p>The UGC Chairman said the transition has brought greater flexibility for students to choose interdisciplinary majors, with 1.4 lakh students opting for dual-degree combinations in their first year under the new structure.</p><h2>Challenges Remain</h2><p>Faculty training and curriculum redesign remain the biggest challenges for many institutions. The UGC has released Rs 2,200 crore for infrastructure upgradation and faculty development under NEP implementation grants.</p>',
'85% of central universities have shifted to the four-year degree structure under NEP 2020, the UGC reported, with 1.4 lakh students choosing dual-degree combinations.','food.jpg','2026-03-24 08:00:00',10,1,'nep-2020-four-year-degree-ugc-central-universities-implementation','NEP 2020 four year degree UGC','NEP 2020: 85% of Central Universities Adopt Four-Year Degree Structure','NEP 2020, four year undergraduate degree, UGC, national education policy India','85% of central universities have implemented the four-year degree under NEP 2020, the UGC reported.','general',0),

(25,'Aamir Khan\'s Next Film Set in 1947 Partition Era; Shooting Begins in Punjab',
'<p><strong>Mumbai:</strong> Actor and filmmaker Aamir Khan announced on Instagram on Monday that his new directorial venture, tentatively titled <em>Azaadi</em>, will be set in the 1947 Partition period and will begin principal photography in Amritsar and Lahore with a Pakistani co-production partner.</p><p>Khan said the film aims to tell "a universal story of human resilience and the tragedy that divided families across the new border."</p><h2>Cast and Scale</h2><p>The film will feature a predominantly newcomer cast with two veteran actors, whose names will be revealed later. The production budget is reported to be Rs 180 crore, making it one of the costliest Bollywood films of 2026.</p>',
'Aamir Khan\'s new directorial film set in the 1947 Partition era begins shooting in Punjab in an India-Pakistan co-production.','sai-kumar.jpg','2026-03-23 20:00:00',7,8,'aamir-khan-azaadi-film-partition-1947-shooting-punjab','Aamir Khan Azaadi film partition','Aamir Khan Announces Partition-Era Film Azaadi; Shooting Begins in Punjab','Aamir Khan, Azaadi film, Bollywood 2026, Partition movie, India Pakistan co-production','Aamir Khan\'s next directorial set in the 1947 Partition begins shooting in Punjab with an India-Pakistan co-production.','general',0);

-- ── Subscribers ─────────────────────────────────────────────
CREATE TABLE IF NOT EXISTS `subscribers` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `email` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `subscribers_email_unique` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ── Indexes for performance ──────────────────────────────────
ALTER TABLE `tbl_news`
  ADD KEY `idx_category_published` (`category_id`, `published_at`),
  ADD KEY `idx_published_id` (`published_at`, `news_id`);

COMMIT;
