INSERT INTO medication_classes (
    id,
    name,
    description,
    parent_id
) VALUES
(1, 'Analgesics', 'Pain relieving medications', NULL),
(2, 'Respiratory Agents', 'Medications for respiratory conditions', NULL),
(3, 'Bone Density Regulators', 'Medications affecting bone metabolism', NULL),
(4, 'Calcium Channel Blockers', 'Cardiovascular medications affecting calcium channels', NULL),
(5, 'Antibiotics', 'Medications that kill or inhibit bacterial growth', NULL),
(6, 'Statins', 'Cholesterol-lowering medications', NULL),
(7, 'Antihistamines', 'Allergy and immune response medications', NULL),
(8, 'Corticosteroids', 'Anti-inflammatory and immune system medications', NULL),
(9, 'Diuretics', 'Medications affecting fluid balance', NULL),
(10, 'Thyroid Medications', 'Hormonal medications affecting thyroid function', NULL),
(11, 'ACE Inhibitors', 'Blood pressure medications affecting renin-angiotensin system', NULL),
(12, 'Angiotensin Receptor Blockers', 'Blood pressure medications blocking angiotensin receptors', NULL),
(13, 'Antidiabetics', 'Medications for managing diabetes', NULL),
(14, 'Beta Blockers', 'Cardiovascular medications blocking beta receptors', NULL),
(15, 'Leukotriene Modifiers', 'Anti-inflammatory medications for asthma and allergies', NULL),
(16, 'Proton Pump Inhibitors', 'Medications reducing stomach acid production', NULL),
(17, 'SSRIs', 'Antidepressants affecting serotonin reuptake', NULL),
(18, 'SNRIs', 'Antidepressants affecting serotonin and norepinephrine', NULL),

-- Parent-child relationships
(19, 'Bronchodilators', 'Medications that dilate airways', 2),
(20, 'Anticholinergics', 'Medications blocking acetylcholine effects', 2),
(21, 'Loop Diuretics', 'Powerful diuretics acting on loop of Henle', 9),
(22, 'Thiazide Diuretics', 'Diuretics acting on distal convoluted tubule', 9),
(23, 'Antifungals', 'Medications that treat fungal infections', NULL),
(24, 'Anticoagulants', 'Blood-thinning medications', NULL),
(25, 'Muscle Relaxants', 'Medications that reduce muscle spasticity', NULL),
(26, 'Hormones', 'Synthetic hormone medications', NULL),
(27, 'Anticonvulsants', 'Medications for preventing seizures', NULL),
(28, 'Antidepressants', 'Medications for treating depression', NULL),
(29, 'Dermatologicals', 'Medications for skin conditions', NULL),
(30, 'Gastrointestinal Agents', 'Medications for digestive system', NULL),

-- New child classes
(31, 'Azoles', 'Antifungal medications targeting ergosterol synthesis', 23),
(32, 'Factor Xa Inhibitors', 'Anticoagulants targeting factor Xa', 24),
(33, 'Centrally Acting Muscle Relaxants', 'Muscle relaxants affecting CNS', 25),
(34, 'Peripherally Acting Muscle Relaxants', 'Muscle relaxants affecting peripheral nerves', 25),
(35, 'Sex Hormones', 'Hormones affecting reproductive system', 26),
(36, 'Tricyclic Antidepressants', 'Older generation antidepressants', 28),
(37, 'Topical Corticosteroids', 'Skin-applied anti-inflammatory steroids', 29),
(38, 'Prokinetics', 'Medications improving GI motility', 30);

-- Update previous entries parent relationships
UPDATE medication_classes SET parent_id = 28 WHERE id IN (17, 18); -- SSRIs and SNRIs under Antidepressants


