Kratos Database Schema

[zkrzyzanowski]

Hi! I can't find anything in the documentation regarding database schema needed to run Kratos. For example, when I stand it up for the first time, it throws an error

021-01-15 10:59:19.318 EST [58702] ERROR:  relation "courier_messages" does not exist at character 216
2021-01-15 10:59:19.318 EST [58702] STATEMENT:  SELECT courier_messages.body, courier_messages.created_at, courier_messages.id, courier_messages.recipient, courier_messages.status, courier_messages.subject, courier_messages.type, courier_messages.updated_at FROM courier_messages AS courier_messages WHERE status != $1 ORDER BY created_at ASC LIMIT 10

or initiating self service registration from the browser:

{"error":{"code":500,"status":"Internal Server Error","message":"ERROR: relation \"selfservice_errors\" does not exist (SQLSTATE 42P01)"}}

Obviously for courier_messages I need the columns its trying to select there, but are there any details on data types or full schema for all tables Kratos needs to function?

Thanks!

[zkrzyzanowski]

Answered this myself. For anyone looking for this later:

kratos migrate sql -c kratos.json -e

https://github.com/ory/kratos/blob/master/docs/docs/cli/kratos-migrate-sql.md

Thanks to those working on this!