GymBeef

DROP DATABASE IF EXISTS GYMBEEF;

CREATE DATABASE GYMBEEF;

USE GYMBEEF;

CREATE TABLE GymBeefPrasok
(
    id      INT AUTO_INCREMENT PRIMARY KEY,
    nazov   VARCHAR(100)  NOT NULL,
    cena    DECIMAL(3)    NOT NULL,
    vaha_kg DECIMAL(3, 1) NOT NULL
);

INSERT INTO GymBeefPrasok (id, nazov, cena, vaha_kg)
VALUES (1, 'WHEY_Protein', 40, 2.0),
       (2, 'Creatine_Monohydrate', 25, 0.5),
       (3, 'Preworkout', 60, 0.5),
       (4, 'Cream_of_Rice', 30, 1.0),
       (5, 'Aminokisliky', 15, 0.5),
       (6, 'Gainer', 60, 6.8),
       (7, 'Citruline', 12, 0.2),
       (8, 'Beta_Alanine', 10, 0.5),
       (9, 'Glycerol', 10, 0.1),
       (10, 'Argenyne', 25, 0.3),
       (11, 'Carnitine', 10, 1.0),
       (12, 'Kolagen', 17, 0.5);

CREATE TABLE GymBeefPills
(
    id    INT AUTO_INCREMENT PRIMARY KEY,
    nazov VARCHAR(100) NOT NULL,
    cena  DECIMAL(3)   NOT NULL,
    kus   INT (3) NOT NULL
);

INSERT INTO GymBeefPills (nazov, cena, kus)
VALUES ('Vitamin_A', 5, 100),
       ('Vitamin_B', 6, 120),
       ('Vitamin_C', 5, 180),
       ('Vitamin_D', 7, 100),
       ('Vitamin_E', 5, 120),
       ('Vitamin_B12', 8, 100),
       ('Vitamin_B6', 5, 100),
       ('Vitamin_B3', 45, 180),
       ('Vitamin_D3', 5, 100),
       ('Zinc', 5, 100),
       ('Melatonin', 5, 100),
       ('Mashrooms', 5, 180);

SELECT * FROM GymBeefPrasok;

SELECT * FROM GymBeefPills;