Running MariaDB latest in docker with named constraint - mySQL has default conventions

mariadb.sh.sql

colima start
docker run --detach --name some-mariadb --env MARIADB_ALLOW_EMPTY_ROOT_PASSWORD=1  mariadb:latest
docker exec -it some-mariadb bash
mariadb

CREATE DATABASE test;
USE test;
CREATE TABLE users(
    id    int NOT NULL AUTO_INCREMENT,
    name       varchar(100),
     PRIMARY KEY (`id`)
    );
CREATE TABLE messages(
    id int NOT NULL AUTO_INCREMENT,
    message    varchar(255) ,
     PRIMARY KEY (`id`)
    );
ALTER TABLE messages ADD COLUMN user_id INT(11), 
    ADD CONSTRAINT messages_ibfk_1 FOREIGN KEY messages_ibfk_1(user_id) REFERENCES users(id);

ALTER TABLE messages DROP CONSTRAINT messages_ibfk_1;
ALTER TABLE messages ADD CONSTRAINT messages_ibfk_1 FOREIGN KEY messages_ibfk_1(user_id) REFERENCES users(id)  ON DELETE SET NULL;