diff options
| -rw-r--r-- | db/init.sql | 7 |
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 ( |