This page documents the use of admin tools to create or update a DB schema.

This admin tool is used to create the schema (for a new installation) or update it (for a deployment of updated model objects).



This tool is used to create an initial DB schema, or update the schema upon code changes to add or change existing fields.  

NOTE: fields that get removed are not handled by this process nor are declarations of new indexes nor statements in the "import.sql" file. Changes in these resources will require explicit creation in a database that already is instantiated with data.  Additionally, addition of a non-nullable field without a default to a table containing rows already can be problematic.  The typical strategy or adding a non nullable field is this:

Following are some details about the implementation of this tool:

Mojo: UpdateDbMojo.java (in admin/mojo/src/main/resources/java/org/ihtsdo/otf/mapping/mojo)

Project: admin/updatedb

Configuration Parameters


Sample command line call of the admin tool to create a DB:

% cd ~/code/admin/updatedb
% mvn install -PUpdatedb -Drun.config=~/config/config.properties -Dhibernate.hbm2ddl.auto=create

Sample command line call of the admin tool to simply update an existing DB:

% cd ~/code/admin/updatedb
% mvn install -PUpdatedb -Drun.config=/home/ihtsdo/config/config.properties -Dhibernate.hbm2ddl.auto=update 


Sample Eclipse run configuration: