I develop a WordPress plugin, which has several database tables of its own. The plugin creates these tables when activated, and removes them when deleted/uninstalled.
I have to implement an update process of the plugin which updates plugin's code as well as tables structure. The simplest case would be to add a new column to one of the tables. The more complex case would be to create a new tables structure and update the content accordingly.
How would you recommend to solve this problem? Is there any built-in WordPress functions that may help?