INSERT INTO medication_bases (
    id,
    generic_name,
    medication_class_id,
    type,
    description,
    requires_prescription,
    controlled_substance,
    contraindications,
    side_effects,
    interactions,
    pregnancy_category,
    breastfeeding_safe,
    black_box_warning,
    status
) VALUES
(1, 'Acetaminophen', 1, 'analgesic', 'Common pain reliever and fever reducer', false, false, 'Liver disease', 'Liver damage in high doses, nausea', 'Alcohol, warfarin', 'B', true, NULL, 'active'),
(2, 'Albuterol', 2, 'bronchodilator', 'Short-acting beta-2 agonist for asthma and COPD', true, false, 'Hypersensitivity', 'Tremor, anxiety, tachycardia', 'Beta-blockers', 'C', true, NULL, 'active'),
(3, 'Alendronate', 3, 'bisphosphonate', 'Treatment for osteoporosis', true, false, 'Esophageal abnormalities', 'Esophagitis, gastric ulcer', 'Calcium supplements', 'C', false, NULL, 'active'),
(4, 'Amlodipine', 4, 'calcium channel blocker', 'Treatment for hypertension and angina', true, false, 'Severe hypotension', 'Edema, dizziness, fatigue', 'CYP3A4 inhibitors', 'C', true, NULL, 'active'),
(5, 'Amoxicillin', 5, 'antibiotic', 'Broad-spectrum penicillin antibiotic', true, false, 'Penicillin allergy', 'Diarrhea, rash', 'Probenecid', 'B', true, NULL, 'active'),
(6, 'Atorvastatin', 6, 'statin', 'Cholesterol-lowering medication', true, false, 'Active liver disease', 'Muscle pain, liver dysfunction', 'Gemfibrozil, cyclosporine', 'X', false, 'May cause liver injury', 'active'),
(7, 'Azithromycin', 5, 'antibiotic', 'Macrolide antibiotic', true, false, 'Liver disease', 'QT prolongation, diarrhea', 'Antacids', 'B', true, NULL, 'active'),
(8, 'Cetirizine', 7, 'antihistamine', 'Second-generation antihistamine', false, false, 'Kidney disease', 'Drowsiness, dry mouth', 'CNS depressants', 'B', true, NULL, 'active'),
(9, 'Ciprofloxacin', 5, 'antibiotic', 'Fluoroquinolone antibiotic', true, false, 'Tendon disorders', 'Tendinitis, nausea', 'Antacids, iron', 'C', true, 'Risk of tendinitis', 'active'),
(10, 'Fluticasone', 8, 'corticosteroid', 'Inhaled corticosteroid', true, false, 'Active respiratory infection', 'Throat irritation, cough', 'CYP3A4 inhibitors', 'C', true, NULL, 'active'),
(11, 'Fexofenadine', 7, 'antihistamine', 'Long-acting antihistamine', false, false, 'None known', 'Headache, drowsiness', 'Antacids, fruit juices', 'C', true, NULL, 'active'),
(12, 'Furosemide', 9, 'loop diuretic', 'Treatment for fluid retention and hypertension', true, false, 'Severe electrolyte imbalance', 'Dehydration, electrolyte disturbances', 'NSAIDs, aminoglycosides', 'C', true, NULL, 'active'),
(13, 'Hydrochlorothiazide', 9, 'thiazide diuretic', 'Treatment for hypertension', true, false, 'Anuria, sulfa allergy', 'Electrolyte imbalance, photosensitivity', 'Lithium, NSAIDs', 'B', true, NULL, 'active'),
(14, 'Ipratropium', 2, 'anticholinergic', 'Bronchodilator for COPD', true, false, 'Glaucoma', 'Dry mouth, cough', 'Other anticholinergics', 'B', true, NULL, 'active'),
(15, 'Levothyroxine', 10, 'thyroid hormone', 'Thyroid replacement therapy', true, false, 'Thyrotoxicosis', 'Palpitations, anxiety', 'Iron supplements, calcium', 'A', true, NULL, 'active'),
(16, 'Lisinopril', 11, 'ACE inhibitor', 'Treatment for hypertension and heart failure', true, false, 'Angioedema history', 'Dry cough, dizziness', 'Potassium supplements, NSAIDs', 'D', false, NULL, 'active'),
(17, 'Losartan', 12, 'ARB', 'Treatment for hypertension', true, false, 'Pregnancy', 'Dizziness, hyperkalemia', 'NSAIDs, potassium supplements', 'D', true, NULL, 'active'),
(18, 'Metformin', 13, 'biguanide', 'First-line treatment for type 2 diabetes', true, false, 'Severe kidney disease', 'Diarrhea, nausea, B12 deficiency', 'Iodinated contrast media', 'B', true, NULL, 'active'),
(19, 'Metoprolol', 14, 'beta blocker', 'Treatment for hypertension and heart failure', true, false, 'Severe bradycardia', 'Fatigue, cold extremities', 'CYP2D6 inhibitors', 'C', true, NULL, 'active'),
(20, 'Montelukast', 15, 'leukotriene modifier', 'Asthma and allergy treatment', true, false, 'Hypersensitivity', 'Headache, behavioral changes', 'None significant', 'B', true, 'Mental health changes', 'active'),
(21, 'Omeprazole', 16, 'proton pump inhibitor', 'Treatment for acid reflux and ulcers', true, false, 'Hypersensitivity', 'Headache, diarrhea', 'Clopidogrel, iron', 'C', true, NULL, 'active'),
(22, 'Sertraline', 17, 'SSRI', 'Antidepressant medication', true, false, 'MAOIs use', 'Nausea, sexual dysfunction', 'NSAIDs, warfarin', 'C', true, 'Suicidal thoughts', 'active'),
(23, 'Simvastatin', 6, 'statin', 'Cholesterol-lowering medication', true, false, 'Active liver disease', 'Muscle pain, liver dysfunction', 'Gemfibrozil, cyclosporine', 'X', false, 'May cause liver injury', 'active'),
(24, 'Tiotropium', 2, 'anticholinergic', 'Long-acting bronchodilator for COPD', true, false, 'Narrow-angle glaucoma', 'Dry mouth, urinary retention', 'Other anticholinergics', 'C', true, NULL, 'active'),
(25, 'Venlafaxine', 18, 'SNRI', 'Antidepressant medication', true, false, 'MAOIs use', 'Nausea, hypertension', 'NSAIDs, tramadol', 'C', true, 'Suicidal thoughts', 'active'),
(26, 'Amphotericin B', 23, 'antifungal', 'Treatment for severe systemic fungal infections', true, false, 'Severe renal impairment', 'Nephrotoxicity, fever, chills', 'Nephrotoxic drugs', 'B', true, 'Risk of renal failure', 'active'),
(27, 'Apixaban', 32, 'anticoagulant', 'Prevention and treatment of blood clots', true, false, 'Active bleeding', 'Bleeding risk, bruising', 'Strong CYP3A4 inhibitors/inducers', 'C', false, 'Bleeding risk', 'active'),
(28, 'Baclofen', 33, 'muscle relaxant', 'Treatment for muscle spasms and spasticity', true, false, 'Severe renal impairment', 'Drowsiness, weakness', 'CNS depressants', 'C', true, NULL, 'active'),
(29, 'Buspirone', 28, 'anxiolytic', 'Treatment for anxiety disorders', true, false, 'MAOIs use', 'Dizziness, headache', 'MAOIs, CYP3A4 inhibitors', 'B', true, NULL, 'active'),
(30, 'Chlorzoxazone', 33, 'muscle relaxant', 'Relief of muscle spasms', true, false, 'Liver disease', 'Dizziness, drowsiness', 'CNS depressants', 'C', true, NULL, 'active'),
(31, 'Clobetasol', 37, 'corticosteroid', 'Treatment for severe skin conditions', true, false, 'Skin infections', 'Skin thinning, irritation', 'None significant', 'C', true, NULL, 'active'),
(32, 'Cyclobenzaprine', 33, 'muscle relaxant', 'Short-term relief of muscle spasms', true, false, 'MAOIs use', 'Drowsiness, dry mouth', 'CNS depressants, MAOIs', 'B', true, NULL, 'active'),
(33, 'Dantrolene', 34, 'muscle relaxant', 'Treatment for chronic spasticity', true, false, 'Active liver disease', 'Weakness, drowsiness, hepatotoxicity', 'CNS depressants', 'C', true, 'Hepatotoxicity risk', 'active'),
(34, 'Diltiazem', 4, 'calcium channel blocker', 'Treatment for hypertension and angina', true, false, 'Heart block, hypotension', 'Edema, headache', 'Beta blockers, digoxin', 'C', true, NULL, 'active'),
(35, 'Doxycycline', 5, 'antibiotic', 'Broad-spectrum tetracycline antibiotic', true, false, 'Pregnancy', 'Photosensitivity, GI upset', 'Antacids, iron', 'D', false, NULL, 'active'),
(36, 'Duloxetine', 18, 'SNRI', 'Treatment for depression and nerve pain', true, false, 'MAOIs use, glaucoma', 'Nausea, dry mouth', 'MAOIs, NSAIDs', 'C', true, 'Suicidality risk', 'active'),
(37, 'Escitalopram', 17, 'SSRI', 'Treatment for depression and anxiety', true, false, 'MAOIs use', 'Nausea, insomnia', 'MAOIs, NSAIDs', 'C', true, 'Suicidality risk', 'active'),
(38, 'Estradiol', 35, 'hormone', 'Hormone replacement therapy', true, false, 'History of breast cancer', 'Breast tenderness, nausea', 'CYP3A4 inducers', 'X', false, 'Cancer risk', 'active'),
(39, 'Fluconazole', 31, 'antifungal', 'Treatment for fungal infections', true, false, 'QT prolongation', 'Headache, nausea', 'QT-prolonging drugs', 'C', true, NULL, 'active'),
(40, 'Linaclotide', 30, 'GI agent', 'Treatment for IBS-C and chronic constipation', true, false, 'Bowel obstruction', 'Diarrhea, abdominal pain', 'None significant', 'C', true, NULL, 'active'),
(41, 'Linezolid', 5, 'antibiotic', 'Treatment for resistant bacterial infections', true, false, 'MAOIs use', 'Diarrhea, headache', 'Serotonergic drugs', 'C', true, NULL, 'active'),
(42, 'Metaxalone', 33, 'muscle relaxant', 'Relief of muscle spasms', true, false, 'Significant liver disease', 'Drowsiness, dizziness', 'CNS depressants', 'C', true, NULL, 'active'),
(43, 'Methocarbamol', 33, 'muscle relaxant', 'Relief of muscle spasms', true, false, 'Renal impairment', 'Drowsiness, dizziness', 'CNS depressants', 'C', true, NULL, 'active'),
(44, 'Mupirocin', 29, 'antibiotic', 'Topical treatment for skin infections', true, false, 'None significant', 'Skin irritation', 'None significant', 'B', true, NULL, 'active'),
(45, 'Nitrofurantoin', 5, 'antibiotic', 'Treatment for urinary tract infections', true, false, 'Renal impairment', 'Nausea, lung reactions', 'Probenecid', 'B', true, NULL, 'active'),
(46, 'Orphenadrine', 33, 'muscle relaxant', 'Relief of muscle spasms', true, false, 'Glaucoma', 'Dry mouth, tachycardia', 'CNS depressants', 'C', true, NULL, 'active'),
(47, 'Rifaximin', 5, 'antibiotic', 'Treatment for travelers diarrhea and IBS', true, false, 'Bowel obstruction', 'Nausea, bloating', 'CYP3A4 inhibitors', 'C', true, NULL, 'active'),
(48, 'Salmeterol', 19, 'bronchodilator', 'Long-acting beta-2 agonist for asthma', true, false, 'Severe milk allergy', 'Tremor, nervousness', 'Beta-blockers', 'C', true, 'Asthma-related death', 'active'),
(49, 'Spironolactone', 9, 'potassium-sparing diuretic', 'Treatment for fluid retention and hypertension', true, false, 'High potassium', 'Hyperkalemia, gynecomastia', 'ACE inhibitors, potassium', 'C', true, NULL, 'active'),
(50, 'Tizanidine', 33, 'muscle relaxant', 'Treatment for spasticity', true, false, 'Liver disease', 'Hypotension, dry mouth', 'CYP1A2 inhibitors', 'C', true, NULL, 'active'),
(51, 'Valacyclovir', 27, 'antiviral', 'Treatment for herpes infections', true, false, 'None significant', 'Headache, nausea', 'None significant', 'B', true, NULL, 'active'),
(52, 'Vancomycin', 5, 'antibiotic', 'Treatment for severe bacterial infections', true, false, 'None significant', 'Nephrotoxicity, red man syndrome', 'Aminoglycosides', 'C', true, NULL, 'active'),
(53, 'Voriconazole', 31, 'antifungal', 'Treatment for severe fungal infections', true, false, 'Pregnancy', 'Visual disturbances, hepatotoxicity', 'CYP3A4 inhibitors/inducers', 'D', false, 'Hepatotoxicity risk', 'active'),
(54, 'Ethosuximide', 27, 'anticonvulsant', 'Treatment for absence seizures', true, false, 'Liver disease', 'Nausea, dizziness, headache', 'Other anticonvulsants', 'C', true, NULL, 'active'),
(55, 'Felbamate', 27, 'anticonvulsant', 'Treatment for severe epilepsy', true, false, 'Liver disease', 'Aplastic anemia, liver failure', 'Other anticonvulsants', 'C', false, 'Risk of aplastic anemia', 'active'),
(56, 'Lamotrigine', 27, 'anticonvulsant', 'Treatment for epilepsy and bipolar', true, false, 'Hypersensitivity', 'Rash, Stevens-Johnson syndrome', 'Valproate, carbamazepine', 'C', true, 'Severe rash risk', 'active'),
(57, 'Levetiracetam', 27, 'anticonvulsant', 'Treatment for seizures', true, false, 'None significant', 'Behavioral changes, fatigue', 'None significant', 'C', true, NULL, 'active'),
(58, 'Mirtazapine', 28, 'antidepressant', 'Treatment for depression', true, false, 'MAOIs use', 'Drowsiness, weight gain', 'MAOIs, alcohol', 'C', true, 'Suicidality risk', 'active'),
(59, 'Nortriptyline', 36, 'tricyclic antidepressant', 'Treatment for depression', true, false, 'Heart block', 'Dry mouth, constipation', 'MAOIs, anticholinergics', 'D', false, NULL, 'active'),
(60, 'Oxcarbazepine', 27, 'anticonvulsant', 'Treatment for seizures', true, false, 'Hypersensitivity', 'Dizziness, diplopia', 'Oral contraceptives', 'C', true, NULL, 'active'),
(61, 'Paroxetine', 17, 'SSRI', 'Treatment for depression and anxiety', true, false, 'MAOIs use', 'Sexual dysfunction, withdrawal', 'MAOIs, pimozide', 'D', false, 'Birth defects risk', 'active'),
(62, 'Phenytoin', 27, 'anticonvulsant', 'Treatment for seizures', true, false, 'Heart block', 'Gingival hyperplasia, ataxia', 'Multiple drug interactions', 'D', false, NULL, 'active'),
(63, 'Pramipexole', 27, 'dopamine agonist', 'Treatment for Parkinsons and RLS', true, false, 'Psychosis', 'Drowsiness, hallucinations', 'CNS depressants', 'C', false, NULL, 'active'),
(64, 'Quetiapine', 28, 'antipsychotic', 'Treatment for schizophrenia and bipolar', true, false, 'Dementia', 'Weight gain, drowsiness', 'CYP3A4 inhibitors', 'C', true, 'Elderly dementia risk', 'active'),
(65, 'Rufinamide', 27, 'anticonvulsant', 'Treatment for seizures', true, false, 'Familial short QT syndrome', 'Headache, dizziness', 'Other anticonvulsants', 'C', true, NULL, 'active'),
(66, 'Stiripentol', 27, 'anticonvulsant', 'Treatment for severe myoclonic epilepsy', true, false, 'Liver disease', 'Loss of appetite, drowsiness', 'CYP inhibitors/inducers', 'C', true, NULL, 'active'),
(67, 'Tiagabine', 27, 'anticonvulsant', 'Treatment for partial seizures', true, false, 'Status epilepticus history', 'Dizziness, depression', 'CYP3A4 inducers', 'C', true, NULL, 'active'),
(68, 'Topiramate', 27, 'anticonvulsant', 'Treatment for epilepsy and migraine', true, false, 'Metabolic acidosis', 'Cognitive effects, kidney stones', 'Carbonic anhydrase inhibitors', 'D', true, 'Birth defects risk', 'active'),
(69, 'Trazodone', 28, 'antidepressant', 'Treatment for depression and insomnia', true, false, 'Recovery from MI', 'Drowsiness, priapism', 'MAOIs, CYP3A4 inhibitors', 'C', true, NULL, 'active'),
(70, 'Valproic Acid', 27, 'anticonvulsant', 'Treatment for seizures and bipolar', true, false, 'Liver disease', 'Hepatotoxicity, teratogenicity', 'Multiple interactions', 'X', false, 'Birth defects risk', 'active'),
(71, 'Vigabatrin', 27, 'anticonvulsant', 'Treatment for complex partial seizures', true, false, 'Visual field loss', 'Vision loss, depression', 'Other anticonvulsants', 'C', true, 'Vision loss risk', 'active'),
(72, 'Zonisamide', 27, 'anticonvulsant', 'Treatment for partial seizures', true, false, 'Sulfa allergy', 'Kidney stones, weight loss', 'Carbonic anhydrase inhibitors', 'C', true, NULL, 'active');

