1 files changed, 35 insertions, 1 deletions
diff --git a/db/data.sql b/db/data.sql
index 4ba2805..4fb248e 100644
--- a/db/data.sql
+++ b/db/data.sql
@@ -1 +1,35 @@
---
+insert into webs.category (`name`) values
+	("Verse fruit en groenten"),
+	("Boeken"),
+	("Overig");
+
+insert into webs.product (`name`, `price`, `category`) values
+	("Appel", 0.90, 1),
+	("Banaan", 1.10, 1),
+	("Peer", 0.99, 1),
+	("ハリネズミのハリー 第１巻", 5.99, 1),
+	("ハリネズミのハリー 第２巻", 5.99, 1),
+	("ハリネズミのハリー 第３巻", 5.99, 1),
+	("イジらないで、長瀞さん 第１巻", 5.49, 1),
+	("イジらないで、長瀞さん 第２巻", 5.49, 1),
+	("Kip", 9.95, 3),
+	("Kikker", 19.95, 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);