From 08d6281d872a8d2a496462f131cbdc860432acc0 Mon Sep 17 00:00:00 2001 From: lonkaars Date: Mon, 8 May 2023 13:23:34 +0200 Subject: add subcategories to database schema --- db/init.sql | 7 ++++++- 1 file changed, 6 insertions(+), 1 deletion(-) diff --git a/db/init.sql b/db/init.sql index 872d456..d84d4e9 100644 --- a/db/init.sql +++ b/db/init.sql @@ -3,7 +3,12 @@ create schema if not exists webs; create table if not exists webs.category ( `ID` int not null auto_increment, `name` varchar(45) not null, - primary key (`ID`) + `parent` int null default null, + primary key (`ID`), + constraint `category_parent_fk` + foreign key (`parent`) + references webs.category (`ID`) + on update cascade ); create table if not exists webs.product ( -- cgit v1.2.3