Could you tell me if I should let them there ? Or if I should erase them ?
This is just to optimize security and space disk on my host.
Thanks in advance for any advice and ... let me wish you all the best
So you don't want to remove any SQL files that have uninstall in the name as these are needed if you ever need to uninstall the extension otherwise the system won't know which database tables to remove.
In theory after the extension is installed you could remove the install SQL file but I don't think this will increase security because if your file/folder permissions are set correctly there is no direct access to this file.
In regards to the Update files they allow changes to be made to the database when upgrading versions of an extension. Basically Joomla's keeps track of schema versions for itself and components in the #__schemas table. It lists the extension_id and with the version_id and uses that to determine what updates to run.
So there was a bug that if you didn't ever have/use an update file then there wasn't a entry in the #__schemas table to compare against so future updates weren't run. I have run some tests and this bug seems to be fixed but I will have run more tests to make sure but the bottom line is once you have installed the latest version they aren't needed unless you choose to downgrade and then upgrade versions.
I don't recommend removing any of these files but you could and then before uninstalling etc you could install a copy over the top of your current one before attempting to uninstall for example and it should work as expected
Let me know if you have follow up questions.
Hi! I'm Steve the founder and head developer of CoalaWeb design studios. I'm an avid supporter of open source projects and the GPL license.
Hi Steven, thank you for this complete and efficient answer
I ask this question because I do not handle very well that part of Joomla. Now that you gave me your lights about this, I won't touch anything.
Thanks again, and have a ... happy new year