USE hospital_db;

INSERT IGNORE INTO roles (name) VALUES ('admin'), ('doctor'), ('receptionist'), ('pharmacy');

INSERT IGNORE INTO users (role_id, full_name, email, password, phone, created_by)
VALUES (1, 'Super Admin', 'admin@hospital.com', '$2b$10$rQnSEm6XDj8L/RwAHr7x7.t8DzM0nN6tGjJ0VkK1Ym5oZBvPqCkUa', '+1234567890', NULL),
       (1, 'Secondary Admin', 'admin2@hospital.com', '$2b$10$TFFY8bcql8T0qQcW2DSj8evZ1.fAO0L50iNrtGGD0yHKXgkfDMowa', '+1234567891', NULL);

INSERT IGNORE INTO departments (name, description) VALUES
('ENT','Ear, Nose & Throat'),
('Cardiology','Heart and blood vessel care'),
('General Surgery','General surgical services'),
('Neurology','Brain and nervous system care'),
('Dentistry','Oral health and dental care'),
('Orthopedics','Bone and joint care'),
('Gynecology','Women’s health'),
('Pediatrics','Child health'),
('Dermatology','Skin health');