diff options
| author | lonkaars <loek@pipeframe.xyz> | 2023-05-08 13:20:14 +0200 |
|---|---|---|
| committer | lonkaars <loek@pipeframe.xyz> | 2023-05-08 13:20:14 +0200 |
| commit | 847347fb5511f6c526e41e0e5963e6d4f3882e58 (patch) | |
| tree | 7559f1dcb2b55871b17eed1d7081b10d97026108 /db | |
| parent | 14997bb700d5bc30d69a48294ae26a7e566939c5 (diff) | |
WIP show products in database
Diffstat (limited to 'db')
| -rw-r--r-- | db/init.sql | 2 |
1 files changed, 1 insertions, 1 deletions
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` |