-- ==============================================
-- Migration: Add Admin Passcode Setting
-- ==============================================
-- Adds admin_passcode to app_settings table for protecting:
-- - Settings page access
-- - Odds/HDP editing
-- - Tips/Predictions editing

-- Insert admin passcode setting (default: 1234)
INSERT INTO app_settings (setting_key, setting_value, setting_type, description) VALUES
('admin_passcode', '1234', 'string', 'Admin passcode (4 digits) for protecting settings and odds editing')
ON DUPLICATE KEY UPDATE description = VALUES(description);

-- Verify insertion
SELECT * FROM app_settings WHERE setting_key = 'admin_passcode';
