data.sql

-- =================================================
-- Queries to insert data
-- =================================================

-- Insert data into categories
INSERT INTO categories (name) VALUES
('Electronics'),
('Tools'),
('Office'),
('Gaming');

-- Insert data into suppliers
INSERT INTO suppliers (name, telephone, country) VALUES
('TechSupply', '123456789', 'Spain'),
('GlobalParts', '987654321', 'Germany'),
('OfficeWorld', '555666777', 'France');

-- Insert data into products
INSERT INTO products (name, price, stock, id_category, id_supplier) VALUES
('Laptop', 1200.00, 10, 1, 1),
('Ratón Gaming', 45.99, 50, 4, 1),
('Taladro', 89.50, 15, 2, 2),
('Impresora', 150.00, 8, 3, 3),
('Teclado Mecánico', 120.00, 20, 4, 1);