This is a sample configuration for a mySQL Tracker Store:
tracker_store:
type: SQL
dialect: "mysql"
url: "localhost"
db: "rasa_tracker_store"
username: "rasa"
password: "rasa"
This is how the database looks on phpMyAdmin:
This had all the information that you required. If you really need to modify the looks, you can create:
- A view
- A script that pulls from the database, rearranges the info, and uploads it to another database
- A frontend application that shows the info as you required without modifying the database (preferable)
If you don’t know how to set up a MySQL database with phpMyAdmin in the first place, I suggest using Wamp on Windows, and a this and this tutorial for Ubuntu.