-
Notifications
You must be signed in to change notification settings - Fork 0
/
bmazonSeeds.sql
29 lines (21 loc) · 1 KB
/
bmazonSeeds.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
CREATE DATABASE bmazon;
USE bmazon;
CREATE TABLE departments (
dept_id INT NOT NULL AUTO_INCREMENT,
department_name VARCHAR(200) NOT NULL,
over_head_costs DECIMAL(20,2) NOT NULL,
PRIMARY KEY (dept_id)
)
CREATE TABLE products (
id INT NOT NULL AUTO_INCREMENT,
product_name VARCHAR(200) NOT NULL,
department_name VARCHAR(200) NOT NULL,
price DECIMAL(10,2) NOT NULL,
stock_quantity INT(10) NOT NULL,
PRIMARY KEY (id)
);
INSERT INTO products (product_name, department_name, price, stock_quantity)
VALUES ("water bottle", "sporting goods", 16.00, 300), ("12in Cast Iron Skillet", "cookware", 20.00, 200),
("PS5", "electronics", 2000.00, 3), ("Dove Dark Chocolate", "food", 10.00, 50), ("Moulin Rouge DVD", "electronics", 22.00, 18),
("Baby Bear Chair", "Home&Decor", 30.00, 23), ("Duplos", "Toys", 13.00, 600), ("Upright Piano", "Instruments", 3,500, 6),
("Flower Pot", "Home&Garden", 14.00, 300), ("Purple Steering Wheel Cover", "automotive", 26.00, 67);