Ghost Database issue with DigitalOcean Database

Hello Ghost team!
This issue is pretty similar to: Unable to start ghost in docker with mysql on digitalocean

We’re using Digital Ocean’s managed DB MySQL8 for Ghost.
They require all tables having PKs. Two tables (brute, migrations_lock) don’t have the keys.I added a column as Primary Key, Auto Inc, Not Null as a workaround to each table.
What issues I potentially might face in the future with this workaround when new releases come out?
I’m also wondering if there are any plans to add Primary Key to all tables in nearest future?

OS: Ubuntu, v20.04.1 LTS
Node Version: v12.18.0
Ghost-CLI Version: v1.15.3
Ghost Version: v3.40.5
MySQL Version: v8.0

1 Like