services:
  db:
    image: mysql:8.0
    container_name: mysql-db
    restart: always
    environment:
      MYSQL_DATABASE: xxx_sphere
      MYSQL_ROOT_PASSWORD: ${DB_ROOT_PASSWORD}
      MYSQL_USER: ${DB_USER}
      MYSQL_PASSWORD: ${DB_PASSWORD}
    ports:
      - "3306:3306"
    volumes:
      # Format: [Pfad auf dem Proxmox-Host]:[Pfad im Container]
      - /mnt/pve_nas/.mysql_data:/var/lib/mysql

  app:
    image: xxx-sphere-web:latest
    container_name: spring-boot-app
    depends_on:
      - db
    ports:
      - "8080:8080"
    environment:
      # Wir biegen localhost auf den Service-Namen 'db' um
      - SPRING_DATASOURCE_URL=jdbc:mysql://db:3306/xxx_sphere?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC
      - DB_USER=${DB_USER}
      - DB_PASSWORD=${DB_PASSWORD}
      - MAIL_USERNAME=${MAIL_USERNAME}
      - MAIL_PASSWORD=${MAIL_PASSWORD}
      - JWT_KEYSTORE_PASSWORD=${JWT_KEYSTORE_PASSWORD}
    # Wartet kurz, bis die DB wirklich bereit ist (optional, aber empfohlen)
    restart: on-failure

volumes:
  mysql_data: