-- MobiSpec Database Dump
-- Compatible with MySQL 5.7+ / MariaDB 10.3+ / PHP 8.2+
-- Generated: 2026-08-25T18:19:23.531Z

SET FOREIGN_KEY_CHECKS=0;
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";

-- Table structure for `admins`
DROP TABLE IF EXISTS `admins`;
CREATE TABLE `admins` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(100) NOT NULL,
  `email` varchar(191) NOT NULL,
  `password_hash` varchar(255) NOT NULL,
  `role` varchar(50) DEFAULT 'admin',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Default Super Admin: admin / admin123 (Password hashed with PASSWORD_BCRYPT)
INSERT INTO `admins` (`id`, `username`, `email`, `password_hash`, `role`) VALUES
(1, 'admin', 'admin@mobispec.com', '$2y$10$e0MYzXyjpJS7Pd0RVvHwHe92gS4f5uM4yN6Q4G1bZ8.45K8/J9t9m', 'superadmin');

-- Table structure for `brands`
DROP TABLE IF EXISTS `brands`;
CREATE TABLE `brands` (
  `id` varchar(64) NOT NULL,
  `name` varchar(100) NOT NULL,
  `slug` varchar(100) NOT NULL,
  `logo_url` varchar(500) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `origin_country` varchar(100) DEFAULT 'Global',
  `established_year` int(11) DEFAULT 2000,
  `is_popular` tinyint(1) DEFAULT 1,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `slug` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Insert Brands
INSERT INTO `brands` (`id`, `name`, `slug`, `logo_url`, `description`, `origin_country`, `established_year`, `is_popular`) VALUES ('brand-samsung', 'Samsung', 'samsung', 'https://images.unsplash.com/photo-1610945265064-0e34e5519bbf?auto=format&fit=crop&w=120&h=120&q=80', 'South Korean multinational tech giant known for Galaxy S flagship series, foldables, and industry-leading Dynamic AMOLED displays.', 'South Korea', 1938, 1);
INSERT INTO `brands` (`id`, `name`, `slug`, `logo_url`, `description`, `origin_country`, `established_year`, `is_popular`) VALUES ('brand-apple', 'Apple', 'apple', 'https://images.unsplash.com/photo-1611186871348-b1ce696e52c9?auto=format&fit=crop&w=120&h=120&q=80', 'American consumer electronics pioneer renowned for iPhones, iOS, A-series/M-series silicon, and ecosystem synergy.', 'United States', 1976, 1);
INSERT INTO `brands` (`id`, `name`, `slug`, `logo_url`, `description`, `origin_country`, `established_year`, `is_popular`) VALUES ('brand-xiaomi', 'Xiaomi', 'xiaomi', 'https://images.unsplash.com/photo-1598327105666-5b89351aff97?auto=format&fit=crop&w=120&h=120&q=80', 'Leading global brand offering feature-rich smartphones with aggressive price-to-performance ratio and Leica optical partnerships.', 'China', 2010, 1);
INSERT INTO `brands` (`id`, `name`, `slug`, `logo_url`, `description`, `origin_country`, `established_year`, `is_popular`) VALUES ('brand-google', 'Google Pixel', 'google', 'https://images.unsplash.com/photo-1574944985070-8f3ebc6b79d2?auto=format&fit=crop&w=120&h=120&q=80', 'Creator of Android providing pure Google experience, computational photography leadership, and 7 years of OS upgrades.', 'United States', 1998, 1);
INSERT INTO `brands` (`id`, `name`, `slug`, `logo_url`, `description`, `origin_country`, `established_year`, `is_popular`) VALUES ('brand-oneplus', 'OnePlus', 'oneplus', 'https://images.unsplash.com/photo-1546868871-7041f2a55e12?auto=format&fit=crop&w=120&h=120&q=80', 'Flagship-killer legacy brand known for ultra-fast SUPERVOOC charging, smooth OxygenOS, and Hasselblad color science.', 'China', 2013, 1);
INSERT INTO `brands` (`id`, `name`, `slug`, `logo_url`, `description`, `origin_country`, `established_year`, `is_popular`) VALUES ('brand-vivo', 'Vivo', 'vivo', 'https://images.unsplash.com/photo-1580910051074-3eb694886505?auto=format&fit=crop&w=120&h=120&q=80', 'Smartphone innovator leading mobile portrait and zoom imaging through ZEISS T* coated optics and custom V-series imaging chips.', 'China', 2009, 1);
INSERT INTO `brands` (`id`, `name`, `slug`, `logo_url`, `description`, `origin_country`, `established_year`, `is_popular`) VALUES ('brand-nothing', 'Nothing', 'nothing', 'https://images.unsplash.com/photo-1592899677977-9c10ca588bbd?auto=format&fit=crop&w=120&h=120&q=80', 'London-based design-first tech company famous for transparent aesthetic, interactive Glyph Interface, and bloatware-free Nothing OS.', 'United Kingdom', 2020, 1);
INSERT INTO `brands` (`id`, `name`, `slug`, `logo_url`, `description`, `origin_country`, `established_year`, `is_popular`) VALUES ('brand-realme', 'Realme', 'realme', 'https://images.unsplash.com/photo-1567581935884-3349723552ca?auto=format&fit=crop&w=120&h=120&q=80', 'Youth-focused brand offering high-wattage fast charging and sleek flagship-grade displays in competitive mid-range tiers.', 'China', 2018, 0);

-- Table structure for `phones`
DROP TABLE IF EXISTS `phones`;
CREATE TABLE `phones` (
  `id` varchar(64) NOT NULL,
  `brand_id` varchar(64) NOT NULL,
  `name` varchar(150) NOT NULL,
  `model_number` varchar(100) NOT NULL,
  `slug` varchar(191) NOT NULL,
  `release_date` varchar(50) DEFAULT NULL,
  `availability` varchar(50) DEFAULT 'Available',
  `status` varchar(50) DEFAULT 'Published',
  `is_featured` tinyint(1) DEFAULT 0,
  `is_trending` tinyint(1) DEFAULT 0,
  `is_upcoming` tinyint(1) DEFAULT 0,
  `official_price` decimal(12,2) DEFAULT 0.00,
  `current_price` decimal(12,2) DEFAULT 0.00,
  `old_price` decimal(12,2) DEFAULT NULL,
  `currency` varchar(10) DEFAULT '৳',
  `discount_percent` int(11) DEFAULT 0,
  `price_updated_at` varchar(50) DEFAULT NULL,
  `price_source` varchar(255) DEFAULT NULL,
  `display_type` varchar(255) DEFAULT NULL,
  `display_size` varchar(100) DEFAULT NULL,
  `resolution` varchar(150) DEFAULT NULL,
  `refresh_rate` varchar(50) DEFAULT '120Hz',
  `peak_brightness` varchar(100) DEFAULT NULL,
  `protection` varchar(150) DEFAULT NULL,
  `hdr_support` varchar(100) DEFAULT NULL,
  `touch_sampling` varchar(100) DEFAULT NULL,
  `chipset` varchar(255) DEFAULT NULL,
  `cpu` varchar(255) DEFAULT NULL,
  `gpu` varchar(150) DEFAULT NULL,
  `ram_default` varchar(50) DEFAULT '8GB',
  `ram_type` varchar(50) DEFAULT 'LPDDR5X',
  `storage_default` varchar(50) DEFAULT '128GB',
  `storage_type` varchar(50) DEFAULT 'UFS 4.0',
  `card_slot` varchar(50) DEFAULT 'No',
  `main_camera` text DEFAULT NULL,
  `ultrawide` text DEFAULT NULL,
  `telephoto` text DEFAULT NULL,
  `macro` varchar(255) DEFAULT NULL,
  `front_camera` varchar(255) DEFAULT NULL,
  `ois_support` varchar(150) DEFAULT NULL,
  `video_recording` text DEFAULT NULL,
  `camera_features` text DEFAULT NULL,
  `battery_capacity` varchar(100) DEFAULT '5000 mAh',
  `charging_speed` varchar(150) DEFAULT NULL,
  `wireless_charging` varchar(100) DEFAULT 'No',
  `reverse_charging` varchar(100) DEFAULT 'No',
  `five_g` varchar(100) DEFAULT '5G SA/NSA',
  `four_g` varchar(100) DEFAULT 'LTE',
  `wifi` varchar(150) DEFAULT NULL,
  `bluetooth` varchar(100) DEFAULT '5.3',
  `nfc` varchar(50) DEFAULT 'Yes',
  `gps` varchar(150) DEFAULT NULL,
  `usb` varchar(100) DEFAULT 'Type-C',
  `fingerprint` varchar(150) DEFAULT 'Under Display',
  `face_unlock` varchar(100) DEFAULT 'Yes',
  `sensors` text DEFAULT NULL,
  `dimensions` varchar(150) DEFAULT NULL,
  `weight` varchar(100) DEFAULT NULL,
  `ip_rating` varchar(100) DEFAULT 'IP68',
  `glass_protection` varchar(150) DEFAULT NULL,
  `materials` varchar(255) DEFAULT NULL,
  `colors_json` json DEFAULT NULL,
  `operating_system` varchar(100) DEFAULT 'Android 14',
  `custom_ui` varchar(100) DEFAULT NULL,
  `update_policy` varchar(255) DEFAULT NULL,
  `main_image` varchar(500) DEFAULT NULL,
  `thumbnail` varchar(500) DEFAULT NULL,
  `gallery_images_json` json DEFAULT NULL,
  `short_description` text DEFAULT NULL,
  `full_description` longtext DEFAULT NULL,
  `key_features_json` json DEFAULT NULL,
  `pros_json` json DEFAULT NULL,
  `cons_json` json DEFAULT NULL,
  `verdict` text DEFAULT NULL,
  `seo_title` varchar(255) DEFAULT NULL,
  `meta_description` text DEFAULT NULL,
  `focus_keyword` varchar(255) DEFAULT NULL,
  `canonical_url` varchar(500) DEFAULT NULL,
  `variants_json` json DEFAULT NULL,
  `faqs_json` json DEFAULT NULL,
  `price_history_json` json DEFAULT NULL,
  `related_phone_ids_json` json DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `slug` (`slug`),
  KEY `brand_id` (`brand_id`),
  KEY `current_price` (`current_price`),
  KEY `is_featured` (`is_featured`),
  KEY `is_trending` (`is_trending`),
  KEY `is_upcoming` (`is_upcoming`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Insert Phones
INSERT INTO `phones` (
  `id`, `brand_id`, `name`, `model_number`, `slug`, `release_date`, `availability`, `status`, `is_featured`, `is_trending`, `is_upcoming`,
  `official_price`, `current_price`, `old_price`, `currency`, `discount_percent`, `price_updated_at`, `price_source`,
  `display_type`, `display_size`, `resolution`, `refresh_rate`, `peak_brightness`, `protection`, `hdr_support`, `touch_sampling`,
  `chipset`, `cpu`, `gpu`, `ram_default`, `ram_type`, `storage_default`, `storage_type`, `card_slot`,
  `main_camera`, `ultrawide`, `telephoto`, `macro`, `front_camera`, `ois_support`, `video_recording`, `camera_features`,
  `battery_capacity`, `charging_speed`, `wireless_charging`, `reverse_charging`,
  `five_g`, `four_g`, `wifi`, `bluetooth`, `nfc`, `gps`, `usb`,
  `fingerprint`, `face_unlock`, `sensors`,
  `dimensions`, `weight`, `ip_rating`, `glass_protection`, `materials`, `colors_json`,
  `operating_system`, `custom_ui`, `update_policy`,
  `main_image`, `thumbnail`, `gallery_images_json`,
  `short_description`, `full_description`, `key_features_json`, `pros_json`, `cons_json`, `verdict`,
  `seo_title`, `meta_description`, `focus_keyword`, `canonical_url`,
  `variants_json`, `faqs_json`, `price_history_json`, `related_phone_ids_json`
) VALUES (
  'phone-s24-ultra', 'brand-samsung', 'Galaxy S24 Ultra', 'SM-S928B/DS', 'samsung-galaxy-s24-ultra', '2024-01-31', 'Available', 'Published', 1, 1, 0,
  184999, 169999, 184999, '৳', 8, '2024-08-15', 'Official Samsung Bangladesh Store & Authorized Resellers',
  'Dynamic LTPO AMOLED 2X, 120Hz, HDR10+, 2600 nits (peak)', '6.8 inches (~89.8% screen-to-body ratio)', '1440 x 3120 pixels, 19.5:9 ratio (~505 ppi density)', '120Hz LTPO (1-120Hz)', '2600 nits', 'Corning Gorilla Armor (Anti-reflective 75% reduction)', 'HDR10+, Always-on display', '240Hz Game Mode',
  'Qualcomm SM8650-AC Snapdragon 8 Gen 3 for Galaxy (4 nm)', '8-core (1x3.39GHz Cortex-X4 & 3x3.1GHz Cortex-A720 & 2x2.9GHz Cortex-A720 & 2x2.2GHz Cortex-A520)', 'Adreno 750 (1000 MHz)', '12GB', 'LPDDR5X', '256GB', 'UFS 4.0', 'No',
  '200 MP, f/1.7, 24mm (wide), 1/1.3", 0.6µm, multi-directional PDAF, Laser AF, OIS', '12 MP, f/2.2, 13mm, 120˚ (ultrawide), 1/2.55", 1.4µm, Dual Pixel PDAF, Super Steady video', '50 MP, f/3.4, 111mm (periscope telephoto), 1/2.52", 0.7µm, PDAF, OIS, 5x optical zoom + 10 MP, f/2.4, 67mm (telephoto), 1/3.52", 1.12µm, Dual Pixel PDAF, OIS, 3x optical zoom', 'Automatic via Ultrawide autofocus', '12 MP, f/2.2, 26mm (wide), Dual Pixel PDAF', 'Yes (Main + 3x Telephoto + 5x Periscope Telephoto)', '8K@24/30fps, 4K@30/60/120fps, 1080p@30/60/240fps, HDR10+, stereo sound rec., gyro-EIS', 'Galaxy AI Photo Assist, Super HDR preview, 100x Space Zoom, Expert RAW',
  '5000 mAh non-removable Li-Ion', '45W wired, PD3.0, 65% in 30 min (advertised)', '15W wireless (Qi/PMA)', '4.5W reverse wireless (Wireless PowerShare)',
  '5G SA/NSA/Sub6/mmWave', 'LTE-A (up to 7CA), Cat20', 'Wi-Fi 802.11 a/b/g/n/ac/6e/7, tri-band, Wi-Fi Direct', '5.3, A2DP, LE', 'Yes', 'GPS, GLONASS, BDS, GALILEO, QZSS', 'USB Type-C 3.2, DisplayPort 1.2, OTG',
  'Ultrasonic (under display)', '2D Face Recognition', 'Accelerometer, Gyro, Proximity, Compass, Barometer, Ultra Wideband (UWB), Samsung DeX',
  '162.3 x 79.0 x 8.6 mm (6.39 x 3.11 x 0.34 in)', '232 g (8.18 oz)', 'IP68 dust/water resistant (up to 1.5m for 30 mins)', 'Corning Gorilla Armor front glass, Gorilla Glass back', 'Titanium frame (Grade 2), Glass front and back, Integrated S-Pen with Bluetooth', '["Titanium Gray","Titanium Black","Titanium Violet","Titanium Yellow"]',
  'Android 14, upgradable to Android 21', 'One UI 6.1.1 (Galaxy AI suite)', '7 major Android OS upgrades, 7 years security updates',
  'https://images.unsplash.com/photo-1610945265064-0e34e5519bbf?auto=format&fit=crop&w=800&q=80', 'https://images.unsplash.com/photo-1610945265064-0e34e5519bbf?auto=format&fit=crop&w=400&q=80', '["https://images.unsplash.com/photo-1610945265064-0e34e5519bbf?auto=format&fit=crop&w=800&q=80","https://images.unsplash.com/photo-1592899677977-9c10ca588bbd?auto=format&fit=crop&w=800&q=80","https://images.unsplash.com/photo-1567581935884-3349723552ca?auto=format&fit=crop&w=800&q=80"]',
  'The definitive 2024 Android powerhouse featuring titanium durability, anti-reflective Gorilla Armor, integrated S-Pen, and 7 years of promised updates.', 'Samsung Galaxy S24 Ultra sets the high-water benchmark for flagship capability with its Snapdragon 8 Gen 3 for Galaxy processor, flat titanium chassis, and groundbreaking anti-reflective Corning Gorilla Armor display that cuts ambient reflections by 75%. Combined with quad-camera versatility led by a 200MP sensor and a dedicated 5x 50MP periscope zoom, it remains an uncompromising productivity and media powerhouse.', '["Corning Gorilla Armor with revolutionary 75% glare reduction","200MP Main + 50MP 5x Optical Periscope Zoom Quad-Camera","Integrated S-Pen stylus with Bluetooth air gestures","7 years of guaranteed Android OS & security patch updates","Custom Snapdragon 8 Gen 3 for Galaxy with larger vapor chamber cooling"]', '["Class-leading glare reduction on flat 6.8-inch Dynamic AMOLED panel","Exceptional camera versatility with natural 5x optical telephoto resolution","Titanium frame adds structural rigidity without increasing weight","Unmatched software longevity with 7 years of operating system support","Integrated S-Pen adds true productivity for notes and signature capture"]', '["Bulky squared-off corners can feel sharp during one-handed use","45W wired charging lags behind competitors offering 100W+","Hefty 232g chassis in pocket"]', 'The Samsung Galaxy S24 Ultra is the most complete, versatile ultra-flagship on the market, combining peak productivity hardware, industry-leading anti-glare display tech, and 7-year software assurance.',
  'Samsung Galaxy S24 Ultra Price in Bangladesh & Full Specifications | MobiSpec', 'Samsung Galaxy S24 Ultra official price in Bangladesh, detailed specifications, 200MP camera test, battery endurance score, display review, and comparisons.', 'Samsung Galaxy S24 Ultra price in Bangladesh', 'https://mobispec.com/phone/samsung-galaxy-s24-ultra',
  '[{"id":"v1","ram":"12GB","storage":"256GB","price":169999,"old_price":184999,"color":"Titanium Gray","sku":"SM-S928B-256","availability":"Available"},{"id":"v2","ram":"12GB","storage":"512GB","price":189999,"old_price":204999,"color":"Titanium Black","sku":"SM-S928B-512","availability":"Available"},{"id":"v3","ram":"12GB","storage":"1TB","price":219999,"color":"Titanium Violet","sku":"SM-S928B-1TB","availability":"Available"}]', '[{"question":"What is the current official price of Samsung Galaxy S24 Ultra in Bangladesh?","answer":"The official price for the base 12GB/256GB variant starts at ৳169,999 (down from ৳184,999), while the 512GB variant is priced at ৳189,999."},{"question":"Does Samsung Galaxy S24 Ultra have an anti-reflective display?","answer":"Yes, it is the first smartphone equipped with Corning Gorilla Armor glass, which cuts ambient screen reflections by up to 75% for unmatched outdoor visibility."},{"question":"How many Android OS updates will Galaxy S24 Ultra receive?","answer":"Samsung guarantees 7 years of major Android OS upgrades (through Android 21) and 7 years of regular security patches."},{"question":"Does the S24 Ultra support an external SD card?","answer":"No, the S24 Ultra does not feature a microSD card slot. Internal storage options are 256GB, 512GB, and 1TB."}]', '[{"date":"2024-01-31","price":184999,"note":"Launch Price"},{"date":"2024-05-10","price":177999,"note":"Mid-year promo"},{"date":"2024-08-15","price":169999,"note":"Official discount"}]', '["phone-iphone-16-pro-max","phone-pixel-9-pro-xl","phone-xiaomi-14-ultra"]'
);
INSERT INTO `phones` (
  `id`, `brand_id`, `name`, `model_number`, `slug`, `release_date`, `availability`, `status`, `is_featured`, `is_trending`, `is_upcoming`,
  `official_price`, `current_price`, `old_price`, `currency`, `discount_percent`, `price_updated_at`, `price_source`,
  `display_type`, `display_size`, `resolution`, `refresh_rate`, `peak_brightness`, `protection`, `hdr_support`, `touch_sampling`,
  `chipset`, `cpu`, `gpu`, `ram_default`, `ram_type`, `storage_default`, `storage_type`, `card_slot`,
  `main_camera`, `ultrawide`, `telephoto`, `macro`, `front_camera`, `ois_support`, `video_recording`, `camera_features`,
  `battery_capacity`, `charging_speed`, `wireless_charging`, `reverse_charging`,
  `five_g`, `four_g`, `wifi`, `bluetooth`, `nfc`, `gps`, `usb`,
  `fingerprint`, `face_unlock`, `sensors`,
  `dimensions`, `weight`, `ip_rating`, `glass_protection`, `materials`, `colors_json`,
  `operating_system`, `custom_ui`, `update_policy`,
  `main_image`, `thumbnail`, `gallery_images_json`,
  `short_description`, `full_description`, `key_features_json`, `pros_json`, `cons_json`, `verdict`,
  `seo_title`, `meta_description`, `focus_keyword`, `canonical_url`,
  `variants_json`, `faqs_json`, `price_history_json`, `related_phone_ids_json`
) VALUES (
  'phone-iphone-16-pro-max', 'brand-apple', 'iPhone 16 Pro Max', 'A3296', 'apple-iphone-16-pro-max', '2024-09-20', 'Available', 'Published', 1, 1, 0,
  199999, 194999, 199999, '৳', 2, '2024-09-25', 'Apple Authorized Reseller Network',
  'LTPO Super Retina XDR OLED, 120Hz, HDR10, Dolby Vision, 2000 nits (peak)', '6.9 inches (~91.4% screen-to-body ratio)', '1320 x 2868 pixels, 19.5:9 ratio (~460 ppi density)', '120Hz ProMotion', '2000 nits', 'Ceramic Shield glass (latest gen 2x tougher)', 'HDR10, Dolby Vision, Dynamic Island', '240Hz touch response',
  'Apple A18 Pro (3 nm)', '6-core (2x4.04 GHz performance + 4x efficiency)', 'Apple GPU (6-core graphics with hardware Ray Tracing)', '8GB', 'LPDDR5X unified memory', '256GB', 'NVMe', 'No',
  '48 MP, f/1.78, 24mm (wide), 1/1.28", 1.22µm, dual pixel PDAF, sensor-shift OIS (2nd gen)', '48 MP, f/2.2, 13mm, 120˚ (ultrawide), 0.7µm, dual pixel PDAF, macro photography', '12 MP, f/2.8, 120mm (periscope telephoto), 1/3.06", 1.12µm, dual pixel PDAF, 3D sensor-shift OIS, 5x optical zoom', '48MP Macro via Ultrawide sensor', '12 MP, f/1.9, 23mm (wide), 1/3.6", PDAF, SL 3D (depth/biometrics)', 'Yes (2nd Gen Sensor-shift OIS & 3D Telephoto OIS)', '4K@24/25/30/60/100/120fps Dolby Vision HDR, 1080p@25/30/60/120/240fps, ProRes 4K120fps, Spatial Video', 'Camera Control capacitive button, Photographic Styles 2.0, Studio-quality 4-mic array, Audio Mix',
  '4685 mAh non-removable Li-Ion', 'Up to 30W wired, 50% in 30 min (advertised)', '25W MagSafe wireless, 15W Qi2', '4.5W wired reverse charging via USB-C',
  '5G SA/NSA/Sub6/mmWave', 'LTE Cat20', 'Wi-Fi 802.11 a/b/g/n/ac/6e/7, dual-band, hotspot', '5.3, A2DP, LE', 'Yes (Apple Pay & NFC tags)', 'Precision dual-frequency GPS (L1+L5), GLONASS, GALILEO, BDS, QZSS, NavIC', 'USB Type-C 3.2 Gen 2 (up to 10Gbps), DisplayPort',
  'None (Face ID)', 'TrueDepth 3D Face ID biometric system', 'LiDAR scanner, Accelerometer, Gyro, Proximity, Compass, Barometer, Emergency SOS via satellite, Crash Detection',
  '163.0 x 77.6 x 8.25 mm (6.42 x 3.06 x 0.32 in)', '227 g (8.01 oz)', 'IP68 dust/water resistant (up to 6m for 30 mins)', 'Ceramic Shield front (2024 Gen), Textured matte glass back', 'Grade 5 Titanium frame with micro-blasted texture', '["Desert Titanium","Natural Titanium","White Titanium","Black Titanium"]',
  'iOS 18', 'Apple Intelligence', '5-6 years of guaranteed iOS major upgrades and security patches',
  'https://images.unsplash.com/photo-1510557880182-3d4d3cba35a5?auto=format&fit=crop&w=800&q=80', 'https://images.unsplash.com/photo-1510557880182-3d4d3cba35a5?auto=format&fit=crop&w=400&q=80', '["https://images.unsplash.com/photo-1510557880182-3d4d3cba35a5?auto=format&fit=crop&w=800&q=80","https://images.unsplash.com/photo-1611186871348-b1ce696e52c9?auto=format&fit=crop&w=800&q=80"]',
  'Apple’s largest display ever at 6.9-inches, featuring A18 Pro silicon, new Camera Control capacitive button, and 4K120fps Dolby Vision video.', 'The iPhone 16 Pro Max stretches screen boundaries with a massive 6.9-inch Super Retina XDR display framed by the slimmest borders on any Apple product. Powered by the 3nm A18 Pro chip, it introduces dedicated hardware Camera Control, upgraded 48MP Ultrawide macro capabilities, and 4K 120fps ProRes recording for professional filmmakers.', '["Industry-leading 6.9-inch ProMotion OLED with razor-thin borders","A18 Pro 3nm chipset with desktop-grade 6-core GPU","New Camera Control button for instant zoom and exposure adjustments","4K 120fps Dolby Vision video recording with studio 4-mic Audio Mix","Grade 5 Titanium chassis with enhanced thermal graphite dissipation"]', '["Unrivaled battery life with large battery and A18 Pro efficiency","Best-in-class video recording with 4K120fps Dolby Vision capture","48MP Ultrawide sensor brings remarkable detail to wide and macro shots","Ultra-thin uniform display bezels provide exceptional immersive viewing","Seamless USB-C 10Gbps throughput and external SSD recording"]', '["Hefty dimensions require two hands for comfortable navigation","Charging speeds remain conservative compared to Android flagships","High starting price point"]', 'iPhone 16 Pro Max represents the pinnacle of mobile video production, raw performance, and battery endurance in a stunning titanium form factor.',
  'Apple iPhone 16 Pro Max Price in Bangladesh & Specifications | MobiSpec', 'Check iPhone 16 Pro Max official price in Bangladesh, full tech specs, A18 Pro benchmark scores, 4K120fps camera features, battery life, and comparisons.', 'iPhone 16 Pro Max price in Bangladesh', 'https://mobispec.com/phone/apple-iphone-16-pro-max',
  '[{"id":"v1","ram":"8GB","storage":"256GB","price":194999,"old_price":199999,"color":"Desert Titanium","sku":"A3296-256","availability":"Available"},{"id":"v2","ram":"8GB","storage":"512GB","price":224999,"color":"Natural Titanium","sku":"A3296-512","availability":"Available"},{"id":"v3","ram":"8GB","storage":"1TB","price":254999,"color":"Black Titanium","sku":"A3296-1TB","availability":"Available"}]', '[{"question":"What is the price of iPhone 16 Pro Max in Bangladesh?","answer":"The official starting price for iPhone 16 Pro Max (256GB) is ৳194,999."},{"question":"What does the new Camera Control button do on iPhone 16 Pro Max?","answer":"The capacitive Camera Control button lets you click to launch the camera, light-press to focus and adjust exposure, slide your finger to zoom or adjust depth, and press to record."},{"question":"Does iPhone 16 Pro Max shoot 4K 120fps video?","answer":"Yes, both in standard video and ProRes recording modes, allowing cinema-grade slow motion playback at 24fps or 30fps without loss of resolution."}]', '[{"date":"2024-09-20","price":199999,"note":"Launch Price"},{"date":"2024-09-25","price":194999,"note":"Market normalization"}]', '["phone-s24-ultra","phone-pixel-9-pro-xl"]'
);
INSERT INTO `phones` (
  `id`, `brand_id`, `name`, `model_number`, `slug`, `release_date`, `availability`, `status`, `is_featured`, `is_trending`, `is_upcoming`,
  `official_price`, `current_price`, `old_price`, `currency`, `discount_percent`, `price_updated_at`, `price_source`,
  `display_type`, `display_size`, `resolution`, `refresh_rate`, `peak_brightness`, `protection`, `hdr_support`, `touch_sampling`,
  `chipset`, `cpu`, `gpu`, `ram_default`, `ram_type`, `storage_default`, `storage_type`, `card_slot`,
  `main_camera`, `ultrawide`, `telephoto`, `macro`, `front_camera`, `ois_support`, `video_recording`, `camera_features`,
  `battery_capacity`, `charging_speed`, `wireless_charging`, `reverse_charging`,
  `five_g`, `four_g`, `wifi`, `bluetooth`, `nfc`, `gps`, `usb`,
  `fingerprint`, `face_unlock`, `sensors`,
  `dimensions`, `weight`, `ip_rating`, `glass_protection`, `materials`, `colors_json`,
  `operating_system`, `custom_ui`, `update_policy`,
  `main_image`, `thumbnail`, `gallery_images_json`,
  `short_description`, `full_description`, `key_features_json`, `pros_json`, `cons_json`, `verdict`,
  `seo_title`, `meta_description`, `focus_keyword`, `canonical_url`,
  `variants_json`, `faqs_json`, `price_history_json`, `related_phone_ids_json`
) VALUES (
  'phone-pixel-9-pro-xl', 'brand-google', 'Pixel 9 Pro XL', 'GEC77', 'google-pixel-9-pro-xl', '2024-08-22', 'Available', 'Published', 1, 0, 0,
  154999, 148999, 154999, '৳', 4, '2024-09-10', 'Authorized Import & Retail Channels',
  'Super Actua LTPO OLED, 120Hz, HDR10+, 3000 nits (peak)', '6.8 inches (~88.0% screen-to-body ratio)', '1344 x 2992 pixels, 20:9 ratio (~486 ppi density)', '120Hz LTPO (1-120Hz)', '3000 nits', 'Corning Gorilla Glass Victus 2', 'HDR10+, Ultra HDR', '240Hz',
  'Google Tensor G4 (4 nm) with Titan M2 security coprocessor', '8-core (1x3.1 GHz Cortex-X4 & 3x2.6 GHz Cortex-A720 & 4x1.92 GHz Cortex-A520)', 'Mali-G715 MC7', '16GB', 'LPDDR5X', '128GB', 'UFS 3.1', 'No',
  '50 MP, f/1.68, 25mm (wide), 1/1.31", 1.2µm, dual pixel PDAF, multi-zone Laser AF, OIS', '48 MP, f/1.7, 123˚ (ultrawide), 1/2.55", dual pixel PDAF, macro focus', '48 MP, f/2.8, 113mm (periscope telephoto), 1/2.55", dual pixel PDAF, OIS, 5x optical zoom, 30x Super Res Zoom', 'Dedicated Macro Focus via 48MP sensor', '42 MP, f/2.2, 17mm (ultrawide), dual pixel PDAF', 'Yes (Main & Telephoto Dual OIS)', '8K@30fps (via Video Boost cloud processing), 4K@24/30/60fps, 1080p@24/30/60/120/240fps, gyro-EIS, OIS, 10-bit HDR', 'Add Me, Best Take, Magic Editor, Night Sight Video, Audio Magic Eraser',
  '5060 mAh non-removable Li-Ion', '37W wired, 70% in 30 min (advertised)', '23W wireless (with Pixel Stand 2nd gen), 12W standard Qi', 'Battery Share reverse wireless',
  '5G SA/NSA/Sub6/mmWave', 'LTE-A (up to 4CA), Cat20', 'Wi-Fi 802.11 a/b/g/n/ac/6e/7, tri-band', '5.3, A2DP, LE, aptX HD', 'Yes', 'Dual-band GPS, GLONASS, GALILEO, BDS, QZSS, NavIC', 'USB Type-C 3.2',
  'Ultrasonic (under display)', 'Class 3 biometric Face Unlock', 'Thermometer (skin & object temperature), Accelerometer, Gyro, Proximity, Compass, Barometer, Ultra Wideband (UWB)',
  '162.8 x 76.6 x 8.5 mm (6.41 x 3.02 x 0.33 in)', '221 g (7.80 oz)', 'IP68 dust/water resistant (up to 1.5m for 30 mins)', 'Gorilla Glass Victus 2 (front & back)', 'Satin polished aluminum frame, Matte back glass, Camera Visor bar', '["Obsidian","Porcelain","Hazel","Rose Quartz"]',
  'Android 14, upgradable to Android 21', 'Pixel UI with Gemini Nano on-device AI', '7 years of guaranteed OS, security, and Pixel Feature Drops',
  'https://images.unsplash.com/photo-1598327105666-5b89351aff97?auto=format&fit=crop&w=800&q=80', 'https://images.unsplash.com/photo-1598327105666-5b89351aff97?auto=format&fit=crop&w=400&q=80', '["https://images.unsplash.com/photo-1598327105666-5b89351aff97?auto=format&fit=crop&w=800&q=80"]',
  'Google’s ultimate camera flagship packing 16GB RAM standard, Gemini Nano AI, 3000-nit Actua display, and 7 years of Pixel Feature Drops.', 'Pixel 9 Pro XL redefines industrial build quality with polished flat rails, an updated camera bar visor, and a blistering 3000-nit Super Actua display. Engineered around Google Tensor G4 with 16GB RAM dedicated to on-device Gemini AI, it delivers computational features like "Add Me" photo composition and Video Boost 8K processing.', '["3000-nit Super Actua LTPO OLED with class-leading outdoor visibility","16GB RAM standard for uninterrupted on-device Gemini AI workloads","42MP ultrawide front camera with autofocus for group selfies","Groundbreaking AI photography tools: Add Me, Zoom Enhance, Magic Editor","Built-in temperature sensor and 7 years of full platform support"]', '["Best point-and-shoot consistency across difficult lighting","Fast and accurate ultrasonic fingerprint scanner upgrade","Premium matte glass back resists fingerprint smudges effortlessly","Class-leading 7 years of software and parts support roadmap"]', '["Tensor G4 raw gaming benchmark performance trails Snapdragon 8 Gen 3","128GB base storage is low for this tier"]', 'The Pixel 9 Pro XL is the smartest camera phone you can buy, blending computational photography supremacy with clean, update-guaranteed software.',
  'Google Pixel 9 Pro XL Price in Bangladesh & Specs | MobiSpec', 'Google Pixel 9 Pro XL price in Bangladesh, Tensor G4 performance test, 50MP triple camera review, 3000-nit Super Actua display analysis.', 'Pixel 9 Pro XL price in Bangladesh', 'https://mobispec.com/phone/google-pixel-9-pro-xl',
  '[{"id":"v1","ram":"16GB","storage":"128GB","price":148999,"old_price":154999,"color":"Obsidian","sku":"GEC77-128","availability":"Available"},{"id":"v2","ram":"16GB","storage":"256GB","price":162999,"color":"Porcelain","sku":"GEC77-256","availability":"Available"},{"id":"v3","ram":"16GB","storage":"512GB","price":179999,"color":"Hazel","sku":"GEC77-512","availability":"Available"}]', '[{"question":"What is the price of Google Pixel 9 Pro XL in Bangladesh?","answer":"The starting price for Pixel 9 Pro XL (16GB/128GB) is approximately ৳148,999 in the Bangladesh market."},{"question":"Does Pixel 9 Pro XL have an ultrasonic fingerprint scanner?","answer":"Yes, Google upgraded from optical to a responsive Qualcomm 3D Sonic Gen 2 ultrasonic sensor under the glass."}]', '[{"date":"2024-08-22","price":154999,"note":"Launch Price"},{"date":"2024-09-10","price":148999,"note":"Market adjustment"}]', '["phone-s24-ultra","phone-iphone-16-pro-max","phone-oneplus-12"]'
);
INSERT INTO `phones` (
  `id`, `brand_id`, `name`, `model_number`, `slug`, `release_date`, `availability`, `status`, `is_featured`, `is_trending`, `is_upcoming`,
  `official_price`, `current_price`, `old_price`, `currency`, `discount_percent`, `price_updated_at`, `price_source`,
  `display_type`, `display_size`, `resolution`, `refresh_rate`, `peak_brightness`, `protection`, `hdr_support`, `touch_sampling`,
  `chipset`, `cpu`, `gpu`, `ram_default`, `ram_type`, `storage_default`, `storage_type`, `card_slot`,
  `main_camera`, `ultrawide`, `telephoto`, `macro`, `front_camera`, `ois_support`, `video_recording`, `camera_features`,
  `battery_capacity`, `charging_speed`, `wireless_charging`, `reverse_charging`,
  `five_g`, `four_g`, `wifi`, `bluetooth`, `nfc`, `gps`, `usb`,
  `fingerprint`, `face_unlock`, `sensors`,
  `dimensions`, `weight`, `ip_rating`, `glass_protection`, `materials`, `colors_json`,
  `operating_system`, `custom_ui`, `update_policy`,
  `main_image`, `thumbnail`, `gallery_images_json`,
  `short_description`, `full_description`, `key_features_json`, `pros_json`, `cons_json`, `verdict`,
  `seo_title`, `meta_description`, `focus_keyword`, `canonical_url`,
  `variants_json`, `faqs_json`, `price_history_json`, `related_phone_ids_json`
) VALUES (
  'phone-oneplus-12', 'brand-oneplus', 'OnePlus 12', 'CPH2581', 'oneplus-12', '2024-01-23', 'Available', 'Published', 0, 1, 0,
  94999, 88999, 94999, '৳', 6, '2024-07-20', 'Official OnePlus Bangladesh Distribution',
  'LTPO4 AMOLED, 1B colors, 120Hz, Dolby Vision, HDR10+, 4500 nits (peak)', '6.82 inches (~90.8% screen-to-body ratio)', '1440 x 3168 pixels (~510 ppi density)', '120Hz LTPO 4.0', '4500 nits', 'Corning Gorilla Glass Victus 2', 'Dolby Vision, HDR10+, Aqua Touch wet finger tech', '2160Hz Instant Touch',
  'Qualcomm Snapdragon 8 Gen 3 (4 nm)', '8-core (1x3.3 GHz Cortex-X4 & 5x3.2 GHz Cortex-A720 & 2x2.3 GHz Cortex-A520)', 'Adreno 750', '12GB', 'LPDDR5X', '256GB', 'UFS 4.0', 'No',
  '50 MP, f/1.6, 23mm (wide), 1/1.43", 1.12µm, multi-directional PDAF, OIS (Sony LYT-808)', '48 MP, f/2.2, 14mm, 114˚ (ultrawide), 1/2.0", 0.8µm, PDAF (Sony IMX581)', '64 MP, f/2.6, 70mm (periscope telephoto), 1/2.0", 0.7µm, PDAF, OIS, 3x optical zoom, 6x in-sensor zoom (OmniVision OV64B)', 'Automatic via 48MP ultrawide autofocus', '32 MP, f/2.4, 21mm (wide), 1/2.74", 0.8µm', 'Yes (Main + Periscope Telephoto Dual OIS)', '8K@24fps, 4K@30/60fps Dolby Vision, 1080p@30/60/240fps, gyro-EIS, HDR', '4th Gen Hasselblad Color Calibration, Master Mode, Hasselblad Portrait',
  '5400 mAh dual-cell Li-Po', '100W wired SUPERVOOC, 1-100% in 26 min (advertised)', '50W AIRVOOC wireless, 1-100% in 55 min', '10W reverse wireless',
  '5G SA/NSA/Sub6', 'LTE Cat20', 'Wi-Fi 802.11 a/b/g/n/ac/6e/7, tri-band', '5.4, A2DP, LE, aptX HD, LHDC', 'Yes', 'Dual-band GPS (L1+L5), GLONASS, BDS, GALILEO, QZSS, NavIC', 'USB Type-C 3.2, OTG',
  'Optical (under display, ergonomic high placement)', '2D Face Recognition', 'Infrared IR blaster, Accelerometer, Gyro, Proximity, Compass, Color spectrum sensor',
  '164.3 x 75.8 x 9.15 mm (6.47 x 2.98 x 0.36 in)', '220 g (7.76 oz)', 'IP65 dust and water splash resistant', 'Gorilla Glass Victus 2 front, Gorilla Glass back', 'Aluminum frame, Flowy Emerald marble texture glass / Silky Black glass', '["Silky Black","Flowy Emerald","Glacial White"]',
  'Android 14, upgradable to Android 18', 'OxygenOS 14 (Trinity Engine performance tuning)', '4 major Android OS upgrades, 5 years security updates',
  'https://images.unsplash.com/photo-1546868871-7041f2a55e12?auto=format&fit=crop&w=800&q=80', 'https://images.unsplash.com/photo-1546868871-7041f2a55e12?auto=format&fit=crop&w=400&q=80', '["https://images.unsplash.com/photo-1546868871-7041f2a55e12?auto=format&fit=crop&w=800&q=80"]',
  'Flagship value powerhouse with 5400mAh battery, 100W SUPERVOOC charging, 4500-nit display, and Hasselblad camera system.', 'OnePlus 12 returns to pure flagship supremacy at an aggressive price tag. Featuring a huge 5400mAh battery, 100W wired and 50W wireless charging, Snapdragon 8 Gen 3 silicon, and an extraordinary 4500-nit 2K display equipped with Aqua Touch technology that works seamlessly in the rain.', '["5400mAh high-density battery with 100W wired + 50W wireless charging","Snapdragon 8 Gen 3 paired with Dual Cryo-velocity VC vapor cooling","4500 nits 2K ProXDR display with Aqua Touch wet-hand control","Hasselblad 4th Gen camera system with 64MP periscope telephoto (3x-120x)","IR blaster and 3-position physical Alert Slider"]', '["Exceptional battery endurance that routinely lasts 2 full days","Blistering 100W wired charging gets full charge in under 30 minutes","Terrific value compared to ৳150k+ flagships with identical silicon","Useful physical Alert Slider and integrated IR blaster"]', '["IP65 water rating rather than full submerged IP68","Curved screen edges may not appeal to flat-display purists"]', 'The OnePlus 12 is the undisputed value-for-money flagship champion of 2024, delivering premium performance and charging speed for under ৳90,000.',
  'OnePlus 12 Price in Bangladesh & Full Specifications | MobiSpec', 'OnePlus 12 official price in Bangladesh, 5400mAh battery test, 100W fast charging speeds, Hasselblad camera review, and comparison with S24 Ultra.', 'OnePlus 12 price in Bangladesh', 'https://mobispec.com/phone/oneplus-12',
  '[{"id":"v1","ram":"12GB","storage":"256GB","price":88999,"old_price":94999,"color":"Flowy Emerald","sku":"CPH2581-256","availability":"Available"},{"id":"v2","ram":"16GB","storage":"512GB","price":99999,"color":"Silky Black","sku":"CPH2581-512","availability":"Available"}]', '[{"question":"What is the price of OnePlus 12 in Bangladesh?","answer":"The official price for OnePlus 12 (12GB/256GB) is ৳88,999 in Bangladesh."},{"question":"Does OnePlus 12 come with a charger in the box?","answer":"Yes, OnePlus includes the 100W SUPERVOOC power adapter and signature red cable in the retail box."},{"question":"How fast does the 100W charger charge OnePlus 12?","answer":"The 5400mAh battery charges from 1% to 100% in approximately 26 minutes with Smart Rapid Charging enabled."}]', '[{"date":"2024-01-23","price":94999,"note":"Launch Price"},{"date":"2024-07-20","price":88999,"note":"Price drop"}]', '["phone-s24-ultra","phone-xiaomi-14-ultra"]'
);
INSERT INTO `phones` (
  `id`, `brand_id`, `name`, `model_number`, `slug`, `release_date`, `availability`, `status`, `is_featured`, `is_trending`, `is_upcoming`,
  `official_price`, `current_price`, `old_price`, `currency`, `discount_percent`, `price_updated_at`, `price_source`,
  `display_type`, `display_size`, `resolution`, `refresh_rate`, `peak_brightness`, `protection`, `hdr_support`, `touch_sampling`,
  `chipset`, `cpu`, `gpu`, `ram_default`, `ram_type`, `storage_default`, `storage_type`, `card_slot`,
  `main_camera`, `ultrawide`, `telephoto`, `macro`, `front_camera`, `ois_support`, `video_recording`, `camera_features`,
  `battery_capacity`, `charging_speed`, `wireless_charging`, `reverse_charging`,
  `five_g`, `four_g`, `wifi`, `bluetooth`, `nfc`, `gps`, `usb`,
  `fingerprint`, `face_unlock`, `sensors`,
  `dimensions`, `weight`, `ip_rating`, `glass_protection`, `materials`, `colors_json`,
  `operating_system`, `custom_ui`, `update_policy`,
  `main_image`, `thumbnail`, `gallery_images_json`,
  `short_description`, `full_description`, `key_features_json`, `pros_json`, `cons_json`, `verdict`,
  `seo_title`, `meta_description`, `focus_keyword`, `canonical_url`,
  `variants_json`, `faqs_json`, `price_history_json`, `related_phone_ids_json`
) VALUES (
  'phone-nothing-2a', 'brand-nothing', 'Nothing Phone (2a)', 'A142', 'nothing-phone-2a', '2024-03-12', 'Available', 'Published', 0, 1, 0,
  38999, 35999, 38999, '৳', 8, '2024-08-01', 'Authorized Nothing Retailers',
  'Flexible AMOLED, 1B colors, 120Hz, HDR10+, 1300 nits (peak)', '6.7 inches (~87.6% screen-to-body ratio)', '1080 x 2412 pixels, 20:9 ratio (~394 ppi density)', '120Hz Adaptive (30/60/90/120Hz)', '1300 nits', 'Corning Gorilla Glass 5', 'HDR10+, 2160Hz PWM Dimming', '240Hz',
  'Mediatek Dimensity 7200 Pro (4 nm)', '8-core (2x2.8 GHz Cortex-A715 & 6x 2.0 Cortex-A510)', 'Mali-G610 MC4', '8GB', 'LPDDR4X', '128GB', 'UFS 2.2', 'No',
  '50 MP, f/1.88, 24mm (wide), 1/1.56", 1.0µm, PDAF, OIS (Samsung GN9)', '50 MP, f/2.2, 114˚ (ultrawide), 1/2.76", 0.64µm (Samsung JN1)', 'None (2x digital sensor crop)', 'Ultra-wide close focus', '32 MP, f/2.2, (wide), 1/2.74", 0.8µm (Sony IMX615)', 'Yes (Main camera OIS & EIS)', '4K@30fps, 1080p@60/120fps, gyro-EIS', 'TrueLens Engine, Ultra XDR co-developed with Google, Night Mode',
  '5000 mAh non-removable Li-Po', '45W wired, 50% in 23 min, 100% in 59 min (advertised)', 'No', '5W wired reverse charging',
  '5G SA/NSA/Sub6', 'LTE-A', 'Wi-Fi 802.11 a/b/g/n/ac/6, dual-band, Wi-Fi Direct', '5.3, A2DP, LE', 'Yes (360-degree antenna)', 'GPS, GLONASS, GALILEO, BDS, QZSS', 'USB Type-C 2.0, OTG',
  'Optical (under display)', '2D Face Unlock', '3-zone Glyph Interface LED light system, Accelerometer, Gyro, Proximity, Compass',
  '161.7 x 76.3 x 8.55 mm (6.37 x 3.00 x 0.34 in)', '190 g (6.70 oz)', 'IP54 dust and splash resistant', 'Gorilla Glass 5 front, Transparent polycarbonate back', 'Polycarbonate unibody frame with 100% recycled aluminum midframe', '["Black","White","Milk","Special Edition (Blue/Red/Yellow accents)"]',
  'Android 14', 'Nothing OS 2.6 (Monochrome aesthetic, zero bloatware)', '3 major Android OS updates, 4 years security updates',
  'https://images.unsplash.com/photo-1592899677977-9c10ca588bbd?auto=format&fit=crop&w=800&q=80', 'https://images.unsplash.com/photo-1592899677977-9c10ca588bbd?auto=format&fit=crop&w=400&q=80', '["https://images.unsplash.com/photo-1592899677977-9c10ca588bbd?auto=format&fit=crop&w=800&q=80"]',
  'Design icon with transparent chassis, Glyph lighting, symmetrical bezels, 50MP dual cameras, and clean Nothing OS at an accessible price.', 'Nothing Phone (2a) disrupts the mid-range smartphone segment by offering unique transparent industrial design, custom Dimensity 7200 Pro performance, and the signature Glyph Interface for silent timer and notification tracking. With uniform 2.1mm bezels and zero pre-installed bloatware, it sets a standard for user-centric software design.', '["Iconic transparent design with interactive 3-part Glyph LED lighting","Ultra-thin 2.1mm symmetrical display bezels all 4 sides","Custom MediaTek Dimensity 7200 Pro 4nm processor","Dual 50MP rear camera system with OIS & Ultra XDR photography","Clean Nothing OS with bespoke monochrome widgets and zero bloatware"]', '["Standout visual identity that turns heads in a sea of generic phones","Clean, fluid Nothing OS software with fast animations and zero ads","Solid battery life from 5000mAh pack easily providing 7-8 hours SOT","Bright 120Hz AMOLED with uniform symmetrical bezels"]', '["No charger included in the retail box","Polycarbonate back is more prone to minor scratches than glass"]', 'The Nothing Phone (2a) is arguably the coolest mid-range phone under ৳40,000, combining distinctive style, clean software, and solid dual 50MP cameras.',
  'Nothing Phone (2a) Price in Bangladesh & Full Specifications | MobiSpec', 'Nothing Phone (2a) price in Bangladesh, Glyph interface review, Dimensity 7200 Pro benchmarks, camera test, and full technical specifications.', 'Nothing Phone 2a price in Bangladesh', 'https://mobispec.com/phone/nothing-phone-2a',
  '[{"id":"v1","ram":"8GB","storage":"128GB","price":35999,"old_price":38999,"color":"Black","sku":"A142-128","availability":"Available"},{"id":"v2","ram":"8GB","storage":"256GB","price":39999,"color":"Milk","sku":"A142-256","availability":"Available"},{"id":"v3","ram":"12GB","storage":"256GB","price":43999,"color":"Special Edition","sku":"A142-12-256","availability":"Available"}]', '[{"question":"What is the price of Nothing Phone (2a) in Bangladesh?","answer":"The official price for Nothing Phone (2a) (8GB/128GB) is ৳35,999."},{"question":"What is the Glyph Interface on Phone (2a)?","answer":"It is a set of LED light strips on the rear that can act as a visual countdown timer, volume indicator, camera fill light, and assignable notification alerts."}]', '[{"date":"2024-03-12","price":38999,"note":"Launch Price"},{"date":"2024-08-01","price":35999,"note":"Promotional discount"}]', '["phone-oneplus-12","phone-pixel-9-pro-xl"]'
);
INSERT INTO `phones` (
  `id`, `brand_id`, `name`, `model_number`, `slug`, `release_date`, `availability`, `status`, `is_featured`, `is_trending`, `is_upcoming`,
  `official_price`, `current_price`, `old_price`, `currency`, `discount_percent`, `price_updated_at`, `price_source`,
  `display_type`, `display_size`, `resolution`, `refresh_rate`, `peak_brightness`, `protection`, `hdr_support`, `touch_sampling`,
  `chipset`, `cpu`, `gpu`, `ram_default`, `ram_type`, `storage_default`, `storage_type`, `card_slot`,
  `main_camera`, `ultrawide`, `telephoto`, `macro`, `front_camera`, `ois_support`, `video_recording`, `camera_features`,
  `battery_capacity`, `charging_speed`, `wireless_charging`, `reverse_charging`,
  `five_g`, `four_g`, `wifi`, `bluetooth`, `nfc`, `gps`, `usb`,
  `fingerprint`, `face_unlock`, `sensors`,
  `dimensions`, `weight`, `ip_rating`, `glass_protection`, `materials`, `colors_json`,
  `operating_system`, `custom_ui`, `update_policy`,
  `main_image`, `thumbnail`, `gallery_images_json`,
  `short_description`, `full_description`, `key_features_json`, `pros_json`, `cons_json`, `verdict`,
  `seo_title`, `meta_description`, `focus_keyword`, `canonical_url`,
  `variants_json`, `faqs_json`, `price_history_json`, `related_phone_ids_json`
) VALUES (
  'phone-xiaomi-14-ultra', 'brand-xiaomi', 'Xiaomi 14 Ultra', '24030PN60G', 'xiaomi-14-ultra', '2024-02-25', 'Available', 'Published', 1, 0, 0,
  169999, 159999, 169999, '৳', 6, '2024-08-10', 'Xiaomi Bangladesh Authorized Outlets',
  'LTPO AMOLED, 68B colors, 120Hz, Dolby Vision, HDR10+, 3000 nits (peak)', '6.73 inches (~89.6% screen-to-body ratio)', '1440 x 3200 pixels, 20:9 ratio (~522 ppi density)', '120Hz LTPO (1-120Hz)', '3000 nits', 'Xiaomi Shield Glass / Longjing Glass', 'Dolby Vision, HDR10+, 1920Hz PWM dimming', '240Hz',
  'Qualcomm Snapdragon 8 Gen 3 (4 nm)', '8-core (1x3.3 GHz Cortex-X4 & 5x3.2 GHz Cortex-A720 & 2x2.3 GHz Cortex-A520)', 'Adreno 750', '16GB', 'LPDDR5X', '512GB', 'UFS 4.0', 'No',
  '50 MP, f/1.63-f/4.0 stepless variable aperture, 23mm (wide), 1.0"-type LYT-900, 1.6µm, multi-directional PDAF, Laser AF, OIS', '50 MP, f/1.8, 12mm, 122˚ (ultrawide), 1/2.51", Dual-Pixel PDAF (Sony IMX858)', '50 MP, f/1.8, 75mm (telephoto), 1/2.51", Dual-Pixel PDAF, OIS, 3.2x optical zoom + 50 MP, f/2.5, 120mm (periscope telephoto), 1/2.51", Dual-Pixel PDAF, OIS, 5x optical zoom (Sony IMX858)', '10cm telephoto macro + 5cm ultrawide macro', '32 MP, f/2.0, 22mm (wide), 1/3.14", 0.7µm', 'Yes (Triple OIS on Main, 3.2x Telephoto, 5x Periscope)', '8K@24/30fps, 4K@24/30/60/120fps, 1080p@30/60/120/240/480/960/1920fps, Dolby Vision HDR 10-bit rec., gyro-EIS', 'Leica Summilux optical lenses, Leica Authentic & Vibrant profiles, Master Cinema, 16-bit Ultra RAW',
  '5000 mAh (Global) / 5300 mAh (China)', '90W wired, PD3.0, QC4, 100% in 33 min (advertised)', '80W wireless, 100% in 46 min', '10W reverse wireless',
  '5G SA/NSA/Sub6', 'LTE Cat20', 'Wi-Fi 802.11 a/b/g/n/ac/6e/7, tri-band', '5.4, A2DP, LE, aptX HD, aptX Adaptive, LHDC', 'Yes', 'Dual-band GPS (L1+L5), GLONASS, BDS, GALILEO, QZSS, NavIC', 'USB Type-C 3.2 Gen 2, DisplayPort, OTG',
  'Optical (under display)', '2D Face Unlock', 'Two-way satellite communication (China model), Accelerometer, Gyro, Proximity, Compass, Color spectrum, Barometer',
  '161.4 x 75.3 x 9.2 mm (6.35 x 2.96 x 0.36 in)', '219.8 g (7.76 oz)', 'IP68 dust/water resistant (up to 1.5m for 30 mins)', 'Xiaomi Shield Glass front, Vegan leather / ceramic back', 'High-strength aluminum unibody frame, Eco-leather back', '["Black","White","Blue","Titanium Gray"]',
  'Android 14', 'Xiaomi HyperOS', '4 major Android OS upgrades, 5 years security updates',
  'https://images.unsplash.com/photo-1598327105666-5b89351aff97?auto=format&fit=crop&w=800&q=80', 'https://images.unsplash.com/photo-1598327105666-5b89351aff97?auto=format&fit=crop&w=400&q=80', '["https://images.unsplash.com/photo-1598327105666-5b89351aff97?auto=format&fit=crop&w=800&q=80"]',
  'The definitive camera-first flagship boasting 1-inch LYT-900 sensor, stepless variable aperture, quad 50MP Leica lenses, and 80W wireless charging.', 'Xiaomi 14 Ultra bridges the boundary between dedicated mirrorless cameras and smartphones. Armed with a 1-inch Sony LYT-900 main sensor that features a mechanical stepless f/1.63 to f/4.0 aperture, plus three additional 50MP Sony IMX858 sensors across ultrawide and dual telephoto lengths, it produces unmatched photographic depth of field and natural bokeh.', '["1.0-inch type Sony LYT-900 sensor with stepless variable aperture (f/1.63 - f/4.0)","Quad 50MP Leica camera array covering 12mm to 240mm focal range","80W wireless charging (fastest in class) and 90W wired fast charging","6.73-inch 2K 120Hz LTPO AMOLED with 3000-nit peak luminance","Xiaomi Dual-Channel IceLoop cooling system for sustained 4K/8K video"]', '["Unsurpassed optical portrait quality with genuine 1-inch hardware depth","All 4 rear camera sensors shoot 4K 120fps video for total focal consistency","Ultra-fast 80W wireless charging fully juices the battery in 46 minutes","Luxurious vegan leather tactile rear grip"]', '["Large circular camera island creates slight top-heaviness","HyperOS has minor notification handling quirks compared to stock Android"]', 'Xiaomi 14 Ultra is the reigning champion of mobile photography hardware, offering true 1-inch sensor physics and optical perfection co-engineered with Leica.',
  'Xiaomi 14 Ultra Price in Bangladesh & Full Specifications | MobiSpec', 'Xiaomi 14 Ultra official price in Bangladesh, 1-inch LYT-900 camera review, Leica quad lens tests, 90W charging benchmarks, and full specs.', 'Xiaomi 14 Ultra price in Bangladesh', 'https://mobispec.com/phone/xiaomi-14-ultra',
  '[{"id":"v1","ram":"16GB","storage":"512GB","price":159999,"old_price":169999,"color":"Black","sku":"24030PN60G-512","availability":"Available"},{"id":"v2","ram":"16GB","storage":"1TB","price":179999,"color":"White","sku":"24030PN60G-1TB","availability":"Available"}]', '[{"question":"What is the price of Xiaomi 14 Ultra in Bangladesh?","answer":"The official price for Xiaomi 14 Ultra (16GB/512GB) is ৳159,999."},{"question":"Does Xiaomi 14 Ultra have a 1-inch camera sensor?","answer":"Yes, it features the 1.0-inch Sony LYT-900 sensor with stepless f/1.63 to f/4.0 mechanical variable aperture."}]', '[{"date":"2024-02-25","price":169999,"note":"Launch Price"},{"date":"2024-08-10","price":159999,"note":"Official discount"}]', '["phone-s24-ultra","phone-iphone-16-pro-max","phone-oneplus-12"]'
);
INSERT INTO `phones` (
  `id`, `brand_id`, `name`, `model_number`, `slug`, `release_date`, `availability`, `status`, `is_featured`, `is_trending`, `is_upcoming`,
  `official_price`, `current_price`, `old_price`, `currency`, `discount_percent`, `price_updated_at`, `price_source`,
  `display_type`, `display_size`, `resolution`, `refresh_rate`, `peak_brightness`, `protection`, `hdr_support`, `touch_sampling`,
  `chipset`, `cpu`, `gpu`, `ram_default`, `ram_type`, `storage_default`, `storage_type`, `card_slot`,
  `main_camera`, `ultrawide`, `telephoto`, `macro`, `front_camera`, `ois_support`, `video_recording`, `camera_features`,
  `battery_capacity`, `charging_speed`, `wireless_charging`, `reverse_charging`,
  `five_g`, `four_g`, `wifi`, `bluetooth`, `nfc`, `gps`, `usb`,
  `fingerprint`, `face_unlock`, `sensors`,
  `dimensions`, `weight`, `ip_rating`, `glass_protection`, `materials`, `colors_json`,
  `operating_system`, `custom_ui`, `update_policy`,
  `main_image`, `thumbnail`, `gallery_images_json`,
  `short_description`, `full_description`, `key_features_json`, `pros_json`, `cons_json`, `verdict`,
  `seo_title`, `meta_description`, `focus_keyword`, `canonical_url`,
  `variants_json`, `faqs_json`, `price_history_json`, `related_phone_ids_json`
) VALUES (
  'phone-galaxy-s25-ultra', 'brand-samsung', 'Galaxy S25 Ultra (Upcoming)', 'SM-S938B', 'samsung-galaxy-s25-ultra', '2025-01-20', 'Coming Soon', 'Published', 0, 1, 1,
  195000, 195000, 195000, '৳', 0, '2024-08-20', 'Expected Market Price / Industry Leak Estimates',
  'Dynamic LTPO AMOLED 2X, 120Hz, HDR10+, 3000 nits (peak)', '6.86 inches (~91.2% screen-to-body ratio)', '1440 x 3120 pixels (~500 ppi density)', '120Hz LTPO', '3000 nits', 'Corning Gorilla Armor 2', 'HDR10+, Dolby Vision supported', '240Hz',
  'Qualcomm Snapdragon 8 Gen 4 / 8 Elite (3 nm)', '8-core Oryon CPU architecture (2x4.32 GHz Phoenix L & 6x3.53 GHz Phoenix M)', 'Adreno 830', '16GB', 'LPDDR5X', '256GB', 'UFS 4.1', 'No',
  '200 MP, f/1.7, 24mm (wide), 1/1.3", 0.6µm, multi-directional PDAF, Laser AF, OIS', '50 MP, f/1.9, 13mm, 120˚ (ultrawide), 1/2.5", Dual Pixel PDAF', '50 MP, f/3.4, 115mm (periscope telephoto), 5x optical zoom + 50 MP, f/2.4, 3x optical zoom', 'Dedicated macro via 50MP ultrawide', '12 MP, f/2.2, Dual Pixel PDAF', 'Yes (Triple OIS)', '8K@60fps, 4K@60/120fps, 1080p@240fps', 'Galaxy AI Generative Video, Audio Erase 2.0, Nightography Pro',
  '5000 mAh non-removable Li-Ion (Stacked battery tech)', '65W wired fast charging (rumored)', '25W Qi2 wireless charging with magnetic ring', '4.5W reverse wireless',
  '5G SA/NSA/Sub6/mmWave', 'LTE Cat24', 'Wi-Fi 7, tri-band', '5.4, A2DP, LE', 'Yes', 'Dual-band GPS, GLONASS, BDS, GALILEO, QZSS', 'USB Type-C 3.2 Gen 2, DisplayPort',
  '3D Ultrasonic Under Display', '2D Face Recognition', 'UWB 2.0, Satellite SOS, Accelerometer, Gyro, Proximity, Compass, Barometer',
  '162.8 x 77.6 x 8.2 mm (expected slim profile)', '219 g (expected lighter chassis)', 'IP68 dust/water resistant (up to 1.5m for 30 mins)', 'Corning Gorilla Armor 2', 'Grade 5 Titanium rounded frame, Matte anti-reflective glass', '["Titanium Silver","Titanium Black","Titanium Blue","Titanium Jade Green"]',
  'Android 15', 'One UI 7.0', '7 major Android OS upgrades, 7 years security patches',
  'https://images.unsplash.com/photo-1610945265064-0e34e5519bbf?auto=format&fit=crop&w=800&q=80', 'https://images.unsplash.com/photo-1610945265064-0e34e5519bbf?auto=format&fit=crop&w=400&q=80', '["https://images.unsplash.com/photo-1610945265064-0e34e5519bbf?auto=format&fit=crop&w=800&q=80"]',
  'Upcoming 2025 flagship expected to introduce 3nm Snapdragon 8 Elite silicon, rounded titanium ergonomics, 50MP ultrawide sensor, and One UI 7.', 'Samsung Galaxy S25 Ultra is anticipated to debut in early 2025 with softer, rounded titanium edges for improved palm comfort, Qualcomm’s revolutionary 3nm Oryon CPU architecture, upgraded 50MP ultrawide optics, and Qi2 magnetic wireless charging.', '["Next-gen Snapdragon 8 Elite 3nm processor with Oryon custom CPU cores","Rounded corner ergonomics addressing previous sharp corner feedback","Upgraded 50MP Ultrawide & 50MP 3x Telephoto optical sensors","One UI 7.0 with next-generation Gemini AI on-device agents","Qi2 magnetic wireless charging compatibility"]', '["Smoother in-hand ergonomics with rounded frame corners","Significant CPU & GPU computing leap with 3nm Oryon architecture","Comprehensive 50MP sensors across all secondary rear cameras"]', '["Estimated high launch pricing","Battery capacity expected to stay at 5000mAh"]', 'Galaxy S25 Ultra is poised to refine the Ultra formula with ergonomic rounded titanium edges and groundbreaking 3nm Oryon silicon power.',
  'Samsung Galaxy S25 Ultra Expected Price in Bangladesh & Specs | MobiSpec', 'Samsung Galaxy S25 Ultra expected launch date, price in Bangladesh, Snapdragon 8 Elite specs, One UI 7 rumors, and leaked camera upgrades.', 'Samsung Galaxy S25 Ultra price in Bangladesh', 'https://mobispec.com/phone/samsung-galaxy-s25-ultra',
  '[{"id":"v1","ram":"16GB","storage":"256GB","price":195000,"color":"Titanium Silver","sku":"SM-S938B-256","availability":"Coming Soon"},{"id":"v2","ram":"16GB","storage":"512GB","price":215000,"color":"Titanium Black","sku":"SM-S938B-512","availability":"Coming Soon"}]', '[{"question":"When will the Samsung Galaxy S25 Ultra be released?","answer":"Samsung is anticipated to unveil the Galaxy S25 series at Galaxy Unpacked in January 2025."},{"question":"What is the expected price of Galaxy S25 Ultra in Bangladesh?","answer":"Early industry estimates project the starting price for 16GB/256GB around ৳195,000 at official launch."}]', '[{"date":"2024-08-20","price":195000,"note":"Expected retail estimate"}]', '["phone-s24-ultra","phone-iphone-16-pro-max"]'
);

-- Table structure for `articles`
DROP TABLE IF EXISTS `articles`;
CREATE TABLE `articles` (
  `id` varchar(64) NOT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(191) NOT NULL,
  `category` varchar(100) DEFAULT 'Buying Guide',
  `excerpt` text DEFAULT NULL,
  `content` longtext DEFAULT NULL,
  `featured_image` varchar(500) DEFAULT NULL,
  `author` varchar(100) DEFAULT NULL,
  `publish_date` varchar(50) DEFAULT NULL,
  `read_time` varchar(50) DEFAULT '5 min read',
  `seo_title` varchar(255) DEFAULT NULL,
  `meta_description` text DEFAULT NULL,
  `focus_keyword` varchar(255) DEFAULT NULL,
  `status` varchar(50) DEFAULT 'Published',
  `related_phone_ids_json` json DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `slug` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Insert Articles
INSERT INTO `articles` (`id`, `title`, `slug`, `category`, `excerpt`, `content`, `featured_image`, `author`, `publish_date`, `read_time`, `seo_title`, `meta_description`, `focus_keyword`, `status`, `related_phone_ids_json`) VALUES ('art-best-flagships-2024', 'Top 5 Flagship Smartphones of 2024: Complete Buying Guide & Verdict', 'top-5-flagship-smartphones-2024-buying-guide', 'Buying Guide', 'We benchmarked the Galaxy S24 Ultra, iPhone 16 Pro Max, Pixel 9 Pro XL, OnePlus 12, and Xiaomi 14 Ultra across camera, battery life, and sustained thermal performance.', 'Choosing the right flagship smartphone requires balancing camera versatility, battery endurance, and guaranteed software update life. In this comprehensive comparison, we break down real-world testing data to help you invest wisely.

### 1. The Glare-Free Display King: Galaxy S24 Ultra
Samsung\'s Gorilla Armor anti-reflective glass remains an unmatched everyday quality-of-life feature. In direct sunlight, screen reflections drop by 75%, making reading documents and viewing photos effortless without needing to crank the brightness to maximum.

### 2. Video Production Benchmark: iPhone 16 Pro Max
With 4K 120fps Dolby Vision and hardware Camera Control, Apple caters directly to creators. The A18 Pro chip offers the highest single-core efficiency on the market today.

### 3. Point & Shoot Simplicity: Pixel 9 Pro XL
Google\'s computational photography excels in skin tone fidelity and dynamic range. The ultrasonic fingerprint reader and 16GB RAM make it the most refined Pixel to date.

### 4. The Value Master: OnePlus 12
At nearly half the cost of ৳180k flagships, the OnePlus 12 delivers the identical Snapdragon 8 Gen 3 silicon, a larger 5400mAh battery, and lightning-fast 100W SUPERVOOC charging.', 'https://images.unsplash.com/photo-1610945265064-0e34e5519bbf?auto=format&fit=crop&w=1200&q=80', 'Tahmid Rahman (Senior Tech Editor)', '2024-09-22', '6 min read', 'Best Flagship Smartphones in Bangladesh (2024) | MobiSpec Guide', 'Comparison and expert buying guide for Galaxy S24 Ultra, iPhone 16 Pro Max, Pixel 9 Pro XL, and OnePlus 12 with price benchmarks.', 'best flagship smartphones 2024', 'Published', '["phone-s24-ultra","phone-iphone-16-pro-max","phone-pixel-9-pro-xl","phone-oneplus-12"]');
INSERT INTO `articles` (`id`, `title`, `slug`, `category`, `excerpt`, `content`, `featured_image`, `author`, `publish_date`, `read_time`, `seo_title`, `meta_description`, `focus_keyword`, `status`, `related_phone_ids_json`) VALUES ('art-s24u-vs-iphone16pm', 'Samsung Galaxy S24 Ultra vs Apple iPhone 16 Pro Max: Head-to-Head Comparison', 'samsung-s24-ultra-vs-iphone-16-pro-max-comparison', 'Comparison', 'Detailed comparison of titanium builds, 200MP vs 48MP zoom optics, anti-glare display technology, battery charging speeds, and OS ecosystems.', 'The ultimate smartphone rivalry enters a new chapter with titanium designs, 3nm/4nm cutting-edge chipsets, and AI integration.

### Build and Display
* **Samsung Galaxy S24 Ultra**: 6.8-inch Dynamic AMOLED 2X with flat Gorilla Armor (anti-reflective coating).
* **Apple iPhone 16 Pro Max**: 6.9-inch Super Retina XDR OLED with micro-thin borders and Ceramic Shield glass.

### Camera Differences
Samsung offers dual dedicated telephotos (3x 10MP + 5x 50MP periscope) capable of 100x Space Zoom. Apple counters with a larger 48MP Fusion sensor and 4K120fps Dolby Vision video.

### Charging & Battery
The OnePlus and Xiaomi competitors boast 90W-100W, while Samsung tops out at 45W and Apple at 30W. However, iPhone 16 Pro Max achieves longer continuous screen-on time due to iOS optimization.', 'https://images.unsplash.com/photo-1510557880182-3d4d3cba35a5?auto=format&fit=crop&w=1200&q=80', 'Rafiqul Islam (Mobile Analyst)', '2024-09-24', '7 min read', 'S24 Ultra vs iPhone 16 Pro Max Comparison | MobiSpec', 'In-depth camera, battery, display, and price comparison between Samsung Galaxy S24 Ultra and Apple iPhone 16 Pro Max.', 'S24 Ultra vs iPhone 16 Pro Max', 'Published', '["phone-s24-ultra","phone-iphone-16-pro-max"]');

-- Table structure for `seo_keywords`
DROP TABLE IF EXISTS `seo_keywords`;
CREATE TABLE `seo_keywords` (
  `id` varchar(64) NOT NULL,
  `keyword` varchar(255) NOT NULL,
  `search_intent` varchar(50) DEFAULT 'Informational',
  `category` varchar(50) DEFAULT 'Primary',
  `target_page` varchar(255) DEFAULT '/',
  `priority` varchar(50) DEFAULT 'Medium',
  `status` varchar(50) DEFAULT 'Targeted',
  `notes` text DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `seo_keywords` (`id`, `keyword`, `search_intent`, `category`, `target_page`, `priority`, `status`, `notes`) VALUES ('kw-1', 'mobile price in bangladesh', 'Transactional', 'Primary', '/', 'High', 'Targeted', 'Core high-volume informational/commercial keyword targeting the homepage directory.');
INSERT INTO `seo_keywords` (`id`, `keyword`, `search_intent`, `category`, `target_page`, `priority`, `status`, `notes`) VALUES ('kw-2', 'samsung galaxy s24 ultra price in bd', 'Commercial', 'Secondary', '/phone/samsung-galaxy-s24-ultra', 'High', 'Ranking', 'Specific model commercial purchase intent.');
INSERT INTO `seo_keywords` (`id`, `keyword`, `search_intent`, `category`, `target_page`, `priority`, `status`, `notes`) VALUES ('kw-3', 'iphone 16 pro max vs s24 ultra camera comparison', 'Informational', 'Long-tail', '/compare?p1=apple-iphone-16-pro-max&p2=samsung-galaxy-s24-ultra', 'High', 'In Progress', 'High CTR comparison query for prospective buyers.');
INSERT INTO `seo_keywords` (`id`, `keyword`, `search_intent`, `category`, `target_page`, `priority`, `status`, `notes`) VALUES ('kw-4', 'best phones under 40000 in bangladesh', 'Transactional', 'Secondary', '/filter?maxPrice=40000', 'Medium', 'Targeted', 'Mid-range buyer intent targeting price filter view.');

-- Table structure for `settings`
DROP TABLE IF EXISTS `settings`;
CREATE TABLE `settings` (
  `setting_key` varchar(100) NOT NULL,
  `setting_value` longtext DEFAULT NULL,
  PRIMARY KEY (`setting_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `settings` (`setting_key`, `setting_value`) VALUES
('site_name', 'MobiSpec'),
('site_tagline', 'Premium Smartphone Specs, Real-time Prices & Comparisons'),
('currency_symbol', '৳'),
('currency_code', 'BDT'),
('contact_email', 'editor@mobispec.com'),
('footer_text', '© 2026 MobiSpec. Technical specifications, verified prices, side-by-side comparisons & buying guides. Designed for cPanel / Namecheap shared hosting deployment.'),
('header_announcement', '🔥 Q3 Price Drops Updated for Galaxy S24 Ultra & iPhone 16 Pro Max'),
('meta_description', 'Database-driven smartphone intelligence platform featuring official mobile prices, exhaustive technical specifications, camera benchmarks, side-by-side phone comparisons, and buying guides.');

-- Table structure for `activity_logs`
DROP TABLE IF EXISTS `activity_logs`;
CREATE TABLE `activity_logs` (
  `id` varchar(64) NOT NULL,
  `action` varchar(100) NOT NULL,
  `entity_type` varchar(50) NOT NULL,
  `entity_name` varchar(150) NOT NULL,
  `admin_user` varchar(100) NOT NULL,
  `timestamp` varchar(50) NOT NULL,
  `details` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `activity_logs` (`id`, `action`, `entity_type`, `entity_name`, `admin_user`, `timestamp`, `details`) VALUES ('log-1', 'Database Initialized', 'System', 'Core Schema & Seed Data', 'Super Admin', '2024-09-24 09:00:00', 'Initial normalized database tables populated with flagship phone records and brand directories.');
INSERT INTO `activity_logs` (`id`, `action`, `entity_type`, `entity_name`, `admin_user`, `timestamp`, `details`) VALUES ('log-2', 'Price Updated', 'Price', 'Samsung Galaxy S24 Ultra', 'Admin', '2024-08-15 14:32:00', 'Updated official price from ৳184,999 to ৳169,999 (8% discount).');

SET FOREIGN_KEY_CHECKS=1;
COMMIT;