INSERT INTO primary_uses (
   medication_base_id,
   condition_id,
   primary_treatment,
   mechanism_of_action
) VALUES
-- Basic medications
(1, 16, 'First-line treatment for pain', 'Inhibits prostaglandin synthesis centrally'),
(2, 17, 'Acute asthma treatment', 'Beta-2 agonist causing bronchodilation'),
(3, 48, 'Osteoporosis treatment', 'Inhibits osteoclast-mediated bone resorption'),
(4, 46, 'Hypertension treatment', 'Calcium channel blocker reducing vascular resistance'),
(5, 51, 'Bacterial infections', 'Inhibits bacterial cell wall synthesis'),
(6, 46, 'High cholesterol treatment', 'HMG-CoA reductase inhibitor'),
(7, 51, 'Bacterial infections', 'Inhibits bacterial protein synthesis'),
(8, 37, 'Allergic rhinitis treatment', 'H1 antihistamine'),
(9, 43, 'UTI treatment', 'DNA gyrase inhibitor'),
(10, 37, 'Allergic rhinitis treatment', 'Corticosteroid anti-inflammatory'),
(11, 37, 'Allergic rhinitis treatment', 'H1 antihistamine'),
(12, 1, 'Heart failure treatment', 'Loop diuretic'),
(13, 46, 'Hypertension treatment', 'Thiazide diuretic'),
(14, 18, 'COPD treatment', 'Anticholinergic bronchodilator'),
(15, 26, 'Thyroid hormone replacement', 'Synthetic thyroid hormone'),
(16, 46, 'Hypertension treatment', 'ACE inhibitor'),
(17, 46, 'Hypertension treatment', 'Angiotensin receptor blocker'),
(18, 25, 'Diabetes treatment', 'Reduces hepatic glucose production'),
(19, 46, 'Hypertension/heart rate control', 'Beta-1 selective blocker'),
(20, 17, 'Asthma prevention', 'Leukotriene receptor antagonist'),
(21, 21, 'Acid reflux treatment', 'Proton pump inhibitor'),
(22, 7, 'Depression treatment', 'Selective serotonin reuptake inhibitor'),
(23, 46, 'High cholesterol treatment', 'HMG-CoA reductase inhibitor'),
(24, 18, 'COPD treatment', 'Long-acting anticholinergic'),
(25, 7, 'Depression treatment', 'Serotonin-norepinephrine reuptake inhibitor'),
-- Specialty medications
(26, 54, 'Fungal infections', 'Forms pores in fungal cell membranes'),
(27, 2, 'Anticoagulation', 'Factor Xa inhibitor'),
(28, 16, 'Muscle spasticity', 'GABA-B receptor agonist'),
(29, 3, 'Anxiety treatment', 'Partial 5-HT1A agonist'),
(30, 16, 'Muscle relaxant', 'Central acting muscle relaxant'),
(31, 36, 'Severe psoriasis', 'Potent topical corticosteroid'),
(32, 16, 'Muscle spasms', 'Central acting muscle relaxant'),
(33, 16, 'Muscle spasticity', 'Inhibits calcium release in muscles'),
(34, 46, 'Hypertension treatment', 'Calcium channel blocker'),
(35, 51, 'Bacterial infections', 'Protein synthesis inhibitor'),
(36, 7, 'Depression treatment', 'Serotonin-norepinephrine reuptake inhibitor'),
(37, 7, 'Depression/anxiety', 'Selective serotonin reuptake inhibitor'),
(38, 28, 'Hormone replacement', 'Estrogen replacement'),
(39, 53, 'Fungal infections', 'Ergosterol synthesis inhibitor'),
(40, 22, 'IBS-C treatment', 'Guanylate cyclase-C agonist'),
(41, 29, 'MRSA treatment', 'Protein synthesis inhibitor'),
(42, 16, 'Muscle relaxant', 'Central acting muscle relaxant'),
(43, 16, 'Muscle relaxant', 'Central acting muscle relaxant'),
(44, 33, 'Topical antibiotic', 'Bacterial protein synthesis inhibitor'),
(45, 43, 'UTI treatment', 'Multiple bacterial enzyme inhibitor'),
(46, 16, 'Muscle relaxant', 'Anticholinergic muscle relaxant'),
(47, 22, 'IBS-D treatment', 'Gut-specific antibiotic'),
(48, 17, 'Asthma maintenance', 'Long-acting beta-2 agonist'),
(49, 1, 'Heart failure', 'Aldosterone antagonist'),
(50, 16, 'Muscle relaxant', 'Alpha-2 adrenergic agonist'),
-- Antivirals and additional medications
(51, 32, 'CMV treatment', 'Viral DNA polymerase inhibitor'),
(52, 29, 'MRSA treatment', 'Cell wall synthesis inhibitor'),
(53, 54, 'Invasive fungal infections', 'Ergosterol synthesis inhibitor'),
-- Anticonvulsants and neurological medications
(54, 9, 'Absence seizures', 'Calcium channel modulator'),
(55, 9, 'Seizure treatment', 'Multiple mechanism anticonvulsant'),
(56, 9, 'Seizure prevention', 'Sodium channel blocker'),
(57, 9, 'Seizure prevention', 'Synaptic vesicle protein 2A modulator'),
(58, 7, 'Depression treatment', 'Alpha-2 antagonist'),
(59, 7, 'Depression treatment', 'Tricyclic antidepressant'),
(60, 9, 'Seizure prevention', 'Sodium channel blocker'),
(61, 7, 'Depression treatment', 'Selective serotonin reuptake inhibitor'),
(62, 9, 'Seizure prevention', 'Sodium channel blocker'),
(63, 11, 'Parkinson\'s treatment', 'Dopamine agonist'),
(64, 9, 'Bipolar/schizophrenia', 'Dopamine/serotonin antagonist'),
(65, 9, 'Seizure treatment', 'Sodium channel modulator'),
(66, 9, 'Severe myoclonic epilepsy', 'GABA modulator'),
(67, 9, 'Seizure treatment', 'GABA reuptake inhibitor'),
(68, 9, 'Seizure prevention', 'Multiple mechanism anticonvulsant'),
(69, 10, 'Insomnia/depression', 'Serotonin antagonist/reuptake inhibitor'),
(70, 9, 'Seizure prevention', 'GABA enhancer'),
(71, 9, 'Seizure treatment', 'GABA transaminase inhibitor'),
(72, 9, 'Seizure prevention', 'Sodium/calcium channel modulator');