




CREATE TABLE IF NOT EXISTS settings (
    id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    setting_key VARCHAR(100) NOT NULL UNIQUE,
    setting_value TEXT DEFAULT NULL,
    autoload TINYINT(1) NOT NULL DEFAULT 1,
    INDEX idx_autoload (autoload)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO settings (setting_key, setting_value, autoload) VALUES
('active_theme', 'simply', 1),
('ads_accent_color', '#dc2626', 1),
('ads_closeable', '1', 1),
('ads_popunder_enabled', '0', 1),
('ads_txt', '', 1),
('agegate_cookie_days', '30', 1),
('agegate_mode', 'button', 1),
('agegate_show_terms', '1', 1),
('agegate_style', 'gradient', 1),
('album_card_border_radius', '8', 1),
('album_card_grid_gap', '4', 1),
('album_card_show_count', '1', 1),
('album_card_show_date', '1', 1),
('album_card_show_thumbnail_hover', '1', 1),
('album_card_show_title', '1', 1),
('album_card_show_views', '1', 1),
('album_card_title_lines', '1', 1),
('albums_default_sort', 'trending', 1),
('albums_per_page', '50', 1),
('albums_per_row', '5', 1),
('albums_display_mode', 'grid', 1),
('albums_nav_mode', 'pages', 1),
('albums_sidebar_categories', '1', 1),
('albums_sidebar_channels', '1', 1),
('albums_sidebar_performers', '1', 1),
('albums_sidebar_tags', '1', 1),
('allowed_image_types', 'jpg,jpeg,png,gif,webp', 0),
('allowed_video_types', 'mp4,webm,ogg', 0),
('analytics_code', '', 0),
('auto_detect_language', '0', 1),
('backup_ftp_host', '', 1),
('backup_ftp_passive', '1', 1),
('backup_ftp_path', '/backups', 1),
('backup_ftp_port', '21', 1),
('backup_ftp_ssl', '0', 1),
('backup_ftp_user', '', 1),
('backup_storage', 'local', 1),
('captcha_on_register', '1', 1),
('captcha_provider', 'none', 1),
('captcha_secret_key', '', 1),
('captcha_site_key', '', 1),
('card_border_radius', '5', 1),
('card_grid_gap', '4', 1),
('card_meta_left', 'views', 1),
('card_meta_right', 'time', 1),
('card_show_duration', '1', 1),
('card_show_thumbnail_hover', '1', 1),
('card_show_title', '1', 1),
('card_title_lines', '1', 1),
('catalogue_api_url', 'https://tubepress.io/v1', 0),
('catalogue_auto_publish', '1', 0),
('catalogue_credit_rate', '0.01', 1),
('catalogue_download_thumbnails', '1', 0),
('catalogue_max_workers', '3', 1),
('catalogue_service_paused', '0', 1),
('categories_default_sort', 'trending', 1),
('categories_per_page', '30', 1),
('categories_per_row', '5', 1),
('channels_as_users', '1', 1),
('channels_default_sort', 'trending', 1),
('channels_per_page', '30', 1),
('channels_per_row', '6', 1),
('color_bg', '', 1),
('color_bg_card', '', 1),
('color_bg_card_opacity', '100', 1),
('color_bg_dark', '', 1),
('color_bg_dark_opacity', '100', 1),
('color_bg_opacity', '100', 1),
('color_bg_surface', '', 1),
('color_bg_surface_opacity', '100', 1),
('color_border', '', 1),
('color_border_opacity', '100', 1),
('color_primary', '#ff5d85', 1),
('color_primary_dark', '#ff5d85', 1),
('color_primary_dark_opacity', '100', 1),
('color_primary_opacity', '100', 1),
('color_secondary', '', 1),
('color_secondary_opacity', '100', 1),
('color_text', '', 1),
('color_text_muted', '', 1),
('color_text_muted_opacity', '100', 1),
('color_text_opacity', '100', 1),
('comments_enabled', '1', 1),
('comments_moderation', '0', 1),
('contact_email', '', 1),
('ctr_bot_filter', '1', 1),
('ctr_click_rate', '120', 1),
('ctr_completion_on', '1', 1),
('ctr_enabled', '1', 1),
('ctr_entity_tracking', '1', 1),
('ctr_event_retention', '8', 1),
('ctr_fatigue_divisor', '2000', 1),
('ctr_freshness_max', '3', 1),
('ctr_imp_rate', '600', 1),
('ctr_preset', 'balanced', 1),
('ctr_prior_weight', '30', 1),
('ctr_quality_cap', '4', 1),
('ctr_recalc_interval', '3600', 1),
('ctr_retention_max', '1.4', 1),
('ctr_retention_min', '0.6', 1),
('ctr_rotation_enabled', '1', 1),
('ctr_tested_threshold', '200', 1),
('default_sort', 'trending', 1),
('default_video_type', 'hetero', 1),
('dk_color_bg', '', 1),
('dk_color_bg_card', '', 1),
('dk_color_bg_card_opacity', '100', 1),
('dk_color_bg_dark', '', 1),
('dk_color_bg_dark_opacity', '100', 1),
('dk_color_bg_opacity', '100', 1),
('dk_color_bg_surface', '', 1),
('dk_color_bg_surface_opacity', '100', 1),
('dk_color_border', '', 1),
('dk_color_border_opacity', '100', 1),
('dk_color_primary', '', 1),
('dk_color_primary_opacity', '100', 1),
('dk_color_text', '', 1),
('dk_color_text_muted', '#f3f3f3', 1),
('dk_color_text_muted_opacity', '100', 1),
('dk_color_text_opacity', '100', 1),
('entity_autotranslate_album_category', '0', 1),
('entity_autotranslate_album_tag', '0', 1),
('entity_autotranslate_category', '0', 1),
('entity_autotranslate_tag', '0', 1),
('footer_config', '{\"columns\":[{\"type\":\"logo\",\"title\":\"Column 1\"},{\"type\":\"navigation\",\"title\":\"Column 2\"},{\"type\":\"pages\",\"title\":\"Column 3\",\"page_ids\":[]},{\"type\":\"badges\",\"title\":\"Column 4\",\"badges\":[{\"icon\":\"shield\",\"label\":\"18+ Only\"},{\"icon\":\"upload\",\"label\":\"Free Content\"},{\"icon\":\"video\",\"label\":\"HD Videos\"}]}],\"bottom\":{\"show_copyright\":true,\"copyright_text\":\"\",\"show_disclaimer\":true,\"disclaimer_text\":\"\",\"show_social\":true},\"social\":{\"twitter\":\"\",\"instagram\":\"\",\"reddit\":\"\",\"telegram\":\"\",\"discord\":\"\"}}', 1),
('footer_text', '', 0),
('import_ai_desc_prompt', 'Rewrite this porn video description to be unique and SEO-friendly. Keep it concise (2-3 sentences max). Do NOT use markdown or HTML.', 1),
('import_ai_title_prompt', 'Rewrite this porn video title to be unique and SEO-friendly while keeping the same meaning. Keep it natural and under 80 characters. Do NOT add quotes around the title.', 1),
('import_ai_translate_desc_prompt', 'Translate this English porn video description into each target language.\n\nRULES:\n1. Translate ALL words to the target language (NO mixing languages)\n2. Keep the same meaning, tone and adult terminology (native speaker quality)\n3. Do NOT use markdown or HTML\n4. Output ONLY the translation inside the XML tags', 1),
('import_ai_translate_prompt', 'Translate this English porn title (max 60 chars each).\n\nRULES:\n1. Translate ALL words to target language (NO mixing languages)\n2. Keep same meaning (do not add or remove words)\n3. Natural phrasing (native speaker quality)\n4. Understand adult content terminology', 1),
('mail_method', 'php', 1),
('menu_categories', '1', 1),
('menu_channels', '0', 1),
('menu_config', '{"items":[{"id":"home","type":"internal","label":"Home","icon":"house","children":[],"url":"/"},{"id":"categories","type":"internal","label":"Categories","icon":"grid-2","children":[],"url":"/categories","mega_menu":true},{"id":"tags","type":"internal","label":"Tags","icon":"tags","children":[],"url":"/tags"},{"id":"pornstars","type":"internal","label":"Pornstars","icon":"users","children":[],"url":"/pornstars"},{"id":"channels","type":"internal","label":"Channels","icon":"clapperboard","children":[],"url":"/channels"},{"id":"albums","type":"internal","label":"Albums","url":"/albums","icon":"images","children":[]},{"id":"new_videos","type":"internal","label":"New Videos","icon":"sparkles","children":[{"id":"top_rated","type":"internal","label":"Top Rated","icon":"star","children":[],"url":"/videos/top-rated"},{"id":"most_viewed","type":"internal","label":"Most Viewed","icon":"eye","children":[],"url":"/videos/most-viewed"},{"id":"most_favorited","type":"internal","label":"Most Favorited","icon":"heart","children":[],"url":"/videos/most-favorited"}],"url":"/videos/new"},{"id":"vtype_switcher","type":"internal","label":"Video Type Switcher","icon":"shuffle","children":[],"url":"#"}]}', 1),
('menu_pornstars', '0', 1),
('menu_search', '1', 1),
('menu_tags', '0', 1),
('meta_description', '', 0),
('meta_keywords', '', 1),
('performers_default_sort', 'trending', 1),
('performers_per_page', '30', 1),
('performers_per_row', '6', 1),
('player_allow_download', '1', 1),
('player_doubleclick_fullscreen', '1', 1),
('player_loop', '0', 1),
('player_playback_rate', '1', 1),
('registration_enabled', '1', 1),
('related_videos_count', '8', 1),
('seo_bing_verify', '', 1),
('seo_custom_body', '', 1),
('seo_custom_head', '', 1),
('seo_desc_category', 'Browse {count} videos in {name}. {description_short}', 1),
('seo_desc_channel', '{name} videos from {site_name}. {description_short}', 1),
('seo_desc_page', '{excerpt}', 1),
('seo_desc_performer', '{name} videos. {bio_short} Watch {count} videos on {site_name}.', 1),
('seo_desc_search', 'Search results for {query} on {site_name}. {count} videos found.', 1),
('seo_desc_tag', 'Videos tagged {name}. {count} videos available on {site_name}.', 1),
('seo_desc_video', 'Watch {title} online. {description_short}', 1),
('seo_fb_app_id', '', 1),
('seo_ga4_id', '', 1),
('seo_google_verify', '', 1),
('seo_home_meta_description', '', 1),
('seo_home_title', '{site_name}{sep}{type}', 1),
('seo_noindex_categories', '0', 1),
('seo_noindex_channels', '0', 1),
('seo_noindex_entire_site', '0', 1),
('seo_noindex_paginated', '0', 1),
('seo_noindex_performers', '0', 1),
('seo_noindex_search', '1', 1),
('seo_noindex_tags', '0', 1),
('seo_og_auto_ctr', '1', 1),
('seo_og_image', '', 1),
('seo_pagination_suffix', '- Page {page}', 1),
('seo_pagination_title', '1', 1),
('seo_pattern_category', '{name} {sep} {site_name}', 1),
('seo_pattern_channel', '{name} {sep} {site_name}', 1),
('seo_pattern_page', '{title} {sep} {site_name}', 1),
('seo_pattern_performer', '{name} {sep} {site_name}', 1),
('seo_pattern_search', 'Search: {query} {sep} {site_name}', 1),
('seo_pattern_tag', '{name} {sep} {site_name}', 1),
('seo_pattern_video', '{title} {sep} {site_name}', 1),
('seo_pinterest_verify', '', 1),
('seo_robots_txt', '', 1),
('seo_sitemap_categories', '1', 1),
('seo_sitemap_channels', '1', 1),
('seo_sitemap_hreflang', '1', 1),
('seo_sitemap_image_tags', '1', 1),
('seo_sitemap_max_urls', '25000', 1),
('seo_sitemap_pages', '1', 1),
('seo_sitemap_performers', '1', 1),
('seo_sitemap_tags', '1', 1),
('seo_sitemap_video_tags', '1', 1),
('seo_sitemap_videos', '1', 1),
('seo_title_separator', ' - ', 1),
('seo_twitter_card', 'summary_large_image', 1),
('seo_twitter_handle', '', 1),
('seo_type_label_gay', 'Gay', 1),
('seo_type_label_hentai', 'Hentai', 1),
('seo_type_label_hetero', 'Straight', 1),
('seo_yandex_verify', '', 1),
('simply_channels_per_row', '6', 1),
('simply_dark_mode_default', 'dark', 1),
('simply_dark_mode_enabled', '1', 1),
('simply_hp_default_sort', 'trending', 1),
('simply_hp_sort_title_newest', 'LATEST VIDEOS', 1),
('simply_hp_sort_title_popular', 'MOST VIEWED', 1),
('simply_hp_sort_title_top_rated', 'TOP RATED', 1),
('simply_hp_sort_title_trending', 'TRENDING', 1),
('simply_hp_title_watched', '', 1),
('simply_hp_watched_enabled', '1', 1),
('simply_nav_style', 'full', 1),
('simply_performers_per_row', '6', 1),
('simply_topbar_bg_color', '#ffffff', 1),
('simply_topbar_bg_opacity', '100', 1),
('simply_topbar_dark_bg_color', '#1d2839', 1),
('simply_topbar_dark_bg_opacity', '100', 1),
('simply_topbar_dark_hover_text_color', '', 1),
('simply_topbar_dark_hover_text_opacity', '100', 1),
('simply_topbar_dark_text_color', '#e2e8f1', 1),
('simply_topbar_dark_text_opacity', '100', 1),
('simply_topbar_enabled', '0', 1),
('simply_topbar_hover_bg_color', '#4d4d4d', 1),
('simply_topbar_hover_bg_opacity', '100', 1),
('simply_topbar_hover_text_color', '#ff9d9d', 1),
('simply_topbar_hover_text_opacity', '100', 1),
('simply_topbar_link_bold', '0', 1),
('simply_topbar_link_hover_underline', '1', 1),
('simply_topbar_link_italic', '0', 1),
('simply_topbar_link_underline', '0', 1),
('simply_topbar_links', '[]', 1),
('simply_topbar_text', '', 1),
('simply_topbar_text_bold', '0', 1),
('simply_topbar_text_color', '#000000', 1),
('simply_topbar_text_italic', '0', 1),
('simply_topbar_text_opacity', '100', 1),
('site_background', '', 1),
('site_background_mode', 'cover', 1),
('site_description', 'The best video site', 1),
('site_favicon', '1771680041_470bc1916341fe90.png', 1),
('site_logo', '1775303027_a42bea267d27196b.webp', 1),
('site_logo_dark', '1775303027_2ca4e977bddba758.webp', 1),
('site_logo_height_desktop', '26', 1),
('site_logo_height_mobile', '18', 1),
('site_max_width', '1600', 1),
('site_name', 'My Video Site', 1),
('site_padding_desktop', '24', 1),
('site_padding_mobile', '10', 1),
('site_url', '', 1),
('smtp_encryption', 'tls', 1),
('smtp_from_email', '', 1),
('smtp_from_name', '', 1),
('smtp_host', '', 1),
('smtp_pass', '', 1),
('smtp_port', '587', 1),
('smtp_user', '', 1),
('social_discord', '', 1),
('social_instagram', '', 1),
('social_reddit', '', 1),
('social_telegram', '', 1),
('social_twitter', '', 1),
('spam_duplicate', '1', 1),
('spam_duplicate_window', '60', 1),
('spam_honeypot', '1', 1),
('spam_length', '1', 1),
('spam_links', '1', 1),
('spam_max_length', '5000', 1),
('spam_max_links', '0', 1),
('spam_min_length', '2', 1),
('spam_ratelimit', '1', 1),
('spam_ratelimit_day', '30', 1),
('spam_ratelimit_hour', '5', 1),
('spam_timegate', '1', 1),
('spam_timegate_seconds', '3', 1),
('timezone', 'UTC', 1),
('transcode_enabled', '1', 1),
('transcode_ffmpeg_path', '', 1),
('transcode_max_per_tick', '0', 1),
('transcode_preview', '1', 1),
('transcode_preview_seconds', '8', 1),
('transcode_thumb_time', '0', 1),
('transcode_thumbs', '1', 1),
('transcode_timeline', '0', 1),
('transcode_timeline_count', '10', 1),
('transcode_timeline_start', '0', 1),
('transcode_trim_start', '10', 1),
('upload_max_size', '524288000', 0),
('video_type_slug_gay', '', 1),
('video_type_slug_hentai', '', 1),
('video_type_slug_hetero', '', 1),
('videos_per_page', '50', 1),
('videos_per_row', '5', 1),
('watch_show_categories', '1', 1),
('watch_show_channels', '1', 1),
('watch_show_date', '1', 1),
('watch_show_duration', '1', 1),
('watch_show_favorites', '1', 1),
('watch_show_likes', '1', 1),
('watch_show_pornstars', '1', 1),
('watch_show_tags', '1', 1),
('watch_show_views', '1', 1),
('watermark_enabled', '0', 1),
('watermark_image', '', 1),
('watermark_max_width', '15', 1),
('watermark_opacity', '100', 1),
('watermark_padding', '3', 1),
('watermark_position', 'top-left', 1);