INSERT INTO medication_variants (
    id,
    brand_name,
    manufacturer,
    medication_base_id,
    strength,
    dosage_form,
    route_of_administration,
    ndc_number,
    unit_price,
    storage_conditions,
    is_usual_dosage,
    order_index
) VALUES
-- Acetaminophen variants
(1, 'Tylenol', 'Johnson & Johnson', 1, '325 mg', 'tablet', 'oral', '50580-825-25', 0.10, 'Store at room temperature', true, 1),
(2, 'Tylenol', 'Johnson & Johnson', 1, '500 mg', 'tablet', 'oral', '50580-825-50', 0.15, 'Store at room temperature', true, 2),
(3, 'Tylenol', 'Johnson & Johnson', 1, '650 mg', 'tablet', 'oral', '50580-825-65', 0.20, 'Store at room temperature', false, 3),

-- Albuterol variants
(4, 'Ventolin HFA', 'GSK', 2, '90 mcg', 'inhaler', 'inhalation', '0173-0682-20', 45.00, 'Store at room temperature', true, 1),
(5, 'ProAir HFA', 'Teva', 2, '90 mcg', 'inhaler', 'inhalation', '59310-579-20', 42.00, 'Store at room temperature', true, 2),

-- Alendronate variants
(6, 'Fosamax', 'Merck', 3, '70 mg', 'tablet', 'oral', '0006-0031-44', 15.00, 'Store at room temperature', true, 1),
(7, 'Fosamax', 'Merck', 3, '35 mg', 'tablet', 'oral', '0006-0031-35', 12.00, 'Store at room temperature', false, 2),

