diff options
| author | adam <adam@> | 2021-02-12 16:40:24 +0200 |
|---|---|---|
| committer | adam <adam@> | 2021-02-12 16:40:24 +0200 |
| commit | 0c3d535a341dcefd702982715f6d20275a0f512d (patch) | |
| tree | bdc6249da1f2d6d4a7975d192537511017df9354 /sql | |
| parent | 75640897d7ae44f10b9dde091d4b8dcba8e23776 (diff) | |
| download | fileup-0c3d535a341dcefd702982715f6d20275a0f512d.tar.gz | |
stuff
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/fileshare.sql | 2 |
1 files changed, 1 insertions, 1 deletions
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) |