-- Phase 2 SEO: Bangladesh keyword-tuned meta_title / meta_description for existing pages.
-- Apply in phpMyAdmin -> hosttiller DB -> Import this file.
-- NOTE: titles intentionally have NO brand suffix; the site appends " — HostTiller".

UPDATE `pages` SET `meta_title` = 'Web Hosting in Bangladesh | Cheap NVMe SSD Hosting', `meta_description` = 'Cheap web hosting in Bangladesh on LiteSpeed NVMe SSD. Free SSL, daily backups, free migration and 99.99% uptime with 24/7 Bangladesh-friendly support.', `updated_at` = NOW() WHERE `slug` = 'web-hosting';

UPDATE `pages` SET `meta_title` = 'WordPress Hosting in Bangladesh | Managed WP on NVMe', `meta_description` = 'Managed WordPress hosting in Bangladesh built for speed. LiteSpeed cache, auto updates, free SSL and daily backups — get more from your WordPress site.', `updated_at` = NOW() WHERE `slug` = 'wordpress-hosting';

UPDATE `pages` SET `meta_title` = 'Buy Domain in Bangladesh | Register & Transfer Domains', `meta_description` = 'Buy a domain name in Bangladesh at competitive prices. Register and transfer domains, get free WHOIS privacy and manage everything from one dashboard.', `updated_at` = NOW() WHERE `slug` = 'domain';

UPDATE `pages` SET `meta_title` = 'VPS Hosting in Bangladesh | Cheap BDIX KVM NVMe VPS', `meta_description` = 'Cheap VPS hosting in Bangladesh with BDIX connectivity. KVM NVMe dedicated cores, instant deployment, full root access and 24/7 support for local low-latency servers.', `updated_at` = NOW() WHERE `slug` = 'vps';

UPDATE `pages` SET `meta_title` = 'Dedicated Server in Bangladesh | Affordable Servers', `meta_description` = 'Affordable dedicated server hosting in Bangladesh and Germany. Full root access, NVMe storage, DDoS protection and 24/7 engineered support.', `updated_at` = NOW() WHERE `slug` = 'dedicated-server';

UPDATE `pages` SET `meta_title` = 'Reseller Hosting in Bangladesh | Wholesale BDIX Hosting', `meta_description` = 'Start a reseller hosting business in Bangladesh. Wholesale hosting with BDIX connectivity, white-label cPanel/WHM, huge margins and daily backups.', `updated_at` = NOW() WHERE `slug` = 'reseller';

UPDATE `pages` SET `meta_title` = 'Root Reseller Hosting in Bangladesh | Full Root', `meta_description` = 'Root reseller hosting for Bangladeshi providers. Run your own hosting business with full root access, WHM and wholesale BDIX server resources.', `updated_at` = NOW() WHERE `slug` = 'root-reseller';

UPDATE `pages` SET `meta_title` = 'Hosting Offers & Promo Codes in Bangladesh | Save Now', `meta_description` = 'Save on hosting in Bangladesh with exclusive offers and promo codes for shared, VPS and reseller plans at HostTiller.', `updated_at` = NOW() WHERE `slug` = 'offer';

UPDATE `pages` SET `meta_title` = 'Network Status & Uptime | Live Hosting Status', `meta_description` = 'Live network status and uptime for HostTiller servers across Bangladesh, USA and Germany.', `updated_at` = NOW() WHERE `slug` = 'server-status';

UPDATE `pages` SET `meta_title` = 'About Us | Cheap Reliable Hosting in Bangladesh', `meta_description` = 'HostTiller is a Bangladeshi web hosting company offering cheap, reliable NVMe SSD hosting, VPS, reseller and dedicated servers with 24/7 support.', `updated_at` = NOW() WHERE `slug` = 'about-us';

UPDATE `pages` SET `meta_title` = 'Blog & Guides | Hosting Tips for Business in Bangladesh', `meta_description` = 'Practical web hosting guides and tips for businesses in Bangladesh — build, launch and grow a faster, safer online presence.', `updated_at` = NOW() WHERE `slug` = 'blog';

UPDATE `pages` SET `meta_title` = 'Contact Us | 24/7 Hosting Support & Sales', `meta_description` = 'Contact HostTiller for cheap web hosting in Bangladesh. 24/7 sales and support for shared hosting, VPS, reseller and dedicated servers.', `updated_at` = NOW() WHERE `slug` = 'contact';

UPDATE `pages` SET `meta_title` = 'Terms & Conditions', `meta_description` = 'Read the HostTiller terms and conditions covering web hosting, VPS, reseller and dedicated server services.', `updated_at` = NOW() WHERE `slug` = 'terms-and-conditions';

UPDATE `pages` SET `meta_title` = 'Privacy Policy', `meta_description` = 'Read the HostTiller privacy policy to understand how we protect your personal data.', `updated_at` = NOW() WHERE `slug` = 'privacy-policy';

UPDATE `pages` SET `meta_title` = 'Knowledgebase | Hosting Help & How-To Guides', `meta_description` = 'Browse the HostTiller knowledgebase for step-by-step guides on hosting, domains, cPanel and resolving common issues.', `updated_at` = NOW() WHERE `slug` = 'knowledgebase';