-- Seed: Sample Doctors
-- Insert sample doctor accounts

-- Password: doctor123
INSERT INTO `users` (`username`, `password_hash`, `email`, `full_name`, `role`, `is_active`) VALUES
('dr_smith', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'smith@homoeopathy.com', 'Dr. John Smith', 'doctor', 1),
('dr_jones', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'jones@homoeopathy.com', 'Dr. Sarah Jones', 'doctor', 1),
('dr_kumar', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'kumar@homoeopathy.com', 'Dr. Raj Kumar', 'doctor', 1)
ON DUPLICATE KEY UPDATE id=id;

-- Sample subscriptions for doctors
INSERT INTO `subscriptions` (`user_id`, `plan_type`, `start_date`, `end_date`, `amount`, `is_active`) 
SELECT id, '1year', CURDATE(), DATE_ADD(CURDATE(), INTERVAL 365 DAY), 89.99, 1
FROM users WHERE role = 'doctor'
ON DUPLICATE KEY UPDATE id=id;