-- Insert sample data for FLIX RADIO
USE flixradio_db;

-- Insert default admin user (password: admin123)
INSERT INTO users (email, password_hash, name, role, status, email_verified) VALUES
('admin@flixradio.com', '$2b$12$LQv3c1yqBWVHxkd0LHAkCOYz6TtxMQJqhN8/LewdBPj3bp.Htl0G.', 'Admin User', 'admin', 'active', true),
('user@flixradio.com', '$2b$12$LQv3c1yqBWVHxkd0LHAkCOYz6TtxMQJqhN8/LewdBPj3bp.Htl0G.', 'Regular User', 'user', 'active', true);

-- Insert sample radio stations
INSERT INTO stations (name, frequency, type, genre, country, state, city, description, stream_url, listeners, status, verified, added_by) VALUES
('181.FM The Buzz', '101.1', 'Internet', 'Alternative', 'United States', 'California', 'Los Angeles', 'Alternative Rock hits', 'http://listen.181fm.com/181-buzz_128k.mp3', 15420, 'active', true, 1),
('181.FM Power 181', '181.0', 'Internet', 'Pop', 'United States', 'California', 'Los Angeles', 'Today\'s Hit Music', 'http://listen.181fm.com/181-power_128k.mp3', 22340, 'active', true, 1),
('181.FM The Heart', '181.2', 'Internet', 'Pop', 'United States', 'New York', 'New York', 'Love Songs and Ballads', 'http://listen.181fm.com/181-heart_128k.mp3', 18900, 'active', true, 1),
('SomaFM Groove Salad', 'SF1', 'Internet', 'Electronic', 'United States', 'California', 'San Francisco', 'Downtempo and Chillout', 'http://ice1.somafm.com/groovesalad-128-mp3', 12450, 'active', true, 1),
('Radio Paradise', 'RP', 'Internet', 'Alternative', 'United States', 'California', 'Paradise', 'Eclectic Music Mix', 'http://stream.radioparadise.com/aac-128', 18750, 'active', true, 1);

-- Insert system settings
INSERT INTO settings (setting_key, setting_value, setting_type, description) VALUES
('site_name', 'FLIX RADIO', 'string', 'Site name displayed in header'),
('max_stations_per_user', '10', 'number', 'Maximum stations a user can submit'),
('require_station_approval', 'true', 'boolean', 'Whether new stations require admin approval'),
('default_station_status', 'pending', 'string', 'Default status for new stations');