From 66040941492d590fd7a93d6c85f5f095335355e8 Mon Sep 17 00:00:00 2001 From: adam Date: Sun, 14 Feb 2021 11:58:35 +0200 Subject: trash --- sql/fileshare.sql | 3 +++ 1 file changed, 3 insertions(+) (limited to 'sql') 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; + + -- cgit v1.2.3