services:
  mssql:
    image: mcr.microsoft.com/mssql/server:2025-RTM-ubuntu-22.04
    container_name: mssql2025

    env_file:
      - .env

    environment:
      ACCEPT_EULA: "Y"
      # IMPORTANT (SQL Server 2025):
      # Use "Developer" or "DeveloperStandard" (NOT "Enterprise Developer")
      MSSQL_PID: "${MSSQL_PID:-Developer}"

    # Workaround for CPU topology/NUMA assert (sosnumap.cpp)
    cpuset: "0-15"
    cpus: "16.0"

    ports:
      - "${MSSQL_PORT:-1433}:1433"

    volumes:
      - ./data:/var/opt/mssql
      - ./backup:/var/opt/mssql/backup
      - ./db/seed:/seed:ro
      - ./db/migrations:/migrations:ro

    healthcheck:
      test: ["CMD-SHELL", "/opt/mssql-tools18/bin/sqlcmd -S localhost -U sa -P \"$$MSSQL_SA_PASSWORD\" -Q \"SELECT 1\" || exit 1"]
      interval: 10s
      timeout: 5s
      retries: 30
      start_period: 25s

    restart: unless-stopped