version: "2.1"
services:
  mariadb:
    image: lscr.io/linuxserver/mariadb:latest
    container_name: redmine-mariadb
    environment:
      - PUID=1000
      - PGID=1000
      - MYSQL_ROOT_PASSWORD=examplerootpassword
      - TZ=Asia/Singapore
      - MYSQL_DATABASE=redmine  # can specify character set utf8mb4?
      - MYSQL_USER=redmine
      - MYSQL_PASSWORD=exampleredminepassword
      # - REMOTE_SQL=http://URL1/your.sql,https://URL2/your.sql
    volumes:
      - /var/www/redmine/config:/config
    ports:
      - 3306:3306
    restart: unless-stopped