From 847347fb5511f6c526e41e0e5963e6d4f3882e58 Mon Sep 17 00:00:00 2001 From: lonkaars Date: Mon, 8 May 2023 13:20:14 +0200 Subject: WIP show products in database --- db/init.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'db') diff --git a/db/init.sql b/db/init.sql index c842e52..872d456 100644 --- a/db/init.sql +++ b/db/init.sql @@ -10,7 +10,7 @@ create table if not exists webs.product ( `ID` int not null auto_increment, `name` varchar(255) not null, `price` decimal(5, 2) not null, - `image` mediumblob null default null, + `image_path` varchar(255) not null default "img/placeholder.png", `category` int not null, primary key (`ID`), constraint `product_category_fk` -- cgit v1.2.3