-- ============================================================
-- Migration 003: Appearance, Footer, Custom Code, Bar, Popup
-- ============================================================

-- ── 1. Appearance Settings ─────────────────────────────────────

INSERT IGNORE INTO system_settings (`key`, `value`, `type`, `group`) VALUES
('site_logo_url',         '',             'string',  'appearance'),
('site_favicon_url',      '',             'string',  'appearance'),
('site_primary_color',    '#087BFF',      'string',  'appearance'),
('site_contact_email',    '',             'string',  'general'),
('site_contact_phone',    '',             'string',  'general'),
('site_address',          '',             'string',  'general');

-- ── 2. Footer & Social ─────────────────────────────────────────

INSERT IGNORE INTO system_settings (`key`, `value`, `type`, `group`) VALUES
('footer_html',           '',             'string',  'appearance'),
('footer_copyright',      '',             'string',  'appearance'),
('social_facebook',       '',             'string',  'social'),
('social_instagram',      '',             'string',  'social'),
('social_twitter',        '',             'string',  'social'),
('social_whatsapp',       '',             'string',  'social'),
('social_telegram',       '',             'string',  'social'),
('social_youtube',        '',             'string',  'social');

-- ── 3. Custom Code Injection ───────────────────────────────────

INSERT IGNORE INTO system_settings (`key`, `value`, `type`, `group`) VALUES
('custom_head_code',       '',             'string',  'custom_code'),
('custom_body_start_code', '',             'string',  'custom_code'),
('custom_body_end_code',   '',             'string',  'custom_code');

-- ── 4. Announcement Bar ────────────────────────────────────────

INSERT IGNORE INTO system_settings (`key`, `value`, `type`, `group`) VALUES
('announcement_bar_enabled',     '0',                                                    'boolean', 'announce'),
('announcement_bar_html',        '',                                                     'string',  'announce'),
('announcement_bar_bg',          'linear-gradient(90deg,#087BFF,#7957FF,#16D9FF)',       'string',  'announce'),
('announcement_bar_dismissable', '1',                                                    'boolean', 'announce'),
('announcement_bar_animation',   'shimmer',                                              'string',  'announce');

-- ── 5. Popup ──────────────────────────────────────────────────

INSERT IGNORE INTO system_settings (`key`, `value`, `type`, `group`) VALUES
('popup_enabled',       '0',  'boolean', 'popup'),
('popup_code',          '',   'string',  'popup'),
('popup_delay_seconds', '3',  'integer', 'popup');