Download the PHP package oddnoc/silverstripe-artefactcleaner without Composer
On this page you can find all versions of the php package oddnoc/silverstripe-artefactcleaner. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download oddnoc/silverstripe-artefactcleaner
More information about oddnoc/silverstripe-artefactcleaner
Files in oddnoc/silverstripe-artefactcleaner
Package silverstripe-artefactcleaner
Short Description Find and optionally delete unused tables, columns and indexes in a SilverStripe database
License MIT
Homepage https://github.com/oddnoc/silverstripe-artefactcleaner
Informations about the package silverstripe-artefactcleaner
Silverstripe Database Artefact Cleaner
The Silverstripe Database Artefact Cleaner identifies and offers the option to remove unused tables, columns, and indexes in a Silverstripe database.
Over time, as the database schema evolves, Silverstripe's schema management tools may leave behind obsolete tables, columns, and indexes. This package assists developers by displaying these unnecessary artefacts and provides the option to delete them, ensuring a cleaner and optimized database.
Installation
To install the Artefact Cleaner, use the following composer command:
Usage
You can run the cleaner task using either the command line or directly through the browser. For MariaDB users (version 10+), the ifexists=1
option can be added to prevent errors if the targeted column or index doesn't exist during the dropping=1
operation.
Command Line
Browser
https://example.org/dev/tasks/ArtefactCleanTask
https://example.org/dev/tasks/ArtefactCleanTask?ifexists=1
https://example.org/dev/tasks/ArtefactCleanTask?dropping=1
https://example.org/dev/tasks/ArtefactCleanTask?dropping=1&ifexists=1
Acknowledgements
This package was inspired by silverstripe-dbplumber by smindel.
Version
4.1.0