diff options
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; + + |