CREATE TABLE IF NOT EXISTS specialities (
  id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(255) NOT NULL UNIQUE,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT IGNORE INTO specialities (name) VALUES
('Allergy and Immunology'),
('Anesthesiology'),
('Cardiology'),
('Cardiothoracic Surgery'),
('Dermatology'),
('Emergency Medicine'),
('Endocrinology'),
('Family Medicine'),
('Gastroenterology'),
('General Surgery'),
('Geriatrics'),
('Hematology'),
('Infectious Disease'),
('Internal Medicine'),
('Nephrology'),
('Neurology'),
('Neurosurgery'),
('Obstetrics and Gynecology'),
('Oncology'),
('Ophthalmology'),
('Orthopedic Surgery'),
('Otolaryngology'),
('Pathology'),
('Pediatrics'),
('Physical Medicine and Rehabilitation'),
('Plastic Surgery'),
('Psychiatry'),
('Pulmonology'),
('Radiology'),
('Rheumatology'),
('Urology');
