2 files changed, 19 insertions, 15 deletions
diff --git a/db/data.sql b/db/data.sql
index 55f59df..fb85463 100644
--- a/db/data.sql
+++ b/db/data.sql
@@ -15,6 +15,10 @@ insert into webs.product (`name`, `price`, `category`, `image`) values
 	("Kip", 9.95, 3, false),
 	("Kikker", 19.95, 3, false);
 
+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"),
diff --git a/db/init.sql b/db/init.sql
index a9fc25b..4be1768 100644
--- a/db/init.sql
+++ b/db/init.sql
@@ -1,61 +1,61 @@
 create schema if not exists webs;
 
 create table if not exists webs.category (
-  `ID` int not null auto_increment,
+  `id` int not null auto_increment,
   `name` varchar(45) not null,
 	`parent` int null default null,
-  primary key (`ID`),
+  primary key (`id`),
   constraint `category_parent_fk`
     foreign key (`parent`)
-    references webs.category (`ID`)
+    references webs.category (`id`)
     on update cascade
 );
 
 create table if not exists webs.product (
-  `ID` int not null auto_increment,
+  `id` int not null auto_increment,
   `name` varchar(255) not null,
   `price` decimal(5, 2) not null,
   `image` boolean not null default false,
   `description` mediumtext null default null,
 	`category` int not null,
-  primary key (`ID`),
+  primary key (`id`),
   constraint `product_category_fk`
     foreign key (`category`)
-    references webs.category (`ID`)
+    references webs.category (`id`)
     on update cascade
 );
 
 create table if not exists webs.customer (
-  `ID` int not null auto_increment,
+  `id` int not null auto_increment,
   `name` varchar(45) not null,
-  primary key (`ID`)
+  primary key (`id`)
 );
 
 create table if not exists webs.cart (
-  `ID` int not null auto_increment,
+  `id` int not null auto_increment,
   `product` int not null,
   `customer` int not null,
 	`count` int not null default 1,
-  primary key (`ID`),
+  primary key (`id`),
   constraint `cart_product_fk`
     foreign key (`product`)
-    references webs.product (`ID`)
+    references webs.product (`id`)
     on update cascade,
   constraint `cart_customer_fk`
     foreign key (`customer`)
-    references webs.customer (`ID`)
+    references webs.customer (`id`)
     on update cascade
 );
 
 create table if not exists webs.promotion (
-  `ID` int not null auto_increment,
+  `id` int not null auto_increment,
   `product` int not null,
   `count_buff` int not null default 1,
 	`price_buff` decimal(4, 3) not null default 1.0,
-  primary key (`ID`),
+  primary key (`id`),
   constraint `promotion_product_fk`
     foreign key (`product`)
-    references webs.product (`ID`)
+    references webs.product (`id`)
     on update cascade
 );