seeds.sql

use bamazon;

INSERT INTO departments (department_name, over_head_costs)
VALUES ("produce", 1000);

INSERT INTO departments (department_name, over_head_costs)
VALUES ("electronics", 1000);

INSERT INTO departments (department_name, over_head_costs)
VALUES ("customer service", 1000);

INSERT INTO departments (department_name, over_head_costs)
VALUES ("arts and crafts", 1000);

INSERT INTO departments (department_name, over_head_costs)
VALUES ("home improvement", 1000);

INSERT INTO departments (department_name, over_head_costs)
VALUES ("beauty", 1000);

INSERT INTO departments (department_name, over_head_costs)
VALUES ("camping", 1000);

INSERT INTO departments (department_name, over_head_costs)
VALUES ("meat", 1000);

INSERT INTO products   (item_id, product_name, department_id, price, stock_quantity)
VALUES (1, "bananas", 1, 5.99, 20 ); 

INSERT INTO products   (item_id, product_name, department_id, price, stock_quantity)
VALUES (2, "computer", 2, 9999.99, 10); 

INSERT INTO products   (item_id, product_name, department_id, price, stock_quantity)
VALUES (3, "membership card", 3, 150, 100); 

INSERT INTO products   (item_id, product_name, department_id, price, stock_quantity)
VALUES (4, "printer", 2, 150, 20); 

INSERT INTO products   (item_id, product_name, department_id, price, stock_quantity)
VALUES (5, "microwave", 2, 200.31, 5); 

INSERT INTO products   (item_id, product_name, department_id, price, stock_quantity)
VALUES (6, "poster board", 4, 9.99, 50); 

INSERT INTO products   (item_id, product_name, department_id, price, stock_quantity)
VALUES (7, "paint brushes", 5, 3.95, 200); 

INSERT INTO products   (item_id, product_name, department_id, price, stock_quantity)
VALUES (8, "makeup", 6, 9.99, 100); 

INSERT INTO products   (item_id, product_name, department_id, price, stock_quantity)
VALUES (9, "tent", 7, 500.00, 3); 

INSERT INTO products   (item_id, product_name, department_id, price, stock_quantity)
VALUES (10, "steak", 8, 49.99, 9);