--- a/OrthancServer/Upgrade4To5.sql	Mon Sep 22 13:57:04 2014 +0200
+++ b/OrthancServer/Upgrade4To5.sql	Mon Sep 22 14:11:37 2014 +0200
@@ -42,6 +42,7 @@
 -- Upgrade the "ResourceDeleted" trigger
 
 DROP TRIGGER ResourceDeleted;
+DROP TRIGGER ResourceDeletedParentCleaning;
 
 CREATE TRIGGER ResourceDeleted
 AFTER DELETE ON Resources
@@ -51,6 +52,13 @@
     FROM Resources AS parent WHERE internalId = old.parentId;
 END;
 
+CREATE TRIGGER ResourceDeletedParentCleaning
+AFTER DELETE ON Resources
+FOR EACH ROW WHEN (SELECT COUNT(*) FROM Resources WHERE parentId = old.parentId) = 0
+BEGIN
+  DELETE FROM Resources WHERE internalId = old.parentId;
+END;
+
 
 -- Change the database version
 -- The "1" corresponds to the "GlobalProperty_DatabaseSchemaVersion" enumeration