-- Amlodipine variants
(8, 'Norvasc', 'Pfizer', 4, '5 mg', 'tablet', 'oral', '0069-1530-68', 0.50, 'Store at room temperature', true, 1),
(9, 'Norvasc', 'Pfizer', 4, '10 mg', 'tablet', 'oral', '0069-1540-68', 0.75, 'Store at room temperature', true, 2),

-- Amoxicillin variants
(10, 'Amoxil', 'GSK', 5, '500 mg', 'capsule', 'oral', '0002-3271-02', 0.30, 'Store at room temperature', true, 1),
(11, 'Amoxil', 'GSK', 5, '875 mg', 'tablet', 'oral', '0002-3273-02', 0.45, 'Store at room temperature', true, 2),
(12, 'Amoxil', 'GSK', 5, '250 mg/5mL', 'suspension', 'oral', '0002-3275-02', 12.00, 'Refrigerate after reconstitution', false, 3),

-- Atorvastatin variants
(13, 'Lipitor', 'Pfizer', 6, '10 mg', 'tablet', 'oral', '0071-0155-23', 2.50, 'Store at room temperature', true, 1),
(14, 'Lipitor', 'Pfizer', 6, '20 mg', 'tablet', 'oral', '0071-0156-23', 3.00, 'Store at room temperature', true, 2),
(15, 'Lipitor', 'Pfizer', 6, '40 mg', 'tablet', 'oral', '0071-0157-23', 3.50, 'Store at room temperature', true, 3),
(16, 'Lipitor', 'Pfizer', 6, '80 mg', 'tablet', 'oral', '0071-0158-23', 4.00, 'Store at room temperature', false, 4),

