USE pharmacy_db;

INSERT INTO users (username, password, role) VALUES
('admin', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'admin'),
('pharmacist', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'pharmacist'),
('cashier', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'cashier');

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);