bamazon/bamazon.sql at master · skendall74/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
DROP DATABASE IF EXISTS bamazonDB;
CREATE database bamazonDB;

USE bamazonDB;

CREATE TABLE products (
  id INT NOT NULL AUTO_INCREMENT,
  product_name VARCHAR(45) NULL,
  department_name VARCHAR(45) NULL,
  price DECIMAL(10,2) NULL,
  quantity INT NULL,
  PRIMARY KEY (id)
);


INSERT INTO products (product_name, department_name, price, quantity)
VALUES ("UF Blue Game Jersey", "Jersey", 100.00, 100);

INSERT INTO products (product_name, department_name, price, quantity)
VALUES ("UF Orange Game Jersey", "Jersey", 100.00, 100);

INSERT INTO products (product_name, department_name, price, quantity)
VALUES ("UF Coaches Polo", "Shirts", 59.99, 100);

INSERT INTO products (product_name, department_name, price, quantity)
VALUES ("Florida Fitted Wool Cap Blue", "Hats", 22.50, 100);

INSERT INTO products (product_name, department_name, price, quantity)
VALUES ("Florida Jumpman Cap Orange", "Hats", 32.00, 100);

INSERT INTO products (product_name, department_name, price, quantity)
VALUES ("UF Crewneck Sweatshirt", "Sweatshirts", 34.00, 100);

INSERT INTO products (product_name, department_name, price, quantity)
VALUES ("UF 20 oz. Pub Glass", "Home Decor", 9.95, 100);

INSERT INTO products (product_name, department_name, price, quantity)
VALUES ("UF Mini Pennant Magnet", "Home Decor", 4.95, 100);

INSERT INTO products (product_name, department_name, price, quantity)
VALUES ("UF Otterbox Black Commuter case", "School Accessories", 69.95, 100);

INSERT INTO products (product_name, department_name, price, quantity)
VALUES ("UF Diploma Frame", "Diploma Frames", 165.00, 100);