From 0abc4c6de856c5c1d678d82bb464758c934fae0c Mon Sep 17 00:00:00 2001 From: adam Date: Sat, 13 Feb 2021 15:40:53 +0200 Subject: triggers are kinda ok --- sql/fileshare.sql | 21 ++++++++++++--------- 1 file changed, 12 insertions(+), 9 deletions(-) (limited to 'sql') diff --git a/sql/fileshare.sql b/sql/fileshare.sql index 4eb60f7..b0c28a5 100644 --- a/sql/fileshare.sql +++ b/sql/fileshare.sql @@ -54,16 +54,19 @@ create table trash ( ); -/* 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 - ); + for each row + insert into trash + select nodes.node_id + from nodes + where nodes.node_id not in (select node_id from node_links) and nodes.node_id=old.node_id; -*/ + /* +create trigger delete_links + after delete + on nodes + for each row + delete from + */ -- cgit v1.2.3