
-- Ensure remedy_name is unique to prevent duplicates
ALTER TABLE remedies ADD UNIQUE (remedy_name);

INSERT IGNORE INTO remedies (remedy_name, remedy_short_name, common_name, family, keynote_symptoms, clinical_indications, potency_range, is_popular) VALUES

-- Popular Acute Remedies
('Aconitum Napellus', 'Acon', 'Monkshood', 'Ranunculaceae', 
'Sudden onset, fear, anxiety, restlessness, shock', 
'Fever, colds, fear, anxiety attacks, sudden inflammation', 
'6C to 1M', 1),

('Arnica Montana', 'Arn', 'Leopards Bane', 'Compositae', 
'Trauma, bruising, soreness, muscle pain', 
'Injuries, bruises, trauma, post-surgical recovery, muscle soreness', 
'6C to 200C', 1),

('Belladonna', 'Bell', 'Deadly Nightshade', 'Solanaceae', 
'Sudden high fever, throbbing, redness, heat', 
'High fever, headache, throat infections, inflammations', 
'6C to 1M', 1),

('Bryonia Alba', 'Bry', 'White Bryony', 'Cucurbitaceae', 
'Dry symptoms, worse motion, thirst for large quantities', 
'Dry cough, constipation, arthritis, headaches worse with motion', 
'6C to 200C', 1),

('Nux Vomica', 'Nux-v', 'Poison Nut', 'Loganiaceae', 
'Digestive issues, irritability, chilly, overindulgence', 
'Indigestion, constipation, hangovers, irritability, insomnia', 
'6C to 1M', 1),

('Arsenicum Album', 'Ars', 'White Arsenic', 'Mineral', 
'Anxiety, restlessness, fastidious, burning pains relieved by heat', 
'Food poisoning, anxiety, asthma, skin conditions', 
'6C to 1M', 1),

('Pulsatilla Nigricans', 'Puls', 'Wind Flower', 'Ranunculaceae', 
'Changeable symptoms, weepy, mild temperament, worse warmth', 
'Colds, earaches, digestive issues, hormonal problems', 
'6C to 200C', 1),

('Rhus Toxicodendron', 'Rhus-t', 'Poison Ivy', 'Anacardiaceae', 
'Joint pain better with motion, restlessness, worse initial motion', 
'Arthritis, sprains, skin rashes, joint stiffness', 
'6C to 200C', 1),

('Sulphur', 'Sulph', 'Sublimated Sulphur', 'Mineral', 
'Heat, burning, offensive discharges, worse bathing', 
'Skin conditions, digestive issues, chronic conditions', 
'6C to 1M', 1),

('Calcarea Carbonica', 'Calc', 'Calcium Carbonate', 'Mineral', 
'Chilly, sweaty head, slow development, anxious', 
'Teething problems, bone development, obesity, anxiety', 
'6C to 1M', 1),

-- Common Constitutional Remedies
('Lycopodium Clavatum', 'Lyc', 'Club Moss', 'Lycopodiaceae', 
'Right-sided symptoms, 4-8pm aggravation, digestive issues', 
'Liver problems, digestive issues, confidence issues, hair loss', 
'6C to 1M', 1),

('Sepia Officinalis', 'Sep', 'Cuttlefish Ink', 'Cephalopoda', 
'Exhaustion, indifference, hormonal issues, bearing down sensation', 
'Hormonal problems, menstrual issues, exhaustion, depression', 
'6C to 1M', 1),

('Natrum Muriaticum', 'Nat-m', 'Common Salt', 'Mineral', 
'Grief, reserved, headaches, worse sun, craving salt', 
'Depression, headaches, cold sores, grief, anemia', 
'6C to 1M', 1),

('Phosphorus', 'Phos', 'Yellow Phosphorus', 'Mineral', 
'Sensitive, anxious, bleeding tendency, thirsty', 
'Respiratory infections, bleeding disorders, anxiety, pneumonia', 
'6C to 1M', 1),

('Ignatia Amara', 'Ign', 'St. Ignatius Bean', 'Loganiaceae', 
'Grief, emotional upset, changeable mood, sighing', 
'Grief, emotional shock, headaches, insomnia from stress', 
'6C to 1M', 0),

