Versions Compared

Old Version 7

changes.mady.by.user Petr Jůza

Saved on

compared with

New Version 8

changes.mady.by.user Petr Jůza

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

In OpenHub, these scripts are added for both currently supported DB engines - PostgreSQL & H2. By default, DB migration using flyway is enabled. If developer checks out the project, schema is created during application startup by Flyway. If any changes are introduced in form of new SQL script, flyway will apply them - scripts can be DDL or data migrations (if they make sense).


Warning

Prerequisite for successfull successful flyway run with PostgreSQL:

  • there is user/role (e.g. openhubusr)
  • there is database (e.g. openhubdb)
  • there is schema openhub

See db/migration/postgresql/V1_0_0__schema_init.sql init script for more details.

If you need to use not concurrent scheduled jobs with Quartz then you must create database structure manually from GitHub scripts.

...