create database sklep;

create table produkt(
	idProdukt int primary key auto_increment,
	Nazwa varchar(45),
	Cena decimal(8,2),
	Podatek decimal(2,2)
	);
create table Klient(
	idKlient int primary key auto_increment,
	Nazwa varchar(45),
	Adres varchar(45),
	NIP varchar(10)
);
create table Faktura(
	idFaktura int primary key auto_increment,
	Klient_idKlient int, foreign key (Klient_idKlient) references Klient(idKlient)
);
create table Faktura_Produkt(
	idFaktura_Produkt int primary key auto_increment,
	Faktura_idFaktura int, foreign key (Faktura_idFaktura) references Faktura(idFaktura),
	Produkt_idProdukt int, foreign key (Produkt_idProdukt) references Produkt(idProdukt),
	Ilosc decimal(8,2),
	Upust decimal(8,2)
);
insert into Klient values(
	null,
	"Klient pierwszy",
	"Nibylandia 16",
	1234567890
);
insert into Klient values(
	null,
	"Klient drugi",
	"Nigdziebadz 12",
	0987654321
);
insert into Produkt values(
	null,
	"Wihajster",
	"15.25",
	"23%"
);
insert into Produkt values(
	null,
	"Dynks",
	"12.00",
	"8%"
);
insert into Produkt values(
	null,
	"Przyczałka do bumbulatorka nr 5",
	"69.99",
	"23%"
);
insert into Produkt values(
	null,
	"Korba od reaktora",
	"20.00",
	"8%"
);
insert into Faktura values(
	null,
	1
);
insert into Faktura values(
	null,
	2
);insert into Faktura values(
	null,
	2
);
insert into Faktura_Produkt values(
	null,
	1,
	1,
	"3",
	"10%"
);
insert into Faktura_Produkt values(
	null,
	1,
	2,
	"44",
	"0%"
);
insert into Faktura_Produkt values(
	null,
	1,
	3,
	"2",
	"15%"
);
insert into Faktura_Produkt values(
	null,
	1,
	4,
	"5",
	"2.5%"
);
insert into Faktura_Produkt values(
	null,
	2,
	2,
	"4",
	"10%"
);
insert into Faktura_Produkt values(
	null,
	2,
	4,
	"4",
	"0%"
);
insert into Faktura_Produkt values(
	null,
	3,
	1,
	"4",
	"50%"
);
insert into Faktura_Produkt values(
	null,
	3,
	3,
	"1",
	"0%"
);
insert into Faktura_Produkt values(
	null,
	3,
	4,
	"17",
	"5%"
);