Prevent Update Table Change
Prevent WP from reseting db schema changes
by John A. Huebner II · github.com/hube2/wp-update-prevent-db-changes
Install
No release zip yet. The repository archive installs, but the folder name will carry the branch suffix and updates will not flow:
wp plugin install https://github.com/hube2/wp-update-prevent-db-changes/archive/refs/heads/master.zipReadme
WP Update Prevent DB Changes
Use this to manage db schema changes at your own risk! Before applying DB changes, always back up your database!
Prevent WP from reseting db schema changes
Have you had to modify one of the standard WordPress DB columns?
Like for example changing option_name from varchar(64) to varchar(255) so that you can use a plugin that may create long option_name values?
Then you updated WP to a new version only to find that your site has crahsed and burned becuase the column was reset to what WP thinks it should be?
Add this file to the mu-plugins (wp-content/mu-plugins) folder on your site and modify the dbdelta_queries method to change the default WP DB schema so that your changes are not reset to the WP defaults.