#!/bin/bash
set -e

echo "=== INITIALIZING TARGET OMOP CDM v5.4 DATABASE ==="

echo "1. Creating target OMOP tables..."
psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" -f /scripts/omop_ddl.sql

echo "2. Creating target OMOP primary keys..."
psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" -f /scripts/omop_pk.sql

echo "=== TARGET OMOP CDM DATABASE INITIALIZATION COMPLETE ==="