#!/usr/bin/env bash
# Script d'application de la migration 007 sur la DB locale Docker
# Usage : bash backend-api/migrations/apply_007_local.sh

set -euo pipefail

MYSQL_HOST="127.0.0.1"
MYSQL_PORT="3316"
MYSQL_USER="root"
MYSQL_PASS='CBAsJg97c=h*nWypYMV8!jbzG6e45XKDiw#dZHlUOqLmv0uf'
MYSQL_DBNAME="faildaily"

mysql -h "$MYSQL_HOST" -P "$MYSQL_PORT" -u "$MYSQL_USER" -p"$MYSQL_PASS" \
  "$MYSQL_DBNAME" < backend-api/migrations/007_child_safety_csae_policy.sql

echo "=== Migration 007 appliquée avec succès ==="