CREATE TABLE klienci
{
	id_klienta INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
	imie VARCHAR(50) NOT NULL,
	nazwisko VARCHAR(100) NOT NULL,
	login VARCHAR(50) NOT NULL,
	haslo VARCHAR(50),
	CONSTRAINT login_unique UNIQUE (login)

};

CREATE TABLE zakupy
(
	id INT NOT NULL,
	przedmiot VARCHAR(50) NOT NULL,
	data_zakupu DATE NOT NULL,
	cena float NOT NULL,
	CONSTRAINT fk_id_klienta
	FOREIGN KEY (id)
    REFERENCES studenci(id_klienta)
);