diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/fileshare.sql | 21 |
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 + */ |