-- Kwerenda 1
CREATE TABLE zamowienia (
    id INT UNSIGNED NOT NULL,
    imie VARCHAR(50) DEFAULT NULL,
    nazwisko VARCHAR(50) DEFAULT NULL,
    adres_email VARCHAR(100) DEFAULT NULL,
    liczba_choinek INT UNSIGNED DEFAULT NULL,
    liczba_mikolajow INT UNSIGNED DEFAULT NULL,
    liczba_reniferow INT UNSIGNED DEFAULT NULL,
    info BOOLEAN DEFAULT NULL
);

-- Kwerenda 2
ALTER TABLE zamowienia
    ADD PRIMARY KEY (id),
    MODIFY id INT UNSIGNED NOT NULL AUTO_INCREMENT;

-- Kwerenda 3
CREATE USER 'klient'@'localhost' IDENTIFIED BY 'klient123';

-- Kwerenda 4
GRANT INSERT ON sklep.* TO 'klient'@'localhost';

-- Kwerenda 5
INSERT INTO zamowienia (imie, nazwisko, adres_email)
VALUES ('Jan', 'Kowalski', 'jKowalski@poczta.pl');
