From a346874ea858d43ee2336e315dba056fb81b6439 Mon Sep 17 00:00:00 2001 From: adam Date: Sat, 13 Feb 2021 14:51:35 +0200 Subject: nothing done --- sql/fileshare.sql | 21 ++++++++++++++++++++- 1 file changed, 20 insertions(+), 1 deletion(-) (limited to 'sql') diff --git a/sql/fileshare.sql b/sql/fileshare.sql index 8e69881..4eb60f7 100644 --- a/sql/fileshare.sql +++ b/sql/fileshare.sql @@ -2,6 +2,8 @@ drop table if exists node_access; drop table if exists users; drop table if exists node_links; +drop table if exists trash; +drop trigger if exists delete_on_zero_links; drop table if exists nodes; @@ -42,9 +44,26 @@ create table node_links ( node_id int not null, name varchar(100) not null default 'no name', note varchar(200) not null default "", - check (directory_id != node_id), foreign key (directory_id) references nodes(node_id) on delete cascade, foreign key (node_id) references nodes(node_id) on delete cascade ); +create table trash ( + node_id int not null, + foreign key (node_id) references nodes(node_id) on delete cascade +); + +/* +create trigger delete_on_zero_links + after delete + on node_links + for each row + insert into trash(node_id) + select + if(old.node_id not in (select node_id from node_links), + old.node_id, + select node_id from nodes where 1=0 + ); + +*/ -- cgit v1.2.3