alter table Klant add column Woonplaats varchar(45) not null;
alter table `Order` add column Leverdatum date not null;
alter table Product add column Voorraad int not null;

update Klant set Woonplaats = "'s-Hertogenbosch" where ID = 1;
update Klant set Woonplaats = "Nijmegen" where ID = 2;
update Klant set Woonplaats = "Tilburg" where ID = 3;

update `Order` set Leverdatum = '2022-10-02' where ID = 1;
update `Order` set Leverdatum = '2014-03-13' where ID = 2;
update `Order` set Leverdatum = '2019-01-01' where ID = 3;
update `Order` set Leverdatum = '2023-07-28' where ID = 4;
update `Order` set Leverdatum = '2018-02-23' where ID = 5;

update Product set Voorraad = 15 where ID = 1;
update Product set Voorraad = 7 where ID = 2;
update Product set Voorraad = 23 where ID = 3;
update Product set Voorraad = 14 where ID = 4;
update Product set Voorraad = 30 where ID = 5;

