Creating Databases

It is required to create a System and Application database. Optionally, a Transaction database can be created to log all transactions made in an application.

• A system database is required for the AMT Control Center to function.
• An application database is required for an AMT application to function.
• A transaction logging database can be created to log transactions made in an AMT application.

Suggested database naming conventions:

Create a System database.

1. Create a database User.
   1. Ensure that the Can Login setting is enabled.
2. Create a Database for the AMT system and add the user as owner.
   1. Set the database encoding to UTF-8.
3. Add a Schema to the database with the exact same name as the database itself, and the previously created user as owner.

Before newly created databases can be used, the databases need to be defined. Define the System database in the cc-config.yaml file for the Control Center. Thereafter, the database must be reorganized.