1 Database Setup

This topic describes about the database setup for SMS services.

The user need to setup database related configuration for SMS Installation. It is recommended to create separate schema for SMS database setup.

Prerequisites

Before proceeding with setup, make sure that the schemas are created and pre-installation setup is done.

The pre-installation setup includes the configuration of database. After creating the schema for each of the required microservices, DDLs, and INCs of each micro-service to be compiled in the respective schemas. The DDLs and INCs ensures the creation of tables and availability of static data required for the execution of services. These are compiled automatically using flyway.

Database Setup

The required service and schema to setup database for SMS are as follows:

Table 1-1 Service and Schema

Service Name	Schema Required
SMS-CORE-SERVICE	Yes