USE pharmacy_db;

INSERT INTO categories (name) VALUES
('Pain Relief'),
('Antibiotics'),
('Vitamins');

INSERT INTO suppliers (name, contact) VALUES
('Supplier A', 'contact@a.com'),
('Supplier B', 'contact@b.com');

INSERT INTO medicines (name, category_id, batch_number, expiry_date, price, quantity, supplier_id) VALUES
('Aspirin', 1, 'B001', '2025-12-31', 5.00, 100, 1),
('Vitamin C', 3, 'B002', '2026-01-01', 10.00, 50, 2);