-- Seed: Repertory Chapters
-- Insert Kent's Repertory main chapters

INSERT INTO `rubrics` (`chapter_name`, `rubric_name`, `full_path`, `level`) VALUES
('MIND', 'MIND', 'MIND', 1),
('VERTIGO', 'VERTIGO', 'VERTIGO', 1),
('HEAD', 'HEAD', 'HEAD', 1),
('EYE', 'EYE', 'EYE', 1),
('EAR', 'EAR', 'EAR', 1),
('NOSE', 'NOSE', 'NOSE', 1),
('FACE', 'FACE', 'FACE', 1),
('MOUTH', 'MOUTH', 'MOUTH', 1),
('STOMACH', 'STOMACH', 'STOMACH', 1),
('ABDOMEN', 'ABDOMEN', 'ABDOMEN', 1),
('RECTUM', 'RECTUM', 'RECTUM', 1),
('STOOL', 'STOOL', 'STOOL', 1),
('URINARY ORGANS', 'URINARY ORGANS', 'URINARY ORGANS', 1),
('MALE SEXUAL ORGANS', 'MALE SEXUAL ORGANS', 'MALE SEXUAL ORGANS', 1),
('FEMALE SEXUAL ORGANS', 'FEMALE SEXUAL ORGANS', 'FEMALE SEXUAL ORGANS', 1),
('RESPIRATION', 'RESPIRATION', 'RESPIRATION', 1),
('COUGH', 'COUGH', 'COUGH', 1),
('CHEST', 'CHEST', 'CHEST', 1),
('BACK', 'BACK', 'BACK', 1),
('EXTREMITIES', 'EXTREMITIES', 'EXTREMITIES', 1),
('SLEEP', 'SLEEP', 'SLEEP', 1),
('FEVER', 'FEVER', 'FEVER', 1),
('SKIN', 'SKIN', 'SKIN', 1),
('GENERALITIES', 'GENERALITIES', 'GENERALITIES', 1)
ON DUPLICATE KEY UPDATE id=id;