add subcategories to database schema

1 files changed, 6 insertions, 1 deletions

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 (