sql restructure

1 files changed, 2 insertions, 2 deletions

diff --git a/sql/fileshare.sql b/sql/fileshare.sql
index b0f1696..b3c9c6e 100644
--- a/sql/fileshare.sql
+++ b/sql/fileshare.sql
@@ -12,7 +12,6 @@ create table nodes (
 	is_directory boolean default false,
 	relative_path varchar(500) not null,
 	type varchar(20) not null default 'data',
-	name varchar(100) not null default 'no name',
 	note varchar(200) not null default "",
 	code varchar(100) not null default "error",
 	primary key (node_id)
@@ -39,10 +38,11 @@ create table node_access (
 	foreign key (node_id) references nodes(node_id),
 	foreign key (user_id) references users(user_id)
 );
-
+/*we can name a node in many different ways */
 create table node_links (
 	directory_id int not null,
 	node_id int not null,
+	name varchar(100) not null default 'no name',
 	check (directory_id != node_id), 
 	foreign key (directory_id) references nodes(node_id),
 	foreign key (node_id) references nodes(node_id)