~jan0sch/smederee

Showing details for patch bf5ca6f7245f506d957ba6143b46c421f5f7602d.
2024-02-02 (Fri), 8:52 AM - Jens Grassel - bf5ca6f7245f506d957ba6143b46c421f5f7602d

TAG v0.11.0

This release contains BREAKING CHANGES in the database structure!

To mitigate the effect create a backup of your database first. Then follow
these instructions:

1. stop the service
2. dump the data of your database only (`pg_dump -a dbname > data.sql`)
3. !!! Remove the `flyway_schema_history` tables from the dump !!!
4. drop the database and create a new one with the same name
5. apply the update
6. start the service
7. stop the service after the migrations have been applied
8. restore the data (`cat data.sql | psql dbname`)

Please note that you might need additional parameters for `pg_dump` and `psql`
depending on your database configuration like username, password or prepended
`sudo` command.

Changed
-------

- **BREAKING CHANGE** remove unnecessary quoting in sql
Summary of changes