USE hospital_db;

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

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');
