insert into webs.category (`name`) values
	("Verse fruit en groenten"),
	("Boeken"),
	("Overig");

insert into webs.product (`name`, `price`, `category`, `image`) values
	("Appel", 0.90, 1, true),
	("Banaan", 1.10, 1, true),
	("Peer", 0.99, 1, true),
	("ハリネズミのハリー 第１巻", 5.99, 1, true),
	("ハリネズミのハリー 第２巻", 5.99, 1, false),
	("ハリネズミのハリー 第３巻", 5.99, 1, false),
	("イジらないで、長瀞さん 第１巻", 5.49, 1, false),
	("イジらないで、長瀞さん 第２巻", 5.49, 1, false),
	("Kip", 9.95, 3, true),
	("Kikker", 19.95, 3, true);

update webs.product set description = "<ul><li>lekker sappig</li><li>zonder BTW</li></ul>" where id = 1;
update webs.product set description = "<ul><li>snel bruin</li><li>zonder BTW</li></ul>" where id = 2;
update webs.product set description = "<ul><li>kurkdroog</li><li>zonder BTW</li></ul>" where id = 3;

insert into webs.customer (`name`) values
	("loek"),
	("bert"),
	("niels"),
	("joshua"),
	("willem");

insert into webs.cart (`product`, `customer`) values
	(4, 1),
	(5, 1),
	(6, 1),
	(7, 1),
	(8, 1);

insert into webs.promotion (`product`, `price_buff`) values
	(1, 0.80), -- 20% korting
	(2, 0.80),
	(3, 0.80);