-- Azithromycin variants
(17, 'Zithromax', 'Pfizer', 7, '250 mg', 'tablet', 'oral', '0069-3060-30', 8.00, 'Store at room temperature', true, 1),
(18, 'Zithromax', 'Pfizer', 7, '500 mg', 'tablet', 'oral', '0069-3070-30', 12.00, 'Store at room temperature', true, 2),
(19, 'Zithromax', 'Pfizer', 7, '200 mg/5mL', 'suspension', 'oral', '0069-3110-30', 25.00, 'Refrigerate after reconstitution', false, 3),

-- Amphotericin B
(20, 'AmBisome', 'Gilead', 26, '50 mg', 'injection', 'intravenous', '61958-0401-01', 150.00, 'Store at 2-8°C', true, 1),
(21, 'AmBisome', 'Gilead', 26, '100 mg', 'injection', 'intravenous', '61958-0401-02', 280.00, 'Store at 2-8°C', false, 2),

-- Apixaban
(22, 'Eliquis', 'Bristol-Myers Squibb', 27, '2.5 mg', 'tablet', 'oral', '0003-0893-21', 8.50, 'Store at room temperature', false, 1),
(23, 'Eliquis', 'Bristol-Myers Squibb', 27, '5 mg', 'tablet', 'oral', '0003-0894-21', 8.50, 'Store at room temperature', true, 2),

-- Baclofen
(24, 'Lioresal', 'Novartis', 28, '10 mg', 'tablet', 'oral', '0078-0140-05', 1.20, 'Store at room temperature', true, 1),
(25, 'Lioresal', 'Novartis', 28, '20 mg', 'tablet', 'oral', '0078-0141-05', 2.00, 'Store at room temperature', false, 2),

-- Buspirone
(26, 'BuSpar', 'Bristol-Myers Squibb', 29, '15 mg', 'tablet', 'oral', '0003-0020-15', 3.00, 'Store at room temperature', true, 1),
(27, 'BuSpar', 'Bristol-Myers Squibb', 29, '30 mg', 'tablet', 'oral', '0003-0020-30', 5.00, 'Store at room temperature', false, 2),

-- Clobetasol
(28, 'Temovate', 'GlaxoSmithKline', 31, '0.05%', 'cream', 'topical', '0004-0470-30', 35.00, 'Store at room temperature', true, 1),
(29, 'Temovate', 'GlaxoSmithKline', 31, '0.05%', 'ointment', 'topical', '0004-0471-30', 35.00, 'Store at room temperature', false, 2),

