#!/bin/bash
set -e

# This script creates multiple databases in PostgreSQL
# It's executed by docker-entrypoint-initdb.d on container initialization

psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" <<-EOSQL
    -- Create flight_platform database
    CREATE DATABASE flight_platform;
    GRANT ALL PRIVILEGES ON DATABASE flight_platform TO $POSTGRES_USER;
    
    -- Create keycloak database
    CREATE DATABASE keycloak;
    GRANT ALL PRIVILEGES ON DATABASE keycloak TO $POSTGRES_USER;
EOSQL

echo "Databases created successfully: flight_platform, keycloak"