BeepZone/backend/database/dev/backup/export-clean-schema.sh

#!/usr/bin/env bash
# Export clean schema (DDL only, no data) from current dev database

set -euo pipefail

# Add mysql-client to PATH (keg-only on macOS)
export PATH="/opt/homebrew/opt/mysql-client/bin:$PATH"

DB_HOST="127.0.0.1"
DB_PORT="3306"
DB_USER="beepzone_user"
DB_PASS="beepzone"
DB_NAME="beepzone"

echo "Exporting clean schema (DDL only, no data)..."
mysqldump \
  --host="$DB_HOST" \
  --port="$DB_PORT" \
  --user="$DB_USER" \
  --password="$DB_PASS" \
  --no-data \
  --skip-comments \
  --skip-dump-date \
  --skip-add-locks \
  --skip-add-drop-table \
  --skip-set-charset \
  --skip-tz-utc \
  --routines \
  --triggers \
  "$DB_NAME" | sed 's/ AUTO_INCREMENT=[0-9]*//g' > beepzone-schema-clean.sql

echo "✓ Exported to: beepzone-schema-clean.sql"