Added test for Issue 57

1 files changed, 13 insertions, 0 deletions

diff --git a/tests/files/begintag_2.sql b/tests/files/begintag_2.sql
new file mode 100644
index 0000000..0de26d6
--- /dev/null
+++ b/tests/files/begintag_2.sql
@@ -0,0 +1,13 @@
+CREATE TRIGGER IF NOT EXISTS remove_if_it_was_the_last_file_link
+-- Delete the direntry when is removed it's last static link
+    AFTER DELETE ON links
+    WHEN NOT EXISTS
+    (
+        SELECT * FROM links
+        WHERE child_entry = OLD.child_entry
+        LIMIT 1
+    )
+BEGIN
+    DELETE FROM dir_entries
+    WHERE dir_entries.inode = OLD.child_entry;
+END;
\ No newline at end of file