Configuring Databases for UK

Once you have successfully prepared the environment for the deployment, you can configure the databases.

1. Create the following databases:

   1. 1. openbank_am_configdb   

      2. openbank_apimgt_statsdb

      3. openbank_apimgtdb

      4. openbank_openbankingdb

      5. openbank_govdb

      6. openbank_iskm_configdb       

      7. openbank_userdb

2. Update the INPUTS field size in AM_APPLICATION_REGISTRATION table in the sql file according to your database. The sql scripts are available in the <WSO2_OB_IAM_HOME>/dbscripts/apimgt directory. (mysql.sql mssql.sql, oracle.sql)

   If you are using Microsoft SQL, do the following changes, in addition to the step above.

   Update the IDN_OIDC_REQ_OBJECT_REFERENCE table in <WSO2_OB_IAM_HOME>/dbscripts/apimgt/mssql.sql file, by replacing the following lines:

   1. Replace FOREIGN KEY (CONSUMER_KEY_ID) REFERENCES IDN_OAUTH_CONSUMER_APPS(ID) ON DELETE CASCADE with

      FOREIGN KEY (CONSUMER_KEY_ID) REFERENCES IDN_OAUTH_CONSUMER_APPS(ID)

   2. Replace FOREIGN KEY (TOKEN_ID) REFERENCES IDN_OAUTH2_ACCESS_TOKEN(TOKEN_ID) with

      FOREIGN KEY (TOKEN_ID) REFERENCES IDN_OAUTH2_ACCESS_TOKEN(TOKEN_ID) ON DELETE CASCADE

3. Update the VALUE field size in SP_METADATA table in the sql file according to your database. The sql scripts are available in the <WSO2_OB_IAM_HOME>/dbscripts/apimgt directory. (mysql.sql mssql.sql, oracle.sql)
4. To create the database schema, execute the following scripts against the given database: