mJR88r6u

1-- DROP SCHEMA IF EXISTS `tutorial`;
2 DROP Table `tutorial` . `product`;
3--  CREATE SCHEMA `tutorial`;
4--  USE `tutorial`;
5--  
6--  
7 CREATE TABLE IF NOT EXISTS `tutorial` . `product`(
8	 `product_id` BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
9	 `name` VARCHAR(40) DEFAULT NULL,
10	 `description` VARCHAR(256) DEFAULT NULL,
11	 `unit_price` DECIMAL (13,2) DEFAULT NULL,
12	 `units_in_stock` INT(11) DEFAULT NULL
13 );
14--  
15--  
16INSERT INTO tutorial.product
17(name,description,unit_price,units_in_stock)
18VALUES
19('test','super',5.32,5),
20('banan','świeży',3.20,6),
21  ('butelka wody','niegazowana',1.00,1),
22  ('ser','żółty',10.99,1),
23  ('ser','biały',16.99,1),
24  ('mleko','3,2% ',10.99,1),
25  ('Monster Energy nap. energ. 500ml', 'ORIGINAL', 4.99, 20),
26  ('Monster Energy nap. energ. 500ml', 'THE DOCTOR', 4.99, 20),
27  ('Level Up nap. energ. 250ml', 'CLASSIC', 1.99, 30),
28  ('Level Up nap. energ. 250ml', 'MANGO', 1.99, 30);
29--  
30-- -- DELETE from tutorial.product
31-- -- where id = 1;
32--  
33-- UPDATE tutorial.product
34-- SET name = 'pierwszy'
35-- where id = 1;
36
37
38CREATE TABLE IF NOT EXISTS `tutorial` . `order`(
39 `order_id` BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
40 `orderNumber` INT DEFAULT NULL,
41 `product_id` INT,
42 FOREIGN KEY(product_id) REFERENCES product(product_id)
43 );