I am looking to upgrade from our current version 4.1.0 (which we have modified quite a bit to fit our practice and workflow) to version 5.0.0 and the first step I was looking at was “Dual Upgrade of OpenEMR and XAMPP in Windows” which has a step to perform a mysqldump of the existing db. When I did the mysqldump and reviewed the dumpfile.sql file that was created, it has DROP TABLE commands to delete the table if it exists. This in my mind would delete the 5.0.0 version of the table then recreate the 4.1.0 version of the table in its place. How can this be the correct action if a change was made in the 5.0.0 version requiring an additional field or a change in field type? I am not saying there was but it really sounds like this dumpfile would downgrade the database.
Thoughts?