-- Seed Data

INSERT INTO admins (username, email, password, fullname, role) VALUES
('admin', 'admin@sendfast.com', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'Super Admin', 'super_admin'),
('finance', 'finance@sendfast.com', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'Finance Officer', 'finance'),
('support', 'support@sendfast.com', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'Support Agent', 'support'),
('compliance', 'compliance@sendfast.com', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'Compliance Officer', 'compliance');

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 settings (`key`, `value`, `description`) VALUES
('app_name', 'SendFast', 'Application name'),
('app_description', 'Fast & Secure Money Transfer Platform', 'Application description'),
('app_logo', '/assets/images/logo.png', 'Logo path'),
('app_favicon', '/assets/images/favicon.ico', 'Favicon path'),
('app_currency', 'USD', 'Default currency'),
('app_timezone', 'UTC', 'Default timezone'),
('app_debug', 'false', 'Debug mode'),
('app_maintenance', 'false', 'Maintenance mode'),
('transfer_fee_percentage', '2.5', 'Default transfer fee percentage'),
('transfer_fee_fixed', '1.00', 'Fixed transfer fee'),
('min_transfer', '10', 'Minimum transfer amount'),
('max_transfer', '10000', 'Maximum transfer amount'),
('referral_bonus', '5.00', 'Referral bonus amount'),
('otp_expiry', '300', 'OTP expiry in seconds'),
('smtp_host', '', 'SMTP host'),
('smtp_port', '587', 'SMTP port'),
('smtp_username', '', 'SMTP username'),
('smtp_password', '', 'SMTP password'),
('smtp_encryption', 'tls', 'SMTP encryption'),
('mail_from', 'noreply@sendfast.com', 'Mail from address'),
('mail_from_name', 'SendFast', 'Mail from name'),
('stripe_key', '', 'Stripe public key'),
('stripe_secret', '', 'Stripe secret key'),
('paypal_client', '', 'PayPal client ID'),
('paypal_secret', '', 'PayPal secret'),
('flutterwave_key', '', 'Flutterwave public key'),
('paystack_key', '', 'Paystack public key'),
('monnify_key', '', 'Monnify API key'),
('google_analytics', '', 'Google Analytics ID'),
('livechat_code', '', 'Live chat embed code'),
('social_facebook', '', 'Facebook URL'),
('social_twitter', '', 'Twitter URL'),
('social_instagram', '', 'Instagram URL'),
('social_linkedin', '', 'LinkedIn URL');

INSERT INTO email_templates (name, subject, body, variables) VALUES
('welcome', 'Welcome to {{app_name}}!', '<h2>Welcome, {{fullname}}!</h2><p>Thank you for joining {{app_name}}. Start sending money today!</p>', 'fullname,app_name'),
('otp', 'Your OTP Code', '<h2>OTP Verification</h2><p>Your OTP code is: <strong>{{otp}}</strong></p><p>Expires in 5 minutes.</p>', 'otp'),
('transfer_complete', 'Transfer Complete', '<h2>Transfer Successful</h2><p>Your transfer of {{amount}} {{currency}} has been sent to {{recipient}}.</p><p>Reference: {{reference}}</p>', 'amount,currency,recipient,reference'),
('transfer_failed', 'Transfer Failed', '<h2>Transfer Failed</h2><p>Your transfer of {{amount}} {{currency}} has failed. Contact support.</p>', 'amount,currency'),
('password_reset', 'Reset Your Password', '<h2>Password Reset</h2><p>Click <a href=\"{{link}}\">here</a> to reset your password.</p>', 'link'),
('kyc_approved', 'KYC Approved', '<h2>Verification Approved</h2><p>Your identity has been verified successfully.</p>', ''),
('kyc_rejected', 'KYC Rejected', '<h2>Verification Rejected</h2><p>Your document could not be verified. Reason: {{reason}}</p>', 'reason');

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');