...

Administration

Database Setup

Note: The current schema is out of date; updated instructions will be available soon.

Download the schema from the CI server

...

1. Download and untar/unzip the Flyway Command Line Tool
   1. The Ingest Server currently uses Flyway 45.2.04; if possible the binary for that version should be used
2. Edit the conf/flyway.conf
   
   1. some properties follow the same pattern as our application properties (connecting to the database)

   2. specify the version which you are creating the baseline (using the MAJOR.MINOR number of the ingest server version)

      Code Block
      language bash title Flyway Configuration Example
      # # Copyright 2010-2015 Axel Fontaine # ... # Jdbc url to use to connect to the database flyway.url=jdbc:postgresql://localhost/ingest # Fully qualified classname of the jdbc driver (autodetected by default based on flyway.url) # flyway.driver= # User to use to connect to the database (default: <<null>>) flyway.user=chron # Password to use to connect to the database (default: <<null>>) flyway.password=my-postgresql-password ... flyway.baselineVersion=3.0

      
      

3. Use the flyway bash script to update the database

   Code Block
   language bash title Flyway Baseline Migration
   $ ./flyway baseline

   
   

...