CREATE TABLE IF NOT EXISTS `settings` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `setting_group` varchar(50) NOT NULL COMMENT 'Group name e.g. shop, payment, delivery, used_battery, social, app',
  `setting_key` varchar(100) NOT NULL COMMENT 'Key within the group',
  `value` text DEFAULT NULL COMMENT 'JSON-encoded or plain string value',
  `is_public` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Whether visible to unauthenticated clients',
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_group_key` (`setting_group`,`setting_key`),
  KEY `idx_group` (`setting_group`),
  KEY `idx_public` (`is_public`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Seed minimum required rows (INSERT IGNORE is idempotent: skips existing rows)
INSERT IGNORE INTO `settings` (`setting_group`, `setting_key`, `value`, `is_public`) VALUES
  ('shop',        'name',                    'فروشگاه باتری',    1),
  ('shop',        'phone',                   NULL,               1),
  ('shop',        'mobile',                  NULL,               1),
  ('shop',        'address',                 NULL,               1),
  ('shop',        'city',                    'تهران',            1),
  ('shop',        'working_hours',           NULL,               1),
  ('payment',     'card_number',             NULL,               1),
  ('payment',     'card_holder',             NULL,               1),
  ('payment',     'card_bank',               NULL,               1),
  ('used_battery','rate_per_amp',            '6000',             1),
  ('delivery',    'free_delivery_threshold', '10000000',         1),
  ('delivery',    'delivery_fee',            '500000',           1),
  ('delivery',    'time_slots',             '[{"key":"morning","label":"صبح (۸-۱۲)"},{"key":"noon","label":"ظهر (۱۲-۱۶)"},{"key":"evening","label":"عصر (۱۶-۲۰)"},{"key":"night","label":"شب (۲۰-۲۳)"}]', 1),
  ('social',      'instagram',               NULL,               1),
  ('social',      'telegram',                NULL,               1),
  ('social',      'whatsapp',                NULL,               1),
  ('app',         'min_version',             '1.0.0',            1),
  ('app',         'latest_version',          '1.0.0',            1),
  ('app',         'force_update',            '0',                1),
  ('app',         'update_url',              NULL,               1);