-- Cyclobenzaprine
(30, 'Flexeril', 'Janssen', 32, '5 mg', 'tablet', 'oral', '50458-591-10', 2.00, 'Store at room temperature', false, 1),
(31, 'Flexeril', 'Janssen', 32, '10 mg', 'tablet', 'oral', '50458-592-10', 2.50, 'Store at room temperature', true, 2),

-- Dantrolene
(32, 'Dantrium', 'Par Pharma', 33, '25 mg', 'capsule', 'oral', '49884-181-01', 3.50, 'Store at room temperature', false, 1),
(33, 'Dantrium', 'Par Pharma', 33, '50 mg', 'capsule', 'oral', '49884-182-01', 4.50, 'Store at room temperature', true, 2),

-- Diltiazem
(34, 'Cardizem', 'Bausch Health', 34, '30 mg', 'tablet', 'oral', '00187-0771-01', 2.00, 'Store at room temperature', false, 1),
(35, 'Cardizem', 'Bausch Health', 34, '60 mg', 'tablet', 'oral', '00187-0772-01', 3.00, 'Store at room temperature', true, 2),
(36, 'Cardizem', 'Bausch Health', 34, '90 mg', 'tablet', 'oral', '00187-0773-01', 4.00, 'Store at room temperature', false, 3),

-- Doxycycline
(37, 'Vibramycin', 'Pfizer', 35, '50 mg', 'capsule', 'oral', '0069-0950-50', 3.00, 'Store at room temperature', false, 1),
(38, 'Vibramycin', 'Pfizer', 35, '100 mg', 'capsule', 'oral', '0069-0970-50', 4.00, 'Store at room temperature', true, 2),

-- Duloxetine
(39, 'Cymbalta', 'Eli Lilly', 36, '20 mg', 'capsule', 'oral', '0002-3235-60', 6.00, 'Store at room temperature', false, 1),
(40, 'Cymbalta', 'Eli Lilly', 36, '30 mg', 'capsule', 'oral', '0002-3240-30', 7.00, 'Store at room temperature', true, 2),
(41, 'Cymbalta', 'Eli Lilly', 36, '60 mg', 'capsule', 'oral', '0002-3270-30', 8.00, 'Store at room temperature', false, 3),

-- Escitalopram
(42, 'Lexapro', 'Forest Labs', 37, '5 mg', 'tablet', 'oral', '0456-2005-01', 4.00, 'Store at room temperature', false, 1),
(43, 'Lexapro', 'Forest Labs', 37, '10 mg', 'tablet', 'oral', '0456-2010-01', 5.00, 'Store at room temperature', true, 2),
(44, 'Lexapro', 'Forest Labs', 37, '20 mg', 'tablet', 'oral', '0456-2020-01', 6.00, 'Store at room temperature', false, 3),

-- Estradiol
(45, 'Estrace', 'Allergan', 38, '0.5 mg', 'tablet', 'oral', '0023-0500-01', 3.00, 'Store at room temperature', false, 1),
(46, 'Estrace', 'Allergan', 38, '1 mg', 'tablet', 'oral', '0023-1000-01', 4.00, 'Store at room temperature', true, 2),
(47, 'Estrace', 'Allergan', 38, '2 mg', 'tablet', 'oral', '0023-2000-01', 5.00, 'Store at room temperature', false, 3),

-- Ethosuximide
(48, 'Zarontin', 'Pfizer', 54, '250 mg', 'capsule', 'oral', '0071-0650-24', 6.00, 'Store at room temperature', true, 1),
(49, 'Zarontin', 'Pfizer', 54, '250 mg/5mL', 'syrup', 'oral', '0071-0651-24', 15.00, 'Store at room temperature', false, 2),

-- Felbamate
(50, 'Felbatol', 'MedPointe', 55, '400 mg', 'tablet', 'oral', '0037-0600-01', 7.00, 'Store at room temperature', true, 1),
(51, 'Felbatol', 'MedPointe', 55, '600 mg', 'tablet', 'oral', '0037-0600-60', 8.50, 'Store at room temperature', false, 2),

-- Fexofenadine
(52, 'Allegra', 'Sanofi', 33, '60 mg', 'tablet', 'oral', '0088-1106-30', 1.50, 'Store at room temperature', false, 1),
(53, 'Allegra', 'Sanofi', 33, '180 mg', 'tablet', 'oral', '0088-1108-30', 2.50, 'Store at room temperature', true, 2),

-- Fluconazole
(54, 'Diflucan', 'Pfizer', 39, '50 mg', 'tablet', 'oral', '0069-3360-50', 8.00, 'Store at room temperature', false, 1),
(55, 'Diflucan', 'Pfizer', 39, '100 mg', 'tablet', 'oral', '0069-3370-50', 12.00, 'Store at room temperature', true, 2),
(56, 'Diflucan', 'Pfizer', 39, '200 mg', 'tablet', 'oral', '0069-3380-50', 20.00, 'Store at room temperature', false, 3),

-- Fluticasone
(57, 'Flovent', 'GSK', 10, '44 mcg', 'inhaler', 'inhalation', '0173-0718-00', 180.00, 'Store at room temperature', false, 1),
(58, 'Flovent', 'GSK', 10, '110 mcg', 'inhaler', 'inhalation', '0173-0719-00', 220.00, 'Store at room temperature', true, 2),
(59, 'Flovent', 'GSK', 10, '220 mcg', 'inhaler', 'inhalation', '0173-0720-00', 280.00, 'Store at room temperature', false, 3),

