# Configuration for the Aurora Refresh Script (aurora_refresh.sh)
# Place this file in the same directory as the script.
# Author: Tomi Eckert

# --- Main Settings ---

# The source production schema to be copied.
# Example: "SBO_COMPANY_PROD"
SOURCE_SCHEMA="SBODEMOHU"

# The HANA user that will be granted read/write access to the new Aurora schema.
# This is typically a technical user for the application.
# Example: "B1_..._RW"
AURORA_USER="B1_XXXXXXXXX_RW"

# The secure user store key for the HANA database user with privileges to
# perform EXPORT, IMPORT, DROP SCHEMA, and GRANT commands (e.g., SYSTEM).
# Using a key (hdbuserstore) is more secure than hardcoding a password.
# Example: "CRONKEY"
DB_ADMIN_KEY="CRONKEY"

# --- Paths ---

# The base directory where the temporary schema export folder will be created.
# Ensure the <sid>adm user has write permissions here.
BACKUP_BASE_DIR="/hana/shared/backup/schema"

# The full path to the HANA hdbsql executable.
HDBSQL="/usr/sap/NDB/HDB00/exe/hdbsql"

# The root directory where post-import SQL scripts are located.
SQL_SCRIPTS_ROOT="/usr/sap/NDB/home/tools/sql"

# --- Post-Import Scripts (Optional) ---

# A space-separated list of SQL script filenames to run after the import is complete.
# The script will look for these files inside the SQL_SCRIPTS_ROOT directory.
# Leave empty ("") if no scripts are needed.
# Example: "update_user_emails.sql cleanup_tables.sql"
POST_IMPORT_SQL=""