diff --git a/util/db-mysql.sql b/util/db-mysql.sql index eff61ca..c5185fe 100644 --- a/util/db-mysql.sql +++ b/util/db-mysql.sql @@ -244,7 +244,8 @@ create table if not exists `folder` ( `id` int not null auto_increment, `parent_id` int default 0, - `name` char(64) not null unique, + `name` char(64) not null, + unique(`parent_id`, `name`), primary key (`id`) ) Engine=InnoDB;