-- Furosemide
(60, 'Lasix', 'Sanofi', 12, '20 mg', 'tablet', 'oral', '0039-0067-10', 1.00, 'Store at room temperature', false, 1),
(61, 'Lasix', 'Sanofi', 12, '40 mg', 'tablet', 'oral', '0039-0067-20', 1.50, 'Store at room temperature', true, 2),
(62, 'Lasix', 'Sanofi', 12, '80 mg', 'tablet', 'oral', '0039-0067-30', 2.00, 'Store at room temperature', false, 3),

-- Hydrochlorothiazide
(63, 'Microzide', 'Watson', 13, '12.5 mg', 'capsule', 'oral', '0591-2525-10', 0.75, 'Store at room temperature', false, 1),
(64, 'Microzide', 'Watson', 13, '25 mg', 'capsule', 'oral', '0591-2526-10', 1.00, 'Store at room temperature', true, 2),

-- Ipratropium
(65, 'Atrovent', 'Boehringer', 14, '17 mcg', 'inhaler', 'inhalation', '0597-0087-17', 180.00, 'Store at room temperature', true, 1),
(66, 'Atrovent', 'Boehringer', 14, '0.02%', 'solution', 'inhalation', '0597-0087-20', 45.00, 'Store at room temperature', false, 2),

-- Continuing with remaining medications...
-- Lamotrigine through Zonisamide following same pattern
(67, 'Lamictal', 'GSK', 56, '25 mg', 'tablet', 'oral', '0173-0633-02', 3.00, 'Store at room temperature', false, 1),
(68, 'Lamictal', 'GSK', 56, '100 mg', 'tablet', 'oral', '0173-0633-00', 5.00, 'Store at room temperature', true, 2),

-- Levetiracetam
(69, 'Keppra', 'UCB', 57, '500 mg', 'tablet', 'oral', '0456-1500-01', 4.00, 'Store at room temperature', true, 1),
(70, 'Keppra', 'UCB', 57, '1000 mg', 'tablet', 'oral', '0456-1510-01', 6.00, 'Store at room temperature', false, 2),

-- Levothyroxine
(71, 'Synthroid', 'AbbVie', 15, '50 mcg', 'tablet', 'oral', '0074-4550-90', 0.75, 'Store at room temperature', false, 1),
(72, 'Synthroid', 'AbbVie', 15, '100 mcg', 'tablet', 'oral', '0074-4551-90', 1.00, 'Store at room temperature', true, 2),
(73, 'Synthroid', 'AbbVie', 15, '150 mcg', 'tablet', 'oral', '0074-4552-90', 1.25, 'Store at room temperature', false, 3),

-- Linaclotide
(74, 'Linzess', 'Allergan', 40, '145 mcg', 'capsule', 'oral', '0456-1201-30', 15.00, 'Store at room temperature', true, 1),
(75, 'Linzess', 'Allergan', 40, '290 mcg', 'capsule', 'oral', '0456-1202-30', 15.00, 'Store at room temperature', false, 2),

-- Linezolid
(76, 'Zyvox', 'Pfizer', 41, '600 mg', 'tablet', 'oral', '0069-1180-01', 120.00, 'Store at room temperature', true, 1),
(77, 'Zyvox', 'Pfizer', 41, '100 mg/5mL', 'suspension', 'oral', '0069-1190-01', 150.00, 'Store at room temperature', false, 2),

-- Lisinopril
(78, 'Prinivil', 'Merck', 16, '10 mg', 'tablet', 'oral', '0006-0074-10', 0.75, 'Store at room temperature', false, 1),
(79, 'Prinivil', 'Merck', 16, '20 mg', 'tablet', 'oral', '0006-0074-20', 1.00, 'Store at room temperature', true, 2),

-- Metaxalone
(80, 'Skelaxin', 'King', 42, '800 mg', 'tablet', 'oral', '60793-411-01', 4.50, 'Store at room temperature', true, 1),
(81, 'Skelaxin', 'King', 42, '400 mg', 'tablet', 'oral', '60793-411-02', 3.50, 'Store at room temperature', false, 2),

-- Metformin
(82, 'Glucophage', 'Bristol-Myers', 18, '500 mg', 'tablet', 'oral', '0087-6060-05', 0.50, 'Store at room temperature', false, 1),
(83, 'Glucophage', 'Bristol-Myers', 18, '1000 mg', 'tablet', 'oral', '0087-6070-05', 0.75, 'Store at room temperature', true, 2),

-- Methocarbamol
(84, 'Robaxin', 'Endo', 43, '500 mg', 'tablet', 'oral', '63323-379-10', 2.00, 'Store at room temperature', false, 1),
(85, 'Robaxin', 'Endo', 43, '750 mg', 'tablet', 'oral', '63323-379-15', 2.50, 'Store at room temperature', true, 2),

-- Mirtazapine
(86, 'Remeron', 'Organon', 58, '15 mg', 'tablet', 'oral', '0052-0105-30', 3.00, 'Store at room temperature', true, 1),
(87, 'Remeron', 'Organon', 58, '30 mg', 'tablet', 'oral', '0052-0107-30', 4.00, 'Store at room temperature', false, 2),

-- Mupirocin
(88, 'Bactroban', 'GSK', 44, '2%', 'ointment', 'topical', '0029-1527-22', 45.00, 'Store at room temperature', true, 1),
(89, 'Bactroban', 'GSK', 44, '2%', 'cream', 'topical', '0029-1527-25', 45.00, 'Store at room temperature', false, 2),

