-- ════════════════════════════════════════════════════════
-- VaultFX — Seed Data
-- ════════════════════════════════════════════════════════

INSERT INTO currencies
  (currency_name, display_name, market_type, spread, pip_value, lot_size, min_trade, max_trade, sort_order)
VALUES
  ('EUR/USD', NULL, 'forex',0.0002,0.0001,100000,0.01,100,1),
  ('GBP/USD', NULL, 'forex',0.0003,0.0001,100000,0.01,100,2),
  ('USD/JPY', NULL, 'forex',0.003,0.01,100000,0.01,100,3),
  ('USD/CHF', NULL, 'forex',0.0003,0.0001,100000,0.01,100,4),
  ('AUD/USD', NULL, 'forex',0.0003,0.0001,100000,0.01,100,5),
  ('USD/INR', NULL, 'forex',0.05,0.01,100000,0.01,100,6),
  ('USD/TRY', NULL, 'forex',0.01,0.0001,100000,0.01,100,7),
  ('NZD/USD', NULL, 'forex',0.0004,0.0001,100000,0.01,100,8),
  ('USD/CAD', 'Canada', 'forex',0.0003,0.0001,100000,0.01,100,9),
  ('EUR/GBP', NULL, 'forex',0.0003,0.0001,100000,0.01,100,10),
  ('USD/AED', 'UAE', 'forex',0.0003,0.0001,100000,0.01,100,11),
  ('USD/ILS', 'Israel', 'forex',0.0003,0.0001,100000,0.01,100,12),
  ('USD/IRR', 'Iran', 'forex',1,1,100000,0.01,100,13),
  ('BTC/USD', NULL, 'crypto',5,0.01,1,0.001,10,1),
  ('ETH/USD', NULL, 'crypto',2,0.01,1,0.001,10,2),
  ('BNB/USD', NULL, 'crypto',1,0.01,1,0.001,10,3),
  ('XAU/USD','Gold Spot','commodity',0.5,0.01,100,0.01,50,1),
  ('XPT/USD','Platinum Spot','commodity',2,0.1,100,0.01,50,2),
  ('XAG/USD','Silver Spot','commodity',0.05,0.001,1000,0.01,50,3),
  ('XBR/USD','Brent Spot','commodity',0.05,0.01,1000,0.01,50,4),
  ('HG1/USD','Copper Spot','commodity',0.02,0.001,1000,0.01,50,5),
  ('XPD/USD','Palladium Spot','commodity',3,0.1,100,0.01,50,6),
  ('XAGG/EUR','Gram Silver Euro','commodity',0.001,0.0001,1000,0.01,50,7),
  ('GAU/USD','Gold Gram','commodity',0.05,0.01,1000,0.01,50,8);

-- one market_control row per currency (defaults to auto)
INSERT INTO market_control (currency_id, control_mode)
SELECT id, 'auto' FROM currencies;

INSERT INTO platform_settings (setting_key, setting_value) VALUES
  ('app_name','VaultFX'),
  ('app_tagline','Trade Smarter. Grow Faster.'),
  ('upi_id','vaultfx@okaxis'),
  ('upi_account_number','XXXXXXXXXXXX'),
  ('upi_ifsc','XXXXXXXXXX'),
  ('upi_bank_name','Axis Bank'),
  ('upi_branch','Main Branch'),
  ('usdt_address','TXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'),
  ('usd_to_inr_rate','83.50'),
  ('platform_spread','0.0002'),
  ('default_leverage','100'),
  ('razorpay_key_id','YOUR_KEY'),
  ('razorpay_key_secret','YOUR_SECRET'),
  ('twelve_data_api_key','YOUR_FREE_KEY'),
  ('claude_api_key','YOUR_KEY'),
  ('sms_api_key','YOUR_KEY'),
  ('smtp_host','smtp.gmail.com'),
  ('smtp_user','your@gmail.com'),
  ('smtp_pass','app_password'),
  ('support_email','support@vaultfx.com'),
  ('app_url','https://vaultfx.com'),
  ('min_deposit_inr','10000'),
  ('max_deposit_inr','1000000'),
  ('min_withdrawal_usd','10'),
  ('min_withdrawal_inr','10000'),
  ('referral_bonus_usd','5.00'),
  ('platform_win_rate','45'),
  ('bulk_trade_min_lot','1'),
  ('market_discovery_interval','900');