-- Respiratory Remedies
('Allium Cepa', 'All-c', 'Red Onion', 'Liliaceae', 
'Watery eyes and nose, worse warm room', 
'Hay fever, colds with watery discharge, allergies', 
'6C to 30C', 0),

('Antimonium Tartaricum', 'Ant-t', 'Tartar Emetic', 'Mineral', 
'Rattling chest, weak, drowsy, difficult expectoration', 
'Bronchitis, pneumonia, asthma with rattling', 
'6C to 200C', 0),

('Drosera Rotundifolia', 'Dros', 'Sundew', 'Droseraceae', 
'Spasmodic cough, worse lying down, whooping cough', 
'Whooping cough, dry cough, laryngitis', 
'6C to 200C', 0),

('Spongia Tosta', 'Spong', 'Roasted Sponge', 'Porifera', 
'Dry barking cough, croup, worse before midnight', 
'Croup, laryngitis, dry cough, thyroid issues', 
'6C to 200C', 0),

-- Digestive Remedies
('Carbo Vegetabilis', 'Carb-v', 'Vegetable Charcoal', 'Vegetable', 
'Flatulence, weakness, wants to be fanned, bloating', 
'Indigestion, flatulence, weakness, collapse states', 
'6C to 200C', 0),

('China Officinalis', 'Chin', 'Peruvian Bark', 'Rubiaceae', 
'Weakness from fluid loss, bloating, debility', 
'Anemia, weakness, malaria, bloating, hemorrhages', 
'6C to 200C', 0),

('Colocynthis', 'Coloc', 'Bitter Cucumber', 'Cucurbitaceae', 
'Cramping pains better pressure and doubling up', 
'Colic, abdominal cramps, neuralgia, sciatica', 
'6C to 200C', 0),

('Ipecacuanha', 'Ip', 'Ipecac Root', 'Rubiaceae', 
'Persistent nausea, clean tongue, vomiting', 
'Nausea, vomiting, asthma, hemorrhages', 
'6C to 30C', 0),

-- Pain and Inflammation Remedies
('Calendula Officinalis', 'Calen', 'Marigold', 'Compositae', 
'Healing wounds, antiseptic, promotes granulation', 
'Cuts, wounds, burns, surgical wounds, ulcers', 
'6C to 30C', 0),

('Hypericum Perforatum', 'Hyper', 'St. Johns Wort', 'Hypericaceae', 
'Nerve injuries, shooting pains, puncture wounds', 
'Nerve injuries, dental pain, spinal injuries, puncture wounds', 
'6C to 200C', 0),

('Ledum Palustre', 'Led', 'Marsh Tea', 'Ericaceae', 
'Puncture wounds, insect bites, cold to touch', 
'Puncture wounds, insect stings, black eye, gout', 
'6C to 200C', 0),

('Ruta Graveolens', 'Ruta', 'Rue', 'Rutaceae', 
'Bruised bones, tendon injuries, eye strain', 
'Sprains, tendon injuries, eye strain, bone bruises', 
'6C to 200C', 0),

-- Women's Health Remedies
('Caulophyllum Thalictroides', 'Caul', 'Blue Cohosh', 'Berberidaceae', 
'Labor pains, weak contractions, joint pains', 
'Labor difficulties, menstrual cramps, arthritis in small joints', 
'6C to 200C', 0),

('Cimicifuga Racemosa', 'Cimic', 'Black Cohosh', 'Ranunculaceae', 
'Shooting pains, nervous, worse motion, menstrual issues', 
'Menstrual pain, headaches, depression, labor pain', 
'6C to 200C', 0),

('Lachesis Mutus', 'Lach', 'Bushmaster Snake', 'Reptilia', 
'Left-sided, worse after sleep, hot flashes, jealousy', 
'Menopause, sore throat, hot flashes, circulatory issues', 
'6C to 1M', 0),

-- Children's Remedies
('Chamomilla', 'Cham', 'German Chamomile', 'Compositae', 
'Irritability, teething, one cheek red, nothing satisfies', 
'Teething, colic, earaches in irritable children', 
'6C to 200C', 1),