-- Nitrofurantoin
(90, 'Macrobid', 'Procter & Gamble', 45, '100 mg', 'capsule', 'oral', '52427-285-01', 3.00, 'Store at room temperature', true, 1),
(91, 'Macrobid', 'Procter & Gamble', 45, '50 mg', 'capsule', 'oral', '52427-285-02', 2.50, 'Store at room temperature', false, 2),

-- Nortriptyline
(92, 'Pamelor', 'Mallinckrodt', 59, '25 mg', 'capsule', 'oral', '0406-9925-01', 2.50, 'Store at room temperature', true, 1),
(93, 'Pamelor', 'Mallinckrodt', 59, '50 mg', 'capsule', 'oral', '0406-9950-01', 3.50, 'Store at room temperature', false, 2),

-- Omeprazole
(94, 'Prilosec', 'AstraZeneca', 21, '20 mg', 'capsule', 'oral', '0186-0740-31', 3.00, 'Store at room temperature', true, 1),
(95, 'Prilosec', 'AstraZeneca', 21, '40 mg', 'capsule', 'oral', '0186-0741-31', 4.00, 'Store at room temperature', false, 2),

-- Orphenadrine
(96, 'Norflex', ' 3M', 46, '100 mg', 'tablet', 'oral', '0089-0230-11', 2.50, 'Store at room temperature', true, 1),
(97, 'Norflex', '3M', 46, '100 mg/mL', 'injection', 'intramuscular', '0089-0231-11', 15.00, 'Store at room temperature', false, 2),

-- Oxcarbazepine
(98, 'Trileptal', 'Novartis', 60, '300 mg', 'tablet', 'oral', '0078-0337-05', 4.00, 'Store at room temperature', true, 1),
(99, 'Trileptal', 'Novartis', 60, '600 mg', 'tablet', 'oral', '0078-0338-05', 6.00, 'Store at room temperature', false, 2),

-- Phenytoin
(100, 'Dilantin', 'Pfizer', 62, '100 mg', 'capsule', 'oral', '0071-0369-24', 2.00, 'Store at room temperature', true, 1),
(101, 'Dilantin', 'Pfizer', 62, '30 mg', 'capsule', 'oral', '0071-0370-24', 1.50, 'Store at room temperature', false, 2),

-- Quetiapine
(102, 'Seroquel', 'AstraZeneca', 64, '100 mg', 'tablet', 'oral', '0310-0271-10', 8.00, 'Store at room temperature', true, 1),
(103, 'Seroquel', 'AstraZeneca', 64, '300 mg', 'tablet', 'oral', '0310-0272-10', 15.00, 'Store at room temperature', false, 2),

-- Sertraline
(104, 'Zoloft', 'Pfizer', 22, '50 mg', 'tablet', 'oral', '0049-4910-30', 3.00, 'Store at room temperature', true, 1),
(105, 'Zoloft', 'Pfizer', 22, '100 mg', 'tablet', 'oral', '0049-4920-30', 4.50, 'Store at room temperature', false, 2),

-- Spironolactone
(106, 'Aldactone', 'Pfizer', 49, '25 mg', 'tablet', 'oral', '0025-1011-31', 1.50, 'Store at room temperature', true, 1),
(107, 'Aldactone', 'Pfizer', 49, '50 mg', 'tablet', 'oral', '0025-1012-31', 2.00, 'Store at room temperature', false, 2),

-- Topiramate
(108, 'Topamax', 'Janssen', 68, '50 mg', 'tablet', 'oral', '50458-641-50', 5.00, 'Store at room temperature', true, 1),
(109, 'Topamax', 'Janssen', 68, '100 mg', 'tablet', 'oral', '50458-642-50', 7.50, 'Store at room temperature', false, 2),

-- Trazodone
(110, 'Desyrel', 'Pfizer', 69, '50 mg', 'tablet', 'oral', '0049-5900-30', 1.50, 'Store at room temperature', true, 1),
(111, 'Desyrel', 'Pfizer', 69, '100 mg', 'tablet', 'oral', '0049-5910-30', 2.00, 'Store at room temperature', false, 2),

-- Valacyclovir
(112, 'Valtrex', 'GSK', 51, '500 mg', 'tablet', 'oral', '0173-0933-00', 12.00, 'Store at room temperature', true, 1),
(113, 'Valtrex', 'GSK', 51, '1000 mg', 'tablet', 'oral', '0173-0934-00', 20.00, 'Store at room temperature', false, 2),

-- Vancomycin
(114, 'Vancocin', 'Eli Lilly', 52, '125 mg', 'capsule', 'oral', '0002-3122-60', 25.00, 'Store at room temperature', true, 1),
(115, 'Vancocin', 'Eli Lilly', 52, '250 mg', 'capsule', 'oral', '0002-3123-60', 40.00, 'Store at room temperature', false, 2),

-- Voriconazole
(116, 'Vfend', 'Pfizer', 53, '50 mg', 'tablet', 'oral', '0049-3170-30', 30.00, 'Store at room temperature', false, 1),
(117, 'Vfend', 'Pfizer', 53, '200 mg', 'tablet', 'oral', '0049-3180-30', 90.00, 'Store at room temperature', true, 2),

-- Zonisamide
(118, 'Zonegran', 'Concordia', 72, '25 mg', 'capsule', 'oral', '0187-5325-60', 3.00, 'Store at room temperature', false, 1),
(119, 'Zonegran', 'Concordia', 72, '100 mg', 'capsule', 'oral', '0187-5328-60', 5.00, 'Store at room temperature', true, 2);