In Piwik 3.0.0-b1 we introduced a better way to define plugin updates by using migrations to define MySQL schema updates. It would be nice to have these available as well in Plugin::install and Plugin::uninstall. Otherwise we still need to write plain SQL there see https://github.com/piwik/piwik/pull/10003/files where we can see plain SQL and usage of the migration API.

I first thought about removing install completely and only using updates in the future but it is actually good to keep install:

• There would be still an uninstall needed in the plugin anyway so it's kind of logical to have an install
• Plugin installation will be faster as we won't have to reply all existing updates but can directly install the plugin. Imagine it is a plugin that adds new columns to log_visit and changes it's type multiple times in a couple of its updates. Instead we can directly install the correct column with the correct type.
• It is easy to get an overview of what the plugin's schema should look like. By looking over many update files it is hard to picture what the actual schema should look like.