diff options
| author | Alex Vitkov <alexvitkov98@gmail.com> | 2021-02-12 14:07:48 +0200 |
|---|---|---|
| committer | Alex Vitkov <alexvitkov98@gmail.com> | 2021-02-12 14:07:48 +0200 |
| commit | 10d7e23ca54ca0003e548922d1202f39c841a0db (patch) | |
| tree | 1b51e10c4f919034c7ec32395770e5c6a6ce3931 /sql | |
| parent | 1c5476e68cc0d43b534521ea3e647bbe0d7e86df (diff) | |
| parent | 76970dca67894917bdbc4213f4c5df60d0c8dec3 (diff) | |
| download | fileup-10d7e23ca54ca0003e548922d1202f39c841a0db.tar.gz | |
Merge branch 'master' of https://github.com/alexvitkov/india
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/fileshare.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/fileshare.sql b/sql/fileshare.sql index 0742538..e3d9520 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) |