database upgrade.sql scripts missing about app HOT 5 CLOSED

Hi AndreZeug,

There is a file inside this zip, \database_schema\upgrades\2.8 \ schema.sql with all you need to upgrade from 2.7

from app.

I just check the zip files and the repo, and you are right, in the repo there isn't a upgrade.sql, but the file is present the zip's, that's probably due to the build process that was used but I haven't investigated that yet. In the meantime, you can use a previous release, or the latest maintenance release https://github.com/effgarces/BookedScheduler/releases/tag/2.8.5.1.
I'm due to release another one, hopefully soon, but with all that's going in the world, my schedule keeps getting messed up.

from app.

Great, thanks a lot!
upgrade.sql from https://github.com/effgarces/BookedScheduler/releases/tag/2.8.5.1. should work for me.
Thanks for taking care of BookedScheduler!

@treborin is it correct that one can upgrade the database with schema.sql? Do you have a documentation about that?

from app.

From what I quickly seen the upgrade.sql file is simply a merged version of clean.sql, data.sql and schema.sql, so you should be able to upgrade using all of the files in sequence.

from app.

That's right, effgarces. I have checked it manually from 2.7.6 up to 2.8.5, and the the only differences i see are what sql files try to update. Using upgrade.sql against your database (2.7.6), should upgrade nicely up to 2.8.5.

from app.