diff options
| author | lonkaars <loek@pipeframe.xyz> | 2023-05-08 17:08:54 +0200 |
|---|---|---|
| committer | lonkaars <loek@pipeframe.xyz> | 2023-05-08 17:08:54 +0200 |
| commit | cda96d31939c7ea727c114b162f43bb4d18314a2 (patch) | |
| tree | aa1aac2c746c5a1452b11af3f187d499b5a9ce5f /db/init.sql | |
| parent | 08d6281d872a8d2a496462f131cbdc860432acc0 (diff) | |
more website
Diffstat (limited to 'db/init.sql')
| -rw-r--r-- | db/init.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/db/init.sql b/db/init.sql index d84d4e9..a9fc25b 100644 --- a/db/init.sql +++ b/db/init.sql @@ -15,7 +15,8 @@ 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_path` varchar(255) not null default "img/placeholder.png", + `image` boolean not null default false, + `description` mediumtext null default null, `category` int not null, primary key (`ID`), constraint `product_category_fk` |