-- Seed Data for Affiliate Program
-- Run this after schema.sql

-- ----------------------------
-- Default Program Configuration
-- ----------------------------
INSERT INTO `program_config` (`config_key`, `config_value`, `description`) VALUES
('total_payout_percent', '60', 'Total percentage of subscription paid out to affiliates'),
('levels_paid', '5', 'Number of upline levels that receive commissions'),
('company_name', 'TradePro Affiliates', 'Company/program name'),
('currency', 'USD', 'Default currency'),
('min_payout', '50', 'Minimum payout threshold in USD'),
('payout_day', '15', 'Day of month payouts are processed');

-- ----------------------------
-- Default Commission Splits (5 levels = 60% total)
-- ----------------------------
INSERT INTO `commission_splits` (`level`, `percent`, `is_active`) VALUES
(1, 25.00, 1),
(2, 15.00, 1),
(3, 10.00, 1),
(4, 6.00, 1),
(5, 4.00, 1);
