From b51d33cb373e591d16892bde492616655ac9ec51 Mon Sep 17 00:00:00 2001 From: UMTS at Teleco Date: Sat, 13 Dec 2025 02:59:39 +0100 Subject: committing to insanit --- backend/database/dev/export-clean-schema.sh | 32 +++++++++++++++++++++++++++++ 1 file changed, 32 insertions(+) create mode 100755 backend/database/dev/export-clean-schema.sh (limited to 'backend/database/dev/export-clean-schema.sh') 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" -- cgit v1.2.3-70-g09d2