Liquibase setup
Liquibase scripts are used to create all tables and insert necessary data to the database. To run those scripts you have to have Maven installed.
Create database table and data
- Download database module from GitHub. Select the branch and tag you want to download. Click button Clone or download and select Download Zip, see picture.
Database module with Liquibase scripts | Documentation and links |
|---|---|
UVMS-AssetModule-DB | Asset |
UVMS-AuditModule-DB | Audit |
UVMS-ConfigModule-DB | Config |
UVMS-ExchangeModule-DB | Exchange |
UVMS-MobileterminalModule-DB | Mobile Terminal |
UVMS-MovementModule-DB | Movement |
UVMS-RulesModule-DB | Rules |
UVMS-SpatialModule | Spatial |
UVMS-ReportingModule | Reporting |
UVMS-UsmModule | User |
- To generate tables and test data for e.g. Asset module, start command console and navigate to where you have the Liquibase script.
E.g. <Your path to Liquibase scripts>\UVMS-AssetModule-DB\LIQUIBASE - Execute following command.
mvn liquibase:update -P postgres -Ddb.url=jdbc:postgresql://<URL to your database>:5432/uvms - Startup pgAdminIII, navigate to the database uvms and investigate the tables and data is created. See picture below
- Repeat step 2 for the remaining modules.