From 0c3d535a341dcefd702982715f6d20275a0f512d Mon Sep 17 00:00:00 2001
From: adam <adam@>
Date: Fri, 12 Feb 2021 16:40:24 +0200
Subject: stuff

---
 sql/fileshare.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'sql')

diff --git a/sql/fileshare.sql b/sql/fileshare.sql
index e3d9520..24e6dd1 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',
-	note varchar(200) not null default "",
 	code varchar(100) not null default "error",
 	primary key (node_id)
 );
@@ -43,6 +42,7 @@ create table node_links (
 	directory_id int not null,
 	node_id int not null,
 	name varchar(100) not null default 'no name',
+	note varchar(200) not null default "",
 	check (directory_id != node_id), 
 	foreign key (directory_id) references nodes(node_id),
 	foreign key (node_id) references nodes(node_id)
-- 
cgit v1.2.3