SQL Schema for players.conditions don't work on MySQL, only on MariaDB

[macvirii]

Priority

Medium

Area

App

What OS are you seeing the problem on?

Linux

Browser

Chrome

What happened?

Per MySQL documentation (https://dev.mysql.com/doc/refman/8.0/en/blob.html) 'BLOB and TEXT columns cannot have DEFAULT values.

So this line on the schema is invalid.
ALTER TABLE players CHANGE conditions conditions BLOB NOT NULL DEFAULT '';

My solution was using MariaDB, where you can define a default for BLOB types.

For this, probably should drop the requirement about MySQL and specify that it needs to run on MariaDB

Code of Conduct

• I agree to follow this project's Code of Conduct