INSERT IGNORE INTO remedies (remedy_name, common_name, source, keynote_symptoms) VALUES
('Aconite', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Aethusa Cynapium', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Allium Cepa', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Aloe Soc', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Ammonium Carb', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Ammonium Mur', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Antim Crude', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Antim Tart', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Apis Mel', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Arnica Montana', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Ars Alb', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Arum Triph', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Baryta Carb', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Belladona', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Borax', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Bryonia Alba', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Calc Carb', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('CalcareaPhos', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Calendula', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Carbo Veg', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Chamomilla', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Cina', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Cinchona', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Cocculus', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Coffea Cruda', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Colchicum', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Colocynth', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Croton Tig', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('DioscoriaVillosa', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Drosera', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Dulcamara', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Euphrasia', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Gelsemium', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('HeparSulph', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Hypericum', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Ignatia', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Ipecac', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Ledum Pal', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Lycopodium', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Natrum Carb', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Natrum Mur', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Nux Vomica', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Podophyllum', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Pulsatilla', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Rhus Tox', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Ruta', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Silicea', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Spongia', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Sulphur', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Symphytum', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'),
('Calc Flour', '', 'BHMS Curriculum, Boericke', 'First BHMS Biochemic Salt'),
('Calc Phos', '', 'BHMS Curriculum, Boericke', 'First BHMS Biochemic Salt'),
('Calc Sulph', '', 'BHMS Curriculum, Boericke', 'First BHMS Biochemic Salt'),
('FerrPhos', '', 'BHMS Curriculum, Boericke', 'First BHMS Biochemic Salt'),
('Kali Mur', '', 'BHMS Curriculum, Boericke', 'First BHMS Biochemic Salt'),
('Kali Phos', '', 'BHMS Curriculum, Boericke', 'First BHMS Biochemic Salt'),
('Kali Sulph', '', 'BHMS Curriculum, Boericke', 'First BHMS Biochemic Salt'),
('Mag Phos', '', 'BHMS Curriculum, Boericke', 'First BHMS Biochemic Salt'),
('Nat Phos', '', 'BHMS Curriculum, Boericke', 'First BHMS Biochemic Salt'),
('Nat Sulph', '', 'BHMS Curriculum, Boericke', 'First BHMS Biochemic Salt'),
('Silicea', '', 'BHMS Curriculum, Boericke', 'First BHMS Biochemic Salt');-- BHMS Curriculum Remedies Insert Script
-- Reference: National Commission for Homoeopathy, Ministry of AYUSH, BHMS First Year Curriculum

INSERT INTO remedies (remedy_name, common_name, source, keynote_symptoms)
SELECT * FROM (
    SELECT 'Aconite', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Aethusa Cynapium', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Allium Cepa', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Aloe Soc', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Ammonium Carb', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Ammonium Mur', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Antim Crude', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Antim Tart', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Apis Mel', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Arnica Montana', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Ars Alb', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Arum Triph', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Baryta Carb', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Belladona', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Borax', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Bryonia Alba', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Calc Carb', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'CalcareaPhos', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Calendula', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Carbo Veg', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Chamomilla', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Cina', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Cinchona', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Cocculus', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Coffea Cruda', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Colchicum', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Colocynth', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Croton Tig', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'DioscoriaVillosa', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Drosera', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Dulcamara', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Euphrasia', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Gelsemium', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'HeparSulph', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Hypericum', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Ignatia', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Ipecac', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Ledum Pal', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Lycopodium', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Natrum Carb', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Natrum Mur', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Nux Vomica', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Podophyllum', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Pulsatilla', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Rhus Tox', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Ruta', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Silicea', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Spongia', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Sulphur', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Symphytum', '', 'BHMS Curriculum, Allen, Kent, Boericke', 'First BHMS Essential Remedy'
    UNION SELECT 'Calc Flour', '', 'BHMS Curriculum, Boericke', 'First BHMS Biochemic Salt'
    UNION SELECT 'Calc Phos', '', 'BHMS Curriculum, Boericke', 'First BHMS Biochemic Salt'
    UNION SELECT 'Calc Sulph', '', 'BHMS Curriculum, Boericke', 'First BHMS Biochemic Salt'
    UNION SELECT 'FerrPhos', '', 'BHMS Curriculum, Boericke', 'First BHMS Biochemic Salt'
    UNION SELECT 'Kali Mur', '', 'BHMS Curriculum, Boericke', 'First BHMS Biochemic Salt'
    UNION SELECT 'Kali Phos', '', 'BHMS Curriculum, Boericke', 'First BHMS Biochemic Salt'
    UNION SELECT 'Kali Sulph', '', 'BHMS Curriculum, Boericke', 'First BHMS Biochemic Salt'
    UNION SELECT 'Mag Phos', '', 'BHMS Curriculum, Boericke', 'First BHMS Biochemic Salt'
    UNION SELECT 'Nat Phos', '', 'BHMS Curriculum, Boericke', 'First BHMS Biochemic Salt'
    UNION SELECT 'Nat Sulph', '', 'BHMS Curriculum, Boericke', 'First BHMS Biochemic Salt'
    UNION SELECT 'Silicea', '', 'BHMS Curriculum, Boericke', 'First BHMS Biochemic Salt'
) AS new_remedies
WHERE NOT EXISTS (
    SELECT 1 FROM remedies WHERE remedies.remedy_name = new_remedies.remedy_name
);
