

INSERT INTO countries (name, iso_code, currency_code, currency_name, phone_code, flag) VALUES
('United States', 'US', 'USD', 'US Dollar', '+1', '🇺🇸'),
('United Kingdom', 'GB', 'GBP', 'British Pound', '+44', '🇬🇧'),
('Canada', 'CA', 'CAD', 'Canadian Dollar', '+1', '🇨🇦'),
('Australia', 'AU', 'AUD', 'Australian Dollar', '+61', '🇦🇺'),
('Germany', 'DE', 'EUR', 'Euro', '+49', '🇩🇪'),
('France', 'FR', 'EUR', 'Euro', '+33', '🇫🇷'),
('Italy', 'IT', 'EUR', 'Euro', '+39', '🇮🇹'),
('Spain', 'ES', 'EUR', 'Euro', '+34', '🇪🇸'),
('Netherlands', 'NL', 'EUR', 'Euro', '+31', '🇳🇱'),
('Nigeria', 'NG', 'NGN', 'Nigerian Naira', '+234', '🇳🇬'),
('Ghana', 'GH', 'GHS', 'Ghanaian Cedi', '+233', '🇬🇭'),
('Kenya', 'KE', 'KES', 'Kenyan Shilling', '+254', '🇰🇪'),
('South Africa', 'ZA', 'ZAR', 'South African Rand', '+27', '🇿🇦'),
('India', 'IN', 'INR', 'Indian Rupee', '+91', '🇮🇳'),
('Pakistan', 'PK', 'PKR', 'Pakistani Rupee', '+92', '🇵🇰'),
('Bangladesh', 'BD', 'BDT', 'Bangladeshi Taka', '+880', '🇧🇩'),
('Philippines', 'PH', 'PHP', 'Philippine Peso', '+63', '🇵🇭'),
('Mexico', 'MX', 'MXN', 'Mexican Peso', '+52', '🇲🇽'),
('Brazil', 'BR', 'BRL', 'Brazilian Real', '+55', '🇧🇷'),
('Japan', 'JP', 'JPY', 'Japanese Yen', '+81', '🇯🇵'),
('China', 'CN', 'CNY', 'Chinese Yuan', '+86', '🇨🇳'),
('South Korea', 'KR', 'KRW', 'South Korean Won', '+82', '🇰🇷'),
('Singapore', 'SG', 'SGD', 'Singapore Dollar', '+65', '🇸🇬'),
('UAE', 'AE', 'AED', 'UAE Dirham', '+971', '🇦🇪'),
('Saudi Arabia', 'SA', 'SAR', 'Saudi Riyal', '+966', '🇸🇦'),
('Turkey', 'TR', 'TRY', 'Turkish Lira', '+90', '🇹🇷'),
('Switzerland', 'CH', 'CHF', 'Swiss Franc', '+41', '🇨🇭'),
('Sweden', 'SE', 'SEK', 'Swedish Krona', '+46', '🇸🇪'),
('Norway', 'NO', 'NOK', 'Norwegian Krone', '+47', '🇳🇴'),
('Denmark', 'DK', 'DKK', 'Danish Krone', '+45', '🇩🇰');

INSERT INTO exchange_rates (currency_from, currency_to, rate, fee_percentage) VALUES
('USD', 'EUR', 0.92, 1.5),
('USD', 'GBP', 0.79, 1.5),
('USD', 'NGN', 1550.00, 2.0),
('USD', 'GHS', 15.20, 2.0),
('USD', 'KES', 145.00, 2.0),
('USD', 'ZAR', 18.50, 1.5),
('USD', 'INR', 83.50, 1.5),
('USD', 'PKR', 280.00, 2.0),
('USD', 'BDT', 110.00, 2.0),
('USD', 'PHP', 56.50, 1.5),
('USD', 'MXN', 17.20, 1.5),
('USD', 'BRL', 5.10, 2.0),
('USD', 'JPY', 150.00, 1.0),
('USD', 'CNY', 7.25, 1.0),
('USD', 'AED', 3.67, 0.5),
('USD', 'SAR', 3.75, 0.5),
('USD', 'CAD', 1.36, 1.0),
('USD', 'AUD', 1.53, 1.0),
('EUR', 'USD', 1.08, 1.0),
('GBP', 'USD', 1.26, 1.0),
('NGN', 'USD', 0.00065, 2.0);





INSERT INTO sms_templates (name, message, variables) VALUES
('otp', 'Your {{app_name}} OTP is: {{otp}}. Valid for 5 minutes.', 'app_name,otp'),
('transfer_alert', 'Your transfer of {{amount}} {{currency}} to {{recipient}} was successful. Ref: {{reference}}', 'amount,currency,recipient,reference'),
('login_alert', 'New login to your {{app_name}} account.', 'app_name');
