version: "3.8"
services:
  app:
    environment:
      - DB_HOST=${STACK_NAME}_db
      # - DB_HOST=db
      - DB_USER=site
      - DB_PASSWORD_FILE=/run/secrets/db_password
      - DB_NAME=site
    secrets:
      - db_password
    depends_on:
      - db
  db:
    image: "mariadb:10.6"
    volumes:
      - "mariadb:/var/lib/mysql"
    networks:
      - backend
    environment:
      - MYSQL_ROOT_PASSWORD_FILE=/run/secrets/db_root_password
      - MYSQL_DATABASE=site
      - MYSQL_USER=site
      - MYSQL_PASSWORD_FILE=/run/secrets/db_password
    secrets:
      - db_password
      - db_root_password
    deploy:
      labels: ['coop-cloud.${STACK_NAME}.db.version=10.6-718cb856']
volumes:
  mariadb:
secrets:
  db_root_password:
    external: true
    name: ${STACK_NAME}_db_root_password_${SECRET_DB_ROOT_PASSWORD_VERSION}
  db_password:
    external: true
    name: ${STACK_NAME}_db_password_${SECRET_DB_PASSWORD_VERSION}