version: '3.8'

services:
  db:
    image: mariadb:10.6
    container_name: mysql_poubelles
    restart: always
     
    environment:
     MYSQL_ROOT_PASSWORD: root
     MYSQL_DATABASE: smart_trash
     MYSQL_USER: web_user
     MYSQL_PASSWORD: poubelle2026
   
    ports:
      - "3306:3306"

    volumes:
      - ./install.sql:/docker-entrypoint-initdb.d/1_install.sql
      - ./test_data.sql:/docker-entrypoint-initdb.d/2_test_data.sql
      - ./db-data:/var/lib/mysql

networks:
  default:
    name: smart_bins_networks