# How to EDIT the central-ledger-schema-DBeaver.erd file

This is a basic guide on how to successfully view/update the central-ledger-schema-DBeaver.erd file.

## Prerequisites

* Download and install the DBeaver Community DB Manager
* The Mojaloop Central-Ledger MySQL Database needs to be up and running, and connectable by the DBeaver
* You'll also need a text editor

## Steps to follow

* Create a new db connection in DBeaver under Database Navigator tab for the MySQL instance running.
* Under the Projects tab right click and create a New ER Diagram.
* Give the diagram a name and select central-ledger db in the wizard.
* Copy the `central-ledger-schema-DBeaver.erd` file from the documentation module to `DBeaverData/workspace/General/Diagrams` in your DBeaver storage location
* Navigate to the newly created erd file using a text editor, search for `data-source id` and copy its value which looks like `mysql5-171ea991174-1218b6e1bf273693`.
* Navigate with a text editor to the `central-ledger-schema-DBeaver.erd` file in the ER Diagrams directory and replace its `data-source id` value with the one copied from the newly created erd file.
* The `central-ledger-schema-DBeaver.erd` should now show the tables as per the `central-ledger-schema.png`