1 files changed, 32 insertions, 0 deletions
diff --git a/backend/database/dev/export-clean-schema.sh b/backend/database/dev/export-clean-schema.sh
new file mode 100755
index 0000000..3548183
--- /dev/null
+++ b/backend/database/dev/export-clean-schema.sh
@@ -0,0 +1,32 @@
+#!/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"