-- Clean up duplicate users completely
DELETE FROM users WHERE role = 'agent';

-- Re-insert clean agent data
INSERT INTO users (username, email, phone, password, role, balance, float_balance, is_active) VALUES
('agent_dhaka', 'agent1@joybangla.com', '01787203830', '$2b$10$tfgEpZpHCc1IAhJGZqKvJOxK8qK8qK8qK8qK8qK8qK8qK8qK8qK8qK', 'agent', 0.00, 50000.00, TRUE),
('agent_chittagong', 'agent2@joybangla.com', '01850001643', '$2b$10$tfgEpZpHCc1IAhJGZqKvJOxK8qK8qK8qK8qK8qK8qK8qK8qK8qK8qK', 'agent', 0.00, 50000.00, TRUE);
