# Set up external database

# This step is optional

If you want to use the built-in database, you don't need to do anything else.

Once the plugin starts, new files should have been created in the plugins/CaseOpening folder. (The plugin will still not start completely and the /case command will not be available yet).

Now you have to prepare a SQL database (e.g. MySQL, MariaDB, etc.). There you have to create a database (if you don't have one yet) and write down access data for a user who has access to the database. If you have all this, you can open the file sql.yml. There you have to enter the access data (below you see the default values):

type: mariadb
host: localhost
port: '3306'
database: caseopening
casePrefix: ''
username: root
password: ''

Name	Standardwert	Benötigt	Beschreibung
`type`	`mariadb`	yes	Please enter the database type here. Currently `mariadb`, `mysql` and `h2` are supported
`host`	`localhost`	yes	Please enter here the hostname of the database server (or set the value to `localhost` if the database server is located on the same server).
`port`	`3306`	yes	Please enter the port of the database server here
`database`	`caseopening`	yes	Please enter the database name here
`casePrefix`		no	If you want the tables to have a prefix, you can enter it here
`username`	`root`	yes	Please enter the username of the database server here
`password`		yes	Please enter the password of the database server here

When you have entered all values, please restart the server. If everything has been entered correctly, the plugin should now start and the /case command should be available.