1
Hi, I am currently working on a custom module and was hoping some of the more experienced XOOPS module developers could let me know how they handle version control.
Everytime I'm making changes to my module's database tables I end up uninstalling my module, uploading the new .sql and xoops_version.php and reinstalling it.
Could someone explain how to use phpmyadmin to create a 'upgrade' sql file that just creates new tables, changes fields ect, and how to add this into my xoops_version.php file so I can make upgrades to database structure without having to uninstall my module?
I'm very familiar with exporting structure and/or data from phpmyadmin. Should I be keeping track of all sql statements I make updating my database in a txt file somewhere? How are other's currently handling similar changes?
Your wisdom is appreciated.