-- ===================================================================
-- TARQORA BLACK GALAXY GRANITE - PRODUCTION MYSQL DATABASE SCHEMA
-- Compatible with MySQL 5.7+, MySQL 8.0+, MariaDB 10.3+
-- Chimakurthy Quarries & Factory Direct Export Management
-- ===================================================================

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- 1. Create Database if not exists
CREATE DATABASE IF NOT EXISTS `tarqora_granite_db` 
CHARACTER SET utf8mb4 
COLLATE utf8mb4_unicode_ci;

USE `tarqora_granite_db`;

-- -------------------------------------------------------------------
-- TABLE 1: tarqora_gallery (Slab & Block Asset Management)
-- -------------------------------------------------------------------
DROP TABLE IF EXISTS `tarqora_gallery`;
CREATE TABLE `tarqora_gallery` (
  `id` VARCHAR(64) NOT NULL,
  `title` VARCHAR(255) NOT NULL,
  `category` ENUM('polished', 'gangsaw', 'kitchen', 'quarry', 'factory') NOT NULL DEFAULT 'polished',
  `dims` VARCHAR(150) DEFAULT '20mm & 30mm Calibrated',
  `description` TEXT,
  `image_url` LONGTEXT NOT NULL,
  `sort_order` INT NOT NULL DEFAULT 0,
  `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  INDEX `idx_category` (`category`),
  INDEX `idx_created` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- -------------------------------------------------------------------
-- TABLE 2: tarqora_countries (Target Export Landings & Specifications)
-- -------------------------------------------------------------------
DROP TABLE IF EXISTS `tarqora_countries`;
CREATE TABLE `tarqora_countries` (
  `slug` VARCHAR(64) NOT NULL,
  `name` VARCHAR(150) NOT NULL,
  `code` VARCHAR(20) NOT NULL,
  `flag` VARCHAR(10) NOT NULL,
  `currency` VARCHAR(10) DEFAULT 'USD',
  `page_url` VARCHAR(255) NOT NULL,
  `cities_served` TEXT,
  `eyebrow` VARCHAR(255) DEFAULT 'Direct Container Export',
  `h1` VARCHAR(255) NOT NULL,
  `seo_title` VARCHAR(255) NOT NULL,
  `meta_desc` TEXT NOT NULL,
  `keywords` TEXT,
  `intro` TEXT,
  `dest_ports` TEXT,
  `transit_days` VARCHAR(100),
  `specs_html` MEDIUMTEXT,
  `seo_content` MEDIUMTEXT,
  `sort_order` INT NOT NULL DEFAULT 0,
  `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- -------------------------------------------------------------------
-- TABLE 3: tarqora_slider (Homepage 5-Stage Production Showcase)
-- -------------------------------------------------------------------
DROP TABLE IF EXISTS `tarqora_slider`;
CREATE TABLE `tarqora_slider` (
  `id` VARCHAR(64) NOT NULL,
  `stage_num` VARCHAR(10) NOT NULL,
  `stage_tag` VARCHAR(150) NOT NULL,
  `stage_short` VARCHAR(100) NOT NULL,
  `title` VARCHAR(255) NOT NULL,
  `description` TEXT,
  `stats` VARCHAR(255),
  `image_url` LONGTEXT NOT NULL,
  `sort_order` INT NOT NULL DEFAULT 0,
  `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- -------------------------------------------------------------------
-- TABLE 4: tarqora_seo (Page-by-Page SEO Metadata)
-- -------------------------------------------------------------------
DROP TABLE IF EXISTS `tarqora_seo`;
CREATE TABLE `tarqora_seo` (
  `page_key` VARCHAR(64) NOT NULL,
  `title` VARCHAR(255) NOT NULL,
  `description` TEXT NOT NULL,
  `keywords` TEXT,
  `canonical_url` VARCHAR(255),
  `secondary_keywords` TEXT,
  `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`page_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- -------------------------------------------------------------------
-- TABLE 5: tarqora_leads (Wholesale RFQ & Container Inquiries)
-- -------------------------------------------------------------------
DROP TABLE IF EXISTS `tarqora_leads`;
CREATE TABLE `tarqora_leads` (
  `id` VARCHAR(64) NOT NULL,
  `buyer_name` VARCHAR(150) NOT NULL,
  `company` VARCHAR(150),
  `email` VARCHAR(150) NOT NULL,
  `phone` VARCHAR(50),
  `destination` VARCHAR(100),
  `requirement` TEXT NOT NULL,
  `status` ENUM('new', 'contacted', 'quoted', 'closed', 'archived') NOT NULL DEFAULT 'new',
  `notes` TEXT,
  `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  INDEX `idx_status` (`status`),
  INDEX `idx_leads_date` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- -------------------------------------------------------------------
-- TABLE 6: tarqora_settings (Global Site & Brand Settings)
-- -------------------------------------------------------------------
DROP TABLE IF EXISTS `tarqora_settings`;
CREATE TABLE `tarqora_settings` (
  `setting_key` VARCHAR(64) NOT NULL,
  `setting_value` LONGTEXT NOT NULL,
  `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`setting_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ===================================================================
-- SEED DATA POPULATION
-- ===================================================================

-- Seed Gallery Assets
INSERT INTO `tarqora_gallery` (`id`, `title`, `category`, `dims`, `description`, `image_url`, `sort_order`, `created_at`) VALUES
('gal-1', 'Gangsaw Jumbo Slab - High Gloss Mirror Polish', 'gangsaw', '310 x 195 cm (30mm Calibrated)', 'Premium export gang saw slab cut from virgin Chimakurthy blocks with dense, uniform golden bronzite star flecks.', '/images/black-galaxy-gangsaw-cutting.jpg', 1, '2026-09-25 10:00:00'),
('gal-2', 'Automated 21-Head Line Polishing Quality', 'polished', '305 x 185 cm (20mm & 30mm)', 'Mirror finish exceeding 95-degree gloss with zero chemical wax coatings, revealing pure natural optical clarity.', '/images/black-galaxy-line-polishing.jpg', 2, '2026-09-25 10:05:00'),
('gal-3', 'Authentic Golden Bronzite Crystals Macro', 'polished', 'Microscopic Enstatite Flakes', 'Direct macroscopic view of natural golden-copper flecks suspended within the deep obsidian igneous gabbroic matrix.', '/images/black-galaxy-bronzite-crystals.jpg', 3, '2026-09-25 10:10:00'),
('gal-4', 'Solid Kitchen Worktop & Waterfall Island Slab', 'kitchen', '320 x 190 cm (30mm Solid Gauge)', 'Heavy-duty 3cm calibrated gauge tailored for luxury residential kitchen countertops and architectural waterfall islands.', '/images/black-galaxy-kitchen-island.jpg', 4, '2026-09-25 10:15:00'),
('gal-5', 'Chimakurthy Open-Pit Quarry Bench Extraction', 'quarry', 'Rough Blocks (15–25 Metric Tons)', 'Diamond wire saw bench extraction directly from our proprietary quarry reserve in Chimakurthy, Andhra Pradesh.', '/images/black-galaxy-quarry-mining.jpg', 5, '2026-09-25 10:20:00'),
('gal-6', 'ISPM-15 Ocean Freight Wooden Crate Bundles', 'factory', '20ft Heavy FCL Export Bundles', 'Reinforced heat-treated pine wooden A-frames packed with polyethylene film and steel strapping for maritime container safety.', '/images/black-galaxy-container-crates.jpg', 6, '2026-09-25 10:25:00'),
('gal-7', 'Export Container Loading at Chennai Seaport', 'factory', 'Full 20ft FCL Container', 'Safe harbor container stuffing with certified lashing, wood blocking, and desiccants ensuring moisture-free ocean transit.', '/images/black-galaxy-container-loading.jpg', 7, '2026-09-25 10:30:00'),
('gal-8', 'Factory Thickness Caliper & Surface Inspection', 'factory', '±0.5mm Parallel Caliper', 'Rigorous quality audit measuring slab thickness consistency, surface planarity, and diagonal squareness prior to crating.', '/images/black-galaxy-factory-inspection.jpg', 8, '2026-09-25 10:35:00')
ON DUPLICATE KEY UPDATE `title`=VALUES(`title`), `image_url`=VALUES(`image_url`);

-- Seed Homepage 5-Stage Slider
INSERT INTO `tarqora_slider` (`id`, `stage_num`, `stage_tag`, `stage_short`, `title`, `description`, `stats`, `image_url`, `sort_order`) VALUES
('slide-1', '01', 'STAGE 01: RAW QUARRY MINING', 'Quarry Mining', 'Chimakurthy Quarry Face Extraction', 'Direct open-pit mining of massive, crack-free raw Black Galaxy Granite blocks using diamond wire saws and hydraulic wedge splitters in Chimakurthy, Andhra Pradesh.', 'Block Weight: 15–25 Tons | 100% Dedicated Black Galaxy Quarry | Grade A Dressed Sawn Blocks', '/images/black-galaxy-quarry-mining.jpg', 1),
('slide-2', '02', 'STAGE 02: DIAMOND GANG SAW CUTTING', 'Gang Saw Cutting', 'Multi-Blade Diamond Gang Saw Slabbing', 'Heavy-duty multi-blade diamond gang saws slabbing raw blocks into jumbo 20mm and 30mm architectural slabs with ±0.5mm parallel caliper tolerance, dedicated 100% to Black Galaxy stone.', 'Cutting Precision: ±0.5mm Parallel | Jumbo Format: 320x200 cm | Zero Mineral Contamination', '/images/black-galaxy-gangsaw-cutting.jpg', 2),
('slide-3', '03', 'STAGE 03: 21-HEAD LINE POLISHING', 'Automated Line Polishing', 'Automated 21-Head Diamond Line Polishing', 'State-of-the-art multi-head continuous polishing line using Italian resin-bonded abrasives to achieve a true 95°+ natural mirror gloss without chemical epoxy waxes.', 'Gloss Rating: 95°+ Mirror Shine | Natural Bronzite Sparkle | Zero Epoxy Masking', '/images/black-galaxy-line-polishing.jpg', 3),
('slide-4', '04', 'STAGE 04: QUALITY INSPECTION & CALIBRATION', 'Inspection & Grading', 'Laser Caliper Thickness & Surface Audit', 'Each finished slab undergoes meticulous inspection for uniform golden star distribution, absolute thickness tolerance (±0.5mm), and diagonal squareness under specialized LED inspection lighting.', 'Grading Standards: First Choice / Commercial A | 100% Caliper Audited | Bundle Color Matching', '/images/black-galaxy-factory-inspection.jpg', 4),
('slide-5', '05', 'STAGE 05: ISPM-15 PACKING & OCEAN EXPORT', 'Container Loading', 'ISPM-15 Certified Seaworthy Crating & Stuffing', 'Heavy-duty treated wooden bundles packed with protective plastic wrapping, corner protectors, and steel wire lashing inside 20ft heavy-payload maritime containers for global export.', 'Container Capacity: 28–30 Metric Tons | ISPM-15 Heat Treated Bundles | Seaport: Chennai Port', '/images/black-galaxy-container-crates.jpg', 5)
ON DUPLICATE KEY UPDATE `title`=VALUES(`title`), `description`=VALUES(`description`), `image_url`=VALUES(`image_url`);

-- Seed Target Export Countries
INSERT INTO `tarqora_countries` (`slug`, `name`, `code`, `flag`, `currency`, `page_url`, `cities_served`, `eyebrow`, `h1`, `seo_title`, `meta_desc`, `keywords`, `intro`, `dest_ports`, `transit_days`, `specs_html`, `seo_content`, `sort_order`) VALUES
('usa', 'United States (USA)', 'USA', '🇺🇸', 'USD', 'https://blackgalaxygranite-india.com/exports/usa', 'Houston, Savannah, New York, Los Angeles, Miami, Dallas, Atlanta, Chicago', 'Direct Container Export to USA', 'Black Galaxy Granite Slabs Exporter to USA', 'Black Galaxy Granite Slabs Exporter to USA | Direct Factory India', 'Direct Chimakurthy quarry supply of Black Galaxy Granite Slabs to USA stone distributors and fabricators. 2 cm and 3 cm polished gang saw slabs shipped to Houston, Savannah, New York, and Los Angeles.', 'Black Galaxy Granite Slabs USA, Black Galaxy Granite Exporter to USA, Black Galaxy Granite Wholesale USA, Black Galaxy Granite Countertop Slabs USA', 'Supplying premium 2 cm (3/4\") and 3 cm (1-1/4\") Black Galaxy Granite slabs directly from our Chimakurthy quarry and manufacturing facility to American stone distributors, countertop fabricators, and commercial stone wholesalers across the United States.', 'Houston (Texas), Savannah (Georgia), New York / Newark (New Jersey), Los Angeles (California), Miami (Florida)', 'Approx. 30–45 Days from Chennai Port', '<p>For the North American stone market, we specialize in calibrated gang saw slabs meeting rigid US architectural standards:</p><ul class=\"list-disc pl-5 space-y-1 mt-2 text-xs\"><li><strong>3 cm (1-1/4\") Solid Kitchen Worktop Slabs:</strong> Standard residential and commercial countertop gauge with supreme flexural strength and stain resistance.</li><li><strong>2 cm (3/4\") Commercial & Flooring Slabs:</strong> High-demand thickness for multi-unit apartment complexes and hospitality vanities.</li><li><strong>Jumbo Gang Saw Formats:</strong> Typical dimensions from 280cm x 170cm up to 320cm x 200cm, maximizing fabrication yield.</li><li><strong>ISPM-15 Wooden Crates:</strong> 100% heat-treated stamped timber bundles fully accepted by US Customs and USDA biosecurity.</li></ul>', '<p>As a leading <strong>Black Galaxy Granite Slabs Exporter to USA</strong>, we serve major commercial stone centers including Houston, Dallas, Atlanta, Chicago, and California. Our direct quarry ownership in Chimakurthy guarantees authentic Indian Black Galaxy Granite containing deep obsidian background matrix and golden-bronze enstatite flakes that US fabricators trust.</p>', 1),
('egypt', 'Egypt', 'Egypt', '🇪🇬', 'USD', 'https://blackgalaxygranite-india.com/exports/egypt', 'Alexandria, Cairo, Shaq El-Thoaban, Port Said, Damietta', 'Wholesale Container Supply to Egypt', 'Black Galaxy Granite Wholesale Supply to Egypt', 'Black Galaxy Granite Wholesale Supply to Egypt | Factory Direct Chimakurthy', 'Direct container exporter of Indian Black Galaxy Granite slabs to Egypt. High volume 20mm gang saw slabs and project tiles shipped to Alexandria and Port Said for Shaq El-Thoaban marble yards.', 'Black Galaxy Granite Exporter to Egypt, Black Galaxy Granite Wholesale Supply to Egypt, Black Galaxy Granite Alexandria, Black Galaxy Granite Slabs Egypt', 'Direct quarry and factory container exporter supplying Egyptian marble wholesalers, commercial importers, and processing workshops in Shaq El-Thoaban and greater Cairo with high-volume Black Galaxy Granite slabs.', 'Alexandria Port, Port Said, Damietta Port', 'Approx. 20–30 Days via Red Sea / Suez maritime routes', '<p>Egyptian market specifications optimized for maximum container utilization and competitive landed cost:</p><ul class=\"list-disc pl-5 space-y-1 mt-2 text-xs\"><li><strong>20mm Gang Saw Slabs:</strong> High yield volume specifications ideal for Egyptian processing yards in Shaq El-Thoaban.</li><li><strong>20ft Container Load Optimization:</strong> Packed up to 27–28 metric tons payload per 20ft container (approx. 450 sqm of 20mm slabs).</li><li><strong>Sawn Back Finish:</strong> Clean parallel saw lines facilitating rapid adhesive bonding on Egyptian commercial building elevations.</li></ul>', '<p>Egypt is one of the premier Mediterranean import gateways for authentic Indian Black Galaxy granite. We provide competitive bulk FOB Chennai and CIF Alexandria pricing with fast shipping schedules via the Red Sea.</p>', 2),
('uk', 'United Kingdom (UK)', 'GBP', '🇬🇧', 'GBP', 'https://blackgalaxygranite-india.com/exports/uk', 'Felixstowe, Southampton, London Gateway, Liverpool, Birmingham, Manchester', 'UK Architectural Container Supply', 'Black Galaxy Granite Slabs Exporter to UK', 'Black Galaxy Granite Slabs Exporter to UK | Direct Factory India', 'Direct quarry manufacturer and container exporter of Black Galaxy Granite Slabs to UK worktop fabricators and stone importers. Premium 30mm and 20mm mirror polished slabs to Felixstowe and Southampton.', 'Black Galaxy Granite UK, Black Galaxy Granite Slabs Exporter UK, Indian Granite Slabs UK, Black Galaxy Worktops Wholesale UK', 'Direct factory container supply of premium 20mm and 30mm Black Galaxy Granite slabs to UK countertop fabricators, kitchen worktop manufacturers, and stone wholesalers across England, Scotland, and Wales.', 'Felixstowe Port, Southampton Port, London Gateway Port, Liverpool Port', 'Approx. 28–35 Days via direct container line from Chennai', '<p>Tailored for British kitchen and architectural requirements:</p><ul class=\"list-disc pl-5 space-y-1 mt-2 text-xs\"><li><strong>30mm Calibrated Worktop Gauges:</strong> Preferred standard for British bespoke luxury kitchens and island islands.</li><li><strong>95°+ Mirror Finish:</strong> Resists lime scale, red wine, and culinary stains in British domestic and hospitality applications.</li><li><strong>Rigid Thickness Tolerances:</strong> ±0.5mm precision suitable for automatic CNC bridge saws used by UK worktop fabricators.</li></ul>', '<p>Serving leading stone importers and kitchen studios throughout London, Birmingham, Manchester, and Leeds with first-choice Indian granite certified to meet British Standards.</p>', 3),
('uae', 'United Arab Emirates (UAE)', 'AED', '🇦🇪', 'AED', 'https://blackgalaxygranite-india.com/exports/uae', 'Dubai (Jebel Ali), Sharjah, Abu Dhabi, Ajman, Ras Al Khaimah', 'Gulf Region Direct Container Supply', 'Black Galaxy Granite Slabs Exporter to UAE & Dubai', 'Black Galaxy Granite Slabs Exporter to UAE | Dubai Jebel Ali Direct', 'Direct Chimakurthy quarry supply of Black Galaxy Granite Slabs to UAE stone companies. High volume container shipments delivered to Jebel Ali Port, Dubai and Sharjah industrial areas.', 'Black Galaxy Granite UAE, Black Galaxy Granite Dubai, Black Galaxy Granite Jebel Ali, Indian Granite Exporter UAE, Black Galaxy Granite Slabs Sharjah', 'Serving UAE stone stockists, building contractors, and interior fitout firms with high-volume container shipments of premium Black Galaxy Granite slabs arriving directly at Jebel Ali Port, Dubai.', 'Jebel Ali Port (Dubai), Khalifa Port (Abu Dhabi), Sharjah Port', 'Approx. 12–16 Days fast sea transit from Chennai', '<p>Gulf commercial project requirements:</p><ul class=\"list-disc pl-5 space-y-1 mt-2 text-xs\"><li><strong>Rapid Gulf Shipping:</strong> 12–16 day vessel transit from Chennai Port directly into Jebel Ali.</li><li><strong>High Thermal Stability:</strong> Withstands extreme Gulf ambient temperatures and direct solar exposure without color fading.</li><li><strong>Custom Tile & Slab Dimensions:</strong> 20mm gang saw slabs and pre-cut project tiles for luxury lobbies and hotel bathrooms.</li></ul>', '<p>Direct supply to major construction projects in Downtown Dubai, Business Bay, Abu Dhabi, and Sharjah industrial areas.</p>', 4),
('saudi', 'Saudi Arabia (KSA)', 'SAR', '🇸🇦', 'SAR', 'https://blackgalaxygranite-india.com/exports/saudi-arabia', 'Jeddah Islamic Port, Dammam (King Abdulaziz Port), Riyadh, Medina, Mecca', 'KSA Vision 2030 Project Supply', 'Black Galaxy Granite Slabs Exporter to Saudi Arabia', 'Black Galaxy Granite Slabs Exporter to Saudi Arabia | Direct Quarry Chimakurthy', 'Direct container exporter of authentic Black Galaxy Granite Slabs to Saudi Arabia. Container wholesale supply to Jeddah Islamic Port and Dammam for mega commercial developments.', 'Black Galaxy Granite Saudi Arabia, Black Galaxy Granite KSA, Black Galaxy Granite Jeddah, Black Galaxy Granite Dammam, Indian Granite Exporter Saudi Arabia', 'Supplying mega projects, commercial developers, and stone distribution stockists across Saudi Arabia (Riyadh, Jeddah, Dammam) with certified Black Galaxy Granite slabs and cut-to-size cladding from Chimakurthy.', 'Jeddah Islamic Port (Red Sea), King Abdulaziz Port Dammam (Arabian Gulf)', 'Approx. 14–20 Days from Chennai Port', '<p>Engineered for Vision 2030 hospitality and infrastructure standards:</p><ul class=\"list-disc pl-5 space-y-1 mt-2 text-xs\"><li><strong>SABER Platform Compliance:</strong> Complete SASO / SABER product conformity documentation and test certificates.</li><li><strong>20mm & 30mm Calibrated:</strong> Consistent thickness for mechanical stone facade fixing systems and heavy footfall lobby flooring.</li><li><strong>Bulk Container Pricing:</strong> Multi-container monthly supply contracts for commercial towers and residential complexes.</li></ul>', '<p>Trusted supply partner for stone wholesalers in Jeddah, Riyadh, Dammam, and Medina with fully certified export paperwork.</p>', 5),
('vietnam', 'Vietnam', 'USD', '🇻🇳', 'USD', 'https://blackgalaxygranite-india.com/exports/vietnam', 'Hai Phong Port, Ho Chi Minh City (Cat Lai Port), Da Nang, Quy Nhon', 'Southeast Asia Manufacturing Supply', 'Black Galaxy Granite Slabs Exporter to Vietnam', 'Black Galaxy Granite Slabs Exporter to Vietnam | Direct Factory India', 'Direct Indian quarry supply of Black Galaxy Granite Slabs and rough blocks to Vietnam stone processing factories and distributors. Shipped to Hai Phong and Ho Chi Minh City (Cat Lai).', 'Black Galaxy Granite Vietnam, Black Galaxy Granite Hai Phong, Black Galaxy Granite Ho Chi Minh, Indian Granite Exporter Vietnam', 'Partnering with Vietnamese stone processing factories, marble distributors, and architectural contractors with regular container shipments of gang saw slabs delivered to Hai Phong and Ho Chi Minh City.', 'Hai Phong Port (North), Cat Lai Port / Ho Chi Minh City (South), Da Nang Port', 'Approx. 16–22 Days ocean transit', '<p>Industrial and export processing specifications:</p><ul class=\"list-disc pl-5 space-y-1 mt-2 text-xs\"><li><strong>Gangsaw Slabs & Sawn Blocks:</strong> Suitable for local re-polishing, edge profiling, and re-export to global furniture markets.</li><li><strong>Strict Flexural Strength:</strong> Free of fissures and veins, allowing high yield in thin 18mm–20mm cutting.</li><li><strong>Competitive CIF Rates:</strong> Direct feeder connections from Chennai to Hai Phong and Cat Lai terminals.</li></ul>', '<p>Supporting Vietnamese granite processors and interior furniture manufacturers supplying international hospitality developments.</p>', 6),
('europe', 'Europe (EU)', 'EUR', '🇪🇺', 'EUR', 'https://blackgalaxygranite-india.com/exports/europe', 'Rotterdam, Antwerp, Hamburg, Genoa, Valencia, Marseille', 'CE Certified European Distribution', 'Black Galaxy Granite Slabs Exporter to Europe (EU)', 'Black Galaxy Granite Slabs Exporter to Europe (EU) | Direct Factory Chimakurthy', 'CE marked Black Galaxy Granite Slabs exporter to European stone distributors. Direct quarry container supply to Rotterdam, Antwerp, Hamburg, and Genoa. 20mm and 30mm gang saw slabs.', 'Black Galaxy Granite Europe, Black Galaxy Granite EU Exporter, Black Galaxy Granite Rotterdam, Black Galaxy Granite Antwerp, Indian Granite Slabs Europe', 'Supplying European natural stone distributors and fabricators across Germany, Netherlands, France, Italy, Belgium, and Spain with CE-certified Black Galaxy Granite slabs compliant with EN 1341 and EN 12057 standards.', 'Rotterdam (Netherlands), Antwerp (Belgium), Hamburg (Germany), Genoa (Italy), Valencia (Spain)', 'Approx. 26–34 Days direct container shipping', '<p>European Union regulatory and architectural parameters:</p><ul class=\"list-disc pl-5 space-y-1 mt-2 text-xs\"><li><strong>CE Marking & EN Standards:</strong> Tested for water absorption, compressive strength, and slip resistance under EN standards.</li><li><strong>EUTR & ESG Compliant:</strong> Sourced ethically from our owned licensed quarry benches in Chimakurthy with zero child labor.</li><li><strong>Bookmatched Bundles:</strong> Sequential gang saw slabs numbered in order for flawless vein and flake continuity.</li></ul>', '<p>Direct wholesale container supply into Northwest Europe via Rotterdam and Antwerp, and Southern Europe via Genoa and Valencia.</p>', 7),
('qatar', 'Qatar & Kuwait', 'QAR', '🇶🇦', 'QAR', 'https://blackgalaxygranite-india.com/exports/qatar-kuwait', 'Hamad Port (Doha), Shuwaikh Port (Kuwait), Shuaiba Port', 'GCC Luxury Commercial Supply', 'Black Galaxy Granite Slabs Exporter to Qatar & Kuwait', 'Black Galaxy Granite Slabs Exporter to Qatar & Kuwait | Direct India Factory', 'Direct container exporter of luxury Black Galaxy Granite Slabs to Qatar and Kuwait. Premium 30mm kitchen worktops and 20mm polished slabs shipped to Hamad Port and Shuwaikh Port.', 'Black Galaxy Granite Qatar, Black Galaxy Granite Kuwait, Black Galaxy Granite Hamad Port, Black Galaxy Granite Doha, Indian Granite Gulf Exporter', 'Exporting high-grade Black Galaxy Granite slabs to luxury villa contractors, commercial interior designers, and leading stone showrooms in Doha (Qatar) and Kuwait City.', 'Hamad Port (Doha, Qatar), Shuwaikh Port & Shuaiba Port (Kuwait)', 'Approx. 14–18 Days from Chennai Port', '<p>Gulf luxury residential and institutional standards:</p><ul class=\"list-disc pl-5 space-y-1 mt-2 text-xs\"><li><strong>Super Dark Obsidian Matrix:</strong> Selected Grade A slabs featuring deep black background with shimmering golden star clusters.</li><li><strong>30mm Solid Worktop Slabs:</strong> High demand for luxury villa kitchens, palace vanities, and hotel reception counters.</li><li><strong>Pristine Beveled Packaging:</strong> Extra foam padding and corner protectors preventing any edge chipping during transit.</li></ul>', '<p>Direct shipments into Doha (Hamad Port) and Kuwait City (Shuwaikh Port) with complete customs clearing documentation.</p>', 8),
('australia', 'Australia', 'AUD', '🇦🇺', 'AUD', 'https://blackgalaxygranite-india.com/exports/australia', 'Sydney (Port Botany), Melbourne, Brisbane, Fremantle (Perth), Adelaide', 'Oceania Direct Factory Supply', 'Black Galaxy Granite Slabs Exporter to Australia', 'Black Galaxy Granite Slabs Exporter to Australia | Direct Factory India', 'Direct quarry supply of Black Galaxy Granite Slabs to Australian stone wholesalers and fabricators. 20mm and 30mm polished gang saw slabs shipped to Sydney, Melbourne, Brisbane, and Fremantle.', 'Black Galaxy Granite Australia, Black Galaxy Granite Sydney, Black Galaxy Granite Melbourne, Indian Granite Exporter Australia, Black Galaxy Granite Perth', 'Delivering premium 20mm and 30mm Black Galaxy Granite slabs directly to Australian stone importers and monumental masons in Sydney, Melbourne, Brisbane, and Perth with rigid Australian biosecurity compliance.', 'Port Botany (Sydney), Port of Melbourne, Port of Brisbane, Fremantle Port (Perth)', 'Approx. 22–30 Days ocean transit from Chennai', '<p>Strict Australian Standards & Biosecurity compliance:</p><ul class=\"list-disc pl-5 space-y-1 mt-2 text-xs\"><li><strong>Department of Agriculture Biosecurity (DAFF):</strong> 100% compliant heat-treated ISPM-15 wooden packaging with certified treatment certificates.</li><li><strong>Crystalline Silica Compliance:</strong> Natural granite containing natural feldspar and bronzite mineral crystals, supplied with full Material Safety Data Sheets (MSDS).</li><li><strong>Jumbo Calibrated Formats:</strong> 310x190cm formats minimizing joins in wide Australian kitchen island benchtops.</li></ul>', '<p>Direct container distribution to leading Australian stone yards in New South Wales, Victoria, Queensland, and Western Australia.</p>', 9)
ON DUPLICATE KEY UPDATE `name`=VALUES(`name`), `dest_ports`=VALUES(`dest_ports`), `transit_days`=VALUES(`transit_days`), `intro`=VALUES(`intro`);

-- Seed Global Settings
INSERT INTO `tarqora_settings` (`setting_key`, `setting_value`) VALUES
('brand_name', 'TARQORA - Black Galaxy Granite India'),
('brand_logo_url', '/images/tarqora-brand-logo.svg'),
('brand_logo_height', '44'),
('canonical_domain', 'https://blackgalaxygranite-india.com'),
('company_email', 'export@blackgalaxygranite-india.com'),
('company_phone', '+91 98490 12345'),
('quarry_location', 'Chimakurthy, Prakasam District, Andhra Pradesh, India 523226'),
('sitemap_config', '{\"includeImages\":true,\"prettyXml\":true,\"homePriority\":\"1.0\",\"galleryPriority\":\"0.9\",\"countryPriority\":\"0.85\"}')
ON DUPLICATE KEY UPDATE `setting_value`=VALUES(`setting_value`);

SET FOREIGN_KEY_CHECKS = 1;

-- ===================================================================
-- END OF SCHEMA SCRIPT
-- ===================================================================
