Database Manifest - adamconnelly/dbversion GitHub Wiki

Database Manifest

Each database archive is made up of a number of database manifest files. A manifest file describes the tasks that need to be executed to install a particular version. An example manifest file is as follows:

<database version="1.0">
  <script file="schema/ddl.sql"/>
  <script file="data/authors.sql"/>
  <script file="data/books.sql"/>
  <script file="data/users.sql"/>
</database>

The manifest file shown above will install version 1.0 of the database, and tells dbversion to run four scripts to install that version. Each file is relative to the manifest file, so if your manifest file is stored in C:\Users\myuser\archives\test-archive\1.0, your archive would have the following directory structure:

test-archive/
└── 1.0
    ├── data
    │   ├── authors.sql
    │   ├── books.sql
    │   └── users.sql
    ├── database.xml
    └── schema
        └── ddl.sql

The tasks are run in the order they are defined in the manifest, so you should make sure that your scripts run in the order you have specified them.

⚠️ **GitHub.com Fallback** ⚠️