We had an issue installing this on a website using DigitalOcean Managed MySQL due to hosted database running with sql_require_primary_key=ON.
This amends create schema to use PRIMARY KEY instead of UNIQUE KEY
For additional context: sql_require_primary_key=ON is preferred as it helps with node migration/ replications in complex topologies or managed environments (e.g. DO) where it can not be disabled or is not recommended.
We had an issue installing this on a website using DigitalOcean Managed MySQL due to hosted database running with sql_require_primary_key=ON.
This amends create schema to use
PRIMARY KEY
instead ofUNIQUE KEY
For additional context: sql_require_primary_key=ON is preferred as it helps with node migration/ replications in complex topologies or managed environments (e.g. DO) where it can not be disabled or is not recommended.