L10n.ws logo L10n.ws

Install Database

L10n.ws Portal uses PostgreSQL database.

After installation first you need to create user owner

DO
$body$
BEGIN
  IF NOT EXISTS(
      SELECT *
      FROM pg_catalog.pg_user
      WHERE usename = 'l10n-portal')
  THEN

    CREATE ROLE "l10n-portal" LOGIN PASSWORD '1';
  END IF;
END
$body$;

Do not forget to change default password.

Next create database with created owner

CREATE DATABASE "l10n-portal" OWNER "l10n-portal";

Database Versioning

For database versioning we are using Liquibase.

Run liquibase changeset scripts from l10n-app

gradlew :liquibase:update -PrunList=portal

Updating database version

For existing database

gradlew :liquibase:changelogSync