-- ── system_settings (key-value store for API integrations) ──
CREATE TABLE IF NOT EXISTS `app_settings` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `setting_key` varchar(100) NOT NULL UNIQUE,
  `setting_value` text DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT IGNORE INTO `app_settings` (`setting_key`,`setting_value`,`updated_at`) VALUES
('sms_api_url',   'https://smsapi.hormuud.com/api/SendSMS', NOW()),
('sms_user',      '', NOW()),
('sms_pass',      '', NOW()),
('sms_sender_id', '', NOW()),
('evc_api_url',   'https://api.waafipay.net/asm', NOW()),
('evc_merchant_uid', 'M0913862', NOW()),
('evc_api_user_id',  '1007968', NOW()),
('evc_api_key',      'API-1629712214AHX', NOW());