Why is my spring boot app not able to create table with _seq name?

Hi there,

On DigitalOcean Managed MySQL, sql_require_primary_key is enabled by default to avoid issues with replication and performance. That’s why your create table reading_day_seq (next_val bigint) fails, it doesn’t have a primary key.

You’ve got two options:

1. You can add a primary key to your sequence table, e.g.:

   create table reading_day_seq (
     id int auto_increment primary key,
     next_val bigint
   ) engine=InnoDB;
   

2. Or you could reconfigure the setting yourself if you really need to disable it. You can do that in the doctl CLI or via API: how to reconfigure Managed MySQL.

Most people would go with option 1, since adding a PK is the safer long-term fix.