Lukas Schätzle Tummerhore
Tummerhore
/ directus-cleaning.sql
Last active
January 18, 2024 13:16
Directus (MySQL): Remove old activities, revisions, flow logs, notifications
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| DISCLAIMER: Use at your own risk! | |
| Tested with Directus 9.23.4 and MySQL | |
| This will delete all flow execution logs, revisions and acitivites which are older | |
| than the specified MinTimestamp and are not in the top <specified MinItems> latest | |
| items. Activities related to saved revisions / flow logs are also saved even when | |
| they normally would have been deleted. | |
| Archived notifiactions are deleted when the creation of the notifaction is older |