DB structure updates

Location path

Path in the build directory Logical role Application

/db_update/domain_master/*.sql

mdc

Master domain entity DB

/db_update/domain/*.sql

mdc

Working domain and template entity DBs

Overview

DB update requests. Each DB contains a settings table with the version of the last applied update file.

Each update file has a name starting with a number representing the date in YYMMDD_*.sql format. Every time the corresponding role reloads, update files representing later versions relative to the current DB version are applied. They are applied in increasing update version order.

Updates for the working domain entity DB are applied simultaneously to all working domain DBs and to the template DB from which DBs for newly created domains are deployed.

See also