diff options
| author | adam <adam@> | 2021-02-14 11:58:35 +0200 |
|---|---|---|
| committer | adam <adam@> | 2021-02-14 11:58:35 +0200 |
| commit | 66040941492d590fd7a93d6c85f5f095335355e8 (patch) | |
| tree | a06b764d773092926c1231ad07ae271bc5d937f9 /sql | |
| parent | 47a01771243568017a5aedfb948a7fb2bf9543f8 (diff) | |
| download | fileup-66040941492d590fd7a93d6c85f5f095335355e8.tar.gz | |
trash
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/fileshare.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/fileshare.sql b/sql/fileshare.sql index 1a0672a..b524a8b 100644 --- a/sql/fileshare.sql +++ b/sql/fileshare.sql @@ -62,6 +62,7 @@ create table shared_nodes ( node_id int not null, passcode varchar(100) default "", code varchar(100) default "", + is_public boolean default false, foreign key (node_id) references nodes(node_id) on delete cascade ); @@ -108,3 +109,5 @@ create trigger delete_links for each row delete from node_links where directory_id=old.node_id; + + |