INSERT INTO dosage_information (
   medication_base_id,
   use_type,
   starting_dose,
   other_dosages
) VALUES
-- Pain/Fever medications
(1, 'Pain/Fever', '325-650mg', '325-1000mg every 4-6 hours, max 4000mg/day'),

-- Respiratory medications
(2, 'Asthma', '90mcg', '1-2 inhalations every 4-6 hours as needed'),
(10, 'Allergic Rhinitis', '50mcg/spray', '1-2 sprays each nostril daily'),
(14, 'COPD', '17mcg', '2 inhalations 4 times daily'),
(20, 'Asthma Prevention', '10mg', '10mg daily at bedtime'),
(24, 'COPD', '18mcg', '1 inhalation daily'),
(48, 'Asthma', '50mcg', '1 inhalation twice daily'),

-- Cardiovascular medications
(3, 'Osteoporosis', '70mg', '70mg once weekly'),
(4, 'Hypertension', '5mg', '5-10mg daily'),
(6, 'Hyperlipidemia', '10mg', '10-80mg daily'),
(12, 'Heart Failure', '20mg', '20-80mg daily'),
(13, 'Hypertension', '12.5mg', '12.5-50mg daily'),
(16, 'Hypertension', '10mg', '10-40mg daily'),
(17, 'Hypertension', '25mg', '25-100mg daily'),
(19, 'Hypertension', '25mg', '25-100mg twice daily'),
(23, 'Hyperlipidemia', '20mg', '20-40mg daily'),
(27, 'Anticoagulation', '5mg', '5mg twice daily'),
(34, 'Hypertension', '30mg', '30-60mg daily'),
(49, 'Heart Failure', '25mg', '25-50mg daily'),

-- Antimicrobials
(5, 'Bacterial Infections', '500mg', '500mg every 8 hours for 7-10 days'),
(7, 'Bacterial Infections', '500mg', '500mg day 1, then 250mg daily for 4 days'),
(9, 'UTI', '250mg', '250-500mg twice daily'),
(26, 'Fungal Infections', '0.3mg/kg', '0.3-1.0mg/kg daily'),
(35, 'Bacterial Infections', '100mg', '100mg twice daily'),
(39, 'Fungal Infections', '200mg', '200-400mg daily'),
(41, 'MRSA', '600mg', '600mg every 12 hours'),
(44, 'Skin Infections', '2%', 'Apply 3 times daily'),
(45, 'UTI', '100mg', '100mg twice daily'),
(47, 'IBS-D', '550mg', '550mg three times daily'),
(51, 'Viral Infections', '1000mg', '1000mg three times daily'),
(52, 'MRSA', '1000mg', '1000mg every 12 hours'),
(53, 'Fungal Infections', '200mg', '200-300mg every 12 hours'),

-- Psychiatric/Neurological medications
(22, 'Depression', '50mg', '50-200mg daily'),
(25, 'Depression', '37.5mg', '37.5-225mg daily'),
(29, 'Anxiety', '5mg', '5-30mg daily'),
(36, 'Depression', '30mg', '30-120mg daily'),
(37, 'Depression', '10mg', '10-20mg daily'),
(54, 'Seizures', '250mg', '250-1500mg daily'),
(55, 'Seizures', '400mg', '400-3600mg daily'),
(56, 'Seizures', '25mg', '25-400mg daily'),
(57, 'Seizures', '500mg', '500-3000mg daily'),
(58, 'Depression', '15mg', '15-45mg daily'),
(59, 'Depression', '25mg', '25-150mg daily'),
(60, 'Seizures', '300mg', '300-2400mg daily'),
(61, 'Depression', '20mg', '20-50mg daily'),
(62, 'Seizures', '100mg', '100-600mg daily'),
(63, 'Parkinson\'s', '0.125mg', '0.125-4.5mg daily'),
(64, 'Bipolar/Schizophrenia', '25mg', '25-800mg daily'),
(65, 'Seizures', '400mg', '400-3200mg daily'),
(66, 'Seizures', '250mg', '250-4000mg daily'),
(67, 'Seizures', '4mg', '4-56mg daily'),
(68, 'Seizures', '25mg', '25-400mg daily'),
(69, 'Insomnia', '50mg', '50-150mg at bedtime'),
(70, 'Seizures', '250mg', '250-3000mg daily'),
(71, 'Seizures', '500mg', '500-3000mg daily'),
(72, 'Seizures', '100mg', '100-400mg daily'),

-- Muscle Relaxants
(28, 'Muscle Spasticity', '5mg', '5-80mg daily'),
(30, 'Muscle Spasms', '250mg', '250-750mg daily'),
(32, 'Muscle Spasms', '5mg', '5-30mg daily'),
(33, 'Muscle Spasticity', '25mg', '25-100mg daily'),
(42, 'Muscle Spasms', '800mg', '800-3200mg daily'),
(43, 'Muscle Spasms', '1500mg', '1500-4500mg daily'),
(46, 'Muscle Spasms', '100mg', '100-400mg daily'),
(50, 'Muscle Spasms', '2mg', '2-36mg daily'),

-- Endocrine medications
(15, 'Hypothyroidism', '25mcg', '25-200mcg daily'),
(18, 'Diabetes', '500mg', '500-2550mg daily'),
(38, 'Hormone Replacement', '1mg', '1-2mg daily'),

-- Gastrointestinal medications
(21, 'Acid Reflux', '20mg', '20-40mg daily'),
(40, 'IBS-C', '145mcg', '145-290mcg daily'),

-- Dermatological medications
(31, 'Psoriasis', '0.05%', 'Apply twice daily'),


-- Allergy medications
(8, 'Allergic Rhinitis', '10mg', '10mg once daily'),
(11, 'Allergic Rhinitis', '180mg', '180mg once daily'),

-- Missing antibiotic/antiviral formulations
(52, 'Bacterial Infections', '1000mg', 'IV: 1000mg every 12 hours, Oral: 125-500mg 4 times daily');