-- =====================================================
-- SIMPUS Seed Master Data - Rollback
-- Version: 000007
-- =====================================================

-- Remove seeded medicine references
DELETE FROM medicine_references WHERE code IN (
    'PAR-500', 'AMP-500', 'IBU-400', 'CTZ-10', 'OMZ-20',
    'MET-500', 'AML-5', 'VIT-C-500', 'SALB-100', 'LOR-10'
);

-- Remove seeded ICD-9-CM codes
DELETE FROM icd9cm_codes WHERE code IN (
    '99.52', '99.04', '93.22', '96.04', '99.15'
);

-- Remove seeded ICD-9-CM chapters
DELETE FROM icd9cm_chapters WHERE code = '99';

-- Remove seeded ICD-10 codes
DELETE FROM icd10_codes WHERE code IN (
    'A09', 'A15', 'B50', 'E11', 'I10', 'J00', 'J06', 'J18',
    'K29', 'K59', 'N39', 'R50', 'Z00'
);

