Solving Failed sql migration when upgrading to 2.11.0+

[juangacovas]

If you changed VARCHAR(36) columns to UUID data type on MySQL or MariaDB, you'll face a failed migration when executing the query at file:
db/mysql/migrations/05_add_visit_id/migration.sql
when doing yarn build.

Solution is executing:
npx prisma migrate resolve --rolled-back "05_add_visit_id"

Then change the file db/mysql/migrations/05_add_visit_id/migration.sql:

1. Invalidate (comment) the line for the first ALTER TABLE (since this got executed at DB), prefixing --
-- ALTER TABLE website_eventADD COLUMNvisit_id VARCHAR(36) NULL;
2. Change the following line (the failed UPDATE is where the migration fails):
   BIN_TO_UUID(RANDOM_BYTES(16) & 0xffffffffffff0fff3fffffffffffffff | 0x00000000000040008000000000000000) uuid
   with this:
   UUID() as uuid

Now you can execute yarn build again and the migration should be applied with success.