diff options
Diffstat (limited to 'INIT_DATABASE.sql')
-rw-r--r-- | INIT_DATABASE.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/INIT_DATABASE.sql b/INIT_DATABASE.sql index d96a4b0..2d772e4 100644 --- a/INIT_DATABASE.sql +++ b/INIT_DATABASE.sql @@ -65,6 +65,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 ); @@ -111,3 +112,5 @@ create trigger delete_links for each row delete from node_links where directory_id=old.node_id; + + |