Database setup

In order to create the database structure required to support the API, follow these steps:

1. Create the database. On psql:

   create database dataportal_auth

2. Grant user permission to your database user. On psql:

   grant all privileges on database dataportal_auth to user {YOUR_USER}

3. Run in a command line:

wget https://raw.githubusercontent.com/sibbr/api/dev/src/main/resources/database/schema.sql
sudo su postgres
psql -d dataportal_auth -W -f schema.sql
exit

**Note: you can use any database name you want. The examples used dataportal_auth, but you can use other names, as long as you remember to apply the same name in all steps of the process.