-- =====================================================
-- TELEGRAM INVESTMENT BOT - INITIAL DATA
-- =====================================================
-- IMPORTANT: Select your database in phpMyAdmin BEFORE importing
-- This file contains: Languages, Admin User, System Settings, Sample Plans
-- =====================================================

-- Insert default languages
INSERT INTO `languages` (`code`, `name`, `native_name`, `flag_emoji`, `is_active`) VALUES
('en', 'English', 'English', '🇺🇸', 1),
('es', 'Spanish', 'Español', '🇪🇸', 1),
('fr', 'French', 'Français', '🇫🇷', 1),
('de', 'German', 'Deutsch', '🇩🇪', 1),
('ru', 'Russian', 'Русский', '🇷🇺', 1),
('ar', 'Arabic', 'العربية', '🇸🇦', 1);

-- Insert default admin (username: admin, password: admin123)
-- NOTE: Change this password immediately in production!
INSERT INTO `admin_users` (`username`, `password_hash`, `email`, `role`) VALUES
('admin', '$2y$12$fCZ1dP55jWN6LhmzANU8yeb01h20Sfk2R.WQFjv9Y2A1rJsyZcbdK', 'admin@example.com', 'super_admin');

-- Insert system settings
INSERT INTO `system_settings` (`setting_key`, `setting_value`, `setting_type`, `description`) VALUES
('bot_token', '', 'string', 'Telegram Bot API Token'),
('bot_username', '', 'string', 'Telegram Bot Username'),
('support_username', '@support', 'string', 'Support Telegram Username'),
('min_withdrawal_btc', '0.001', 'number', 'Minimum BTC withdrawal'),
('min_withdrawal_eth', '0.01', 'number', 'Minimum ETH withdrawal'),
('min_withdrawal_usdt', '10', 'number', 'Minimum USDT withdrawal'),
('min_withdrawal_ltc', '0.1', 'number', 'Minimum LTC withdrawal'),
('min_withdrawal_trx', '100', 'number', 'Minimum TRX withdrawal'),
('min_withdrawal_dash', '0.1', 'number', 'Minimum DASH withdrawal'),
('withdrawal_fee_percentage', '2', 'number', 'Withdrawal fee percentage'),
('referral_commission', '5', 'number', 'Referral commission percentage'),
('enable_registration', 'true', 'boolean', 'Allow new user registration');

-- Insert sample deposit addresses (REPLACE WITH REAL ADDRESSES)
INSERT INTO `deposit_addresses` (`currency`, `address`, `label`) VALUES
('BTC', 'bc1qxy2kgdygjrsqtzq2n0yrf2493p83kkfjhx0wlh', 'BTC Wallet 1'),
('ETH', '0x742d35Cc6634C0532925a3b844Bc9e7595f0bEb', 'ETH Wallet 1'),
('USDT', 'TYDzsYUEpvnYmQk4zGP9sWWcTEd2MiAtW6', 'USDT Wallet 1'),
('LTC', 'LTC1qxy2kgdygjrsqtzq2n0yrf2493p83kkfjhx0wlh', 'LTC Wallet 1'),
('TRX', 'TYDzsYUEpvnYmQk4zGP9sWWcTEd2MiAtW6', 'TRX Wallet 1'),
('DASH', 'Xxy2kgdygjrsqtzq2n0yrf2493p83kkfjhx0wlh', 'DASH Wallet 1');

-- Insert investment plans
INSERT INTO `investment_plans` (`name`, `currency`, `min_amount`, `max_amount`, `roi_percentage`, `duration_days`, `description`, `display_order`) VALUES
('Capital', 'BTC', 0.001, 0.01, 15.00, 7, 'Basic investment plan with 15% ROI in 7 days', 1),
('Gold', 'BTC', 0.01, 0.1, 25.00, 14, 'Gold plan with 25% ROI in 14 days', 2),
('Diamond', 'BTC', 0.1, 1.0, 40.00, 30, 'Diamond plan with 40% ROI in 30 days', 3),
('Mega', 'BTC', 1.0, 10.0, 75.00, 60, 'Mega plan with 75% ROI in 60 days', 4),
('Capital', 'ETH', 0.01, 0.1, 15.00, 7, 'Basic investment plan with 15% ROI in 7 days', 1),
('Gold', 'ETH', 0.1, 1.0, 25.00, 14, 'Gold plan with 25% ROI in 14 days', 2),
('Diamond', 'ETH', 1.0, 10.0, 40.00, 30, 'Diamond plan with 40% ROI in 30 days', 3),
('Mega', 'ETH', 10.0, 100.0, 75.00, 60, 'Mega plan with 75% ROI in 60 days', 4),
('Capital', 'USDT', 100, 1000, 15.00, 7, 'Basic investment plan with 15% ROI in 7 days', 1),
('Gold', 'USDT', 1000, 10000, 25.00, 14, 'Gold plan with 25% ROI in 14 days', 2),
('Diamond', 'USDT', 10000, 100000, 40.00, 30, 'Diamond plan with 40% ROI in 30 days', 3),
('Capital', 'LTC', 0.1, 1.0, 15.00, 7, 'Basic investment plan with 15% ROI in 7 days', 1),
('Gold', 'LTC', 1.0, 10.0, 25.00, 14, 'Gold plan with 25% ROI in 14 days', 2);

-- End of initial data