#!/bin/bash
# Run this script in Terminal to create the deployhub database and tables.
# Usage: ./scripts/setup-database.sh   (from inside the backend folder)
#    or: bash scripts/setup-database.sh

set -e
SCRIPT_DIR="$(cd "$(dirname "${BASH_SOURCE[0]}")" && pwd)"
BACKEND_DIR="$(dirname "$SCRIPT_DIR")"
SQL_FILE="$SCRIPT_DIR/init-db.sql"

echo "Creating database deployhub (if it doesn't exist)..."
psql postgres -c "CREATE DATABASE deployhub;" 2>/dev/null || true

echo "Creating tables in deployhub..."
psql deployhub -f "$SQL_FILE"

echo "Done. Database deployhub is ready."