docker-compose.yml

networks:
  default:
    name: confidently_incorrect_network
    driver: bridge
    ipam:
      driver: default
      config:
        - subnet: 172.32.99.0/24

services:

  mysql:
    image: "mysql:9.7.1"
    env_file: docker/.env.mysql
    command: [
      "mysqld",
      "--max_allowed_packet=1073741824",
      "--explicit_defaults_for_timestamp=1",
      "--character-set-server=utf8mb4",
      "--collation-server=utf8mb4_unicode_520_ci"
    ]
    ports:
      - "8002:3306"
    volumes:
      # Schema files (single source of truth, also used by skeema) load first, then reference data.
      # Entrypoint runs init files in filename order; Tbl*.sql sort before zz_ so data lands last.
      # schema/ holds ONLY table definitions (skeema requires that); reference data lives in data/.
      - ./schema:/docker-entrypoint-initdb.d
      - ./data/questions.sql:/docker-entrypoint-initdb.d/zz_questions.sql
    tmpfs:
      - /var/lib/mysql