Versions Compared

Key

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

...

Warning

Prerequisite for 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.

There are also tables and functions for archivation of "production" tables. Archivation tables have prefix "archive_", e.g. archive_external_call

Function for archivation is called archive_records(integer) where input is number of months after that the message will be archived.


Enabling/disabling flyway in application.properties

...