FROM postgres:18.3-alpine3.23

# Set environment variables for PostgreSQL
ENV POSTGRES_USER=${POSTGRES_USER}
ENV POSTGRES_PASSWORD=${POSTGRES_PASSWORD}
ENV POSTGRES_DB=${POSTGRES_DB}

# Copy the database setup script
COPY db.sql /docker-entrypoint-initdb.d/01_init.sql