('Calcarea Phosphorica', 'Calc-p', 'Calcium Phosphate', 'Mineral', 
'Growing pains, slow dentition, dissatisfied', 
'Teething, growing pains, slow development, headaches', 
'6C to 200C', 0),

('Magnesia Phosphorica', 'Mag-p', 'Magnesium Phosphate', 'Mineral', 
'Cramping pains better heat and pressure', 
'Menstrual cramps, colic, neuralgia, muscle cramps', 
'6C to 30C', 0),

-- Skin Remedies
('Graphites', 'Graph', 'Black Lead', 'Mineral', 
'Thick sticky discharges, cracks in skin, eczema', 
'Eczema, skin cracks, keloids, constipation', 
'6C to 200C', 0),

('Hepar Sulphuris Calcareum', 'Hep', 'Calcium Sulphide', 'Mineral', 
'Splinter-like pains, oversensitive, chilly, suppuration', 
'Abscesses, boils, croup, infected wounds', 
'6C to 200C', 0),

('Mezereum', 'Mez', 'Spurge Olive', 'Thymelaeaceae', 
'Skin eruptions with thick crusts, neuralgia', 
'Shingles, eczema, neuralgia, dental problems', 
'6C to 200C', 0),

('Urtica Urens', 'Urt-u', 'Stinging Nettle', 'Urticaceae', 
'Burning, stinging, itching skin, worse touch', 
'Hives, burns, itching, gout, kidney stones', 
'6C to 30C', 0),

-- Mental/Emotional Remedies
('Argentum Nitricum', 'Arg-n', 'Silver Nitrate', 'Mineral', 
'Anticipatory anxiety, claustrophobia, craving sweets', 
'Anxiety, stage fright, digestive issues, phobias', 
'6C to 200C', 0),

('Gelsemium Sempervirens', 'Gels', 'Yellow Jasmine', 'Loganiaceae', 
'Weakness, trembling, drowsy, paralysis, anticipatory fear', 
'Flu, stage fright, trembling, headaches, paralysis', 
'6C to 200C', 0),

('Staphysagria', 'Staph', 'Stavesacre', 'Ranunculaceae', 
'Suppressed emotions, indignation, surgical wounds', 
'Emotional trauma, surgical wounds, cystitis, sties', 
'6C to 200C', 0),

-- Eye and ENT Remedies
('Euphrasia Officinalis', 'Euphr', 'Eyebright', 'Scrophulariaceae', 
'Watery eyes, profuse bland nasal discharge, worse light', 
'Conjunctivitis, hay fever, eye inflammation, colds', 
'6C to 30C', 0),

('Mercurius Solubilis', 'Merc', 'Quicksilver', 'Mineral', 
'Sweating, worse night, offensive discharges, metallic taste', 
'Sore throat, dental problems, gum disease, ear infections', 
'6C to 200C', 0),

('Kali Bichromicum', 'Kali-bi', 'Potassium Bichromate', 'Mineral', 
'Thick stringy discharges, sinus pain, ulceration', 
'Sinusitis, post-nasal drip, headaches, ulcers', 
'6C to 200C', 0),

-- Fever and Infection Remedies
('Ferrum Phosphoricum', 'Ferr-p', 'Iron Phosphate', 'Mineral', 
'Early fever, no clear symptoms, gradual onset', 
'Early stages of inflammation, fever, anemia', 
'6C to 30C', 0),

('Pyrogenium', 'Pyrog', 'Sepsin', 'Nosode', 
'Septic states, offensive discharges, restlessness', 
'Septic conditions, flu, high fever with normal pulse', 
'6C to 200C', 0),

('Hamamelis Virginiana', 'Ham', 'Witch Hazel', 'Hamamelidaceae', 
'Venous congestion, hemorrhages, bruised soreness', 
'Varicose veins, hemorrhoids, bruises, nosebleeds', 
'6C to 200C', 0),

('Aesculus Hippocastanum', 'Aesc', 'Horse Chestnut', 'Sapindaceae', 
'Portal congestion, hemorrhoids, lower back pain', 
'Hemorrhoids, back pain, varicose veins, constipation', 
'6C to 30C', 0);

UPDATE remedies SET created_at = NOW(), updated_at = NOW();
