OCMOD

I'm playing around with OCMOD, without any experience of vQmod.

I've managed to create a zip file with the right contents, make changes (virtual) to a core file, and alter a database table (install.sql). Is there any way for me to remove the change to the database on removing the mod?

Any help appreciated

There is no way to revert DB changes.

After testing, it seems the install() and uninstall() methods still work in the extension admin controller

So my question is why do we need an install.sql file ?

Every modification isn't going to be an extension module. If you have an OCMod based solution the only other option for DB changes would be dumping an install method in a model file.

Ahh I see. So this is an additiononal function for those "non extension/module" modifications to allow them to run install sql commands in addition to the current controller methods.

In all honesty I don't know what the official thinking behind it is. (For something that's the bread and butter of OpenCart there hasn't been much communication about modding.) SQL handling is a regularly requested feature for vQmod - I've even seen devs hack it in - so I'm sure that's how it will get used. I know I have a few mods it would be useful for.

Why not just add support for an uninstall.sql file?