aboutsummaryrefslogtreecommitdiffstats
path: root/sql/fileshare.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/fileshare.sql')
-rw-r--r--sql/fileshare.sql21
1 files changed, 12 insertions, 9 deletions
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
+ */