-- ============================================
-- SEO & Schema Settings Migration
-- Adds new settings for enhanced SEO, social media, and structured data
-- ============================================

-- Navigation Icon
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('nav_icon', '');

-- Logo Settings (Image or Text)
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('logo_type', 'image');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('text_logo', '');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('text_logo_font', 'Playfair Display');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('text_logo_size', '24');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('text_logo_color', '#FF6B35');

-- SEO Settings
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('meta_title', '');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('meta_og_title', '');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('meta_og_description', '');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('meta_og_image', '');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('meta_og_url', '');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('meta_twitter_card', 'summary_large_image');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('meta_twitter_site', '');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('meta_twitter_title', '');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('meta_twitter_description', '');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('meta_twitter_image', '');

-- Search Engine Verification
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('google_verification', '');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('bing_verification', '');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('yandex_verification', '');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('pinterest_verification', '');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('google_analytics_id', '');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('google_tag_manager_id', '');

-- Schema.org Structured Data (JSON-LD)
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('schema_enabled', '1');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('schema_type', 'LocalBusiness');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('schema_name', '');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('schema_description', '');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('schema_telephone', '');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('schema_email', '');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('schema_url', '');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('schema_street_address', '');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('schema_address_locality', '');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('schema_address_region', '');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('schema_postal_code', '');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('schema_address_country', 'IN');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('schema_latitude', '');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('schema_longitude', '');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('schema_logo', '');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('schema_image', '');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('schema_price_range', '₹₹₹');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('schema_opening_hours', '');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('schema_opening_hours_spec', '');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('schema_closing_days', '');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('schema_founder', '');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('schema_founding_date', '');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('schema_area_served', '');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('schema_service_type', '');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('schema_facebook', '');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('schema_twitter', '');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('schema_instagram', '');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('schema_linkedin', '');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('schema_youtube', '');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('schema_pinterest', '');

-- Additional Organization Schema
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('schema_organization_type', 'TravelAgency');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('schema_alt_name', '');

-- Website Schema
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('schema_website_name', '');
INSERT IGNORE INTO `settings` (`setting_key`, `setting_value`) VALUES ('schema_publisher', '');

-- JSON-LD Output Preview (auto-generated, not stored)
-- This will be generated dynamically from the settings above
