CREATE TRIGGER "MailAccountAfterDelete" AFTER DELETE
ON "MailAccounts"
BEGIN
 DECLARE MailFoldersCursor SENSITIVE CURSOR FOR MailFoldersStatement;

 PREPARE MailFoldersStatement FROM 'SELECT GUID FROM MailFolders WHERE MailFolders.AccountID = ?';
 OPEN MailFoldersCursor USING OLDROW.GUID;
 
 START TRANSACTION ON TABLES MailFolders;
 BEGIN
   WHILE NOT EOF(MailFoldersCursor) DO DELETE FROM MailFoldersCursor;
   END WHILE;
 
   COMMIT;
 
   EXCEPTION
     ROLLBACK;
 END;

END