-- Seed: Sample Remedies
-- Insert common homeopathic remedies

INSERT INTO `remedies` (`name`, `abbreviation`, `materia_medica_text`, `modalities`) VALUES
('Sulphur', 'Sulph', 'Great remedy for chronic diseases. Skin affections, burning sensations. Worse from warmth, bathing. Better from open air, cold drinks.', 
 '{"better": ["Open air", "Cold drinks"], "worse": ["Warmth", "Bathing", "Night"]}'),
 
('Lycopodium', 'Lyc', 'Digestive complaints, right-sided symptoms. Worse 4-8 PM. Craves sweets, warm food. Better from warm food, uncovering.',
 '{"better": ["Warm food", "Uncovering"], "worse": ["4-8 PM", "Cold drinks", "Right side"]}'),
 
('Arsenicum Album', 'Ars', 'Anxiety, restlessness, burning pains. Worse midnight, cold, wet weather. Better warm drinks, warmth.',
 '{"better": ["Warm drinks", "Warmth", "Company"], "worse": ["Midnight", "Cold", "Wet weather"]}'),
 
('Pulsatilla', 'Puls', 'Changeable symptoms, mild disposition. Worse warm rooms, rich food. Better open air, cold applications.',
 '{"better": ["Open air", "Cold applications", "Gentle motion"], "worse": ["Warm rooms", "Rich food", "Evening"]}'),
 
('Nux Vomica', 'Nux', 'Irritable, oversensitive, digestive issues. Worse morning, mental exertion. Better sleep, strong pressure.',
 '{"better": ["Sleep", "Strong pressure", "Warmth"], "worse": ["Morning", "Mental exertion", "Spices"]}'),

('Belladonna', 'Bell', 'Sudden onset, throbbing pains, redness. Worse light, noise, touch. Better rest, semi-erect position.',
 '{"better": ["Rest", "Semi-erect position", "Darkness"], "worse": ["Light", "Noise", "Touch", "Motion"]}'),

('Calcarea Carbonica', 'Calc', 'Slow, fat, chilly. Worse cold, wet weather, exertion. Better dry climate, lying down.',
 '{"better": ["Dry climate", "Lying down", "Pressure"], "worse": ["Cold", "Wet weather", "Exertion"]}'),

('Ignatia', 'Ign', 'Hysterical, contradictory emotions. Worse grief, coffee, tobacco. Better distraction, company.',
 '{"better": ["Distraction", "Company", "Warmth"], "worse": ["Grief", "Coffee", "Tobacco", "Morning"]}'),

('Natrum Muriaticum', 'Nat-m', 'Closed, reserved, sensitive. Worse consolation, sun, heat. Better open air, sweating.',
 '{"better": ["Open air", "Sweating", "Cold bathing"], "worse": ["Consolation", "Sun", "Heat"]}'),

('Sepia', 'Sep', 'Indifferent, averse to family. Worse pregnancy, hormonal changes. Better vigorous exercise, sleep.',
 '{"better": ["Vigorous exercise", "Sleep", "Cold bathing"], "worse": ["Pregnancy", "Hormonal changes", "Evening", "Before storm"]}')
ON DUPLICATE KEY UPDATE name=name;