bamazon/bamazon.sql at master · Lorica7/bamazon · GitHub

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
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
DROP DATABASE IF EXISTS bamazonDB;
CREATE database bamazonDB;

USE bamazonDB;

CREATE TABLE products (
  id INTEGER(11) NOT NULL AUTO_INCREMENT,
  item_name VARCHAR(100) NOT NULL,
  department_name VARCHAR(100) NOT NULL,
  price DECIMAL(20) NOT NULL,
  stock_quantity INTEGER(20) NOT NULL,
  PRIMARY KEY (id)
);

INSERT INTO products (item_name, department_name, price, stock_quantity)
VALUES ("Macbook", "Computers and Electronics", 2100.99, 500);

INSERT INTO products (item_name, department_name, price, stock_quantity)
VALUES ("Karhu sneakers", "Ladies Sneakers", 130.99, 750);

INSERT INTO products (item_name, department_name, price, stock_quantity)
VALUES ("Protein Bars Pack", "Pantry Goods", 24.99, 241);

INSERT INTO products (item_name, department_name, price, stock_quantity)
VALUES ("Spiritual Gangster Lotus T-shirt", "Ladies Athletics, Yoga", 45.00, 100);

INSERT INTO products (item_name, department_name, price, stock_quantity)
VALUES ("Nutribullet", "Kitchen Appliances", 110.99, 2000);

INSERT INTO products (item_name, department_name, price, stock_quantity)
VALUES ("Juicer", "Kitchen Appliances", 375.69, 1500);

INSERT INTO products (item_name, department_name, price, stock_quantity)
VALUES ("The Name of the Rose", "Books", 28.99, 2347);

INSERT INTO products (item_name, department_name, price, stock_quantity)
VALUES ("Cards Against Humanity", "Games", 30.00, 579);

INSERT INTO products (item_name, department_name, price, stock_quantity)
VALUES ("Horse hooves(10 pack)", "Pet products, Dogs", 27.88, 125);

INSERT INTO products (item_name, department_name, price, stock_quantity)
VALUES ("Training Treats", "Pet products, Dogs", 2100.99, 509);

INSERT INTO products (item_name, department_name, price, stock_quantity)
VALUES ("Javascript for Dummies", "Books", 24.99, 4760);

INSERT INTO products (item_name, department_name, price, stock_quantity)
VALUES ("Tao Te Ching", "Books", 27.99,725);

INSERT INTO products (item_name, department_name, price, stock_quantity)
VALUES ("iPhone", "Computers and Electronics", 1000, 9000);

INSERT INTO products (item_name, department_name, price, stock_quantity)
VALUES ("Monitor", "Computers and Electronics", 875, 85);